/// <summary>
/// 展示数据
/// </summary>
/// <param name="id">记录Id</param>
private void ShowInfo(int id)
{
LCheckDetailBB checkDetailBB = new LCheckDetailBB();
vLCheckDetailData model = new vLCheckDetailData();
try
{
model = checkDetailBB.GetVModel(id);
this.id.Text = model.id.ToString();
this.checkDetailDesc.Text = model.checkDetailDesc;
this.materialNo.Text = model.materialNo;
this.checkFileId.Text = model.checkFileId.ToString();
this.checkItemId.Text = model.checkItemId.ToString();
this.dateType.Text = model.dateType;
this.unit.Text = model.unit;
this.uplimit.Text = model.uplimit;
this.downlimit.Text = model.downlimit;
this.standDesc.Text = model.standDesc;
this.isMustCheck.Text = model.isMustCheck.ToString();
this.isAddupCheck.Text = model.isAddupCheck.ToString();
this.checkAmount.Text = model.checkAmount.ToString();
this.arrivedAmount.Text = model.arrivedAmount.ToString();
this.openBoxScale.Text = model.openBoxScale.ToString();
this.checkOutScale.Text = model.checkOutScale.ToString();
this.mark.Text = model.mark;
}
finally
{
checkDetailBB.Dispose();
}
}
/// <summary>
/// 得到一个视图model
/// </summary>
/// <param name="id">主键值</param>
/// <returns>model</returns>
public vLCheckDetailData GetVModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select id,checkDetailDesc,materialNo,checkFileId,checkItemId,dateType,unit,uplimit,downlimit,standDesc,isMustCheck,
isAddupCheck,checkAmount,arrivedAmount,openBoxScale,checkOutScale,mark,isrtEmpId,isrtDt,updtEmpId,updtDt,
materialDesc,checkItemNo,checkItemNm,updtEmpNo,updtEmpNm,preFileNm,downFileNm,isMustCheckDesc,isAddupCheckDesc,openBoxScaleDesc,
checkOutScaleDesc,fileUrl from vLCheckDetail");
strSql.Append(" where id = @id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int)
};
parameters[0].Value = id;
vLCheckDetailData model = new vLCheckDetailData();
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["checkDetailDesc"] != DBNull.Value)
{
model.checkDetailDesc = Convert.ToString(row["checkDetailDesc"]);
}
if (row["materialNo"] != DBNull.Value)
{
model.materialNo = Convert.ToString(row["materialNo"]);
}
if (row["checkFileId"] != DBNull.Value)
{
model.checkFileId = Convert.ToInt32(row["checkFileId"]);
}
if (row["checkItemId"] != DBNull.Value)
{
model.checkItemId = Convert.ToInt32(row["checkItemId"]);
}
if (row["dateType"] != DBNull.Value)
{
model.dateType = Convert.ToString(row["dateType"]);
}
if (row["unit"] != DBNull.Value)
{
model.unit = Convert.ToString(row["unit"]);
}
if (row["uplimit"] != DBNull.Value)
{
model.uplimit = Convert.ToString(row["uplimit"]);
}
if (row["downlimit"] != DBNull.Value)
{
model.downlimit = Convert.ToString(row["downlimit"]);
}
if (row["standDesc"] != DBNull.Value)
{
model.standDesc = Convert.ToString(row["standDesc"]);
}
if (row["isMustCheck"] != DBNull.Value)
{
model.isMustCheck = Convert.ToBoolean(row["isMustCheck"]);
}
if (row["isAddupCheck"] != DBNull.Value)
{
model.isAddupCheck = Convert.ToBoolean(row["isAddupCheck"]);
}
if (row["checkAmount"] != DBNull.Value)
{
model.checkAmount = Convert.ToDouble(row["checkAmount"]);
}
if (row["arrivedAmount"] != DBNull.Value)
{
model.arrivedAmount = Convert.ToDouble(row["arrivedAmount"]);
}
if (row["openBoxScale"] != DBNull.Value)
{
model.openBoxScale = Convert.ToDouble(row["openBoxScale"]);
}
if (row["checkOutScale"] != DBNull.Value)
{
model.checkOutScale = Convert.ToDouble(row["checkOutScale"]);
}
if (row["mark"] != DBNull.Value)
{
model.mark = Convert.ToString(row["mark"]);
}
if (row["isrtEmpId"] != DBNull.Value)
{
model.isrtEmpId = Convert.ToInt32(row["isrtEmpId"]);
}
if (row["isrtDt"] != DBNull.Value)
{
model.isrtDt = Convert.ToString(row["isrtDt"]);
}
if (row["updtEmpId"] != DBNull.Value)
{
model.updtEmpId = Convert.ToInt32(row["updtEmpId"]);
}
if (row["updtDt"] != DBNull.Value)
{
model.updtDt = Convert.ToString(row["updtDt"]);
}
if (row["materialDesc"] != DBNull.Value)
{
model.materialDesc = Convert.ToString(row["materialDesc"]);
}
if (row["checkItemNo"] != DBNull.Value)
{
model.checkItemNo = Convert.ToString(row["checkItemNo"]);
}
if (row["checkItemNm"] != DBNull.Value)
{
model.checkItemNm = Convert.ToString(row["checkItemNm"]);
}
if (row["updtEmpNo"] != DBNull.Value)
{
model.updtEmpNo = Convert.ToString(row["updtEmpNo"]);
}
if (row["updtEmpNm"] != DBNull.Value)
{
model.updtEmpNm = Convert.ToString(row["updtEmpNm"]);
}
if (row["preFileNm"] != DBNull.Value)
{
model.preFileNm = Convert.ToString(row["preFileNm"]);
}
if (row["downFileNm"] != DBNull.Value)
{
model.downFileNm = Convert.ToString(row["downFileNm"]);
}
if (row["isMustCheckDesc"] != DBNull.Value)
{
model.isMustCheckDesc = Convert.ToString(row["isMustCheckDesc"]);
}
if (row["isAddupCheckDesc"] != DBNull.Value)
{
model.isAddupCheckDesc = Convert.ToString(row["isAddupCheckDesc"]);
}
if (row["openBoxScaleDesc"] != DBNull.Value)
{
model.openBoxScaleDesc = Convert.ToDouble(row["openBoxScaleDesc"]);
}
if (row["checkOutScaleDesc"] != DBNull.Value)
{
model.checkOutScaleDesc = Convert.ToDouble(row["checkOutScaleDesc"]);
}
if (row["fileUrl"] != DBNull.Value)
{
model.fileUrl = Convert.ToString(row["fileUrl"]);
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 展示数据
/// </summary>
/// <param name="id">记录Id</param>
private void ShowInfo(int id)
{
LCheckDetailBB checkDetailBB = new LCheckDetailBB();
vLCheckDetailData model = new vLCheckDetailData();
SFileBB fileBB = new SFileBB();
try
{
model = checkDetailBB.GetVModel(id);
this.materialNo.Text = model.materialNo;
this.materialDesc.Text = model.materialDesc;
this.checkDetailDesc.Text = model.checkDetailDesc;
this.checkItemId.SelectedValue = model.checkItemId.ToString();
this.dateType.SelectedValue = model.dateType;
this.unit.Text = model.unit;
this.uplimit.Text = model.uplimit;
this.downlimit.Text = model.downlimit;
this.standDesc.Text = model.standDesc;
if (model.isMustCheck != null)
{
this.isMustCheck.Checked = model.isMustCheck;
}
if (model.isAddupCheck != null)
{
this.isAddupCheck.Checked = model.isAddupCheck;
}
this.checkAmount.Text = model.checkAmount.ToString();
this.openBoxScale.Text = Convert.ToString(model.openBoxScale * 100);
this.checkOutScale.Text = Convert.ToString(model.checkOutScale * 100);
this.mark.Text = model.mark;
if (model.checkFileId != 0)
{
this.fileId.Value = Convert.ToString(model.checkFileId);
this.fileNm.Value = fileBB.GetBatchFileNm(Convert.ToString(model.checkFileId));
this.localeImage.ImageUrl = "../../../Common/Image.ashx?ImID=" + Convert.ToString(model.checkFileId);
}
//else
//{
// this.fileId.Value = model.checkFileId.ToString();
// this.fileNm =
//}
}
finally
{
checkDetailBB.Dispose();
fileBB.Dispose();
}
}