public ActionResult Edit(FormCollection frm, int?id)
{
Sys_UserType updateUT = new Sys_UserType();
updateUT.UserTypeName = frm["UserTypeName"];
updateUT.LastUpdatedDate = DateTime.Now;
updateUT.LastUpdatedBy = Convert.ToInt32(Session["UserId"]);
db.UpdateUT(updateUT, (int)id);
return(RedirectToAction("Index"));
}
public ActionResult Create(FormCollection frm)
{
Sys_UserType saveUT = new Sys_UserType();
saveUT.UserTypeName = frm["UserTypeName"];
saveUT.EnteredDate = DateTime.Now;
saveUT.EnteredBy = Convert.ToInt32(Session["UserId"]);
saveUT.DepartmentId = Convert.ToInt32(Session["DepartmentId"]);
db.AddUT(saveUT);
return(RedirectToAction("Index"));
}
/// <summary>
/// 页面加载
/// </summary>
public override void RenderPage()
{
if (UserTypeID.IsNoNull())
{
objSys_UserType = objUserRule.Sys_UserType.First(s => s.UserTypeID == UserTypeID);
txtUserTypeID.Enabled = false;
Page.DataBind();
}
else
{
txtUserTypeID.Enabled = true;
}
}
public int AddUT(Sys_UserType saveUT)
{
string sql = "insert into Sys_UserType(UserTypeName,EnteredBy,EnteredDate,LastUpdatedBy,LastUpdatedDate,DepartmentId," +
"IsDeleted,DeletedBy,DeletedDate)" +
" values(@UserTypeName,@EnteredBy,@EnteredDate,0,null,@DepartmentId," +
"0,0,null)";
using (var db = DbHelper.GetDBConnection())
{
int id = db.Query <int>(sql, saveUT).SingleOrDefault();
db.Close();
return(id);
}
}
public bool UpdateUT(Sys_UserType updateUT, int Id)
{
string sql = " Update Sys_UserType set UserTypeName=@UserTypeName," +
"LastUpdatedDate=@LastUpdatedDate, LastUpdatedBy=@LastUpdatedBy where IsDeleted=0 and UserTypeId= " + Id;
using (var db = DbHelper.GetDBConnection())
{
var lst = db.Execute(sql, updateUT);
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 保存信息
/// </summary>
public void SaveInfo()
{
if (UserTypeID.IsNull())
{
objSys_UserType.UserTypeID = txtUserTypeID.TextInt;
///用户类型名称
objSys_UserType.UserTypeName = txtUserTypeName.TextCutWord(50);
///备注
objSys_UserType.Remark = txtRemark.TextCutWord(100);
objUserRule.InsertUserType(objSys_UserType);
MessageDialog("新增成功", "UserTypeList.aspx");
}
else
{
objSys_UserType = objUserRule.Sys_UserType.First(p => p.UserTypeID == UserTypeID);
///用户类型名称
objSys_UserType.UserTypeName = txtUserTypeName.TextCutWord(50);
///备注
objSys_UserType.Remark = txtRemark.TextCutWord(100);
objUserRule.UpdateUserType(objSys_UserType);
MessageDialog("修改成功", "UserTypeList.aspx");
}
}
