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