public ActionResult SaveRolePer(long Rid, string Pids)
{
BaseDal <rolepermission> rmDal = new BaseDal <rolepermission>();
rolepermission rmModel = new rolepermission();
try
{
rmDal.ExecSqlCommand(string.Format("delete from {0} WHERE rid = {1}", "rolepermission", Rid));
Pids.Split(',').ToList().ForEach(
q =>
{
rmModel = new rolepermission()
{
Rid = Rid, Pid = Convert.ToInt64(q)
};
rmDal.Add(rmModel);
}
);
return(Success());
}
catch (Exception e)
{
return(Error(e));
}
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="logType">日志类型</param>
/// <param name="controller">控制器名称</param>
/// <param name="modelName">模块名称</param>
/// <param name="action">方法</param>
/// <param name="handleType">操作类型</param>
/// <param name="note">文本</param>
/// <param name="userId">操作用户编号</param>
/// <param name="userName">操作用户名称</param>
/// <returns></returns>
public bool AddLog(LogType logType, string controller, string modelName, string action, HandleType handleType, string note,
string userId, string userName)
{
try
{
ComOperationLogEntity entity = new ComOperationLogEntity()
{
Id = LogHelper.Id,
LogType = (int)logType,
Controller = controller,
ModelName = modelName,
Action = action,
HandleTypeId = ((int)handleType).ToString(),
Note = note,
Ip = LogHelper.GetUserIp,
CreatorId = userId,
CreateBy = userName,
CreateOn = DateTime.Now
};
BaseDal.Add(entity);
return(true);
}
catch {
return(false);
}
}
public virtual ActionResult Upload()
{
string[] type = { ".bmp", ".jpg", ".jpeg", ".png", ".gif", ".exe" };
List <long> list = new List <long>();
try
{
BaseDal <image> idal = new BaseDal <image>();
image en = new image();
HttpFileCollectionBase collection = HttpContext.Request.Files;
for (int i = 0; i < collection.Count; i++)
{
HttpPostedFileBase singel = collection[i];
byte[] buff = new byte[singel.ContentLength];
singel.InputStream.Read(buff, 0, singel.ContentLength);
en.Name = singel.FileName;
en.Img = buff;
en.ContentType = Path.GetExtension(singel.FileName);
if (type.Any(h => h == en.ContentType.ToLower()))
{
en = idal.Add(en);
list.Add(en.ID);
}
else
{
return(Error(new Exception("文件格式不支持")));
}
}
return(Json(new { Message = Tip.Success, Ids = string.Join(",", list) }));
}
catch (Exception e)
{
return(Error(e));
}
}
/// <summary>
/// 添加登录日志
/// 添加人：周 鹏
/// 添加时间：2015-08-11
/// </summary>
/// <history>
/// 修改描述：时间+作者+描述
/// </history>
/// <param name="source">登录来源（Web、PDA）</param>
/// <param name="ip">登录IP</param>
/// <param name="status">登录状态（成功、失败）</param>
/// <param name="note">登录情况说明</param>
/// <param name="account">登录账号</param>
/// <param name="userName">登录人员姓名</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
public bool AddLog(int source, string ip, int status, string note, string account, string userName)
{
try
{
var entity = new ComLoginLogEntity()
{
Id = LogHelper.Id,
Source = source,
Ip = ip,
Status = status,
Note = note,
CreatorId = account,
CreateBy = userName,
CreateOn = DateTime.Now
};
BaseDal.Add(entity);
if (status != 3)
{
LogHelper.Dispose();
}
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 有条件的添加
/// </summary>
/// <param name="en"></param>
/// <param name="where"></param>
/// <returns></returns>
public virtual ActionResult AddExpress(T en, Expression <Func <T, bool> > where)
{
try
{
if (dal.Exist(where))
{
return(Error(new Exception("该记录已存在")));
}
else
{
dal.Add(en);
return(Success());
}
}
catch (Exception e)
{
return(Error(e));
}
}
/// <summary>
/// 保存通用文章
/// 添加人：张西琼
/// 时间：2014-11-13
/// <history>
/// 修改描述：时间+作者+描述
/// </history>
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public ComArticleEntity SaveArticle(ComArticleEntity entity)
{
try
{
return(BaseDal.Add(entity));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public override ActionResult Add(user u)
{
//有条件添加 判断 用户名是否存在
Expression <Func <user, bool> > where = q => q.LoginName == u.LoginName.Trim();
string Rid = Request["Rid"];
userrole urole = new userrole();
try
{
if (dal.Exist(where))
{
return(Error(new Exception("该记录已存在")));
}
else
{
long uid = dal.Add(u).Id;
Rid.Split(',').ToList().ForEach(
q =>
{
urole = new userrole()
{
Uid = uid, Rid = Convert.ToInt64(q)
};
urDal.Add(urole);
}
);
return(Success());
}
}
catch (Exception e)
{
return(Error(e));
}
//return AddExpress(u, where);
}
public HttpResponseMessage response(Response rs)
{
rest.add();
var res = new HttpResponseMessage();
context.Add(rs);
//var re = new ResponseDTO();
//re.name = "myname";
var r = map.Map <Response>(rs);
//context.Add(r);
//context.SaveChanges();
return(res);
}
public ActionResult SaveFeedback(fankui feedback)
{
feedback.Flag = 0;
var t = fdal.Add(feedback);
if (t.Id > 0)
{
return(Content("<script>alert('提交成功');window.location='/Kbase/Index.do'</script>;"));
}
else
{
return(Content("<script>alert('提交失败');window.location='/Kbase/Index.do'</script>;"));
}
}
public ActionResult Add(string command, string type, HttpPostedFile upload)
{
var uploads = Request.Files["upload"];
image img = new image();
using (MemoryStream stream = new MemoryStream())
{
uploads.InputStream.CopyTo(stream);
img.Img = stream.ToArray();
}
img.Name = uploads.FileName;
img.ContentType = uploads.ContentType;
var res = imgdal.Add(img);
var CKEditorFuncNum = System.Web.HttpContext.Current.Request["CKEditorFuncNum"];
var url = "/Image/get.do?id=" + res.ID;
return(Content("<script>window.parent.CKEDITOR.tools.callFunction(" + CKEditorFuncNum + ", \"" + url + "\");</script>"));
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public virtual JsonModel Add(T entity)
{
JsonModel jsonModel = null;
try
{
int result = CurrentDal.Add(entity);
if (result > 0)
{
jsonModel = new JsonModel()
{
errNum = 0,
errMsg = "success",
retData = result
};
}
else
{
jsonModel = new JsonModel()
{
errNum = 5,
errMsg = "名称重复",
retData = result
};
}
return(jsonModel);
}
catch (Exception ex)
{
LogHelper.Error(ex);
jsonModel = new JsonModel()
{
errNum = 400,
errMsg = ex.Message,
retData = ""
};
return(jsonModel);
}
}
public bool Add(T t)
{
return(dal.Add(t) > 0);
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public MsgResult InitData(List <T_SysOperations> list)
{
MsgResult result = new MsgResult();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
int count = 0;
//1 , 清除关系表以及数据表
count = BaseDal.Clear(typeof(T_UserRoles).Name);
count = BaseDal.Clear(typeof(T_RolePermissions).Name);
count = BaseDal.Clear(typeof(T_OperatePermissions).Name);
count = BaseDal.Clear(typeof(T_MenuPermissions).Name);
count = BaseDal.Clear(typeof(T_AdminUsers).Name);
count = BaseDal.Clear(typeof(T_SysRoles).Name);
count = BaseDal.Clear(typeof(T_SysPermissions).Name);
count = BaseDal.Clear(typeof(T_SysOperations).Name);
// 2 , 初始化数据
//用户
T_AdminUsers adminUser = new T_AdminUsers();
adminUser.Phone = "17512039375";
adminUser.CreateTime = DateTime.Now;
adminUser.CreateUser = 1;
adminUser.Salt = "123456";
adminUser.PwdHush = EncryptHelper.GetMd5("n5187698" + adminUser.Salt);
adminUser.Guid = Guid.NewGuid().ToString("N");
var addUser = BaseDal.Add(adminUser);
BaseDal.SaveChanges();
//角色
T_SysRoles role = new T_SysRoles();
role.Guid = Guid.NewGuid().ToString("N");
role.Name = "超级管理员";
role.Description = "拥有所有的权限";
role.CreateUser = addUser.Id;
role.CreateTime = DateTime.Now;
//操作权限
T_SysPermissions permission = new T_SysPermissions();
permission.Guid = Guid.NewGuid().ToString("N");
permission.Type = 1;
permission.Description = "操作权限";
permission.CreateUser = addUser.Id;
permission.CreateTime = DateTime.Now;
//菜单权限
T_SysPermissions permissionNew = new T_SysPermissions();
permissionNew.Guid = Guid.NewGuid().ToString("N");
permissionNew.Type = 2;
permissionNew.Description = "菜单权限";
permissionNew.CreateUser = addUser.Id;
permissionNew.CreateTime = DateTime.Now;
var addRole = SysRolesDal.Add(role);
var addPermission = SysPermissionsDal.Add(permission);
var addPermissionNew = SysPermissionsDal.Add(permissionNew);
BaseDal.SaveChanges();
//操作列表
SysOperationsDal.BatchAdd(list);
var newList = SysOperationsDal.GetModel(x => x.Id >= 0).ToList();
// 3 , 初始化关系
T_UserRoles userRole = new T_UserRoles();
userRole.UserId = addUser.Id;
userRole.RoleId = addRole.Id;
//用户角色
adminUser.T_UserRoles.Add(userRole);
BaseDal.SaveChanges();
//操作权限
T_RolePermissions permissions = new T_RolePermissions();
permissions.RoleId = addRole.Id;
permissions.PermissionId = addPermission.Id;
//菜单权限
T_RolePermissions permissionsNew = new T_RolePermissions();
permissionsNew.RoleId = addRole.Id;
permissionsNew.PermissionId = addPermissionNew.Id;
//角色权限
role.T_RolePermissions.Add(permissions);
role.T_RolePermissions.Add(permissionsNew);
List <T_OperatePermissions> addOperatelist = new List <T_OperatePermissions>();
for (int i = 0; i < newList.Count; i++)
{
T_OperatePermissions operate = new T_OperatePermissions();
operate.PermissionId = addPermission.Id;
operate.OperationId = newList[i].Id;
addOperatelist.Add(operate);
}
//权限操作
permission.T_OperatePermissions = addOperatelist;
List <T_MenuPermissions> addMenuOperate = new List <T_MenuPermissions>();
List <T_SysMenus> menuList = new List <T_SysMenus>();
menuList = SysMenusDal.GetModel(X => X.Id >= 0).ToList();
for (int i = 0; i < menuList.Count; i++)
{
T_MenuPermissions menuPermission = new T_MenuPermissions();
menuPermission.MenuId = menuList[i].Id;
menuPermission.PermissionId = addPermissionNew.Id;
addMenuOperate.Add(menuPermission);
}
permissionNew.T_MenuPermissions = addMenuOperate;
BaseDal.SaveChanges();
scope.Complete();
}
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Message = e.Message;
}
return(result);
}
//新增一个用户
#region 新增一个用户
/// <summary>
/// 新增一个用户
/// </summary>
/// <param name="entity">输入一个准备新增用户的对象</param>
/// <returns>返回该新增用户</returns>
public UserInfo Add(UserInfo entity)
{
return(based.Add(entity));
}
/// <summary>
/// Adds the specified element.
/// </summary>
/// <param name="element">The element.</param>
/// <returns></returns>
/// 创建者：叶烨星
/// 创建时间：2018/1/28 19:10
/// 修改者：
/// 修改时间：
public ServiceResult <bool> Add(T element)
{
return(dal.Add(element));
}
public bool Add(T t)
{
return(baseDal.Add(t) > 0 ? true : false);
}
public int Add(T DevInfo)
{
return(dal.Add(DevInfo));
}
public virtual async Task <bool> Add(T t)
{
return(await dal.Add(t));
}
private void ImportDictionary()
{
var view = new TaskInfoDialog();
var result = DialogHost.Show(view, "RootDialog");
TaskInfoDialogViewModel taskInfoDialog = TaskInfoDialogViewModel.getInstance();
TaskMessage taskMessage = new TaskMessage();
taskMessage.Title = "执行导入字典目录任务";
taskMessage.Progress = 0.0;
taskInfoDialog.Messages.Add(taskMessage);
Task task = new Task(() =>
{
App.Current.Dispatcher.Invoke((Action)(() =>
{
taskMessage.DetailMessages.Add("开始导入。。");
}));
// 导入BDCS_CONSTCLS
BaseDal <CONSTCLS> baseDal = new BaseDal <CONSTCLS>();
StreamReader sr = new StreamReader(@"C:\Users\Administrator\Desktop\BDCS_CONSTCLS 1.txt", Encoding.Default);
String line;
int index = 0;
while ((line = sr.ReadLine()) != null)
{
string[] s = line.Split(',');
CONSTCLS c = new CONSTCLS();
c.MBBSM = int.Parse(s[0].Trim());
c.CONSTSLSID = int.Parse(s[1].Trim());
c.CONSTCLSNAME = s[2].Trim();
c.CONSTCLSTYPE = s[3].Trim();
c.BZ = s[4].Trim();
baseDal.Add(c);
index++;
double per = index / 79.0 * 100;
taskMessage.Progress = per;
App.Current.Dispatcher.Invoke((Action)(() =>
{
taskMessage.DetailMessages.Add("字典目录表：进度" + per.ToString("#0.#0") + "%");
}));
}
index = 0;
taskMessage.Progress = 0.0;
BaseDal <CONST> baseDal2 = new BaseDal <CONST>();
StreamReader sr2 = new StreamReader(@"C:\Users\Administrator\Desktop\BDCS_CONST 1.txt", Encoding.Default);
String line2;
while ((line2 = sr2.ReadLine()) != null)
{
string[] s = line2.Split(',');
CONST c = new CONST();
c.MBBSM = int.Parse(s[0].Trim());
c.CONSTSLSID = int.Parse(s[1].Trim());
c.CONSTVALUE = s[2].Trim();
c.CONSTTRANS = s[3].Trim();
if (s[4].Trim() != "")
{
c.PARENTNODE = int.Parse(s[4].Trim());
}
else
{
c.PARENTNODE = null;
}
if (s[5].Trim() != "")
{
c.CONSTORDER = int.Parse(s[5].Trim());
}
else
{
c.CONSTORDER = null;
}
c.BZ = s[6].Trim();
c.CREATETIME = null;
c.MODIFYTIME = null;
c.REPORTVALUE = s[9].Trim();
c.GJCONSTTRANS = s[10].Trim();
c.SFSY = s[11].Trim();
c.GJVALUE = s[12].Trim();
baseDal2.Add(c);
index++;
double per = index / 1918.0 * 100;
taskMessage.Progress = per;
App.Current.Dispatcher.Invoke((Action)(() =>
{
taskMessage.DetailMessages.Add("字典表：进度" + per.ToString("#0.#0") + "%");
}));
}
});
task.Start();
task.ContinueWith(t =>
{
ThreadPool.QueueUserWorkItem(delegate
{
SynchronizationContext.SetSynchronizationContext(new
System.Windows.Threading.DispatcherSynchronizationContext(System.Windows.Application.Current.Dispatcher));
SynchronizationContext.Current.Post(pl =>
{
taskMessage.DetailMessages.Add("导入完成。");
}, null);
});
});
}
public T Add(T entity)
{
CurrentDal.Add(entity);
DbSession.SaveChanges();
return(entity);
}
public bool Add(T model)
{
return(dal.Add(model) > 0);
}
/// <summary>
/// 添加一个对象
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public bool Add(T t)
{
dal.Add(t);
return(dal.SaveChanges() > 0);
}
