| | |
|---|
| | | } |
|---|
| | | try |
|---|
| | | { |
|---|
| | | ds = webserver.GetEmployeeList(sWhere, ref DBUtility.ClsPub.sErrInfo); |
|---|
| | | string sql = $"Select * from h_v_IF_Emp {sWhere} Order by HNumber"; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_Emp"); |
|---|
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
|---|
| | | { |
|---|
| | | objjson.code = "0"; |
|---|
| | |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | string sql = string.Format(@"select b.HDotCheckItemID HDotCheckItemID,c.HNumber HDotCheckCode,b.HDotCheckItem,b.HDotCheckPart,b.HClaim, |
|---|
| | | b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark from Sb_EquipDotCheckRuleBillMain a |
|---|
| | | b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark,a.HInterID,a.HBillNo from Sb_EquipDotCheckRuleBillMain a |
|---|
| | | left join Sb_EquipDotCheckRuleBillSub b on a.HInterID=b.HInterID |
|---|
| | | left join Gy_QCCheckItem c on c.HItemID=b.HDotCheckItemID |
|---|
| | | left join Gy_Employee e on e.HItemID=b.HManagerID |
|---|
