public void AssAddCG(WebHelper w, Dictionary <string, object> kv) { Model.ic_t_inout_store_master ord = w.GetObject <Model.ic_t_inout_store_master>(); ord.approve_flag = "0"; ord.display_flag = "1"; ord.old_no = ""; ord.approve_date = DateTime.MinValue; ord.max_change = 0m; //不确定 ord.lock_man = ""; ord.lock_date = DateTime.MinValue; List <Model.ic_t_inout_store_detail> lines = w.GetList <Model.ic_t_inout_store_detail>("lines"); foreach (var item in lines) { item.cost_notax = 0m; //不确定 item.branch_no_d = ""; item.ly_sup_no = ""; item.ly_rate = 0m; } string sheet_no = ""; bll.AssAddCG(ord, lines, out sheet_no); w.Write("sheet_no", sheet_no); }
void IInOutBLL.ChangeInOut(Model.ic_t_inout_store_master ord, List <Model.ic_t_inout_store_detail> lines) { var db = new DB.DBByHandClose(Appsetting.conn); DB.IDB d = db; try { db.Open(); db.BeginTran(); // string sql = "select approve_flag,update_time from ic_t_inout_store_master where sheet_no='" + ord.sheet_no + "'"; 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 + "]"); } if (Helper.Conv.ToDateTime(row["update_time"]).ToString("yyyy-MM-dd HH:mm:ss") != ord.update_time.ToString("yyyy-MM-dd HH:mm:ss")) { throw new Exception("单据已被他人修改[" + ord.sheet_no + "]"); } } sql = "delete from ic_t_inout_store_detail where sheet_no='" + ord.sheet_no + "'"; d.ExecuteScalar(sql, null); sql = "delete from ic_t_inout_store_master where sheet_no='" + ord.sheet_no + "'"; d.ExecuteScalar(sql, null); // ord.update_time = DateTime.Now; d.Insert(ord); foreach (Model.ic_t_inout_store_detail line in lines) { sql = "select isnull(max(flow_id),0) + 1 as flow_id from ic_t_inout_store_detail "; line.flow_id = Helper.Conv.ToInt64(d.ExecuteScalar(sql, null)); d.Insert(line); } // db.CommitTran(); } catch (Exception ex) { LogHelper.writeLog("InOutBLL.ChangeInOut()", ex.ToString(), ord.sheet_no); db.RollBackTran(); throw ex; } finally { db.Close(); } }
private void insertTHRK(string pay_way, decimal pay_amt) { var gd = new Model.bi_t_item_info(); decimal amt = 0; //单据总金额 IBLL.ICGRK bll = new BLL.CGRK(); var lines_cgrk = new List <Model.ic_t_inout_store_detail>(); int index = 0; foreach (var item in this.lines) { if (goodsDic.TryGetValue(item.item_no, out gd) == false) { new MsgForm("商品读取错误").ShowDialog(); return; } ++index; var line_cgrk = new Model.ic_t_inout_store_detail(); line_cgrk.sheet_no = lblsheet_no.Text.Trim(); line_cgrk.item_no = item.item_no; line_cgrk.item_subno = item.item_subno; line_cgrk.item_name = item.item_name; line_cgrk.unit_no = gd.unit_no; line_cgrk.in_qty = item.qty; line_cgrk.orgi_price = item.source_price; line_cgrk.valid_price = item.price; line_cgrk.cost_price = item.price; line_cgrk.valid_date = DateTime.Now; line_cgrk.barcode = gd.barcode; line_cgrk.sheet_sort = index; line_cgrk.other3 = item.is_give; amt += line_cgrk.valid_price * line_cgrk.in_qty; lines_cgrk.Add(line_cgrk); } var ord = new Model.ic_t_inout_store_master(); ord.sheet_no = lblsheet_no.Text.Trim(); ord.trans_no = "D"; ord.branch_no = Program.branch_no; ord.supcust_no = supcus_no; ord.total_amount = amt; ord.inout_amount = pay_amt; ord.approve_flag = "0"; ord.oper_date = DateTime.Now; ord.oper_id = Program.oper_id; ord.pay_way = pay_way; //新建 bll.InsertOrder(ord, lines_cgrk); }
void IInOutBLL.AddInOut(Model.ic_t_inout_store_master ord, List <Model.ic_t_inout_store_detail> lines, out string sheet_no) { sheet_no = ""; var db = new DB.DBByHandClose(Appsetting.conn); DB.IDB d = db; try { db.Open(); db.BeginTran(); if (ord.trans_no == "A") { sheet_no = MaxCode(d, "PI"); ord.db_no = "+"; } else if (ord.trans_no == "D") { sheet_no = MaxCode(d, "RI"); ord.db_no = "+"; } else if (ord.trans_no == "F") { sheet_no = MaxCode(d, "RO"); ord.db_no = "-"; } else if (ord.trans_no == "G") { sheet_no = MaxCode(d, "IO"); ord.db_no = ""; } else if (ord.trans_no == "01") { sheet_no = MaxCode(d, "OO"); ord.db_no = "+"; } else if (ord.trans_no == "03") { sheet_no = MaxCode(d, "OO"); ord.db_no = "-"; } else { sheet_no = MaxCode(d, "OO"); ord.db_no = ""; } ord.sheet_no = sheet_no; ord.create_time = DateTime.Now; ord.update_time = ord.create_time; // d.Insert(ord); foreach (Model.ic_t_inout_store_detail line in lines) { string sql = "select isnull(max(flow_id),0) + 1 as flow_id from ic_t_inout_store_detail "; line.flow_id = Helper.Conv.ToInt64(d.ExecuteScalar(sql, null)); line.sheet_no = sheet_no; d.Insert(line); } // db.CommitTran(); } catch (Exception ex) { LogHelper.writeLog("InOutBLL.AddInOut()", ex.ToString(), ord.sheet_no); db.RollBackTran(); throw ex; } finally { db.Close(); } }
void IBLL.IInOutBLL.ChangeInOut(Model.ic_t_inout_store_master ord, List <Model.ic_t_inout_store_detail> lines) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("sheet_no", ord.sheet_no); w.Append("trans_no", ord.trans_no); w.Append("branch_no", ord.branch_no); w.Append("voucher_no", ord.voucher_no); w.Append("supcust_no", ord.supcust_no); w.Append("pay_way", ord.pay_way); w.Append("db_no", ord.db_no); w.Append("discount", ord.discount.ToString()); w.Append("coin_no", ord.coin_no); w.Append("total_amount", ord.total_amount.ToString()); w.Append("inout_amount", ord.inout_amount.ToString()); w.Append("tax_amount", ord.tax_amount.ToString()); w.Append("oper_id", ord.oper_id); w.Append("deal_man", ord.deal_man); w.Append("cm_branch", ord.cm_branch); w.Append("oper_date", ord.oper_date.ToString("yyyy-MM-dd HH:mm:ss")); w.Append("other1", ord.other1); w.Append("other2", ord.other2); w.Append("other3", ord.other3); w.Append("old_no", ord.old_no); w.Append("num1", ord.num1.ToString()); w.Append("num2", ord.num2.ToString()); w.Append("num3", ord.num3.ToString()); w.Append("sale_no", ord.sale_no); w.Append("update_time", ord.update_time.ToString("yyyy-MM-dd HH:mm:ss")); var tb = new DataTable(); tb.Columns.Add("sheet_no"); tb.Columns.Add("item_no"); tb.Columns.Add("item_name"); tb.Columns.Add("unit_no"); tb.Columns.Add("unit_factor", typeof(decimal)); tb.Columns.Add("in_qty", typeof(decimal)); tb.Columns.Add("orgi_price", typeof(decimal)); tb.Columns.Add("valid_price", typeof(decimal)); tb.Columns.Add("cost_price", typeof(decimal)); tb.Columns.Add("sub_amount", typeof(decimal)); tb.Columns.Add("tax", typeof(decimal)); tb.Columns.Add("is_tax"); tb.Columns.Add("valid_date", typeof(DateTime)); tb.Columns.Add("other1"); tb.Columns.Add("other2"); tb.Columns.Add("other3"); tb.Columns.Add("num1", typeof(decimal)); tb.Columns.Add("num2", typeof(decimal)); tb.Columns.Add("num3", typeof(decimal)); tb.Columns.Add("num4", typeof(decimal)); tb.Columns.Add("num5", typeof(decimal)); tb.Columns.Add("num6", typeof(decimal)); tb.Columns.Add("barcode"); tb.Columns.Add("voucher_no"); tb.Columns.Add("sheet_sort", typeof(int)); tb.Columns.Add("ret_qnty", typeof(decimal)); tb.Columns.Add("discount", typeof(decimal)); tb.Columns.Add("packqty", typeof(int)); tb.Columns.Add("sgqty", typeof(decimal)); foreach (Model.ic_t_inout_store_detail line in lines) { tb.Rows.Add(line.sheet_no, line.item_no, line.item_name, line.unit_no, line.unit_factor, line.in_qty, line.orgi_price, line.valid_price, line.cost_price, line.sub_amount, line.tax, line.is_tax, line.valid_date, line.other1, line.other2, line.other3, line.num1, line.num2, line.num3, line.num4, line.num5, line.num6, line.barcode, line.voucher_no, line.sheet_sort, line.ret_qnty, line.discount, line.packqty, line.sgqty); } w.Append("lines", tb); Helper.IRequest req = new Helper.Request(); var json = req.request("/inout?t=change_inout", w.ToString()); ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json); if (r.Read("errId") != "0") { throw new Exception(r.Read("errMsg")); } }