File was renamed from WebAPI/Controllers/¹¤×ʹÜÀí/Gy_ClassTimePrjGroupController.cs |
| | |
| | | public DataSet ds = new DataSet(); |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DAL.ClsGy_ClassTimePrjGroup_Ctl oClassTimePrj = new DAL.ClsGy_ClassTimePrjGroup_Ctl(); |
| | | DAL.ClsGy_ClassTimePrjGroup_View oClassTimePrjHlp = new DAL.ClsGy_ClassTimePrjGroup_View(); |
| | | DAL.ClsGy_ClassTimePrjGroup_Ctl oBill = new DAL.ClsGy_ClassTimePrjGroup_Ctl(); |
| | | DAL.ClsGy_ClassTimePrjGroup_View oBillHlp = new DAL.ClsGy_ClassTimePrjGroup_View(); |
| | | |
| | | |
| | | #region æ ¸ç®æ¹å¼ç»å表 |
| | |
| | | } |
| | | |
| | | //夿å卿§ |
| | | if (oClassTimePrjHlp.GetInfoByID(HItemID)) |
| | | if (oBillHlp.GetInfoByID(HItemID)) |
| | | { |
| | | //夿æ¯å¦åå¨å项 |
| | | if (oClassTimePrj.HavChildCodes(HItemID)) |
| | | if (oBill.HavChildCodes(HItemID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | return objJsonResult; |
| | | } |
| | | //å 餿°æ® |
| | | if (oClassTimePrj.DeleteByID(HItemID)) |
| | | if (oBill.DeleteByID(HItemID)) |
| | | { |
| | | //åå
¥æ¥å¿ |
| | | DBUtility.ClsPub.Add_Log("", "å 餿 ¸ç®æ¹å¼ç»ï¼ä»£ç ï¼" + oClassTimePrjHlp.omodel.HNumber + ",åç§°ï¼" + oClassTimePrjHlp.omodel.HName, HMaker); |
| | | DBUtility.ClsPub.Add_Log("", "å 餿 ¸ç®æ¹å¼ç»ï¼ä»£ç ï¼" + oBillHlp.omodel.HNumber + ",åç§°ï¼" + oBillHlp.omodel.HName, HMaker); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å 餿 ¸ç®æ¹å¼ç»æåï¼"; |
| | |
| | | |
| | | if (IsAudit == 0) //å®¡æ ¸å¤æ |
| | | { |
| | | if (oClassTimePrj.CheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | if (oBill.CheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | } |
| | | else if (IsAudit == 1) //åå®¡æ ¸å¤æ |
| | | { |
| | | if (oClassTimePrj.AbandonCheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | if (oBill.AbandonCheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | |
| | | if (IsStop == 0) //ç¦ç¨å¤æ |
| | | { |
| | | if (oClassTimePrj.StopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | if (oBill.StopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | } |
| | | else if (IsStop == 1) //åç¦ç¨å¤æ |
| | | { |
| | | if (oClassTimePrj.AbandonStopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | if (oBill.AbandonStopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | msg2 = msg2.Replace("\n", ""); |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Model.ClsGy_ClassTimePrjGroup_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_ClassTimePrjGroup_Model>>(msg2); |
| | | oClassTimePrj.oModel.HItemID = list[0].HItemID; |
| | | oClassTimePrj.oModel.HNumber = list[0].HNumber; |
| | | oClassTimePrj.oModel.HName = list[0].HName; |
| | | oClassTimePrj.oModel.HShortNumber = DBUtility.ClsPub.GetShortNumber(list[0].HNumber); |
| | | oClassTimePrj.oModel.HLevel = DBUtility.ClsPub.GetLevel(list[0].HNumber); |
| | | oClassTimePrj.oModel.HEndFlag = true; |
| | | oClassTimePrj.oModel.HStopflag = list[0].HStopflag; |
| | | oClassTimePrj.oModel.HUseFlag = list[0].HUseFlag; |
| | | oClassTimePrj.oModel.HRemark = list[0].HRemark; |
| | | oClassTimePrj.oModel.HMakeEmp = HMaker; |
| | | oClassTimePrj.oModel.HModifyEmp = HMaker; |
| | | oClassTimePrj.oModel.HCheckEmp = list[0].HCheckEmp; |
| | | oClassTimePrj.oModel.HUSEORGID = list[0].HUSEORGID; |
| | | oClassTimePrj.oModel.HCREATEORGID = list[0].HUSEORGID; |
| | | oBill.oModel.HItemID = list[0].HItemID; |
| | | oBill.oModel.HNumber = list[0].HNumber; |
| | | oBill.oModel.HName = list[0].HName; |
| | | oBill.oModel.HShortNumber = DBUtility.ClsPub.GetShortNumber(list[0].HNumber); |
| | | oBill.oModel.HLevel = DBUtility.ClsPub.GetLevel(list[0].HNumber); |
| | | oBill.oModel.HEndFlag = true; |
| | | oBill.oModel.HStopflag = list[0].HStopflag; |
| | | oBill.oModel.HUseFlag = list[0].HUseFlag; |
| | | oBill.oModel.HRemark = list[0].HRemark; |
| | | oBill.oModel.HMakeEmp = HMaker; |
| | | oBill.oModel.HModifyEmp = HMaker; |
| | | oBill.oModel.HCheckEmp = list[0].HCheckEmp; |
| | | oBill.oModel.HUSEORGID = list[0].HUSEORGID; |
| | | oBill.oModel.HCREATEORGID = list[0].HUSEORGID; |
| | | // |
| | | oClassTimePrj.oModel.HDeptID = list[0].HDeptID; |
| | | oClassTimePrj.oModel.HGroupID = list[0].HGroupID; |
| | | oBill.oModel.HDeptID = list[0].HDeptID; |
| | | oBill.oModel.HGroupID = list[0].HGroupID; |
| | | |
| | | //æ£æ¥ç¶çº§æ¯å¦åå¨ |
| | | string sParent = DBUtility.ClsPub.GetParentCode(list[0].HNumber); |
| | | if (sParent.Trim() == "") |
| | | { |
| | | oClassTimePrj.oModel.HParentID = 0; |
| | | oBill.oModel.HParentID = 0; |
| | | } |
| | | else |
| | | { |
| | | ds = oCn.RunProcReturn("select * from " + ModRightName + " where HStopflag=0 and HNumber='" + sParent + "' and HItemID<>" + oClassTimePrj.oModel.HItemID, ModRightName); |
| | | ds = oCn.RunProcReturn("select * from " + ModRightName + " where HStopflag=0 and HNumber='" + sParent + "' and HItemID<>" + oBill.oModel.HItemID, ModRightName); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | oClassTimePrj.oModel.HParentID = long.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | oBill.oModel.HParentID = long.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | else |
| | | { |
| | |
| | | } |
| | | //ä¿åå代ç |
| | | |
| | | DataSet dsOldNumber = oCn.RunProcReturn("select * from " + ModRightName + " where HItemID='" + oClassTimePrj.oModel.HItemID + "'", ModRightName); |
| | | DataSet dsOldNumber = oCn.RunProcReturn("select * from " + ModRightName + " where HItemID='" + oBill.oModel.HItemID + "'", ModRightName); |
| | | if (dsOldNumber.Tables[0].Rows.Count > 0) |
| | | { |
| | | oClassTimePrj.HOldNumber = DBUtility.ClsPub.isStrNull(dsOldNumber.Tables[0].Rows[0]["HNumber"]); |
| | | oBill.HOldNumber = DBUtility.ClsPub.isStrNull(dsOldNumber.Tables[0].Rows[0]["HNumber"]); |
| | | //æ¯å¦æ°ä»£ç æ¯èªå·±å项ç®çãåé¡¹ç® |
| | | if (sParent.Length >= oClassTimePrj.HOldNumber.Length) |
| | | if (sParent.Length >= oBill.HOldNumber.Length) |
| | | { |
| | | if (sParent.Substring(0, oClassTimePrj.HOldNumber.ToString().Length) == oClassTimePrj.HOldNumber.Trim()) |
| | | if (sParent.Substring(0, oBill.HOldNumber.ToString().Length) == oBill.HOldNumber.Trim()) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | } |
| | | else |
| | | { |
| | | oClassTimePrj.HOldNumber = ""; |
| | | oBill.HOldNumber = ""; |
| | | } |
| | | |
| | | //ä¿åå夿 |
| | | //å®¡æ ¸ä»£ç æ¯å¦åç |
| | | if (!DBUtility.ClsPub.AllowNumber(oClassTimePrj.oModel.HNumber)) |
| | | if (!DBUtility.ClsPub.AllowNumber(oBill.oModel.HNumber)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | return objJsonResult; |
| | | } |
| | | //æ¯å¦éå¤ä»£ç |
| | | if (oClassTimePrj.HavSameNumber(oClassTimePrj.oModel.HItemID, oClassTimePrj.oModel.HNumber)) |
| | | if (oBill.HavSameNumber(oBill.oModel.HItemID, oBill.oModel.HNumber)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | if (OperationType == "1") |
| | | { |
| | | //æ°å¢ |
| | | if (oClassTimePrj.AddNew()) |
| | | if (oBill.AddNew()) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | } |
| | | else |
| | | { |
| | | if(oClassTimePrj.oModel.HCheckEmp!="") |
| | | if(oBill.oModel.HCheckEmp!="") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | return objJsonResult; |
| | | } |
| | | //ä¿®æ¹ |
| | | if (oClassTimePrj.ModifyByID(oClassTimePrj.oModel.HItemID)) |
| | | if (oBill.ModifyByID(oBill.oModel.HItemID)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |