| | |
|---|
| | | // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | |
|---|
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "新增工序流转卡单据：" + oBill.omodel.HBillNo + "','LMES-工序流转卡模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | |
|---|
| | | //测试语句=========================================================================================================== |
|---|
| | | string msg_str = ""; |
|---|
| | | string sql_str = "select a.HQty HQty_Main,b.HQty HQty_Sub " + |
|---|
| | | "from Sc_ProcessExchangeBillMain as a " + |
|---|
| | | "inner join Sc_ProcessExchangeBillSub as b on a.HInterID = b.HInterID " + |
|---|
| | | "where a.HInterID = " + oBill.omodel.HInterID; |
|---|
| | | DataSet ds_str = oCN.RunProcReturn(sql_str, "Sc_ProcessExchangeBillMain"); |
|---|
| | | if (ds_str.Tables[0].Rows.Count > 0) |
|---|
| | | { |
|---|
| | | msg_str = "HQty_Main:" + ds_str.Tables[0].Rows[0]["HQty_Main"].ToString() + ";HQty_Sub:"; |
|---|
| | | for (int j = 0; j < ds_str.Tables[0].Rows.Count; j++) |
|---|
| | | { |
|---|
| | | msg_str += ds_str.Tables[0].Rows[j]["HQty_Sub"].ToString() + ","; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //============================================================================================================== |
|---|
| | | |
|---|
| | | |
|---|
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "新增工序流转卡单据：" + oBill.omodel.HBillNo + msg_str + "','LMES-工序流转卡模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | LogService.Write("用户:" + msg4 + ",日期:" + DateTime.Now + ",修改工序流转卡单据:" + oBill.omodel.HBillNo); |
|---|
| | | bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | |
|---|
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "修改工序流转卡单据：" + oBill.omodel.HBillNo + "','LMES-工序流转卡模块','" + DBUtility.ClsPub.IPAddress + "','修改单据'", ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | //测试语句=========================================================================================================== |
|---|
| | | string msg_str = ""; |
|---|
| | | string sql_str = "select a.HQty HQty_Main,b.HQty HQty_Sub " + |
|---|
| | | "from Sc_ProcessExchangeBillMain as a " + |
|---|
| | | "inner join Sc_ProcessExchangeBillSub as b on a.HInterID = b.HInterID " + |
|---|
| | | "where a.HInterID = " + oBill.omodel.HInterID; |
|---|
| | | DataSet ds_str = oCN.RunProcReturn(sql_str, "Sc_ProcessExchangeBillMain"); |
|---|
| | | if (ds_str.Tables[0].Rows.Count > 0) |
|---|
| | | { |
|---|
| | | msg_str = "HQty_Main:" + ds_str.Tables[0].Rows[0]["HQty_Main"].ToString() + ";HQty_Sub:"; |
|---|
| | | for (int j = 0; j < ds_str.Tables[0].Rows.Count; j++) |
|---|
| | | { |
|---|
| | | msg_str += ds_str.Tables[0].Rows[j]["HQty_Sub"].ToString() + ","; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //============================================================================================================== |
|---|
| | | |
|---|
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "修改工序流转卡单据：" + oBill.omodel.HBillNo + msg_str + "','LMES-工序流转卡模块','" + DBUtility.ClsPub.IPAddress + "','修改单据'", ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | } |
|---|
| | | if (bResult) |
|---|
| | | { |
|---|
