public void DoAction(StrDictionary sd) { GlobalVar.DBHelper.BeginBatch(); string oriId = null;//原id //修改订单,先将之前的信息冲掉 if (sd["oprtype"].Equals("modify")) { //保存原id GlobalVar.DBHelper.AddCustomParam("@seqnbr", sd["seqnbr"]); oriId = Convert.ToString(GlobalVar.DBHelper.ExcuteForUnique("select id from bills where seqnbr=@seqnbr", true)); if (!restoreBalance(sd["seqnbr"])) { MessageBox.Show("修改订单失败"); GlobalVar.DBHelper.EndBatch(true);//异常强制回滚 return; } }else if(sd["oprtype"].Equals("delete")) { //删除账单,并回滚库存及相关记录 bool success = restoreBalance(sd["seqnbr"]); GlobalVar.DBHelper.EndBatch(!success); GlobalVar.Container.InvokeScript(sd["invoke"],new object[]{success}); return; } string oprcode = sd["operator"]; GlobalVar.DBHelper.AddInsert("billitem", "productid,num,type,saleoff,mark,seqnbr,saleprice,c_num"); GlobalVar.DBHelper.AddInsert("bills", "id,seqnbr,payer,purunit,mobile,pid,operator,pagecode,type"); //billitem表 EasyUITable etb = new EasyUITable(); etb.Parse(sd["data"]); DateTime dtNow = DateTime.Now; long billseq = dtNow.Ticks; if (sd.ContainsKey("seqnbr") && sd["seqnbr"] != null && !sd["seqnbr"].Equals(String.Empty)) { billseq = Convert.ToInt64(sd["seqnbr"]); } etb.Table.Columns.Add("seqnbr"); foreach (DataRow r in etb.Table.Rows) { r.SetField<long>("seqnbr", billseq); r.AcceptChanges(); r.SetAdded(); } etb.Table.TableName = "billitem"; //bills 表 DataTable tbBill = new DataTable(); tbBill.Init("bills", "id,seqnbr,operator,mobile,payer,pid,purunit,pagecode,type"); DataRow row = tbBill.NewRow(); if (oriId != null) row.SetField<long>("id", Convert.ToInt64(oriId)); row.SetField<long>("seqnbr", billseq); row.SetField<string>("operator", oprcode); row.SetField<string>("mobile", sd["mobile"]); row.SetField<string>("payer", sd["payer"]); row.SetField<string>("purunit", sd["purunit"]); row.SetField<string>("pid", sd["pid"]); row.SetField<string>("pagecode", sd["pagecode"]); row.SetField<string>("type", sd["type"]); tbBill.Rows.Add(row); //products 表 string idset = GetIdSet(etb.Table, "productid"); DataTable tbProd = new DataTable("products"); GlobalVar.DBHelper.AddSelectWithLimit("products", "id,storenum", "id IN " + idset); GlobalVar.DBHelper.AddUpdate("products", "id,storenum,size,position", "id"); GlobalVar.DBHelper.Fill(ref tbProd); //storehistory表 GlobalVar.DBHelper.AddInsert("storenumhistory", "mark,num,billseqnbr,seqnbr,type,productid,finalstore,opr,customer"); DataTable tblHis = new DataTable(); tblHis.Init("storenumhistory", "mark,num,billseqnbr,seqnbr,type,productid,finalstore,opr,customer"); //账务明细表 GlobalVar.DBHelper.AddInsert("debtdetail", "main_seqnbr,billseq,opr,mark,seqnbr,amount,type"); DataTable tblDebt = new DataTable(); tblDebt.Init("debtdetail", "main_seqnbr,billseq,seqnbr,opr,mark,date,amount,type"); DataRow debtrow = tblDebt.NewRow(); debtrow.SetField<string>("opr", oprcode); debtrow.SetField<long>("seqnbr", dtNow.Ticks); debtrow.SetField<string>("amount", sd["amount"]); debtrow.SetField<string>("type", sd["type"]); debtrow.SetField<string>("main_seqnbr", billseq.ToString()); debtrow.SetField<string>("billseq", billseq.ToString()); if (sd["pid"] != "0") { string mainSeqnbr = GlobalVar.DBHelper.ExcuteForUnique<string>("select seqnbr from bills where id=" + sd["pid"]); debtrow.SetField<string>("main_seqnbr", mainSeqnbr); } tblDebt.Rows.Add(debtrow); //平衡货品数量 Balance(etb.Table, tbProd, tblHis, sd, billseq); DataSet ds = new DataSet(); ds.Tables.AddRange(new DataTable[] { etb.Table, tbProd, tbBill, tblHis, tblDebt }); //新增账单数据 更新货品数据 int ret = GlobalVar.DBHelper.Update(ds, "billitem,products,bills,storenumhistory,debtdetail"); //int ret = GlobalVar.DBHelper.Update(ds, "billitem,bills,debtdetail"); if (ret == -1) { GlobalVar.DBHelper.EndBatch(true); GlobalVar.Container.InvokeScript("resultCallback", new object[] { false }); return; } //若更新主单,需同时更新关联的子单 /*if (oriPid != null) { try { GlobalVar.DBHelper.AddCustomParam("@seqnbr", billseq); string newPid = Convert.ToString(GlobalVar.DBHelper.ExcuteForUnique("select id from bills where seqnbr=@seqnbr", true)); GlobalVar.DBHelper.AddCustomParam("@newPid", newPid); GlobalVar.DBHelper.AddCustomParam("@oldPid", oriPid); GlobalVar.DBHelper.ExcuteNonQuery("update bills set pid=@newPid where pid=@oldPid"); GlobalVar.DBHelper.AddCustomParam("@newSeqnbr", dtNow.Ticks); GlobalVar.DBHelper.AddCustomParam("@oldSeqnbr", sd["seqnbr"]); GlobalVar.DBHelper.ExcuteNonQuery("update debtdetail set main_seqnbr=@newSeqnbr where main_seqnbr=@oldSeqnbr"); } catch (Exception e) { GlobalVar.DBHelper.EndBatch(true); GlobalVar.Container.InvokeScript("resultCallback", new object[] { false }); return; } }*/ bool noErr = Utility.ProcessSqlError(ds); GlobalVar.DBHelper.EndBatch(noErr == false); //账单录入版暂不进行打印 //if (noErr) // BillPrinter.Print(etb.Table, sd); GlobalVar.Container.InvokeScript("resultCallback", new object[] { noErr }); }
public void DoAction(StrDictionary sd) { EasyUITable etb = new EasyUITable(); etb.Parse(sd["data"]); BillPrinter.Print(etb.Table, sd); }
public void DoAction(StrDictionary sd) { EasyUITable etb = new EasyUITable(); etb.Parse(sd["data"]); etb.Table.TableName = sd["table"]; etb.Table.AcceptChanges(); if (etb.Table.Columns.Contains("id") == false) { GlobalVar.Log.LogError("找不到id字段", "UpdateAction"); throw new Exception(); } GlobalVar.DBHelper.AddUpdate(sd["table"], sd["fields"], "id"); GlobalVar.DBHelper.AddInsert(sd["table"], sd["fields"]); GlobalVar.DBHelper.AddDelete(sd["table"], "id"); string[] delIds = sd["delids"].Split(new char[] { ',' }); foreach (DataRow r in etb.Table.Rows) { string id = r.Field<string>("id"); if (String.IsNullOrEmpty(id))//新增记录 { r["id"] = null;//不设为null,插入时失败 if (sd.ContainsKey("statusfield") && etb.Table.Columns.Contains(sd["statusfield"]) && String.IsNullOrEmpty(r.Field<String>(sd["statusfield"]))) r.SetField<int>(sd["statusfield"], 0); r.AcceptChanges(); r.SetAdded(); } else if (delIds.Contains(id))//删除记录 { if (sd.ContainsKey("statusfield")) { r.SetField<char>(sd["statusfield"], '1'); } else r.Delete(); } else { r.SetModified();//更新记录 } } int cnt = GlobalVar.DBHelper.Update(etb.Table); if (cnt > 0 && sd.ContainsKey("invoke")) { GlobalVar.Container.InvokeScript(sd["invoke"], null); } if (cnt > 0) MessageBox.Show("更新成功!"); else MessageBox.Show("更新失败,请查看日志!"); }