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