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));
}
}