/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">model</param>
public int AddRecord(CSaleBill_HangHaoData model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("set nocount on; ");
strSql.Append("insert into CSaleBill_HangHao(");
strSql.Append(@"saleBillNo,saleBillDt,custNo,custNm,saleEmpNo,saleBillType,stockupBillNo,mark,financeBillNo,isStockedByBill,
instantState,AbsEntry,DocEntry)");
strSql.Append(" values (");
strSql.Append(@"@saleBillNo,@saleBillDt,@custNo,@custNm,@saleEmpNo,@saleBillType,@stockupBillNo,@mark,@financeBillNo,@isStockedByBill,
@instantState,@AbsEntry,@DocEntry)");
strSql.Append("; select @@identity; set nocount off; ");
SqlParameter[] parameters = {
new SqlParameter("@saleBillNo", SqlDbType.VarChar,20),
new SqlParameter("@saleBillDt", SqlDbType.DateTime),
new SqlParameter("@custNo", SqlDbType.VarChar,20),
new SqlParameter("@custNm", SqlDbType.NVarChar,50),
new SqlParameter("@saleEmpNo", SqlDbType.VarChar,20),
new SqlParameter("@saleBillType", SqlDbType.NVarChar,20),
new SqlParameter("@stockupBillNo", SqlDbType.VarChar,20),
new SqlParameter("@mark", SqlDbType.NVarChar,500),
new SqlParameter("@financeBillNo", SqlDbType.VarChar,20),
new SqlParameter("@isStockedByBill", SqlDbType.Bit),
new SqlParameter("@instantState", SqlDbType.VarChar,10),
new SqlParameter("@AbsEntry", SqlDbType.Int),
new SqlParameter("@DocEntry", SqlDbType.Int)
};
parameters[0].Value = model.saleBillNo;
parameters[1].Value = model.saleBillDt == string.Empty ? null : model.saleBillDt;
parameters[2].Value = model.custNo;
parameters[3].Value = model.custNm;
parameters[4].Value = model.saleEmpNo;
parameters[5].Value = model.saleBillType;
parameters[6].Value = model.stockupBillNo;
parameters[7].Value = model.mark;
parameters[8].Value = model.financeBillNo;
parameters[9].Value = model.isStockedByBill;
parameters[10].Value = model.instantState;
parameters[11].Value = model.AbsEntry;
parameters[12].Value = model.DocEntry;
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>
/// 更新一条数据
/// </summary>
/// <param name="model">model</param>
public bool ModifyRecord(CSaleBill_HangHaoData model)
{
bool ret = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update CSaleBill_HangHao set ");
strSql.Append("saleBillNo=@saleBillNo,");
strSql.Append("saleBillDt=@saleBillDt,");
strSql.Append("custNo=@custNo,");
strSql.Append("custNm=@custNm,");
strSql.Append("saleEmpNo=@saleEmpNo,");
strSql.Append("saleBillType=@saleBillType,");
strSql.Append("stockupBillNo=@stockupBillNo,");
strSql.Append("mark=@mark,");
strSql.Append("financeBillNo=@financeBillNo,");
strSql.Append("isStockedByBill=@isStockedByBill,");
strSql.Append("instantState=@instantState,");
strSql.Append("AbsEntry=@AbsEntry,");
strSql.Append("DocEntry=@DocEntry");
strSql.Append(" where id = @id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@saleBillNo", SqlDbType.VarChar,20),
new SqlParameter("@saleBillDt", SqlDbType.DateTime),
new SqlParameter("@custNo", SqlDbType.VarChar,20),
new SqlParameter("@custNm", SqlDbType.NVarChar,50),
new SqlParameter("@saleEmpNo", SqlDbType.VarChar,20),
new SqlParameter("@saleBillType", SqlDbType.NVarChar,20),
new SqlParameter("@stockupBillNo", SqlDbType.VarChar,20),
new SqlParameter("@mark", SqlDbType.NVarChar,500),
new SqlParameter("@financeBillNo", SqlDbType.VarChar,20),
new SqlParameter("@isStockedByBill", SqlDbType.Bit),
new SqlParameter("@instantState", SqlDbType.VarChar,10),
new SqlParameter("@AbsEntry", SqlDbType.Int),
new SqlParameter("@DocEntry", SqlDbType.Int)
};
parameters[0].Value = model.id;
parameters[1].Value = model.saleBillNo;
parameters[2].Value = model.saleBillDt == string.Empty ? null : model.saleBillDt;
parameters[3].Value = model.custNo;
parameters[4].Value = model.custNm;
parameters[5].Value = model.saleEmpNo;
parameters[6].Value = model.saleBillType;
parameters[7].Value = model.stockupBillNo;
parameters[8].Value = model.mark;
parameters[9].Value = model.financeBillNo;
parameters[10].Value = model.isStockedByBill;
parameters[11].Value = model.instantState;
parameters[12].Value = model.AbsEntry;
parameters[13].Value = model.DocEntry;
try
{
SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
ret = true;
}
catch (Exception ex)
{
throw ex;
}
return ret;
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">model</param>
public bool ModifyRecord(CSaleBill_HangHaoData model)
{
return this.saleBill_HangHaoDB.ModifyRecord(model);
}
/// <summary>
/// 得到一个model
/// </summary>
/// <param name="id">主键值</param>
/// <returns>model</returns>
public CSaleBill_HangHaoData GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select id,saleBillNo,saleBillDt,custNo,custNm,saleEmpNo,saleBillType,stockupBillNo,mark,financeBillNo,isStockedByBill,
instantState,AbsEntry,DocEntry from CSaleBill_HangHao");
strSql.Append(" where id = @id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int)
};
parameters[0].Value = id;
CSaleBill_HangHaoData model = new CSaleBill_HangHaoData();
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["saleBillNo"] != DBNull.Value)
{
model.saleBillNo = Convert.ToString(row["saleBillNo"]);
}
if (row["saleBillDt"] != DBNull.Value)
{
model.saleBillDt = Convert.ToString(row["saleBillDt"]);
}
if (row["custNo"] != DBNull.Value)
{
model.custNo = Convert.ToString(row["custNo"]);
}
if (row["custNm"] != DBNull.Value)
{
model.custNm = Convert.ToString(row["custNm"]);
}
if (row["saleEmpNo"] != DBNull.Value)
{
model.saleEmpNo = Convert.ToString(row["saleEmpNo"]);
}
if (row["saleBillType"] != DBNull.Value)
{
model.saleBillType = Convert.ToString(row["saleBillType"]);
}
if (row["stockupBillNo"] != DBNull.Value)
{
model.stockupBillNo = Convert.ToString(row["stockupBillNo"]);
}
if (row["mark"] != DBNull.Value)
{
model.mark = Convert.ToString(row["mark"]);
}
if (row["financeBillNo"] != DBNull.Value)
{
model.financeBillNo = Convert.ToString(row["financeBillNo"]);
}
if (row["isStockedByBill"] != DBNull.Value)
{
model.isStockedByBill = Convert.ToBoolean(row["isStockedByBill"]);
}
if (row["instantState"] != DBNull.Value)
{
model.instantState = Convert.ToString(row["instantState"]);
}
if (row["AbsEntry"] != DBNull.Value)
{
model.AbsEntry = Convert.ToInt32(row["AbsEntry"]);
}
if (row["DocEntry"] != DBNull.Value)
{
model.DocEntry = Convert.ToInt32(row["DocEntry"]);
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">model</param>
public int AddRecord(CSaleBill_HangHaoData model)
{
return this.saleBill_HangHaoDB.AddRecord(model);
}