private void ShowInfo(int id) { PManageDepartBB manageDepartBB = new PManageDepartBB(); vPManageDepartData model = new vPManageDepartData(); try { model = manageDepartBB.GetVModel(id); this.empNm.Text = model.empNm.ToString(); this.roleName.Text = model.roleName; this.departNm.Text = model.departNm.ToString(); } finally { manageDepartBB.Dispose(); } }
/// <summary> /// �õ�һ����ͼmodel /// </summary> /// <param name="id">����ֵ</param> /// <returns>model</returns> public vPManageDepartData GetVModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from vPManageDepart"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; vPManageDepartData model = new vPManageDepartData(); 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["empId"] != DBNull.Value) { model.empId = Convert.ToInt32(row["empId"]); } if (row["roleId"] != DBNull.Value) { model.roleId = Convert.ToInt32(row["roleId"]); } if (row["departId"] != DBNull.Value) { model.departId = Convert.ToInt32(row["departId"]); } if (row["empNo"] != DBNull.Value) { model.empNo = Convert.ToString(row["empNo"]); } if (row["empNm"] != DBNull.Value) { model.empNm = Convert.ToString(row["empNm"]); } if (row["roleName"] != DBNull.Value) { model.roleName = Convert.ToString(row["roleName"]); } if (row["departNo"] != DBNull.Value) { model.departNo = Convert.ToString(row["departNo"]); } if (row["departNm"] != DBNull.Value) { model.departNm = Convert.ToString(row["departNm"]); } return model; } else { return null; } }
private void ShowInfo(int id) { PManageDepartBB manageDepartBB = new PManageDepartBB(); vPManageDepartData model = new vPManageDepartData(); try { model = manageDepartBB.GetVModel(id); this.empId.Value = model.empId.ToString(); this.empNm.Value = model.empNm; if (this.roleId.Items.FindByValue(model.roleId.ToString()) != null) { this.roleId.SelectedValue = model.roleId.ToString(); } this.departId.Value = model.departId.ToString(); this.departNm.Value = model.departNm; } finally { manageDepartBB.Dispose(); } }