| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 根据检验方案主内码获取检验项目,前面的会把先获取物料的默认质检方案，APP只根据检验方案ID获取对应检验项目 |
|---|
| | | /// </summary> |
|---|
| | | /// <returns></returns> |
|---|
| | | [Route("Web/GetCheckItemByCheckProjectID_Sec")] |
|---|
| | | [HttpGet] |
|---|
| | | public object GetCheckItemByCheckProjectID_Sec(int CheckProjectID, int HBatchQty, int HMaterID, string HBillType) |
|---|
| | | { |
|---|
| | | //if (CheckProjectID <= 0) |
|---|
| | | //{ |
|---|
| | | // objjson.code = "0"; |
|---|
| | | // objjson.count = 0; |
|---|
| | | // objjson.Message = "检验方案未选择"; |
|---|
| | | // objjson.data = null; |
|---|
| | | // return objjson; |
|---|
| | | //} |
|---|
| | | try |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | string sql = "exec h_p_Gy_GetQCCheckItemByProject_Sec " + CheckProjectID + "," + HBatchQty + "," + HMaterID + ",'" + HBillType + "'"; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_p_Gy_GetQCCheckItemByProject_Sec"); |
|---|
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
|---|
| | | { |
|---|
| | | objjson.code = "0"; |
|---|
| | | objjson.count = 0; |
|---|
| | | objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; |
|---|
| | | objjson.data = null; |
|---|
| | | return objjson; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | objjson.code = "1"; |
|---|
| | | objjson.count = 1; |
|---|
| | | objjson.Message = "获取成功!"; |
|---|
| | | objjson.data = ds.Tables[0]; |
|---|
| | | return objjson; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception ex) |
|---|
| | | { |
|---|
| | | objjson.code = "0"; |
|---|
| | | objjson.count = 0; |
|---|
| | | objjson.Message = "获取失败" + ex.ToString(); |
|---|
| | | objjson.data = null; |
|---|
| | | return objjson; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 根据器具主内码获取器具保养检验项目 |
|---|
| | | /// </summary> |
|---|
| | | /// <returns></returns> |
|---|
