| | |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | //获取点检项目编辑数据 |
|---|
| | | ds = oCN.RunProcReturn(@"select a.HDotCheckItemID,HDotCheckItem, HDotCheckPart , HClaim, a.HRemark,a.HManagerID,e.HNumber HManagerCode,e.HName HManagerName from Sc_MouldDotCheckPlanBillSub a |
|---|
| | | left join Gy_Employee e on a.HManagerID=e.HItemID |
|---|
| | | ds = oCN.RunProcReturn(@"select * from h_v_Sc_MouldDotCheckPlanBill_Edit |
|---|
| | | where 1=1 " + sqlWhere, "Sc_MouldDotCheckPlanBillSub"); |
|---|
| | | ////获取配件项目编辑数据 |
|---|
| | | //ds1 = oCN.RunProcReturn(@"select b.HMaterID, mt.Hnumber HMaterNumber ,mt.HName HMaterName, b.HUnitID |
|---|
| | |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "获取信息成功！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | objJsonResult.list = list; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
