public static string AddTree(Dictionary <string, string> dict)
{
string res = UserInfoSrv.AddTree(dict);
SqlExceRes sqlRes = new SqlExceRes(res);
return(sqlRes.GetResultString("新建成功", "部门名称有重复，请重新输入"));
}
public static string InsertInfos(DataTable dt)
{
dt.Columns.Remove("序号");
dt.Columns.Remove("工龄");
dt.Columns.Remove("年龄");
dt.Columns.Remove("部门");
dt.Columns["工号"].ColumnName = "employeeCode";
dt.Columns["姓名"].ColumnName = "userName";
dt.Columns["性别"].ColumnName = "sex";
//dt.Columns["部门"].ColumnName = "department";
dt.Columns["岗位"].ColumnName = "post";
dt.Columns["入职日期"].ColumnName = "hiredate";
dt.Columns["转正日期"].ColumnName = "regularEmployeeDate";
dt.Columns["状态"].ColumnName = "isValid";
dt.Columns["毕业学校"].ColumnName = "graduationSchool";
dt.Columns["专业"].ColumnName = "major";
dt.Columns["学历"].ColumnName = "education";
dt.Columns["手机号码"].ColumnName = "mobilePhone";
dt.Columns["私人邮箱"].ColumnName = "email";
dt.Columns["企业QQ"].ColumnName = "enterpriseQQ";
dt.Columns["企业邮箱"].ColumnName = "enterpriseEmail";
dt.Columns["银行开户行"].ColumnName = "bank";
dt.Columns["账号"].ColumnName = "bankAccount";
dt.Columns["身份证号"].ColumnName = "idNumber";
dt.Columns["出生日期"].ColumnName = "birthday";
dt.Columns["家庭住址"].ColumnName = "address";
dt.Columns["紧急联络人"].ColumnName = "emergencyContact";
dt.Columns["紧急联络人电话"].ColumnName = "emergencyContactNumber";
dt.Columns["社保个人编号"].ColumnName = "socialSecurityNumber";
return(UserInfoSrv.InsertInfos(dt));
}
public static string UpdateInfos(Dictionary <string, string> dict, string id)
{
string res = UserInfoSrv.UpdateInfos(dict, id);
SqlExceRes sqlRes = new SqlExceRes(res);
return(sqlRes.GetResultString("修改成功", ""));
}
public static DataSet getUserTree(string range)
{
UserInfo user = (UserInfo)HttpContext.Current.Session["user"];
DataSet ds = UserInfoSrv.getInfos(user.companyId.ToString(), range);
return(ds);
}
public static DataSet getInfos(Dictionary <string, string> dict)
{
UserInfo user = (UserInfo)HttpContext.Current.Session["user"];
DataSet ds = UserInfoSrv.getInfos(user.companyId.ToString(), dict);
return(ds);
}
public static string Delete(string id)
{
string res = UserInfoSrv.Delete(id);
SqlExceRes sqlRes = new SqlExceRes(res);
return(sqlRes.GetResultString("操作成功", ""));
}
public static string CookieLogin(ref UserInfo user, string token)
{
//user.passWord = SqlHelper.Split(user.passWord);
//user.userName = SqlHelper.Split(user.userName);
//user.mobilePhone = SqlHelper.Split(user.mobilePhone);
//string res = UserInfoSrv.Login(ref user,ref token);
//user.passWord = "******";//隐藏真实密码
string res = "";
//user = null;
DataSet ds = UserInfoSrv.GetToken(token, user.userName);
if (ds == null || ds.Tables[0].Rows.Count == 0 || ds.Tables[1].Rows.Count == 0)
{
return(res);
}
DateTime dtDb = Convert.ToDateTime(ds.Tables[0].Rows[0]["LoginTime"]).AddDays(7);
if (dtDb.CompareTo(DateTime.Now) > -1)//时间在有效范围内
{
user = ModelHandler <UserInfo> .FillModel(ds.Tables[1].Rows[0]);
//user.passWord = "******";//隐藏真实密码
if (user.userId == Convert.ToInt32(ds.Tables[0].Rows[0]["UserId"]))//用户ID与token相互匹配
{
res = "登录成功";
}
}
return(res);
}
public static string Login(ref UserInfo user, ref string token)
{
AntiInjectionAttack(ref user);
string res = UserInfoSrv.Login(ref user, ref token);
//user.passWord = "******";//隐藏真实密码
return(res);
}
public static string ModifyPassword(ref UserInfo user)
{
user.passWord = SqlHelper.MD5((user.passWord));
string res = UserInfoSrv.ModifyPassword(ref user);
//user.passWord = "******";//隐藏真实密码
return(res);
}
public static DataSet GetMembers(UserInfo user)
{
DataSet ds = UserInfoSrv.GetMembers(user);
if (ds == null)
{
return(null);
}
ds.Tables[0].Columns.Remove("passWord");
return(ds);
}
public static List <DepartmentPost> GetDepartmentPostList(UserInfo user)
{
DataSet ds = UserInfoSrv.GetDepartmentPostList(user);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
return(null);
}
//List<DepartmentPost> list = new List<DepartmentPost>();
//foreach(DataRow row in ds.Tables[0].Rows)
//{
// DepartmentPost dp = new DepartmentPost();
// dp = ModelHandler<DepartmentPost>.FillModel(row);
//}
List <DepartmentPost> list = ModelHandler <DepartmentPost> .FillModel(ds.Tables[0]);
return(list);
}
public static string SaveDepartmentFromWx(object json)
{
//去掉所有回车换行符
//json = json.Replace('\r', (char)0);
//json = json.Replace('\n', (char)0);
JArray listSrc = (JArray)(json);
ArrayList listDst = new ArrayList();
foreach (JObject val in listSrc)
{
//Dictionary<string, object> dict = (Dictionary < string, object> )val;
Dictionary <string, string> newDict = new Dictionary <string, string>();
//newDict.Add("Id", dict["id"].ToString());
//newDict.Add("name", dict["name"].ToString());
//newDict.Add("parentId", dict["parentid"].ToString());
//newDict.Add("companyId", "1");
//newDict.Add("state", "启用");
//newDict.Add("order", dict["order"].ToString());
string name = val["name"].ToString();
int i = Convert.ToInt32(val["parentid"]);
while (i > 0)
{
foreach (JObject j in listSrc)
{
if (i == Convert.ToInt32(j["id"]))
{
name = j["name"].ToString() + "/" + name;
i = Convert.ToInt32(j["parentid"]);
break;
}
}
}
newDict.Add("Id", val["id"].ToString());
newDict.Add("name", name);
newDict.Add("parentId", val["parentid"].ToString());
newDict.Add("companyId", "1");
newDict.Add("state", "启用");
newDict.Add("orderForSameParent", val["order"].ToString());
listDst.Add(newDict);
}
return(UserInfoSrv.SaveDepartmentFromWx(listDst));
}
public static DataTable getInfos(string companyId, string departId, string searchString)
{
DataSet ds = null;
if (string.IsNullOrEmpty(departId))
{
ds = UserInfoSrv.getInfos(companyId);
}
else
{
ds = UserInfoSrv.getInfos(companyId, departId);
}
DataTable dt = null;
if (ds != null)
{
DataTable dtUsing = UserInfoProcess(ds);
if (string.IsNullOrEmpty(searchString))//搜索字符为空时，不搜索，直接返回
{
return(dtUsing);
}
else
{
dt = dtUsing.Clone();
foreach (DataRow row in dtUsing.Rows)
{
if (row["employeeCode"].ToString().Trim().Contains(searchString) ||
PinYinHelper.IsEqual(row["userName"].ToString(), searchString)
//|| PinYinHelper.IsEqual(row["fullName"].ToString(), searchString)
|| row["userName"].ToString().Trim().Contains(searchString)
//|| row["fullName"].ToString().Trim().Contains(searchString))
)
{
//row["passWord"] = "******";
dt.Rows.Add(row.ItemArray);
dt.Rows[dt.Rows.Count - 1]["passWord"] = "******";
continue;
}
}
}
}
ClearMemory.Clear(ds);
return(dt);
}
public static string InsertInfos(Dictionary <string, string> dict)
{
string res = UserInfoSrv.InsertInfos(dict);
string[] strs1 = res.Split(':');
string[] strs2 = strs1[1].Split(',');
if (strs2[1].Contains("操作成功") && Convert.ToInt32(strs2[0]) > 0)
{
res = "新建成功";
}
else if (strs2[1].Contains("操作成功") && Convert.ToInt32(strs2[0]) == 0)
{
res = "人员名称已存在，请重新输入!";
}
else
{
res = strs2[1];
}
return(res);
}
public static string SaveUserInfoFromWx(object json)
{
JArray listSrc = (JArray)(json);
ArrayList listUser = new ArrayList();
foreach (JObject val in listSrc)
{
UserAndDepartmentInfo userDpt = new UserAndDepartmentInfo();
userDpt.UserInfo = new Dictionary <string, string>();
userDpt.UserInfo.Add("wechatUserId", val["userid"].ToString());
userDpt.UserInfo.Add("userName", val["name"].ToString());
userDpt.UserInfo.Add("mobilePhone", val["mobile"].ToString());
userDpt.UserInfo.Add("companyId", "1");
userDpt.UserInfo.Add("isValid", "在职");
if (val["gender"].ToString() == "1")
{
userDpt.UserInfo.Add("sex", "男");
}
else if (val["gender"].ToString() == "2")
{
userDpt.UserInfo.Add("sex", "女");
}
userDpt.UserInfo.Add("post", val["position"].ToString());
userDpt.UserInfo.Add("avatar", val["avatar"].ToString());
//newDict.Add("departmentId", SqlHelper.ToMultiData(val["department"]));
userDpt.DepartmentPost = new ArrayList();
JArray list = (JArray)(val["department"]);
foreach (int jVal in list)
{
Dictionary <string, string> dictDepart = new Dictionary <string, string>();
dictDepart.Add("wechatUserId", val["userid"].ToString());
dictDepart.Add("departmentId", jVal.ToString());
dictDepart.Add("postId", "71");//默认正式员工
dictDepart.Add("isHead", val["isleader"].ToString());
userDpt.DepartmentPost.Add(dictDepart);
}
listUser.Add(userDpt);
}
return(UserInfoSrv.SaveUserInfoFromWx(listUser));
}
public static DataTable GetAllUsers()
{
DataSet ds = UserInfoSrv.GetAllUsers();
DataTable dt = null;
if (ds != null)
{
dt = ds.Tables[0].Copy();
dt.Columns.Add("HanZiPinYinSortColumn");
for (int i = 0; i < dt.Rows.Count; i++)
{
string tempStr = PinYinHelper.getPinyin(dt.Rows[i]["userName"].ToString());
dt.Rows[i]["HanZiPinYinSortColumn"] = StringTools.JustKeepLetters(tempStr);
}
DataView dv = dt.DefaultView;
dv.Sort = "HanZiPinYinSortColumn asc";
return(dv.ToTable());
}
else
{
return(dt);
}
}
/// <summary>
/// 保存草稿
/// </summary>
/// <param name="emailId">邮件ID</param>
/// <param name="subject">邮件主题</param>
/// <param name="text">邮件正文</param>
/// <param name="recipients">收件人</param>
/// <returns></returns>
public static string SaveDraft(string emailId, string subject, string text
, string[] recipients)
{
JObject res = new JObject();
if (string.IsNullOrEmpty(emailId))
{
res.Add("ErrCode", 1);
res.Add("ErrMsg", "参数缺少");
return(res.ToString());
}
List <string> sqlList = new List <string>();
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("Subject", subject);
dict.Add("Text", text);
dict.Add("LMT", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sqlList.Add(SqlHelper.GetUpdateString(dict, "yl_email", string.Format(" where Id={0}", emailId)));
if (recipients.Length > 0)
{
sqlList.Add(string.Format("delete from yl_email_recipient where EmailId={0}", emailId));
ArrayList list = new ArrayList();
foreach (string recpient in recipients)
{
if (string.IsNullOrEmpty(recpient))
{
continue;
}
if (recpient.Length <= 5)
{
DataSet ds = UserInfoSrv.getInfos("1", recpient);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataTable dt in ds.Tables)
{
foreach (DataRow row in dt.Rows)
{
Boolean flag = true;
foreach (Dictionary <string, string> dc in list)
{
if (dc["UserId"].ToString() == row["userId"].ToString())
{
flag = false;
break;
}
}
if (flag)
{
dict = new Dictionary <string, string>();
dict.Add("EmailId", emailId);
dict.Add("UserId", row["userId"].ToString());
list.Add(dict);
sqlList.Add(string.Format("insert into `yl_email_recipient` (userid,emailId) values" +
" ((select t.wechatUserId from users t where userId = '{0}'),'{1}');", row["userId"].ToString(), emailId));
}
}
}
}
else if (ds == null)
{
res.Add("ErrCode", 1);
res.Add("ErrMsg", "连接数据库出现问题");
return(res.ToString());
}
}
else if (recpient.Length <= 8)
{
int id = (Convert.ToInt32(recpient) - 1000000) / 1000;
DataSet ds = SqlHelper.Find("select GroupMember from yl_email_group where Id=" + id);
JArray GroupJarray = JArray.Parse(ds.Tables[0].Rows[0][0].ToString());
foreach (JObject jobject in GroupJarray)
{
Boolean flag = true;
foreach (Dictionary <string, string> dc in list)
{
if (dc["UserId"].ToString() == jobject["UserId"].ToString())
{
flag = false;
break;
}
}
if (flag)
{
dict = new Dictionary <string, string>();
dict.Add("EmailId", emailId);
dict.Add("UserId", jobject["UserId"].ToString());
list.Add(dict);
sqlList.Add(string.Format("insert into `yl_email_recipient` (userid,emailId) values" +
" ((select t.wechatUserId from users t where userId = '{0}'),'{1}');", jobject["UserId"].ToString(), emailId));
}
}
}
else
{
Boolean flag = true;
foreach (Dictionary <string, string> dc in list)
{
if (dc["UserId"].ToString() == recpient)
{
flag = false;
break;
}
}
if (flag)
{
dict = new Dictionary <string, string>();
dict.Add("EmailId", emailId);
dict.Add("UserId", recpient);
list.Add(dict);
sqlList.Add(string.Format("insert into `yl_email_recipient` (userid,emailId) values" +
" ((select t.wechatUserId from users t where userId = '{0}'),'{1}');", recpient, emailId));
}
}
}
}
SqlExceRes r = new SqlExceRes(SqlHelper.Exce(sqlList.ToArray()));
if (r.Result == SqlExceRes.ResState.Success)
{
res.Add("ErrCode", "0");
res.Add("ErrMsg", "操作成功");
}
else
{
res.Add("ErrCode", 1);
res.Add("ErrMsg", r.ExceMsg);
}
return(res.ToString());
}
public static UserInfo GetUserInfo(string wechatUserId, ref string msg)
{
return(UserInfoSrv.GetUserInfo(wechatUserId, ref msg));
}
public static string DeleteDepartPost(string id)
{
return(UserInfoSrv.DeleteDepartPost(id));
}
public static string UpdateDepartPost(Dictionary <string, string> dict, string id)
{
return(UserInfoSrv.UpdateDepartPost(dict, id));
}
public static string InsertDepartPost(Dictionary <string, string> dict)
{
return(UserInfoSrv.InsertDepartPost(dict));
}
public static DataSet GetSelectedTree(string wechatUserId)
{
return(UserInfoSrv.GetSelectedTree(wechatUserId));
}
public static DataSet getTree(string companyId)
{
return(UserInfoSrv.getTree(companyId));
}
public static DataSet CheckInfo(string code, string company, string mobile, string idNubmer)
{
return(UserInfoSrv.CheckInfo(code, company, mobile, idNubmer));
}
public static object CheckEmployeeCode(string code, string company)
{
return(UserInfoSrv.CheckEmployeeCode(code, company));
}
public static object CheckMobile(string mobile)
{
return(UserInfoSrv.CheckMobile(mobile));
}
public static DataSet GetUserDepartment()
{
return(UserInfoSrv.GetUserDepartment());
}
public static string GetDepartRemark(string companyId, string id)
{
return(UserInfoSrv.GetDepartRemark(companyId, id));
}
private string getData()
{
string sector = Request.Form["sector"];
// 区分是财务部还是人事部
//UserInfo user = (UserInfo)Session["user"];
UserInfo user = (UserInfo)Session["user"];
DataSet ds = UserInfoSrv.GetDepartmentPostList(user);
JArray jArray = new JArray();
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows[0]["departmentId"] != null)
{
int departmentId = Int32.Parse(ds.Tables[0].Rows[0]["departmentId"].ToString());
DateTime time = DateTime.Now;
DataTable table = ItemSettingManage.getData(time.Year, time.Month, sector);
// 如果是财务部
if (departmentId == 1)
{
JObject jObject = new JObject();
jObject.Add("index", 1);
jObject.Add("item", "固定资产分摊");
jObject = HandleEmptyJObject(jObject, "FixedAssetsCost", table);
jArray.Add(jObject);
jObject = new JObject();
jObject.Add("index", 2);
jObject.Add("item", "财务费用金额");
jObject = HandleEmptyJObject(jObject, "FinancialCost", table);
jArray.Add(jObject);
jObject = new JObject();
jObject.Add("index", 3);
jObject.Add("item", "研发费用金额");
jObject = HandleEmptyJObject(jObject, "RdCost", table);
jArray.Add(jObject);
jObject = new JObject();
jObject.Add("index", 4);
jObject.Add("item", "总部管理费用");
jObject = HandleEmptyJObject(jObject, "HeadOfficeManageCost", table);
jArray.Add(jObject);
jObject = new JObject();
jObject.Add("index", 5);
jObject.Add("item", "所得税");
jObject = HandleEmptyJObject(jObject, "IncomeTax", table);
jArray.Add(jObject);
jObject = new JObject();
jObject.Add("index", 6);
jObject.Add("item", "增值税");
jObject = HandleEmptyJObject(jObject, "ValueAddedTax", table);
jArray.Add(jObject);
jObject = new JObject();
jObject.Add("index", 7);
jObject.Add("item", "附加税");
jObject = HandleEmptyJObject(jObject, "AdditionalTax", table);
jArray.Add(jObject);
jObject = new JObject();
jObject.Add("index", 8);
jObject.Add("item", "印花税");
jObject = HandleEmptyJObject(jObject, "StampTax", table);
jArray.Add(jObject);
}
// 或者是人事部
else if (departmentId == 101)
{
JObject jObject = new JObject();
jObject.Add("index", 1);
jObject.Add("item", "工资社保金额");
jObject.Add("num", 0);
jArray.Add(jObject);
}
else
{
return("该用户权限不足");
}
}
else
{
return("查询数据为空");
}
return(jArray.ToString());
}
