New file |
| | |
| | | using DBUtility; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Linq; |
| | | using System.Net; |
| | | using System.Net.Http; |
| | | using System.Web.Http; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers |
| | | { |
| | | public class Gy_ClassTimePrjGroupController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | const string ModCaption = "æ ¸ç®æ¹å¼ç»"; |
| | | public const string ModRightName = "Gy_ClassTimePrjGroup"; |
| | | public const string ModRightNameAdd = ModRightName + "_Add"; //æ°å¢ |
| | | public const string ModRightNameEdit = ModRightName + "_Edit"; //ç¼è¾ |
| | | public const string ModRightNameCheck = ModRightName + "_Check"; //å®¡æ ¸ |
| | | public const string ModRightNameClose = ModRightName + "_Stop"; //ç¦ç¨ |
| | | public const string ModRightNameDelete = ModRightName + "_Delete"; //å é¤ |
| | | 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(); |
| | | |
| | | |
| | | #region æ ¸ç®æ¹å¼ç»å表 |
| | | /// <summary> |
| | | /// è·åæ ¸ç®æ¹å¼ç»åè¡¨ä¿¡æ¯ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroupList_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroupList_Json(string sWhere, string HMaker) |
| | | { |
| | | try |
| | | { |
| | | //夿æé |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightName, 1, false, HMaker)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åæé,请ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //è¿ååè¡¨ä¿¡æ¯ |
| | | ds = oCn.RunProcReturn("select * from h_v_Gy_ClassTimePrjGroupList where " + sWhere + " order by " + ModCaption + "代ç " , "h_v_Gy_ClassTimePrjGroupList"); |
| | | List<object> columnNameList = new List<object>(); |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString)); //è·åå°DataColumnå对象çåå |
| | | } |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢å表信æ¯å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¸ç®æ¹å¼ç»å é¤ |
| | | /// <summary> |
| | | /// å 餿 ¸ç®æ¹å¼ç» |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroup_Delete_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroup_Delete_Json(Int64 HItemID, string HMaker) |
| | | { |
| | | try |
| | | { |
| | | //夿æé |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, HMaker)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åå é¤åè½æé,请ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //夿å卿§ |
| | | if (oClassTimePrjHlp.GetInfoByID(HItemID)) |
| | | { |
| | | //夿æ¯å¦åå¨å项 |
| | | if (oClassTimePrj.HavChildCodes(HItemID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤æ ¸ç®æ¹å¼ç»åå¨å项ç®,ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //å 餿°æ® |
| | | if (oClassTimePrj.DeleteByID(HItemID)) |
| | | { |
| | | //åå
¥æ¥å¿ |
| | | DBUtility.ClsPub.Add_Log("", "å 餿 ¸ç®æ¹å¼ç»ï¼ä»£ç ï¼" + oClassTimePrjHlp.omodel.HNumber + ",åç§°ï¼" + oClassTimePrjHlp.omodel.HName, HMaker); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å 餿 ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å 餿 ¸ç®æ¹å¼ç»å¤±è´¥ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æªæ¥è¯¢å°è¯¥æ ¸ç®æ¹å¼ç»ï¼è¯·å·æ°æ°æ®åéæ°éæ©ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å 餿 ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #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")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroup_Check_Json(Int64 HItemID, int IsAudit, string HMaker) |
| | | { |
| | | string sErrMsg = ""; |
| | | try |
| | | { |
| | | //夿æé |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, HMaker)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åå®¡æ ¸/åå®¡æ ¸åè½æé,请ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (IsAudit == 0) //å®¡æ ¸å¤æ |
| | | { |
| | | if (oClassTimePrj.CheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å®¡æ ¸æ ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else if (IsAudit == 1) //åå®¡æ ¸å¤æ |
| | | { |
| | | if (oClassTimePrj.AbandonCheckByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åå®¡æ ¸æ ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åå®¡æ ¸æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸/åå®¡æ ¸åè½å¤æé误ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸æåå®¡æ ¸æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #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")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroup_Stop_Json(Int64 HItemID, int IsStop, string HMaker) |
| | | { |
| | | string sErrMsg = ""; |
| | | try |
| | | { |
| | | //夿æé |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightNameClose, 1, false, HMaker)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åç¦ç¨/åç¦ç¨åè½æé,请ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (IsStop == 0) //ç¦ç¨å¤æ |
| | | { |
| | | if (oClassTimePrj.StopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ç¦ç¨æ ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ç¦ç¨æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else if (IsStop == 1) //åç¦ç¨å¤æ |
| | | { |
| | | if (oClassTimePrj.AbandonStopByHItemID(HItemID, HMaker, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åç¦ç¨æ ¸ç®æ¹å¼ç»æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åç¦ç¨æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ç¦ç¨/åç¦ç¨åè½å¤æé误ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ç¦ç¨æåç¦ç¨æ ¸ç®æ¹å¼ç»å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¸ç®æ¹å¼ç»ä¿å |
| | | /// <summary> |
| | | /// æ ¸ç®æ¹å¼ç»ä¿å |
| | | /// </summary> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroup_Save_Json")] |
| | | [HttpPost] |
| | | public object GetGy_ClassTimePrjGroup_Save_Json([FromBody] JObject oMain) |
| | | { |
| | | try |
| | | { |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string HMaker = sArray[1].ToString(); |
| | | string OperationType = sArray[2].ToString(); //æä½ç±»åï¼1æ°å¢ã2ç¼è¾ï¼ |
| | | |
| | | //夿æé |
| | | if (OperationType == "1") |
| | | { |
| | | //夿æ°å¢æé |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightNameAdd, 1, false, HMaker)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åæ°å¢æé,请ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | //夿ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, false, HMaker)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åç¼è¾æé,请ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | //ååºåå |
| | | 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; |
| | | // |
| | | oClassTimePrj.oModel.HDeptID = list[0].HDeptID; |
| | | oClassTimePrj.oModel.HGroupID = list[0].HGroupID; |
| | | |
| | | //æ£æ¥ç¶çº§æ¯å¦åå¨ |
| | | string sParent = DBUtility.ClsPub.GetParentCode(list[0].HNumber); |
| | | if (sParent.Trim() == "") |
| | | { |
| | | oClassTimePrj.oModel.HParentID = 0; |
| | | } |
| | | else |
| | | { |
| | | ds = oCn.RunProcReturn("select * from " + ModRightName + " where HStopflag=0 and HNumber='" + sParent + "' and HItemID<>" + oClassTimePrj.oModel.HItemID, ModRightName); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | oClassTimePrj.oModel.HParentID = long.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä¸çº§ä»£ç ä¸åå¨æè¢«ç¦ç¨ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | //ä¿åå代ç |
| | | |
| | | DataSet dsOldNumber = oCn.RunProcReturn("select * from " + ModRightName + " where HItemID='" + oClassTimePrj.oModel.HItemID + "'", ModRightName); |
| | | if (dsOldNumber.Tables[0].Rows.Count > 0) |
| | | { |
| | | oClassTimePrj.HOldNumber = DBUtility.ClsPub.isStrNull(dsOldNumber.Tables[0].Rows[0]["HNumber"]); |
| | | //æ¯å¦æ°ä»£ç æ¯èªå·±å项ç®çãåé¡¹ç® |
| | | if (sParent.Length >= oClassTimePrj.HOldNumber.Length) |
| | | { |
| | | if (sParent.Substring(0, oClassTimePrj.HOldNumber.ToString().Length) == oClassTimePrj.HOldNumber.Trim()) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ°ä»£ç ä¸è½æ¯èªå·±çä¸çº§çå项ç®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | else |
| | | { |
| | | oClassTimePrj.HOldNumber = ""; |
| | | } |
| | | |
| | | //ä¿åå夿 |
| | | //å®¡æ ¸ä»£ç æ¯å¦åç |
| | | if (!DBUtility.ClsPub.AllowNumber(oClassTimePrj.oModel.HNumber)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //æ¯å¦éå¤ä»£ç |
| | | if (oClassTimePrj.HavSameNumber(oClassTimePrj.oModel.HItemID, oClassTimePrj.oModel.HNumber)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "代ç éå¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //ä¿å |
| | | if (OperationType == "1") |
| | | { |
| | | //æ°å¢ |
| | | if (oClassTimePrj.AddNew()) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ°å¢æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ°å¢å¤±è´¥ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if(oClassTimePrj.oModel.HCheckEmp!="") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·²å®¡æ ¸ï¼ä¸å
许修æ¹ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //ä¿®æ¹ |
| | | if (oClassTimePrj.ModifyByID(oClassTimePrj.oModel.HItemID)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿®æ¹æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿®æ¹å¤±è´¥ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region æ¾ç¤ºæ ¸ç®æ¹å¼ç»ä¿¡æ¯ |
| | | /// <summary> |
| | | /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ |
| | | /// </summary> |
| | | [Route("Gy_ClassTimePrjGroupController/GetGy_ClassTimePrjGroup_Json")] |
| | | [HttpGet] |
| | | public object GetGy_ClassTimePrjGroup_Json(Int64 HItemID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCn.RunProcReturn("select * from h_v_Gy_ClassTimePrjGroupListDetail where HItemID=" + HItemID, "h_v_Gy_ClassTimePrjGroupListDetail"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æªæ¥è¯¢å°è¯¥æ ¸ç®æ¹å¼ç»ï¼è¯·å·æ°æ°æ®åéæ°éæ©ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "è¿åæ ¸ç®æ¹å¼ç»ä¿¡æ¯å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | } |
| | | } |