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 SearchByCircle(double x, double y, double r)
{
ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["markets"].ToString();
rlt = "";
string sql = "select X,Y,M_ID,marketName,Address ,CenterFlag,CenterID from marketsInfos where ((" + x + "-marketsInfos.X)*(" + x + "-marketsInfos.X)+(" + y + "-marketsInfos.Y)*(" + y + "-marketsInfos.Y))<(" + r + "*" + r + ")";
DataSet ds = ExecuteQueryBySql(sql);
string markTmp = ToXml("marketsInfo", ds);
rlt += markTmp + ";";
string proStr = "";
List <DataClasses.prodectsInfo> prodects = new List <DataClasses.prodectsInfo>();
List <DataClasses.FinancialInfo> financials = new List <DataClasses.FinancialInfo>();
for (int i = 0; i < marks.Count; i++)
{
sql = "select M_ID,ProdectID,ProdectName,NumInStocks,SaleNum ,Price,InerPrice,MarketName from prodectsInfo where M_ID =" + marks[i].MarketID;
DataSet ds1 = ExecuteQueryBySql(sql);
DataClasses.prodectsInfo Prodect = new DataClasses.prodectsInfo();
int columns = ds1.Tables[0].Columns.Count;//查询结果的列数
for (int m = 0; m < ds.Tables[0].Rows.Count; m++)
{
try
{
Prodect = new DataClasses.prodectsInfo();
Prodect.MarketID = Convert.ToInt32(ds1.Tables[0].Rows[m][0]);
Prodect.ProdectID = Convert.ToInt32(ds1.Tables[0].Rows[m][1]);
Prodect.ProdectName = ds1.Tables[0].Rows[m][2].ToString();
Prodect.InstocksNum = Convert.ToInt32(ds1.Tables[0].Rows[m][3]);
Prodect.SaleNum = Convert.ToInt32(ds1.Tables[0].Rows[m][4]);
Prodect.Price = Convert.ToDouble(ds1.Tables[0].Rows[m][5]);
Prodect.InerPrice = Convert.ToDouble(ds1.Tables[0].Rows[m][6]);
Prodect.MarketName = ds1.Tables[0].Rows[m][7].ToString();
prodects.Add(Prodect);
}
catch
{
break;
}
}
string Sql = "select M_ID, marketName,Total_amount,Sale_amount,Order_amount,MarketName from Financial_statement where M_ID =" + marks[i].MarketID;
ds1 = ExecuteQueryBySql(Sql);
DataClasses.FinancialInfo finacial = new DataClasses.FinancialInfo();
try
{
finacial.MarketID = Convert.ToInt32(ds1.Tables[0].Rows[0][0]);
finacial.MarketName = ds1.Tables[0].Rows[0][1].ToString();
finacial.totalAmount = Convert.ToDouble(ds1.Tables[0].Rows[0][2]);
finacial.SaleAmount = Convert.ToDouble(ds1.Tables[0].Rows[0][3]);
finacial.InerAmount = Convert.ToDouble(ds1.Tables[0].Rows[0][4]);
finacial.MarketName = ds1.Tables[0].Rows[0][5].ToString();
financials.Add(finacial);
}
catch
{
}
}
if (prodects.Count > 0)
{
proStr = XMLSerialization.Serialize(prodects);
}
else
{
proStr = "无信息";
}
if (financials.Count > 0)
{
proStr += ";" + XMLSerialization.Serialize(financials);
}
else
{
proStr += ";" + "无信息";
}
rlt += proStr;
return(rlt);
}
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);
}
