| | |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | LogService.Write("1"); |
|---|
| | | Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); |
|---|
| | | LogService.Write("2"); |
|---|
| | | string HBeginDate = dic["HBeginDate"].ToString();//开始日期 |
|---|
| | | LogService.Write("3"+ HBeginDate); |
|---|
| | | string HEndDate = dic["HEndDate"].ToString();//结束日期 |
|---|
| | | LogService.Write("4" + HEndDate); |
|---|
| | | string HMouldNo = dic["HMouldNo"].ToString();//模具编码 |
|---|
| | | LogService.Write("5" + HMouldNo); |
|---|
| | | string HName = dic["HName"].ToString();//模具名称 |
|---|
| | | LogService.Write("6" + HName); |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("exec h_P_Sc_MouldLifeUsePicReport '" + HBeginDate + "'," + HEndDate + ",'" + HMouldNo + "','" + HName + "'", "h_P_Sc_MouldLifeUsePicReport"); |
|---|
| | | ds = oCN.RunProcReturn("exec h_P_Sc_MouldLifeUsePicReport '" + HBeginDate + "','" + HEndDate + "','" + HMouldNo + "','" + HName + "'", "h_P_Sc_MouldLifeUsePicReport"); |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | //添加列名 |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
|---|
| | |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | objJsonResult.list = columnNameList; |
|---|
| | | return objJsonResult; |
|---|
| | | //} |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
