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());;
}
}
