using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Windows.Forms; namespace DBUtility { public class ClsXt_BaseBill { public string BillType; //单据类型 public string HBillSubType; //单据子类型 public string MvarItemKey; //表名 public string MvarItemKeySub; // 子表名 public string MvarItemKeySub2; // 子表名 public string MvarItemKeySub3; // 子表名 public string MvarItemKeySub4; // 子表名 public string MvarItemKeySubForWeb; //子表视图WEB public string MvarItemKeySubForWeb2; //子表2视图WEB public string MvarItemKeyForWeb; //主表视图WEB public string MvarReportTitle; //标题 public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public SQLHelper.ClsCNK3 oK3Cn = new SQLHelper.ClsCNK3(); public SQLHelper.ClsCNK3 oCnK3 = new SQLHelper.ClsCNK3(); string ComputerName = SystemInformation.ComputerName; //设备名称 string IPAddress=""; //设备IP public ClsXt_BaseBill() { BillType = ""; MvarItemKey = ""; MvarItemKeySub = ""; MvarItemKeySub2 = ""; MvarItemKeySub3 = ""; MvarItemKeySub4 = ""; MvarReportTitle = ""; MvarItemKeySubForWeb = ""; MvarItemKeySubForWeb2 = ""; //新增 MvarItemKeyForWeb = ""; } #region 固定代码 ~ClsXt_BaseBill() { } //反作废 public bool AbandonCancelltion(Int64 lngBillKey, ref string sReturn) { try { DataSet ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=3 Where HInterID=" + lngBillKey.ToString()); } else if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); } else { oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=1 Where HInterID=" + lngBillKey.ToString()); } sReturn = ""; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //反作废单据(包含写入日志) 2024-01-31 public bool AbandonCancelltion(Int64 lngBillKey, string HBillNo, string sUser, ref string sReturn) { try { oCn.BeginTran(); DataSet ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=3 Where HInterID=" + lngBillKey.ToString()); } else if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); } else { oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=1 Where HInterID=" + lngBillKey.ToString()); } //写入日志 string WorkList = "反作废单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','反作废')" ); sReturn = "反作废单据成功！"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //反作废(包含作废后控制、写入日志) 2025-03-10 public bool AbandonCancelltion(Int64 lngBillKey, string HBillNo, string procName, string sUser, ref string sReturn) { string sql = ""; if (isUse(lngBillKey, ref sReturn)) { return false; } try { //开启事务 oCn.BeginTran(); DataSet ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=3 Where HInterID=" + lngBillKey.ToString()); } else if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); } else { oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=1 Where HInterID=" + lngBillKey.ToString()); } //作废后控制 sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'"; ds = oCn.RunProcReturn(sql, procName); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { sReturn = "反作废过程中出错，请与网络管理人员联系"; oCn.RollBack(); return false; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString(); oCn.RollBack(); return false; } //写入日志 string WorkList = "反作废单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','反作废')" ); sReturn = "反作废单据成功！"; ; oCn.Commit(); return true; } catch (Exception e) { oCn.RollBack(); sReturn = e.Message; throw (e); } } //反关闭 public bool CancelClose(Int64 lngBillKey, ref string sReturn) { try { DataSet ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); if (ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null,HBillStatus=4,HCloseType = 0 Where HInterID=" + lngBillKey.ToString()); } else if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null,HBillStatus=2,HCloseType = 0 Where HInterID=" + lngBillKey.ToString()); } else { oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null,HBillStatus=1,HCloseType = 0 Where HInterID=" + lngBillKey.ToString()); } sReturn = ""; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //反关闭单据(包含写入日志) 2024-01-31 public bool CancelClose(Int64 lngBillKey, string HBillNo, string sUser, ref string sReturn) { try { oCn.BeginTran(); DataSet ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); if (ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null,HBillStatus=4,HCloseType = 0 Where HInterID=" + lngBillKey.ToString()); } else if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null,HBillStatus=2,HCloseType = 0 Where HInterID=" + lngBillKey.ToString()); } else { oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null,HBillStatus=1,HCloseType = 0 Where HInterID=" + lngBillKey.ToString()); } //写入日志 string WorkList = "反关闭单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','反关闭')" ); sReturn = "反关闭单据成功！"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //行反关闭单据(包含写入日志) 2024-01-31 public bool CancelRow(Int64 lngBillKey,Int64 HEntryID, string HBillNo, string sUser, ref string sReturn) { try { //oCn.BeginTran(); string sql = "select * from " + MvarItemKeySub + " where HInterID=" + lngBillKey.ToString() + " and HEntryID = " + HEntryID; DataSet ds = oCn.RunProcReturn(sql, MvarItemKeySub); if(ds==null || ds.Tables[0].Rows.Count == 0) { sReturn = "行记录不存在！"; return false; } else { sql = " Update " + MvarItemKeySub + " set HCloseMan='',HEntryCloseDate='',HCloseType=0 Where HInterID=" + lngBillKey.ToString() + " and HEntryID = " + HEntryID; oCn.RunProc(sql); } //写入日志 string WorkList = "行反关闭，单据号：" + HBillNo + "；子表内码：" + HEntryID; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','行反关闭')" ); sReturn = "行反关闭成功！"; //oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //反审核 public bool AbandonCheck(Int64 lngBillKey, ref string sReturn) { string sql = ""; if (isUse(lngBillKey, ref sReturn)) { return false; } try { DataSet ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); if (ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=4 Where HInterID=" + lngBillKey.ToString()); } else if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=3 Where HInterID=" + lngBillKey.ToString()); } else { oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=1 Where HInterID=" + lngBillKey.ToString()); } //反审核后 更新及时库存表 减少库存 sql = "select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(); ds = oCn.RunProcReturn(sql, MvarItemKey); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string HBillType = ds.Tables[0].Rows[0]["HBillType"].ToString(); if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1204") { //反审核更新 及时库存表 增加库存 1201 1202 1203 1247 1244 1251 1210 //反审核更新 及时库存表 减少库存 1204 1202 1203 1247 1244 1251 1210 ds = oCn.RunProcReturn("exec h_KF_UPDateICinventory '" + lngBillKey.ToString() + "','" + HBillType + "','2'", "h_KF_UPDateICinventory"); } //=========================审核反审核后负库存控制 DataSet ds2 = oCn.RunProcReturn("Exec h_p_KF_ICinventoryStockCtrl '" + lngBillKey.ToString() + "', '" + HBillType + "'", "h_p_KF_ICinventoryStockCtrl"); if (ds2 == null) { sReturn = "库存更新后控制判断失败！"; oCn.RollBack(); return false; } if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") { sReturn = "库存更新失败！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); oCn.RollBack(); return false; } //============================ } sReturn = ""; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //反审核(包含反审核后控制、写入日志) 2024-01-31 public bool AbandonCheck(Int64 lngBillKey, string HBillNo, string procName, string sUser, ref string sReturn) { string sql = ""; DataSet ds; if (isUse(lngBillKey, ref sReturn)) { return false; } try { //开启事务 oCn.BeginTran(); ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); if (ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=4 Where HInterID=" + lngBillKey.ToString()); } else if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") { oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=3 Where HInterID=" + lngBillKey.ToString()); } else { oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=1 Where HInterID=" + lngBillKey.ToString()); } //反审核后控制 sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'"; ds = oCn.RunProcReturn(sql, procName); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { sReturn = "反审核过程中出错，请与网络管理人员联系"; oCn.RollBack(); return false; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString(); oCn.RollBack(); return false; } //反审核后 更新及时库存表 减少库存 sql = "select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(); ds = oCn.RunProcReturn(sql, MvarItemKey); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string HBillType = ds.Tables[0].Rows[0]["HBillType"].ToString(); if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1205" || HBillType == "1250" || HBillType == "1206" || HBillType == "1245" || HBillType == "1239") { //反审核更新 及时库存表 增加库存 1201 1202 1203 1247 1244 1251 1210 //反审核更新 及时库存表 减少库存 1205 1250 1206 1245 1239 ds = oCn.RunProcReturn("exec h_KF_UPDateICinventory '" + lngBillKey.ToString() + "','" + HBillType + "','2'", "h_KF_UPDateICinventory"); }else if (HBillType == "1207") { //更新及时库存表 增加调入库存,减少调出库存 ds = oCn.RunProcReturn("exec h_KF_UPDateICinventory_Move '" + lngBillKey.ToString() + "','" + HBillType + "','2'", "h_KF_UPDateICinventory_Move"); } //=========================审核反审核后负库存控制 DataSet ds2 = oCn.RunProcReturn("Exec h_p_KF_ICinventoryStockCtrl '" + lngBillKey.ToString() + "', '" + HBillType + "'", "h_p_KF_ICinventoryStockCtrl"); if (ds2 == null) { sReturn = "库存更新失败后控制判断失败！"; oCn.RollBack(); return false; } if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") { sReturn = "库存更新失败！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); oCn.RollBack(); return false; } //============================ } //写入日志 string WorkList = "反审核单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','反审核')" ); sReturn = "反审核单据成功！"; oCn.Commit(); return true; } catch (Exception e) { oCn.RollBack(); sReturn = e.Message; throw (e); } } //发起多级审批 public bool startCheckFlow(Int64 lngBillKey,ref string sReturn) { try { string HBillNo = ""; //单据号 string HCheckFlowID = ""; //审批流ID string HCheckItemNowID = ""; //当前审核项目ID string HCheckItemNextID = ""; //待审核项目ID //判断是否已经发起审批 string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + this.BillType + "'"; DataSet ds0 = oCn.RunProcReturn(sql0, "Xt_BillCheckFlowStatus"); if (ds0 != null && ds0.Tables[0].Rows.Count > 0) { sReturn = "单据已发起审批，不可重复审批！"; return false; } //获取单据数据 string sql = "select * from " + this.MvarItemKey + " where HInterID = " + lngBillKey; DataSet ds = oCn.RunProcReturn(sql, this.MvarItemKey); if (ds == null || ds.Tables[0].Rows.Count == 0) { sReturn = "单据不存在！"; return false; } HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString(); string HCheckFlowID_select = ds.Tables[0].Rows[0]["HCheckFlowID"].ToString(); //获取单据类型对应的默认审批流 string sql1 = "select b.HInterID,b.HCheckItemID from Xt_CheckFlowMain as a " + "inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " + "where a.HBillTypeID = '" + this.BillType + "' " + "and a.HInterID = " + HCheckFlowID_select + " " + "order by b.HFlowNo asc"; DataSet ds1 = oCn.RunProcReturn(sql1, "Xt_CheckFlowMain"); if (ds1 == null || ds1.Tables[0].Rows.Count == 0) { sReturn = "默认审批流不存在！"; return false; } HCheckFlowID = ds1.Tables[0].Rows[0]["HInterID"].ToString(); HCheckItemNowID = ds1.Tables[0].Rows[0]["HCheckItemID"].ToString(); if (ds1.Tables[0].Rows.Count >= 2) { HCheckItemNextID = ds1.Tables[0].Rows[1]["HCheckItemID"].ToString(); } else { HCheckItemNextID = "0"; } oCn.BeginTran(); //增加 单据审批状态表 数据 for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { string sql2 = "insert into Xt_BillCheckFlowStatus" + "(HBillTypeID,HBillInterID,HBillNo,HCheckFlowID,HCheckItemID,HChecker,HCheckDate,HCheckNote) " + "values(" + "'" + this.BillType + "'," + "" + lngBillKey + "," + "'" + HBillNo + "'," + "" + ds1.Tables[0].Rows[i]["HInterID"].ToString() + "," + "" + ds1.Tables[0].Rows[i]["HCheckItemID"].ToString() + "," + "" + "''" + "," + "" + "''" + "," + "" + "''" + "" + ")"; oCn.RunProc(sql2); } //更新主表 审批流 数据 string sql3 = "update " + this.MvarItemKey + " set HCheckFlowID = " + HCheckFlowID + ",HCheckItemNowID=" + HCheckItemNowID + ",HCheckItemNextID=" + HCheckItemNextID + ",HBillStatus=" + 6 + " where HInterID = " + lngBillKey; oCn.RunProc(sql3); oCn.Commit(); return true; } catch (Exception e) { sReturn += e.Message; return false; } } //驳回 public bool RejectCheckFlowProgress(Int64 lngBillKey, string HBillNo,string sUser, ref string sReturn) { if (isUse(lngBillKey, ref sReturn)) { return false; } try { //开启事务 oCn.BeginTran(); //判断是否存在审核过的项目 //string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + this.BillType + "' and ISNULL(HChecker,'') <> ''"; //DataSet ds0 = oCn.RunProcReturn(sql0, "Xt_BillCheckFlowStatus"); //if (ds0 != null && ds0.Tables[0].Rows.Count == 0) //{ // sReturn = "单据不存在已经审核的项目！"; // return false; //} //获取需要驳回的审核项目 string sql0 = "select c.* from Xt_CheckFlowMain as a " + "inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " + "inner join Xt_BillCheckFlowStatus as c on a.HBillTypeID = c.HBillTypeID and b.HCheckItemID = c.HCheckItemID " + "where c.HBillTypeID = '" + this.BillType + "' and c.HBillInterID = " + lngBillKey + " " + "order by b.HFlowNo asc"; DataSet ds0 = oCn.RunProcReturn(sql0, "Xt_BillCheckFlowStatus"); if (ds0 == null || ds0.Tables[0].Rows.Count == 0) { sReturn = "驳回失败!原因:未发起审批！！"; return false; } //获取当前审核项目 string HCheckFlowID = ds0.Tables[0].Rows[0]["HCheckFlowID"].ToString(); //审批流内码 sql0 = "select * from " + MvarItemKey + " where HInterID = " + lngBillKey; ds0 = oCn.RunProcReturn(sql0, MvarItemKey); string HCheckItemNowID = ds0.Tables[0].Rows[0]["HCheckItemNowID"].ToString(); //当前审批项目内码 //查找是否有权限 string sql01 = "select * from Xt_CheckUserRight where HUserID = '" + sUser + "' and HCheckFlowInterID = " + HCheckFlowID + " and HCheckItemID = " + HCheckItemNowID + ""; DataSet ds01 = oCn.RunProcReturn(sql01, "Xt_CheckUserRight"); if (ds01.Tables[0].Rows.Count == 0) { sReturn = "无权限！"; return false; } //更新 驳回删除审核流状态表 string sql02 = "Delete Xt_BillCheckFlowStatus where HBillTypeID = '" + this.BillType + "' and HBillInterID=" + lngBillKey + " and HCheckFlowID=" + HCheckFlowID; oCn.RunProc(sql02); oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=5,HCheckItemNowID = 0,HCheckItemNextID = 0 Where HInterID=" + lngBillKey.ToString()); //写入日志 string WorkList = "驳回单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','驳回')" ); sReturn = "反审核单据成功！"; oCn.Commit(); return true; } catch (Exception e) { oCn.RollBack(); sReturn = e.Message; throw (e); } } //审批流-反审核(包含反审核后控制、写入日志) 2024-01-31 public bool AbandonCheck(SQLHelper.ClsCN oCN,Int64 lngBillKey, string HBillNo, string procName, string sUser, ref string sReturn) { string sql = ""; DataSet ds; if (isUse(lngBillKey, ref sReturn)) { return false; } try { ds = oCN.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); if (ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") { oCN.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=4 Where HInterID=" + lngBillKey.ToString()); } else if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") { oCN.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=3 Where HInterID=" + lngBillKey.ToString()); } else { oCN.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=1 Where HInterID=" + lngBillKey.ToString()); } //反审核后控制 sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'"; ds = oCN.RunProcReturn(sql, procName); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { sReturn = "反审核过程中出错，请与网络管理人员联系"; return false; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString(); return false; } //反审核后 更新及时库存表 减少库存 sql = "select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(); ds = oCN.RunProcReturn(sql, MvarItemKey); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string HBillType = ds.Tables[0].Rows[0]["HBillType"].ToString(); if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1205" || HBillType == "1250" || HBillType == "1206" || HBillType == "1245" || HBillType == "1239") { //反审核更新 及时库存表 增加库存 1201 1202 1203 1247 1244 1251 1210 //反审核更新 及时库存表 减少库存 1205 1250 1206 1245 1239 ds = oCN.RunProcReturn("exec h_KF_UPDateICinventory '" + lngBillKey.ToString() + "','" + HBillType + "','2'", "h_KF_UPDateICinventory"); } } //写入日志 string WorkList = "反审核单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCN.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','反审核')" ); sReturn = "反审核单据成功！"; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //审核 public bool CheckBill(Int64 lngBillKey, ref string sReturn) { string sql = ""; DataSet ds; try { string HChecker = ClsPub.CurUserName ; string HCheckDate =ClsPub.GetServerDate(-1); oCn.RunProc(" Update " + MvarItemKey + " set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); //审核后 更新及时库存表 增加库存 sql = "select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(); ds = oCn.RunProcReturn(sql, MvarItemKey); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string HBillType = ds.Tables[0].Rows[0]["HBillType"].ToString(); if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1204") { //审核更新 及时库存表 增加库存 1201 1202 1203 1247 1244 1251 1210 //审核更新 及时库存表 减少库存 1204 ds = oCn.RunProcReturn("exec h_KF_UPDateICinventory '" + lngBillKey.ToString() + "','" + HBillType + "','1'", "h_KF_UPDateICinventory"); } //=========================审核反审核后负库存控制 DataSet ds2 = oCn.RunProcReturn("Exec h_p_KF_ICinventoryStockCtrl '" + lngBillKey.ToString() + "', '" + HBillType + "'", "h_p_KF_ICinventoryStockCtrl"); if (ds2 == null) { sReturn = "库存更新后控制判断失败！"; oCn.RollBack(); return false; } if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") { sReturn = "库存更新失败！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); oCn.RollBack(); return false; } //============================ } sReturn = ""; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //审核 public bool CheckBill(Int64 lngBillKey,string sUser, ref string sReturn) { try { string HChecker = sUser; string HCheckDate = ClsPub.GetServerDate(-1); oCn.RunProc(" Update " + MvarItemKey + " set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "' Where HInterID=" + lngBillKey.ToString()); sReturn = ""; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //审核(包含审核后控制、写入日志) 2024-01-31 public bool CheckBill(Int64 lngBillKey, string HBillNo,string procName , string sUser, ref string sReturn) { string sql = ""; DataSet ds; try { string HChecker = sUser; string HCheckDate = ClsPub.GetServerDate(-1); //开启事务 oCn.BeginTran(); //更新单据状态 oCn.RunProc(" Update " + MvarItemKey + " set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); //审核后控制 sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'"; ds = oCn.RunProcReturn(sql, procName); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { sReturn = "审核过程中出错，请与网络管理人员联系"; oCn.RollBack(); return false; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString(); oCn.RollBack(); return false; } //审核后 更新及时库存表 增加库存 sql = "select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(); ds = oCn.RunProcReturn(sql, MvarItemKey); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string HBillType = ds.Tables[0].Rows[0]["HBillType"].ToString(); if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1250" || HBillType == "1206" || HBillType == "1245" || HBillType == "1239") { //审核更新 及时库存表 增加库存 1201 1202 1203 1247 1244 1251 1210 //审核更新 及时库存表 减少库存 1204 1250 1206 1245 1239 ds = oCn.RunProcReturn("exec h_KF_UPDateICinventory '" + lngBillKey.ToString() + "','" + HBillType + "','1'", "h_KF_UPDateICinventory"); }//直接调拨单审核更新 else if (HBillType == "1207") { //更新及时库存表 减少调入库存,增加调出库存 ds = oCn.RunProcReturn("exec h_KF_UPDateICinventory_Move '" + lngBillKey.ToString() + "','" + HBillType + "','1'", "h_KF_UPDateICinventory_Move"); } //=========================审核反审核后负库存控制 DataSet ds2 = oCn.RunProcReturn("Exec h_p_KF_ICinventoryStockCtrl '" + lngBillKey.ToString() + "', '" + HBillType +"'", "h_p_KF_ICinventoryStockCtrl"); if (ds2 == null) { sReturn = "库存更新后控制判断失败！"; oCn.RollBack(); return false; } if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") { sReturn = "库存更新失败！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); oCn.RollBack(); return false; } //============================ } //写入日志 string WorkList = "审核单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','"+SystemName+"','" + IPAddress + "','审核')" ); sReturn = "审核单据成功！"; oCn.Commit(); return true; } catch (Exception e) { oCn.RollBack(); sReturn = e.Message; throw (e); } } //审批流-审核(包含审核后控制、写入日志) 2024-01-31 public bool CheckBill(SQLHelper.ClsCN oCN,Int64 lngBillKey, string HBillNo, string procName, string sUser, ref string sReturn) { string sql = ""; DataSet ds; try { string HChecker = sUser; string HCheckDate = ClsPub.GetServerDate(-1); //更新单据状态 oCN.RunProc(" Update " + MvarItemKey + " set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); //审核后控制 sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'"; ds = oCN.RunProcReturn(sql, procName); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { sReturn = "审核过程中出错，请与网络管理人员联系"; return false; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString(); return false; } //审核后 更新及时库存表 增加库存 sql = "select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(); ds = oCN.RunProcReturn(sql, MvarItemKey); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string HBillType = ds.Tables[0].Rows[0]["HBillType"].ToString(); if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1250" || HBillType == "1206" || HBillType == "1245" || HBillType == "1239") { //审核更新 及时库存表 增加库存 1201 1202 1203 1247 1244 1251 1210 //审核更新 及时库存表 减少库存 1204 1250 1206 1245 1239 ds = oCN.RunProcReturn("exec h_KF_UPDateICinventory '" + lngBillKey.ToString() + "','" + HBillType + "','1'", "h_KF_UPDateICinventory"); } } //写入日志 string WorkList = "审核单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCN.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','审核')" ); sReturn = "审核单据成功！"; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //关闭 public bool CloseBill(Int64 lngBillKey, ref string sReturn) { try { string HCloseMan = ClsPub.CurUserName; string HCloseDate = ClsPub.GetServerDate(-1); oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='" + HCloseMan + "',HCloseDate='" + HCloseDate + "',HBillStatus=3,HCloseType = 1 Where HInterID=" + lngBillKey.ToString()); sReturn = ""; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //关闭单据(包含写入日志) 2024-01-31 public bool CloseBill(Int64 lngBillKey, string HBillNo, string sUser, ref string sReturn) { try { oCn.BeginTran(); string HCloseMan = sUser; string HCloseDate = ClsPub.GetServerDate(-1); oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='" + HCloseMan + "',HCloseDate='" + HCloseDate + "',HBillStatus=3,HCloseType = 1 Where HInterID=" + lngBillKey.ToString()); //写入日志 string WorkList = "关闭单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','关闭')" ); sReturn = "关闭单据成功！"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //行关闭单据（行关闭后控制）(包含写入日志) 2024-01-31 public bool CloseRow(Int64 lngBillKey, Int64 HEntryID, string HBillNo, string sUser, string procName, ref string sReturn) { DataSet ds; try { oCn.BeginTran(); string HCloseMan = sUser; string HEntryCloseDate = ClsPub.GetServerDate(-1); //变更行关闭状态 string sql = " Update " + MvarItemKeySub + " set HCloseMan='" + HCloseMan + "',HEntryCloseDate='" + HEntryCloseDate + "',HCloseType=1 Where HInterID=" + lngBillKey.ToString() + " and HEntryID = " + HEntryID; oCn.RunProc(sql); //检查单据子表所有行是否都关闭，若都关闭则自动关闭单据 //sql = "select * from " + MvarItemKeySub + " where HInterID=" + lngBillKey + " and HCloseMan=''"; //ds = oCn.RunProcReturn(sql, MvarItemKeySub); //if(ds!=null && ds.Tables[0].Rows.Count == 0) //{ // sql = " Update " + MvarItemKey + " set HCloseMan='" + HCloseMan + "',HCloseDate=getdate(),HBillStatus=3,HCloseType = 0 Where HInterID=" + lngBillKey.ToString(); // oCn.RunProc(sql); //} //写入日志 string WorkList = "行关闭，单据号：" + HBillNo + "；子表内码：" + HEntryID; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','行关闭')" ); //行关闭后控制========================================= string sql_afterClose = "exec " + procName + " " + lngBillKey + "," + HEntryID + ",'" + HBillNo + "','" + sUser + "'"; DataSet ds_afterClose = oCn.RunProcReturn(sql_afterClose, procName); if (ds_afterClose == null || ds_afterClose.Tables[0].Rows.Count <= 0) { sReturn = "行关闭失败，原因：行关闭后控制错误，请联系网络管理人员！"; oCn.RollBack(); return false; } else { if (ds_afterClose.Tables[0].Rows[0]["HBack"].ToString() != "0") { sReturn = "关闭失败，原因：" + ds_afterClose.Tables[0].Rows[0]["HRemark"].ToString(); oCn.RollBack(); return false; } } //========================================= sReturn = "行关闭成功！"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //行关闭单据(包含写入日志) 2024-01-31 public bool CloseRow(Int64 lngBillKey,Int64 HEntryID, string HBillNo, string sUser, ref string sReturn) { DataSet ds; try { oCn.BeginTran(); string HCloseMan = sUser; string HEntryCloseDate = ClsPub.GetServerDate(-1); //变更行关闭状态 string sql = " Update " + MvarItemKeySub + " set HCloseMan='" + HCloseMan + "',HEntryCloseDate='" + HEntryCloseDate + "',HCloseType=1 Where HInterID=" + lngBillKey.ToString() + " and HEntryID = " + HEntryID; oCn.RunProc(sql); //检查单据子表所有行是否都关闭，若都关闭则自动关闭单据 //sql = "select * from " + MvarItemKeySub + " where HInterID=" + lngBillKey + " and HCloseMan=''"; //ds = oCn.RunProcReturn(sql, MvarItemKeySub); //if(ds!=null && ds.Tables[0].Rows.Count == 0) //{ // sql = " Update " + MvarItemKey + " set HCloseMan='" + HCloseMan + "',HCloseDate=getdate(),HBillStatus=3,HCloseType = 0 Where HInterID=" + lngBillKey.ToString(); // oCn.RunProc(sql); //} //写入日志 string WorkList = "行关闭，单据号：" + HBillNo + "；子表内码：" + HEntryID; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','行关闭')" ); sReturn = "行关闭成功！"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //作废 public bool Cancelltion(Int64 lngBillKey, ref string sReturn) { try { string HDeleteMan = ClsPub.CurUserName; string HDeleteDate = ClsPub.GetServerDate(-1); oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='" + HDeleteMan + "',HDeleteDate='" + HDeleteDate + "',HBillStatus=4 Where HInterID=" + lngBillKey.ToString()); sReturn = ""; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //作废单据(包含写入日志) 2024-01-31 public bool Cancelltion(Int64 lngBillKey, string HBillNo, string sUser, ref string sReturn) { try { oCn.BeginTran(); string HDeleteMan = sUser; string HDeleteDate = ClsPub.GetServerDate(-1); oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='" + HDeleteMan + "',HDeleteDate='" + HDeleteDate + "',HBillStatus=4 Where HInterID=" + lngBillKey.ToString()); //写入日志 string WorkList = "作废单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','作废')" ); sReturn = "作废单据成功！"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //作废(包含作废后控制、写入日志) 2025-03-10 public bool Cancelltion(Int64 lngBillKey, string HBillNo, string procName, string sUser, ref string sReturn) { string sql = ""; DataSet ds; if (isUse(lngBillKey, ref sReturn)) { return false; } try { //开启事务 oCn.BeginTran(); string HDeleteMan = sUser; string HDeleteDate = ClsPub.GetServerDate(-1); oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='" + HDeleteMan + "',HDeleteDate='" + HDeleteDate + "',HBillStatus=4 Where HInterID=" + lngBillKey.ToString()); //作废后控制 sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'"; ds = oCn.RunProcReturn(sql, procName); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { sReturn = "作废过程中出错，请与网络管理人员联系"; oCn.RollBack(); return false; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString(); oCn.RollBack(); return false; } //写入日志 string WorkList = "作废单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','作废')" ); sReturn = "作废单据成功！"; oCn.Commit(); return true; } catch (Exception e) { oCn.RollBack(); sReturn = e.Message; throw (e); } } //保养计划删除子表1 public void DeleteBillSub(Int64 lngBillKey) { oCn.RunProc("Delete From " + MvarItemKeySub + " where HInterID=" + lngBillKey.ToString()); } //保养计划删除子表2 public void DeleteBillSub2(Int64 lngBillKey) { if (MvarItemKeySub2 != "") { oCn.RunProc("Delete From " + MvarItemKeySub2 + " where HInterID=" + lngBillKey.ToString()); } } //删除子表 public void DeleteBillSub3(Int64 lngBillKey) { if (MvarItemKeySub3 != "") { oCn.RunProc("Delete From " + MvarItemKeySub3 + " where HInterID=" + lngBillKey.ToString()); } } //删除子表 public void DeleteBillSub4(Int64 lngBillKey) { if (MvarItemKeySub4 != "") { oCn.RunProc("Delete From " + MvarItemKeySub4 + " where HInterID=" + lngBillKey.ToString()); } } //删除主表 public void DeleteBillMain(Int64 lngBillKey) { oCn.RunProc("Delete From " + MvarItemKey + " where HInterID=" + lngBillKey.ToString()); } //删除单据 public virtual bool DeleteBill(Int64 lngBillKey, ref string sReturn) { try { oCn.BeginTran(); //删除关联 DeleteRelation(ref sReturn, lngBillKey); //删除明细表 DeleteBillSub(lngBillKey); DeleteBillSub2(lngBillKey); DeleteBillSub3(lngBillKey); DeleteBillSub4(lngBillKey); //删除主表 DeleteBillMain(lngBillKey); sReturn = "删除单据成功！"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //删除单据(包含删除后控制、写入日志) 2024-01-31 public bool DeleteBill(Int64 lngBillKey, string HBillNo, string procName, string sUser, ref string sReturn) { string sql = ""; DataSet ds; try { oCn.BeginTran(); //删除关联 DeleteRelation(ref sReturn, lngBillKey); //删除明细表 DeleteBillSub(lngBillKey); DeleteBillSub2(lngBillKey); DeleteBillSub3(lngBillKey); DeleteBillSub4(lngBillKey); //删除主表 DeleteBillMain(lngBillKey); //删除后控制 sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'"; ds = oCn.RunProcReturn(sql, procName); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { sReturn = "删除过程中出错，请与网络管理人员联系"; oCn.RollBack(); return false; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString(); oCn.RollBack(); return false; } //写入日志 string WorkList = "删除单据，单据号：" + HBillNo; string SystemName = "LMES-" + MvarReportTitle + "模块"; oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','删除')" ); sReturn = "删除单据成功！"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //是否被关联 public bool isUse(Int64 lngBillKey, ref string sReturn) { try { //查询主表 DataSet Ds ; Ds = oCn.RunProcReturn("Select HinterID from " + MvarItemKeySub + " Where HInterID=" + lngBillKey.ToString() + " and isnull(HRelationQty,0)<>0 ", MvarItemKey); if (Ds.Tables[0].Rows.Count != 0) { sReturn = "单据已被关联,不能操作！"; return true; } sReturn = ""; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //读取下张单据 public bool GetNextBill(ref string sReturn,string HBillNo) { try { //查询主表 Int64 lMainID = 0; DataSet Ds ; Ds = oCn.RunProcReturn("Select Top 1 HinterID from " + MvarItemKey + " Where HBillNo>'" + HBillNo + "' and HBillType='" + this.BillType + "' Order By HInterID ", MvarItemKey); if (Ds.Tables[0].Rows.Count != 0) { lMainID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()); if (lMainID != 0) { if (ShowBill(lMainID, ref sReturn)) { sReturn = "查询下张单据成功"; return true; } } } sReturn = "查询下张单据失败"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //读取上张单据 public bool GetPrevousBill(ref string sReturn, string HBillNo) { try { //查询主表 Int64 lMainID = 0; DataSet Ds ; Ds = oCn.RunProcReturn("Select Top 1 HinterID from " + MvarItemKey + " Where HBillNo<'" + HBillNo + "' and HBillType='" + BillType + "' Order By HInterID Desc", MvarItemKey); if (Ds.Tables[0].Rows.Count != 0) { lMainID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()); if (lMainID != 0) { if (ShowBill(lMainID, ref sReturn)) { sReturn = "查询上张单据成功"; return true; } } } sReturn = "查询上张单据失败"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //读取首张单据 public bool GetFirstBill(ref string sReturn) { try { //查询主表 Int64 lMainID = 0; DataSet Ds ; Ds = oCn.RunProcReturn("Select Top 1 HinterID from " + MvarItemKey + " Where HBillType='" + BillType + "' Order By HInterID ", MvarItemKey); if (Ds.Tables[0].Rows.Count != 0) { lMainID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()); if (lMainID != 0) { if (ShowBill(lMainID, ref sReturn)) { sReturn = "查询首张单据成功"; return true; } } } sReturn = "查询首张单据失败"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //读取末张单据 public bool GetLastBill(ref string sReturn) { try { //查询主表 Int64 lMainID = 0; DataSet Ds ; Ds = oCn.RunProcReturn("Select Top 1 HinterID from " + MvarItemKey + " Where HBillType='" + BillType + "' Order By HInterID Desc", MvarItemKey); if (Ds.Tables[0].Rows.Count != 0) { lMainID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()); if (lMainID != 0) { if (ShowBill(lMainID, ref sReturn)) { sReturn = "查询末张单据成功"; return true; } } } sReturn = "查询末张单据失败"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //MAINID是否重复 public virtual bool IsExistMainID(ref string sReturn, Int64 lngBillKey, ClsPub.Enum_BillStatus oBillStatus) { try { string sSql = ""; if (oBillStatus == ClsPub.Enum_BillStatus.BillStatus_AddNew) { sSql = "Select HInterID from " + MvarItemKey + " where HInterID =" + lngBillKey + ""; DataSet Ds; Ds = oCn.RunProcReturn(sSql, " + MvarItemKey + "); if (Ds.Tables[0].Rows.Count != 0) { sReturn = "ID重复"; return true; } } sReturn = "ID未重复"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //K3单据号是否重复 public bool IsExistBillNoK3(ref string sReturn, string sBillNo, ClsPub.Enum_BillStatus oBillStatus, Int64 lngBillKey) { try { string sSql = ""; if (oBillStatus == ClsPub.Enum_BillStatus.BillStatus_AddNew) { sSql = "Select FInterID from " + MvarItemKey + " where ftrantype='" + BillType + "'and FBillNO ='" + sBillNo + "'"; } else { sSql = "Select FInterID from " + MvarItemKey + " where ftrantype='" + BillType + "'and FBillNO ='" + sBillNo + "' and FInterID<>" + lngBillKey.ToString(); } DataSet Ds; Ds = oCnK3.RunProcReturn(sSql, " + MvarItemKey + "); if (Ds.Tables[0].Rows.Count != 0) { sReturn = "单号重复"; return true; } sReturn = "单号未重复"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //单据号是否重复 public virtual bool IsExistBillNo(ref string sReturn, string sBillNo, ClsPub.Enum_BillStatus oBillStatus, Int64 lngBillKey) { string sSql = ""; try { if (oBillStatus == ClsPub.Enum_BillStatus.BillStatus_AddNew) { sSql = "Select HInterID from " + MvarItemKey + " where hbilltype='" + BillType + "'and HBillNO ='" + sBillNo + "'"; } else { sSql = "Select HInterID from " + MvarItemKey + " where hbilltype='" + BillType + "'and HBillNO ='" + sBillNo + "' and HInterID<>" + lngBillKey.ToString(); } DataSet Ds ; Ds = oCn.RunProcReturn(sSql, " + MvarItemKey + "); if (Ds.Tables[0].Rows.Count != 0) { sReturn = "单号重复"; return true; } sReturn = "单号未重复"; return false; } catch (Exception e) { sReturn = e.Message+"sql:"+ sSql; return false; } } #endregion //修改单据 public virtual bool ModifyBill(Int64 lngBillKey, ref string sReturn) { return true; } //新增单据 public virtual bool AddBill( ref string sReturn) { return true; } //显示单据 public virtual bool ShowBill(Int64 lngBillKey, ref string sReturn) { return true; } //删除关联 public virtual void DeleteRelation(ref string sReturn, Int64 lngBillKey) { sReturn = ""; return; } //新增关联 public virtual void AddNewRelation(ref string sReturn, Int64 lngBillKey) { sReturn = ""; return; } //读取下张单据K3 public bool GetNextBillK3(ref string sReturn, string HBillNo) { try { //查询主表 Int64 lMainID = 0; DataSet Ds; Ds = oCnK3.RunProcReturn("Select Top 1 FinterID from " + MvarItemKey + " Where FBillNo>'" + HBillNo + "' and FTranType='" + this.BillType + "' Order By FInterID ", MvarItemKey); if (Ds.Tables[0].Rows.Count != 0) { lMainID = ClsPub.isLong(Ds.Tables[0].Rows[0]["FInterID"].ToString()); if (lMainID != 0) { if (ShowBill(lMainID, ref sReturn)) { sReturn = "查询下张单据成功"; return true; } } } sReturn = "查询下张单据失败"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //读取首张单据K3 public bool GetFirstBillK3(ref string sReturn) { try { //查询主表 Int64 lMainID = 0; DataSet Ds; Ds = oCnK3.RunProcReturn("Select Top 1 FinterID from " + MvarItemKey + " Where FTranType='" + BillType + "' Order By FInterID ", MvarItemKey); if (Ds.Tables[0].Rows.Count != 0) { lMainID = ClsPub.isLong(Ds.Tables[0].Rows[0]["FInterID"].ToString()); if (lMainID != 0) { if (ShowBill(lMainID, ref sReturn)) { sReturn = "查询首张单据成功"; return true; } } } sReturn = "查询首张单据失败"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //读取末张单据K3 public bool GetLastBillK3(ref string sReturn) { try { //查询主表 Int64 lMainID = 0; DataSet Ds; Ds = oCnK3.RunProcReturn("Select Top 1 FinterID from " + MvarItemKey + " Where FTranType='" + BillType + "' Order By FInterID Desc", MvarItemKey); if (Ds.Tables[0].Rows.Count != 0) { lMainID = ClsPub.isLong(Ds.Tables[0].Rows[0]["FInterID"].ToString()); if (lMainID != 0) { if (ShowBill(lMainID, ref sReturn)) { sReturn = "查询末张单据成功"; return true; } } } sReturn = "查询末张单据失败"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //读取上张单据K3 public bool GetPrevousBillK3(ref string sReturn, string HBillNo) { try { //查询主表 Int64 lMainID = 0; DataSet Ds; Ds = oCnK3.RunProcReturn("Select Top 1 FinterID from " + MvarItemKey + " Where FBillNo<'" + HBillNo + "' and FTranType='" + BillType + "' Order By FInterID Desc", MvarItemKey); if (Ds.Tables[0].Rows.Count != 0) { lMainID = ClsPub.isLong(Ds.Tables[0].Rows[0]["FInterID"].ToString()); if (lMainID != 0) { if (ShowBill(lMainID, ref sReturn)) { sReturn = "查询上张单据成功"; return true; } } } sReturn = "查询上张单据失败"; return false; } catch (Exception e) { sReturn = e.Message; throw (e); } } //显示单据头 public DataSet ShowBillMain(Int64 lngBillKey,string sShowItem, ref string sReturn) { string s = ""; try { //查询主表 DataSet Ds; s = "Select " + sShowItem + " from " + MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString(); Ds = oCn.RunProcReturn("Select " + sShowItem + " from " + MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString(), MvarItemKeyForWeb); if (Ds==null || Ds.Tables[0].Rows.Count == 0) { sReturn = "单据头未找到！"; return null; } sReturn = "显示单据头成功！"; return Ds; } catch (Exception e) { sReturn = e.Message; return null; } } //显示单据头2 public DataSet ShowBillMain(Int64 lngBillKey, Int64 HEntryID, string sShowItem, ref string sReturn) { string s = ""; try { //查询主表 DataSet Ds; s = "Select " + sShowItem + " from " + MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString() + " and HEntryID=" + HEntryID; Ds = oCn.RunProcReturn("Select " + sShowItem + " from " + MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString() + " and HEntryID=" + HEntryID, MvarItemKeyForWeb); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { sReturn = "单据头未找到！"; return null; } sReturn = "显示单据头成功！"; return Ds; } catch (Exception e) { sReturn = e.Message; return null; } } //显示单体 public DataSet ShowBillSub(Int64 lngBillKey, string sShowItem, ref string sReturn) { string s = ""; try { //查询主表 DataSet Ds; s = "Select " + sShowItem + " from " + MvarItemKeySubForWeb + " Where HInterID=" + lngBillKey.ToString() + " order by HEntryID "; Ds = oCn.RunProcReturn("Select " + sShowItem + " from " + MvarItemKeySubForWeb + " Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", MvarItemKeySubForWeb); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { sReturn = "单据体未找到！"; return null; } sReturn = "显示单据体成功！"; return Ds; } catch (Exception e) { sReturn = e.Message + s ; return null; } } //显示表体 public DataSet ShowBillSub(Int64 lngBillKey, Int64 HEntryID, string sShowItem, ref string sReturn) { string s = ""; try { //查询主表 DataSet Ds; s = "Select " + sShowItem + " from " + MvarItemKeySubForWeb + " Where HInterID=" + lngBillKey.ToString() + " and HEntryID=" + HEntryID + " order by HEntryID "; Ds = oCn.RunProcReturn("Select " + sShowItem + " from " + MvarItemKeySubForWeb + " Where HInterID=" + lngBillKey.ToString() + " and HEntryID=" + HEntryID + " order by HEntryID ", MvarItemKeySubForWeb); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { sReturn = "单据体未找到！"; return null; } sReturn = "显示单据体成功！"; return Ds; } catch (Exception e) { sReturn = e.Message + s; return null; } } //显示表体2 public DataSet ShowBillSub2(Int64 lngBillKey, Int64 HEntryID, string sShowItem, ref string sReturn) { string s = ""; try { //查询主表 DataSet Ds; s = "Select " + sShowItem + " from " + MvarItemKeySubForWeb2 + " Where HInterID=" + lngBillKey.ToString() + " and HEntryID=" + HEntryID + " order by HEntryID "; Ds = oCn.RunProcReturn("Select " + sShowItem + " from " + MvarItemKeySubForWeb2 + " Where HInterID=" + lngBillKey.ToString() + " and HEntryID=" + HEntryID + " order by HEntryID ", MvarItemKeySubForWeb2); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { sReturn = "单据体未找到！"; return null; } sReturn = "显示单据体成功！"; return Ds; } catch (Exception e) { sReturn = e.Message + s; return null; } } //更新打印次数 public void UpDatePrintQty(Int64 lngBillKey, ref string sReturn) { try { oCn.RunProc(" Update " + MvarItemKey + " set HPrintQty=HPrintQty + 1 Where HInterID=" + lngBillKey.ToString()); sReturn = ""; } catch (Exception e) { sReturn = e.Message; throw (e); } } } }