public static AuditMain GetAuditMainById(int id, out string message)
{
message = "";
AuditMain main = new AuditMain();
try
{
main = AuditMainDBOperate.GetAuditMainById(id);
if (main == null)
{
message = "MainNull"; return(null);
}
var list = AuditMainDBOperate.GetAuditDetailList(main.MainId);
var memeberList = CompanyUserDBOperate.GetUserByIds(list.Select(a => a.OperateBy).ToArray());
list.ForEach(a => {
var model = memeberList.FirstOrDefault(b => b.Id == a.OperateBy);
if (model == null)
{
return;
}
a.OperateName = model.Name;
a.OperateHeadUrl = model.WeChatHeadUrl;
});
main.DetailList = list;
}
catch (Exception ex)
{
LogBussiness.AddLog("GetAuditMainById", id + "", ex.Message, Util.LogLevel.Error);
}
return(main);
}
public JsonResult Bind(string openid, string headUrl, string name, string userName)
{
var model = CompanyUserDBOperate.GetModelByName(userName);
model.IsBindWeChat = 1;
model.WeChatOpenId = openid;
model.WeChatHeadUrl = headUrl;
model.WeChatNickName = name;
CompanyUserDBOperate.ModifyCompanyUser(model);
return(Json(new { code = 1 }));
}
//public JsonResult GetMemberInfo()
//{
// var user = CookieOperate.MemberCookie;
// ResultInfo<Dto.CompanyUser> result = new ResultInfo<Dto.CompanyUser>();
// if (user != null) { result.IsSuccess = true; result.Data = user; }
// return Json(result);
//}
public JsonResult MemberList()
{
var list = CompanyUserDBOperate.GetComapnyUserList(CookieOperate.MemberCookie.CompanyId);
ResultInfo <List <CompanyUser> > result = new ResultInfo <List <CompanyUser> >()
{
IsSuccess = true
};
result.Data = list;
return(Json(result));
}
public ActionResult BindWeChat(string openid, string headUrl, string name, string userName)
{
var model = CompanyUserDBOperate.GetModelByName(userName);
//model.IsBindWeChat = 1;
model.WeChatOpenId = openid;
model.WeChatHeadUrl = headUrl;
model.WeChatNickName = name;
//ViewBag.OpenId = openid;
//ViewBag.headUrl = headUrl;
//ViewBag.name = name;
//ViewBag.userName = userName;
return(View(model));
}
/// <summary>
/// 通过手机号登录
/// </summary>
/// <param name="Mobile"></param>
/// <param name="Code"></param>
/// <returns></returns>
public static ResultInfo LoginByMobile(string Mobile, string Code)
{
ResultInfo info = new ResultInfo();
if (!Code.Equals(CommonMethod.MobileVerify))
{
info.Code = "CodeError"; return(info);
}
var user = CompanyUserDBOperate.GetModelByMobile(Mobile);
if (user == null)
{
info.Code = "MemberMobileNotExist"; return(info);
}
var depart = CompanyDepartMentDBOperate.GetDepartMentById(user.DepartId);
user.DepartName = depart.Name;
CookieOperate.MemberCookie = user;
info.IsSuccess = true;
CommonMethod.MobileVerify = "";
return(info);
}
public static bool ImportExcel(DataTable dt, CompanyUser user)
{
try
{
using (SqlBulkCopy sqlBC = new SqlBulkCopy(ConfigSetting.DataConnection))
{
//一次批量的插入的数据量
sqlBC.BatchSize = dt.Rows.Count;
//超时之前操作完成所允许的秒数，如果超时则事务不会提交 ，数据将回滚，所有已复制的行都会从目标表中移除
sqlBC.BulkCopyTimeout = 1800;
//设置要批量写入的表
sqlBC.DestinationTableName = "WorkListItems";
DataTable newDt = new DataTable();
#region 赋值
var objType = typeof(WorkListItems);
PropertyInfo[] properties = objType.GetProperties();
string[] outColName = new string[] { "Id", "ModifyDate", "CanEdit", "ModifyBy", "LevelName", "LevelClass", "StatusName", "StatusClass", "WorkName", "ProjectName" };
foreach (var item in properties)
{
var name = item.Name;
if (outColName.Contains(name))
{
continue;
}
newDt.Columns.Add(new DataColumn()
{
ColumnName = item.Name
});
sqlBC.ColumnMappings.Add(item.Name, item.Name);
}
var itemType = CommonMethod.GetEnumItems <ItemType>();
var itemStatus = CommonMethod.GetEnumItems <ItemStatus>();
var userName = new List <string>();
var workId = new List <int>();
for (int i = 0; i < dt.Rows.Count; i++)
{
var type = dt.Rows[i][6].ToString();
var status = dt.Rows[i][7].ToString();
KeyValuePair <string, string>?typeTxt = itemType.FirstOrDefault(a => a.Value == type);
KeyValuePair <string, string>?statusTxt = itemStatus.FirstOrDefault(a => a.Value == status);
if (!typeTxt.HasValue ||
string.IsNullOrWhiteSpace(typeTxt.Value.Key) ||
!statusTxt.HasValue ||
string.IsNullOrWhiteSpace(statusTxt.Value.Key))
{
continue;
}
DataRow dr = newDt.NewRow();
dr["CompanyId"] = user.CompanyId.ToString();
dr["CompanyName"] = user.CompanyName.ToString();
dr["ProjectId"] = "";
dr["WorkId"] = dt.Rows[i][0];
dr["Name"] = dt.Rows[i][1];
dr["Infos"] = dt.Rows[i][2];
dr["UserName"] = dt.Rows[i][3].ToString() + ",";
dr["Level"] = dt.Rows[i][4].ToString();
dr["DayCount"] = dt.Rows[i][5].ToString();
dr["StartDate"] = DateTime.Now;
dr["EndDate"] = DateTime.Now.AddDays(CommonMethod.GetInt(dr["DayCount"]));
dr["Type"] = typeTxt.Value.Key;
dr["Status"] = statusTxt.Value.Key;
dr["IsDeleted"] = "0";
dr["CreateDate"] = DateTime.Now.ToString();
dr["CreateBy"] = user.UserName;
newDt.Rows.Add(dr);
workId.Add(CommonMethod.GetInt(dt.Rows[i][0]));
userName.AddRange(dr["UserName"].ToString().Split(','));
}
#endregion
var companyList = CompanyUserDBOperate.GetUserByNames(userName.ToArray());
var workList = WorkListDBOperate.GetListByIds(workId.ToArray());
for (int i = 0; i < newDt.Rows.Count; i++)
{
var usrName = newDt.Rows[i]["UserName"].ToString();
var usrs = usrName.Split(',');
var ids = string.Empty;
foreach (var item in usrs)
{
if (string.IsNullOrWhiteSpace(item))
{
continue;
}
ids += companyList.FirstOrDefault(a => a.Name == item).UserName + ",";
}
var wId = CommonMethod.GetInt(newDt.Rows[i]["WorkId"]);
newDt.Rows[i]["UserId"] = ids;
newDt.Rows[i]["ProjectId"] = workList.FirstOrDefault(a => a.Id == wId).ProjectId;
}
//批量写入
if (newDt.Rows.Count != 0 && newDt != null)
{
sqlBC.WriteToServer(newDt);
newDt.Dispose();
}
}
}
catch (Exception ex)
{
string msg = ex.Message;
LogBussiness.AddLog("WorkItemsImport", "", ex.Message, LogLevel.Error);
return(false);
}
return(true);
}
