/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SerialNumber DataRowToModel(DataRow row)
{
Maticsoft.Model.SerialNumber model = new Maticsoft.Model.SerialNumber();
if (row != null)
{
if (row["SN"] != null)
{
model.SN = row["SN"].ToString();
}
if (row["Type"] != null)
{
model.Type = row["Type"].ToString();
}
if (row["State"] != null)
{
model.State = row["State"].ToString();
}
if (row["BatchNO"] != null)
{
model.BatchNO = row["BatchNO"].ToString();
}
if (row["OrderID"] != null)
{
model.OrderID = row["OrderID"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SerialNumber model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_SerialNumber set ");
strSql.Append("Type=@Type,");
strSql.Append("State=@State,");
strSql.Append("BatchNO=@BatchNO,");
strSql.Append("OrderID=@OrderID");
strSql.Append(" where SN=@SN ");
SqlParameter[] parameters =
{
new SqlParameter("@Type", SqlDbType.VarChar, 20),
new SqlParameter("@State", SqlDbType.VarChar, 20),
new SqlParameter("@BatchNO", SqlDbType.VarChar, 20),
new SqlParameter("@OrderID", SqlDbType.VarChar, 20),
new SqlParameter("@SN", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.Type;
parameters[1].Value = model.State;
parameters[2].Value = model.BatchNO;
parameters[3].Value = model.OrderID;
parameters[4].Value = model.SN;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.SerialNumber model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_SerialNumber(");
strSql.Append("SN,Type,State,BatchNO,OrderID)");
strSql.Append(" values (");
strSql.Append("@SN,@Type,@State,@BatchNO,@OrderID)");
SqlParameter[] parameters =
{
new SqlParameter("@SN", SqlDbType.VarChar, 20),
new SqlParameter("@Type", SqlDbType.VarChar, 20),
new SqlParameter("@State", SqlDbType.VarChar, 20),
new SqlParameter("@BatchNO", SqlDbType.VarChar, 20),
new SqlParameter("@OrderID", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.SN;
parameters[1].Value = model.Type;
parameters[2].Value = model.State;
parameters[3].Value = model.BatchNO;
parameters[4].Value = model.OrderID;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SerialNumber GetModel(string SN)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SN,Type,State,BatchNO,OrderID from tb_SerialNumber ");
strSql.Append(" where SN=@SN ");
SqlParameter[] parameters =
{
new SqlParameter("@SN", SqlDbType.VarChar, 20)
};
parameters[0].Value = SN;
Maticsoft.Model.SerialNumber model = new Maticsoft.Model.SerialNumber();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SerialNumber model)
{
return(dal.Update(model));
}
/// <summary>
/// 批量增加条码
/// </summary>
/// <param name="model">抽象类 serialnumber</param>
/// <param name="StartSN">开始编码</param>
/// <param name="OrderCount">工单总量</param>
/// <returns></returns>
public string Add(Maticsoft.Model.SerialNumber model, long StartSN, int OrderCount)
{
return(dal.serialNumber_Value(_InspectMethod, model, StartSN, OrderCount));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.SerialNumber model)
{
return(dal.Add(model));
}
/// <summary>
/// 生成并保存外袋
/// </summary>
/// <returns></returns>
public string Sack_SerialNumber(string ordrID, string sackQty)
{
/***********************************************************
*
* 编码规则为：工单单号+00001
* 外袋编码Demo ：130000100001
*
* *********************************************************/
if (ordrID != "" && sackQty != "")
{
WorkOrder wo = new WorkOrder();
Maticsoft.Model.WorkOrder Tem = wo.GetModel(ordrID);
int orderCount = 0;
if (Tem != null)
{
orderCount = int.Parse(Tem.Count); //总批量
}
int _TemSackQty = int.Parse(sackQty); //单袋数量
int _TemGenerateCount = orderCount / _TemSackQty; //需要生成多少个外袋编码
long SN = long.Parse(ordrID.Substring(4, 7) + "00000");
int Add_Yet = 0, Add_Not = 0; //记录添加成功的数量
string message = "";
//实体类赋值
Maticsoft.Model.SerialNumber temSerialNumber = new Maticsoft.Model.SerialNumber();
temSerialNumber.OrderID = ordrID;
temSerialNumber.Type = Maticsoft.Model.E_SerialNumber_Type.SackSN.ToString();
if (Exists_Where("(OrderID ='" + temSerialNumber.OrderID + "') AND ( Type ='" + temSerialNumber.Type + "')"))
{
Add_Yet = GetRecordCount("(SN ='" + temSerialNumber.SN + "') AND ( Type ='" + temSerialNumber.OrderID + "')");
message = "工单:" + ordrID + "外袋编码已添加！";
}
else
{
string tem_ExrrySnList = "";
for (int i = 1; i < _TemGenerateCount + 1; i++)
{
temSerialNumber.SN = (SN + i).ToString();
//判断是否重复
if (!Exists_Where("(OrderID ='" + temSerialNumber.OrderID + "') AND ( Type ='" + temSerialNumber.Type + "')"))
{
//判断是否添加成功
if (Add(temSerialNumber))
{
Add_Yet++; //记录添加成功数量
}
else
{
Add_Not++; tem_ExrrySnList += "\r\n：" + temSerialNumber.SN + "\r\n";
}
}
else
{
tem_ExrrySnList += "\r\n此编码重复：" + temSerialNumber.SN + "\r\n";
}
}
message = "外袋编码添加\r\n成功：" + Add_Yet + "条\r\n失败：" + Add_Not + "条" + tem_ExrrySnList;
}
return(message);
}
else
{
string message = "未添加外袋条码！";
return(message);
}
}
