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); }
}
