New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | using System.Data; |
| | | |
| | | namespace DAL |
| | | { |
| | | public class ClsPM_WorkTaskWeekBill : DBUtility.ClsXt_BaseBill |
| | | { |
| | | public Model.ClsPM_WorkTaskWeekBillMain omodel = new Model.ClsPM_WorkTaskWeekBillMain(); |
| | | public List<Model.ClsPM_WorkTaskWeekBillSub> DetailColl = new List<Model.ClsPM_WorkTaskWeekBillSub>(); |
| | | |
| | | public ClsPM_WorkTaskWeekBill() |
| | | { |
| | | base.MvarItemKeySub = "PM_WorkTaskWeekBillSub"; |
| | | base.MvarItemKeySub2 = ""; |
| | | base.MvarItemKeySub3 = ""; |
| | | base.MvarItemKeySub4 = ""; |
| | | base.MvarItemKey= "PM_WorkTaskWeekBillMain"; |
| | | base.MvarReportTitle="å·¥ä½å¨è®¡å"; |
| | | base.BillType="4756"; |
| | | base.HBillSubType = "4756"; |
| | | |
| | | } |
| | | |
| | | #region åºå®ä»£ç |
| | | #region æ åæé 彿° |
| | | ~ClsPM_WorkTaskWeekBill() |
| | | { |
| | | DetailColl = null; |
| | | } |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region ä¿®æ¹åæ® |
| | | public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //æ´æ°ä¸»è¡¨ |
| | | string mainSql = "update PM_WorkTaskWeekBillMain set " + |
| | | " HBillNo = '" + omodel.HBillNo + |
| | | "', HDate = '" + omodel.HDate + |
| | | "', HYear = " + omodel.HYear + |
| | | ", HPeriod = " + omodel.HPeriod + |
| | | ", HRemark = '" + omodel.HRemark + |
| | | "', HUpDater = '" + omodel.HUpDater + |
| | | "', HUpDateDate = getdate()" + |
| | | //=============================================================== |
| | | ", HOrgID = " + omodel.HOrgID + |
| | | ", HYear = " + omodel.HYear + |
| | | ", HWeek = " + omodel.HWeek + |
| | | ", HBeginDate = '" + omodel.HBeginDate + |
| | | "', HEndDate = '" + omodel.HEndDate + |
| | | "', HPlanEmpID = " + omodel.HPlanEmpID + |
| | | " where HInterID = " + omodel.HInterID; |
| | | |
| | | //å é¤å
³è |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | | //å é¤å表 |
| | | DeleteBillSub(lngBillKey); |
| | | |
| | | //æå
¥å表 |
| | | omodel.HInterID = lngBillKey; |
| | | foreach (Model.ClsPM_WorkTaskWeekBillSub oSub in DetailColl) |
| | | { |
| | | string subSql = "insert into PM_WorkTaskWeekBillSub" + |
| | | "(HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HWeekDay,HSno,HProjectID,HProjectStageID,HTaskNote,HPlanTimes) " + |
| | | " values(" + |
| | | "" + omodel.HInterID.ToString() + |
| | | "," + oSub.HEntryID.ToString() + |
| | | ",'" + oSub.HCloseMan + |
| | | "','" + oSub.HEntryCloseDate + |
| | | "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + |
| | | ",'" + oSub.HRemark + |
| | | "'," + oSub.HSourceInterID + |
| | | "," + oSub.HSourceEntryID + |
| | | ",'" + oSub.HSourceBillNo + |
| | | "','" + oSub.HSourceBillType + |
| | | "'," + oSub.HRelationQty + |
| | | "," + oSub.HRelationMoney + |
| | | "," + oSub.HWeekDay + |
| | | "," + oSub.HSno + |
| | | "," + oSub.HProjectID + |
| | | "," + oSub.HProjectStageID + |
| | | ",'" + oSub.HTaskNote + |
| | | "'," + oSub.HPlanTimes + |
| | | ")"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | | |
| | | sReturn = "ä¿®æ¹åæ®æåï¼"; |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ°å¢åæ® |
| | | public override bool AddBill(ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | DataSet ds; |
| | | |
| | | |
| | | oCn.BeginTran(); |
| | | |
| | | //æ£æ¥ä¸»è¡¨å
ç æ¯å¦éå¤ï¼è¥éå¤åéæ°çæå¹¶ç»§ç»æ£æ¥ï¼ç´å°ä¸åéå¤ |
| | | while (true) |
| | | { |
| | | ds = oCn.RunProcReturn("select * from PM_WorkTaskWeekBillMain where HInterID = " + omodel.HInterID, "PM_WorkTaskWeekBillMain"); |
| | | if(ds!=null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | | break; |
| | | } |
| | | } |
| | | |
| | | //æå
¥ä¸»è¡¨ |
| | | string mainSql = "insert into PM_WorkTaskWeekBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HRemark,HMaker,HMakeDate" + |
| | | ",HOrgID,HWeek,HBeginDate,HEndDate,HPlanEmpID) " + |
| | | "values(" + |
| | | "" + omodel.HYear.ToString() + |
| | | "," + omodel.HPeriod.ToString() + |
| | | ",'" + this.BillType + |
| | | "','" + this.HBillSubType + |
| | | "'," + omodel.HInterID + |
| | | ",'" + omodel.HDate + |
| | | "','" + omodel.HBillNo + |
| | | "','" + omodel.HRemark + |
| | | "','" + omodel.HMaker + |
| | | "','" + omodel.HMakeDate + |
| | | "'," + omodel.HOrgID + |
| | | "," + omodel.HWeek + |
| | | ",'" + omodel.HBeginDate + |
| | | "','" + omodel.HEndDate + |
| | | "'," + omodel.HPlanEmpID + |
| | | ")"; |
| | | |
| | | oCn.RunProc(mainSql); |
| | | |
| | | //æå
¥å表 |
| | | foreach (Model.ClsPM_WorkTaskWeekBillSub oSub in DetailColl) |
| | | { |
| | | string subSql = "insert into PM_WorkTaskWeekBillSub" + |
| | | "(HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HWeekDay,HSno,HProjectID,HProjectStageID,HTaskNote,HPlanTimes) " + |
| | | " values(" + |
| | | "" + omodel.HInterID.ToString() + |
| | | "," + oSub.HEntryID.ToString() + |
| | | ",'" + oSub.HCloseMan + |
| | | "','" + oSub.HEntryCloseDate + |
| | | "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + |
| | | ",'" + oSub.HRemark + |
| | | "'," + oSub.HSourceInterID + |
| | | "," + oSub.HSourceEntryID + |
| | | ",'" + oSub.HSourceBillNo + |
| | | "','" + oSub.HSourceBillType + |
| | | "'," + oSub.HRelationQty + |
| | | "," + oSub.HRelationMoney + |
| | | "," + oSub.HWeekDay + |
| | | "," + oSub.HSno + |
| | | "," + oSub.HProjectID + |
| | | "," + oSub.HProjectStageID + |
| | | ",'" + oSub.HTaskNote + |
| | | "'," + oSub.HPlanTimes + |
| | | ")"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | | sReturn = "æ°å¢åæ®æåï¼"; |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ¾ç¤ºåæ® |
| | | public override bool ShowBill(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | //æ¥è¯¢ä¸»è¡¨ |
| | | DataSet Ds ; |
| | | Ds = oCn.RunProcReturn("select * from PM_WorkTaskWeekBillMain Where HInterID = " + lngBillKey.ToString(), "PM_WorkTaskWeekBillMain"); |
| | | if(Ds.Tables[0].Rows.Count==0) |
| | | { |
| | | sReturn = "åæ®æªæ¾å°ï¼"; |
| | | return false; |
| | | } |
| | | |
| | | //åºå®èµå¼=========================================== |
| | | omodel.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HYear"]); |
| | | omodel.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPeriod"]); |
| | | omodel.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillType"]); |
| | | omodel.HBillSubType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillSubType"]); |
| | | omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]); |
| | | omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]); |
| | | omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim(); |
| | | omodel.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HBillStatus"]); |
| | | omodel.HCheckItemNowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNowID"]); |
| | | omodel.HCheckItemNextID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNextID"]); |
| | | omodel.HCheckFlowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckFlowID"]); |
| | | omodel.HRemark = Ds.Tables[0].Rows[0]["HRemark"].ToString().Trim(); |
| | | omodel.HBackDate = Ds.Tables[0].Rows[0]["HBackDate"].ToString().Trim(); |
| | | omodel.HBacker = Ds.Tables[0].Rows[0]["HBacker"].ToString().Trim(); |
| | | omodel.HCheckDate = Ds.Tables[0].Rows[0]["HCheckDate"].ToString().Trim(); |
| | | omodel.HChecker = Ds.Tables[0].Rows[0]["HChecker"].ToString().Trim(); |
| | | omodel.HMaker = Ds.Tables[0].Rows[0]["HMaker"].ToString().Trim(); |
| | | omodel.HMakeDate = Ds.Tables[0].Rows[0]["HMakeDate"].ToString().Trim(); |
| | | omodel.HUpDateDate = Ds.Tables[0].Rows[0]["HUpDateDate"].ToString().Trim(); |
| | | omodel.HUpDater = Ds.Tables[0].Rows[0]["HUpDater"].ToString().Trim(); |
| | | omodel.HCloseDate = Ds.Tables[0].Rows[0]["HCloseDate"].ToString().Trim(); |
| | | omodel.HCloseMan = Ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim(); |
| | | omodel.HCloseType = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HCloseType"]); |
| | | omodel.HDeleteDate = Ds.Tables[0].Rows[0]["HDeleteDate"].ToString().Trim(); |
| | | omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim(); |
| | | //======================================================== |
| | | |
| | | omodel.HOrgID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HOrgID"]); |
| | | omodel.HWeek = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HWeek"]); |
| | | omodel.HBeginDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBeginDate"]); |
| | | omodel.HEndDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HEndDate"]); |
| | | omodel.HPlanEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPlanEmpID"]); |
| | | |
| | | // |
| | | |
| | | //å¾ªç¯ |
| | | DataSet DsSub ; |
| | | DsSub = oCn.RunProcReturn("select * from PM_WorkTaskWeekBillSub where HInterID = " + lngBillKey.ToString() + "order by HEntryID", "PM_WorkTaskWeekBillSub"); |
| | | DetailColl.Clear();//æ¸
空 |
| | | for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) |
| | | { |
| | | Model.ClsPM_WorkTaskWeekBillSub oSub = new Model.ClsPM_WorkTaskWeekBillSub(); |
| | | // åºå®èµå¼=============================================== |
| | | oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); |
| | | oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); |
| | | oSub.HSourceInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceInterID"]); |
| | | oSub.HSourceEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceEntryID"]); |
| | | oSub.HSourceBillType = DsSub.Tables[0].Rows[i]["HSourceBillType"].ToString().Trim(); |
| | | oSub.HSourceBillNo = DsSub.Tables[0].Rows[i]["HSourceBillNo"].ToString().Trim(); |
| | | oSub.HRelationQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty"]); |
| | | oSub.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationMoney"]); |
| | | oSub.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HCloseMan"]); |
| | | oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[i]["HCloseType"]); |
| | | oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HEntryCloseDate"]); |
| | | oSub.HRemark = DsSub.Tables[0].Rows[i]["HRemark"].ToString().Trim(); |
| | | //=================================================== |
| | | oSub.HWeekDay = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HWeekDay"]); |
| | | oSub.HSno = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSno"]); |
| | | oSub.HProjectID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HProjectID"]); |
| | | oSub.HProjectStageID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HProjectStageID"]); |
| | | oSub.HTaskNote = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HTaskNote"]); |
| | | oSub.HPlanTimes = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HPlanTimes"]); |
| | | |
| | | DetailColl.Add(oSub); |
| | | } |
| | | sReturn = "æ¾ç¤ºåæ®æåï¼"; |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | throw (e); |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | } |
| | | |
| | | } |