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()); }