//同步关注状态
public void TBGZSTATUS(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
try
{
JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptRoot == -1 && d.ComId == UserInfo.User.ComId);
#region 步用户关注状态
WXHelp wx = new WXHelp(UserInfo.QYinfo);
GetDepartmentMemberInfoResult yg = wx.WX_GetDepartmentMemberInfo(branchModel.WXBMCode.Value);
if (yg != null && yg.userlist != null)
{
foreach (var u in yg.userlist)
{
JH_Auth_User user = new JH_Auth_UserB().GetEntity(d => d.ComId == UserInfo.User.ComId && d.UserName == u.userid);
if (user != null && u != null && (u.status == 1 || u.status == 4))
{
user.isgz = u.status.ToString();
new JH_Auth_UserB().Update(user);
}
}
}
}
catch (Exception ex)
{
msg.ErrorMsg = ex.Message;
}
#endregion
}
//同步部门使用
public long WX_CreateBranchTB(JH_Auth_Branch Model)
{
int pid = 0;
var bm = new JH_Auth_BranchB().GetEntity(p => p.DeptCode == Model.DeptRoot && p.ComId == Model.ComId);
if (bm != null)
{
pid = Int32.Parse(bm.WXBMCode.ToString());
}
return(MailListApi.CreateDepartment(GetToken(), Model.DeptName, pid, Model.DeptShort).id);
}
/// <summary>
/// 同步通讯录
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1">初始化密码</param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
#region 企业号相关
/// <summary>
/// 将系统的组织架构同步到微信中去
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void TBBRANCHUSER(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
//判断是否启用微信后，启用部门需要同步添加微信部门
if (UserInfo.QYinfo.IsUseWX == "Y")
{
#region 步部门
//系统部门
List <JH_Auth_Branch> branchList = new JH_Auth_BranchB().GetEntities(d => d.ComId == UserInfo.User.ComId && d.WXBMCode == null).ToList();
WXHelp wx = new WXHelp(UserInfo.QYinfo);
//微信部门
GetDepartmentListResult bmlist = wx.WX_GetBranchList("");
foreach (JH_Auth_Branch branch in branchList)
{
List <DepartmentList> departList = bmlist.department.Where(d => d.name == branch.DeptName).ToList();
WorkJsonResult result = null;
if (departList.Count() > 0)
{
branch.WXBMCode = int.Parse(departList[0].id.ToString());
result = wx.WX_UpdateBranch(branch);
}
else
{
int branchWxCode = int.Parse(wx.WX_CreateBranchTB(branch).ToString());
branch.WXBMCode = branchWxCode;
}
new JH_Auth_BranchB().Update(branch);
}
#endregion
#region 步人员
JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptRoot == -1 && d.ComId == UserInfo.User.ComId);
GetDepartmentMemberInfoResult yg = wx.WX_GetDepartmentMemberInfo(branchModel.WXBMCode.Value);
List <JH_Auth_User> userList = new JH_Auth_UserB().GetEntities(d => d.ComId == UserInfo.User.ComId && d.UserName != "administrator").ToList();
foreach (JH_Auth_User user in userList)
{
if (yg.userlist.Where(d => d.name == user.UserName || d.mobile == user.mobphone).Count() > 0)
{
wx.WX_UpdateUser(user);
}
else
{
wx.WX_CreateUser(user);
}
}
#endregion
}
}
public WorkJsonResult WX_UpdateBranch(JH_Auth_Branch Model)
{
WorkJsonResult Ret = new WorkJsonResult();
if (Qyinfo.IsUseWX == "Y")
{
int pid = 0;
var bm = new JH_Auth_BranchB().GetEntity(p => p.DeptCode == Model.DeptRoot && p.ComId == Model.ComId);
if (bm != null)
{
pid = Int32.Parse(bm.WXBMCode.ToString());
}
Ret = MailListApi.UpdateDepartment(GetToken(), long.Parse(Model.WXBMCode.ToString()), Model.DeptName, pid, Model.DeptShort);
}
return(Ret);
}
/// <summary>
/// 根据部门编号获取部门人员(基本设置列表)
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="strUserName"></param>
public void GETUSERJBSZLIST(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int deptCode = 0;
int.TryParse(P1, out deptCode);
JH_Auth_Branch branch = new JH_Auth_BranchB().GetBMByDeptCode(UserInfo.QYinfo.ComId, deptCode);
if (branch == null)
{
msg.ErrorMsg = "数据异常";
}
string strQXWhere = string.Format("And ( u.branchCode={0} or b.Remark1 like '{1}%')", deptCode, (branch.Remark1 == "" ? "" : branch.Remark1 + "-") + branch.DeptCode);
string branchqx = new JH_Auth_BranchB().GetBranchQX(UserInfo);
if (branch.DeptRoot == -1 && !string.IsNullOrEmpty(branchqx))
{
strQXWhere = " And (";
int i = 0;
foreach (int dept in branchqx.SplitTOInt(','))
{
JH_Auth_Branch branchQX = new JH_Auth_BranchB().GetBMByDeptCode(UserInfo.QYinfo.ComId, dept);
strQXWhere += string.Format((i == 0 ? "" : "And") + " ( u.branchCode!={0} And b.Remark1 NOT like '{1}%')", dept, (branchQX.Remark1 == "" ? "" : branchQX.Remark1 + "-") + branchQX.DeptCode);
i++;
}
strQXWhere += ")";
}
string tableName = " JH_Auth_User u inner join JH_Auth_Branch b on u.branchCode=b.DeptCode left join SZHL_GZGL_JCSZ z on u.UserName=z.UserName and u.ComId=z.ComId ";
string tableColumn = " z.*,u.ID as uid,u.UserName as un,u.UserRealName,u.mobphone,b.DeptName,b.DeptCode";
string strWhere = string.Format("u.ComId={0} {1}", UserInfo.User.ComId, strQXWhere);
if (P2 != "")
{
strWhere += string.Format(" And (u.UserName like '%{0}%' or u.UserRealName like '%{0}%' or b.DeptName like '%{0}%' or u.mobphone like '%{0}%' ) ", P2);
}
int page = 0;
int pagecount = 8;
int.TryParse(context.Request("p") ?? "0", out page);
int.TryParse(context.Request("pagecount") ?? "8", out pagecount);//页数
page = page == 0 ? 1 : page;
int total = 0;
DataTable dt = new JH_Auth_UserB().GetDataPager(tableName, tableColumn, pagecount, page, " DeptShort ,UserOrder asc", strWhere, ref total);
msg.Result = dt;
msg.Result1 = total;
}
/// <summary>
/// 岗位/部门列表，并包含资产数量
/// </summary>
public void GETALLGWBYBRANCHCODE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string where = "";
if (!string.IsNullOrEmpty(P2))
{
where += " and z.TypeID='" + P2 + "' ";
}
string status = context.Request["status"] ?? "";
if (!string.IsNullOrEmpty(status))
{
where += string.Format(" And z.Status='{0}' ", status);
}
DataTable dt = new JH_Auth_BranchB().GetDTByCommand("select distinct(UserGW),(select COUNT(0) from dbo.SZHL_ZCGL z where z.IsDel=0 and z.UserGW=u.UserGW " + where + ") as ZCNum from JH_Auth_User u where branchcode='" + P1 + "' and IsUse ='Y' and (select COUNT(0) from dbo.SZHL_ZCGL z where z.IsDel=0 and z.UserGW=u.UserGW " + where + ")>0 order by UserGW");
msg.Result = dt;
}
/// <summary>
/// 从企业微信同步到系统里
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void TBTXL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
try
{
int bmcount = 0;
int rycount = 0;
if (P1 == "")
{
msg.ErrorMsg = "请输入初始密码";
return;
}
WXHelp wx = new WXHelp(UserInfo.QYinfo);
#region 更新部门
GetDepartmentListResult bmlist = wx.WX_GetBranchList("");
foreach (var wxbm in bmlist.department.OrderBy(d => d.parentid))
{
var bm = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == wxbm.id);
if (bm == null)
{
#region 新增部门
JH_Auth_Branch jab = new JH_Auth_Branch();
jab.WXBMCode = int.Parse(wxbm.id.ToString());
jab.ComId = UserInfo.User.ComId;
jab.DeptName = wxbm.name;
jab.DeptDesc = wxbm.name;
jab.DeptShort = int.Parse(wxbm.order.ToString());
if (wxbm.parentid == 0)//如果是跟部门,设置其跟部门为-1
{
jab.DeptRoot = -1;
}
else
{
var bm1 = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == wxbm.parentid);
jab.DeptRoot = bm1.DeptCode;
jab.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, jab.DeptRoot);
}
new JH_Auth_BranchB().Insert(jab);
jab.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, jab.DeptRoot) + jab.DeptCode;
new JH_Auth_BranchB().Update(jab);
bmcount = bmcount + 1;
#endregion
}
else
{
//同步部门时放弃更新现有部门
}
}
#endregion
#region 更新人员
JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptRoot == -1 && d.ComId == UserInfo.User.ComId);
GetDepartmentMemberInfoResult yg = wx.WX_GetDepartmentMemberInfo(branchModel.WXBMCode.Value);
foreach (var u in yg.userlist)
{
var user = new JH_Auth_UserB().GetUserByUserName(UserInfo.QYinfo.ComId, u.userid);
if (user == null)
{
#region 新增人员
JH_Auth_User jau = new JH_Auth_User();
jau.ComId = UserInfo.User.ComId;
jau.UserName = u.userid;
jau.UserPass = CommonHelp.GetMD5(P1);
jau.UserRealName = u.name;
jau.Sex = u.gender == 1 ? "男" : "女";
if (u.department.Length > 0)
{
int id = int.Parse(u.department[0].ToString());
var bm1 = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == id);
jau.BranchCode = bm1.DeptCode;
jau.remark = bm1.Remark1.Split('-')[0];//用户得部门路径
}
jau.mailbox = u.email;
jau.mobphone = u.mobile;
jau.zhiwu = string.IsNullOrEmpty(u.position) ? "员工" : u.position;
jau.IsUse = "Y";
if (u.status == 1 || u.status == 4)
{
jau.isgz = u.status.ToString();
}
jau.txurl = u.avatar;
new JH_Auth_UserB().Insert(jau);
rycount = rycount + 1;
#endregion
//为所有人增加普通员工的权限
JH_Auth_Role rdefault = new JH_Auth_RoleB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.isSysRole == "Y" && p.RoleName == "员工");//找到默认角色
if (rdefault != null)
{
JH_Auth_UserRole jaurdefault = new JH_Auth_UserRole();
jaurdefault.ComId = UserInfo.User.ComId;
jaurdefault.RoleCode = rdefault.RoleCode;
jaurdefault.UserName = jau.UserName;
new JH_Auth_UserRoleB().Insert(jaurdefault);
}
}
else
{
//同步人员时放弃更新现有人员
#region 更新人员
user.UserRealName = u.name;
if (u.department.Length > 0)
{
int id = int.Parse(u.department[0].ToString());
var bm1 = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == id);
user.BranchCode = bm1.DeptCode;
}
user.mailbox = u.email;
user.mobphone = u.mobile;
user.zhiwu = string.IsNullOrEmpty(u.position) ? "员工" : u.position;
user.Sex = u.gender == 1 ? "男" : "女";
if (u.status == 1 || u.status == 4)
{
user.IsUse = "Y";
user.isgz = u.status.ToString();
}
else if (u.status == 2)
{
user.IsUse = "N";
}
user.txurl = u.avatar;
new JH_Auth_UserB().Update(user);
#endregion
}
#region 更新角色(职务)
if (!string.IsNullOrEmpty(u.position))
{
var r = new JH_Auth_RoleB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.RoleName == u.position);
if (r == null)
{
JH_Auth_Role jar = new JH_Auth_Role();
jar.ComId = UserInfo.User.ComId;
jar.RoleName = u.position;
jar.RoleDec = u.position;
jar.PRoleCode = 0;
jar.isSysRole = "N";
jar.IsUse = "Y";
jar.leve = 0;
jar.DisplayOrder = 0;
new JH_Auth_RoleB().Insert(jar);
JH_Auth_UserRole jaur = new JH_Auth_UserRole();
jaur.ComId = UserInfo.User.ComId;
jaur.RoleCode = jar.RoleCode;
jaur.UserName = u.userid;
new JH_Auth_UserRoleB().Insert(jaur);
}
else
{
}
}
#endregion
}
#endregion
msg.Result1 = bmcount;
msg.Result2 = rycount;
}
catch (Exception ex)
{
msg.ErrorMsg = ex.ToString();
}
}
public void SAVEIMPORTUSER(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string branchMsg = "", branchErrorMsg = "", userMsg = "";
int i = 0, j = 0;
DataTable dt = new DataTable();
dt = JsonConvert.DeserializeObject <DataTable>(P1);
dt.Columns.Add("BranchCode");
JH_Auth_Branch branchroot = new JH_Auth_BranchB().GetEntity(d => d.ComId == UserInfo.User.ComId && d.DeptRoot == -1);
foreach (DataRow row in dt.Rows)
{
int bRootid = branchroot.DeptCode;
string branchName = row[4].ToString();
if (branchName != "")
{
string[] branchNames = branchName.Split('/');
string strBranch = branchNames[0];
JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptName == strBranch && d.ComId == UserInfo.User.ComId);
if (branchModel == null)
{
branchModel = new JH_Auth_Branch();
branchModel.DeptName = branchNames[0];
branchModel.DeptDesc = branchNames[0];
branchModel.ComId = UserInfo.User.ComId;
branchModel.DeptRoot = bRootid;
branchModel.CRDate = DateTime.Now;
branchModel.CRUser = UserInfo.User.UserName;
new JH_Auth_BranchB().Insert(branchModel);
branchModel.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, branchModel.DeptRoot) + branchModel.DeptCode;
new JH_Auth_BranchB().Update(branchModel);
}
}
}
int rowIndex = 0;
foreach (DataRow row in dt.Rows)
{
rowIndex++;
string branchName = row[4].ToString();
if (branchName != "")
{
string[] branchNames = branchName.Split('/');
string strPBranch = branchNames[0];
JH_Auth_Branch PbranchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptName == strPBranch && d.ComId == UserInfo.User.ComId);
int bRootid = PbranchModel.DeptCode;
for (int l = 1; l < branchNames.Length; l++)
{
string strBranch = branchNames[1];
JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptName == strBranch && d.DeptRoot == PbranchModel.DeptCode && d.ComId == UserInfo.User.ComId);
if (branchModel != null)
{
bRootid = branchModel.DeptCode;
if (l == branchNames.Length - 1)
{
row["BranchCode"] = branchModel.DeptCode;
}
}
else
{
branchModel = new JH_Auth_Branch();
branchModel.DeptName = strBranch;
branchModel.DeptDesc = strBranch;
branchModel.ComId = UserInfo.User.ComId;
branchModel.DeptRoot = bRootid;
branchModel.CRDate = DateTime.Now;
branchModel.CRUser = UserInfo.User.UserName;
new JH_Auth_BranchB().Insert(branchModel);
branchModel.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, branchModel.DeptRoot) + branchModel.DeptCode;
new JH_Auth_BranchB().Update(branchModel);
try
{
bRootid = branchModel.DeptCode;
if (l == branchNames.Length - 1)
{
row["BranchCode"] = branchModel.DeptCode;
}
i++;
branchMsg += "新增部门“" + strBranch + "”成功<br/>";
}
catch (Exception ex)
{
branchErrorMsg += "部门：" + strBranch + "失败 " + msg.ErrorMsg + "<br/>";
}
}
}
string userName = row[2].ToString();
JH_Auth_User userModel = new JH_Auth_UserB().GetEntity(d => d.UserName == userName && d.ComId == UserInfo.User.ComId);
if (userModel == null)
{
JH_Auth_User userNew = new JH_Auth_User();
if (row["BranchCode"].ToString() != "")
{
int tempcode = int.Parse(row["BranchCode"].ToString());
JH_Auth_Branch branchTemp = new JH_Auth_BranchB().GetEntity(d => d.DeptCode == tempcode && d.ComId == UserInfo.User.ComId);
userNew.BranchCode = branchTemp.DeptCode;
userNew.remark = branchTemp.Remark1.Split('-')[0];
}
else
{
userNew.BranchCode = bRootid;
}
userNew.ComId = UserInfo.User.ComId;
userNew.IsUse = "Y";
userNew.mailbox = row[3].ToString();
userNew.mobphone = row[2].ToString();
userNew.RoomCode = row[7].ToString();
userNew.Sex = row[1].ToString();
userNew.telphone = row[9].ToString();
DateTime result;
if (DateTime.TryParse(row[10].ToString(), out result))
{
userNew.Birthday = result;
}
userNew.UserGW = row[6].ToString();
userNew.UserName = row[2].ToString();
userNew.UserRealName = row[0].ToString();
userNew.zhiwu = row[5].ToString() == "" ? "员工" : row[5].ToString();
userNew.UserPass = CommonHelp.GetMD5(P2);
userNew.CRDate = DateTime.Now;
userNew.CRUser = UserInfo.User.UserName;
if (!string.IsNullOrEmpty(row[8].ToString()))
{
int orderNum = 0;
int.TryParse(row[8].ToString(), out orderNum);
userNew.UserOrder = orderNum;
}
try
{
msg.ErrorMsg = "";
if (string.IsNullOrEmpty(userNew.UserName))
{
msg.ErrorMsg = "用户名必填";
}
//Regex regexPhone = new Regex("^0?1[3|4|5|8|7][0-9]\\d{8}$");
//if (!regexPhone.IsMatch(userNew.UserName))
//{
// msg.ErrorMsg = "用户名必须为手机号";
//}
if (string.IsNullOrEmpty(userNew.mobphone))
{
msg.ErrorMsg = "手机号必填";
}
//if (!regexPhone.IsMatch(userNew.mobphone))
//{
// msg.ErrorMsg = "手机号填写不正确";
//}
Regex regexOrder = new Regex("^[0-9]*$");
if (userNew.UserOrder != null && !regexOrder.IsMatch(userNew.UserOrder.ToString()))
{
msg.ErrorMsg = "序号必须是数字";
}
if (msg.ErrorMsg != "")
{
userMsg += "第" + rowIndex + "行" + msg.ErrorMsg + "<br/>";
}
if (msg.ErrorMsg == "")
{
new JH_Auth_UserB().Insert(userNew);
JH_Auth_Role role = new JH_Auth_RoleB().GetEntity(d => d.RoleName == userNew.zhiwu && d.ComId == UserInfo.User.ComId);
if (role == null)
{
role = new JH_Auth_Role();
role.PRoleCode = 0;
role.RoleName = userNew.zhiwu;
role.RoleDec = userNew.zhiwu;
role.IsUse = "Y";
role.isSysRole = "N";
role.leve = 0;
role.ComId = UserInfo.User.ComId;
role.DisplayOrder = 0;
new JH_Auth_RoleB().Insert(role);
}
string strSql = string.Format("INSERT into JH_Auth_UserRole (UserName,RoleCode,ComId) Values('{0}',{1},{2})", userNew.UserName, role.RoleCode, UserInfo.User.ComId);
new JH_Auth_RoleB().ExsSql(strSql);
string isFS = context.Request["issend"] ?? "";
if (isFS.ToLower() == "true")
{
string content = string.Format("尊敬的" + userNew.UserName + "用户您好：你已被添加到" + UserInfo.QYinfo.QYName + ",账号：" + userNew.mobphone + "，密码" + P2 + ",登录请访问" + UserInfo.QYinfo.WXUrl);
new SZHL_DXGLB().SendSMS(userNew.mobphone, content, userNew.ComId.Value);
}
j++;
}
}
catch (Exception ex)
{
userMsg += "第" + rowIndex + "行" + msg.ErrorMsg + "<br/>";
}
}
else
{
userMsg += "第" + rowIndex + "行" + "用户“" + row[2].ToString() + "”已存在<br/>";
}
}
else
{
branchErrorMsg += "第" + rowIndex + "行所在部门必填<br/>";
}
}
msg.Result = branchErrorMsg + "<br/>" + userMsg;
msg.Result1 = "新增部门" + i + "个,新增用户" + j + "个<br/>" + branchMsg + (branchMsg == "" ? "" : "<br/>");
}
/// <summary>
/// 发放工资条
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void FFXZ(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
if (string.IsNullOrWhiteSpace(P1))
{
msg.ErrorMsg = "发送失败";
return;
}
string taitou = context.Request["taitou"] ?? "";
string luokuan = context.Request["luokuan"] ?? "";
string ffdx = context.Request["ffdx"] ?? "";
string ffwx = context.Request["ffwx"] ?? "";
string ym = context.Request["ym"] ?? "";
SZHL_XZ_JL xzjj = new SZHL_XZ_JL();
xzjj.YearMonth = ym;
xzjj.title = P2;
xzjj.rise = taitou;
xzjj.Inscribe = luokuan;
xzjj.ComId = UserInfo.User.ComId;
xzjj.CRDate = DateTime.Now;
xzjj.CRUser = UserInfo.User.UserName;
xzjj.salaryData = P1;
new SZHL_XZ_JLB().Insert(xzjj);
//string shibaiuser = "";
#region 工资单
List <JObject> xxb = JsonConvert.DeserializeObject <List <JObject> >(P1);
foreach (var a in xxb)
{
bool bl = false;
string username = a["姓名"] != null ? a["姓名"].ToString().Trim() : "";
string bmname = a["部门"] != null ? a["部门"].ToString().Trim() : "";
string tel = a["手机"] != null ? a["手机"].ToString().Trim() : "";
SZHL_XZ_GZD gzd = new SZHL_XZ_GZD();
gzd.ComId = UserInfo.User.ComId;
gzd.CRUser = UserInfo.User.UserName;
gzd.CRDate = DateTime.Now;
gzd.YearMonth = ym;
gzd.Telephone = tel;
gzd.salaryData = a.ToString();
gzd.title = P2;
gzd.rise = taitou;
gzd.Inscribe = luokuan;
gzd.IsRead = 0;
gzd.UserRealName = username;
gzd.BranchName = bmname;
JH_Auth_User user = new JH_Auth_UserB().GetEntity(d => d.ComId == UserInfo.User.ComId && d.mobphone == tel);
if (user != null)
{
gzd.UserName = user.UserName;
var bm = new JH_Auth_BranchB().GetEntity(d => d.ComId == UserInfo.User.ComId && d.DeptCode == user.BranchCode);
if (bm != null && bm.DeptName == bmname)
{
gzd.BranchCode = bm.DeptCode;
}
bl = true;
}
new SZHL_XZ_GZDB().Insert(gzd);
if (ffwx == "1" && tel != "" && bl)
{
SZHL_TXSX CSTX = new SZHL_TXSX();
CSTX.Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
CSTX.APIName = "XZGL";
CSTX.ComId = UserInfo.User.ComId;
CSTX.FunName = "SENDXZMSG";
CSTX.CRUserRealName = UserInfo.User.UserRealName;
CSTX.MsgID = gzd.ID.ToString();
CSTX.TXContent = taitou;
CSTX.ISCS = "N";
CSTX.TXUser = user.UserName;
CSTX.TXMode = "XZFF";
CSTX.CRUser = UserInfo.User.UserName;
TXSX.TXSXAPI.AddALERT(CSTX); //时间为发送时间
}
if (ffdx == "1" && tel != "")
{
string hj = a["合计"] != null ? a["合计"].ToString().Trim() : "";
CommonHelp.SendSMS(tel, username + "，" + taitou + "，" + "合计：" + hj + "元.点击" + UserInfo.QYinfo.WXUrl.TrimEnd('/') + "/View_Mobile/UI/UI_GZD_VIEW.html?ID=" + gzd.ID + " 查看详情", UserInfo.QYinfo.ComId);
}
}
#endregion
//msg.Result = shibaiuser.TrimEnd(',');
}
