/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">model</param>
public int AddRecord(BArrangeBillBoxResultChangeData model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("set nocount on; ");
strSql.Append("insert into BArrangeBillBoxResultChange(");
strSql.Append(@"boxNo,checkResult,checkResultDt,checkResultEmpId,preCheckResult,preCheckResultDt,preCheckResultEmpId,mark)");
strSql.Append(" values (");
strSql.Append(@"@boxNo,@checkResult,@checkResultDt,@checkResultEmpId,@preCheckResult,@preCheckResultDt,@preCheckResultEmpId,@mark)");
strSql.Append("; select @@identity; set nocount off; ");
SqlParameter[] parameters = {
new SqlParameter("@boxNo", SqlDbType.VarChar,20),
new SqlParameter("@checkResult", SqlDbType.Bit),
new SqlParameter("@checkResultDt", SqlDbType.DateTime),
new SqlParameter("@checkResultEmpId", SqlDbType.Int),
new SqlParameter("@preCheckResult", SqlDbType.Bit),
new SqlParameter("@preCheckResultDt", SqlDbType.DateTime),
new SqlParameter("@preCheckResultEmpId", SqlDbType.Int),
new SqlParameter("@mark", SqlDbType.NVarChar,500)
};
parameters[0].Value = model.boxNo;
parameters[1].Value = model.checkResult;
parameters[2].Value = model.checkResultDt == string.Empty ? null : model.checkResultDt;
parameters[3].Value = model.checkResultEmpId;
parameters[4].Value = model.preCheckResult;
parameters[5].Value = model.preCheckResultDt == string.Empty ? null : model.preCheckResultDt;
parameters[6].Value = model.preCheckResultEmpId;
parameters[7].Value = model.mark;
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(BArrangeBillBoxResultChangeData model)
{
bool ret = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update BArrangeBillBoxResultChange set ");
strSql.Append("boxNo=@boxNo,");
strSql.Append("checkResult=@checkResult,");
strSql.Append("checkResultDt=@checkResultDt,");
strSql.Append("checkResultEmpId=@checkResultEmpId,");
strSql.Append("preCheckResult=@preCheckResult,");
strSql.Append("preCheckResultDt=@preCheckResultDt,");
strSql.Append("preCheckResultEmpId=@preCheckResultEmpId,");
strSql.Append("mark=@mark");
strSql.Append(" where id = @id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@boxNo", SqlDbType.VarChar,20),
new SqlParameter("@checkResult", SqlDbType.Bit),
new SqlParameter("@checkResultDt", SqlDbType.DateTime),
new SqlParameter("@checkResultEmpId", SqlDbType.Int),
new SqlParameter("@preCheckResult", SqlDbType.Bit),
new SqlParameter("@preCheckResultDt", SqlDbType.DateTime),
new SqlParameter("@preCheckResultEmpId", SqlDbType.Int),
new SqlParameter("@mark", SqlDbType.NVarChar,500)
};
parameters[0].Value = model.id;
parameters[1].Value = model.boxNo;
parameters[2].Value = model.checkResult;
parameters[3].Value = model.checkResultDt == string.Empty ? null : model.checkResultDt;
parameters[4].Value = model.checkResultEmpId;
parameters[5].Value = model.preCheckResult;
parameters[6].Value = model.preCheckResultDt == string.Empty ? null : model.preCheckResultDt;
parameters[7].Value = model.preCheckResultEmpId;
parameters[8].Value = model.mark;
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 BArrangeBillBoxResultChangeData GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select id,boxNo,checkResult,checkResultDt,checkResultEmpId,preCheckResult,preCheckResultDt,preCheckResultEmpId,mark from BArrangeBillBoxResultChange");
strSql.Append(" where id = @id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int)
};
parameters[0].Value = id;
BArrangeBillBoxResultChangeData model = new BArrangeBillBoxResultChangeData();
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["boxNo"] != DBNull.Value)
{
model.boxNo = Convert.ToString(row["boxNo"]);
}
if (row["checkResult"] != DBNull.Value)
{
model.checkResult = Convert.ToBoolean(row["checkResult"]);
}
if (row["checkResultDt"] != DBNull.Value)
{
model.checkResultDt = Convert.ToString(row["checkResultDt"]);
}
if (row["checkResultEmpId"] != DBNull.Value)
{
model.checkResultEmpId = Convert.ToInt32(row["checkResultEmpId"]);
}
if (row["preCheckResult"] != DBNull.Value)
{
model.preCheckResult = Convert.ToBoolean(row["preCheckResult"]);
}
if (row["preCheckResultDt"] != DBNull.Value)
{
model.preCheckResultDt = Convert.ToString(row["preCheckResultDt"]);
}
if (row["preCheckResultEmpId"] != DBNull.Value)
{
model.preCheckResultEmpId = Convert.ToInt32(row["preCheckResultEmpId"]);
}
if (row["mark"] != DBNull.Value)
{
model.mark = Convert.ToString(row["mark"]);
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">model</param>
public bool ModifyRecord(BArrangeBillBoxResultChangeData model)
{
return this.arrangeBillBoxResultChangeDB.ModifyRecord(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">model</param>
public int AddRecord(BArrangeBillBoxResultChangeData model)
{
return this.arrangeBillBoxResultChangeDB.AddRecord(model);
}
//*****************************************************************************
//do it later do it later do it later
//*****************************************************************************
/// <summary>
/// 物料箱检测结果转换
/// </summary>
/// <param name="dtBox"></param>
/// <param name="isRegular"></param>
/// <param name="strMark"></param>
/// <returns></returns>
public bool ConvertBox(DataTable dtBox, bool isRegular, string strMark)
{
bool ret = false;
BArrangeBillBoxResultChangeBB arrangeBillBoxResultChangeBB = new BArrangeBillBoxResultChangeBB(this.connection);
SCommBB commBB = new SCommBB(this.connection);
SqlTransaction trans = null;
try
{
if (this.transaction == null)
{
trans = this.connection.BeginTransaction("TransSave");
this.arrangeBillBoxBB.Transaction = trans;
arrangeBillBoxResultChangeBB.Transaction = trans;
commBB.Transaction = trans;
}
else
{
this.arrangeBillBoxBB.Transaction = this.transaction;
arrangeBillBoxResultChangeBB.Transaction = this.transaction;
commBB.Transaction = this.transaction;
}
BArrangeBillBoxResultChangeData arrangeBillBoxResultChangeModel = new BArrangeBillBoxResultChangeData();
foreach (DataRow dataRow in dtBox.Rows)
{
string strBoxNo = "";
DataTable dtArrangeBox = new DataTable();
strBoxNo = dataRow["boxNo"].ToString();//箱号
dtArrangeBox = this.arrangeBillBoxBB.GetList("boxNo='" + strBoxNo + "'").Tables[0];
//更改原箱的检测结果
commBB.ExecuteSql("update dbo.BArrangeBillBox set checkResult='" + isRegular
+ "',checkResultDt='" + System.DateTime.Now.ToString() + "',checkResultEmpId=" + this.empId + " where boxNo='" + strBoxNo + "'");
//新增箱变更记录
arrangeBillBoxResultChangeModel = new BArrangeBillBoxResultChangeData();
arrangeBillBoxResultChangeModel.boxNo = strBoxNo;//箱号
arrangeBillBoxResultChangeModel.checkResult = isRegular;//是否合格
arrangeBillBoxResultChangeModel.checkResultDt = System.DateTime.Now.ToString();//判定时间
arrangeBillBoxResultChangeModel.checkResultEmpId = this.empId;//判定人员
arrangeBillBoxResultChangeModel.preCheckResult = Convert.ToBoolean(dtArrangeBox.Rows[0]["checkResult"]);//上一次判定结果
arrangeBillBoxResultChangeModel.preCheckResultDt = dtArrangeBox.Rows[0]["checkResultDt"].ToString();//上一次判定时间
arrangeBillBoxResultChangeModel.preCheckResultEmpId = Convert.ToInt32(dtArrangeBox.Rows[0]["checkResultEmpId"]);//上一次判定人员
arrangeBillBoxResultChangeBB.AddRecord(arrangeBillBoxResultChangeModel);
}
if (this.transaction == null) trans.Commit();
ret = true;
}
catch (Exception ex)
{
if (this.transaction == null) trans.Rollback("TransSave");
throw ex;
}
finally
{
arrangeBillBoxResultChangeBB.Dispose();
commBB.Dispose();
}
return ret;
}