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