/// <summary> /// 根据用户的ID得到用户的姓名 /// </summary> /// <param name="userIDS"></param> public static String GetUserNamByIDS(String userIDS) { String result = String.Empty; if (String.IsNullOrEmpty(userIDS) == false) { JUserDA da1 = new JUserDA(); List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("UserID", userIDS, SearchOperator.Collection)); DataTable dt1 = da1.GetListData(condition, -1, -1, "num", "UserName"); bool first = true; StringBuilder str1 = new StringBuilder(); foreach (DataRow dr1 in dt1.Rows) { if (first) { str1.Append(dr1[0].ToString()); first = false; } else { str1.Append(",").Append(dr1[0].ToString()); } } result = str1.ToString(); } return(result); }
//得到列表数据 public DataTable GetListData(List <SearchField> condition, int PageSize, int CurPage, String orderBy, params String[] Fields) { JUserDA da = new JUserDA(); return(da.GetListData(condition, PageSize, CurPage, orderBy, Fields)); }
/// <summary> /// 删除用户数据,同时删除其相关数据 /// 提示:此功能,可能会根据不同的项目重写 /// </summary> /// <param name="AreaCode"></param> public bool DeleteData(String UserID) { bool succ = false; if (String.IsNullOrEmpty(UserID) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("UserID", UserID, SearchOperator.Collection)); JConnect conn1 = JConnect.GetConnect(); conn1.BeginTrans(); try { //JRoleUsersDA da1 = new JRoleUsersDA(conn1); //da1.DeleteData(condition); //JOrgUsersDA da2 = new JOrgUsersDA(conn1); //da2.DeleteData(condition); JUserDA da3 = new JUserDA(); da3.DeleteData(condition); //删除其他的相关业务表 conn1.CommitTrans(); succ = true; } catch (Exception err) { JTool.WriteErrorLog(err.Message); conn1.RollBackTrans(); } } return(succ); }
/// <summary> /// 功能说明:更新密码 /// </summary> /// <param name="oldpass">旧密码</param> /// <param name="newPass">新密码</param> /// <returns></returns> public String ChangeOldPassWord(String UserID, String oldpass, String newPass) { String error = String.Empty; if (String.IsNullOrEmpty(oldpass) == false && String.IsNullOrEmpty(newPass) == false) { JUserDA da1 = new JUserDA(); List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("UserID", UserID)); DataRow dr1 = da1.GetFirstDataRow(condition, "*"); if (dr1 != null) { String pass0 = dr1["password"].ToString().Trim(); String pass1 = oldpass; String pass2 = JString.MD5(pass1); if (pass1 == pass0 || pass2 == pass0) { String pass3 = JString.MD5(newPass); Dictionary <string, object> data1 = new Dictionary <string, object>(); data1["password"] = pass3; da1.EditData(condition, data1); } else { error = "提示:老密码输入不正确,请重新输入!"; } } } return(error); }
/// <summary> /// 得到选择用户的EasyUiJson数据 /// </summary> /// <returns></returns> public String GetSelectUserEasyUiJsonData(List <String> OldUserID) { JUserDA da1 = new JUserDA(); DataTable dt1 = da1.GetSelectUserEasyUiJsonData(OldUserID); String str1 = UTools.GetEasyUiTreeData(dt1); return(str1); }
/// <summary> /// 根据用户的姓名得到姓名列表 /// </summary> /// <param name="UserName"></param> /// <returns></returns> public DataTable GetUserName(String UserName, int pageSize) { DataTable dt1 = null; if (String.IsNullOrEmpty(UserName) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("UserName", UserName, SearchOperator.Contains)); JUserDA da1 = new JUserDA(); dt1 = da1.GetListData(condition, pageSize, 1, "UserName", "UserName"); } return(dt1); }
/// <summary> /// 根据用户的ID得到用户实体 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public JUserDD GetUserInfoByUserID(String UserID) { JUserDD data1 = null; if (String.IsNullOrEmpty(UserID) == false) { JUserDA da1 = new JUserDA(); List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("UserID", UserID)); data1 = da1.GetFirstDataEntity(condition, "*"); } return(data1); }
/// <summary> /// 重置用户的登陆密码 /// </summary> /// <param name="UserID"></param> public bool ResetPassWord(String UserID) { bool succ = false; try { JUserDA da1 = new JUserDA(); if (String.IsNullOrEmpty(UserID) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("UserID", UserID)); Dictionary <String, object> data1 = new Dictionary <string, object>(); data1["[password]"] = "123456"; da1.EditData(condition, data1); succ = true; } }catch (Exception err) {; } return(succ); }
/// <summary> /// 检查用户名是否正确,并返回正确的用户ID列表 /// </summary> /// <param name="userNameList"></param> /// <returns></returns> public bool CheckUserList(String userNameList, ref String rightUser) { bool succ = true;; StringBuilder str1 = new StringBuilder(); bool first = true; if (String.IsNullOrEmpty(userNameList) == false) { userNameList = userNameList.Replace(",", ","); String[] arr1 = userNameList.Split(','); List <SearchField> condition = new List <SearchField>(); JUserDA da1 = new JUserDA(); Dictionary <string, object> dic1 = null; foreach (String m in arr1) { condition.Clear(); condition.Add(new SearchField("( UserID='" + m + "' or UserName='******') ", "", SearchOperator.UserDefine)); dic1 = da1.GetFirstDictionary(condition, "UserID"); if (dic1 != null && dic1.Count > 0) { if (first) { str1.Append(dic1["UserID"].ToString()); first = false; } else { str1.Append(",").Append(dic1["UserID"].ToString()); } } else { succ = false; break; } } } if (succ) { rightUser = str1.ToString(); } return(succ); }
public String GetPwd(String userid) { if (String.IsNullOrEmpty(userid) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("UserID", userid)); JUserDA da1 = new JUserDA(); DataRow drresult = da1.GetFirstDataRow(condition, "PassWord");// GetListData(condition, -1, 1, "AuthorityGroup"); if (drresult != null) { if (!String.IsNullOrEmpty(drresult["PassWord"].ToString())) { return(drresult["PassWord"].ToString()); } } } return(""); }
/// <summary> /// 得到用户的授权用户信息 /// </summary> /// <param name="UserID">用户ID</param> /// <param name="sqkind">授权类型 1--工作备忘 2--工作日志 3--工作计划 4--考核数据 /// </param> /// <returns></returns> public String GetShouquanUserList(String UserID, int sqkind) { StringBuilder str1 = new StringBuilder(); bool first = true; JUserDA da1 = new JUserDA(); List <SearchField> condition = new List <SearchField>(); String s2 = String.Format("instr(qx{0}, '{1}') > 0", sqkind, UserID); condition.Add(new SearchField(s2, "", SearchOperator.UserDefine)); DataTable dt1 = da1.GetListData(condition, -1, -1, "num", "UserID,qx" + sqkind + " as sq"); foreach (DataRow dr1 in dt1.Rows) { String[] sq = dr1[1].ToString().Split(','); if (sq.Contains(UserID)) { if (first) { str1.Append(dr1[0].ToString()); first = false; } else { str1.Append(",").Append(dr1[0].ToString()); } } } String s1 = str1.ToString(); if (String.IsNullOrEmpty(s1)) { s1 = "-1"; } return(s1); }
//插入数据 private void InsertData1( String prNum, String content1, String content2, String zeren1, String finish1, Tb_TaskDA da0) { //1--更加prjNum得到项目id String prjguid = String.Empty; Tb_ProjectDA da1 = new Tb_ProjectDA(); List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("prjNum", prNum)); Dictionary <String, object> dic1 = da1.GetFirstDictionary(condition, "GuidID"); if (dic1 != null && dic1.Count > 0 && String.IsNullOrEmpty(dic1["GuidID"].ToString()) == false) { prjguid = dic1["GuidID"].ToString(); } //2--得到项目经理的id String prjManager = String.Empty; Tb_Project_PersonDA da3 = new Tb_Project_PersonDA(); dic1.Clear(); condition.Clear(); condition.Add(new SearchField("ProjectGuidID", prjguid)); condition.Add(new SearchField("PrjRole", "0")); dic1 = da3.GetFirstDictionary(condition, "PersonID"); if (dic1 != null && dic1.Count > 0) { prjManager = dic1["PersonID"].ToString(); } //3--根据责任人的姓名得到责任id String zr1 = String.Empty; JUserDA da2 = new JUserDA(); dic1.Clear(); condition.Clear(); condition.Add(new SearchField("UserName", zeren1)); dic1 = da2.GetFirstDictionary(condition, "UserID"); if (dic1 != null && dic1.Count > 0) { zr1 = dic1["UserID"].ToString(); } //插入数据 String year1 = DateTime.Now.ToString("yyyy"); String month1 = DateTime.Now.ToString("MM"); if (String.IsNullOrEmpty(prjguid) == false && String.IsNullOrEmpty(content1) == false && String.IsNullOrEmpty(content2) == false && String.IsNullOrEmpty(prjManager) == false && String.IsNullOrEmpty(zr1) == false) { dic1.Clear(); dic1["ProjectGuidID"] = prjguid; DateTime t1 = DateTime.Parse(year1 + "-" + month1 + "-01"); dic1["begDate"] = t1; DateTime t2 = DateTime.Parse(year1 + "-" + finish1.Substring(0, 2) + "-" + finish1.Substring(2)); dic1["endDate"] = t2; dic1["Workload"] = ((t2 - t1).Days + 1) * 8; dic1["TaskTitle"] = "工作计划"; dic1["content"] = content1 + "--" + content2; dic1["Manager"] = prjManager; dic1["Status"] = "1"; dic1["GuidID"] = WebFrame.Util.JString.GetUnique32ID(); dic1["AddTime"] = DateTime.Now; dic1["AddUser"] = zr1; da0.NewData(dic1); } }
/// <summary> /// 判断是否有符合条件的数据 /// </summary> ///<param name="condition">查询条件</param> /// <returns></returns> public bool HasData(List <SearchField> condition) { JUserDA da = new JUserDA(); return(da.HasData(condition)); }
/// <summary> /// 得到满足条件的第一行数据 /// </summary> /// <param name="condition">查询条件</param> /// <param name="Fields">数据字段</param> /// <returns>满足条件的行</returns> public DataRow GetFirstDataRow(List <SearchField> condition, params String[] Fields) { JUserDA da = new JUserDA(); return(da.GetFirstDataRow(condition, Fields)); }
/// <summary> /// 平台用户的登陆方法 /// </summary> /// <param name="userName">用户名</param> /// <param name="PassWord">登录密码</param> /// <param name="Userid">登录成功后,返回的用户ID</param> /// <returns> /// 0--表示用户名不存在 /// 1--表示密码不正确 /// 2--表示账号已停用 /// 3--表示登陆成功 /// </returns> public int Login(String userName, String PassWord, ref String Userid, ref String departNum) { int succ = 0; Userid = userName; departNum = String.Empty; if (String.IsNullOrEmpty(userName) == false && String.IsNullOrEmpty(PassWord) == false) { JUserDA da1 = new JUserDA(); List <SearchField> condition = new List <SearchField>(); SearchField search1 = new SearchField("UserID", userName); SearchField search2 = new SearchField("UserName", userName); condition.Add(search1 | search2); DataRow data1 = da1.GetFirstDataRow(condition, "*"); if (data1 != null) { String password1 = data1["Password"].ToString(); if (PassWord == password1 || JString.MD5(PassWord) == password1) { if (data1["status"].ToString() == "1") { //判断用户所在单位的情况 succ = 3; //修改用户登录时间和登录次数 condition.Clear(); condition.Add(search1 | search2); Dictionary <String, object> dic0 = new Dictionary <string, object>(); dic0["LastLogin"] = DateTime.Now; if (data1["LoginCount"].ToString() != String.Empty) { dic0["LoginCount"] = "$$LoginCount+1"; } else { dic0["LoginCount"] = 1; } da1.EditData(condition, dic0); //设置用户的权限角色(可能需要修改) FrameLib.AuthorityID = data1["AuthorityID"].ToString(); //用户的权限ID FrameLib.UserName = data1["UserName"].ToString(); //用户的UserName FrameLib.AuthorityGroup = data1["AuthorityGroup"].ToString(); //表示用户的类别 /* * FrameLib.DepartID = data1["DepartID"].ToString(); //表示用户所属的部门ID * * //根据部门的ID设置部门的Num(数据权限用) * condition.Clear(); * JOrgDA org1 = new JOrgDA(); * condition.Add(new SearchField("OrgID",data1["DepartID"].ToString())); * DataRow r1=org1.GetFirstDataRow(condition,"num"); * if(r1!=null) * { * departNum = r1["num"].ToString(); * }*/ Userid = data1["userid"].ToString(); //创建用户登录日志 JUserLoginLogDA da2 = new JUserLoginLogDA(); Dictionary <String, object> logdata = new Dictionary <string, object>(); logdata["ID"] = WebFrame.Util.JString.GetUnique32ID(); logdata["UserID"] = data1["UserID"].ToString(); logdata["UserName"] = data1["UserName"].ToString(); logdata["CreateTime"] = DateTime.Now; logdata["AuthorityGroup"] = data1["AuthorityGroup"]; string ip = GetIPAddress(); logdata["Remark"] = ip; da2.NewData(logdata); } else { succ = 2; } } else { succ = 1; } } } return(succ); }
/// <summary> /// 新增一条数据 /// </summary> /// <param name="data1">Dictionary数据</param> public void NewData(Dictionary <String, object> data1) { JUserDA da = new JUserDA(); da.NewData(data1); }
/// <summary> /// 保存用户数据的修改 /// </summary> /// <returns></returns> public int SaveData(String oldUserID, String num, String UserID, String UserName, String trueName, String telephone, String Status, String AuthorityID, String OrgID, String cardID) { int succ = 0; JConnect conn = JConnect.GetConnect(); conn.BeginTrans(); try { JUserDA da1 = new JUserDA(conn); JOrgUsersDA da2 = new JOrgUsersDA(conn); Dictionary <String, object> data1 = new Dictionary <string, object>(); data1["num"] = num; data1["userid"] = UserID; data1["username"] = UserName; data1["TrueName"] = trueName; data1["status"] = Status; data1["AuthorityID"] = AuthorityID; data1["DepartID"] = FrameLib.DepartID; data1["AuthorityGroup"] = FrameLib.AuthorityGroup; if (!string.IsNullOrEmpty(cardID)) { data1["WbCardID"] = cardID; } if (!string.IsNullOrEmpty(telephone)) { data1["Telephone"] = telephone; } if (String.IsNullOrEmpty(oldUserID) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("UserID", UserID)); data1.Remove("userid"); da1.EditData(condition, data1); } else { data1["[Password]"] = "123456"; //设置默认的口令和密码 data1["LastLogin"] = DateTime.Now; //设置默认的登陆时间 data1["LoginCount"] = 0; //设置默认的登陆测试 da1.NewData(data1); } //更新组织用户表 List <SearchField> condition2 = new List <SearchField>(); condition2.Add(new SearchField("UserID", UserID)); if (string.IsNullOrEmpty(OrgID) == false) { if (da2.HasData(condition2)) { data1.Clear(); data1["orgid"] = OrgID; da2.EditData(condition2, data1); } else { data1.Clear(); data1["orgid"] = OrgID; data1["userid"] = UserID; da2.NewData(data1); } } else { da2.DeleteData(condition2); } conn.CommitTrans(); succ = 1; } catch (Exception err) { conn.RollBackTrans(); } return(succ); }
/// <summary> /// 创建月度考核数据 /// </summary> /// <param name="byear">考核年份</param> /// <param name="bmonth">考核月份</param> /// <param name="khDays">考核工作日</param> /// <returns></returns> public bool CreateMonthKHData(int byear, int bmonth, double khDays) { bool succ = false; //code、team和test的工作量系数 double rate1 = double.Parse(WebFrame.Comm.JStrInfoBU.GetStrTextByID("codeRate")); double rate2 = double.Parse(WebFrame.Comm.JStrInfoBU.GetStrTextByID("teamRate")); double rate3 = double.Parse(WebFrame.Comm.JStrInfoBU.GetStrTextByID("testRate")); JConnect.GetConnect().BeginTrans(); try { //1--得到考核人员清单 List <SearchField> condition = new List <SearchField>(); JUserDA da1 = new JUserDA(); condition.Add(new SearchField("gw='0' or gw='1' or gw='2'", "", SearchOperator.UserDefine)); DataTable dt1 = da1.GetListData(condition, -1, -1, "num", "UserID,UserName"); //2--删除原有的考核数据 Tb_KH_MonthDA da2 = new Tb_KH_MonthDA(); condition.Clear(); condition.Add(new SearchField("byear", byear + "", SearchFieldType.NumericType)); condition.Add(new SearchField("bmonth", bmonth + "", SearchFieldType.NumericType)); da2.DeleteData(condition); //3--根据考核人员名单形成新的月度考核数据 DataTable khTable = new DataTable(); khTable.Columns.Add("userid"); khTable.Columns.Add("username"); khTable.Columns.Add("workload1", typeof(double)); khTable.Columns.Add("workload2", typeof(double)); khTable.Columns.Add("workload3", typeof(double)); khTable.PrimaryKey = new DataColumn[] { khTable.Columns["userid"] }; foreach (DataRow dr1 in dt1.Rows) { DataRow khrow = khTable.NewRow(); khrow["userid"] = dr1["userid"]; khrow["UserName"] = dr1["username"]; khrow["workload1"] = 0; //code khrow["workload2"] = 0; //team khrow["workload3"] = 0; //test khTable.Rows.Add(khrow); } //4--根据月度考核的任务,修改考核数据 condition.Clear(); condition.Add(new SearchField("Status", "4")); condition.Add(new SearchField("DatePart('yyyy', finishDate)=" + byear, "", SearchOperator.UserDefine)); condition.Add(new SearchField("DatePart('M', finishDate)=" + bmonth, "", SearchOperator.UserDefine)); Tb_TaskDA da3 = new Tb_TaskDA(); DataTable dt3 = da3.GetListData(condition, -1, -1, "FinishDate", "*"); Tb_Task_BugDA da4 = new Tb_Task_BugDA(); foreach (DataRow dr3 in dt3.Rows) { int load1 = int.Parse(dr3["LastWorkLoad"].ToString()); String Manager = dr3["Manager"].ToString(); String ExecuteMan = dr3["ExecuteMan"].ToString(); //得到测试的情况A-3 B-2 C-1 Dictionary <String, double> debugDic = da4.GetTaskDebugRate(dr3["Guidid"].ToString()); if (debugDic.Count == 0) { debugDic[dr3["TestMan"].ToString()] = 1.0; } //根据不同的人员分配工作量 //code DataRow datarow1 = khTable.Rows.Find(ExecuteMan); if (datarow1 != null) { datarow1["workload1"] = double.Parse(datarow1["workload1"].ToString()) + load1; } //team DataRow datarow2 = khTable.Rows.Find(Manager); if (datarow2 != null) { datarow2["workload2"] = double.Parse(datarow2["workload2"].ToString()) + load1; } //test foreach (string m in debugDic.Keys) { DataRow datarow3 = khTable.Rows.Find(m); if (datarow3 != null) { datarow3["workload3"] = double.Parse(datarow3["workload3"].ToString()) + load1 * debugDic[m]; } } } //5--将数据写入到月度考核任务表 Dictionary <String, object> dic1 = new Dictionary <string, object>(); foreach (DataRow dr1 in khTable.Rows) { dic1.Clear(); dic1["byear"] = byear; dic1["bmonth"] = bmonth; dic1["userid"] = dr1["userid"]; dic1["userName"] = dr1["username"]; dic1["Fullload"] = khDays * 8; dic1["workload1"] = dr1["workload1"]; dic1["workload2"] = dr1["workload2"]; dic1["workload3"] = dr1["workload3"]; dic1["workload"] = rate1 * double.Parse(dr1["workload1"].ToString()) + rate2 * double.Parse(dr1["workload2"].ToString()) + rate3 * double.Parse(dr1["workload3"].ToString()); dic1["AddMoney"] = 0; da2.NewData(dic1); } JConnect.GetConnect().CommitTrans(); succ = true; } catch (Exception err) { JConnect.GetConnect().RollBackTrans(); WebFrame.Util.JTool.WriteErrorLog(err.ToString()); } return(succ); }
/// <summary> /// 根据条件,修改一个实体数据 /// </summary> /// <param name="condition">修改数据的条件</param> /// <param name="data1">新的数据</param> public void EditData(List <SearchField> condition, Dictionary <String, object> data1) { JUserDA da = new JUserDA(); da.EditData(condition, data1); }