| | |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | DLL.ClsSb_EquipDotCheckRuleBill oBill = new DLL.ClsSb_EquipDotCheckRuleBill(); |
|---|
| | | if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) |
|---|
| | | ds = oCN.RunProcReturn("select * from Sb_EquipDotCheckRuleBillMain where HInterID=" + HInterID, "Sb_EquipDotCheckRuleBillMain"); |
|---|
| | | if (ds.Tables[0].Rows.Count>0) |
|---|
| | | { |
|---|
| | | if (oBill.omodel.HBillStatus > 1) |
|---|
| | | if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | |
|---|
| | | string sql1 = @"select 点检项目ID HDotCheckItemID,点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,负责人ID HManagerID,负责人代码 HManagerNumber,负责人 HManagerName,子备注 HRemark,b.HNumber 点检项目代码 from h_v_Sb_EquipDotCheckRuleList a |
|---|
| | | left join Gy_QCCheckItem b on a.点检项目ID =b.HItemID where 1 = 1 "; |
|---|
| | | string sql1 = @"select * from h_v_Sb_EquipDotCheckRuleList a |
|---|
| | | left join Gy_DotCheck b on a.点检项目ID =b.HItemID where 1 = 1 "; |
|---|
| | | string sql = sql1 + sqlWhere; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckRuleList"); |
|---|
| | | objJsonResult.code = "0"; |
|---|
