| | |
| | | return response; |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region èªå¨å 载页é¢è¡¨å¤´ |
| | | /// <summary> |
| | | /// è¿å项ç®é¶æ®µå表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DefineBillMainSet/getDefineBillMainSet")] |
| | | [HttpGet] |
| | | public object getDefineBillMainSet(string HModName, string user) |
| | | { |
| | | try |
| | | { |
| | | string sql = "select b.* from Xt_DefineBillMainSetMain as a inner join Xt_DefineBillMainSetSub as b on a.HInterID = b.HInterID where a.HModName ='" + HModName + "' and a.HUser ='" + user + "' order by b.HArrangeOrder,b.HArrangeOrderSub"; |
| | | ds = oCN.RunProcReturn(sql, "Xt_DefineBillMainSet"); |
| | | |
| | | if(ds!=null && ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sql = "select b.* from Xt_DefineBillMainSetMain as a inner join Xt_DefineBillMainSetSub as b on a.HInterID = b.HInterID where a.HModName ='" + HModName + "' and a.HUser ='admin' order by b.HArrangeOrder,b.HArrangeOrderSub"; |
| | | ds = oCN.RunProcReturn(sql, "Xt_DefineBillMainSet"); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | } |
| | | } |