/// <summary>
/// 创建标签
/// </summary>
/// <param name="name"></param>
/// <param name="sortNum"></param>
/// <param name="categoryId"></param>
/// <returns></returns>
public int CreateTags(string name, int sortNum, int categoryId)
{
var pagesize = 0;
CheckPageSize(this.PageSize, out pagesize);
CheckManageId();
CheckName(name);
CheckSortNum(sortNum);
CheckCategoryId(categoryId);
Manage manage;
CheckManageId(out manage);
//CheckExistName(name);
var tags = new Tags()
{
CreateUserId = manage.Id,
CreateTime = DateTime.Now,
KeyWord = PinyinHelper.PinyinString(name),
Name = name,
SortNum = sortNum,
CategoryId = categoryId
};
this._tagsRepository.CreateEntity(tags);
return(tags.Id);
}
public int GetrOrAddUser(string userName)
{
using (ProofDataContext pdc = new ProofDataContext())
{
string pym = userName.ToLower();
var re = pdc.xt_ryb.Where(p => p.xm == userName).FirstOrDefault();
if (re == null)
{
int ghid = int.Parse(pdc.xt_ryb.Max(p => p.gh));
pdc.xt_ryb.Add(new xt_ryb
{
id_dept = 3,
rylb = "1",
gzlb = "1",
xm = userName,
pym = PinyinHelper.PinyinString(userName),
mm = "123",
xb = "1",
gh = (ghid + 1).ToString(),
});
pdc.SaveChanges();
re = pdc.xt_ryb.Where(p => p.xm == userName).FirstOrDefault();
}
return(re.id);
}
}
public void SyncUsers(List <User> users)
{
using (SunginDataContext sc = new SunginDataContext())
{
var ulist = sc.Users.ToList();
ulist.ForEach(p => p.IsDelete = true);
users.ForEach(p =>
{
var u = ulist.SingleOrDefault(t => t.DdId == p.DdId);
if (u == null)
{
p.Pinyin = PinyinHelper.PinyinString(p.UserName);
sc.Users.Add(p);
}
else
{
u.Pinyin = PinyinHelper.PinyinString(u.UserName);
u.UserName = p.UserName;
u.IsLeader = p.IsLeader;
u.DeptId = p.DeptId;
u.DepartName = p.DepartName;
u.Avatar = p.Avatar;
u.IsDelete = false;
};
});
sc.SaveChanges();
}
}
/// <summary>
/// 添加多个标签和数量
/// </summary>
/// <param name="dicts">标签名称,排序数量</param>
/// <returns></returns>
public void CreateTags(IDictionary <string, int> dicts)
{
if (dicts == null || dicts.Count <= 0)
{
return;
}
if (UserId <= 0)
{
return;
}
IList <Condtion> condtions = new List <Condtion>()
{
ConditionEqualId(UserId),
CondtionEqualState()
};
var user = this._userRepository.GetEntity(condtions);
if (user == null)
{
return;
}
IList <Tags> updateTags = new List <Tags>();
IList <Tags> insertTag = new List <Tags>();
foreach (var dict in dicts)
{
var tags = (from t in this._tagsRepository.GetEntityList()
where t.State == false &&
t.Name.Trim() == dict.Key
select t).FirstOrDefault();
if (tags != null)
{
tags.SortNum = dict.Value;
tags.UpdateUserId = user.Id;
tags.UpdateTime = DateTime.Now;
updateTags.Add(tags);
}
else
{
var newTags = new Tags()
{
Name = dict.Key,
KeyWord = PinyinHelper.PinyinString(dict.Key),
CreateUserId = user.Id,
CreateTime = DateTime.Now,
SortNum = dict.Value
};
insertTag.Add(newTags);
}
}
if (updateTags.Count > 0)
{
this._tagsRepository.UpdateEntitys(updateTags);
}
if (insertTag.Count > 0)
{
this._tagsRepository.CreateEntitys(insertTag);
}
}
/// <summary>
/// 修改板块信息
/// </summary>
/// <param name="id">板块编号</param>
/// <param name="categoryId">分类编号</param>
/// <param name="name">板块名称</param>
/// <param name="sortNum">排序数量</param>
/// <param name="pageSize">显示行数</param>
/// <returns></returns>
public bool UpdatePlate(int id, int categoryId, string name, int sortNum, int pageSize)
{
CheckId(id);
CheckName(name);
CheckPageSize(pageSize);
categoryId = categoryId <= 0 ? 0 : categoryId;
Category category = null;
if (categoryId > 0)
{
CheckCategoryId(categoryId);
CheckCategoryId(categoryId, out category);
}
Plate plate;
CheckId(id, out plate);
CheckName(id, name, category);
plate.CategoryId = categoryId;
plate.Name = name;
plate.KeyWord = PinyinHelper.PinyinString(name);
plate.UpdateManageId = 1;
plate.UpdateTime = DateTime.Now;
plate.SortNum = sortNum;
plate.PageSize = pageSize;
return(this._plateRepository.UpdateEntity(plate));
}
/// <summary>
/// 添加板块
/// </summary>
/// <param name="categoryId">分类编号</param>
/// <param name="name">板块名称</param>
/// <param name="sortNum">排序数量</param>
/// <param name="pageSize">显示多少条</param>
/// <returns></returns>
public int CreatePlate(int categoryId, string name, int sortNum, int pageSize)
{
categoryId = categoryId <= 0 ? 0 : categoryId;
CheckName(name);
CheckPageSize(pageSize);
Category category = null;
if (categoryId > 0)
{
CheckCategoryId(categoryId);
CheckCategoryId(categoryId, out category);
}
CheckName(name, category);
var plate = new Plate()
{
CategoryId = categoryId,
CreateManageId = 1,
CreateTime = DateTime.Now,
KeyWord = PinyinHelper.PinyinString(name),
PageSize = pageSize,
Name = name,
SortNum = sortNum
};
this._plateRepository.CreateEntity(plate);
return(plate.Id);
}
/// <summary>
/// 添加分类
/// </summary>
/// <param name="name">分类名称</param>
/// <param name="parentId">分类的上级编号</param>
/// <returns></returns>
public int CreateCategory(string name, int parentId)
{
CheckNameNotNull(name);
CheckName(parentId, name);
string locationpath = "";
if (parentId > 0)
{
Category parentCategory;
CheckId(parentId, out parentCategory);
CheckLocalhostPathNotNull(parentCategory.LocationPath);
CheckLocationPath(parentCategory.LocationPath);
locationpath = parentCategory.LocationPath + ",";
}
var category = new Category()
{
Name = name,
ParentId = parentId,
CreateManageId = 1,
CreateTime = DateTime.Now,
KeyWord = PinyinHelper.PinyinString(name),
LocationPath = locationpath
};
this._categoryRepository.CreateEntity(category);
category.LocationPath = category.LocationPath + GetLocalhostPath(category.Id);
this._categoryRepository.UpdateEntity(category);
return(category.Id);
}
/// <summary>
/// 确认事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Accept_Click(object sender, EventArgs e)
{
bool IsOk = false;
bpms_employee = ControlBindHelper.GetWebControls <BPMS_Employee>(this.Page);
bpms_employee.Enabled = Enabled.Checked ? 1 : 0;
bpms_employee.IsDimission = IsDimission.Checked ? 1 : 0;
bpms_employee.CompanyId = hiddenCompanyId.Value;
bpms_employee.DepartmentId = hiddenDepartmentId.Value;
bpms_employee.WorkgroupId = hiddenWorkgroupId.Value;
bpms_employee.Spell = PinyinHelper.PinyinString(bpms_employee.RealName);
if (!string.IsNullOrEmpty(_key))//判断是否编辑
{
bpms_employee.EmployeeId = _key;
bpms_employee.ModifyDate = DateTime.Now;
bpms_employee.ModifyUserId = RequestSession.GetSessionUser().UserId;
bpms_employee.ModifyUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_employeeibll.Update(bpms_employee);
if (IsOk)
{
//保存成功后将数据同步到微信企业号
string[] tempDepart = new string[3] {
bpms_employee.CompanyId, bpms_employee.DepartmentId, bpms_employee.WorkgroupId
};
Extattr extattr = new Extattr();
extattr = null;
if (!myCommFun.UpdateMember(bpms_employee.Code, bpms_employee.RealName, toDepartmentId(tempDepart), toPosition(bpms_employee.DutyId), bpms_employee.Mobile, toGender(bpms_employee.Gender), bpms_employee.Email, bpms_employee.WeixinId, Convert.ToInt32(bpms_employee.Enabled), bpms_employee.headpic, extattr))
{
ShowMsgHelper.AlertCallback(MessageHelper.MSG0032);
}
ShowMsgHelper.AlertParmCallback(MessageHelper.MSG0006);
}
}
else
{
bpms_employee.EmployeeId = CommonHelper.GetGuid;
bpms_employee.CreateUserId = RequestSession.GetSessionUser().UserId;
bpms_employee.CreateUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_employeeibll.Insert(bpms_employee);
if (IsOk)
{
//保存成功后将数据同步到微信企业号
string[] tempDepart = new string[3] {
bpms_employee.CompanyId, bpms_employee.DepartmentId, bpms_employee.WorkgroupId
};
Extattr extattr = new Extattr();
extattr = null;
if (!myCommFun.CreateMember(bpms_employee.Code, bpms_employee.RealName, toDepartmentId(tempDepart), toPosition(bpms_employee.DutyId), bpms_employee.Mobile, toGender(bpms_employee.Gender), bpms_employee.Email, bpms_employee.WeixinId, bpms_employee.headpic, extattr))
{
ShowMsgHelper.AlertCallback(MessageHelper.MSG0032);
}
ShowMsgHelper.AlertParmCallback(MessageHelper.MSG0005);
}
}
if (!IsOk)
{
ShowMsgHelper.Alert_Error(MessageHelper.MSG0022);
}
}
/// <summary>
/// 添加多个标签
/// </summary>
/// <param name="names">标签名称</param>
/// <returns></returns>
public bool CreateTags(IList <string> names)
{
if (names == null || names.Count <= 0)
{
return(false);
}
if (UserId < 0)
{
return(false);
}
IList <Condtion> condtions = new List <Condtion>()
{
ConditionEqualId(UserId),
CondtionEqualState()
};
var user = this._userRepository.GetEntity(condtions);
if (user == null)
{
return(false);
}
IList <Tags> updateTags = new List <Tags>();
IList <Tags> insertTags = new List <Tags>();
foreach (var name in names)
{
var tag = (from t in this._tagsRepository.GetEntityList()
join u in this._userRepository.GetEntityList() on t.CreateUserId equals u.Id
where t.State == false &&
u.State == false
select t).FirstOrDefault();
if (tag != null)
{
tag.SortNum += 1;
tag.UpdateTime = DateTime.Now;
tag.UpdateUserId = user.Id;
updateTags.Add(tag);
}
else
{
var newTag = new Tags()
{
Name = name,
KeyWord = PinyinHelper.PinyinString(name),
CreateUserId = user.Id,
CreateTime = DateTime.Now
};
insertTags.Add(newTag);
}
}
this._tagsRepository.UpdateEntitys(updateTags);
this._tagsRepository.CreateEntitys(insertTags);
return(true);
}
public void AddUser(User user)
{
using (SunginDataContext sc = new SunginDataContext())
{
SetLoginInfo(ref user);
user.SetCreateUser("system");
user.Pinyin = PinyinHelper.PinyinString(user.UserName);
sc.Users.Add(user);
sc.SaveChanges();
}
}
/// <summary>
/// 修改字典名称
/// </summary>
/// <param name="name">字典名称</param>
/// <param name="id">分类编号</param>
/// <returns></returns>
public bool UpdateDictionary(string name, int id)
{
CheckNameNotNull(name);
CheckIdBiggerZero(id);
Dictionary dictionary;
CheckDictionaryId(id, out dictionary);
dictionary.Name = name;
dictionary.KeyWord = PinyinHelper.PinyinString(name);
dictionary.UpdateManageId = 1;
dictionary.UpdateTime = DateTime.Now;
return(this._dictionaryRepository.UpdateEntity(dictionary));
}
/// <summary>
/// 修改分类名称
/// </summary>
/// <param name="name">分类名称</param>
/// <param name="id">分类编号</param>
/// <returns></returns>
public bool UpdateCategory(string name, int id)
{
CheckNameNotNull(name);
CheckIdBiggerZero(id);
Category category;
CheckId(id, out category);
CheckName(category.ParentId, name);
category.Name = name;
category.KeyWord = PinyinHelper.PinyinString(name);
category.UpdateManageId = 1;
category.UpdateTime = DateTime.Now;
return(this._categoryRepository.UpdateEntity(category));
}
public EmpCheckMonth(USERINFO emp, AttControlClass attControl, GetDeptNameDelgate GetDeptName)
{
Emp = emp;
DeptName = GetDeptName((short)emp.DEFAULTDEPTID);
AttControl = attControl;
GetDayType = AttControl.GetDayType;
EmpNote = AttControl.GetEmpNoteInfoByByte(emp.Notes);
if (EmpNote == null)
{
EmpNote = new EmpNoteInfo();
EmpNote.EmpPyName = PinyinHelper.PinyinString(emp.Name);
EmpNote.IsHaveNote = true;
AttControl.UpDateEmpNoteInfo(emp.USERID, EmpNote);
}
}
/// <summary>
/// 确认事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Accept_Click(object sender, EventArgs e)
{
bool IsOk = false;
bpms_user = ControlBindHelper.GetWebControls <BPMS_User>(this.Page);
bpms_user.Enabled = Enabled.Checked ? 1 : 0;
bpms_user.CompanyId = hiddenCompanyId.Value;
bpms_user.DepartmentId = hiddenDepartmentId.Value;
bpms_user.WorkgroupId = hiddenWorkgroupId.Value;
bpms_user.RoleId = hiddenRoleId.Value;
bpms_user.Spell = PinyinHelper.PinyinString(bpms_user.RealName);
if (!string.IsNullOrEmpty(_key))//判断是否编辑
{
bpms_user.UserId = _key;
bpms_user.ModifyDate = DateTime.Now;
bpms_user.ModifyUserId = RequestSession.GetSessionUser().UserId;
bpms_user.ModifyUserName = RequestSession.GetSessionUser().UserName;
bpms_user.Password = null;
IsOk = bpms_useribll.Update(bpms_user);
if (IsOk)
{
ShowMsgHelper.AlertCallback(MessageHelper.MSG0006);
}
}
else
{
bpms_user.UserId = CommonHelper.GetGuid;
bpms_user.Secretkey = Md5Helper.MD5(CommonHelper.CreateNo(), 16);
string Password = DESEncrypt.Encrypt(bpms_user.Password, bpms_user.Secretkey);
bpms_user.Password = Md5Helper.MD5(Password, 32);
bpms_user.CreateUserId = RequestSession.GetSessionUser().UserId;
bpms_user.CreateUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_useribll.Insert(bpms_user);
if (IsOk)
{
ShowMsgHelper.AlertCallback(MessageHelper.MSG0005);
}
}
if (!IsOk)
{
ShowMsgHelper.Alert_Error(MessageHelper.MSG0022);
}
}
public int CreateDictionaryItem(string name, int parentId)
{
CheckNameNotNull(name);
if (parentId > 0)
{
Dictionary parentDictionary;
CheckDictionaryId(parentId, out parentDictionary);
}
var dictionaryItem = new DictionaryItem()
{
Name = name,
DictionaryId = parentId,
CreateManageId = 1,
CreateTime = DateTime.Now,
KeyWord = PinyinHelper.PinyinString(name),
};
this._dictionaryItemRepository.CreateEntity(dictionaryItem);
return(dictionaryItem.Id);
}
/// <summary>
/// 添加字典
/// </summary>
/// <param name="name">字典名称</param>
/// <param name="parentId">字典上级分类编号</param>
/// <returns></returns>
public int CreateDictionary(string name, int parentId)
{
CheckNameNotNull(name);
if (parentId > 0)
{
Category parentCategory;
CheckCategoryId(parentId, out parentCategory);
CheckLocalhostPathNotNull(parentCategory.LocationPath);
CheckLocationPath(parentCategory.LocationPath);
}
var dictionary = new Dictionary()
{
Name = name,
CategoryId = parentId,
CreateManageId = 1,
CreateTime = DateTime.Now,
KeyWord = PinyinHelper.PinyinString(name),
};
this._dictionaryRepository.CreateEntity(dictionary);
return(dictionary.Id);
}
/// <summary>
/// 修改标签
/// </summary>
/// <param name="id"></param>
/// <param name="name"></param>
/// <param name="sortNum"></param>
/// <returns></returns>
public int UpdateTags(int id, string name, int sortNum)
{
var pagesize = 0;
CheckId(id);
CheckPageSize(this.PageSize, out pagesize);
CheckManageId();
CheckName(name);
CheckSortNum(sortNum);
Manage manage;
CheckManageId(out manage);
Tags tags;
CheckId(id, out tags);
CheckExistName(tags.Id, name);
tags.Name = name;
tags.KeyWord = PinyinHelper.PinyinString(name);
tags.SortNum = sortNum;
tags.UpdateTime = DateTime.Now;
tags.UpdateUserId = manage.Id;
this._tagsRepository.UpdateEntity(tags);
return(tags.Id);
}
/// <summary>
/// 添加标签
/// </summary>
/// <param name="name">标签名称</param>
/// <returns></returns>
public bool CreateTags(string name)
{
if (string.IsNullOrEmpty(name))
{
return(false);
}
CheckUserId();
User user;
CheckUserId(out user);
var tags = (from t in this._tagsRepository.GetEntityList()
where t.State == false &&
t.Name == name.Trim()
select t).FirstOrDefault();
var success = false;
if (tags != null)
{
tags.SortNum += 1;
tags.UpdateTime = DateTime.Now;
tags.UpdateUserId = user.Id;
success = this._tagsRepository.UpdateEntity(tags);
}
else
{
var newTags = new Tags()
{
Name = name,
KeyWord = PinyinHelper.PinyinString(name),
CreateUserId = user.Id,
CreateTime = DateTime.Now
};
success = this._tagsRepository.CreateEntity(newTags);
}
return(success);
}
public int GetOrAddClient(string clientName)
{
using (ProofDataContext pdc = new ProofDataContext())
{
string c = clientName.ToLower();
string pym = PinyinHelper.PinyinString(clientName).ToLower();
var re = pdc.xt_khb.Where(p => p.khmc.ToLower() == c).FirstOrDefault();
if (re == null)
{
pdc.xt_khb.Add(new xt_khb
{
khmc = clientName,
khqc = clientName,
rq = DateTime.Now,
bz_dd = 1,
address = "内部同步客户",
pym = pym == "" ? clientName : pym,
});
pdc.SaveChanges();
re = pdc.xt_khb.Where(p => p.khmc.ToLower() == c).FirstOrDefault();
}
return(re.id);
}
}
public void TestPinyinHelper()
{
var aa = PinyinHelper.PinyinString("ffff");
}