/// <summary>
/// 功能说明：增加当前用户的登录日志
/// </summary>
public void AddLogo(string username)
{
string depart = "";
//根据当前用户名得到所在的部门
U_UserNameBU user1 = new U_UserNameBU();
depart = user1.GetDepart1(username);
user1.Close();
List <SearchField> list1 = new List <SearchField>();
list1.Add(new SearchField("sname", username));
list1.Add(new SearchField("endlogin", "", SearchOperator.空值));
list1.Add(new SearchField("beginlogin", "", SearchOperator.非空值));
DataSet ds = this.tabCommand.SearchData("*", list1);
if (ds.Tables[0].Rows.Count == 0)
{
//表示没有用户登录日志记录，则增加一条新的数据记录；
DataRow dr = ds.Tables[0].NewRow();
dr["sname"] = username;
dr["depart"] = depart;
dr["beginlogin"] = DateTime.Now.ToString();
ds.Tables[0].Rows.Add(dr);
}
else
{
//表示存在没有完整的用户日志记录
DateTime dt0 = DateTime.Now;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
DateTime dt1 = DateTime.Parse(dr["beginlogin"].ToString());
if (dt0.Date != dt1.Date)
{
//日期不相等，则直接修改结束日期为17：30
dr["endlogin"] = dt1.Date.ToString("yyyy-MM-dd") + " 17:30:00";
DateTime dt2 = DateTime.Parse(dr["endlogin"].ToString());
TimeSpan sp1 = dt2 - dt1;
dr["time1"] = sp1.Minutes.ToString();
//同时新增一条当他记录
DataRow dr1 = ds.Tables[0].NewRow();
dr1["sname"] = username;
dr1["depart"] = depart;
dr1["beginlogin"] = DateTime.Now.ToString();
ds.Tables[0].Rows.Add(dr1);
}
}
}
this.tabCommand.Update(ds);
ds.AcceptChanges();
}
public DataSet GetFASP(string begintime, string endtime, string depart)
{
string sql1 = "select ZCzeren from ZCSPStatView";
if (depart != "" && depart != null)
{
sql1 = sql1 + " where depart='" + depart + "'";
}
sql1 = sql1 + " group by ZCzeren";
DataSet ds1 = this.tabCommand.TableComm.SearchData(sql1);
string sql2 = "select max(id) as mid,zcid,ZCzeren,kind from ZCSPStatView where 1=1";
if (depart != "" && depart != null)
{
sql2 = sql2 + " and depart='" + depart + "'";
}
if (begintime != "" && begintime != null)
{
sql2 = sql2 + " and time0 > '" + begintime + "'";
}
if (endtime != "" && endtime != null)
{
sql2 = sql2 + " and time0 < '" + endtime + "'";
}
sql2 = sql2 + " group by ZCzeren,kind,zcid";
DataSet ds2 = this.tabCommand.TableComm.SearchData(sql2);
DataSet ds = new DataSet();
DataTable tab1 = new DataTable();
tab1.Columns.Add("zeren");
tab1.Columns.Add("depart");
tab1.Columns.Add("count1");
tab1.Columns.Add("count2");
tab1.Columns.Add("count3");
tab1.Columns.Add("count4");
tab1.Columns.Add("count5");
tab1.Columns.Add("count6");
tab1.Columns.Add("count7");
U_UserNameBU user1 = new U_UserNameBU();
DataRow dr = null;
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
{
dr = tab1.NewRow();
dr["zeren"] = ds1.Tables[0].Rows[i][0].ToString();
dr["count1"] = "0";
dr["count2"] = "0";
dr["count3"] = "0";
dr["count4"] = "0";
dr["count5"] = "0";
dr["count6"] = "0";
for (int j = 0; j < ds2.Tables[0].Rows.Count; j++)
{
if (ds2.Tables[0].Rows[j]["ZCzeren"].ToString() == ds1.Tables[0].Rows[i][0].ToString())
{
if (ds2.Tables[0].Rows[j]["kind"].ToString() == "11")
{
dr["count1"] = Int32.Parse(dr["count1"].ToString()) + 1;
}
if (ds2.Tables[0].Rows[j]["kind"].ToString() == "12")
{
dr["count2"] = Int32.Parse(dr["count2"].ToString()) + 1;
}
if (ds2.Tables[0].Rows[j]["kind"].ToString() == "13")
{
dr["count3"] = Int32.Parse(dr["count3"].ToString()) + 1;
}
if (ds2.Tables[0].Rows[j]["kind"].ToString() == "14")
{
dr["count4"] = Int32.Parse(dr["count4"].ToString()) + 1;
}
if (ds2.Tables[0].Rows[j]["kind"].ToString() == "15")
{
dr["count5"] = Int32.Parse(dr["count5"].ToString()) + 1;
}
if (ds2.Tables[0].Rows[j]["kind"].ToString() == "16")
{
dr["count6"] = Int32.Parse(dr["count6"].ToString()) + 1;
}
}
}
dr["count7"] = Int32.Parse(dr["count1"].ToString()) + Int32.Parse(dr["count2"].ToString()) + Int32.Parse(dr["count3"].ToString()) + Int32.Parse(dr["count4"].ToString()) + Int32.Parse(dr["count5"].ToString()) + Int32.Parse(dr["count6"].ToString());
dr["depart"] = user1.GetDepart1(ds1.Tables[0].Rows[i][0].ToString());
tab1.Rows.Add(dr);
}
user1.Close();
ds.Tables.Add(tab1);
return(ds);
}