public string GetTicketInfo(string TicketID) { string BoxInfo = string.Empty; int _ticketID = 0; int _group = 0; try { if (TicketID.IndexOf(',') > -1) { // string[] ss = TicketID.Split(','); _ticketID = Convert.ToInt32(TicketID.Substring(0, TicketID.Length - 1)); _group = Convert.ToInt32(TicketID.Substring(TicketID.Length - 1)); } else { _ticketID = Convert.ToInt32(TicketID); } } catch { return(BoxInfo); } Hownet.BLL.WorkTicket bllWT = new Hownet.BLL.WorkTicket(); DataTable dt = bllWT.GetTickInfo(_ticketID).Tables[0]; if (dt.Rows.Count > 0) { return(Table2String(dt)); } else { return(string.Empty); } }
/// <summary> /// 入库处理 /// </summary> /// <param name="Amount">入库数量,工序全部完成自动入库时,设置为-1</param> /// <param name="NID">机器号</param> public static void UpNotAmount(int Amount, int NID) { Hownet.BLL.AmountInfo bllAI = new Hownet.BLL.AmountInfo(); DataRow[] drsMain = BasicTable.dtMain.Select("(No=" + NID + ")"); if (drsMain.Length == 0) { return; } bool t = false; Hownet.BLL.WorkTicket bllWT = new Hownet.BLL.WorkTicket();//有当前卡机的刷卡记录,读出相应分箱记录 DataTable dttWT = bllWT.GetInDepotList(Convert.ToInt32(drsMain[0]["TicketID"])).Tables[0]; List <Hownet.Model.WorkTicket> liWT = bllWT.DataTableToList(dttWT); if (liWT[0].P2DInfoID != 0 && Amount == -1) { return; } #region 更总生产单在线数量 List <Hownet.Model.AmountInfo> liAI = bllAI.GetModelList("(MainID=" + liWT[0].TaskID + ") And (TableTypeID=1) And (MListID=" + liWT[0].MListID + ")"); if (liAI.Count > 0) { if (Amount == -1) { liAI[0].NotAmount -= liWT[0].Amount; } else { if (t) { liAI[0].NotAmount = liAI[0].NotAmount + liWT[0].EligibleAmount - Amount; } else { liAI[0].NotAmount -= Amount; } } bllAI.Update(liAI[0]); } if (liWT[0].TaskID > 0) { liAI = bllAI.GetModelList("(MainID=" + liWT[0].DepartmentID + ") And (TableTypeID=37) And (MListID=" + liWT[0].MListID + ")"); if (liAI.Count > 0) { if (Amount == -1) { liAI[0].NotAmount -= liWT[0].Amount; } else { if (t) { liAI[0].NotAmount = liAI[0].NotAmount + liWT[0].EligibleAmount - Amount; } else { liAI[0].NotAmount -= Amount; } } bllAI.Update(liAI[0]); } } #endregion #region 更新分箱表 liWT[0].EligibleAmount = Amount; liWT[0].InferiorAmount = liWT[0].Amount - Amount; liWT[0].P2DInfoID = -1; liWT[0].P2DDepartmentID = 0; bllWT.Update(liWT[0]); #endregion }
/// <summary> /// 入库处理 /// </summary> /// <param name="Amount">入库数量,工序全部完成自动入库时,设置为-1</param> /// <param name="NID">机器号</param> public static string InDepotAmount(int Amount, int NID, int _depotID) { Hownet.BLL.Product2Depot bllP2D = new Hownet.BLL.Product2Depot(); Hownet.Model.Product2Depot modP2D = new Hownet.Model.Product2Depot(); Hownet.BLL.Product2DepotInfo bllP2DInfo = new Hownet.BLL.Product2DepotInfo(); Hownet.Model.Product2DepotInfo modP2DInfo = new Hownet.Model.Product2DepotInfo(); Hownet.BLL.Repertory bllRep = new Hownet.BLL.Repertory(); Hownet.Model.Repertory modRep = new Hownet.Model.Repertory(); Hownet.BLL.AmountInfo bllAI = new Hownet.BLL.AmountInfo(); DataRow[] drsMain = BasicTable.dtMain.Select("(No=" + NID + ")"); if (drsMain.Length == 0) { return(ReturnStr(0, NID, "无相关记录")); } bool t = false; Hownet.BLL.WorkTicket bllWT = new Hownet.BLL.WorkTicket();//有当前卡机的刷卡记录,读出相应分箱记录 DataTable dttWT = bllWT.GetInDepotList(Convert.ToInt32(drsMain[0]["TicketID"])).Tables[0]; List <Hownet.Model.WorkTicket> liWT = bllWT.DataTableToList(dttWT); if (liWT[0].P2DInfoID > 0 && Amount == -1) { return(ReturnStr(0, NID, "本箱已入库")); } //if (Amount == -1) //{ //} #region 记入入库明细 DataTable dtP2D = new DataTable(); if (Amount == -1) { dtP2D = bllP2D.GetList("(DateTime='" + DateTime.Today + "') And (IsVerify=4) And (DepotID=" + _depotID + ")").Tables[0]; if (dtP2D.Rows.Count == 0)//查出当天已审核的该仓库入库表 { modP2D = new Hownet.Model.Product2Depot(); modP2D.DateTime = DateTime.Today; modP2D.Num = bllP2D.NewNum(modP2D.DateTime); modP2D.DepotID = _depotID; modP2D.IsVerify = 4; modP2D.VerifyMan = 0; modP2D.VerifyDate = modP2D.DateTime; modP2D.UpData = 1; modP2D.A = 1; modP2D.TypeID = 8; modP2D.Remark = ""; modP2D.ID = bllP2D.Add(modP2D); dtP2D = bllP2D.GetList("(ID=" + modP2D.ID + ")").Tables[0]; } } if (liWT[0].P2DInfoID > 0)//这箱货已有入库单编号 { modP2DInfo = bllP2DInfo.GetModel(liWT[0].P2DInfoID); if (Amount == -1) { if (modP2DInfo.MainID == Convert.ToInt32(dtP2D.Rows[0]["ID"]))//这个入库单明细的主表,等于今天的自动入库单编号 { Amount = Convert.ToInt32(drsMain[0]["Amount"]); modP2DInfo.Amount = modP2DInfo.Amount - liWT[0].EligibleAmount + Amount;//更新入库数量 bllP2DInfo.Update(modP2DInfo); t = true; } else { return(ReturnStr(0, NID, "已于此前入库")); } } else { modP2DInfo.Amount = modP2DInfo.Amount - liWT[0].EligibleAmount + Amount;//更新入库数量 bllP2DInfo.Update(modP2DInfo); t = true; } } else { if (Amount == -1) { Amount = Convert.ToInt32(drsMain[0]["Amount"]); } modP2DInfo = new Hownet.Model.Product2DepotInfo(); modP2DInfo.A = modP2DInfo.ID = 0; modP2DInfo.MainID = Convert.ToInt32(dtP2D.Rows[0]["ID"]); modP2DInfo.MaterielID = Convert.ToInt32(drsMain[0]["MaterielID"]); modP2DInfo.ColorID = liWT[0].ColorID; modP2DInfo.ColorOneID = liWT[0].ColorOneID; modP2DInfo.ColorTwoID = liWT[0].ColorTwoID; modP2DInfo.DeparmentID = liWT[0].DepartmentID; modP2DInfo.SizeID = liWT[0].SizeID; modP2DInfo.BrandID = liWT[0].BrandID; modP2DInfo.Remark = ""; modP2DInfo.TaskID = liWT[0].TaskID; modP2DInfo.Amount = Amount; if (liWT[0].MListID > 0) { modP2DInfo.MListID = liWT[0].MListID; } else { Hownet.BLL.MaterielList bllML = new Hownet.BLL.MaterielList(); Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList(); modML.A = 1; } liWT[0].P2DInfoID = modP2DInfo.ID = bllP2DInfo.Add(modP2DInfo); } #endregion #region 更新库存 try { DataTable dtRep = bllRep.GetList("(DepartmentID=" + _depotID + ") And (MListID=" + liWT[0].MListID + ")").Tables[0]; if (dtRep.Rows.Count > 0) { modRep = bllRep.GetModel(Convert.ToInt32(dtRep.Rows[0]["ID"])); if (Amount == -1) { modRep.Amount += liWT[0].Amount; } else { if (t) { modRep.Amount = modRep.Amount - liWT[0].EligibleAmount + Amount; } else { modRep.Amount += Amount; } } bllRep.Update(modRep); } else { Hownet.BLL.Materiel bllMat = new Hownet.BLL.Materiel(); modRep = new Hownet.Model.Repertory(); modRep.ID = modRep.A = 0; modRep.MListID = liWT[0].MListID; modRep.MeasureID = bllMat.GetModel(Convert.ToInt32(drsMain[0]["MaterielID"])).MeasureID; modRep.ColorID = liWT[0].ColorID; modRep.ColorOneID = liWT[0].ColorOneID; modRep.ColorTwoID = liWT[0].ColorTwoID; modRep.SizeID = liWT[0].SizeID; modRep.BrandID = liWT[0].BrandID; modRep.CompanyID = 0; modRep.DepartmentID = _depotID; modRep.Amount = Amount; modRep.MaterielID = Convert.ToInt32(drsMain[0]["MaterielID"]); bllRep.Add(modRep); } #endregion #region 更总生产单在线数量 List <Hownet.Model.AmountInfo> liAI = bllAI.GetModelList("(MainID=" + liWT[0].TaskID + ") And (TableTypeID=1) And (MListID=" + liWT[0].MListID + ")"); if (liAI.Count > 0) { if (Amount == -1) { liAI[0].NotAmount -= liWT[0].Amount; } else { if (t) { liAI[0].NotAmount = liAI[0].NotAmount + liWT[0].EligibleAmount - Amount; } else { liAI[0].NotAmount -= Amount; } } bllAI.Update(liAI[0]); } if (liWT[0].TaskID > 0) { liAI = bllAI.GetModelList("(MainID=" + liWT[0].DepartmentID + ") And (TableTypeID=37) And (MListID=" + liWT[0].MListID + ")"); if (liAI.Count > 0) { if (Amount == -1) { liAI[0].NotAmount -= liWT[0].Amount; } else { if (t) { liAI[0].NotAmount = liAI[0].NotAmount + liWT[0].EligibleAmount - Amount; } else { liAI[0].NotAmount -= Amount; } } bllAI.Update(liAI[0]); } } #endregion #region 更新分箱表 liWT[0].EligibleAmount = Amount; liWT[0].InferiorAmount = liWT[0].Amount - Amount; liWT[0].P2DInfoID = modP2DInfo.ID; liWT[0].P2DDepartmentID = _depotID; bllWT.Update(liWT[0]); #endregion if (Amount > 0 && t) { for (int i = 0; i < drsMain.Length; i++) { drsMain[i].Delete(); } BasicTable.dtMain.AcceptChanges(); } DataTable dtttt = bllP2D.GetSumAmount(DateTime.Today, modP2DInfo.DeparmentID).Tables[0]; string ttt = string.Empty; if (dtttt.Rows.Count > 0) { ttt = dtttt.Rows[0]["Name"].ToString(); } int l = 15 - gb.GetByteCount(ttt); if (l > 0) { for (int i = 0; i < l; i++) { ttt = ttt + " "; } } ttt += dtttt.Rows[0]["Amount"].ToString(); return(ReturnStr(0, NID, ttt)); } catch (Exception ex) { return(ReturnStr(0, NID, "错误")); } }
public string EmpAddWork(string TicketInfoID, string EmpID, string TicketTime) { if (TicketInfoID == string.Empty || TicketTime == string.Empty) { return("工序卡刷卡不正确"); } if (Convert.ToDateTime(TicketTime).AddSeconds(30) < DateTime.Now) { return("刷卡超时"); } if (EmpID == string.Empty) { return(string.Empty); } try { Hownet.BLL.MiniEmp bllME = new Hownet.BLL.MiniEmp(); Hownet.Model.MiniEmp modME = bllME.GetModel(Convert.ToInt32(EmpID)); if (modME == null) { return("员工不正确"); } if (Convert.ToDateTime(modME.DimDate) > Convert.ToDateTime("1900-1-1")) { return("员工已离职!"); } Hownet.BLL.WorkTicketInfo bllWTI = new Hownet.BLL.WorkTicketInfo(); Hownet.Model.WorkTicketInfo modWTI = bllWTI.GetModel(Convert.ToInt32(TicketInfoID)); if (modWTI == null) { return("工序卡刷卡不正确"); } if (modWTI.EmployeeID > 0) { return("该工序已被完成"); } Hownet.BLL.Working bllW = new Hownet.BLL.Working(); Hownet.Model.Working modW = bllW.GetModel(modWTI.WorkingID); if (!CheckWorkType(modW.WorkTypeID.ToString(), modME.WorkTypeID)) { return("工种不匹配"); } DateTime dtNow = DateTime.Now; Hownet.BLL.ProductTaskMain bllPTM = new Hownet.BLL.ProductTaskMain(); Hownet.Model.ProductTaskMain modPTM = bllPTM.GetModel(modWTI.TaskID); bllWTI.GetBarBack(modWTI.ID, modME.ID, dtNow, 1); bllWTI.AddPayInfo(modPTM.MaterielID, modWTI.ID, modPTM.DateTime.ToString("yyyyMMdd") + modPTM.Num.ToString().PadLeft(3, '0')); DataRow[] drs = ReaderCard.BasicTable.dtWTCard.Select("(InfoID=" + TicketInfoID + ")"); if (drs.Length == 1) { drs[0]["EmployeeID"] = modME.ID; drs[0]["MiniEmpName"] = modME.Name; drs[0]["DateTime"] = DateTime.Now; } if (modWTI.WorkingID == BasicTable.BackDepotWorkingID) { Hownet.BLL.WorkTicket bllWT = new Hownet.BLL.WorkTicket(); Hownet.Model.WorkTicket modWT = bllWT.GetModel(modWTI.MainID); if (modWT.P2DInfoID == 0) { Hownet.BLL.AmountInfo bllAI = new Hownet.BLL.AmountInfo(); List <Hownet.Model.AmountInfo> liAI = bllAI.GetModelList("(MainID=" + modWT.TaskID + ") And (TableTypeID=1) And (MListID=" + modWT.MListID + ")"); if (liAI.Count > 0) { liAI[0].NotAmount -= modWT.Amount; bllAI.Update(liAI[0]); } } } return("今天总产量:" + bllWTI.CountAmount(modME.ID, dtNow, ReaderCard.BasicTable.IsShowMoney).ToString()); } catch { return("对不起,出现错误!"); } //return string.Empty; }
public string GetBoxInfo(string TicketID) { // string BoxInfo = string.Empty; StringBuilder BoxInfo = new StringBuilder(); int _ticketID = 0; int _group = 0; try { //if (TicketID.IndexOf(',') > -1) //{ //string[] ss = TicketID.Split(','); _ticketID = Convert.ToInt32(TicketID.Substring(0, TicketID.Length - 1)); _group = Convert.ToInt32(TicketID.Substring(TicketID.Length - 1)); //} //else //{ // _ticketID = Convert.ToInt32(TicketID); //} } catch { return(BoxInfo.ToString()); } DataTable dtt = new DataTable(); dtt.TableName = "dt"; dtt.Columns.Add("Remark", typeof(string)); dtt.Columns.Add("WorkingName", typeof(string)); dtt.Columns.Add("WTIID", typeof(int)); dtt.Columns.Add("IsCanMove", typeof(bool)); dtt.Columns.Add("dtNow", typeof(string)); DataRow[] drs = ReaderCard.BasicTable.dtWTCard.Select("(TicketID=" + _ticketID + ") And (GroupBy=" + _group + ")"); if (drs.Length == 0) { DataTable dttt = BasicTable.bllWTIDC.GetAllListByTicketID(_ticketID, _group).Tables[0]; if (dttt.Rows.Count == 0) { #region Hownet.BLL.WorkTicket bllWT = new Hownet.BLL.WorkTicket(); DataSet ds = bllWT.GetBoxInfo(_ticketID, _group); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { BoxInfo.Append("箱号:"); BoxInfo.Append(dt.Rows[0]["BoxNum"].ToString()); BoxInfo.Append(",款号:"); BoxInfo.Append(dt.Rows[0]["MaterielName"].ToString()); if (dt.Rows[0]["BrandName"] != null && dt.Rows[0]["BrandName"].ToString() != string.Empty) { BoxInfo.Append(", 商标:"); BoxInfo.Append(dt.Rows[0]["BrandName"].ToString()); } if (dt.Rows[0]["ColorName"] != null && dt.Rows[0]["ColorName"].ToString() != string.Empty) { BoxInfo.Append(", 颜色:"); BoxInfo.Append(dt.Rows[0]["ColorName"].ToString()); } if (dt.Rows[0]["SizeName"] != null && dt.Rows[0]["SizeName"].ToString() != string.Empty) { BoxInfo.Append(", 尺码:"); BoxInfo.Append(dt.Rows[0]["SizeName"].ToString()); } if (dt.Rows[0]["ColorOneName"] != null && dt.Rows[0]["ColorOneName"].ToString() != string.Empty) { BoxInfo.Append(", 配色一:"); BoxInfo.Append(dt.Rows[0]["ColorOneName"].ToString()); } if (dt.Rows[0]["ColorTwoName"] != null && dt.Rows[0]["ColorTwoName"].ToString() != string.Empty) { BoxInfo.Append(", 配色二:"); BoxInfo.Append(dt.Rows[0]["ColorTwoName"].ToString()); } BoxInfo.Append(", 数量:"); BoxInfo.Append(dt.Rows[0]["Amount"].ToString()); DataRow dr = dtt.NewRow(); dr[0] = BoxInfo; string amount = "0"; if (ds.Tables[1].Rows.Count > 0) { dr[1] = " " + ds.Tables[1].Rows[0][0].ToString(); dr[2] = ds.Tables[1].Rows[0][1]; dr[3] = ds.Tables[1].Rows[0][2]; amount = ds.Tables[1].Rows[0][3].ToString(); } else { dr[1] = " 所有工序已完成"; dr[2] = 0; dr[3] = false; } dr[4] = DateTime.Now.ToString(); dtt.Rows.Add(dr); BoxInfo.Append("й"); BoxInfo.Append(dr[1].ToString() + " " + amount); BoxInfo.Append("й"); BoxInfo.Append(dr[2].ToString()); BoxInfo.Append("й"); BoxInfo.Append(dr[3].ToString()); BoxInfo.Append("й"); BoxInfo.Append(DateTime.Now.ToLongTimeString()); return(BoxInfo.ToString()); } else { return(BoxInfo.ToString()); } #endregion } else { for (int i = 0; i < dttt.Rows.Count; i++) { ReaderCard.BasicTable.dtWTCard.Rows.Add(dttt.Rows[i].ItemArray); } drs = ReaderCard.BasicTable.dtWTCard.Select("(TicketID=" + _ticketID + ") And (GroupBy=" + _group + ")"); } } if (drs.Length > 0) { BoxInfo.Append("箱号:"); BoxInfo.Append(drs[0]["BoxNum"].ToString()); BoxInfo.Append(",款号:"); BoxInfo.Append(drs[0]["MaterielName"].ToString()); // BoxInfo = "箱号:" + drs[0]["BoxNum"].ToString() + ",款号:" + drs[0]["MaterielName"].ToString(); //if (drs[0]["BrandName"] != null && drs[0]["BrandName"].ToString() != string.Empty) //{ // BoxInfo += ", 商标:" + drs[0]["BrandName"].ToString(); //} if (drs[0]["ColorName"] != null && drs[0]["ColorName"].ToString() != string.Empty) { BoxInfo.Append(", 颜色:"); BoxInfo.Append(drs[0]["ColorName"].ToString()); } if (drs[0]["SizeName"] != null && drs[0]["SizeName"].ToString() != string.Empty) { BoxInfo.Append(", 尺码:"); BoxInfo.Append(drs[0]["SizeName"].ToString()); } //if (drs[0]["ColorOneName"] != null && drs[0]["ColorOneName"].ToString() != string.Empty) //{ // BoxInfo += ", 配色一:" + drs[0]["ColorOneName"].ToString(); //} //if (drs[0]["ColorTwoName"] != null && drs[0]["ColorTwoName"].ToString() != string.Empty) //{ // BoxInfo += ", 配色二:" + drs[0]["ColorTwoName"].ToString(); //} BoxInfo.Append(", 数量:"); BoxInfo.Append(drs[0]["Amount"].ToString()); DataRow dr = dtt.NewRow(); dr[0] = BoxInfo; DataRow[] ddrs = ReaderCard.BasicTable.dtWTCard.Select("(TicketID=" + _ticketID + ") And (GroupBy=" + _group + ") And (EmployeeID=0)", "Orders"); if (ddrs.Length > 0) { dr[1] = ddrs[0]["WorkingName"].ToString(); dr[2] = ddrs[0]["InfoID"]; dr[3] = ddrs[0]["IsCanMove"]; } else { dr[1] = " 所有工序已完成"; dr[2] = 0; dr[3] = false; } dr[4] = DateTime.Now.ToString(); dtt.Rows.Add(dr); BoxInfo.Append("й"); BoxInfo.Append(dr[1].ToString());// + " " + ddrs[0]["Amount"].ToString()); BoxInfo.Append("й"); BoxInfo.Append(dr[2].ToString()); BoxInfo.Append("й"); BoxInfo.Append(dr[3].ToString()); BoxInfo.Append("й"); BoxInfo.Append(DateTime.Now.ToLongTimeString()); return(BoxInfo.ToString());; } else { return(BoxInfo.ToString());; } }