/// <summary> /// 展示数据 /// </summary> /// <param name="id">记录Id</param> private void ShowInfo(int id) { BTallyBillBB tallyBillBB = new BTallyBillBB(); vBTallyBillData model = new vBTallyBillData(); BTallyBillDetailBB detailBB=new BTallyBillDetailBB(); try { //获取理货单实例 model = tallyBillBB.GetVModel(id); this.palletNo.Text = model.palletNo; this.wareLocatorNm.Text = model.wareLocatorNm; this.wareNm.Text = model.wareNm; this.isInStock.Text = model.isInStock ? "已入库" : "未入库"; this.instantState.Text = model.instantState == "01" ? "理货中" : model.instantState == "02" ? "理货已完成" : "已入库"; DataSet ds = detailBB.GetVList(" mainid=" + id); this.grid.DataSource = ds; this.grid.DataBind(); } finally { tallyBillBB.Dispose(); } }
/// <summary> /// 得到一个视图model /// </summary> /// <param name="id">主键值</param> /// <returns>model</returns> public vBTallyBillData GetVModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select id,palletNo,wareNo,wareLocatorNo,isInStock,isrtEmpId,isrtDt,updtEmpId,updtDt,instantState,wareNm, wareLocatorNm,isrtEmpNm from vBTallyBill"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; vBTallyBillData model = new vBTallyBillData(); 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["palletNo"] != DBNull.Value) { model.palletNo = Convert.ToString(row["palletNo"]); } if (row["wareNo"] != DBNull.Value) { model.wareNo = Convert.ToString(row["wareNo"]); } if (row["wareLocatorNo"] != DBNull.Value) { model.wareLocatorNo = Convert.ToString(row["wareLocatorNo"]); } if (row["isInStock"] != DBNull.Value) { model.isInStock = Convert.ToBoolean(row["isInStock"]); } 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["instantState"] != DBNull.Value) { model.instantState = Convert.ToString(row["instantState"]); } if (row["wareNm"] != DBNull.Value) { model.wareNm = Convert.ToString(row["wareNm"]); } if (row["wareLocatorNm"] != DBNull.Value) { model.wareLocatorNm = Convert.ToString(row["wareLocatorNm"]); } if (row["isrtEmpNm"] != DBNull.Value) { model.isrtEmpNm = Convert.ToString(row["isrtEmpNm"]); } return model; } else { return null; } }
/// <summary> /// 展示数据 /// </summary> /// <param name="id">记录Id</param> private void ShowInfo(int id) { BTallyBillBB tallyBillBB = new BTallyBillBB(); vBTallyBillData model = new vBTallyBillData(); try { model = tallyBillBB.GetVModel(id); this.id.Text = model.id.ToString(); this.palletNo.Text = model.palletNo; this.wareLocatorNo.Text = model.wareLocatorNo; this.isInStock.Checked = model.isInStock; this.instantState.Text = model.instantState; } finally { tallyBillBB.Dispose(); } }