public string addData(string type, string info) { string rlt = ""; string strSql = ""; info = xmlChang(info); ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["markets"].ToString(); switch (type) { case "marketsInfo": { DataClasses.marketsInfo market = new DataClasses.marketsInfo(); market = XMLSerialization.Desrialize(market, info); strSql = "insert into marketsInfos values (" + market.X + "," + market.Y + "," + market.CenterFlag + "," + market.MarketID + ",'" + market.MarketName + "','" + market.Address + "'," + market.CenterID + ")"; break; } case "prodectsInfo": { DataClasses.prodectsInfo prodect = new DataClasses.prodectsInfo(); prodect = XMLSerialization.Desrialize(prodect, info); strSql = "insert into prodectsInfo values ('" + prodect.MarketName + "'," + prodect.MarketID + "," + prodect.ProdectID + "," + prodect.Price + "," + prodect.SaleNum + "," + prodect.InstocksNum + "," + prodect.PreNum + "," + prodect.ReceNum + ",'" + prodect.ProdectName + "'," + prodect.InerPrice + ")"; break; } case "CenterInfo": { DataClasses.CenterSInfo center = new DataClasses.CenterSInfo(); center = XMLSerialization.Desrialize(center, info); strSql = "insert into Centers_ProdectsInfos values ('" + center.MarketName + "'," + center.CenterID + "," + center.prodectID + ",'" + center.prodectName + "'," + center.prodectNum + ")"; break; } case "Financial": { DataClasses.FinancialInfo financial = new DataClasses.FinancialInfo(); financial = XMLSerialization.Desrialize(financial, info); strSql = "insert into Financial_statement values ('" + financial.MarketName + "'," + financial.MarketID + "," + financial.totalAmount + "," + financial.SaleAmount + "," + financial.InerAmount + ")"; } break; } if (!upp(strSql)) { rlt = "添加失败!"; return(rlt); } return("添加成功!"); }
public string ToXml(string DataType, DataSet ds) { string rlt = ""; switch (DataType) { case "marketsInfo": { DataClasses.marketsInfo mark = null; //string result = string.Empty;//查询结果字符串 int columns = ds.Tables[0].Columns.Count; //查询结果的列数 for (int m = 0; m < ds.Tables[0].Rows.Count; m++) { try { //{//X,Y,M_ID,marketName,Address ,CenterFlag mark = new DataClasses.marketsInfo(); mark.X = Convert.ToDouble(ds.Tables[0].Rows[m][0]); mark.Y = Convert.ToDouble(ds.Tables[0].Rows[m][1]); mark.MarketID = Convert.ToInt32(ds.Tables[0].Rows[m][2]); mark.MarketName = ds.Tables[0].Rows[m][3].ToString(); mark.Address = ds.Tables[0].Rows[m][4].ToString(); mark.CenterFlag = Convert.ToInt32(ds.Tables[0].Rows[m][5]); mark.CenterID = Convert.ToInt32(ds.Tables[0].Rows[m][6]); marks.Add(mark); } catch { } } if (marks.Count > 0) { //string s = XMLSerialization.Serialize(mark); rlt = XMLSerialization.Serialize(marks); } else { rlt = "无信息!"; } break; } case "prodectsInfo": { //select M_ID、ProdectID,ProdectName,NumInStocks,SaleNum 、Price、InerPrice DataClasses.prodectsInfo Prodect = new DataClasses.prodectsInfo(); int columns = ds.Tables[0].Columns.Count; //查询结果的列数 for (int m = 0; m < ds.Tables[0].Rows.Count; m++) { try { Prodect = new DataClasses.prodectsInfo(); Prodect.MarketID = Convert.ToInt32(ds.Tables[0].Rows[m][0]); Prodect.ProdectID = Convert.ToInt32(ds.Tables[0].Rows[m][1]); Prodect.ProdectName = ds.Tables[0].Rows[m][2].ToString(); Prodect.InstocksNum = Convert.ToInt32(ds.Tables[0].Rows[m][3]); Prodect.SaleNum = Convert.ToInt32(ds.Tables[0].Rows[m][4]); Prodect.Price = Convert.ToDouble(ds.Tables[0].Rows[m][5]); Prodect.InerPrice = Convert.ToDouble(ds.Tables[0].Rows[m][6]); Prodect.MarketName = ds.Tables[0].Rows[m][7].ToString(); Prodects.Add(Prodect); } catch { } } if (Prodects.Count > 0) { rlt = XMLSerialization.Serialize(Prodects); } else { rlt = "无信息"; } break; } case "CenterInfo": { List <DataClasses.CenterSInfo> Centers = new List <DataClasses.CenterSInfo>(); DataClasses.CenterSInfo Center = new DataClasses.CenterSInfo(); int columns = ds.Tables[0].Columns.Count; //查询结果的列数 for (int m = 0; m < ds.Tables[0].Rows.Count; m++) { try { Center = new DataClasses.CenterSInfo(); Center.MarketName = ds.Tables[0].Rows[m][0].ToString(); Center.CenterID = Convert.ToInt32(ds.Tables[0].Rows[m][1]); Center.prodectID = Convert.ToInt32(ds.Tables[0].Rows[m][2]); Center.prodectName = ds.Tables[0].Rows[m][3].ToString(); Center.prodectNum = Convert.ToInt32(ds.Tables[0].Rows[m][4]); Centers.Add(Center); } catch { } } if (Centers.Count > 0) { rlt = XMLSerialization.Serialize(Centers); } else { rlt = "无信息"; } break; } case "Financial": { // M_ID, marketName,Total_amount,Sale_amount,Order_amount DataClasses.FinancialInfo finacial = new DataClasses.FinancialInfo(); int columns = ds.Tables[0].Columns.Count; //查询结果的列数 for (int m = 0; m < ds.Tables[0].Rows.Count; m++) { try { finacial = new DataClasses.FinancialInfo(); finacial.MarketID = Convert.ToInt32(ds.Tables[0].Rows[m][0]); finacial.MarketName = ds.Tables[0].Rows[m][1].ToString(); finacial.totalAmount = Convert.ToDouble(ds.Tables[0].Rows[m][2]); finacial.SaleAmount = Convert.ToDouble(ds.Tables[0].Rows[m][3]); finacial.InerAmount = Convert.ToDouble(ds.Tables[0].Rows[m][4]); financials.Add(finacial); } catch { } } if (financials.Count > 0) { rlt = XMLSerialization.Serialize(financials); } else { rlt = "无信息"; } break; } case "OrderStatement": { //M_ID, ProdectID,ProdectName,OrderNum, preData List <DataClasses.OrderSatement> tmpList = new List <DataClasses.OrderSatement>(); DataClasses.OrderSatement Order = new DataClasses.OrderSatement(); int columns = ds.Tables[0].Columns.Count; for (int m = 0; m < ds.Tables[0].Rows.Count; m++) { try { Order = new DataClasses.OrderSatement(); Order.MarketID = Convert.ToInt32(ds.Tables[0].Rows[m][0]); Order.ProdectID = Convert.ToInt32(ds.Tables[0].Rows[m][1]); Order.prodectName = ds.Tables[0].Rows[m][2].ToString(); Order.PreNum = Convert.ToInt32(ds.Tables[0].Rows[m][3]); Order.PreTime = Convert.ToDateTime(ds.Tables[0].Rows[m][4]); Order.MarketName = ds.Tables[0].Rows[m][5].ToString(); tmpList.Add(Order); } catch { } } if (tmpList.Count > 0) { rlt = XMLSerialization.Serialize(tmpList); } else { rlt = "无信息"; } break; } } return(rlt); }