public JsonResult SaveUserLinkMan(string linkManID)
{
linkManID = linkManID.Substring(1, linkManID.Length - 2);
string userID = Formula.FormulaHelper.GetUserInfo().UserID;
SQLHelper sqlHelper = SQLHelper.CreateSqlHelper("Base");
DataTable dt1 = sqlHelper.ExecuteDataTable(string.Format("select ID from S_A_UserLinkMan where UserID='{0}' and LinkManID='{1}' ", userID, linkManID));
if (dt1.Rows.Count > 0)
{
return(Json(JsonAjaxResult.Successful("联系人已存在！")));
}
string newID = FormulaHelper.CreateGuid();
object obj = sqlHelper.ExecuteScalar(string.Format("select Max(SortIndex) as SortIndex from S_A_UserLinkMan where UserID='{0}'", userID));
double maxSort = 0;
if (obj is DBNull)
{
maxSort = 0;
}
else
{
maxSort = Convert.ToDouble(obj);
}
sqlHelper.ExecuteDataTable(string.Format("Insert Into S_A_UserLinkMan (ID,UserID,LinkManID,SortIndex) Values ('{0}','{1}','{2}',{3})", newID, userID, linkManID, Math.Ceiling(maxSort) + 1));
return(Json(JsonAjaxResult.Successful("添加成功！")));
}
/// <summary>
/// 设置默认公众号
/// </summary>
/// <param name="MpID"></param>
/// <returns></returns>
public JsonResult SetDefaultMp(string MpID)
{
var mpUserRelationFO = Formula.FormulaHelper.CreateFO <MpUserRelationFO>();
mpUserRelationFO.SetDefaultMp(this.CurrentUserInfo.UserID, MpID);
return(Json(JsonAjaxResult.Successful()));
}
/// <summary>
/// 设置默认企业号
/// </summary>
/// <param name="QyID"></param>
/// <returns></returns>
public JsonResult SetDefaultQy(string QyID)
{
var qyUserRelationFO = Formula.FormulaHelper.CreateFO <QyUserRelationFO>();
qyUserRelationFO.SetDefaultQy(this.CurrentUserInfo.UserID, QyID);
return(Json(JsonAjaxResult.Successful()));
}
public JsonResult DeleteEmployee()
{
string listIDs = Request["ListIDs"];
string[] idArray = listIDs.Split(',');
entities.Set <T_Employee>().Where(c => idArray.Contains(c.ID)).Update(c =>
{
c.IsDeleted = "1";
c.DeleteTime = DateTime.Now;
});
entities.SaveChanges();
return(Json(JsonAjaxResult.Successful()));
}
public override JsonResult Delete()
{
#region 假删除
var IDs = (Request["ListIDs"] ?? "").Split(',');
var mpid = GetQueryString("MpID");
var etys = entities.Set <MpMessage>().Where(c => IDs.Contains(c.ID) && c.IsDelete == 0).ToList();
var wxFO = Formula.FormulaHelper.CreateFO <WxFO>();
for (int i = 0; i < etys.Count(); i++)
{
var entity = etys[i];
entity.IsDelete = 1;
}
entities.SaveChanges();
return(Json(JsonAjaxResult.Successful()));
#endregion
}
public JsonResult SyncSystemUser()
{
string Ids = Request["IDs"];
if (string.IsNullOrWhiteSpace(Ids))
{
return(Json(""));
}
BaseEntities baseEntities = FormulaHelper.GetEntities <BaseEntities>();
EmployeeFo fo = new EmployeeFo();
List <S_HR_Employee> employeeList = this.ComprehensiveDbContext.Set <S_HR_Employee>().Where(c => c.IsHaveAccount == "1" && Ids.Contains(c.ID)).ToList();
if (employeeList == null || employeeList.Count == 0)
{
return(Json(""));
}
foreach (S_HR_Employee employee in employeeList)
{
if (string.IsNullOrEmpty(employee.UserID))
{
fo.EmployeeAddToUser(employee, FormsAuthentication.HashPasswordForStoringInConfigFile(employee.Code.ToLower(), "SHA1"));
}
else
{
var user = baseEntities.Set <S_A_User>().Find(employee.UserID);
if (user == null)
{
fo.EmployeeAddToUser(employee, FormsAuthentication.HashPasswordForStoringInConfigFile(employee.Code.ToLower(), "SHA1"));
}
else if (employee.IsDeleted == "0") //Update
{
fo.EmployeeUpdateToUser(employee);
}
else
{
fo.EmployeeDeleteToUser(employee);//Delete
}
}
}
return(Json(JsonAjaxResult.Successful()));
}
public JsonResult AddFile()
{
var mpid = GetQueryString("MpID");
var filename = GetQueryString("FileName");
var wxFO = Formula.FormulaHelper.CreateFO<WxFO>();
foreach (var fn in filename.Split(',').Where(c => !string.IsNullOrEmpty(c)))
{
FsFileInfo fileInfo = masterService.GetFileInfo(fn, WeChatConfig.FileServerName);
var entity = GetEntity<MpMediaVideo>("");
EntityCreateLogic(entity);
entity.IsDelete = 0;
entity.MpID = mpid;
entity.Title = fileInfo.FileName.Substring(fileInfo.FileName.IndexOf('_') + 1);
entity.FileID = fileInfo.FileName;
var mediaid = wxFO.AddVideoFile(mpid, fileInfo.FileFullPath, entity.Title, "");
entity.MediaID = mediaid;
entities.Set<MpMediaVideo>().Add(entity);
}
entities.SaveChanges();
return Json(JsonAjaxResult.Successful());
}
