/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model</param> public int AddRecord(CCheckPalletData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("set nocount on; "); strSql.Append("insert into CCheckPallet("); strSql.Append(@"InvoiceNo,StockUpBillNo,PalletNo,PalletIndex,ShippingMarkNo,BoxNo,MainBoxNo,Quantity,isrtEmpId,isrtDt)"); strSql.Append(" values ("); strSql.Append(@"@InvoiceNo,@StockUpBillNo,@PalletNo,@PalletIndex,@ShippingMarkNo,@BoxNo,@MainBoxNo,@Quantity,@isrtEmpId,@isrtDt)"); strSql.Append("; select @@identity; set nocount off; "); SqlParameter[] parameters = { new SqlParameter("@InvoiceNo", SqlDbType.VarChar,40), new SqlParameter("@StockUpBillNo", SqlDbType.VarChar,20), new SqlParameter("@PalletNo", SqlDbType.VarChar,20), new SqlParameter("@PalletIndex", SqlDbType.Int), new SqlParameter("@ShippingMarkNo", SqlDbType.NVarChar,20), new SqlParameter("@BoxNo", SqlDbType.VarChar,20), new SqlParameter("@MainBoxNo", SqlDbType.VarChar,20), new SqlParameter("@Quantity", SqlDbType.Decimal,9), new SqlParameter("@isrtEmpId", SqlDbType.Int), new SqlParameter("@isrtDt", SqlDbType.DateTime) }; parameters[0].Value = model.InvoiceNo; parameters[1].Value = model.StockUpBillNo; parameters[2].Value = model.PalletNo; parameters[3].Value = model.PalletIndex; parameters[4].Value = model.ShippingMarkNo; parameters[5].Value = model.BoxNo; parameters[6].Value = model.MainBoxNo; parameters[7].Value = model.Quantity; parameters[8].Value = model.isrtEmpId; parameters[9].Value = model.isrtDt == string.Empty ? null : model.isrtDt; int id = 0; try { object ret = SqlHelper.ExecuteScalar(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ret != null && ret != DBNull.Value) { id = Convert.ToInt32(ret); } } catch (Exception ex) { throw ex; } return id; }
public bool AddNewCcheckRecord(string BoxNo, string InvoiceNo, string ShippingMarkNo, string StockUpBillNo, string PalletIndex, string Quantity, string PalletNo, string isrtEmpId, string isrtDt, string MainBoxNo) { //ccheckInfo.Add(boxNo); // ccheckInfo.Add(invoiceNo); // ccheckInfo.Add(shippingMarkNo); // ccheckInfo.Add(stockUpBillNo); // ccheckInfo.Add(palletIndex); // ccheckInfo.Add(leavingNum); // ccheckInfo.Add(palletNo); // ccheckInfo.Add(isrtEmpId); // ccheckInfo.Add(isrtDt); // ccheckInfo.Add(mainBoxNo); CCheckPalletData ccheckPalletData = new CCheckPalletData(); CCheckPalletBC ccheckPalletBC = new CCheckPalletBC(); ccheckPalletData.BoxNo = BoxNo; ccheckPalletData.InvoiceNo = InvoiceNo; ccheckPalletData.ShippingMarkNo = ShippingMarkNo; ccheckPalletData.StockUpBillNo = StockUpBillNo; ccheckPalletData.PalletIndex = int.Parse(PalletIndex); ccheckPalletData.Quantity = int.Parse(Quantity); ccheckPalletData.PalletNo = PalletNo; ccheckPalletData.isrtEmpId = int.Parse(isrtEmpId); ccheckPalletData.isrtDt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ccheckPalletData.MainBoxNo = MainBoxNo; try { int result = ccheckPalletBC.AddRecord(ccheckPalletData); if (result > 0) return true; else { return false; } } catch { return false; } finally { ccheckPalletBC.Dispose(); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(CCheckPalletData model) { bool ret = false; StringBuilder strSql = new StringBuilder(); strSql.Append("update CCheckPallet set "); strSql.Append("InvoiceNo=@InvoiceNo,"); strSql.Append("StockUpBillNo=@StockUpBillNo,"); strSql.Append("PalletNo=@PalletNo,"); strSql.Append("PalletIndex=@PalletIndex,"); strSql.Append("ShippingMarkNo=@ShippingMarkNo,"); strSql.Append("BoxNo=@BoxNo,"); strSql.Append("MainBoxNo=@MainBoxNo,"); strSql.Append("Quantity=@Quantity,"); strSql.Append("isrtEmpId=@isrtEmpId,"); strSql.Append("isrtDt=@isrtDt"); strSql.Append(" where ID = @ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@InvoiceNo", SqlDbType.VarChar,40), new SqlParameter("@StockUpBillNo", SqlDbType.VarChar,20), new SqlParameter("@PalletNo", SqlDbType.VarChar,20), new SqlParameter("@PalletIndex", SqlDbType.Int), new SqlParameter("@ShippingMarkNo", SqlDbType.NVarChar,20), new SqlParameter("@BoxNo", SqlDbType.VarChar,20), new SqlParameter("@MainBoxNo", SqlDbType.VarChar,20), new SqlParameter("@Quantity", SqlDbType.Decimal,9), new SqlParameter("@isrtEmpId", SqlDbType.Int), new SqlParameter("@isrtDt", SqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = model.InvoiceNo; parameters[2].Value = model.StockUpBillNo; parameters[3].Value = model.PalletNo; parameters[4].Value = model.PalletIndex; parameters[5].Value = model.ShippingMarkNo; parameters[6].Value = model.BoxNo; parameters[7].Value = model.MainBoxNo; parameters[8].Value = model.Quantity; parameters[9].Value = model.isrtEmpId; parameters[10].Value = model.isrtDt == string.Empty ? null : model.isrtDt; try { SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); ret = true; } catch (Exception ex) { throw ex; } return ret; }
/// <summary> /// 得到一个model /// </summary> /// <param name="ID">主键值</param> /// <returns>model</returns> public CCheckPalletData GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select ID,InvoiceNo,StockUpBillNo,PalletNo,PalletIndex,ShippingMarkNo,BoxNo,MainBoxNo,Quantity,isrtEmpId,isrtDt from CCheckPallet"); strSql.Append(" where ID = @ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = ID; CCheckPalletData model = new CCheckPalletData(); DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; if (row["ID"] != DBNull.Value) { model.ID = Convert.ToInt32(row["ID"]); } if (row["InvoiceNo"] != DBNull.Value) { model.InvoiceNo = Convert.ToString(row["InvoiceNo"]); } if (row["StockUpBillNo"] != DBNull.Value) { model.StockUpBillNo = Convert.ToString(row["StockUpBillNo"]); } if (row["PalletNo"] != DBNull.Value) { model.PalletNo = Convert.ToString(row["PalletNo"]); } if (row["PalletIndex"] != DBNull.Value) { model.PalletIndex = Convert.ToInt32(row["PalletIndex"]); } if (row["ShippingMarkNo"] != DBNull.Value) { model.ShippingMarkNo = Convert.ToString(row["ShippingMarkNo"]); } if (row["BoxNo"] != DBNull.Value) { model.BoxNo = Convert.ToString(row["BoxNo"]); } if (row["MainBoxNo"] != DBNull.Value) { model.MainBoxNo = Convert.ToString(row["MainBoxNo"]); } if (row["Quantity"] != DBNull.Value) { model.Quantity = Convert.ToDecimal(row["Quantity"]); } if (row["isrtEmpId"] != DBNull.Value) { model.isrtEmpId = Convert.ToInt32(row["isrtEmpId"]); } if (row["isrtDt"] != DBNull.Value) { model.isrtDt = Convert.ToString(row["isrtDt"]); } return model; } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(CCheckPalletData model) { return this.checkPalletDB.ModifyRecord(model); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model</param> public int AddRecord(CCheckPalletData model) { return this.checkPalletDB.AddRecord(model); }
/// <summary> /// 更新一条"CCheckPallet"信息 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(CCheckPalletData model) { bool ret = false; SqlTransaction trans = null; try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TransModify"); this.checkPalletBB.Transaction = trans; this.errorDiaryBB.Transaction = trans; this.operatDiaryBB.Transaction = trans; } this.checkPalletBB.ModifyRecord(model); SOperatDiaryData operatDiaryData = new SOperatDiaryData(); operatDiaryData.empId = this.empId; operatDiaryData.functionId = ""; operatDiaryData.recordId = model.ID.ToString(); operatDiaryData.operateContent = "CCheckPallet修改一条id为“" + model.ID.ToString() + "”的记录"; this.operatDiaryBB.AddRecord(operatDiaryData); if (this.transaction == null) trans.Commit(); ret = true; } catch (Exception ex) { if (this.transaction == null) trans.Rollback("TransModify"); SErrorDiaryData errorDiaryData = new SErrorDiaryData(); errorDiaryData.empId = this.empId; errorDiaryData.functionId = ""; errorDiaryData.errorText = "CCheckPallet修改记录“" + model.ID.ToString() + "”时报错:" + ex.Message; this.errorDiaryBB.AddRecord(errorDiaryData); throw ex; } finally { } return ret; }
/// <summary> /// 增加一条"CCheckPallet"信息 /// </summary> /// <param name="model">model</param> public int AddRecord(CCheckPalletData model) { int id = 0; SqlTransaction trans = null; try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TransAdd"); this.checkPalletBB.Transaction = trans; this.errorDiaryBB.Transaction = trans; this.operatDiaryBB.Transaction = trans; } id = this.checkPalletBB.AddRecord(model); SOperatDiaryData operatDiaryData = new SOperatDiaryData(); operatDiaryData.empId = this.empId; operatDiaryData.functionId = ""; operatDiaryData.recordId = id.ToString(); operatDiaryData.operateContent = "CCheckPallet增加一条id为“" + id.ToString() + "”的记录"; this.operatDiaryBB.AddRecord(operatDiaryData); if (this.transaction == null) trans.Commit(); } catch (Exception ex) { if (this.transaction == null) trans.Rollback("TransAdd"); SErrorDiaryData errorDiaryData = new SErrorDiaryData(); errorDiaryData.empId = this.empId; errorDiaryData.functionId = ""; errorDiaryData.errorText = "CCheckPallet增加记录时报错:" + ex.Message; this.errorDiaryBB.AddRecord(errorDiaryData); throw ex; } finally { } return id; }