/// <summary>
/// 保存标签条码
/// </summary>
/// <param name="B_Barcode"></param>
/// <param name="B_Code"></param>
/// <param name="B_Name"></param>
/// <param name="B_Qty"></param>
/// <param name="B_WorkShopCode"></param>
private void SaveBarcode(string B_Barcode, string B_Code, string B_Name, decimal B_Qty, string B_WorkShopCode)
{
Mes_BarcodeEntity BarcodeEntity = new Mes_BarcodeEntity();
Mes_BarcodeBLL BarcodeBLL = new Mes_BarcodeBLL();
BarcodeEntity.B_Barcode = B_Barcode;
BarcodeEntity.B_Code = B_Code;
BarcodeEntity.B_Name = B_Name;
BarcodeEntity.B_Qty = B_Qty;
BarcodeEntity.B_WorkShopCode = B_WorkShopCode;
BarcodeEntity.B_Ptime = DateTime.Now;
BarcodeEntity.B_Status = 1;
BarcodeBLL.SaveEntity("", BarcodeEntity);
}
/// <summary>
/// 保存标签条码
/// </summary>
/// <param name="B_Barcode"></param>
/// <param name="B_Code"></param>
/// <param name="B_Name"></param>
/// <param name="B_Qty"></param>
/// <param name="B_WorkShopCode"></param>
private void SaveBarcode(string B_Barcode, string B_Code, string B_Name, decimal B_Qty, string B_WorkShopCode)
{
Mes_BarcodeEntity BarcodeEntity = new Mes_BarcodeEntity();
Mes_BarcodeBLL BarcodeBLL = new Mes_BarcodeBLL();
BarcodeEntity.B_Barcode = B_Barcode;
BarcodeEntity.B_Code = B_Code;
BarcodeEntity.B_Name = B_Name;
BarcodeEntity.B_Qty = B_Qty;
BarcodeEntity.B_WorkShopCode = B_WorkShopCode;
DateTime dt = DateTime.Now;
BarcodeEntity.B_Ptime = dt;
BarcodeEntity.B_Itime = dt;
BarcodeEntity.B_Otime = dt;
BarcodeEntity.B_Utime = dt;
BarcodeEntity.B_Remark = "由" + txtQty.Text + "分写而来";
BarcodeEntity.B_Status = 1;
BarcodeBLL.SaveEntity("", BarcodeEntity);
}
/// <summary>
/// 保存实体数据
/// </summary>
/// <param name="keyValue">主键</param>
/// <param name="entity">实体</param>
/// <returns>返回值大于0:操作成功</returns>
public int SaveEntity(string keyValue, Mes_BarcodeEntity entity)
{
try
{
var strSql = new StringBuilder();
var paramList = new List <SqlParameter>();
if (string.IsNullOrEmpty(keyValue))
{
strSql.Append("INSERT INTO Mes_Barcode(");
strSql.Append("ID,");
strSql.Append("B_Barcode,");
strSql.Append("B_Code,");
strSql.Append("B_Name,");
strSql.Append("B_Qty,");
strSql.Append("B_WorkShopCode,");
strSql.Append("B_Status,");
strSql.Append("B_Ptime,");
strSql.Append("B_Itime,");
strSql.Append("B_Otime,");
strSql.Append("B_Utime,");
strSql.Append("B_Remark");
strSql.Append(")");
strSql.Append(" VALUES (");
strSql.Append("@ID,");
strSql.Append("@B_Barcode,");
strSql.Append("@B_Code,");
strSql.Append("@B_Name,");
strSql.Append("@B_Qty,");
strSql.Append("@B_WorkShopCode,");
strSql.Append("@B_Status,");
strSql.Append("@B_Ptime,");
strSql.Append("@B_Itime,");
strSql.Append("@B_Otime,");
strSql.Append("@B_Utime,");
strSql.Append("@B_Remark");
strSql.Append(")");
paramList.Add(new SqlParameter("@ID", Guid.NewGuid().ToString()));
}
else
{
}
paramList.Add(new SqlParameter("@B_Barcode", entity.B_Barcode));
paramList.Add(new SqlParameter("@B_Code", entity.B_Code));
paramList.Add(new SqlParameter("@B_Name", entity.B_Name));
paramList.Add(new SqlParameter("@B_Qty", entity.B_Qty));
paramList.Add(new SqlParameter("@B_WorkShopCode", entity.B_WorkShopCode));
paramList.Add(new SqlParameter("@B_Status", entity.B_Status));
paramList.Add(new SqlParameter("@B_Ptime", entity.B_Ptime));
paramList.Add(new SqlParameter("@B_Itime", entity.B_Itime));
paramList.Add(new SqlParameter("@B_Otime", entity.B_Otime));
paramList.Add(new SqlParameter("@B_Utime", entity.B_Utime));
paramList.Add(new SqlParameter("@B_Remark", entity.B_Remark));
var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray());
return(result);
}
catch (Exception)
{
throw;
}
}
