/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model</param> public int AddRecord(UStockCheckDetail_JoeyData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("set nocount on; "); strSql.Append("insert into UStockCheckDetail_Joey("); strSql.Append(@"StockCheckBillNo,WareNo,WareLocatorNo,PalletNo,BoxNo,MaterialNo,UnityNo,FactPackNo,WmsNo,Num, CheckResult,CheckPersonId,CheckDate)"); strSql.Append(" values ("); strSql.Append(@"@StockCheckBillNo,@WareNo,@WareLocatorNo,@PalletNo,@BoxNo,@MaterialNo,@UnityNo,@FactPackNo,@WmsNo,@Num, @CheckResult,@CheckPersonId,@CheckDate)"); strSql.Append("; select @@identity; set nocount off; "); SqlParameter[] parameters = { new SqlParameter("@StockCheckBillNo", SqlDbType.NVarChar,50), new SqlParameter("@WareNo", SqlDbType.NVarChar,50), new SqlParameter("@WareLocatorNo", SqlDbType.NVarChar,50), new SqlParameter("@PalletNo", SqlDbType.NVarChar,50), new SqlParameter("@BoxNo", SqlDbType.NVarChar,50), new SqlParameter("@MaterialNo", SqlDbType.NVarChar,50), new SqlParameter("@UnityNo", SqlDbType.Int), new SqlParameter("@FactPackNo", SqlDbType.Int), new SqlParameter("@WmsNo", SqlDbType.Int), new SqlParameter("@Num", SqlDbType.Int), new SqlParameter("@CheckResult", SqlDbType.NVarChar,50), new SqlParameter("@CheckPersonId", SqlDbType.Int), new SqlParameter("@CheckDate", SqlDbType.DateTime) }; parameters[0].Value = model.StockCheckBillNo; parameters[1].Value = model.WareNo; parameters[2].Value = model.WareLocatorNo; parameters[3].Value = model.PalletNo; parameters[4].Value = model.BoxNo; parameters[5].Value = model.MaterialNo; parameters[6].Value = model.UnityNo; parameters[7].Value = model.FactPackNo; parameters[8].Value = model.WmsNo; parameters[9].Value = model.Num; parameters[10].Value = model.CheckResult; parameters[11].Value = model.CheckPersonId; parameters[12].Value = model.CheckDate == string.Empty ? null : model.CheckDate; 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; }
/// <summary> /// 更新一条"UStockCheckDetail_Joey"信息 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(UStockCheckDetail_JoeyData model) { bool ret = false; SqlTransaction trans = null; try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TransModify"); this.stockCheckDetail_JoeyBB.Transaction = trans; this.errorDiaryBB.Transaction = trans; this.operatDiaryBB.Transaction = trans; } this.stockCheckDetail_JoeyBB.ModifyRecord(model); SOperatDiaryData operatDiaryData = new SOperatDiaryData(); operatDiaryData.empId = this.empId; operatDiaryData.functionId = ""; operatDiaryData.recordId = model.id.ToString(); operatDiaryData.operateContent = "UStockCheckDetail_Joey修改一条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 = "UStockCheckDetail_Joey修改记录“" + model.id.ToString() + "”时报错:" + ex.Message; this.errorDiaryBB.AddRecord(errorDiaryData); throw ex; } finally { } return ret; }
/// <summary> /// 增加一条"UStockCheckDetail_Joey"信息 /// </summary> /// <param name="model">model</param> public int AddRecord(UStockCheckDetail_JoeyData model) { int id = 0; SqlTransaction trans = null; try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TransAdd"); this.stockCheckDetail_JoeyBB.Transaction = trans; this.errorDiaryBB.Transaction = trans; this.operatDiaryBB.Transaction = trans; } id = this.stockCheckDetail_JoeyBB.AddRecord(model); SOperatDiaryData operatDiaryData = new SOperatDiaryData(); operatDiaryData.empId = this.empId; operatDiaryData.functionId = ""; operatDiaryData.recordId = id.ToString(); operatDiaryData.operateContent = "UStockCheckDetail_Joey增加一条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 = "UStockCheckDetail_Joey增加记录时报错:" + ex.Message; this.errorDiaryBB.AddRecord(errorDiaryData); throw ex; } finally { } return id; }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(UStockCheckDetail_JoeyData model) { return this.stockCheckDetail_JoeyDB.ModifyRecord(model); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model</param> public int AddRecord(UStockCheckDetail_JoeyData model) { return this.stockCheckDetail_JoeyDB.AddRecord(model); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(UStockCheckDetail_JoeyData model) { bool ret = false; StringBuilder strSql = new StringBuilder(); strSql.Append("update UStockCheckDetail_Joey set "); strSql.Append("StockCheckBillNo=@StockCheckBillNo,"); strSql.Append("WareNo=@WareNo,"); strSql.Append("WareLocatorNo=@WareLocatorNo,"); strSql.Append("PalletNo=@PalletNo,"); strSql.Append("BoxNo=@BoxNo,"); strSql.Append("MaterialNo=@MaterialNo,"); strSql.Append("UnityNo=@UnityNo,"); strSql.Append("FactPackNo=@FactPackNo,"); strSql.Append("WmsNo=@WmsNo,"); strSql.Append("Num=@Num,"); strSql.Append("CheckResult=@CheckResult,"); strSql.Append("CheckPersonId=@CheckPersonId,"); strSql.Append("CheckDate=@CheckDate"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@StockCheckBillNo", SqlDbType.NVarChar,50), new SqlParameter("@WareNo", SqlDbType.NVarChar,50), new SqlParameter("@WareLocatorNo", SqlDbType.NVarChar,50), new SqlParameter("@PalletNo", SqlDbType.NVarChar,50), new SqlParameter("@BoxNo", SqlDbType.NVarChar,50), new SqlParameter("@MaterialNo", SqlDbType.NVarChar,50), new SqlParameter("@UnityNo", SqlDbType.Int), new SqlParameter("@FactPackNo", SqlDbType.Int), new SqlParameter("@WmsNo", SqlDbType.Int), new SqlParameter("@Num", SqlDbType.Int), new SqlParameter("@CheckResult", SqlDbType.NVarChar,50), new SqlParameter("@CheckPersonId", SqlDbType.Int), new SqlParameter("@CheckDate", SqlDbType.DateTime) }; parameters[0].Value = model.id; parameters[1].Value = model.StockCheckBillNo; parameters[2].Value = model.WareNo; parameters[3].Value = model.WareLocatorNo; parameters[4].Value = model.PalletNo; parameters[5].Value = model.BoxNo; parameters[6].Value = model.MaterialNo; parameters[7].Value = model.UnityNo; parameters[8].Value = model.FactPackNo; parameters[9].Value = model.WmsNo; parameters[10].Value = model.Num; parameters[11].Value = model.CheckResult; parameters[12].Value = model.CheckPersonId; parameters[13].Value = model.CheckDate == string.Empty ? null : model.CheckDate; 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 UStockCheckDetail_JoeyData GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select id,StockCheckBillNo,WareNo,WareLocatorNo,PalletNo,BoxNo,MaterialNo,UnityNo,FactPackNo,WmsNo,Num, CheckResult,CheckPersonId,CheckDate from UStockCheckDetail_Joey"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; UStockCheckDetail_JoeyData model = new UStockCheckDetail_JoeyData(); 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["StockCheckBillNo"] != DBNull.Value) { model.StockCheckBillNo = Convert.ToString(row["StockCheckBillNo"]); } if (row["WareNo"] != DBNull.Value) { model.WareNo = Convert.ToString(row["WareNo"]); } if (row["WareLocatorNo"] != DBNull.Value) { model.WareLocatorNo = Convert.ToString(row["WareLocatorNo"]); } if (row["PalletNo"] != DBNull.Value) { model.PalletNo = Convert.ToString(row["PalletNo"]); } if (row["BoxNo"] != DBNull.Value) { model.BoxNo = Convert.ToString(row["BoxNo"]); } if (row["MaterialNo"] != DBNull.Value) { model.MaterialNo = Convert.ToString(row["MaterialNo"]); } if (row["UnityNo"] != DBNull.Value) { model.UnityNo = Convert.ToInt32(row["UnityNo"]); } if (row["FactPackNo"] != DBNull.Value) { model.FactPackNo = Convert.ToInt32(row["FactPackNo"]); } if (row["WmsNo"] != DBNull.Value) { model.WmsNo = Convert.ToInt32(row["WmsNo"]); } if (row["Num"] != DBNull.Value) { model.Num = Convert.ToInt32(row["Num"]); } if (row["CheckResult"] != DBNull.Value) { model.CheckResult = Convert.ToString(row["CheckResult"]); } if (row["CheckPersonId"] != DBNull.Value) { model.CheckPersonId = Convert.ToInt32(row["CheckPersonId"]); } if (row["CheckDate"] != DBNull.Value) { model.CheckDate = Convert.ToString(row["CheckDate"]); } return model; } else { return null; } }