private string getuserid()
{
string id = "";
string sql = "select Employeeid from Employee where username='******'";
return(OperateDB.getExecuteScalar(sql));
}
public string getAction(string id)
{
string sql = "select Name from FlowAction where ID=" + id;
string action = OperateDB.getExecuteScalar(sql);
return(action);
}
protected void comeback_Click(object sender, EventArgs e)
{
string strsql = "select LeaveID from Leave where retrue='未回'";
id = Convert.ToInt32(OperateDB.getExecuteScalar(strsql));
if (id == 0)
{
Response.Write("<script>alert('你还没有请假！')</script>");
}
else
{
DateTime dt = DateTime.Now;
string sql = "update Leave set retrue='" + dt + "' where LeaveID='" + id + "'";
if (OperateDB.ExecuteNonQuery(sql) > 0)
{
Response.Write("<script>alert('回来登记成功！')</script>");
}
else
{
Response.Write("<script>alert('回来登记失败！')</script>");
}
}
Bind();
}
protected void btnsave_Click(object sender, EventArgs e)
{
if (Request.Form["ctl00$ContentPlaceHolder1$addtime"].Trim() == "" || this.Motif.Text.Trim() == "" || this.textcontent.Text.Trim() == "")
{
this.Motif.Text = "";
this.textcontent.Text = "";
addtime.Text = "";
return;
}
else
{
DateTime starttime = Convert.ToDateTime(Request.Form["ctl00$ContentPlaceHolder1$addtime"]);
string UserName = Session["UserName"].ToString();
log sl = new log();
string sql = "select id from UserInfo where UserName='******'";
int ID = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
string Motif = this.Motif.Text.Trim();
string Content = this.textcontent.Text.Trim();
string AddTime = addtime.Text.Trim();
sl.InsertCalendar(ID, Motif, Content, AddTime);
Response.Write("<script>alert('添加成功！');</script>");
Bind();
this.Motif.Text = "";
this.textcontent.Text = "";
addtime.Text = "";
}
}
public string SelectName()
{
string sql = "select Name from Employee where UserName='******'";
string Name = OperateDB.getExecuteScalar(sql);
return(Name);
}
protected void ok_Click(object sender, EventArgs e)
{
string sql = "select ShangTime from Checktime ";
DateTime shang = Convert.ToDateTime(OperateDB.getExecuteScalar(sql));
DateTime time = Convert.ToDateTime(DateTime.Now.ToString());
TimeSpan d = shang.TimeOfDay;
TimeSpan dd = time.TimeOfDay;
if (d > dd)
{
int i = 1;
int b = 0;
string Da = DateTime.Now.ToLongDateString();
string state = "考勤成功";
string id = Session["UserName"].ToString();
string Content = this.TextArea1.Value;
Response.Write("<script>alert('考勤成功！')</script>");
string sql1 = "insert into [Check] values('" + time.ToString() + "',null,'" + Da + "','" + id + "','" + state + "',null,'" + Content + "',null," + i + "," + b + ")";
OperateDB.ExecuteNonQuery(sql1);
Bind();
}
else
{
int i = 1;
int b = 0;
string Da = DateTime.Now.ToLongDateString();
string id = Session["UserName"].ToString();
string state = "迟到";
string Content = this.TextArea1.Value;
DateTime Time1 = DateTime.Now;
string sql2 = "insert into [Check] values('" + Time1.ToString() + "',null,'" + Da + "','" + id + "','" + state + "',null,'" + Content + "',null," + i + "," + b + ")";
OperateDB.ExecuteNonQuery(sql2);
Bind();
}
}
protected void ok1_Click(object sender, EventArgs e)
{
string sql = "select xiaTime from Checktime ";
DateTime xia = Convert.ToDateTime(OperateDB.getExecuteScalar(sql).ToString());
DateTime time = Convert.ToDateTime(DateTime.Now.ToString());
TimeSpan d = xia.TimeOfDay;
TimeSpan dd = time.TimeOfDay;
if (d > dd)
{
DateTime dt = DateTime.Now;
string Da = DateTime.Now.ToLongDateString();
string y = "早退";
string Whys = this.TextArea1.Value.Trim();
int s = 1;
int x = 1;
string sql1 = "update [Check] set offdutyTime='" + dt.ToString() + "',offdutystate='" + y + "',offwhys='" + Whys + "',shang=" + s + ",xia=" + x + " where username='******' and CheckDate='" + Da + "'";
OperateDB.ExecuteNonQuery(sql1);
Bind();
}
else
{
DateTime dt = DateTime.Now;
string Da = DateTime.Now.ToLongDateString();
string y = "成功考勤";
string Whys = this.TextArea1.Value.Trim();
int s = 1;
int x = 1;
string sql1 = "update [Check] set offdutyTime='" + dt.ToString() + "',offdutystate='" + y + "',offwhys='" + Whys + "',shang=" + s + ",xia=" + x + " where username='******' and CheckDate='" + Da + "'";
OperateDB.ExecuteNonQuery(sql1);
Bind();
}
}
protected void goout_Click(object sender, EventArgs e)
{
string strsql = "select Evectionid from Evection where rtime='未回'";
id = Convert.ToInt32(OperateDB.getExecuteScalar(strsql));
string add = this.add.Text;
if (string.IsNullOrEmpty(add))
{
Response.Write("<script>alert('请输入地点')</script>");
}
else
{
if (id != 0)
{
Response.Write("<script>alert('还没有回来登记！不能登记出差')</script>");
}
else
{
DateTime Da = DateTime.Now;
string sql = "insert into Evection values('" + add + "','" + Da + "','未回','" + this.TextArea1.Value + "','" + Session["UserName"].ToString() + "')";
id = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
Response.Write("<script>alert('出差登记成功！')</script>");
}
}
Bind();
}
public string useram()
{
NewsID = Convert.ToInt32(Request["NewsID"].ToString());
string sql = "select Name from Employee where Employeeid=(select UserID from News where NewsID=" + NewsID + ")";
return(OperateDB.getExecuteScalar(sql));
}
protected void comeback_Click(object sender, EventArgs e)
{
string strsql = "select OutRegisterid from OutRegister where ReturnTime='未归' and username='******'";
id = Convert.ToInt32(OperateDB.getExecuteScalar(strsql));
if (id == 0)
{
Response.Write("<script>alert('你还没有外出！')</script>");
}
else
{
DateTime dt = DateTime.Now;
string sql = "update OutRegister set returntime='" + dt.ToString() + "' where OutRegisterid='" + id + "'";
if (OperateDB.ExecuteNonQuery(sql) > 0)
{
Response.Write("<script>alert('回来登记成功！')</script>");
}
else
{
Response.Write("<script>alert('回来登记失败！')</script>");
}
}
Bind();
}
public string Name(string y)
{
int NewsID = Convert.ToInt32(Request["NewsID"].ToString());
string sql = "select Name from Employee where username='******'";
return(OperateDB.getExecuteScalar(sql));
}
public string SelectName()
{
int Meetingid = Convert.ToInt32(Request["Meetingid"].ToString());
string sql = "select Name from Employee where UserName=(select username from Meeting where Meetingid=" + Meetingid + " )";
string Name = OperateDB.getExecuteScalar(sql);
return(Name);
}
public string TypeName()
{
string Re = "";
int NewsID = Convert.ToInt32(Request["NewsID"].ToString());
string sql = "select type from NewsType where NTID=(select TypeId from news where NewsID=" + NewsID + ")";
return(Re = OperateDB.getExecuteScalar(sql));
}
private void Bind()
{
string sql = "select * from OutRegister where username='******'";
this.dt1.DataSource = OperateDB.ExecuteDataSet(sql);
dt1.DataBind();
string strsql = "select OutRegisterid from OutRegister where ReturnTime='未归' and username='******'";
id = Convert.ToInt32(OperateDB.getExecuteScalar(strsql));
}
private void Bind()
{
string sql = "select * from Leave where username='******'";
this.dt1.DataSource = OperateDB.ExecuteDataSet(sql);
dt1.DataBind();
string strsql = "select LeaveID from Leave where retrue='未回'";
id = Convert.ToInt32(OperateDB.getExecuteScalar(strsql));
}
private void Bind()
{
string UserName = Session["UserName"].ToString();
string sql = "select id from UserInfo where UserName='******'";
int id = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
string sql1 = "select * from Calendar where id=" + id + " order by CalendarID desc";
this.dt1.DataSource = OperateDB.ExecuteDataSet(sql1);
this.dt1.DataBind();
}
public static bool isadmin(string name)
{
string sql = string.Format(@"SELECT dutyid
FROM Userinfo
WHERE (UserName = '******')", name);
if (Convert.ToInt32(OperateDB.getExecuteScalar(sql)) > 4)
{
return(true);
}
else
{
return(false);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
log si = new log();
string title = this.titel.Text;
string content = this.content.Text;
int type = Convert.ToInt32(this.DropDownList1.SelectedItem.Value);
int remark = 1;
string sql = "select Employeeid from Employee where username='******'";
int userid = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
string strSql = "insert into News values(" + type + ",'" + title + "','" + content + "'," + remark + "," + userid + ",default)";
if (OperateDB.ExecuteNonQuery(strSql) > 0)
{
si.InsertWorkLog(Session["UserName"].ToString(), DateTime.Now.ToString(), "添加了标题为：" + title + "的新闻");
Response.Write("<script>alert('发布成功！');</script>");
this.titel.Text = "";
this.content.Text = "";
}
else
{
Response.Write("<script>alert('发布失败！');</script>");
}
}
protected void Button1_Command(object sender, CommandEventArgs e)
{
int sid = Convert.ToInt32(e.CommandArgument);
string sql = "select Appurtenance from Email where sid=" + sid + "";
string ss = OperateDB.getExecuteScalar(sql);
string[] a = ss.Split(';');
string url = "";
for (int i = 0; i < a.Length; i++)
{
string b = a[i];
url = Server.MapPath("~") + "\\upfiles\\" + b;
}
if (File.Exists(url))
{
File.Delete(url);
}
string sql1 = "delete from Email where sid=" + sid + "";
OperateDB.ExecuteNonQuery(sql1);
Bind(getsql());
}
protected void goout_Click(object sender, EventArgs e)
{
string strsql = "select LeaveID from Leave where retrue='未回'";
id = Convert.ToInt32(OperateDB.getExecuteScalar(strsql));
if (id != 0)
{
Response.Write("<script>alert('还没有回来登记！不能登记请假')</script>");
}
else
{
DateTime Da = DateTime.Now;
string sql = "insert into Leave values('" + Session["UserName"].ToString() + "','" + Da + "','未回','" + this.TextArea1.Value + "')";
id = Convert.ToInt32(OperateDB.getExecuteScalar(strsql));
Response.Write("<script>alert('外出登记成功！')</script>");
}
Bind();
}
protected void goout_Click(object sender, EventArgs e)
{
string strsql = "select OutRegisterid from OutRegister where ReturnTime='未归' and username='******'";
id = Convert.ToInt32(OperateDB.getExecuteScalar(strsql));
if (id != 0)
{
Response.Write("<script>alert('还没有回来登记！不能登记外出')</script>");
}
else
{
DateTime Da = DateTime.Now;
string sql = "insert into OutRegister values('" + Da.ToString() + "','未归','" + Session["UserName"].ToString() + "','" + this.TextArea1.Value + "','" + Da.ToLongDateString() + "');select @@IDENTITY AS ID;";
id = Convert.ToInt32(OperateDB.ExecuteNonQuery(sql));
Response.Write("<script>alert('外出登记成功！')</script>");
}
Bind();
}
protected void Button2_Click(object sender, EventArgs e)
{
if (drpFltype.SelectedIndex != 0 && !string.IsNullOrEmpty(drpFlow.SelectedItem.Text))
{
//插入申请
string sql;
string title = this.txtTitle.Text;
int urgent = Convert.ToInt32(this.drpUrgent.SelectedIndex);
int flowid = Convert.ToInt32(this.drpFlow.SelectedItem.Value);
Sqlselete ss = new Sqlselete();
int userid = Convert.ToInt32(ss.SelectEmpByUserName(Session["UserName"].ToString()));
//string FileName = this.FileUpload1.PostedFile.FileName;
string content = this.TextBox2.Text.ToString();
string src = "";
if (Request.QueryString["id"] != null)
{
sql = "update FlowDoc set Title='" + title + "',Content='" + content + "',IsSave=0";
if (OperateDB.ExecuteNonQuery(sql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
sql = "select top 1 Num from Path where FlowID=" + Convert.ToInt32(Request.QueryString["id"]) + " order by Num desc";
int approve = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
sql = "select Num from Path where UserID=" + userid;
int num = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
sql = "select * from Path where FlowID=" + flowid;
DataSet ds = OperateDB.ExecuteDataSet(sql);
//int result = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (Convert.ToInt32(dr["UserID"]) == userid)
{
string strSql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + Convert.ToInt32(Request.QueryString["id"]) + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
if (OperateDB.ExecuteNonQuery(strSql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
continue;
}
if (Convert.ToInt32(dr["Num"]) > num)
{
string strsql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + Convert.ToInt32(Request.QueryString["id"]) + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
if (OperateDB.ExecuteNonQuery(strsql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
}
}
}
else
{
if (!Directory.Exists(Server.MapPath(".") + "\\Files\\"))
{
Directory.CreateDirectory(Server.MapPath(".") + "\\Files\\");
}
if (FileUpload1.PostedFile.ContentLength == 0)
{
src = "";
}
else
{
string strFilePath = FileUpload1.PostedFile.FileName;
FileInfo fl = new FileInfo(strFilePath);
string Ext = fl.Name;
src = Ext;
string ServerPath = Server.MapPath(".");
string strSeraPath = ServerPath + "\\Files\\" + src;
FileUpload1.PostedFile.SaveAs(strSeraPath);
}
string strSql1 = "insert into FlowDoc values('" + title + "'," + urgent + "," + flowid + ",1," + userid + ",'" + content + "',default,1,0,'" + src + "')";
if (OperateDB.ExecuteNonQuery(strSql1) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
//插入申请审批路径
sql = "select top 1 ID from FlowDoc order by PubDate desc";
int docid = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
sql = "select top 1 Num from Path where FlowID=" + flowid + " order by Num desc";
int approve = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
sql = "select Num from Path where UserID=" + userid;
int num = Convert.ToInt32(OperateDB.getExecuteScalar(sql));//序号
sql = "select * from Path where FlowID=" + flowid;
DataSet ds = OperateDB.ExecuteDataSet(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (Convert.ToInt32(dr["UserID"]) == userid)
{
string strSql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + docid + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
if (OperateDB.ExecuteNonQuery(strSql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
continue;
}
if (Convert.ToInt32(dr["Num"]) > num)
{
string strsql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + docid + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
if (OperateDB.ExecuteNonQuery(strsql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
}
}
}
}
}
