public override void Delete() { try { SM_SALEORDER saleorderobj = this.gGrid1.GetCurSelect <SM_SALEORDER>(); if (saleorderobj == null) { return; } string orderid = G.Core.GConvert.ToString(saleorderobj.ORDERID); string sql = string.Format("select * from SM_POCKET where ORDERID='{0}'", orderid); DataSet ds = DbEntry.Provider.ExecuteDataset(sql); if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show("该订单已装箱不能删除!"); return; } DialogResult dr = MessageBox.Show("是否删除单据!", "提示", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { DbEntry.UsingTransaction(delegate { string csql = string.Format("exec SMProc_SaleOrderDelete '{0}','{1}'", orderid, G.AppInfo.GGlobal.User.USERDM); DbEntry.Provider.ExecuteNonQuery(csql); }); this.RefreshData(); } } catch (Exception e) { MessageBox.Show(e.Message); } }
public void SetPara(SM_SALEORDER order) { saleorder = order; this.TXT_ORDERID.SetValue(order.ORDERID); this.TXT_ORDERTYPE.SetValue(order.ORDERTYPENAME); this.TXT_CUSTNAME.SetValue(order.CUSTNAME); LoadGrid1(order.ORDERID); }
public void SetPara(SM_SALEORDER order) { orderid = order.ORDERID; this.TXT_ORDERID.SetValue(order.ORDERID); this.TXT_ORDERTYPE.SetValue(order.ORDERTYPENAME); this.TXT_CUSTNAME.SetValue(order.CUSTNAME); LoadGridCP(orderid, ""); LoadGridShop(orderid, ""); this.LoadGridZJ(orderid, ""); }
private void TXT_ORDERID_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)13) { G.BLL.ERP.Sale.SM_SALEORDERLogic salelogic = new G.BLL.ERP.Sale.SM_SALEORDERLogic(); string orderid = G.Core.Common.Usually.GetPadingNO("SO", this.TXT_ORDERID.Text, 10); SM_SALEORDER order = salelogic.GetSaleOrder(G.AppInfo.GGlobal.User, orderid); FillSaleOrder(order); } }
private void FillSaleOrder(SM_SALEORDER order) { this.TXT_ORDERID.Text = order.ORDERID; this.TXT_CUSTID.Text = order.CUSTNAME; this.TXT_CUSTLEV.Text = order.CUSTLEV; this.TXT_ORDERDATE.Text = G.Core.GConvert.ToShortDateTime(order.ORDERDATE); this.TXT_SALESMAN.Text = order.SALESMANNAME; this.TXT_SALESREP.Text = order.SALESREPNAME; this.TXT_INOFC.Text = order.INOFCNAME; this.TXT_CUSTORDNB.Text = order.CUSTORDNB; this.TXT_ORDQTY.Text = G.Core.GConvert.ToInt(order.ORDQTY).ToString(); }
public override void Modify() { SM_SALEORDER order = this.gGrid1.GetCurSelect <SM_SALEORDER>(); if (order != null) { string csql = string.Format("exec SMProc_SaleOrder2BomTemp '{0}','{1}' ", order.ORDERID, G.AppInfo.GGlobal.User.USERDM); DbEntry.Provider.ExecuteNonQuery(csql); SM_ASSISTPLAN assplanform = new SM_ASSISTPLAN(); assplanform.SetPara(order); assplanform.ShowDialog(); this.LoadData(); } }
public override void Modify() { try { SM_SALEORDER order = this.gGrid1.GetCurSelect <SM_SALEORDER>(); if (order != null) { string csql = string.Format("exec SMProc_SaleOrder2BomTemp '{0}','{1}' ", order.ORDERID, G.AppInfo.GGlobal.User.USERDM); DbEntry.Provider.ExecuteNonQueryUsingTransaction(csql); SM_PLAN planform = new SM_PLAN(); planform.SetPara(order); planform.ShowDialog(); RefreshData(); } } catch (Exception e) { MessageBox.Show(e.Message); } }
private void DELETED() { try { SM_SALEORDER saleorderobj = this.gGrid1.GetCurSelect <SM_SALEORDER>(); if (saleorderobj == null) { return; } int id = G.Core.GConvert.ToInt(saleorderobj.Id); DbEntry.UsingTransaction(delegate { string csql = string.Format("UPDATE A SET STATUS='C' FROM SM_SALEORDER A WHERE ID={0}", id); DbEntry.Provider.ExecuteNonQuery(csql); }); this.RefreshData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public override void Delete() { try { SM_SALEORDER saleorderobj = this.gGrid1.GetCurSelect <SM_SALEORDER>(); if (saleorderobj == null) { return; } string orderid = G.Core.GConvert.ToString(saleorderobj.ORDERID); string sql = string.Format("select * from SM_POCKET where ORDERID='{0}'", orderid); DataSet ds = DbEntry.Provider.ExecuteDataset(sql); if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show("该订单已装箱不能删除!"); return; } DialogResult dr = MessageBox.Show("是否删除单据!", "提示", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { DbEntry.UsingTransaction(delegate { string csql = string.Format("INSERT INTO SM_SALEORDER_DEL(ID,ORDERID,ORDERDATE,CUSTID,INVCUSTID,ORDERTYPE,FTTAG,RECADDRESS,STATUS,SALESMAN,SALESREP,INOFC,REMARK,INVTAG,ORDQTY,ORDAMOUNT,ORDDISCOUNT,MAGTAG,CLOTHTYPE,THICK,REQDATE,PROTAG,OPERATOR,OPERDATE,CUSTORDNB,AUDITOR,AUDITDATE,SUPPTAG,OTHAMOUNT) SELECT ID,ORDERID,ORDERDATE,CUSTID,INVCUSTID,ORDERTYPE,FTTAG,RECADDRESS,STATUS,SALESMAN,SALESREP,INOFC,REMARK,INVTAG,ORDQTY,ORDAMOUNT,ORDDISCOUNT,MAGTAG,CLOTHTYPE,THICK,REQDATE,PROTAG,OPERATOR,OPERDATE,CUSTORDNB,AUDITOR,AUDITDATE,SUPPTAG,OTHAMOUNT FROM SM_SALEORDER WHERE ORDERID='{0}'", orderid); DbEntry.Provider.ExecuteNonQuery(csql); string csql1 = string.Format("INSERT INTO SM_SALEORDERDTL_DEL(ID,SALEORDERID,ORDERID,ORDLNNO,ITEMCODE,COLOR,TCOLORA,TCOLORB,SIZEA,MOULDA,MOULDB,MOULDC,MOULDD,STYLENO,LNQTY,BASICPRICE,MOULDPRICE,TCOLORPRICE,OTHERPRICE,ADDPRICE,PLANPRICE,LNPRICE,LNAMOUNT,NEEDING,LNDISCOUNT,SAMPLETAG,QCTAG) SELECT * FROM SM_SALEORDERDTL WHERE ORDERID='{0}'", orderid); DbEntry.Provider.ExecuteNonQuery(csql1); string csql2 = string.Format("delete from SM_SALEORDER where ORDERID='{0}'", orderid); DbEntry.Provider.ExecuteNonQuery(csql2); string csql3 = string.Format("delete from SM_SALEORDERDTL where ORDERID='{0}'", orderid); DbEntry.Provider.ExecuteNonQuery(csql3); }); this.RefreshData(); } } catch (Exception e) { MessageBox.Show(e.Message); } }
public void SOPrint(bool isPrint) { try { SM_SALEORDER saleorder = this.editData as SM_SALEORDER; string orderid = G.Core.GConvert.ToString(saleorder.ORDERID); string je = G.Core.GConvert.ToRMB(G.Core.GConvert.ToDecimal(saleorder.ORDAMOUNT)); string condition = string.Format("ORDERID='{0}'", orderid).Replace("'", "''"); string sqlstr = string.Format("EXEC Pro_PrintData '{0}','{1}'", "salecontract", condition); DataSet ds = DbEntry.Provider.ExecuteDataset(sqlstr); ds.Tables[0].Columns.Add("JERMB"); ds.Tables[0].Rows[0]["JERMB"] = je; G.Controls.Printer.PrintHelper printobj = new G.Controls.Printer.PrintHelper(@"\Sale\SALECONTRACT.frx", new List <string>() { "Master", "Detail" }, ds); printobj.Print(isPrint); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public override void Modify() { try { if (this.EditorT != null) { BaseEditor editor = System.Activator.CreateInstance(this.EditorT) as BaseEditor; editor.ShowInTaskbar = false; editor.StartPosition = FormStartPosition.CenterScreen; SM_SALEORDER obj = gGrid1.GetCurSelect <SM_SALEORDER>(); editor.SetData(obj); var audit = G.Core.ClassHelper.GetFieldValue(obj, AuditField) != null?G.Core.ClassHelper.GetFieldValue(obj, AuditField).ToString() : ""; //if (audit == "A") { editor.CurEditStatus = EditorStatus.Look; } //else //{ editor.CurEditStatus = EditorStatus.Modify; //} editor.ShowDialog(); RefreshData(); } } catch (Exception e) { MessageBox.Show(e.Message); } }