private DataReportConsumeGoods BuildSalesGoodsInfo(DataRow dr)
{
DataReportConsumeGoods goods = new DataReportConsumeGoods();
goods.ID = (string)dr["order_id"];
if (!string.IsNullOrEmpty(dr["code"].ToString()))
{
goods.GoodsID = (string)dr["code"];
}
if (!string.IsNullOrEmpty(dr["name"].ToString()))
{
goods.GoodsName = (string)dr["name"];
}
if (!string.IsNullOrEmpty(dr["ean"].ToString()))
{
goods.Ean = (string)dr["ean"];
}
if (!string.IsNullOrEmpty(dr["num"].ToString()))
{
goods.Num = Convert.ToInt32(dr["num"].ToString());
}
if (!string.IsNullOrEmpty(dr["total_amount"].ToString()))
{
goods.Amount = Convert.ToDecimal(dr["total_amount"].ToString());
}
if (!string.IsNullOrEmpty(dr["operator_id"].ToString()))
{
UserDAL dal = new UserDAL();
goods.Opter = dal.QueryByOptrID((int)dr["operator_id"]).name;
}
if (!string.IsNullOrEmpty(dr["units"].ToString()))
{
goods.Units = dr["units"].ToString();
}
if (!string.IsNullOrEmpty(dr["dt"].ToString()))
{
goods.Date = ((DateTime)dr["dt"]).ToString();
}
int pay_mode = 0;
if (!string.IsNullOrEmpty(dr["pay_mode"].ToString()))
{
pay_mode = Convert.ToInt32(dr["pay_mode"].ToString());
}
goods.PayType = PayMode.getStringbyMode(pay_mode);
return(goods);
}
private DataReportConsumeGoods BuildReturnGoodsInfo(DataRow dr)
{
DataReportConsumeGoods goods = new DataReportConsumeGoods();
goods.ID = (string)dr["return_id"];
goods.PayType = "现金";
if (!string.IsNullOrEmpty(dr["code"].ToString()))
{
goods.GoodsID = (string)dr["code"];
}
if (!string.IsNullOrEmpty(dr["name"].ToString()))
{
goods.GoodsName = (string)dr["name"];
}
if (!string.IsNullOrEmpty(dr["num"].ToString()))
{
goods.Num = -Convert.ToInt32(dr["num"].ToString());
}
if (!string.IsNullOrEmpty(dr["return_value"].ToString()))
{
goods.Amount = -Convert.ToDecimal(dr["return_value"].ToString());
}
if (!string.IsNullOrEmpty(dr["operator_id"].ToString()))
{
UserDAL dal = new UserDAL();
goods.Opter = dal.QueryByOptrID((int)dr["operator_id"]).name;
}
if (!string.IsNullOrEmpty(dr["units"].ToString()))
{
goods.Units = dr["units"].ToString();
}
if (!string.IsNullOrEmpty(dr["dt"].ToString()))
{
goods.Date = ((DateTime)dr["dt"]).ToString();
}
if (!string.IsNullOrEmpty(dr["return_mode"].ToString()))
{
int mode = (int)dr["return_mode"];
if (mode == (int)PAYMODEFORNEW.PAYMODEFORNEW_BANK)
{
goods.PayType = "银行卡";
}
else if (mode == (int)PAYMODEFORNEW.PAYMODEFORNEW_REDCODE)
{
goods.PayType = "红码";
}
}
return(goods);
}
public List <DataReportConsumeGoods> QueryConsumeGoods(string begin, string end, string content)
{
List <DataReportConsumeGoods> ret = new List <DataReportConsumeGoods>();
UserDAL dal = new UserDAL();
DataSet ds = new DataSet();
if (content != null && content != "")
{
ds = ExecuteDataSet(@"select sales.dt, sales_goods.goods_id, sales_goods.num, goods.name, goods.ean,sales_goods.total_amount, sales_goods.uuid,
sales.operator_id ,pay_mode,goods.code, goods.units , sales.order_id
from sales_goods left join sales on sales_goods.order_id = sales.order_id
left join goods on sales_goods.goods_id = goods.goods_id where (sales.dt BETWEEN @start_time and @end_time) and sales.operator_id=@optr order by sales.dt desc",
new MySqlParameter("@start_time", begin),
new MySqlParameter("@end_time", end),
new MySqlParameter("@optr", dal.QueryByUserName(content).OptrID));
}
else
{
ds = ExecuteDataSet(@"select sales.dt, sales_goods.goods_id, sales_goods.num, goods.name, goods.ean,sales_goods.total_amount, sales_goods.uuid,
sales.operator_id ,pay_mode,goods.code, goods.units , sales.order_id
from sales_goods left join sales on sales_goods.order_id = sales.order_id
left join goods on sales_goods.goods_id = goods.goods_id where sales.dt BETWEEN @start_time and @end_time order by sales.dt desc",
new MySqlParameter("@start_time", begin),
new MySqlParameter("@end_time", end));
}
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
DataReportConsumeGoods goods = BuildSalesGoodsInfo(dr);
if (goods != null && goods.GoodsID != "" && goods.GoodsID != null)
{
ret.Add(goods);
}
}
}
if (content != null && content != "")
{
ds = ExecuteDataSet(@"select sales_return.dt, sales_return.return_mode, goods_return.goods_id, goods_return.num, goods.name, goods.ean,goods_return.return_value, goods_return.uuid,
sales_return.operator_id ,goods.code, goods.units , goods_return.return_id
from goods_return left join sales_return on goods_return.return_id = sales_return.uuid
left join goods on goods_return.goods_id = goods.goods_id where (sales_return.dt BETWEEN @start_time and @end_time) and sales_return.operator_id=@optr order by sales_return.dt desc",
new MySqlParameter("@start_time", begin),
new MySqlParameter("@end_time", end),
new MySqlParameter("@optr", dal.QueryByUserName(content).OptrID));
}
else
{
ds = ExecuteDataSet(@"select sales_return.dt, sales_return.return_mode, goods_return.goods_id, goods_return.num, goods.name, goods.ean,goods_return.return_value, goods_return.uuid,
sales_return.operator_id,goods.code, goods.units , goods_return.return_id
from goods_return left join sales_return on goods_return.return_id = sales_return.uuid
left join goods on goods_return.goods_id = goods.goods_id where (sales_return.dt BETWEEN @start_time and @end_time) order by sales_return.dt desc",
new MySqlParameter("@start_time", begin),
new MySqlParameter("@end_time", end));
}
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
DataReportConsumeGoods goods = BuildReturnGoodsInfo(dr);
if (goods != null && goods.GoodsID != "" && goods.GoodsID != null)
{
ret.Add(goods);
}
}
}
return(ret);
}
