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