/// <summary> /// 添加用户 /// </summary> /// <param name="user">用户信息</param> /// <returns>影响行数</returns> public Result add(sys_user user) { SysUserDAL Sysuser = new SysUserDAL(); Result res = new Result(); try { if (Sysuser.Add(user) == 0) { res.Code = RES.ERROR; res.Message = "添加失败!"; return(res); } else { res.Code = RES.OK; res.Message = "添加成功!"; return(res); } } catch { res.Code = RES.ERROR; res.Message = "添加失败!"; return(res); } }
public async Task <ActionResult> Update([FromBody] SysUserView model) { var resdata = await AutoException.Excute <SysUser>(async (result) => { model.UpdateBy = "admin"; model.UpdateDt = DateTime.Now; var res = await SysUserDAL.UpdateAsync(model); result.Data = model; if (!res) { throw new Exception("数据修改异常,JSON:" + Newtonsoft.Json.JsonConvert.SerializeObject(model)); } else { if (!string.IsNullOrEmpty(model.userrole)) { string[] idstr = model.userrole.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); List <SysUserRole> rolelist = (from p in idstr select new SysUserRole { RoleId = Convert.ToInt32(p), UserId = model.Id, Status = 1, CreateDt = DateTime.Now, CreateBy = model.UpdateBy }).ToList(); await SysUserRoleDAL.BatchInsertAsync(rolelist); } } }, false); return(Json(resdata)); }
public async Task <IActionResult> List(string searchContent, string seniorQueryJson, int page = 1, int limit = 10, string sidx = "CreateDt", string sord = "desc") { try { SysUser query = null; if (!string.IsNullOrEmpty(seniorQueryJson)) { query = Newtonsoft.Json.JsonConvert.DeserializeObject <SysUser>(seniorQueryJson); } System.Linq.Expressions.Expression <Func <SysUser, bool> > predicate = ExpressionBuilder.True <SysUser>(); predicate = predicate.And(b => b.Id > 0); if (searchContent != null) { predicate = predicate.And(b => b.UserName.IndexOf(searchContent) != -1); } PageInfo pageinfo = new PageInfo { }; (List <SysUser> list, long count)datas = await SysUserDAL.QueryAsync(predicate, null, pageinfo); var lists = datas.list; return(lists.GetJson <SysUser>(sidx, sord, page, limit, SysTool.GetPropertyNameArray <SysUser>())); } catch (Exception ex) { throw ex; } }
protected void gvwList_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName) { case "Edit": Response.Redirect("userroledetail.aspx?action=edt&id=" + e.CommandArgument + "&userid=" + txtUSER_ID.Text); break; case "Delete": SysUserDAL _dalsysuser = null; Hashtable _htParameters = null; try { _dalsysuser = new SysUserDAL(); _htParameters = new Hashtable(); _htParameters["p_sys_userid"] = e.CommandArgument.ToString(); _dalsysuser.Delete(_htParameters); this.BindData(); Response.Redirect("userdetail.aspx?action=edt&id=" + Request.Params["id"]); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null); } break; } }
/// <summary> /// 重置用户密码 /// </summary> /// <param name="user">用户信息</param> /// <returns>影响行数</returns> public Result RePassword(List <int> userid) { SysUserDAL Sysuser = new SysUserDAL(); Result res = new Result(); int re = 0; try { foreach (var userId in userid) { re += Sysuser.RePassword(userId); } if (re == 0) { res.Code = RES.ERROR; res.Message = "修改失败!"; return(res); } else { res.Code = RES.OK; res.Message = "修改成功!"; return(res); } } catch { res.Code = RES.ERROR; res.Message = "修改失败!"; return(res); } }
/// <summary> /// 添加用户 /// </summary> /// <param name="user">用户信息</param> /// <returns>影响行数</returns> public Result Update(sys_user user, int userid) { SysUserDAL Sysuser = new SysUserDAL(); Result res = new Result(); try { if (Sysuser.Update(user, userid) == 0) { res.Code = RES.ERROR; res.Message = "添加失败!"; return(res); } else { res.Code = RES.OK; res.Message = "添加成功!"; return(res); } } catch { res.Code = RES.ERROR; res.Message = "添加失败!"; return(res); } }
private void BtnSearchCostApply_Click(object sender, EventArgs e) { Dictionary <string, object> conditions = new Dictionary <string, object>(); conditions.Add("apply_id", UserInfoBLL.UserId); int status = -1; if (CmbApplyStatus.SelectedItem != null) { if (!CmbApplyStatus.SelectedItem.ToString().Trim().Equals(" ")) { switch (CmbApplyStatus.SelectedItem.ToString()) { case "未审核": status = 0; break; case "正在审核": status = 1; break; case "审核通过": status = 2; break; case "审核驳回": status = 3; break; } } } if (status >= 0) { conditions.Add("status", status); } conditions.Add("start_time", TimeApplyStart.Value); conditions.Add("end_time", TimeApplyEnd.Value); List <cost> ListCost = new CostApplyBLL().Query(conditions); List <CostApplyData> DataList = new List <CostApplyData>(); foreach (cost cost in ListCost) { string applicant = new SysUserDAL().SelectById(cost.Main.apply_id)[0].name; string statusStr = null; switch (cost.Main.status) { case 0: statusStr = "未审核"; break; case 1: statusStr = "正在审核"; break; case 2: statusStr = "审核通过"; break; case 3: statusStr = "审核驳回"; break; } DataList.Add(new CostApplyData { Number = 1, cost_id = cost.Main.id, applicant = applicant, apply_money = cost.Main.apply_money, apply_time = cost.Main.apply_time, status = statusStr }); } DgvCostApply.DataSource = DataList; }
public async Task <ActionResult> Delete(string id) { var resdata = await AutoException.Excute <long>(async (result) => { string[] idstr = id.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); foreach (var item in idstr) { var bl = await SysUserDAL.DeleteAsync(Convert.ToInt32(item)); if (!bl) { throw new Exception("数据删除异常,ID:" + item); } } }, true); return(Json(resdata)); }
public async Task <ActionResult> UpdatePwd(string id, string pwd) { var resdata = await AutoException.Excute <long>(async (result) => { string[] idstr = id.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); foreach (var item in idstr) { var model = await SysUserDAL.GetByOneAsync(w => w.Id == Convert.ToInt32(item)); model.Password = pwd; //MD5编码 var bl = await SysUserDAL.UpdateAsync(model); if (!bl) { throw new Exception("密码修改异常,ID:" + item); } } }, false); return(Json(resdata)); }
public async Task <IActionResult> Login([FromBody] LoginModel model) { var user = await SysUserDAL.GetByOneAsync(q => q.UserName == model.userName && q.Password == model.password); if (user != null) { var isSuperUser = user.UserType == UserType.SuperUser; //获取用户的权限列表 var userRoles = await SysUserRoleDAL.QueryAsync(r => r.UserId == user.Id); if (userRoles.list != null && userRoles.list.Count() > 0 || isSuperUser) { var roleCodes = "Admin";// var roleids = isSuperUser ? "0" : string.Join(",", userRoles.list.Select(s => s.RoleId).ToArray()); //用户标识 var identity = new ClaimsIdentity(CookieAuthenticationDefaults.AuthenticationScheme); identity.AddClaim(new Claim(ClaimTypes.Sid, user.Id.ToString())); identity.AddClaim(new Claim(ClaimTypes.Name, user.UserName)); identity.AddClaim(new Claim(ClaimTypes.UserData, Newtonsoft.Json.JsonConvert.SerializeObject(new SysUserView { Id = user.Id, UserName = user.UserName, RealName = user.RealName, UserType = user.UserType, userrole = roleids, }))); identity.AddClaim(new Claim(ClaimTypes.Role, roleCodes)); await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(identity)); return(Json(new { status = 1 })); } else { return(Json(new { status = 2, errorMessage = "账号未设置角色" })); } } else { return(Json(new { status = 2, errorMessage = "用户不存在或密码错误" })); } }
public async Task <ActionResult> UpdateModule(string id) { var userroles = await SysUserRoleDAL.QueryUserRole(u => u.UserId == Convert.ToInt32(id), null, null); (List <SysRole> list, long count)role = await SysRoleDAL.QueryAsync(w => w.Status == 1); ViewBag.RoleList = role.list.Select(s => new SelectListItem { Selected = userroles.list.Exists(ss => ss.RoleId == s.Id), Text = s.RoleName, Value = s.Id.ToString() }).ToList(); SysUser model = new SysUser() { }; if (!string.IsNullOrEmpty(id) && id != "0") { int _id = Convert.ToInt32(id); model = await SysUserDAL.GetByOneAsync(w => w.Id == _id); } return(View(model)); }
private void CostApprovalForm_Load(object sender, EventArgs e) { cost cost = new CostApplyBLL().Query(new Dictionary <string, object> { { "id", costId } }).First(); cost_main main = cost.Main; view_sys_u2g applicant = new SysUserDAL().SelectById(main.apply_id).First(); TexApplicant.Text = applicant.name; foreach (cost_detail detail in cost.DetailList) { int index = this.DgvCostDetail.Rows.Add(); this.DgvCostDetail.Rows[index].SetValues(new CostApplyDAL().GetCostTypeById(detail.cost_type_id), detail.money); } foreach (cost_approval approval in cost.ApprovalList) { int index = this.DgvApproval.Rows.Add(); string approver = approval.approval_id + "." + new SysUserDAL().SelectById(approval.approval_id).First().name; this.DgvApproval.Rows[index].SetValues(approver, approval.result, approval.time, approval.opinion); } int userId = UserInfoBLL.UserId; List <string> approverList = new CostApplyDAL().GetApprovalInfo(userId); if (approverList.Count == 0) { LblNextApprover.Visible = false; CmbNextApprover.Visible = false; return; } else { LblNextApprover.Visible = true; CmbNextApprover.Visible = true; } CmbNextApprover.Items.Clear(); CmbNextApprover.Items.AddRange(approverList.ToArray()); }
private void CostApplyDetailForm_Load(object sender, EventArgs e) { cost cost = new CostApplyBLL().Query(new Dictionary <string, object> { { "id", costId } }).First(); cost_main main = cost.Main; LblCostId.Text = main.id.ToString(); view_sys_u2g applicant = new SysUserDAL().SelectById(main.apply_id).First(); LblApplicant.Text = applicant.name; LblApplicantOrg.Text = applicant.org_name; LblApplyTime.Text = main.apply_time.ToString("yyyy-MM-dd HH:mm:ss"); LblApplyMoney.Text = main.apply_money.ToString(); foreach (cost_detail detail in cost.DetailList) { int index = this.DgvCostDetail.Rows.Add(); this.DgvCostDetail.Rows[index].SetValues(new CostApplyDAL().GetCostTypeById(detail.cost_type_id), detail.money); } switch (main.status) { case 0: LblStatus.Text = "未审核"; break; case 1: LblStatus.Text = "正在审核"; break; case 2: LblStatus.Text = "审核通过"; break; case 3: LblStatus.Text = "审核驳回"; break; } foreach (cost_approval approval in cost.ApprovalList) { int index = this.DgvApproval.Rows.Add(); string approver = approval.approval_id + "." + new SysUserDAL().SelectById(approval.approval_id).First().name; this.DgvApproval.Rows[index].SetValues(approver, approval.result, approval.time, approval.opinion); } }
public SysUserBLL() { handle = new SysUserDAL(); }
public AuthController(SysUserDAL sysUserDAL) { this.SysUserDAL = sysUserDAL; }
/// <summary> /// 查询所有用户 /// </summary> /// <returns>用户信息</returns> public List <view_sys_u2g> SelectAll() { SysUserDAL Sysuser = new SysUserDAL(); return(Sysuser.SelectAll()); }
/// <summary> /// 条件查询用户 /// </summary> /// <param name="UserInfo">查询条件</param> /// <returns>用户信息</returns> public List <view_sys_u2g> Select(sys_user UserInfo) { SysUserDAL Sysuser = new SysUserDAL(); return(Sysuser.Select(UserInfo)); }
/// <summary> /// 通过用户id查询用户 /// </summary> /// <param name="UserId">用户id</param> /// <returns>用户信息</returns> public List <view_sys_u2g> SelectById(int UserId) { SysUserDAL Sysuser = new SysUserDAL(); return(Sysuser.SelectById(UserId)); }
/// <summary> /// 获得所有结算单 /// </summary> /// <param name="PKID">车场编号</param> /// <param name="SettleStatus">结算单状态</param> /// <param name="Priod">帐期</param> /// <returns></returns> public List <ParkSettlementModel> GetSettlements(string PKID, int SettleStatus, string Priod, string UserID) { List <ParkSettlementModel> settlements = new List <ParkSettlementModel>(); StringBuilder strSql = new StringBuilder(); // strSql.Append(@"select s.ID,s.RecordID,s.PKID,s.Priod,s.SettleStatus,s.TotalAmount,s.HandlingFeeAmount,s.ReceivableAmount,s.StartTime,s.EndTime,s.PayTime,s.CreateTime,s.Receipt,s.CreateUser,p.pkname ParkName,u.UserName,s.Remark from parksettlement s left join baseparkinfo p on s.pkid=p.pkid left join sysuser u on u.RecordID=s.CreateUser where s.pkid=@PKID and settlestatus in ( //select flowid from ParkSettlementApprovalFlow where flowuser=@userid // and pkid=@PKID)"); // if (SettleStatus != -1) // { // strSql.Append(" and settlestatus=@settlestatus"); // } // if (Priod != "-1") // { // strSql.Append(" and Priod=@Priod"); // } // StringBuilder strSql1 = new StringBuilder(); // strSql1.Append(@"select s.ID,s.RecordID,s.PKID,s.Priod,s.SettleStatus,s.TotalAmount,s.HandlingFeeAmount,s.ReceivableAmount,s.StartTime,s.EndTime,s.PayTime,s.CreateTime,s.Receipt,s.CreateUser,p.pkname ParkName,u.UserName,s.Remark from parksettlement s left join baseparkinfo p on s.pkid=p.pkid left join sysuser u on u.RecordID=s.CreateUser where s.pkid=@PKID and createuser=@UserID"); // if (SettleStatus != -1) // { // strSql1.Append(" and settlestatus=@settlestatus"); // } // if (Priod != "-1") // { // strSql1.Append(" and Priod=@Priod"); // } // string s = strSql.ToString() + " union " + strSql1.ToString(); strSql.Append(@"select s.ID,s.RecordID,s.PKID,s.Priod,s.SettleStatus,s.TotalAmount,s.HandlingFeeAmount,s.ReceivableAmount,s.StartTime,s.EndTime,s.PayTime,s.CreateTime,s.Receipt,s.CreateUser,p.pkname ParkName,u.UserName,s.Remark from parksettlement s left join baseparkinfo p on s.pkid=p.pkid left join sysuser u on u.RecordID=s.CreateUser where s.pkid=@PKID"); if (SettleStatus != -1) { strSql.Append(" and settlestatus=@settlestatus"); } if (Priod != "-1") { strSql.Append(" and Priod=@Priod"); } List <ParkSettlementApprovalFlowModel> approvals = new ParkSettlementApprovalFlowDAL().GetSettlementApprovalFlows(PKID); //判断当前帐户是不是项目帐户 var companys = new CompanyDAL().QueryTopCompany(); List <Entities.SysUser> users = new List <Entities.SysUser> (); if (companys != null) { users = new SysUserDAL().QuerySysUserByCompanys(companys.Select(u => u.CPID).ToList()); } using (DbOperator dbOperator = ConnectionManager.CreateReadConnection()) { dbOperator.ClearParameters(); dbOperator.AddParameter("PKID", PKID); dbOperator.AddParameter("SettleStatus", SettleStatus); dbOperator.AddParameter("Priod", Priod); dbOperator.AddParameter("userid", UserID); using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString())) { while (reader.Read()) { ParkSettlementModel sm = DataReaderToModel <ParkSettlementModel> .ToModel(reader); if (sm.CreateTime > DateTime.MinValue) { sm.CreateTimeName = sm.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"); } if (sm.EndTime > DateTime.MinValue) { sm.EndTimeName = sm.EndTime.ToString("yyyy-MM-dd HH:mm:ss"); } if (sm.PayTime > DateTime.MinValue) { sm.PayTimeName = sm.PayTime.ToString("yyyy-MM-dd HH:mm:ss"); } if (sm.StartTime > DateTime.MinValue) { sm.StartTimeName = sm.StartTime.ToString("yyyy-MM-dd HH:mm:ss"); } //申请人为当前人 //if (UserID == sm.CreateUser) //{ // if (sm.SettleStatus != 0) // { // if (!IsApprovalFlow(PKID, UserID, sm.SettleStatus)) // { // sm.IsHide = true; // } // } //} if (sm.SettleStatus == 0) { var appro = approvals.Find(u => u.FlowID == 0); if (appro != null) { if (appro.FlowUser == UserID) { sm.IsHide = false; } else { sm.IsHide = true; } } else { sm.IsHide = true; } } else if (sm.SettleStatus == 2 || sm.SettleStatus == -1) { sm.IsHide = true; } else { //如果是平台用户,则不可见 if (users.Find(u => u.RecordID == UserID) != null) { sm.IsHide = true; } else { sm.IsHide = false; } } settlements.Add(sm); } } } return(settlements); }
public void Initialize() { var sysUserDAL = new SysUserDAL(); var sysMenuDAL = new SysMenuDAL(); var sysDictionary = new SysDictionaryDAL(); var siteInfoDAL = new SiteInfoDAL(); if (sysUserDAL.Count() == 0) { //初始化用户 sysUserDAL.Insert(new Entity.SysUser { UserName = "******", Password = "******", UserType = Entity.Enum.UserType.SuperUser, CreateBy = "admin", CreateDt = DateTime.Now, Email = "*****@*****.**" }); } if (sysMenuDAL.Count() == 0) { var menuList = new List <SysMenu>(); var menuid1 = sysMenuDAL.Insert(new SysMenu { MenuName = "权限管理", ParentID = 0, Description = "", MenuUrl = "#", IconUrl = "#", Sort = 1, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); var menuList1 = new List <SysMenu>(); menuList1.Add(new SysMenu { MenuName = "用户管理", ParentID = menuid1, Description = "", MenuUrl = "/Admin/SysUser/Index", IconUrl = "#", Sort = 2, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList1.Add(new SysMenu { MenuName = "角色管理", ParentID = menuid1, Description = "", MenuUrl = "/Admin/SysRole/Index", IconUrl = "#", Sort = 3, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList1.Add(new SysMenu { MenuName = "菜单管理", ParentID = menuid1, Description = "", MenuUrl = "/Admin/SysMenu/Index", IconUrl = "#", Sort = 4, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysMenuDAL.BatchInsert(menuList1); var menuList2 = new List <SysMenu>(); var menuid2 = sysMenuDAL.Insert(new SysMenu { MenuName = "文章管理", ParentID = 0, Description = "", MenuUrl = "#", IconUrl = "#", Sort = 1, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList2.Add(new SysMenu { MenuName = "文章列表", ParentID = menuid2, Description = "", MenuUrl = "/Admin/Article/Index", IconUrl = "#", Sort = 6, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList2.Add(new SysMenu { MenuName = "文章分类", ParentID = menuid2, Description = "", MenuUrl = "/Admin/ArticleType/Index", IconUrl = "#", Sort = 7, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysMenuDAL.BatchInsert(menuList2); var menuList3 = new List <SysMenu>(); var menuid3 = sysMenuDAL.Insert(new SysMenu { MenuName = "系统设置", ParentID = 0, Description = "", MenuUrl = "#", IconUrl = "#", Sort = 99, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList3.Add(new SysMenu { MenuName = "字典管理", ParentID = menuid3, Description = "", MenuUrl = "/Admin/SysDictionary/Index", IconUrl = "#", Sort = 9, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList3.Add(new SysMenu { MenuName = "站点信息", ParentID = menuid3, Description = "", MenuUrl = "/Admin/SiteInfo/Index", IconUrl = "#", Sort = 9, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList3.Add(new SysMenu { MenuName = "更新日志", ParentID = menuid3, Description = "", MenuUrl = "/Admin/SysUpdateLog/Index", IconUrl = "#", Sort = 9, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysMenuDAL.BatchInsert(menuList3); } if (sysDictionary.Count() == 0) { var dic1 = (new SysDictionary { DictName = "权限按钮", DictNo = "PermissionButton", ParentID = 0, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); long id1 = sysDictionary.Insert(dic1); var dicList = new List <SysDictionary>(); dicList.Add(new SysDictionary { DictName = "新增", DictNo = "add", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "修改", DictNo = "update", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "删除", DictNo = "delete", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "导出", DictNo = "export", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "导入", DictNo = "import", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "打印", DictNo = "Print", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "审核", DictNo = "Auth", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "查看", DictNo = "show", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysDictionary.BatchInsert(dicList); var dic2 = (new SysDictionary { DictName = "站点设置", DictNo = "SiteSetting", ParentID = 0, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); long id2 = sysDictionary.Insert(dic2); var dic3 = (new SysDictionary { DictName = "简语描述", DictNo = "Index_Sketch", ParentID = id2, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); long id3 = sysDictionary.Insert(dic3); var dicList2 = new List <SysDictionary>(); dicList2.Add(new SysDictionary { DictName = "字典配置1", DictNo = "01", ParentID = id3, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList2.Add(new SysDictionary { DictName = "字典配置2", DictNo = "02", ParentID = id3, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList2.Add(new SysDictionary { DictName = "字典配置3", DictNo = "03", ParentID = id3, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysDictionary.BatchInsert(dicList2); } if (siteInfoDAL.Count() == 0) { var siteinfo = (new SiteInfo { SiteName = "FreeSql", Status = 1, Headline = ".NETCore最方便的ORM", Abstract = "FreeSql 是一个功能强大的 .NETStandard 库,用于对象关系映射程序(O/RM),支持 .NETCore 2.1+ 或 .NETFramework 4.6.1+", CreateDt = DateTime.Now, CreateBy = "admin" }); siteInfoDAL.Insert(siteinfo); } }