public string CreateText(Tem tem, string msg, string tableName, DataXml data) { string head = @"<?xml version=""1.0"" encoding=""gb2312"" ?> <freeforms> {0}</freeforms> "; msg = string.Format(head, msg); XmlDocument model = new XmlDocument(); //存放保存方法 StringBuilder SaveModel = new StringBuilder(); WebForm1 com = new WebForm1(); model.LoadXml(msg); StringReader sRead = new StringReader(msg); DataSet ds = new DataSet(); ds.ReadXml(sRead, XmlReadMode.InferTypedSchema); StringBuilder sb = new StringBuilder(); DataTable row = ds.Tables["row"]; DataTable col = ds.Tables["col"]; DataTable lab = ds.Tables["label"]; DataTable edit = ds.Tables["editor"]; for (int i = 0; i < row.Rows.Count; i++) { sb.Append("<tr>"); DataRow[] colView = col.AsDataView().Table.Select("row_ID= '" + i + "'"); var rowValue = ""; for (int k = 0; k < colView.Length; k++) { int num = (int)colView[k]["col_ID"]; if (num % 2 == 0) { rowValue = lab.Select("col_ID = " + num + "")[0]["dbname"] as string; sb.AppendFormat(@"<td class=""label-bg"" style=""width: 100px; "">{0}</td>", com.GetChina(rowValue, tableName, data)); } else { rowValue = edit.Select("col_ID = " + num + "")[0]["dbname"] as string; sb.AppendFormat(@"<td> <input type=""text"" size=""10"" id=""{0}"" name=""{0}"" value=""<%=model.{0}%>""/> </td>", rowValue); } sb.Append(Environment.NewLine); SaveModel.AppendFormat(" head.{0} = Post(\"{0}\");", rowValue); SaveModel.AppendLine(); } sb.Append("</tr>"); sb.Append(Environment.NewLine); } return(sb.ToString() + tem.NewLine + SaveModel.ToString()); }
private void viewdata(DataXml data, RichTextBox richTextBox) { richTextBox.Clear(); foreach (var item in data) { richTextBox.AppendText(item); } }
public string GetChina(string col, string table, DataXml data) { var china = data.MessageXml.Where(x => x.TableName == table && x.ColumnName == col).FirstOrDefault(); if (china == null) { return(col); } return(china.value); }
public DataXml SaveInXmlFormat(Data data) { DataXml dataXml = new DataXml(); foreach (var item in data) { var serializer = new ConfigurationContainer().Create(); var xml = serializer.Serialize(item); } return(dataXml); }
static void Main(string[] args) { //Xml Declaration DataXml dataXml = new DataXml(); XmlSerializer DataSerializer = new XmlSerializer(typeof(DataXml)); //Management Class declaration Employer_Manager _Employer = new Employer_Manager(); Company_Manager _Company = new Company_Manager(); //Creating data //Company samsung = new Company("Samsung", "Electronic fabrication", "korea", new DateTime(1938, 3, 1)); //Employer employer1 = new Employer("Daniel kochima", 45, samsung.Name); //Employer employer2 = new Employer("Park jie hum", 32, null); //Employer employer3 = new Employer("Jamal idrissi", 19, null); //samsung.AddEmployer(employer1); //_Employer.Add(employer1); //_Employer.Add(employer2); //_Employer.Add(employer3); //_Company.AddCompany(samsung); //save //dataXml.Save(DataSerializer, new StreamWriter("Data.xml"), _Company, _Employer); //load dataXml.Load(DataSerializer, new StreamReader("Data.xml"), ref _Company, ref _Employer); bool Program = true; string Input = ""; while (Program) { Console.WriteLine("________COMPANIES AND EMPLOYERS________"); Console.WriteLine("1/Employers erea\t2/Companies erea"); Console.Write("Your Choice : "); Input = Console.ReadLine(); if (Input == "1") { EmployerErea(_Employer); } else if (Input == "2") { EspaceEntreprise(_Company, _Employer); } else { Console.WriteLine("=> The command cannot be found !!"); } Console.WriteLine("________COMPANIES AND EMPLOYERS________"); Program = Leave(); } dataXml.Save(DataSerializer, new StreamWriter("Data.xml"), _Company, _Employer); } //done
/// <summary> /// 批量发送短信 /// </summary> /// <param name="phone"></param> /// <param name="body"></param> /// <returns></returns> public static SMSReceiveModel SendBatchSMS(string phone, string body) { string postReturn = string.Empty; try { string strReturnXML = PostWebRequest(url, sendBatchMessage(phone, body)); postReturn = DataXml.GetResultCode(strReturnXML); } catch (Exception e) { throw e; } return(GetPostReturn(postReturn)); }
public string CreateText(Tem tem, string msg, string tableName, DataXml data) { string text = Environment.NewLine; WebForm1 com = new WebForm1(); var modelList = data.TableXml.Where(x => x.TableName == tableName); StringBuilder GetModel = new StringBuilder(); string DDL = " yield return new NameValue() {{ Name = \"{0}\", Value = cod.GetDDLTextByValue(\"{1}\", entity.{0}) }};"; string noDDL = " yield return new NameValue() {{ Name = \"{0}\", Value = entity.{0}.ToString() }};"; string[] model = msg.Split('|'); for (int i = 0; i < model.Length; i++) { if (string.IsNullOrEmpty(tableName)) { text += string.Format(tem.ColText, com.GetSizeStatus(model[i], data.size), com.GetSizeStatus(model[i], data.size)); } else { text += string.Format(tem.ColText, model[i], com.GetChina(model[i], tableName, data)); var currData = modelList.Where(x => x.ColumnName == model[i]).FirstOrDefault(); if (string.IsNullOrEmpty(currData.DDL)) { GetModel.AppendFormat(noDDL, model[i]); } else { GetModel.AppendFormat(DDL, model[i], currData.DDL); } GetModel.Append(tem.NewLine); } if (i < model.Length - 1) { text += ","; } text += tem.NewLine; } var ColText = string.Format(tem.COLS, text); return(ColText + tem.NewLine + GetModel.ToString()); }
public string CreateText(Tem tem, string msg, string tableName, DataXml data) { StringBuilder GetModel = new StringBuilder(); string DDL = " yield return new NameValue() {{ Name = \"{0}\", Value = cod.GetDDLTextByValue(\"{1}\", entity.{0}) }};"; string noDDL = " yield return new NameValue() {{ Name = \"{0}\", Value = entity.{0}.ToString() }};"; var models = data.TableXml.Where(x => x.TableName == tableName); foreach (var i in models) { if (string.IsNullOrEmpty(i.DDL)) { GetModel.AppendFormat(noDDL, i.ColumnName); } else { GetModel.AppendFormat(DDL, i.ColumnName, i.DDL); } GetModel.AppendLine(); } return(GetModel.ToString()); }
public string CreateText(Tem tem, string msg, string tableName, DataXml data) { return(""); // string tem = @"<?xml version=""1.0"" encoding=""gb2312"" ?> <freeforms> {0}</freeforms> "; // msg = string.Format(tem, msg); // XmlDocument model = new XmlDocument(); // model.LoadXml(msg); // StringReader sRead = new StringReader(msg); // DataSet ds = new DataSet(); // ds.ReadXml(sRead, XmlReadMode.InferTypedSchema); // StringBuilder sb = new StringBuilder(); // DataTable row = ds.Tables["row"]; // DataTable col = ds.Tables["col"]; // DataTable lab = ds.Tables["label"]; // DataTable edit = ds.Tables["editor"]; // for (int i = 0; i < row.Rows.Count; i++) // { // sb.Append("<tr>"); // DataRow[] colView = col.AsDataView().Table.Select("row_ID= '" + i + "'"); // var rowValue = ""; // for (int k = 0; k < colView.Length; k++) // { // int num = (int)colView[k]["col_ID"]; // //10 - 10 // //if (num % 2 == 0) // //{ // // rowValue = lab.Select("col_ID = " + num + "")[0]["dbname"] as string; // // sb.AppendFormat(@"<td class=""label-bg"" style=""width: 100px; "">{0}</td>", rowValue); // //} // //else // //{ // // rowValue = edit.Select("col_ID = " + num + "")[0]["dbname"] as string; // // sb.AppendFormat(@"<td> <input type=""text"" size=""10"" id=""{0}"" name=""{0}"" value=""<%=head.{0}%>""/> </td>", rowValue); // //} // //10 - > 2015 // if (num % 2 == 0) // { // rowValue = lab.Select("col_ID = " + num + "")[0]["dbname"] as string; // sb.AppendFormat(@"<td style='width: 100px;' class='label-bg'> @Html.LabelFor( x => x.{0}) </td>", rowValue); // } // else // { // var temModel = edit.Select("col_ID = " + num + "")[0]; // rowValue = temModel["dbname"] as string; // if (temModel["controltype"].ToString() == "UltraTextEditor") // { // sb.AppendFormat(@"<td> <input type='text' id='{0}' name ='{0}' class='easyui-validatebox tb' data-options='required: true' value = '@Model.{0}' /> </td>", rowValue); // } // else // { // sb.AppendFormat(@" <td> <select id=""{0}"" name=""{0}"" class=""easyui-combobox"" style =""width: 200px; height: 27px; "" // title = ""@Html.DisplayNameFor(model => model.{0})"" panelwidth = ""300"" data-options = ""required:true"" // panelheight = '200' > // <option id = """" value = """" ></option > // @Html.Raw({0}) // </select> </td>", rowValue); // } // } // sb.Append(Environment.NewLine); // } // sb.Append("</tr>"); // sb.Append(Environment.NewLine); // } // return sb.ToString(); //} }