/// <summary> /// 得到一个视图model /// </summary> /// <param name="id">主键值</param> /// <returns>model</returns> public vBCheckBillData GetVModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select id,checkBillNo,arriveBillNo,financeBillNo,materialNo,checkResult,checkMark,checkEmpId,checkDt,isrtEmpId,isrtDt, updtEmpId,updtDt,commitEmpId,commitDt,instantState,materialDesc,instantStateNm from vBCheckBill"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; vBCheckBillData model = new vBCheckBillData(); 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["checkBillNo"] != DBNull.Value) { model.checkBillNo = Convert.ToString(row["checkBillNo"]); } if (row["arriveBillNo"] != DBNull.Value) { model.arriveBillNo = Convert.ToString(row["arriveBillNo"]); } if (row["financeBillNo"] != DBNull.Value) { model.financeBillNo = Convert.ToString(row["financeBillNo"]); } if (row["materialNo"] != DBNull.Value) { model.materialNo = Convert.ToString(row["materialNo"]); } if (row["checkResult"] != DBNull.Value) { model.checkResult = Convert.ToString(row["checkResult"]); } if (row["checkMark"] != DBNull.Value) { model.checkMark = Convert.ToString(row["checkMark"]); } if (row["checkEmpId"] != DBNull.Value) { model.checkEmpId = Convert.ToInt32(row["checkEmpId"]); } if (row["checkDt"] != DBNull.Value) { model.checkDt = Convert.ToString(row["checkDt"]); } 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["commitEmpId"] != DBNull.Value) { model.commitEmpId = Convert.ToInt32(row["commitEmpId"]); } if (row["commitDt"] != DBNull.Value) { model.commitDt = Convert.ToString(row["commitDt"]); } if (row["instantState"] != DBNull.Value) { model.instantState = Convert.ToString(row["instantState"]); } if (row["materialDesc"] != DBNull.Value) { model.materialDesc = Convert.ToString(row["materialDesc"]); } if (row["instantStateNm"] != DBNull.Value) { model.instantStateNm = Convert.ToString(row["instantStateNm"]); } return model; } else { return null; } }
/// <summary> /// 展示数据 /// </summary> /// <param name="id">记录Id</param> private void ShowInfo(int id) { BCheckBillBB checkBillBB = new BCheckBillBB(); SCommBB commBB = new SCommBB(); try { vBCheckBillData model = new vBCheckBillData(); DataSet ds = new DataSet(); string strSQL = ""; model = checkBillBB.GetVModel(id); this.lbCheckBillNo.Text = model.checkBillNo; this.tbArriveBillNo.Text = model.arriveBillNo; this.tbFinanceBillNo.Text = model.financeBillNo; this.hidMaterialNo.Value = model.materialNo; this.tbMaterialDesc.Text = model.materialDesc; this.tbCheckMark.Text = model.checkMark; //查找到货单明细ID strSQL = "select id,num from BArriveDetail where arriveBillNo='" + model.arriveBillNo + "' and financeBillNo='" + model.financeBillNo + "' and materialNo='" + model.materialNo + "'"; ds = commBB.Query(strSQL); if (ds != null && ds.Tables[0].Rows.Count > 0) { this.hidArriveDetailID.Value = ds.Tables[0].Rows[0]["id"].ToString(); this.tbNum.Text = ds.Tables[0].Rows[0]["num"].ToString(); } this.BindMateriel2();//绑定物料对应检测标准明细表 } finally { checkBillBB.Dispose(); } }