public void add(WebHelper w, Dictionary <string, object> kv)
{
Model.pm_t_flow_main ord = w.GetObject <Model.pm_t_flow_main>();
ord.price_type = "1";
ord.approve_flag = "0";
ord.approve_man = "";
ord.approve_date = System.DateTime.MinValue;
List <Model.pm_t_price_flow_detial> lines = w.GetList <Model.pm_t_price_flow_detial>("lines");
foreach (Model.pm_t_price_flow_detial line in lines)
{
line.sheet_no = ord.sheet_no;
line.price_type = ord.price_type;
line.start_date = ord.start_date;
line.start_time = ord.start_time;
line.end_time = ord.end_time;
}
string sheet_no = "";
bll.Add(ord, lines, out sheet_no);
w.Write("sheet_no", sheet_no);
}
void IBLL.ICusPriceOrder.Change(Model.pm_t_flow_main ord, List <Model.pm_t_price_flow_detial> lines)
{
string sql = "select * from pm_t_flow_main where sheet_no='" + ord.sheet_no + "'";
var db = new DB.DBByHandClose(Appsetting.conn);
DB.IDB d = db;
try
{
db.Open();
db.BeginTran();
//
var tb = d.ExecuteToTable(sql, null);
if (tb.Rows.Count == 0)
{
throw new Exception("单据不存在" + ord.sheet_no);
}
else
{
var row = tb.Rows[0];
if (row["approve_flag"].ToString() == "1")
{
throw new Exception("单据已审核" + ord.sheet_no);
}
}
sql = "delete from pm_t_price_flow_detial where sheet_no='" + ord.sheet_no + "'";
d.ExecuteScalar(sql, null);
sql = "delete from pm_t_flow_main where sheet_no='" + ord.sheet_no + "'";
d.ExecuteScalar(sql, null);
//
d.Insert(ord);
foreach (Model.pm_t_price_flow_detial line in lines)
{
d.Insert(line);
}
//
db.CommitTran();
}
catch (Exception ex)
{
db.RollBackTran();
throw;
}
finally
{
db.Close();
}
}
void IBLL.ICusPriceOrder.Add(Model.pm_t_flow_main ord, List <Model.pm_t_price_flow_detial> lines, out string sheet_no)
{
IBLL.ICusPriceOrder ins = this;
ord.sheet_no = ins.MaxCode();
//
string sql = "select * from pm_t_flow_main where sheet_no='" + ord.sheet_no + "'";
var db = new DB.DBByHandClose(Appsetting.conn);
DB.IDB d = db;
try
{
db.Open();
db.BeginTran();
//
var tb = d.ExecuteToTable(sql, null);
if (tb.Rows.Count != 0)
{
throw new Exception("已存在单号" + ord.sheet_no);
}
d.Insert(ord);
foreach (Model.pm_t_price_flow_detial line in lines)
{
line.sheet_no = ord.sheet_no;
d.Insert(line);
}
//
db.CommitTran();
}
catch (Exception ex)
{
db.RollBackTran();
throw;
}
finally
{
db.Close();
}
//
sheet_no = ord.sheet_no;
}
void IServiceBase.Request(string t, string pars, out string res)
{
try
{
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars);
var kv = r.ToDictionary();
IBLL.ICusPriceOrder bll = new BLL.CusPriceOrder();
if (t == "get_list")
{
DateTime date1 = Helper.Conv.ToDateTime(r.Read("date1"));
DateTime date2 = Helper.Conv.ToDateTime(r.Read("date2"));
var tb = bll.GetList(date1, date2);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("data", tb);
res = w.ToString();
}
else if (t == "get_order")
{
string sheet_no = r.Read("sheet_no");
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetOrder(sheet_no, out tb1, out tb2);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("tb1", tb1);
w.Append("tb2", tb2);
res = w.ToString();
}
else if (t == "max_code")
{
string code = bll.MaxCode();
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("code", code);
res = w.ToString();
}
else if (t == "add")
{
Model.pm_t_flow_main ord = new Model.pm_t_flow_main();
ord.sheet_no = r.Read("sheet_no");
ord.branch_no = r.Read("branch_no");
ord.vip_type = r.Read("vip_type");
ord.price_type = "1";
ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date"));
ord.oper_id = r.Read("oper_id");
ord.approve_flag = "0";
ord.memo = r.Read("memo");
ord.other1 = r.Read("other1");
ord.other2 = r.Read("other2");
ord.other3 = r.Read("other3");
ord.cm_branch = r.Read("cm_branch");
ord.start_date = Helper.Conv.ToDateTime(r.Read("start_date"));
ord.end_date = Helper.Conv.ToDateTime(r.Read("end_date"));
ord.start_time = r.Read("start_time");
ord.end_time = r.Read("end_time");
ord.buy_amt = Helper.Conv.ToDecimal(r.Read("buy_amt"));
ord.add_amt = Helper.Conv.ToDecimal(r.Read("add_amt"));
ord.deal_man = r.Read("deal_man");
ord.approve_man = "";
ord.approve_date = System.DateTime.MinValue;
ord.num1 = Helper.Conv.ToDecimal(r.Read("num1"));
ord.num2 = Helper.Conv.ToDecimal(r.Read("num2"));
ord.num3 = Helper.Conv.ToDecimal(r.Read("num3"));
List <Model.pm_t_price_flow_detial> lines = new List <Model.pm_t_price_flow_detial>();
foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines"))
{
Model.pm_t_price_flow_detial line = new Model.pm_t_price_flow_detial();
lines.Add(line);
line.sheet_no = ord.sheet_no;
line.item_no = r2.Read("item_no");
line.price_type = ord.price_type;
line.start_date = ord.start_date;
line.old_price = Helper.Conv.ToDecimal(r2.Read("old_price"));
line.new_price = Helper.Conv.ToDecimal(r2.Read("new_price"));
line.discount = Helper.Conv.ToDecimal(r2.Read("discount"));
line.buy_qnty = Helper.Conv.ToDecimal(r2.Read("buy_qnty"));
line.other1 = r2.Read("other1");
line.other2 = r2.Read("other2");
line.other3 = r2.Read("other3");
line.start_time = ord.start_time;
line.end_time = ord.end_time;
line.stock_qty = Helper.Conv.ToDecimal(r2.Read("stock_qty"));
line.num1 = Helper.Conv.ToDecimal(r2.Read("num1"));
line.num2 = Helper.Conv.ToDecimal(r2.Read("num2"));
line.num3 = Helper.Conv.ToDecimal(r2.Read("num3"));
line.old_price2 = Helper.Conv.ToDecimal(r2.Read("old_price2"));
line.old_price3 = Helper.Conv.ToDecimal(r2.Read("old_price3"));
line.new_price2 = Helper.Conv.ToDecimal(r2.Read("new_price2"));
line.new_price3 = Helper.Conv.ToDecimal(r2.Read("new_price3"));
}
string sheet_no = "";
bll.Add(ord, lines, out sheet_no);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("sheet_no", sheet_no);
res = w.ToString();
}
else if (t == "change")
{
Model.pm_t_flow_main ord = new Model.pm_t_flow_main();
ord.sheet_no = r.Read("sheet_no");
ord.branch_no = r.Read("branch_no");
ord.vip_type = r.Read("vip_type");
ord.price_type = "1";
ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date"));
ord.oper_id = r.Read("oper_id");
ord.approve_flag = "0";
ord.memo = r.Read("memo");
ord.other1 = r.Read("other1");
ord.other2 = r.Read("other2");
ord.other3 = r.Read("other3");
ord.cm_branch = r.Read("cm_branch");
ord.start_date = Helper.Conv.ToDateTime(r.Read("start_date"));
ord.end_date = Helper.Conv.ToDateTime(r.Read("end_date"));
ord.start_time = r.Read("start_time");
ord.end_time = r.Read("end_time");
ord.buy_amt = Helper.Conv.ToDecimal(r.Read("buy_amt"));
ord.add_amt = Helper.Conv.ToDecimal(r.Read("add_amt"));
ord.deal_man = r.Read("deal_man");
ord.approve_man = "";
ord.approve_date = System.DateTime.MinValue;
ord.num1 = Helper.Conv.ToDecimal(r.Read("num1"));
ord.num2 = Helper.Conv.ToDecimal(r.Read("num2"));
ord.num3 = Helper.Conv.ToDecimal(r.Read("num3"));
List <Model.pm_t_price_flow_detial> lines = new List <Model.pm_t_price_flow_detial>();
foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines"))
{
Model.pm_t_price_flow_detial line = new Model.pm_t_price_flow_detial();
lines.Add(line);
line.sheet_no = ord.sheet_no;
line.item_no = r2.Read("item_no");
line.price_type = ord.price_type;
line.start_date = ord.start_date;
line.old_price = Helper.Conv.ToDecimal(r2.Read("old_price"));
line.new_price = Helper.Conv.ToDecimal(r2.Read("new_price"));
line.discount = Helper.Conv.ToDecimal(r2.Read("discount"));
line.buy_qnty = Helper.Conv.ToDecimal(r2.Read("buy_qnty"));
line.other1 = r2.Read("other1");
line.other2 = r2.Read("other2");
line.other3 = r2.Read("other3");
line.start_time = ord.start_time;
line.end_time = ord.end_time;
line.stock_qty = Helper.Conv.ToDecimal(r2.Read("stock_qty"));
line.num1 = Helper.Conv.ToDecimal(r2.Read("num1"));
line.num2 = Helper.Conv.ToDecimal(r2.Read("num2"));
line.num3 = Helper.Conv.ToDecimal(r2.Read("num3"));
line.old_price2 = Helper.Conv.ToDecimal(r2.Read("old_price2"));
line.old_price3 = Helper.Conv.ToDecimal(r2.Read("old_price3"));
line.new_price2 = Helper.Conv.ToDecimal(r2.Read("new_price2"));
line.new_price3 = Helper.Conv.ToDecimal(r2.Read("new_price3"));
}
bll.Change(ord, lines);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "delete")
{
string sheet_no = r.Read("sheet_no");
bll.Delete(sheet_no);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "check")
{
string sheet_no = r.Read("sheet_no");
string approve_man = r.Read("approve_man");
bll.Check(sheet_no, approve_man);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else
{
throw new Exception("未找到方法" + t);
}
}
catch (Exception ex)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "-1");
w.Append("errMsg", ex.Message);
LogHelper.writeLog("", ex.ToString());
res = w.ToString();
}
}
