public AjaxResult GetOrderView([FromBody] dynamic Json)
{
string OrderNo = Json.OrderNo; //参数:订单号
#region //数据操作
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
Mod_TMO_CONDETAILS mod = tmo_condetails.GetModel(OrderNo);
if (mod != null)
{
result.Result = SerializationHelper.JsonSerialize(mod);
}
else
{
result.Result = "当前没有相关订单信息";
}
#endregion
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//添加
if (!string.IsNullOrEmpty(Request.QueryString["add"]))
{
hidconNo.Value = Request.QueryString["add"];
BindUserInfo();
}
//修改
if (!string.IsNullOrEmpty(Request.QueryString ["edit"]))
{
hidOrderNo.Value = Request.QueryString["edit"];
Mod_TMO_CONDETAILS mod = condetails.GetModel(hidOrderNo.Value);
hidconNo.Value = mod.C_CON_NO;
BindUserInfo();
}
}
}
/// <summary>
/// 获取数据列表
/// </summary>
private void GetList()
{
Mod_TMO_CONDETAILS mod = tmo_condetails.GetModel(ltlOrderNo.Text);
if (mod != null)
{
ltlConNo.Text = mod.C_CON_NO;
ltlType.Text = mod.N_TYPE.ToString();
DataTable dt = trc_roll_prodcut.GetRollProdcut(mod.C_STL_GRD, mod.C_SPEC, mod.C_STD_CODE, mod.C_AREA).Tables[0];
if (dt.Rows.Count > 0)
{
rptList.DataSource = dt;
rptList.DataBind();
}
else
{
rptList.DataSource = null;
rptList.DataBind();
}
}
}
private void GetList()
{
Mod_TMO_CONDETAILS mod = tmo_condetails.GetModel(txtOrderNo.Value);
if (mod != null)
{
txtMatCode.Value = mod.C_MAT_CODE;
txtMatName.Value = mod.C_MAT_NAME;
txtStlGrd.Value = mod.C_STL_GRD;
txtSpec.Value = mod.C_SPEC;
txTechProt.Value = mod.C_TECH_PROT;
txtstdcode.Value = mod.C_STD_CODE;
txtPack.Value = mod.C_PACK;
txtUse.Value = mod.C_PRO_USE;
txtUnit.Value = mod.C_UNITIS;
dropLEV.SelectedIndex = dropLEV.Items.IndexOf(dropLEV.Items.FindByText(mod.C_LEV));
txtNum.Value = mod.N_WGT.ToString();
txtDate.Value = Convert.ToDateTime(mod.D_DELIVERY_DT).ToString("yyy-MM-dd");
txtNeedDate.Value = Convert.ToDateTime(mod.D_NEED_DT).ToString("yyy-MM-dd");
hidSysDate.Value = Convert.ToDateTime(mod.D_SYS_DELIVERY_DT).ToString("yyy-MM-dd");
txtAddress.Value = mod.C_CGC;
txtOTCompany.Value = mod.C_OTC;
}
}
public static bool AddOrder(string c_con_no, string c_con_name, string c_area, string c_mat_code, string c_mat_name, string c_tech_prot, string c_spec, string c_stl_grd, string c_unitis, string c_pro_use, string d_delivery_dt, string n_wgt, string addrid, string c_otc, string n_currency_type, string c_std_code, string n_type, string n_dia, string c_pack, string orderNo, string custNo, string custName, string custLEV, string custType, string sysDate, string shipvia)
{
if (!string.IsNullOrEmpty(orderNo))//更新数据
{
Mod_TMO_CONDETAILS mod = condetails.GetModel(orderNo);
mod.C_MAT_CODE = c_mat_code;
mod.C_MAT_NAME = c_mat_name;
mod.C_TECH_PROT = c_tech_prot;
mod.C_SPEC = c_spec;
mod.C_STL_GRD = c_stl_grd;
//mod.C_STD_CODE = c_std_code;
mod.C_UNITIS = c_unitis;
mod.C_PRO_USE = c_pro_use;
mod.D_DELIVERY_DT = Convert.ToDateTime(d_delivery_dt);//交货日期
mod.N_WGT = Convert.ToDecimal(n_wgt);
mod.N_DIA = Convert.ToDecimal(n_dia);
mod.N_TYPE = Convert.ToDecimal(n_type);
mod.C_PACK = c_pack;
mod.C_CURRENCY_TYPE = n_currency_type;
mod.C_OTC = c_otc;
mod.C_CUST_NO = custNo;
mod.C_CUST_NAME = custName;
mod.N_USER_LEV = Convert.ToDecimal(custLEV); //客户等级
mod.C_SALE_CHANNEL = custType;
mod.D_SYS_DELIVERY_DT = Convert.ToDateTime(sysDate); //系统推荐交货日期
mod.D_NEED_DT = Convert.ToDateTime(sysDate); //需求日期
mod.C_SHIPVIA = shipvia;
#region //收货单位相关信息
Mod_TS_CUSTADDR modaddr = custaddr.GetModel(addrid);
if (modaddr != null)
{
mod.C_CGC = modaddr.C_CGC;
mod.C_CGAREA = modaddr.C_CGAREA;
mod.C_CGADDR = modaddr.C_CGADDR;
mod.C_CGMAN = modaddr.C_CGMAN;
mod.C_CGMOBILE = modaddr.C_CGMOBILE;
}
#endregion
#region //获取钢种单价-折扣-税率
DataTable dt = activity.GetActivityList(c_mat_code, c_stl_grd, c_spec).Tables[0];
if (dt.Rows.Count > 0)
{
decimal n_notax_unitprice = Convert.ToDecimal(dt.Rows[0]["N_PRICE"]); //无税单价
decimal n_rate = Convert.ToDecimal(dt.Rows[0]["N_RATE"]); //税率
decimal unitPrice = n_notax_unitprice * n_rate + n_notax_unitprice; //含税单价
decimal n_discount = Convert.ToDecimal(dt.Rows[0]["N_DISCOUNT"]); //折扣
decimal n_orimoto = Convert.ToDecimal(dt.Rows[0]["N_ORIMOTO"]); //折本汇率
mod.N_CELING_RATE = n_orimoto;
mod.N_NOTAX_UNITPRICE = n_notax_unitprice; //无税单价
mod.N_NOTAX_NETPRICE = n_notax_unitprice; //无税净价
mod.N_INCLUTAX_NETPRICE = unitPrice; //含税净价
mod.N_DC_NOTAX_UNITPRICE = n_notax_unitprice; //本币无税单价
mod.N_DC_INCLUTAX_UNITPRICE = unitPrice; //本币含税单价
mod.N_TAX = n_rate; //税率
decimal n_nomoney = Convert.ToDecimal(n_wgt) * n_notax_unitprice; //无税金额
mod.N_NOMONEY = n_nomoney; //无税金额
decimal n_pricetax_sum = Convert.ToDecimal(n_wgt) * unitPrice; //价税合计
mod.N_PRICETAX_SUM = n_pricetax_sum; //价税合计
mod.N_DC_PRICETAX_SUM = n_pricetax_sum; //本币价税合计
mod.N_ITEM_DIS = Convert.ToDecimal(dt.Rows[0]["N_DISCOUNT"]); //单品折扣
mod.N_AMOUNT_FAX = n_pricetax_sum - n_nomoney; //税额
mod.N_DC_AMOUNT_FAX = n_pricetax_sum - n_nomoney; //税额
}
#endregion
#region //获取执行标准/自由项/品种/类别 //设置质量设计号//订单-质量 //等级
Mod_TQB_STD_MAIN mod_std_main = std_main.GetModel(c_std_code);
if (mod_std_main != null)
{
mod.C_PROD_NAME = mod_std_main.C_PROD_NAME; //类别
mod.C_PROD_KIND = mod_std_main.C_PROD_KIND; //品种
mod.C_STD_CODE = mod_std_main.C_STD_CODE; //执行标准代码
}
DataRow dr = std_config.GetFREE(c_std_code);
if (dr != null)
{
mod.C_FREE_TERM = dr["C_ZYX1"].ToString();
mod.C_FREE_TERM2 = dr["C_ZYX2"].ToString();
}
mod.C_LEV = "普通";
string PK_DESIGN_ID = ""; //质量设计号主键ID
DataTable dtDesign = design.GetList("", c_std_code).Tables[0]; //质量设计信息
if (dtDesign.Rows.Count > 0)
{
mod.C_DESIGN_NO = dtDesign.Rows[0]["C_DESIGN_NO"].ToString(); //质量设计号
PK_DESIGN_ID = dtDesign.Rows[0]["C_ID"].ToString(); //质量设计主键ID
}
#endregion
bool result = false;
if (condetails.Update(mod))
{
//删除订单-质量
if (design_order.DeleteOder(orderNo))
{
//订单质量设计信息插入
Mod_TQB_DESIGN_ORDER modDesign_Order = new Mod_TQB_DESIGN_ORDER();
modDesign_Order.C_ORDER_ID = orderNo;
modDesign_Order.C_DESIGN_ID = PK_DESIGN_ID;
result = design_order.Add(modDesign_Order);
}
}
return(result);
}
else//新增数据
{
Mod_TMO_CONDETAILS mod = new Mod_TMO_CONDETAILS();
string order_no = c_con_no + DateTime.Now.ToString("MMddHHmmss");//订单号
mod.C_NO = order_no;
mod.C_CON_NO = c_con_no;
mod.C_CON_NAME = c_con_name;
mod.C_AREA = c_area;
mod.C_MAT_CODE = c_mat_code;
mod.C_MAT_NAME = c_mat_name;
mod.C_STD_CODE = c_std_code;
mod.C_TECH_PROT = c_tech_prot;
mod.C_SPEC = c_spec;
mod.C_STL_GRD = c_stl_grd;
mod.C_UNITIS = c_unitis;
mod.C_PRO_USE = c_pro_use;
mod.D_DELIVERY_DT = Convert.ToDateTime(d_delivery_dt);
mod.D_DT = DateTime.Now;
mod.N_WGT = Convert.ToDecimal(n_wgt);
mod.N_DIA = Convert.ToDecimal(n_dia);
mod.N_TYPE = Convert.ToDecimal(n_type);
mod.C_PACK = c_pack;
mod.C_CURRENCY_TYPE = n_currency_type;
mod.C_OTC = c_otc;
mod.D_SYS_DELIVERY_DT = Convert.ToDateTime(sysDate); //系统推荐交货日期
mod.D_NEED_DT = Convert.ToDateTime(sysDate); //需求日期
mod.C_CUST_NO = custNo;
mod.C_CUST_NAME = custName;
mod.N_USER_LEV = Convert.ToDecimal(custLEV);//客户等级
mod.C_SALE_CHANNEL = custType;
var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (BaseUser != null)
{
mod.C_EMP_ID = BaseUser.Id;
mod.C_EMP_NAME = BaseUser.Name;
}
#region //收货单位相关信息
Mod_TS_CUSTADDR modaddr = custaddr.GetModel(addrid);
if (modaddr != null)
{
mod.C_CGC = modaddr.C_CGC;
mod.C_CGAREA = modaddr.C_CGAREA;
mod.C_CGADDR = modaddr.C_CGADDR;
mod.C_CGMAN = modaddr.C_CGMAN;
mod.C_CGMOBILE = modaddr.C_CGMOBILE;
}
#endregion
#region //获取钢种单价-折扣-税率
DataTable dt = activity.GetActivityList(c_mat_code, c_stl_grd, c_spec).Tables[0];
if (dt.Rows.Count > 0)
{
decimal n_notax_unitprice = Convert.ToDecimal(dt.Rows[0]["N_PRICE"]); //无税单价
decimal n_rate = Convert.ToDecimal(dt.Rows[0]["N_RATE"]); //税率
decimal unitPrice = n_notax_unitprice * n_rate + n_notax_unitprice; //含税单价
decimal n_discount = Convert.ToDecimal(dt.Rows[0]["N_DISCOUNT"]); //折扣
decimal n_orimoto = Convert.ToDecimal(dt.Rows[0]["N_ORIMOTO"]); //折本汇率
mod.N_CELING_RATE = n_orimoto;
mod.N_NOTAX_UNITPRICE = n_notax_unitprice; //无税单价
mod.N_NOTAX_NETPRICE = n_notax_unitprice; //无税净价
mod.N_INCLUTAX_NETPRICE = unitPrice; //含税净价
mod.N_DC_NOTAX_UNITPRICE = n_notax_unitprice; //本币无税单价
mod.N_DC_INCLUTAX_UNITPRICE = unitPrice; //本币含税单价
mod.N_TAX = n_rate; //税率
decimal n_nomoney = Convert.ToDecimal(n_wgt) * n_notax_unitprice; //无税金额
mod.N_NOMONEY = n_nomoney; //无税金额
decimal n_pricetax_sum = Convert.ToDecimal(n_wgt) * unitPrice; //价税合计
mod.N_PRICETAX_SUM = n_pricetax_sum; //价税合计
mod.N_DC_PRICETAX_SUM = n_pricetax_sum; //本币价税合计
mod.N_ITEM_DIS = Convert.ToDecimal(dt.Rows[0]["N_DISCOUNT"]); //单品折扣
mod.N_AMOUNT_FAX = n_pricetax_sum - n_nomoney; //税额
mod.N_DC_AMOUNT_FAX = n_pricetax_sum - n_nomoney; //税额
}
#endregion
#region //获取执行标准/自由项/品种/类别 //设置质量设计号//订单-质量 //等级
Mod_TQB_STD_MAIN mod_std_main = std_main.GetModel(c_std_code);
if (mod_std_main != null)
{
mod.C_PROD_NAME = mod_std_main.C_PROD_NAME; //类别
mod.C_PROD_KIND = mod_std_main.C_PROD_KIND; //品种
mod.C_STD_CODE = mod_std_main.C_STD_CODE; //执行标准代码
}
DataRow dr = std_config.GetFREE(c_std_code);
if (dr != null)
{
mod.C_FREE_TERM = dr["C_ZYX1"].ToString();
mod.C_FREE_TERM2 = dr["C_ZYX2"].ToString();
}
mod.C_LEV = "普通";
string PK_DESIGN_ID = ""; //质量设计号主键ID
DataTable dtDesign = design.GetList("", c_std_code).Tables[0]; //质量设计信息
if (dtDesign.Rows.Count > 0)
{
mod.C_DESIGN_NO = dtDesign.Rows[0]["C_DESIGN_NO"].ToString(); //质量设计号
PK_DESIGN_ID = dtDesign.Rows[0]["C_ID"].ToString(); //质量设计主键ID
}
#endregion
bool result = false;
if (condetails.Add(mod))
{
//插入订单质量设计号
Mod_TQB_DESIGN_ORDER modDesign_Order = new Mod_TQB_DESIGN_ORDER();
modDesign_Order.C_ORDER_ID = order_no;
modDesign_Order.C_DESIGN_ID = PK_DESIGN_ID;
result = design_order.Add(modDesign_Order);
}
return(result);
}
}
/// <summary>
/// 插入销售订单
/// </summary>
/// <param name="parem">合同参数列表,返回DataTable:ID,CODE</param>
/// <returns></returns>
public DataTable InsertSaleOrder(List <string> parem)
{
//初始化DataTable
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(string)); //主键
dt.Columns.Add("CODE", typeof(string)); //单据号
Dal_TMO_CON tmo_con = new Dal_TMO_CON();
Dal_TMO_CONDETAILS tmo_condetails = new Dal_TMO_CONDETAILS();
ArrayList strSql = new ArrayList();
if (parem.Count > 0)
{
for (int i = 0; i < parem.Count; i++)
{
Mod_TMO_CON modCon = tmo_con.GetModel(parem[i]);
Mod_TMO_SALEORDER modSale = new Mod_TMO_SALEORDER();
#region //销售订单主表
string pk_mainid = Guid.NewGuid().ToString("N"); //主键ID
string code = Dal_RandomNumber.GetSaleCode(); //销售单据号
dt.Rows.Add(new object[] { pk_mainid, code });
StringBuilder cmdText = new StringBuilder();
cmdText.Append("insert into TMO_SALEORDER(");
cmdText.Append("C_ID,C_CODE,C_CONNO,C_INITIALIZE_ID,C_BIZTYPE,D_BILLDATE,C_CUSTOMERID,C_DEPTID,C_EMPLOYEEID,C_OPERATORID,C_SALECORPID,C_RECEIPTCUSTOMERID,C_RECEIVEADDRESS,C_RECEIPTCORPID,C_TRANSMODEID,D_MAKEDATE,C_APPROVEID,D_APPROVEDATE)");
cmdText.Append(" values (");
cmdText.Append("'" + pk_mainid + "',"); //主键ID
cmdText.Append("'" + code + "',"); //销售单据号
cmdText.Append("'" + modCon.C_CON_NO + "',"); //合同号
cmdText.Append("'',"); //方案表主键
cmdText.Append("'" + modCon.C_BIZTYPE + "',"); //业务类型ID
cmdText.Append("to_date('" + DateTime.Now + "','yyyy-mm-dd hh24:mi:ss'),"); //单据日期
cmdText.Append("'" + modCon.C_CUSTOMERID + "',"); //客户ID-NC客商管理档案主键
cmdText.Append("'" + modCon.C_DEPTID + "',"); //部门ID
cmdText.Append("'" + modCon.C_EMPLOYEEID + "',"); //业务员ID
cmdText.Append("'" + modCon.C_COPERATORID + "',"); //制单人ID
cmdText.Append("'" + modCon.C_SALECORPID + "',"); //销售组织ID
cmdText.Append("'" + modCon.C_CRECEIPTCUSTOMERID + "',"); //收货单位
cmdText.Append("'" + modCon.C_ADDRESS + "',"); //收货地址
cmdText.Append("'" + modCon.C_CRECEIPTAREAID + "',"); //开票单位ID-来源与客户档案信息
cmdText.Append("'" + modCon.C_TRANSMODEID + "',"); //发运方式ID
cmdText.Append("to_date('" + modCon.D_DMAKEDATE + "','yyyy-mm-dd hh24:mi:ss'),"); //制单日期
cmdText.Append("'" + modCon.C_APPROVEID + "',"); //审批人
cmdText.Append("to_date('" + modCon.D_APPROVEDATE + "','yyyy-mm-dd hh24:mi:ss')"); //审批日期
cmdText.Append(")");
strSql.Add(cmdText.ToString());
#endregion
DataTable dtOrder = tmo_condetails.GetConOrderList(parem[i], "").Tables[0];
if (dtOrder.Rows.Count > 0)
{
for (int k = 0; k < dtOrder.Rows.Count; k++)
{
#region //插入销售订单子表
Mod_TMO_CONDETAILS modOrder = tmo_condetails.GetModel(dtOrder.Rows[k]["C_NO"].ToString());
string pk_itemid = Guid.NewGuid().ToString("N"); //主键
StringBuilder cmdText2 = new StringBuilder();
cmdText2.Append("insert into TMO_SALEORDERITEM(");
cmdText2.Append("C_ID,C_BILLID,C_ORDERNO,C_CONNO,C_INVBASDOCID,C_INVENTORYID,C_UNITID,C_FUNITID,N_NUMBER,D_CONSIGNDATE,D_DELIVERDATE,C_CURRENCYTYPEID,N_TAXRATE,N_ORIGINALCURPRICE,N_ORIGINALCURTAXPRICE,N_ORIGINALCURTAXMNY,N_ORIGINALCURMNY,N_ORIGINALCURSUMMNY,C_RECEIPTAREAID,C_RECEIVEADDRESS,C_RECEIPTCORPID,C_VFREE1,C_VFREE2,C_VFREE3,C_VDEF1)");
cmdText2.Append(" values (");
cmdText2.Append("'" + pk_itemid + "',"); //主键
cmdText2.Append("'" + pk_mainid + "',"); //来源销售主表ID
cmdText2.Append("'" + modOrder.C_NO + "',"); //订单号
cmdText2.Append("'" + modOrder.C_CON_NO + "',"); //合同号
cmdText2.Append("'" + modOrder.C_INVBASDOCID + "',"); //存货档案主键
cmdText2.Append("'" + modOrder.C_INVENTORYID + "',"); //存货管理档案主键
cmdText2.Append("'" + modOrder.C_UNITID + "',"); //主计量单位
cmdText2.Append("'" + modOrder.C_PACKUNITID + "',"); //辅单位
cmdText2.Append("" + modOrder.N_WGT + ","); //数量
cmdText2.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //发货日期
cmdText2.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //交货日期
cmdText2.Append("'" + modOrder.C_CURRENCYTYPEID + "',"); //货币
cmdText2.Append("" + modOrder.N_TAXRATE + ","); //税率
cmdText2.Append("" + modOrder.N_ORIGINALCURPRICE + ","); //原币无税单价
cmdText2.Append("" + modOrder.N_ORIGINALCURTAXPRICE + ","); //原币含税单价
cmdText2.Append("" + modOrder.N_ORIGINALCURTAXMNY + ","); //原币税额
cmdText2.Append("" + modOrder.N_ORIGINALCURMNY + ","); //原币无税金额
cmdText2.Append("" + modOrder.N_ORIGINALCURSUMMNY + ","); //原币价税合计
cmdText2.Append("'" + modCon.C_CRECEIPTAREAID + "',"); //收货地区
cmdText2.Append("'" + modCon.C_ADDRESS + "',"); //收货地址
cmdText2.Append("'" + modCon.C_CRECEIPTCORPID + "',"); //收货单位
cmdText2.Append("'" + modOrder.C_FREE_TERM + "',"); //自由项1
cmdText2.Append("'" + modOrder.C_FREE_TERM2 + "',"); //自由项2
cmdText2.Append("'" + modOrder.C_PACK + "',"); //包装要求
cmdText2.Append("'" + modOrder.C_VDEF1 + "'"); //质量等级
cmdText2.Append(")");
strSql.Add(cmdText2.ToString());
#endregion
#region //日计划
string dayCode = Dal_RandomNumber.GetDayPlanCode(); //日计划单据号
StringBuilder cmdText3 = new StringBuilder();
cmdText3.Append("insert into TMP_DAYPLAN(");
cmdText3.Append(@"C_PLCODE,
C_PKBILLB,
C_PKBILLH,
C_CONNO,
C_ORDERNO,
C_PKINV,
C_PKASSISTMEASURE,
N_ASSISTNUM,
N_NUM,
N_UNITPRICE,
N_MONEY,
D_PLANDATE,
D_ORDSNDATE,
D_REQUIREDATE,
D_SNDDATE,
C_PKCUST,
C_PKSENDTYPE,
C_PKSALEORG,
C_PKOPERATOR,
C_PKOPRDEPART,
C_PKPLANPERSON,
C_PKAPPRPERSON,
D_APPRDATE,
C_PKARRIVEAREA,
C_DESTADDRESS,
C_RECEIPTCORPID,
C_BIZTYPE,
C_UNITID,
C_VFREE1,
C_VFREE2,
C_VFREE3,
C_VFREE4,
C_SALECODE)");
cmdText3.Append(" values (");
cmdText3.Append("'" + dayCode + "',"); //日计划单据号
cmdText3.Append("'" + pk_itemid + "',"); //来源销售订单子表ID
cmdText3.Append("'" + pk_mainid + "',"); //来源销售订单主表ID
cmdText3.Append("'" + modOrder.C_CON_NO + "',"); //合同号
cmdText3.Append("'" + modOrder.C_NO + "',"); //订单号
cmdText3.Append("'" + modOrder.C_INVENTORYID + "',"); //存货主键
cmdText3.Append("'" + modOrder.C_PACKUNITID + "',"); //辅计量单位ID
cmdText3.Append("" + modOrder.N_FNUM + ","); //辅数量
cmdText3.Append("" + modOrder.N_WGT + ","); //主数量
cmdText3.Append("" + modOrder.N_ORIGINALCURTAXPRICE + ","); //单价
cmdText3.Append("" + modOrder.N_ORIGINALCURSUMMNY + ","); //订单金额
cmdText3.Append("to_date('" + modOrder.D_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //日计划日期
cmdText3.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //定单要求发货日期
cmdText3.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //定单要求到货日期
cmdText3.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //实际发货日期
cmdText3.Append("'" + modOrder.C_RECEIPTCORPID + "',"); //客户ID
cmdText3.Append("'" + modCon.C_TRANSMODEID + "',"); //发运方式ID
cmdText3.Append("'" + modCon.C_SALECORPID + "',"); //销售组织ID
cmdText3.Append("'" + modCon.C_EMPLOYEEID + "',"); //业务员ID
cmdText3.Append("'" + modCon.C_DEPTID + "',"); //业务部门ID
cmdText3.Append("'" + modCon.C_COPERATORID + "',"); //计划人ID
cmdText3.Append("'" + modCon.C_APPROVEID + "',"); //审批人ID
cmdText3.Append("to_date('" + modCon.D_APPROVEDATE + "','yyyy-mm-dd hh24:mi:ss'),"); //审批日期
cmdText3.Append("'" + modCon.C_CRECEIPTAREAID + "',"); //到货地区ID
cmdText3.Append("'" + modCon.C_ADDRESS + "',"); //到货地址
cmdText3.Append("'" + modCon.C_CRECEIPTCUSTOMERID + "',"); //收货单位ID
cmdText3.Append("'" + modCon.C_BIZTYPE + "',"); //业务类型ID
cmdText3.Append("'" + modOrder.C_UNITID + "',"); //计量单位ID
cmdText3.Append("'" + modOrder.C_FREE_TERM + "',"); //自由项1
cmdText3.Append("'" + modOrder.C_FREE_TERM2 + "',"); //自由项2
cmdText3.Append("'" + modOrder.C_PACK + "',"); //包装要求
cmdText3.Append("'" + modOrder.C_VDEF1 + "',"); //质量等级
cmdText3.Append("'" + code + "'"); //销售单据号
cmdText3.Append(")");
strSql.Add(cmdText3);
#endregion
}
}
}
DbHelperOra.ExecuteSqlTran(strSql);
}
return(dt);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMO_CONDETAILS model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMO_CONDETAILS model)
{
return(dal.Add(model));
}
//批准
protected void btnOk_Click(object sender, EventArgs e)
{
#region //添加流程明细
string content = string.Empty;
DateTime dt = DateTime.Now;
if (!string.IsNullOrEmpty(txtContent.Text))
{
content += txtContent.Text + "-(" + ltlUserName.Text + " " + dt.ToString() + ")";
}
else
{
content += "批准—(" + ltlUserName.Text + " " + dt.ToString() + ")";
}
Mod_TMB_FLOWPROC modPro = new Mod_TMB_FLOWPROC();
modPro.C_FILE_ID = ltlFileID.Text;
modPro.C_STEP_ID = ltlStepID.Text;
modPro.C_STEP_EMP_ID = ltlUserID.Text;
modPro.C_STEPNOTE = content;
modPro.D_STEP_DT = dt;
modPro.N_PROCRESULT = 1;
#endregion
if (flowproc.Add(modPro)) //插入流程明细
{
con.UpdateCheckEmp(ltlTaskID.Text, ltlUserID.Text, dt); //更新当前审批人/时间
string nextStep = flowstep.GetNextStep(ltlFlowID.Text, ltlStepID.Text); //下一处理步骤
if (nextStep == "0") //判断是否最后步骤
{
if (fileinfo.UpdateStepStatus(nextStep, 1, ltlFileID.Text)) //更新文件事务状态为办结
{
#region //更新合同/明细状态
if (con.UpdateConStatus(2, ltlTaskID.Text)) //更新合同
{
if (condetails.UpdateStatus(2, ltlTaskID.Text)) //更新合同明细
{
bool result = false;
foreach (RepeaterItem rpt in rptList.Items)
{
Literal ltlOrderNo = (Literal)rpt.FindControl("ltlOrderNo");
DataRow[] row = orderdata.Select("C_ORDER_NO='" + ltlOrderNo.Text + "'");
if (row.Length > 0)
{
if (row[0]["N_EXEC_STATUS"].ToString() == "0")//订单未排产
{
Mod_TMO_CONDETAILS mod = condetails.GetModel(ltlOrderNo.Text);
if (tmo_order.UpdateOrder(mod)) //更新订单池订单
{
result = tmp_plan.UpdatePlan(mod); //更新订单日计划
}
}
}
else
{
if (condetails.AddOrder(ltlOrderNo.Text))//订单插入订单池
{
Mod_TMO_CONDETAILS mod = condetails.GetModel(ltlOrderNo.Text);
mod.C_BUSINESS_TYPE = dropYeWuType.SelectedValue;
if (mod != null)
{
result = tmp_plan.AddPlan(mod);//插入日计划
}
}
}
}
if (result)
{
WebMsg.MessageBox("提交成功", "WorkFlow_D.aspx");
}
}
}
#endregion
}
}
else
{
if (fileinfo.UpdateStep(nextStep, ltlFileID.Text))//更新文件事务下一步骤
{
WebMsg.MessageBox("提交成功", "WorkFlow_D.aspx");
}
}
}
}
/// <summary>
/// 添加日计划
/// </summary>
public bool AddPlan(Mod_TMO_CONDETAILS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMP_PLAN(");
strSql.Append("C_NO,C_CON_NO,D_PLANSEND_DT,C_MAT_CODE,C_MAT_NAME,C_SPEC,C_STL_GRD,N_WGT,C_ATSTATION,C_AREA,C_ADDR,C_CGC,C_ORGO_CUST,C_SEND_STOCK_DEPT,D_ORRE_AOG_DT,C_SEND_STOCK,C_AOG_STOCK_DEPT,C_SEND_COM,C_SALE_COM,C_AOG_COM,C_SEND_AREA,C_SEND_ADDR,C_SEND_SITE,C_AOG_SITE,C_ORDER_TYPE,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT)");
strSql.Append(" values (");
strSql.Append(":C_NO,:C_CON_NO,:D_PLANSEND_DT,:C_MAT_CODE,:C_MAT_NAME,:C_SPEC,:C_STL_GRD,:N_WGT,:C_ATSTATION,:C_AREA,:C_ADDR,:C_CGC,:C_ORGO_CUST,:C_SEND_STOCK_DEPT,:D_ORRE_AOG_DT,:C_SEND_STOCK,:C_AOG_STOCK_DEPT,:C_SEND_COM,:C_SALE_COM,:C_AOG_COM,:C_SEND_AREA,:C_SEND_ADDR,:C_SEND_SITE,:C_AOG_SITE,:C_ORDER_TYPE,:C_REMARK,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CON_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":D_PLANSEND_DT", OracleDbType.Date),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":N_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_ATSTATION", OracleDbType.Varchar2, 100),
new OracleParameter(":C_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ADDR", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CGC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORGO_CUST", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SEND_STOCK_DEPT", OracleDbType.Varchar2, 100),
new OracleParameter(":D_ORRE_AOG_DT", OracleDbType.Date),
new OracleParameter(":C_SEND_STOCK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_AOG_STOCK_DEPT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SEND_COM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SALE_COM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_AOG_COM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SEND_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SEND_ADDR", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SEND_SITE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_AOG_SITE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDER_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date)
};
parameters[0].Value = model.C_NO;
parameters[1].Value = model.C_CON_NO;
parameters[2].Value = model.D_DELIVERY_DT;
parameters[3].Value = model.C_MAT_CODE;
parameters[4].Value = model.C_MAT_NAME;
parameters[5].Value = model.C_SPEC;
parameters[6].Value = model.C_STL_GRD;
parameters[7].Value = model.N_WGT;
parameters[8].Value = model.C_ATSTATION;
parameters[9].Value = model.C_AREA;
parameters[10].Value = model.C_ADDRESS;
parameters[11].Value = model.C_RECEIPTCORPID;
parameters[12].Value = model.C_CUST_NO;
parameters[13].Value = "1001NC10000000000669"; //发货库存组织
parameters[14].Value = model.D_DELIVERY_DT;
parameters[15].Value = ""; //发货仓库
parameters[16].Value = "1001NC10000000000669"; //到货库存组织
parameters[17].Value = "1001"; //发货单位
parameters[18].Value = "1001"; //销售公司
parameters[19].Value = model.C_RECEIPTCORPID; //到货公司
parameters[20].Value = model.C_CRECEIPTAREAID; //发货地区
parameters[21].Value = model.C_ADDRESS; //发货地址
parameters[22].Value = model.C_ADDRESS; //发货地点
parameters[23].Value = model.C_ADDRESS; //到货地点
parameters[24].Value = model.N_TYPE; //订单类型
parameters[25].Value = model.C_REMARK;
parameters[26].Value = model.C_EMP_ID;
parameters[27].Value = model.C_EMP_NAME;
parameters[28].Value = model.D_MOD_DT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
