/// <summary>
/// 获得查询where
/// </summary>
/// <returns></returns>
string GetWhere()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
string str = "Workprogress=3";
string id = com.getsid("tast").ToString();
if (id == "3")
{
str = "Workprogress=" + id.ToString();
}
else if (id == "9")
{
str = "Workprogress=9 and Manager=" + "'" + getvalue(2) + "'";
}
else if (id == "45678")
{
str = "Workprogress in(4,5,6,7,8)";
str += " and Manager=" + "'" + getvalue(2) + "'";
}
if (Tasktitle.Text.Trim() != "")
{
str += " and (Tasktitle like " + "'" + Tasktitle.Text.Trim() + "%')";
}
if (classse.SelectedValue.ToString() != "0")
{
str += " and classse=" + "'" + classse.SelectedValue.ToString() + "'";
}
return(str);
}
public string getstrobj(object name, int i)
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); string str = "";
if (i == 1)
{
DataTable dt = com.COM_Select("OA_ItemTB", "id", "", name.ToString(), "", 4);
if (dt.Rows.Count != 0)
{
str = dt.Rows[0]["titlename"].ToString();
}
}
else
{
if (name.ToString() == "1")
{
str = "一般";
}
else if (name.ToString() == "2")
{
str = "紧急";
}
else
{
str = "十分紧急";
}
}
return(str);
}
protected void drop()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
Itemid.DataSource = com.COM_Select("OA_ItemTB", "typeid", "parentid", "1", "0", 8);
Itemid.DataTextField = "titlename";
Itemid.DataValueField = "Id";
Itemid.DataBind();
}
protected void gvlist_RowDataBound(object sender, GridViewRowEventArgs e)
{
int num = 0;
//
if (e.Row.RowIndex != -1)
{
int id = e.Row.RowIndex + 1;
e.Row.Cells[0].Text = id.ToString();
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
#region 行事件
string fid = gvlist.DataKeys[e.Row.RowIndex].Value.ToString().Trim();
GridView gvlist3 = (GridView)e.Row.FindControl("GridView2");
if (fid != "")
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
DataTable dt = com.COM_Select("OA_ItemTB", "parentid", "Isdelete", fid, "1", 8);
gvlist3.DataSource = dt; gvlist3.DataBind();
if (com.getsid("uid") != "-1" && com.getsid("kq") != "-1")
{
DataTable ds =com.COM_Proc_Sel3("Pc_SelOpposebyPTI",fid,com.getsid("uid"), com.getsid("kq"));
for (int i = 0; i < ds.Rows.Count; i++)
{
Label lb = (Label)gvlist3.Rows[i].FindControl("lbtxt");
switch (getvalue(4))
{
case "1":
lb.Text = ds.Rows[i]["threescore"].ToString();
break;
case "2":
lb.Text = ds.Rows[i]["twoscore"].ToString();
break;
case "3":
lb.Text = ds.Rows[i]["onescore"].ToString();
break;
case "4":
lb.Text = ds.Rows[i]["custom"].ToString();
break;
}
num +=Convert.ToInt32(lb.Text.Trim());
TextBox txt = (TextBox)gvlist3.Rows[i].FindControl("txtremark");
txt.Text = ds.Rows[i]["remrk"].ToString();
}
}
}
#endregion
Label lbtxt = (Label)e.Row.FindControl("labnum");
lbtxt.Text = num.ToString();
Snum += num;
}
// 合计
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[3].Text = "合计您给的总分：<font style=\"color:red\">"+Snum.ToString()+"</font>";
}
}
protected void drop()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
dropitem.DataSource = com.COM_Select("OA_ItemTB", "typeid", "parentid", "1", "0", 8);
dropitem.DataTextField = "titlename";
dropitem.DataValueField = "Id";
dropitem.DataBind();
dropitem.Items.Insert(0, new ListItem("======全部项目======", "0"));
}
void show()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
DataTable table = com.COM_Select("OA_Message", "Mid", "", mes.ToString(), "", 4);
if (table.Rows.Count != 0)
{
ren.Visible = false;
}
else
{
ren.Visible = true;
drop();
}
}
public string email()
{
string a = "";
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
DataTable dt = com.COM_Proc_Sel1("Pc_emailsystem", "," + UserId + ",");
if (dt.Rows.Count != 0)
{
if (dt.Rows[0]["contents"].ToString() != "0")
a = "<a href=" + "" + dt.Rows[0]["titles"].ToString() + "" + " target=\"_blank\">共有<font style=\"color:#000099;font-weight: bold\">" + dt.Rows[0]["files"].ToString() + "</font> 封邮件，今天有<font style=\"color: #FF0000;font-weight: bold\">" + dt.Rows[0]["contents"].ToString() + "</font>封邮件,请登录!" + "</a>";
//string sid = dt.Rows[0]["Id"].ToString();
//DataRow drw = dt.Rows[0];
//drw["files"] = "0";
//com.COM_Up(dt, "OA_EmailtextTB", "files=@files", sid);
}
return a;
}
public string email()
{
string a = "";
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
DataTable dt = com.COM_Proc_Sel1("Pc_emailsystem", "," + UserId + ",");
if (dt.Rows.Count != 0)
{
if (dt.Rows[0]["contents"].ToString() != "0")
{
a = "<a href=" + "" + dt.Rows[0]["titles"].ToString() + "" + " target=\"_blank\">共有<font style=\"color:#000099;font-weight: bold\">" + dt.Rows[0]["files"].ToString() + "</font> 封邮件，今天有<font style=\"color: #FF0000;font-weight: bold\">" + dt.Rows[0]["contents"].ToString() + "</font>封邮件,请登录!" + "</a>";
}
//string sid = dt.Rows[0]["Id"].ToString();
//DataRow drw = dt.Rows[0];
//drw["files"] = "0";
//com.COM_Up(dt, "OA_EmailtextTB", "files=@files", sid);
}
return(a);
}
public string getstrobj(object name, int i)
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); string str = "";
if (i == 1)
{
DataTable dt = com.COM_Select("OA_ItemTB", "id", "", name.ToString(), "", 4);
if (dt.Rows.Count != 0)
str = dt.Rows[0]["titlename"].ToString();
}
else
{
if (name.ToString() == "1")
str = "一般";
else if (name.ToString() == "2")
str = "紧急";
else
str = "十分紧急";
}
return str;
}
void showdp()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
int uid = Convert.ToInt32(com.getsid("fid"));
if (uid != -1)
{
int dpid = new JumbotOA.BLL.UserBLL().GetEntity(uid).Did;
DropDownList1.SelectedValue = dpid.ToString();
DropDownList1.Enabled = false;
this.DropDownList2.DataSource = new JumbotOA.BLL.UserBLL().GetList("Did=" + DropDownList1.SelectedValue.ToString());
this.DropDownList2.DataTextField = "Uname";
this.DropDownList2.DataValueField = "Uid";
this.DropDownList2.DataBind();
DropDownList2.SelectedValue = uid.ToString();
DropDownList2.Enabled = false;
}
else
{
DropDownList1.Enabled = true;
DropDownList2.Enabled = true;
}
}
protected void Show()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
string id = com.getsid("tast").ToString();
switch (id)
{
case "-1":
gvlist.Visible = false; AspNetPager1.Visible = false;
break;
case "3":
gvlist.Columns[7].Visible = false; gvlist.Columns[9].Visible = false; gvlist.Columns[4].Visible = false;
break;
case "9":
gvlist.Columns[5].Visible = false;
break;
case "45678":
gvlist.Columns[7].Visible = false; gvlist.Columns[8].Visible = false;
break;
}
}
void show()
{
JumbotOA.BLL.COMDLL com=new JumbotOA.BLL.COMDLL ();
DataTable table = com.COM_Select("OA_Message", "Mid", "", mes.ToString(), "", 4);
if (table.Rows.Count != 0)
{
ren.Visible = false;
}
else
{
ren.Visible = true;
drop();
}
}
protected void drop()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
Itemid.DataSource = com.COM_Select("OA_ItemTB", "typeid", "parentid", "1", "0", 8);
Itemid.DataTextField = "titlename";
Itemid.DataValueField = "Id";
Itemid.DataBind();
}
void bangemmail()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
JumbotOA.BLL.URLENCRYP urlen = new JumbotOA.BLL.URLENCRYP();
string UserId = JumbotOA.BLL.OA_SysMessageIn.userid();
string username = "", userpwd = "", pstr = "";
string[] str = null;
DataTable dt = com.COM_Proc_Sel1("PC_getOA_email", UserId.ToString());
if (dt.Rows.Count != 0)
{
#region 存储了邮箱
str = dt.Rows[0]["emailname"].ToString().Split("@".ToCharArray());
if (str[1] == "jumbotcms.net")
username = str[0].ToString();
else
username = dt.Rows[0]["emailname"].ToString();
pstr = dt.Rows[0]["emailname"].ToString();
userpwd = urlen.Decryp(dt.Rows[0]["emailpwd"].ToString());
jmail.POP3Class popMail = new POP3Class();
jmail.Message mailMessage;
//取得最大时间
DataTable dts = com.COM_Proc_Sel1("Pc_emailsystem", "," + UserId + ",");
string popstr = JumbotOA.BLL.Eemail.GetFormatPop3(pstr).ToString();
int num = 0;
try
{
popMail.Connect(username, userpwd, popstr, 110); //建立连接
if (0 < popMail.Count)
{
#region 检索今天邮件
DateTime t1= Convert.ToDateTime(DateTime.Now.ToString("yyyy-M-d").ToString() + " 01:00:00");
DateTime t2=Convert.ToDateTime(DateTime.Now.ToString("yyyy-M-d").ToString() + " 23:59:59");
for (int i = popMail.Count; i > 0; i--)
{
mailMessage = popMail.Messages[i];
if (dts.Rows.Count != 0)
{
if (mailMessage.Date >= t1 && mailMessage.Date <= t2)
num++;
else
continue;
}
else
{
dts.Rows.Clear();
DataRow dr = dts.NewRow();
dr["uid"] = "," + UserId + ",";
dr["recivetime"] = DateTime.Now;
dr["files"] = popMail.Count.ToString();//邮件总数
dr["contents"] = "0";
dts.Rows.Add(dr);
com.COM_Add(dts, "OA_EmailtextTB", "@uid,@recivetime,@files,@contents");
}
}
#endregion
}
string titles = "";
switch (str[1])
{
case "jumbotcms.net":
titles = "http://mail.jumbotcms.net/default.jsp";
break;
case "sina.com":
titles = "http://mail.sina.com.cn";
break;
case "sina.cn":
titles = "http://mail.sina.com.cn/cnmail/index.html";
break;
case "163.com":
titles = "http://email.163.com";
break;
case "126.com":
titles = "http://email.163.com";
break;
case "yeah.net":
titles = "http://email.163.com";
break;
case "qq.com":
titles = "https://mail.qq.com/cgi-bin/loginpage?flowid=16621966528880993";
break;
}
string Id = dts.Rows[0]["Id"].ToString();
DataRow drw = dts.Rows[0];
drw["recivetime"] = DateTime.Now;
drw["titles"] = titles;
drw["files"] = popMail.Count.ToString();
drw["contents"] = num.ToString();
com.COM_Up(dts, "OA_EmailtextTB", "recivetime=@recivetime,titles=@titles,files=@files,contents=@contents", Id);
popMail.Disconnect();
popMail = null;
Tools.Common.JavaScript.MessageBox(this, "检索成功!");
}
catch (Exception e)
{
com.ErroLog(e.ToString());
Tools.Common.JavaScript.MessageBox(this, "检索失败！网络连接已超时！");
}
#endregion
}
else
Tools.Common.JavaScript.MessageBox(this, "您还没有保存过邮箱名称和密码信息！暂时无法检索！");
}
protected void Show()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
string id = com.getsid("tast").ToString();
switch (id)
{
case "-1":
gvlist.Visible = false; AspNetPager1.Visible = false;
break;
case "3":
gvlist.Columns[7].Visible=false;gvlist.Columns[9].Visible=false;gvlist.Columns[4].Visible=false;
break;
case "9":
gvlist.Columns[5].Visible = false;
break;
case "45678":
gvlist.Columns[7].Visible = false;gvlist.Columns[8].Visible=false;
break;
}
}
protected void gvlist_RowDataBound(object sender, GridViewRowEventArgs e)
{
int num = 0;
//
if (e.Row.RowIndex != -1)
{
int id = e.Row.RowIndex + 1;
e.Row.Cells[0].Text = id.ToString();
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
#region 行事件
string fid = gvlist.DataKeys[e.Row.RowIndex].Value.ToString().Trim();
GridView gvlist3 = (GridView)e.Row.FindControl("GridView2");
if (fid != "")
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
DataTable dt = com.COM_Select("OA_ItemTB", "parentid", "Isdelete", fid, "1", 8);
gvlist3.DataSource = dt; gvlist3.DataBind();
if (com.getsid("uid") != "-1" && com.getsid("kq") != "-1")
{
DataTable ds = com.COM_Proc_Sel3("Pc_SelOpposebyPTI", fid, com.getsid("uid"), com.getsid("kq"));
for (int i = 0; i < ds.Rows.Count; i++)
{
Label lb = (Label)gvlist3.Rows[i].FindControl("lbtxt");
switch (getvalue(4))
{
case "1":
lb.Text = ds.Rows[i]["threescore"].ToString();
break;
case "2":
lb.Text = ds.Rows[i]["twoscore"].ToString();
break;
case "3":
lb.Text = ds.Rows[i]["onescore"].ToString();
break;
case "4":
lb.Text = ds.Rows[i]["custom"].ToString();
break;
}
num += Convert.ToInt32(lb.Text.Trim());
TextBox txt = (TextBox)gvlist3.Rows[i].FindControl("txtremark");
txt.Text = ds.Rows[i]["remrk"].ToString();
}
}
}
#endregion
Label lbtxt = (Label)e.Row.FindControl("labnum");
lbtxt.Text = num.ToString();
Snum += num;
}
// 合计
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[3].Text = "合计您给的总分：<font style=\"color:red\">" + Snum.ToString() + "</font>";
}
}
protected void drop()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
dropitem.DataSource = com.COM_Select("OA_ItemTB", "typeid", "parentid", "1", "0", 8);
dropitem.DataTextField = "titlename";
dropitem.DataValueField = "Id";
dropitem.DataBind();
dropitem.Items.Insert(0, new ListItem("======全部项目======", "0"));
}
void bangemmail()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
JumbotOA.BLL.URLENCRYP urlen = new JumbotOA.BLL.URLENCRYP();
string UserId = JumbotOA.BLL.OA_SysMessageIn.userid();
string username = "", userpwd = "", pstr = "";
string[] str = null;
DataTable dt = com.COM_Proc_Sel1("PC_getOA_email", UserId.ToString());
if (dt.Rows.Count != 0)
{
#region 存储了邮箱
str = dt.Rows[0]["emailname"].ToString().Split("@".ToCharArray());
if (str[1] == "jumbotcms.net")
{
username = str[0].ToString();
}
else
{
username = dt.Rows[0]["emailname"].ToString();
}
pstr = dt.Rows[0]["emailname"].ToString();
userpwd = urlen.Decryp(dt.Rows[0]["emailpwd"].ToString());
jmail.POP3Class popMail = new POP3Class();
jmail.Message mailMessage;
//取得最大时间
DataTable dts = com.COM_Proc_Sel1("Pc_emailsystem", "," + UserId + ",");
string popstr = JumbotOA.BLL.Eemail.GetFormatPop3(pstr).ToString();
int num = 0;
try
{
popMail.Connect(username, userpwd, popstr, 110); //建立连接
if (0 < popMail.Count)
{
#region 检索今天邮件
DateTime t1 = Convert.ToDateTime(DateTime.Now.ToString("yyyy-M-d").ToString() + " 01:00:00");
DateTime t2 = Convert.ToDateTime(DateTime.Now.ToString("yyyy-M-d").ToString() + " 23:59:59");
for (int i = popMail.Count; i > 0; i--)
{
mailMessage = popMail.Messages[i];
if (dts.Rows.Count != 0)
{
if (mailMessage.Date >= t1 && mailMessage.Date <= t2)
{
num++;
}
else
{
continue;
}
}
else
{
dts.Rows.Clear();
DataRow dr = dts.NewRow();
dr["uid"] = "," + UserId + ",";
dr["recivetime"] = DateTime.Now;
dr["files"] = popMail.Count.ToString();//邮件总数
dr["contents"] = "0";
dts.Rows.Add(dr);
com.COM_Add(dts, "OA_EmailtextTB", "@uid,@recivetime,@files,@contents");
}
}
#endregion
}
string titles = "";
switch (str[1])
{
case "jumbotcms.net":
titles = "http://mail.jumbotcms.net/default.jsp";
break;
case "sina.com":
titles = "http://mail.sina.com.cn";
break;
case "sina.cn":
titles = "http://mail.sina.com.cn/cnmail/index.html";
break;
case "163.com":
titles = "http://email.163.com";
break;
case "126.com":
titles = "http://email.163.com";
break;
case "yeah.net":
titles = "http://email.163.com";
break;
case "qq.com":
titles = "https://mail.qq.com/cgi-bin/loginpage?flowid=16621966528880993";
break;
}
string Id = dts.Rows[0]["Id"].ToString();
DataRow drw = dts.Rows[0];
drw["recivetime"] = DateTime.Now;
drw["titles"] = titles;
drw["files"] = popMail.Count.ToString();
drw["contents"] = num.ToString();
com.COM_Up(dts, "OA_EmailtextTB", "recivetime=@recivetime,titles=@titles,files=@files,contents=@contents", Id);
popMail.Disconnect();
popMail = null;
Tools.Common.JavaScript.MessageBox(this, "检索成功!");
}
catch (Exception e)
{
com.ErroLog(e.ToString());
Tools.Common.JavaScript.MessageBox(this, "检索失败！网络连接已超时！");
}
#endregion
}
else
{
Tools.Common.JavaScript.MessageBox(this, "您还没有保存过邮箱名称和密码信息！暂时无法检索！");
}
}
void showdp()
{
JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL();
int uid = Convert.ToInt32(com.getsid("fid"));
if (uid != -1)
{
int dpid = new JumbotOA.BLL.UserBLL().GetEntity(uid).Did;
DropDownList1.SelectedValue = dpid.ToString();
DropDownList1.Enabled = false;
this.DropDownList2.DataSource = new JumbotOA.BLL.UserBLL().GetList("Did=" + DropDownList1.SelectedValue.ToString());
this.DropDownList2.DataTextField = "Uname";
this.DropDownList2.DataValueField = "Uid";
this.DropDownList2.DataBind();
DropDownList2.SelectedValue = uid.ToString();
DropDownList2.Enabled = false;
}
else
{
DropDownList1.Enabled = true;
DropDownList2.Enabled = true;
}
}
/// <summary>
/// 获得查询where
/// </summary>
/// <returns></returns>
string GetWhere()
{
JumbotOA.BLL.COMDLL com=new JumbotOA.BLL.COMDLL ();
string str = "Workprogress=3";
string id=com.getsid("tast").ToString();
if (id == "3")
str = "Workprogress=" + id.ToString();
else if (id == "9")
{
str = "Workprogress=9 and Manager=" + "'" + getvalue(2) + "'";
}
else if (id == "45678")
{
str = "Workprogress in(4,5,6,7,8)";
str += " and Manager=" + "'" + getvalue(2) + "'";
}
if (Tasktitle.Text.Trim() != "")
str += " and (Tasktitle like " + "'" + Tasktitle.Text.Trim() + "%')";
if (classse.SelectedValue.ToString() != "0")
str += " and classse=" +"'"+ classse.SelectedValue.ToString()+"'";
return str;
}
