private void ShowInfo(int id) { HOrgnizationBB orgnizationBB = new HOrgnizationBB(); vHOrgnizationData model = new vHOrgnizationData(); try { model = orgnizationBB.GetVModel(id); this.departNo.Text = model.departNo; this.departNm.Text = model.departNm; this.uppDepartId.Text = model.uppDepartNm; this.departLeader.Text = model.leaderEmpNm; this.isEffect.Text = model.isEffectDesc; this.mark.Text = model.mark; } finally { orgnizationBB.Dispose(); } }
/// <summary> /// �õ�һ����ͼmodel /// </summary> /// <param name="departId">����ֵ</param> /// <returns>model</returns> public vHOrgnizationData GetVModel(int departId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select departId,departNo,departNm,uppDepartId,departLeader,isEffect,isDel,isrtDt,isrtEmpId,updtDt,updtEmpId,mark,leaderEmpNm,isrtEmpNm,updtEmpNm,isEffectDesc,uppDepartNm from vHOrgnization"); strSql.Append(" where departId = @departId "); SqlParameter[] parameters = { new SqlParameter("@departId", SqlDbType.Int) }; parameters[0].Value = departId; vHOrgnizationData model = new vHOrgnizationData(); 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["departId"] != DBNull.Value) { model.departId = Convert.ToInt32(row["departId"]); } if (row["departNo"] != DBNull.Value) { model.departNo = Convert.ToString(row["departNo"]); } if (row["departNm"] != DBNull.Value) { model.departNm = Convert.ToString(row["departNm"]); } if (row["uppDepartId"] != DBNull.Value) { model.uppDepartId = Convert.ToInt32(row["uppDepartId"]); } if (row["departLeader"] != DBNull.Value) { model.departLeader = Convert.ToInt32(row["departLeader"]); } if (row["isEffect"] != DBNull.Value) { model.isEffect = Convert.ToBoolean(row["isEffect"]); } if (row["isDel"] != DBNull.Value) { model.isDel = Convert.ToBoolean(row["isDel"]); } if (row["isrtDt"] != DBNull.Value) { model.isrtDt = Convert.ToString(row["isrtDt"]); } if (row["isrtEmpId"] != DBNull.Value) { model.isrtEmpId = Convert.ToInt32(row["isrtEmpId"]); } if (row["updtDt"] != DBNull.Value) { model.updtDt = Convert.ToString(row["updtDt"]); } if (row["updtEmpId"] != DBNull.Value) { model.updtEmpId = Convert.ToInt32(row["updtEmpId"]); } if (row["mark"] != DBNull.Value) { model.mark = Convert.ToString(row["mark"]); } if (row["leaderEmpNm"] != DBNull.Value) { model.leaderEmpNm = Convert.ToString(row["leaderEmpNm"]); } if (row["isrtEmpNm"] != DBNull.Value) { model.isrtEmpNm = Convert.ToString(row["isrtEmpNm"]); } if (row["updtEmpNm"] != DBNull.Value) { model.updtEmpNm = Convert.ToString(row["updtEmpNm"]); } if (row["isEffectDesc"] != DBNull.Value) { model.isEffectDesc = Convert.ToString(row["isEffectDesc"]); } if (row["uppDepartNm"] != DBNull.Value) { model.uppDepartNm = Convert.ToString(row["uppDepartNm"]); } return model; } else { return null; } }