copy from "WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjGroupController.cs"
copy to "WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\267\245\350\265\204\345\237\272\347\241\200\350\265\204\346\226\231/Gy_WorkTypeController.cs"
File was copied from WebAPI/Controllers/¹¤×ʹÜÀí/Gy_ClassTimePrjGroupController.cs |
| | |
| | | |
| | | namespace WebAPI.Controllers |
| | | { |
| | | public class Gy_ClassTimePrjGroupController : ApiController |
| | | public class Gy_WorkTypeController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | const string ModCaption = "æ ¸ç®æ¹å¼ç»"; |
| | | public const string ModRightName = "Gy_ClassTimePrjGroup"; |
| | | const string ModCaption = "å·¥ç§"; |
| | | public const string ModRightName = "Gy_WorkType"; |
| | | public const string ModRightNameAdd = ModRightName + "_Add"; //æ°å¢ |
| | | public const string ModRightNameEdit = ModRightName + "_Edit"; //ç¼è¾ |
| | | public const string ModRightNameCheck = ModRightName + "_Check"; //å®¡æ ¸ |
| | |
| | | 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_WorkType_Ctl oBill = new DAL.ClsGy_WorkType_Ctl(); |
| | | DAL.ClsGy_WorkType_View oBillHlp = new DAL.ClsGy_WorkType_View(); |
| | | |
| | | |
| | | #region æ ¸ç®æ¹å¼ç»å表 |
| | | #region å·¥ç§å表 |
| | | /// <summary> |
| | | /// è·åæ ¸ç®æ¹å¼ç»åè¡¨ä¿¡æ¯ |
| | | /// è·åå·¥ç§åè¡¨ä¿¡æ¯ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroupList_Json")] |
| | | [Route("Gy_WorkTypeController/GetGy_WorkTypeList_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroupList_Json(string sWhere, string HMaker) |
| | | public object GetGy_WorkTypeList_Json(string sWhere, string HMaker) |
| | | { |
| | | try |
| | | { |
| | |
| | | } |
| | | |
| | | //è¿ååè¡¨ä¿¡æ¯ |
| | | ds = oCn.RunProcReturn("select * from h_v_Gy_ClassTimePrjGroupList where " + sWhere + " order by " + ModCaption + "代ç " , "h_v_Gy_ClassTimePrjGroupList"); |
| | | ds = oCn.RunProcReturn("select * from h_v_Gy_WorkTypeList where " + sWhere + " order by " + ModCaption + "代ç " , "h_v_Gy_WorkTypeList"); |
| | | List<object> columnNameList = new List<object>(); |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¸ç®æ¹å¼ç»å é¤ |
| | | #region å·¥ç§å é¤ |
| | | /// <summary> |
| | | /// å 餿 ¸ç®æ¹å¼ç» |
| | | /// å é¤å·¥ç§ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroup_Delete_Json")] |
| | | [Route("Gy_WorkTypeController/GetGy_WorkType_Delete_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroup_Delete_Json(Int64 HItemID, string HMaker) |
| | | public object GetGy_WorkType_Delete_Json(Int64 HItemID, string HMaker) |
| | | { |
| | | try |
| | | { |
| | |
| | | } |
| | | |
| | | //夿å卿§ |
| | | if (oClassTimePrjHlp.GetInfoByID(HItemID)) |
| | | if (oBillHlp.GetInfoByID(HItemID)) |
| | | { |
| | | //夿æ¯å¦åå¨å项 |
| | | if (oClassTimePrj.HavChildCodes(HItemID)) |
| | | if (oBill.HavChildCodes(HItemID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤æ ¸ç®æ¹å¼ç»åå¨å项ç®,ä¸è½å é¤ï¼"; |
| | | objJsonResult.Message = "æ¤å·¥ç§åå¨å项ç®,ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | 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 = "å 餿 ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.Message = "å é¤å·¥ç§æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å 餿 ¸ç®æ¹å¼ç»å¤±è´¥ï¼"; |
| | | objJsonResult.Message = "å é¤å·¥ç§å¤±è´¥ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æªæ¥è¯¢å°è¯¥æ ¸ç®æ¹å¼ç»ï¼è¯·å·æ°æ°æ®åéæ°éæ©ï¼"; |
| | | objJsonResult.Message = "æªæ¥è¯¢å°è¯¥å·¥ç§ï¼è¯·å·æ°æ°æ®åéæ°éæ©ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å 餿 ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.Message = "å é¤å·¥ç§å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¸ç®æ¹å¼ç»å®¡æ ¸ãåå®¡æ ¸ |
| | | #region å·¥ç§å®¡æ ¸ãåå®¡æ ¸ |
| | | /// <summary> |
| | | /// å®¡æ ¸ãåå®¡æ ¸æ ¸ç®æ¹å¼ç» |
| | | /// å®¡æ ¸ãåå®¡æ ¸å·¥ç§ |
| | | /// </summary> |
| | | /// <param name="HItemID">å
ç </param> |
| | | /// <param name="IsAudit">å®¡æ ¸(0),åå®¡æ ¸(1)</param> |
| | | /// <param name="HMaker">æä½äºº</param> |
| | | /// <returns></returns> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroup_Check_Json")] |
| | | [Route("Gy_WorkTypeController/GetGy_WorkType_Check_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroup_Check_Json(Int64 HItemID, int IsAudit, string HMaker) |
| | | public object GetGy_WorkType_Check_Json(Int64 HItemID, int IsAudit, string HMaker) |
| | | { |
| | | string sErrMsg = ""; |
| | | try |
| | |
| | | |
| | | if (IsAudit == 0) //å®¡æ ¸å¤æ |
| | | { |
| | | if (oClassTimePrj.CheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | if (oBill.CheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å®¡æ ¸æ ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.Message = "å®¡æ ¸å·¥ç§æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.Message = "å®¡æ ¸å·¥ç§å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else if (IsAudit == 1) //åå®¡æ ¸å¤æ |
| | | { |
| | | if (oClassTimePrj.AbandonCheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | if (oBill.AbandonCheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åå®¡æ ¸æ ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.Message = "åå®¡æ ¸å·¥ç§æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åå®¡æ ¸æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.Message = "åå®¡æ ¸å·¥ç§å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸æåå®¡æ ¸æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.Message = "å®¡æ ¸æåå®¡æ ¸å·¥ç§å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¸ç®æ¹å¼ç»ç¦ç¨ãåç¦ç¨ |
| | | #region å·¥ç§ç¦ç¨ãåç¦ç¨ |
| | | /// <summary> |
| | | /// ç¦ç¨ãåç¦ç¨æ ¸ç®æ¹å¼ç» |
| | | /// ç¦ç¨ãåç¦ç¨å·¥ç§ |
| | | /// </summary> |
| | | /// <param name="HItemID">å
ç </param> |
| | | /// <param name="IsStop">ç¦ç¨(0),åç¦ç¨(1)</param> |
| | | /// <param name="HMaker">æä½äºº</param> |
| | | /// <returns></returns> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroup_Stop_Json")] |
| | | [Route("Gy_WorkTypeController/GetGy_WorkType_Stop_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroup_Stop_Json(Int64 HItemID, int IsStop, string HMaker) |
| | | public object GetGy_WorkType_Stop_Json(Int64 HItemID, int IsStop, string HMaker) |
| | | { |
| | | string sErrMsg = ""; |
| | | try |
| | |
| | | |
| | | if (IsStop == 0) //ç¦ç¨å¤æ |
| | | { |
| | | if (oClassTimePrj.StopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | if (oBill.StopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ç¦ç¨æ ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.Message = "ç¦ç¨å·¥ç§æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ç¦ç¨æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.Message = "ç¦ç¨å·¥ç§å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else if (IsStop == 1) //åç¦ç¨å¤æ |
| | | { |
| | | if (oClassTimePrj.AbandonStopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | if (oBill.AbandonStopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åç¦ç¨æ ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.Message = "åç¦ç¨å·¥ç§æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åç¦ç¨æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.Message = "åç¦ç¨å·¥ç§å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ç¦ç¨æåç¦ç¨æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.Message = "ç¦ç¨æåç¦ç¨å·¥ç§å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¸ç®æ¹å¼ç»ä¿å |
| | | #region å·¥ç§ä¿å |
| | | /// <summary> |
| | | /// æ ¸ç®æ¹å¼ç»ä¿å |
| | | /// å·¥ç§ä¿å |
| | | /// </summary> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroup_Save_Json")] |
| | | [Route("Gy_WorkTypeController/GetGy_WorkType_Save_Json")] |
| | | [HttpPost] |
| | | public object GetGy_ClassTimePrjGroup_Save_Json([FromBody] JObject oMain) |
| | | public object GetGy_WorkType_Save_Json([FromBody] JObject oMain) |
| | | { |
| | | try |
| | | { |
| | |
| | | msg2 = msg2.Replace("\\", ""); |
| | | 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; |
| | | List<Model.ClsGy_WorkType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_WorkType_Model>>(msg2); |
| | | 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.HPayMoney = list[0].HPayMoney; |
| | | oBill.oModel.HDayMoney = list[0].HDayMoney; |
| | | oBill.oModel.HForEmp = list[0].HForEmp; |
| | | |
| | | //æ£æ¥ç¶çº§æ¯å¦åå¨ |
| | | 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; |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region æ¾ç¤ºæ ¸ç®æ¹å¼ç»ä¿¡æ¯ |
| | | #region æ¾ç¤ºå·¥ç§ä¿¡æ¯ |
| | | /// <summary> |
| | | /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ |
| | | /// </summary> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroup_Json")] |
| | | [Route("Gy_WorkTypeController/GetGy_WorkType_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroup_Json(Int64 HItemID) |
| | | public object GetGy_WorkType_Json(Int64 HItemID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCn.RunProcReturn("select * from h_v_Gy_ClassTimePrjGroupListDetail where HItemID=" + HItemID, "h_v_Gy_ClassTimePrjGroupListDetail"); |
| | | ds = oCn.RunProcReturn("select * from h_v_Gy_WorkTypeListDetail where HItemID=" + HItemID, "h_v_Gy_WorkTypeListDetail"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æªæ¥è¯¢å°è¯¥æ ¸ç®æ¹å¼ç»ï¼è¯·å·æ°æ°æ®åéæ°éæ©ï¼"; |
| | | objJsonResult.Message = "æªæ¥è¯¢å°è¯¥å·¥ç§ï¼è¯·å·æ°æ°æ®åéæ°éæ©ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "è¿åæ ¸ç®æ¹å¼ç»ä¿¡æ¯å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.Message = "è¿åå·¥ç§ä¿¡æ¯å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |