| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | #region 根据物料内码获取物料信息 |
|---|
| | | [Route("Cg_POInStockBill/getMaterialByMaterID")] |
|---|
| | | [HttpGet] |
|---|
| | | public ApiResult<DataTable> getMaterialByMaterID(Int64 HMaterID) |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | |
|---|
| | | string sql = "select a.HItemID HMaterID,a.HNumber HMaterNumber,a.HName HMaterName,a.HMaterRuleType,a.HModel HMaterModel,a.HUnitID, b.HNumber HUnitNumber, b.HName HUnitName" + |
|---|
| | | " from Gy_Material AS a " + |
|---|
| | | " LEFT OUTER JOIN Gy_Unit AS b on a.HUnitID = b.HItemID " + |
|---|
| | | " where a.HItemID =" + HMaterID; |
|---|
| | | |
|---|
| | | var dataSet = oCN.RunProcReturn(sql, "Gy_Material"); |
|---|
| | | |
|---|
| | | |
|---|
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
|---|
| | | return new ApiResult<DataTable> { code = -1, msg = "不存在该物料" }; |
|---|
| | | |
|---|
| | | return new ApiResult<DataTable> { code = 1, msg = "查询成功", data = dataSet.Tables[0] }; |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 反审核 |
|---|
| | | /// </summary> |
|---|
| | |
|---|
| | | sql = @" |
|---|
| | | Insert Into Cg_POInStockBillMain |
|---|
| | | (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate |
|---|
| | | ,HBillNo,HBillStatus,HSupID,HManagerID,HEmpID,HDeptID,HRemark |
|---|
| | | ,HBillNo,HBillStatus,HSupID,HSupDealerID,HManagerID,HEmpID,HDeptID,HRemark |
|---|
| | | ,HMaker,HMakeDate,HChecker,HCheckDate,HOWNERTYPEID,HOWNERID |
|---|
| | | ,HERPInterID,HERPBillType,HPURCHASEORGID,HSTOCKORGID,HREQUIREORGID |
|---|
| | | ,HSTOCKGROUPID,HSENDBILLNO,HLADBILLNO,HPURDEPTID,HPURGROUPID,HSUPPLYID |
|---|
| | | ,HSETTLEID,HCHARGEID,HBUSINESSTYPE,HSUPPLYADDRESS,HCORRESPONDORGID,HPROVIDERCONTACTID,HCurID,HExRate,HAddress,HWHID,HInnerBillNo) |
|---|
| | | values(" + mainList[0].HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1103 + "','" + |
|---|
| | | mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "'," + mainList[0].HBillStatus + "," + mainList[0].HSupID + |
|---|
| | | mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "'," + mainList[0].HBillStatus + "," + (mainList[0].HSupDealerID == 0 ? mainList[0].HSupID : mainList[0].HSupDealerID) + "," + mainList[0].HSupID + |
|---|
| | | "," + mainList[0].HManagerID + "," + mainList[0].HEmpID + "," + mainList[0].HDeptID + ",'" + mainList[0].HRemark + "','" + mainList[0].HMaker + |
|---|
| | | "','" + mainList[0].HMakeDate + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HOWNERTYPEID + "'," + mainList[0].HOWNERID + "," + mainList[0].HERPInterID + ",'" + mainList[0].HERPBillType + "'," + mainList[0].HPURCHASEORGID + "," + mainList[0].HSTOCKORGID + "," + mainList[0].HREQUIREORGID + "," + |
|---|
| | | mainList[0].HSTOCKGROUPID + ",'" + mainList[0].HSENDBILLNO + "','" + mainList[0].HLADBILLNO + "'," + mainList[0].HPURDEPTID + "," + mainList[0].HPURGROUPID + "," + mainList[0].HSUPPLYID + "," + |
|---|
