| | |
|---|
| | | } |
|---|
| | | 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"; |
|---|
| | |
|---|
| | | List<object> list = new List<object>(); |
|---|
| | | DataSet ds2; |
|---|
| | | DataSet ds1; |
|---|
| | | string sql1 = string.Format(@"select t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark |
|---|
| | | string sql1 = string.Format(@"select a.HInterID,a.HBillNo,t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark |
|---|
| | | from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub_Item t on a.HInterID=t.HInterID |
|---|
| | | left join Gy_Maintain m on m.HItemID=t.HMaintainItemID |
|---|
| | | left join Gy_Employee e on e.HItemID=t.HManagerID |
|---|
| | |
|---|
| | | List<object> list = new List<object>(); |
|---|
| | | DataSet ds2; |
|---|
| | | DataSet ds1; |
|---|
| | | string sql1 = string.Format(@"select t.HMaintainItemID HMaintainItemID,m.HNumber HMaintainItemNumber,t.HMaintainItem HMaintainItem,t.HMaintainPart HMaintainPart,t.HClaim HClaim,t.HManagerID HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark |
|---|
| | | string sql1 = string.Format(@"select a.HInterID,a.HBillNo,t.HMaintainItemID HMaintainItemID,m.HNumber HMaintainItemNumber,t.HMaintainItem HMaintainItem,t.HMaintainPart HMaintainPart,t.HClaim HClaim,t.HManagerID HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark |
|---|
| | | from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub_Item t on a.HInterID=t.HInterID |
|---|
| | | left join Gy_Maintain m on m.HItemID=t.HMaintainItemID |
|---|
| | | left join Gy_Employee e on e.HItemID=t.HManagerID |
|---|
| | |
|---|
| | | { |
|---|
| | | 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 |
|---|
