62,074
社区成员
发帖
与我相关
我的任务
分享
//DAL层
public EasyFastCMS.Model.UserGroup GetModel(int ID)
{
Model.UserGroup model = new Model.UserGroup();
using (var edm = new EasyFastCMSEntities())
{
var query = edm.EasyFastCMS_UserGroup.Where(ug => ug.ID == ID);
foreach (EasyFastCMS_UserGroup ug in query)
{
model.ID = ug.ID;
model.GroupName = ug.GroupName;
}
}
return model;
}
//BLL层
private readonly SQLServerDAL.UserGroup dal = new SQLServerDAL.UserGroup();
public Model.UserGroup GetModel(int id)
{
return dal.GetModel(id);
}
//Web层
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadInfo();
}
}
private void LoadInfo()
{
BLL.UserGroup bll = new BLL.UserGroup();
Model.UserGroup model = bll.GetModel(Convert.ToInt32(Request.QueryString["id"]));
this.Admin_Users_UserGroup_UserGroupUpDate_ltlID.Text = model.ID.ToString();
this.Admin_Users_UserGroup_UserGroupUpDate_txtGroupName.Text=model.GroupName;
this.Admin_Users_UserGroup_UserGroupUpDate_txtGroupIntro.Text=model.GroupIntro;
this.Admin_Users_UserGroup_UserGroupUpDate_txtOrderID.Text = model.OrderID.ToString();
ViewState["model"] = model;
}
public EasyFastCMS.Model.UserGroup GetModel(int ID)
{
SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) };
parameters[0].Value = ID;
EasyFastCMS.Model.UserGroup model = new EasyFastCMS.Model.UserGroup();
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "EasyFastCMS_UserGroup_GetModel", parameters))
{
while (rdr.Read())
{
model.ID = rdr.GetInt32(0);
model.GroupName = rdr.GetString(1);
model.GroupIntro = rdr.IsDBNull(2) ? "" : rdr.GetString(2);
model.GroupNum = rdr.GetInt32(3);
model.IsSys = rdr.GetBoolean(4);
model.OrderID = rdr.GetInt32(5);
}
}
return model;
}
public EasyFastCMS.Model.UserGroup GetModel(int ID)
{
Model.UserGroup model;
using (var edm = new EasyFastCMSEntities())
{
model = (Model.UserGroup)edm.EasyFastCMS_UserGroup.Where(ug => ug.ID == ID);
}
return model;
}