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