| | |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // string sql = @"select a.FID,a.FNUMBER Employee,d.FNUMBER Dept from Gy_Employee e |
|---|
| | | // join AIS20210811135644..T_HR_EMPINFO a on e.HNumber = a.FNUMBER |
|---|
| | | // join AIS20210811135644..T_BD_STAFFTEMP c on c.FID = a.FID |
|---|
| | | // join AIS20210811135644..T_BD_DEPARTMENT d on c.FDEPTID = d.FDEPTID |
|---|
| | | // where e.HItemID ='" + HKeeperID + "' "; |
|---|
| | | // //查询质检员对应质检部门 |
|---|
| | | // ds = oCN.RunProcReturn(sql, "T_HR_EMPINFO"); |
|---|
| | | // LogService.Write("sql" + sql); |
|---|
| | | // if (ds.Tables[0].Rows.Count == 0) |
|---|
| | | // { |
|---|
| | | // objJsonResult.code = "0"; |
|---|
| | | // objJsonResult.count = 0; |
|---|
| | | // objJsonResult.Message = "操作失败,质检员对应质检部门无数据。" + sql; |
|---|
| | | // objJsonResult.data = null; |
|---|
| | | // return objJsonResult; |
|---|
| | | // } |
|---|
| | | |
|---|
| | | string sql = @"select a.FID,a.FNUMBER Employee,d.FNUMBER Dept from Gy_Employee e |
|---|
| | | join JL20250716203240..T_HR_EMPINFO a on e.HNumber = a.FNUMBER |
|---|
| | | join JL20250716203240..T_BD_STAFFTEMP c on c.FID = a.FID |
|---|
| | | join JL20250716203240..T_BD_DEPARTMENT d on c.FDEPTID = d.FDEPTID |
|---|
| | | where e.HItemID ='" + HKeeperID + "' "; |
|---|
| | | //查询质检员对应质检部门 |
|---|
| | | ds = oCN.RunProcReturn(sql, "T_HR_EMPINFO"); |
|---|
| | | LogService.Write("sql" + sql); |
|---|
| | | if (ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "操作失败,质检员对应质检部门无数据。" + sql; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | JObject model = new JObject(); |
|---|
| | |
|---|
| | | model.Add("FInspectOrgId", new JObject() { ["Fnumber"] = HZJOrgNumber.ToString() }); //质检组织 |
|---|
| | | model.Add("FSourceOrgId", new JObject() { ["Fnumber"] = HZJOrgNumber.ToString() }); //来源组织 |
|---|
| | | //model.Add("FInspectDepId", new JObject() { ["Fnumber"] = ds.Tables[0].Rows[0]["Dept"].ToString() }); //质检部门 |
|---|
| | | //model.Add("FInspectorId", new JObject() { ["Fnumber"] = ds.Tables[0].Rows[0]["Employee"].ToString() }); //质检员 |
|---|
| | | model.Add("FInspectorId", new JObject() { ["Fnumber"] = ds.Tables[0].Rows[0]["Employee"].ToString() }); //质检员 |
|---|
| | | model.Add("FISSYNCED", "false");// 是否已同步 |
|---|
| | | model.Add("F_PGKJ_Date", DateTime.Now.ToString("yyyy-MM-dd"));// 报检日期 |
|---|
| | | model.Add("FBillNo", HBillNo); |
|---|
