| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 委外工序发出单流水号回车获取流转卡信息 |
| | | /// 委外工序发出单流水号回车获取流转卡信息(委外工序接收、工序进站接收通用) |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | |
| | | string HBarCode = list[0].HBarCode;//条形码 |
| | | string HAddr = ""; |
| | | string HBarCodeMaker = ""; |
| | | string BillType = "3791"; |
| | | string BillType = "3793"; |
| | | double HWasterQty = list[0].HWasterQty;//不合格数量 |
| | | long HPlanPieceQty = list[0].HPlanPieceQty;//发出件数 |
| | | long HBadPNL = list[0].HBadPNL;//报废件数 |
New file |
| | |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers |
| | | { |
| | | //工序进站接收单Controller |
| | | public class Cj_StationInBillController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | DataSet ds1; |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 新增单据-保存按钮 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("Cj_StationInBill/AddBill")] |
| | | [HttpPost] |
| | | public object AddBill([FromBody] JObject oMain) |
| | | { |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | try |
| | | { |
| | | //委外工序发出反序列化 |
| | | msg1 = "[" + msg1.ToString() + "]"; |
| | | List<StationBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<StationBill>>(msg1); |
| | | string BillType = "3790"; |
| | | long HInterID = list[0].HInterID;//递入type得到的单据ID |
| | | string HBillNo = list[0].HBillNo;//递入type得到的单据号 |
| | | int HBillStatus = 0; |
| | | string HMaker = list[0].HMaker;//制单人 |
| | | int HYear = 2021; |
| | | double HPeriod = 1; |
| | | string HRemark = list[0].HRemark;//备注 |
| | | long HICMOInterID = list[0].HICMOInterID;//任务单ID |
| | | string HICMOBillNo = list[0].HICMOBillNo;//任务单 |
| | | int HProcPlanInterID = 0; |
| | | int HProcPlanEntryID = 0; |
| | | string HProcPlanBillNo = ""; |
| | | int HProcExchInterID = 0; |
| | | int HProcExchEntryID = 0; |
| | | string HProcExchBillNo = list[0].HProcExchBillNo;//流转卡 |
| | | long HMaterID = list[0].HMaterID;//产品ID |
| | | long HProcID = list[0].HProcID;//当前工序 |
| | | double HICMOQty = list[0].HICMOQty;//任务单数量 |
| | | double HPlanQty = list[0].HPlanQty;//流转卡数量 |
| | | long HSourceID = list[0].HSourceID;//生产资源ID |
| | | long HGroupID = list[0].HGroupID;//班组ID |
| | | long HDeptID = 0; |
| | | long HEmpID = list[0].HEmpID;//接收人ID |
| | | string HBarCode = list[0].HBarCode;//条形码 |
| | | string HAddr = ""; |
| | | string HBarCodeMaker = ""; |
| | | long HSupID = 0; |
| | | double HQty = list[0].HQty;//接收数量 |
| | | double HPrice = 0; |
| | | double HMoney = 0; |
| | | double HPieceQty = list[0].HPieceQty;//接收件数 |
| | | string HSourceName = list[0].HSourceName;//生产资源名称 |
| | | long HCenterID = list[0].HCenterID;//工作中心ID |
| | | string HProcNo = list[0].HProcNo;//流水号 |
| | | string HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号 |
| | | //若MAINDI重复则重新获取 |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Insert Into Sc_StationInBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HICMOInterID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" + |
| | | ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationInTime,HSourceID" + |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" + |
| | | ",HSupID,HQty,HPrice,HMoney,HPieceQty,HSourceName,HCenterID" + |
| | | ",HProcNo,HOrderProcNO" + |
| | | ") " + |
| | | " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate()" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "'" + |
| | | "," + HICMOInterID + ",'" + HICMOBillNo + "'," + HProcPlanInterID + "," + HProcPlanEntryID + ",'" + HProcPlanBillNo + "'," + HProcExchInterID + "," + HProcExchEntryID + |
| | | ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID + |
| | | "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" + |
| | | "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HPieceQty + ",'" + HSourceName + "'," + HCenterID + |
| | | ",'" + HProcNo + "','" + HOrderProcNO + "'" + |
| | | ") "); |
| | | ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_QtyCtrl " + HInterID + "", "h_p_MES_StationInBill_QtyCtrl"); |
| | | if (ds == null) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "判断数量失败!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "判断数量失败!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2") |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_In " + HInterID + ",1"); |
| | | //判断是否是 首道工序 |
| | | ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc from Sc_ProcessExchangeBillMain a " + |
| | | " inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID " + |
| | | " Where a.HInterID=" + HProcExchInterID + " and b.HEntryID=" + HProcExchEntryID + " ", "Sc_ProcessExchangeBillMain"); |
| | | if (ds1 == null || ds1.Tables[0].Rows.Count == 0) |
| | | { |
| | | |
| | | } |
| | | else if (ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HFstProc"]) == "是") |
| | | { |
| | | |
| | | } |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "新增单据成功!"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exception!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 工序进站接收单流水号回车获取工序信息 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("Cj_StationInBill/txtHProcNo_KeyDown")] |
| | | [HttpGet] |
| | | public object txtHProcNo_KeyDown(string sBillNo,string sProcNo) |
| | | { |
| | | try |
| | | { |
| | | if (sBillNo.Equals("") || sProcNo.Equals("")) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "条形码不能为空!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //得到信息(委外标记为0时,流转标记为1时) |
| | | ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "' and 下道流转工序<>'转' and 委外标记=0 and 流转标记=1 and 工序号='" + sProcNo + "'", "h_v_Sc_ProcessExchangeBillList"); |
| | | //Ds = oCn.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "' and 工序号='" + sProcNo + "' and 委外标记=0 and 流转标记=1 ", "h_v_Sc_ProcessExchangeBillList"); |
| | | //写入信息 |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "工序号错误或者当前工序号不允许进站,请重新输入!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucess!"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exception!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 返回委外工序接收单列表 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("Cj_StationInBill/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationInBillList " + sWhere, "h_v_MES_StationInBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_MES_StationInBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationInBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "false!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucess!"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exception!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | // |
| | | } |
| | | } |
New file |
| | |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers |
| | | { |
| | | //工序出站汇报单Controller |
| | | public class Cj_StationOutBillController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | DataSet ds1; |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 新增单据-保存按钮 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("Cj_StationOutBill/AddBill")] |
| | | [HttpPost] |
| | | public object AddBill([FromBody] JObject oMain) |
| | | { |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | try |
| | | { |
| | | //反序列化 |
| | | msg1 = "[" + msg1.ToString() + "]"; |
| | | List<StationBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<StationBill>>(msg1); |
| | | |
| | | string BillType = "3791"; |
| | | string HBillSubType = "3791"; |
| | | long HInterID = list[0].HInterID;//递入type得到的单据ID |
| | | string HBillNo = list[0].HBillNo;//递入type得到的单据号 |
| | | int HBillStatus = 0; |
| | | string HMaker = list[0].HMaker;//制单人 |
| | | string HMouldNum = list[0].HMouldNum;//模穴号 |
| | | int HYear = 2021; |
| | | double HPeriod = 1; |
| | | string HRemark = list[0].HRemark;//备注 |
| | | string HSourceName = list[0].HSourceName;//生产资源名称 |
| | | double HPieceQty = list[0].HPieceQty;//进站PCS数 |
| | | double HWasterQty = list[0].HWasterQty;//报废数量 |
| | | double HPlanPieceQty = list[0].HPlanPieceQty;//进站PNL数 |
| | | double HBadPNL = list[0].HBadPNL;//报废PNL数 |
| | | long HICMOInterID = list[0].HICMOInterID;//任务单ID |
| | | string HICMOBillNo = list[0].HICMOBillNo;//任务单 |
| | | int HProcPlanInterID = 0; |
| | | int HProcPlanEntryID = 0; |
| | | string HProcPlanBillNo = ""; |
| | | long HProcExchInterID = list[0].lngBillKey; |
| | | long HProcExchEntryID = list[0].lngBillSubKey; |
| | | string HProcExchBillNo = list[0].HProcExchBillNo;//流转卡 |
| | | long HMaterID = list[0].HMaterID;//产品ID |
| | | long HProcID = list[0].HProcID;//当前工序ID |
| | | double HICMOQty = list[0].HICMOQty;//任务单数量 |
| | | double HPlanQty = list[0].HPlanQty;//移交PNL数 |
| | | DateTime HStationOutTime = list[0].HStationOutTime;//汇报时间 |
| | | long HSourceID = list[0].HSourceID;//生产资源ID |
| | | long HPayProcID = list[0].HPayProcID;//核算工序ID |
| | | long HGroupID = list[0].HGroupID;//班组ID |
| | | long HDeptID = 0; |
| | | long HEmpID = list[0].HEmpID;//操作员ID |
| | | string HBarCode = list[0].HBarCode;//条形码 |
| | | string HAddr = ""; |
| | | string HBarCodeMaker = ""; |
| | | long HSourceID2 = list[0].HSourceID2;//生产资源2ID |
| | | long HSourceID3 = list[0].HSourceID3;//生产资源3ID |
| | | long HSourceID4 = list[0].HSourceID4;//生产资源4ID |
| | | long HSourceID5 = list[0].HSourceID5;//生产资源5ID |
| | | long HSupID = 0; |
| | | double HQty = list[0].HQty;//合格数量 |
| | | double HPrice = 0; |
| | | double HMoney = 0; |
| | | double HBadCount = list[0].HBadCount;//不良数量 |
| | | long HCenterID = list[0].HCenterID;//工作中心ID |
| | | string HProcNo = list[0].HProcNo;//流水号 |
| | | string HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号 |
| | | string HSourceNameList = list[0].HSourceNameList;//设备清单 |
| | | long HMainSourceInterID = list[0].HInterID;//递入type得到的单据ID |
| | | string HMainSourceBillNo = list[0].HBillNo;//递入type得到的单据号 |
| | | string HMainSourceBillType = "3790"; |
| | | bool HLastSubProc = list[0].HLastSubProc;//转下工序 |
| | | long HEmpID2 = list[0].HEmpID2;//操作员2ID |
| | | long HEmpID3 = list[0].HEmpID3;//操作员3ID |
| | | long HEmpID4 = list[0].HEmpID4;//操作员4ID |
| | | long HEmpID5 = list[0].HEmpID5;//操作员5ID |
| | | double HDSQty = list[0].HDSQty;//折弯刀数 |
| | | double HChongQty = list[0].HChongQty;//NCT冲次数 |
| | | double HPriceRate = list[0].HPriceRate;//系数 |
| | | double HWorkTimes = list[0].HWorkTimes;//工时 |
| | | long HQCCheckID = list[0].HQCCheckID;//检验员ID |
| | | |
| | | //若MAINDI重复则重新获取 |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Insert Into Sc_StationOutBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate,HMouldNum" + |
| | | ",HYear,HPeriod,HRemark,HSourceName,HPieceQty,HWasterQty,HPlanPieceQty,HBadPNL" + |
| | | ",HICMOInterID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" + |
| | | ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationOutTime,HSourceID,HPayProcID" + |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate,HSourceID2,HSourceID3,HSourceID4,HSourceID5" + |
| | | ",HSupID,HQty,HPrice,HMoney,HBadCount,HCenterID,HProcNo,HOrderProcNO,HSourceNameList" + |
| | | ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" + |
| | | ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID" + |
| | | ") " + |
| | | " values('" + BillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate(),'" + HMouldNum + "'" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL + |
| | | "," + HICMOInterID + ",'" + HICMOBillNo + "'," + HProcPlanInterID + "," + HProcPlanEntryID + ",'" + HProcPlanBillNo + "'," + HProcExchInterID + "," + HProcExchEntryID + |
| | | ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",'" + HStationOutTime + "'," + HSourceID + "," + HPayProcID + |
| | | "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" + "," + HSourceID2 + "," + HSourceID3 + "," + HSourceID4 + "," + HSourceID5 + |
| | | "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HBadCount + "," + HCenterID + "," + HProcNo + ",'" + HOrderProcNO + "'" + ",'" + HSourceNameList + "'" + |
| | | "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + Convert.ToString(HLastSubProc ? 1 : 0) + |
| | | "," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID + |
| | | ") "); |
| | | ds = oCN.RunProcReturn("exec h_p_MES_StationOutBill_QtyCtrl " + HInterID + "", "h_p_MES_StationOutBill_QtyCtrl"); |
| | | if (ds == null) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "判断数量失败!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "判断数量失败!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2") |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "数量控制," + ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Out " + HInterID + ",1"); |
| | | oCN.RunProc("exec h_p_Mes_ProcessExchangeChangeStatus " + HInterID + " "); |
| | | oCN.RunProc("exec h_p_Mes_StationOutBillBackBarCode " + HInterID + " "); |
| | | //判断是否是 末道工序 |
| | | ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc from Sc_ProcessExchangeBillMain a " + |
| | | " inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID " + |
| | | " Where a.HInterID=" + HProcExchInterID + " and b.HEntryID=" + HProcExchEntryID + " ", "Sc_ProcessExchangeBillMain"); |
| | | if (ds1 == null || ds1.Tables[0].Rows.Count == 0 || HLastSubProc == false) |
| | | { |
| | | |
| | | } |
| | | else if (ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HLastProc"]) == "是") |
| | | { |
| | | |
| | | } |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "新增单据成功!"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exception!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 返回工序出站汇报单列表 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("Cj_StationOutBill/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList " + sWhere, "h_v_MES_StationOutBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_MES_StationOutBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "false!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucess!"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exception!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | // |
| | | } |
| | | } |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 返回生产汇报单主表详情信息 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("Sc_ProcessMangement/MES_DetailSc_ProcessReportList_Json")] |
| | | [HttpGet] |
| | | public object MES_DetailSc_ProcessReportList_Json(int HInterID) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (HInterID<=0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID小于0!" ; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | |
| | | string sql1 = @"select s1.HInterID,s1.HBillNo,s1.HDeptID,s2.HName,s1.HDate,s1.HPlanQty,s1.HICMOBillNo,s1.HRemark,s2.HNumber |
| | | ,s1.HMaker,s1.HMakeDate,s1.HChecker,s1.HCheckDate,s1.HUpDater,s1.HUpDateDate,s1.HCloseMan,s1.HCloseDate |
| | | from Sc_ProcessReportMain s1 |
| | | inner join Gy_Department s2 on s1.HDeptID=s2.HItemID and s1.HInterID=" + HInterID; |
| | | |
| | | ds = oCN.RunProcReturn(sql1, "Sc_ProcessReportMain"); |
| | | |
| | | } |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有返回任何记录!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 返回生产派工单关联详情信息 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("Sc_ProcessMangement/MES_h_v_Sc_ProcessSendWorkList_Json")] |
| | | [HttpGet] |
| | | public object MES_h_v_Sc_ProcessSendWorkList_Json(int HInterID) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (HInterID <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID小于0!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | |
| | | string sql1 =@"select [hmainid], [日期], [单据号], [HDeptID], [部门代码], [部门], [HMaterID], [物料代码], [物料名称], [规格型号], [HUnitID], [计量单位代码], [计量单位], [HprocID], |
| | | [工序代码], [工序], [HGroupID], [班组代码], [班组名称], [HSourceID], [资源代码], [生产资源], [HWorkerID], [职员代码], [职员], [hsubid], [数量], [计划开工日期], |
| | | [计划完工日期], [计划工时], [表体备注], [HICMOInterID], [生产任务单号], [HSeOrderInterID], [销售订单号], [表头备注], [制单人], [制单日期], [审核人], [审核日期], [修改人], |
| | | [修改日期], [关闭人], [关闭日期], [作废人], [作废日期], [源单主内码], [源单子内码], [源单单号], [源单类型], [行关闭人], [HBillType], [HQtyDecimal], [HPriceDecimal] |
| | | from h_v_Sc_ProcessSendWorkList |
| | | where hmainid=(select HSourceID from Sc_ProcessReportSub where HInterID="+HInterID+")"; |
| | | |
| | | ds = oCN.RunProcReturn(sql1, "h_v_Sc_ProcessSendWorkList"); |
| | | |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有返回任何记录!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 返回生产工序计划单列表 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | |
| | | string UserName; |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | |
| | | lsmain = oListModels.getObjectByJson_Reportlist(msg2); |
| | | foreach (Model.ClsSc_ProcessReportMain oItem in lsmain) |
| | | { |
| | | //oItem.HMaker = ""; |
| | | //UserName = oItem.HMaker; |
| | | UserName = oItem.HMaker; |
| | | oItem.HMaker = UserName; |
| | | oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); |
| | |
| | | reportSub.HEntryID = i; |
| | | reportSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | reportSub.HRemark = ""; |
| | | reportSub.HCloseMan = ""; |
| | | reportSub.HCloseMan = ReportModel.omodel.HCloseMan; |
| | | reportSub.HCloseType = false; |
| | | reportSub.HEmpID =0; |
| | | reportSub.HICMOBillNo =""; |
| | | reportSub.HICMOInterID = (long)ItemView.HICMOInterID; |
| | | reportSub.HEntryID = i; |
| | | reportSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | reportSub.HRemark = ""; |
| | | reportSub.HCloseMan = ""; |
| | | reportSub.HCloseType = false; |
| | | reportSub.HSourceBillType = "3712"; |
| | | reportSub.HQty = (double)ItemView.数量; |
| | | reportSub.HProcID = (long)ItemView.HprocID; |
| | | reportSub.HProcNumber = ItemView.工序代码; |
| | | reportSub.HOutPrice = 0; |
| | | reportSub.HOutMoney = 0; |
| | | reportSub.HSourceID = (long)ItemView.HSourceID; |
| | | reportSub.HSourceID = (long)ItemView.hmainid; |
| | | reportSub.HEmpNumber = ""; |
| | | reportSub.HRelBeginDate = DateTime.Now; |
| | | reportSub.HRelEndDate = DateTime.Now; |
| | |
| | | reportSub.HSeOrderBillNo = ""; |
| | | reportSub.HProcPlanInterID = 0; |
| | | reportSub.HProcPlanBillNo = ""; |
| | | reportSub.HSourceInterID = 0; |
| | | reportSub.HSourceBillNo = ""; |
| | | reportSub.HSourceInterID = (long)ItemView.hmainid; |
| | | reportSub.HSourceBillNo = ItemView.单据号; |
| | | reportSub.HRelationQty = 0; |
| | | reportSub.HRelationMoney = 0; |
| | | reportSub.HMaterID = (long)ItemView.HMaterID; |
| | |
| | | reportSub.HProcPlanEntryID = 0; |
| | | reportSub.HProcPlanBillNo = ""; |
| | | reportSub.HSourceEntryID = 0; |
| | | reportSub.HSourceBillType = ""; |
| | | reportSub.HSourceBillType = "3712"; |
| | | reportSub.HRelationQty = 0; |
| | | reportSub.HRelationMoney = 0; |
| | | reportSub.HBadPrirce = 0; |
| | |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 汇报单编辑关闭功能 |
| | | /// </summary> |
| | | /// <param name="HInterID"></param> |
| | | /// <param name="IsClose"></param> |
| | | /// <param name="CurUserName"></param> |
| | | /// <returns></returns> |
| | | [Route("CloseProcessReportList")] |
| | | [HttpGet] |
| | | public object CloseProcessReportList(int HInterID,int IsClose,string CurUserName) |
| | | { |
| | | DataSet ds; |
| | | string ModRightNameCheck = "Sc_ProcessReport_check"; |
| | | try |
| | | { |
| | | //审核权限 |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "审核失败!无权限!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (HInterID <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID小于0!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from Sc_ProcessReportMain where HInterID=" + HInterID, "Sc_ProcessReportMain"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有这个单据,无法关闭!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | var HChecker = ds.Tables[0].Rows[0]["HChecker"].ToString(); |
| | | var HCloseMan = ds.Tables[0].Rows[0]["HCloseMan"].ToString(); |
| | | |
| | | if (IsClose == 0) |
| | | { |
| | | if (HCloseMan.Trim() != "" || HChecker.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "单据未审核、已关闭、已作废状态下不允许关闭!!!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oCN.RunProc("update Sc_ProcessReportMain set HCloseMan='" + CurUserName + "' ,HCloseDate=GETDATE() where HInterID=" + HInterID); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* 单据关闭成功!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | else if(IsClose==1) |
| | | { |
| | | if (HCloseMan.Trim() == "" || HChecker.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "单据未审核、未关闭、已作废状态下不允许撤销关闭!!!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.RunProc("update Sc_ProcessReportMain set HCloseMan='' ,HCloseDate=null where HInterID=" + HInterID); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* 单据反关闭成功!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "单据无法关闭!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "关闭失败或则反关闭失败!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 汇报单编辑审核反审核功能 |
| | | /// </summary> |
| | | /// <param name="HInterID"></param> |
| | | /// <param name="IsAudit"></param> |
| | | /// <param name="CurUserName"></param> |
| | | /// <returns></returns> |
| | | [Route("AuditProcessReportList")] |
| | | [HttpGet] |
| | | public object AuditProcessReportList(int HInterID, int IsAudit, string CurUserName) |
| | | { |
| | | DataSet ds; |
| | | string ModRightNameCheck = "Sc_ProcessReport_check"; |
| | | var a = DBUtility.ClsPub.CurUserName; |
| | | try |
| | | { |
| | | //审核权限 |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "审核失败!无权限!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (HInterID <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID小于0!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | ds = oCN.RunProcReturn("select * from Sc_ProcessReportMain where HInterID=" + HInterID, "Sc_ProcessReportMain"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有这个单据,无法审核!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | var HChecker = ds.Tables[0].Rows[0]["HChecker"].ToString();//取审核人 |
| | | var HMaker=ds.Tables[0].Rows[0]["HMaker"].ToString();//取制单人 |
| | | var HCloseMan=ds.Tables[0].Rows[0]["HCloseMan"].ToString();//取关闭人 |
| | | if (IsAudit == 0) |
| | | { |
| | | if (HChecker.Trim() != "" || HChecker.Trim() == HMaker || HCloseMan != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "单据已审核、已关闭、已作废状态不允许审核!!!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.RunProc("update Sc_ProcessReportMain set HChecker='" + CurUserName + "' ,HCheckDate=GETDATE() where HInterID=" + HInterID); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* 单据审核成功!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else if (IsAudit == 1) |
| | | { |
| | | if (HChecker.Trim() == "" || HChecker.Trim() == CurUserName || HCloseMan != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "单据未审核、已关闭、已作废状态下不允许反审核!!!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.RunProc("update Sc_ProcessReportMain set HChecker='' ,HCheckDate=null where HInterID=" + HInterID); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* 单据反审核成功!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "单据无法审核!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "审核失败或者反审核失败!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | } |
| | |
| | | "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HDeptID.ToString() + ",'" + omodel.HDeptNumber + "'," + omodel.HGroupID.ToString() + |
| | | ",'" + omodel.HGroupNumber + "'," + omodel.HMaterID.ToString() + ",'" + omodel.HMaterNumber + "'," + omodel.HUnitID.ToString() + ",'" + omodel.HUnitNumber + "'" + |
| | | ", " + omodel.HPlanQty.ToString() + "," + omodel.HInStockQty.ToString() + "," + omodel.HSumTimes.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HRemark + "'" + |
| | | ",'" + omodel.HInnerBillNo + "','" + DBUtility.ClsPub.CurUserName + "',getdate()," + omodel.HSupID.ToString() + ",'" + omodel.HMarker + "'" + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HMaker.ToString() + "',getdate()," + omodel.HSupID.ToString() + ",'" + omodel.HMarker + "'" + |
| | | ") "); |
| | | //插入子表 |
| | | foreach (Model.ClsSc_ProcessReportSub oSub in DetailColl) |
| | |
| | | public long HBadPNL { get; set; } |
| | | public double HPrice_BHS { get; set; } |
| | | public double HMoney_BHS { get; set; } |
| | | public long HCenterID { get; set; } |
| | | public string HMouldNum { get; set; } |
| | | public long lngBillKey { get; set; } |
| | | public long lngBillSubKey { get; set; } |
| | | public DateTime HStationOutTime { get; set; } |
| | | public long HPayProcID { get; set; } |
| | | public long HSourceID2 { get; set; } |
| | | public long HSourceID3 { get; set; } |
| | | public long HSourceID4 { get; set; } |
| | | public long HSourceID5 { get; set; } |
| | | public double HBadCount { get; set; } |
| | | public string HSourceNameList { get; set; } |
| | | public bool HLastSubProc { get; set; } |
| | | public long HEmpID2 { get; set; } |
| | | public long HEmpID3 { get; set; } |
| | | public long HEmpID4 { get; set; } |
| | | public long HEmpID5 { get; set; } |
| | | public double HDSQty { get; set; } |
| | | public double HChongQty { get; set; } |
| | | public double HPriceRate { get; set; } |
| | | public double HWorkTimes { get; set; } |
| | | public long HQCCheckID { get; set; } |
| | | |
| | | |
| | | } |
| | |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <File Include="apiapp.json"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.dll"> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/Dapper.dll"> |
| | | <publishTime>07/22/2016 14:52:40</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> |
| | | <publishTime>09/20/2018 19:23:20</publishTime> |
| | |
| | | <publishTime>07/25/2012 11:48:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/Newtonsoft.Json.dll"> |
| | | <publishTime>08/03/2014 20:33:56</publishTime> |
| | |
| | | <publishTime>01/04/2011 13:48:18</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/Swashbuckle.Core.dll"> |
| | | <publishTime>02/15/2015 17:57:08</publishTime> |
| | |
| | | <publishTime>11/28/2018 13:01:00</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.WebHost.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Mvc.dll"> |
| | | <publishTime>01/28/2015 04:02:18</publishTime> |
| | |
| | | <publishTime>11/24/2014 11:18:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.dll"> |
| | | <publishTime>04/25/2021 08:39:33</publishTime> |
| | | <publishTime>04/22/2021 20:00:19</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.pdb"> |
| | | <publishTime>04/25/2021 08:39:33</publishTime> |
| | | <publishTime>04/22/2021 20:00:19</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.XmlSerializers.dll"> |
| | | <publishTime>02/04/2021 21:35:21</publishTime> |
| | |
| | | <publishTime>03/26/2019 14:23:20</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.css"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.min.css"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Content/Site.css"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="DLL/BLL.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="DLL/DAL.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="DLL/DBUtility.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="DLL/Model.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="DLL/Newtonsoft.Json.Net35.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Class.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Control.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="DLL/SQLHelper.dll"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.eot"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.svg"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.ttf"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.woff"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Global.asax"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Index.html"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="packages.config"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.js"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.min.js"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.js"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.js"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.map"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.js"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.min.js"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/modernizr-2.6.2.js"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/Error.cshtml"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/_Layout.cshtml"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/web.config"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Views/_ViewStart.cshtml"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> |
| | | <publishTime>04/12/2021 11:33:15</publishTime> |
| | | <publishTime>03/26/2021 14:35:48</publishTime> |
| | | </File> |
| | | <File Include="Web.config"> |
| | | <publishTime>04/25/2021 08:39:37</publishTime> |
| | | <publishTime>04/22/2021 20:00:25</publishTime> |
| | | </File> |
| | | </ItemGroup> |
| | | </Project> |
| | |
| | | <Compile Include="Controllers\CGGL\Cg_POInStockBillController.cs" /> |
| | | <Compile Include="Controllers\CGGL\Cg_POInStockBackBillController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Cj_NoPassProcController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Cj_StationOutBillController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Cj_StationInBillController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Cj_StationEntrustOutBillController.cs" /> |
| | | <Compile Include="Controllers\Sc_ProcessMangementController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Cj_StationEntrustInBillController.cs" /> |