1

zrg

2025-04-02 09e3977be3584d23ddd3cec69eff8c358647cd3f

 DAL/¼Æ»®¹ÜÀí/ClsGy_RoutingBill.cs

@@ -108,7 +108,7 @@
                      ") ");
                }
                //
                oCn.RunProc("exec h_p_Gy_RoutingBillCheck " + omodel.HInterID.ToString());  //设置默认工艺路线
                oCn.RunProc("exec h_p_Gy_RoutingBillCheck " + omodel.HInterID.ToString() + ",'" + DBUtility.ClsPub.CurUserName + "'");  //设置默认工艺路线
                //oCn.RunProc("exec h_p_Sc_ProcessExchangeBillSetUpdate " + omodel.HInterID.ToString());  //设置首道末道 æµè½¬æ ‡è®° ç­‰ å­—段。
                //
                //判断是否重复工序号
@@ -242,7 +242,7 @@
                      ") ");
                }
                //
                oCn.RunProc("exec h_p_Gy_RoutingBillCheck " + omodel.HInterID.ToString());  //设置默认工艺路线
                oCn.RunProc("exec h_p_Gy_RoutingBillCheck " + omodel.HInterID.ToString() + ",'" + DBUtility.ClsPub.CurUserName + "'");  //设置默认工艺路线
                //oCn.RunProc("exec h_p_Sc_ProcessExchangeBillSetUpdate " + omodel.HInterID.ToString());  //设置首道末道 æµè½¬æ ‡è®° ç­‰ å­—段。
                //
                //判断是否重复工序号
@@ -280,7 +280,7 @@
            {
                //查询主表
                DataSet Ds ;
                Ds = oCn.RunProcReturn("Select * from Gy_RoutingBillMain Where HInterID=" + lngBillKey.ToString()+" and HPRDORGID='"+DBUtility.ClsPub.HOrgID.ToString()+"'", "Gy_RoutingBillMain");
                Ds = oCn.RunProcReturn("Select * from Gy_RoutingBillMain Where HInterID=" + lngBillKey.ToString(), "Gy_RoutingBillMain");
                if(Ds.Tables[0].Rows.Count==0)
                {
                    sReturn = "单据未找到！";
@@ -288,6 +288,8 @@
                }
                //赋值
                omodel.HInterID =DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString());
                omodel.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HBillStatus"].ToString());

                omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim();
                omodel.HName = Ds.Tables[0].Rows[0]["HName"].ToString().Trim();
                omodel.HDate = Convert.ToDateTime(Ds.Tables[0].Rows[0]["HDate"].ToString().Trim());