/// <summary> /// 得到一个视图model /// </summary> /// <param name="id">主键值</param> /// <returns>model</returns> public vLCheckGunData GetVModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select id,checkGunNo,checkGunNm,isDel,isrtEmpId,isrtDt,updtEmpId,updtDt,isrtEmpNm,updtEmpNm from vLCheckGun"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; vLCheckGunData model = new vLCheckGunData(); 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["checkGunNo"] != DBNull.Value) { model.checkGunNo = Convert.ToString(row["checkGunNo"]); } if (row["checkGunNm"] != DBNull.Value) { model.checkGunNm = Convert.ToString(row["checkGunNm"]); } if (row["isDel"] != DBNull.Value) { model.isDel = Convert.ToBoolean(row["isDel"]); } 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["isrtEmpNm"] != DBNull.Value) { model.isrtEmpNm = Convert.ToString(row["isrtEmpNm"]); } if (row["updtEmpNm"] != DBNull.Value) { model.updtEmpNm = Convert.ToString(row["updtEmpNm"]); } return model; } else { return null; } }
/// <summary> /// 展示数据 /// </summary> /// <param name="id">记录Id</param> private void ShowInfo(int id) { LCheckGunBB checkGunBB = new LCheckGunBB(); vLCheckGunData model = new vLCheckGunData(); try { model = checkGunBB.GetVModel(id); this.tbCheckGunNo.Text = model.checkGunNo; this.tbCheckGunNm.Text = model.checkGunNm; } finally { checkGunBB.Dispose(); } }