public NewDataSet GetNewDataSet(string name, string cardNo) { string sql = string.Format("Select * from FC_Da_FWZM Where Name='{0}' and CardNo='{1}'", name, cardNo); DataSet ds = OleDBHelper.GetDataSet(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { IList <Table> tables = new List <Table>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Table t = new Table(); t.ProveResultID = ds.Tables[0].Rows[i]["ProveResultID"].ToString(); t.BusiID = ds.Tables[0].Rows[i]["BusiID"].ToString(); t.CardNo = ds.Tables[0].Rows[i]["CardNo"].ToString(); t.Name = ds.Tables[0].Rows[i]["Name"].ToString(); t.HouseSite = ds.Tables[0].Rows[i]["HouseSite"].ToString(); t.Source = ds.Tables[0].Rows[i]["Source"].ToString(); t.SourceDes = ds.Tables[0].Rows[i]["SourceDes"].ToString(); t.Area = ds.Tables[0].Rows[i]["Area"].ToString(); t.RightNo = ds.Tables[0].Rows[i]["RightNo"].ToString(); tables.Add(t); } NewDataSet set1 = new NewDataSet(); set1.Tables = tables.ToArray(); return(set1); } else { return(null); } }
//public string GetNewData(string Name,string CardNo) { // FC_DA_Data data = new FC_DA_Data(); // NewDataSet set= data.GetNewDataSet(Name, CardNo); // try // { // if (set != null) // { // return SerializerNewDataSet(set); // } // else // { // return "<?xml version=\"1.0\" encoding=\"GB2312\"?><NewDataSet><NOResult>无返回结果</NOResult></NewDataSet> "; // } // } // catch (Exception ex) { // return string.Format("<?xml version=\"1.0\" encoding=\"GB2312\"?>< NewDataSet ><NOResult>{0}</NOResult></NewDataSet> ",ex.Message); // } //} public NewDataSet GetNewData(string Name, string CardNo) { FC_DA_Data data = new FC_DA_Data(); NewDataSet set = data.GetNewDataSet(Name, CardNo); try { if (set != null) { return(set); } else { return(new NewDataSet { NOResult = "无返回结果" }); } } catch (Exception ex) { return(new NewDataSet { NOResult = ex.Message }); } }
private string SerializerNewDataSet(NewDataSet set) { if (set != null) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("<?xml version=\"1.0\" encoding=\"GB2312\"?><NewDataSet>"); if (set.Tables.Length > 0) { for (int i = 0; i < set.Tables.Length; i++) { sb.AppendFormat("<Table>"); sb.AppendFormat("<ProveResultID>"); sb.AppendFormat(set.Tables[i].ProveResultID); sb.AppendFormat("</ProveResultID>"); sb.AppendFormat("<BusiID>"); sb.AppendFormat(set.Tables[i].BusiID); sb.AppendFormat("</BusiID>"); sb.AppendFormat("<CardNo>"); sb.AppendFormat(set.Tables[i].CardNo); sb.AppendFormat("</CardNo>"); sb.AppendFormat("<HouseSite>"); sb.AppendFormat(set.Tables[i].HouseSite); sb.AppendFormat("</HouseSite>"); sb.AppendFormat("<Source>"); sb.AppendFormat(set.Tables[i].Source); sb.AppendFormat("</Source>"); sb.AppendFormat("<SourceDes>"); sb.AppendFormat(set.Tables[i].SourceDes); sb.AppendFormat("</SourceDes>"); sb.AppendFormat("<Area>"); sb.AppendFormat(set.Tables[i].Area); sb.AppendFormat("</Area>"); sb.AppendFormat("<RightNo>"); sb.AppendFormat(set.Tables[i].RightNo); sb.AppendFormat("</RightNo>"); sb.AppendFormat("</Table>"); } } else { sb.AppendFormat("<NOResult>无返回结果</NOResult>"); } sb.AppendFormat("</NewDataSet>"); return(sb.ToString()); } else { return("<?xml version=\"1.0\" encoding=\"GB2312\"?>< NewDataSet ><NOResult>无返回结果</NOResult></NewDataSet> "); } }
public string GetNewData(string Name, string CardNo) { FC_DA_Data data = new FC_DA_Data(); NewDataSet set = data.GetNewDataSet(Name, CardNo); try { if (set != null) { return(SerializerNewDataSet(set)); } else { return("<?xml version=\"1.0\" encoding=\"GB2312\"?><NewDataSet><NOResult>无返回结果</NOResult></NewDataSet> "); } } catch (Exception ex) { return(string.Format("<?xml version=\"1.0\" encoding=\"GB2312\"?>< NewDataSet ><NOResult>{0}</NOResult></NewDataSet> ", ex.Message)); } }