| | |
|---|
| | | |
|---|
| | | [Route("QC_CustomerAppealReport/SB_EquipICMOTechParamList")] |
|---|
| | | [HttpGet] |
|---|
| | | public object SB_EquipICMOTechParamList(string sWhere, string user) |
|---|
| | | public object SB_EquipICMOTechParamList(string sWhere, string user,string Type) |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_SB_EquipICMOTechParamBillList '" + HProcExchBillNo + "','" + HProcName + "','" + HTechParamName + "','"+HEquipName+"'", "h_p_SB_EquipICMOTechParamBillList"); |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_SB_EquipICMOTechParamBillList '" + HProcExchBillNo + "','" + HProcName + "','" + HTechParamName + "','"+HEquipName+"','"+Type+"'", "h_p_SB_EquipICMOTechParamBillList"); |
|---|
| | | |
|---|
| | | //娣诲姞鍒楀悕 |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
|---|
| | |
|---|
| | | else |
|---|
| | | { |
|---|
| | | string sql1 = "select * from h_v_OA_ErrMsgBackBillList_Query where 1 = 1 "; |
|---|
| | | string sql = sql1 + sWhere + " order by 鏃ユ湡 "; |
|---|
| | | string sql = sql1 + sWhere + " order by 鏃ユ湡 desc "; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_OA_ErrMsgBackBillList_Query"); |
|---|
| | | } |
|---|
| | | |
|---|
