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;
}
}
