/// <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; } }