| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 返回委外工单列表 |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="sWhere"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | [Route("LEMS/MES_WW_EntrustWorkOrderBillMain_Json")] |
|---|
| | | [HttpGet] |
|---|
| | | public object MES_WW_EntrustWorkOrderBillMain_Json(string sWhere) |
|---|
| | | { |
|---|
| | | DataSet ds; |
|---|
| | | try |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | if (sWhere == null || sWhere.Equals("")) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("select top 500 * from WW_EntrustWorkOrderBillMain ", "WW_EntrustWorkOrderBillMain"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | string sql1 = "select * from WW_EntrustWorkOrderBillMain where 1 = 1 "; |
|---|
| | | string sql = sql1 + sWhere; |
|---|
| | | ds = oCN.RunProcReturn(sql, "WW_EntrustWorkOrderBillMain"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "没有返回任何记录！" + e.ToString(); |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | return GetObjectJson(ds); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 返回委外工序汇报单列表 |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="sWhere"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | [Route("LEMS/MES_Sc_StationOutBillMain_Json")] |
|---|
| | | [HttpGet] |
|---|
| | | public object MES_Sc_StationOutBillMain_Json(string sWhere) |
|---|
| | | { |
|---|
| | | DataSet ds; |
|---|
| | | try |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | if (sWhere == null || sWhere.Equals("")) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("select top 500 * from Sc_StationOutBillMain ", "Sc_StationOutBillMain"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | string sql1 = "select * from Sc_StationOutBillMain where 1 = 1 "; |
|---|
| | | string sql = sql1 + sWhere; |
|---|
| | | ds = oCN.RunProcReturn(sql, "Sc_StationOutBillMain"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "没有返回任何记录！" + e.ToString(); |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | return GetObjectJson(ds); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 返回工序委外接收单列表 |
|---|
| | | ///参数：string sql。 |
|---|
| | | ///返回值：object。 |
|---|
