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