public void Compute(DB.IDB db, string sheet_property, string db_no, string branch_no, string item_no, decimal sheet_qty, decimal sheet_price, out decimal price, out decimal end_price, out decimal adjust_amt) { string sql = "select * from bi_t_item_info where item_no='" + item_no + "'"; Model.bi_t_item_info item = db.ExecuteToModel <Model.bi_t_item_info>(sql, null); if (item == null) { throw new Exception("不存在商品内码" + item.item_no); } sql = "select * from ic_t_branch_stock where branch_no='" + branch_no + "'" + " and item_no='" + item_no + "'"; Model.ic_t_branch_stock stock = db.ExecuteToModel <Model.ic_t_branch_stock>(sql, null); if (stock == null) { stock = new Model.ic_t_branch_stock(); stock.branch_no = branch_no; stock.item_no = item_no; stock.stock_qty = 0; stock.cost_price = item.price; stock.display_flag = "1"; stock.last_price = 0; stock.fifo_price = 0; stock.update_time = System.DateTime.Now; db.Insert(stock); } if (sheet_property == "1") { //入库类 if (db_no.Equals("-")) { InPrice(stock.stock_qty, stock.cost_price, -sheet_qty, sheet_price, out price, out end_price, out adjust_amt); } else { InPrice(stock.stock_qty, stock.cost_price, sheet_qty, sheet_price, out price, out end_price, out adjust_amt); } } else { //出库类 if (db_no.Equals("-")) { OutPrice(stock.stock_qty, stock.cost_price, sheet_qty, sheet_price, out price, out end_price, out adjust_amt); } else { OutPrice(stock.stock_qty, stock.cost_price, -sheet_qty, sheet_price, out price, out end_price, out adjust_amt); } } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IItem bll = new BLL.Item(); if (t == "get_list") { string item_clsno = r.Read("item_clsno"); string keyword = r.Read("keyword"); int show_stop = Helper.Conv.ToInt32(r.Read("show_stop")); int page_index = Helper.Conv.ToInt32(r.Read("page_index")); int page_size = Helper.Conv.ToInt32(r.Read("page_size")); int total_count = 0; var tb = bll.GetList(item_clsno, keyword, show_stop, page_index, page_size, out total_count); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); w.Append("total_count", total_count.ToString()); res = w.ToString(); } else if (t == "get_item") { string item_no = r.Read("item_no"); var tb = bll.GetItem(item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); 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.bi_t_item_info item = new Model.bi_t_item_info(); item.item_no = r.Read("item_no"); item.item_subno = r.Read("item_subno"); item.item_name = r.Read("item_name"); item.item_subname = r.Read("item_subname"); item.item_clsno = r.Read("item_clsno"); item.unit_no = r.Read("unit_no"); item.item_size = r.Read("item_size"); item.product_area = r.Read("product_area"); item.price = Helper.Conv.ToDecimal(r.Read("price")); item.base_price = Helper.Conv.ToDecimal(r.Read("base_price")); item.sale_price = Helper.Conv.ToDecimal(r.Read("sale_price")); item.combine_sta = r.Read("combine_sta"); item.item_flag = r.Read("item_flag"); item.display_flag = r.Read("display_flag"); item.sup_no = r.Read("sup_no"); item.barcode = r.Read("barcode"); item.base_price2 = Helper.Conv.ToDecimal(r.Read("base_price2")); item.base_price3 = Helper.Conv.ToDecimal(r.Read("base_price3")); item.valid_day = Helper.Conv.ToDecimal(r.Read("valid_day")); bll.Add(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change") { Model.bi_t_item_info item = new Model.bi_t_item_info(); item.item_no = r.Read("item_no"); item.item_subno = r.Read("item_subno"); item.item_name = r.Read("item_name"); item.item_subname = r.Read("item_subname"); item.item_clsno = r.Read("item_clsno"); item.unit_no = r.Read("unit_no"); item.item_size = r.Read("item_size"); item.product_area = r.Read("product_area"); item.price = Helper.Conv.ToDecimal(r.Read("price")); item.base_price = Helper.Conv.ToDecimal(r.Read("base_price")); item.sale_price = Helper.Conv.ToDecimal(r.Read("sale_price")); item.combine_sta = r.Read("combine_sta"); item.item_flag = r.Read("item_flag"); item.display_flag = r.Read("display_flag"); item.sup_no = r.Read("sup_no"); item.barcode = r.Read("barcode"); item.base_price2 = Helper.Conv.ToDecimal(r.Read("base_price2")); item.base_price3 = Helper.Conv.ToDecimal(r.Read("base_price3")); item.valid_day = Helper.Conv.ToDecimal(r.Read("valid_day")); bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string item_no = r.Read("item_no"); bll.Delete(item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "get_list_short") { var tb = bll.GetListShort(); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("datas", tb); res = w.ToString(); } else if (t == "is_use") { string item_no = r.Read("item_no"); var val = bll.IsUse(item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("value", val.ToString()); res = w.ToString(); } else if (t == "get_list_by_sup") { string sup_no = r.Read("sup_no"); string keyword = r.Read("keyword"); int show_stop = Helper.Conv.ToInt32(r.Read("show_stop")); int page_index = Helper.Conv.ToInt32(r.Read("page_index")); int page_size = Helper.Conv.ToInt32(r.Read("page_size")); int total_count = 0; var tb = bll.GetList_BySup(sup_no, keyword, show_stop, page_index, page_size, out total_count); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); w.Append("total_count", total_count.ToString()); res = w.ToString(); } else { WebHelper w = new WebHelper(pars); w.ReflectionMethod(bll, t); res = w.NmJson(); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
public void change(WebHelper w, Dictionary <string, object> kv) { Model.bi_t_item_info item = w.GetObject <Model.bi_t_item_info>(); bll.Change(item); }