| private DataSet dataSource |
| { |
| get { return (DataSet)ViewState["dataSource"]; } |
| set { ViewState["dataSource"] = value; } |
| } |
| public void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) |
| { |
| RadGrid1.DataSource = dataSource; |
| } |
| protected void AddColumnsToRadGrid(string columnName, string columnText, Type dataType, bool display) |
| { |
| int test = 0; |
| |
| GridBoundColumn newnewBoundColumn = new GridBoundColumn(); |
| newBoundColumn.DataType = dataType; |
| newBoundColumn.DataField = columnName; |
| newBoundColumn.HeaderText = columnText; |
| newBoundColumn.Display = display; |
| |
| if (_RadGrid1Columns == null) |
| { |
| _RadGrid1Columns = RadGrid1.Columns; |
| test = 1; |
| } |
| |
| _RadGrid1Columns.Add(newBoundColumn); |
| |
| if (test != 1) |
| { |
| RadGrid1.Columns.Clear(); |
| |
| foreach (GridColumn gc in _RadGrid1Columns) |
| RadGrid1.Columns.Add(gc); |
| } |
| } |
| protected void AddColumnsToDataTable(DataTable table, List<JobAttributeValue> _javc) |
| { |
| System.Text.StringBuilder sb = new System.Text.StringBuilder(); |
| sb.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?>"); |
| sb.AppendLine("<ArrayOfJobTicket xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">"); |
| |
| int jrn = 0; |
| bool parseSuccess = false; |
| List<JobAttributeValue> matches = null; |
| |
| foreach (DataRow row in table.Rows) |
| { |
| sb.AppendLine("<JobTicket>"); |
| |
| foreach (DataColumn column in table.Columns) |
| { |
| sb.AppendLine(string.Format("<{0}>{1}</{2}>", column.ColumnName, row[column.ColumnName].ToString(), column.ColumnName)); |
| if (column.ColumnName == "JobRecordNumber") |
| { |
| parseSuccess = int.TryParse(row[column.ColumnName].ToString(), out jrn); |
| |
| } |
| } |
| if (parseSuccess) |
| { |
| matches = _javc.FindAll(delegate(JobAttributeValue jav) { return jav.JobRecordNumber == jrn; }); |
| if (matches != null) |
| { |
| if(matches.Count == 1) |
| { |
| foreach (JobAttributeValue Attribute in matches) |
| sb.AppendLine(string.Format("<{0}>{1}</{2}>", Attribute.AttributeName, Attribute.AttributeValue,Attribute.AttributeName)); |
| } |
| else |
| if(matches.Count > 1) |
| { |
| matches.Sort(delegate(JobAttributeValue obj1, JobAttributeValue obj2) {return obj1.AttributeValue.CompareTo(obj2.AttributeValue);} ); |
| foreach (JobAttributeValue Attribute in matches) |
| { |
| if (matches.IndexOf(Attribute) == 0) |
| sb.AppendLine(string.Format("<{0}>{1}, ", Attribute.AttributeName, Attribute.AttributeValue)); |
| else |
| if (matches.IndexOf(Attribute) == matches.Count - 1) |
| sb.Append(string.Format("{0}</{1}>", Attribute.AttributeValue, Attribute.AttributeName)); |
| else |
| sb.Append(string.Format("{0}, ", Attribute.AttributeValue)); |
| } |
| } |
| } |
| } |
| else |
| { |
| sb.AppendLine(string.Format("<{0}></{1}>", _javc[1].AttributeName, _javc[1].AttributeName)); |
| } |
| |
| sb.AppendLine("</JobTicket>"); |
| |
| } |
| sb.AppendLine("</ArrayOfJobTicket>"); |
| //System.IO.File.WriteAllText("C:\\datasetoutfromSB.xml", sb.ToString()); |
| |
| TextReader tr = new StringReader(sb.ToString()); |
| dataSource.Tables.Clear(); |
| dataSource.ReadXml(tr, XmlReadMode.Auto); |
| |
| AddColumnsToRadGrid(_javc[0].AttributeName, _javc[0].AttributeName, _javc[0].AttributeValue.GetType(), true); |
| } |
| protected void treeFolders_NodeClick1(object sender, RadTreeNodeEventArgs e) |
| { |
| //folderName = e.Node.Text; |
| |
| //RadGrid1.CurrentPageIndex = 0; |
| //RadGrid1.Rebind(); |
| |
| //labelFrom.Text = String.Empty; |
| //labelDate.Text = String.Empty; |
| //labelSubject.Text = String.Empty; |
| //labelMessage.Text = String.Empty; |
| |
| _currentSelectedNode = e.Node; |
| |
| if (e.Node.Value != "") |
| { |
| string xmlValue = string.Empty; |
| if (e.Node != null) |
| xmlValue = e.Node.Value.ToString(); |
| |
| if (xmlValue.Length > 0) |
| { |
| JobTicketCollection JobTicketCollection = new JobTicketCollection(); |
| JobTicketCollection = JobTicketService.getJobsByFilter(xmlValue); |
| if (JobTicketCollection != null) |
| { |
| if (JobTicketCollection.Count > 0) |
| { |
| Stream _stream = SerializationServices<JobTicketCollection>.SerializeToStream(JobTicketCollection); |
| |
| DataSet _dataSet = new DataSet(); |
| _dataSet.ReadXml(_stream, XmlReadMode.Auto); |
| |
| dataSource = _dataSet; |
| |
| // Add default columns to RadGrid |
| AddColumnsToRadGrid("JobRecordNumber", "Job Record Number", typeof(Int32), true); |
| } |
| } |
| } |
| else |
| { |
| DataSet _dataSet = new DataSet(); |
| dataSource = _dataSet; |
| } |
| |
| RadGrid1.Rebind(); |
| } |
| } |
| protected void btnStock_Click(object sender, EventArgs e) |
| { |
| List<int> jobRecNums = new List<int>(); |
| foreach (DataRow dataRow in dataSource.Tables[0].Rows) |
| jobRecNums.Add(Convert.ToInt32(dataRow["JobRecordNumber"])); |
| |
| List<JobAttributeValue> jobAttributeValueCollection = new List<JobAttributeValue>(); |
| jobAttributeValueCollection = JobTicketService.getNewAttribute(jobRecNums, "ImprintLine_color"); |
| |
| AddColumnsToDataTable(dataSource.Tables[0], jobAttributeValueCollection); |
| |
| RadGrid1.Rebind(); |
| } |
| |