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