public void Reload()
{
string strsql1 = "select id,会议时间,会议主题,纪要内容,落实措施,完成时间,落实情况,已完成,完成时间节点,批复,指示项附件名称,纪要上传人,纪要类型,关联责任人,考核绩效点 from tb_xiangxi where 完成责任人='" + yonghu + "'and 已完成=0";
gridControl1.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
gridView1.Columns["会议时间"].Caption = "创建时间";
gridView1.Columns["会议主题"].Caption = "来源";
gridView1.Columns["纪要上传人"].Visible = false;
gridView1.Columns["纪要类型"].Visible = false;
gridView1.Columns["id"].Visible = false;
string strsql2 = "select id,会议时间,会议主题,纪要内容,落实措施,完成时间,落实情况,已完成,完成时间节点,批复,指示项附件名称,考核绩效点,纪要类型,完成责任人,纪要上传人 from tb_xiangxi where 完成责任人='" + yonghu + "'and 已完成=1";
gridControl2.DataSource = SQLhelp.GetDataTable(strsql2, CommandType.Text);
gridView2.Columns["会议时间"].Caption = "创建时间";
gridView2.Columns["会议主题"].Caption = "来源";
gridView2.Columns["纪要上传人"].Visible = false;
gridView2.Columns["纪要类型"].Visible = false;
gridView2.Columns["id"].Visible = false;
gridView2.Columns["完成责任人"].Visible = false;
string strsql3 = "select id,会议时间,会议主题,纪要内容,落实措施,落实情况,完成时间,已完成,完成时间节点,批复,指示项附件名称,纪要上传人,纪要类型,关联责任人,完成责任人,更新,考核绩效点 from tb_xiangxi where 关联责任人='" + yonghu + "'";
gridControl3.DataSource = SQLhelp.GetDataTable(strsql3, CommandType.Text);
gridView3.Columns["会议时间"].Caption = "创建时间";
gridView3.Columns["会议主题"].Caption = "来源";
gridView3.Columns["纪要上传人"].Visible = false;
gridView3.Columns["纪要类型"].Visible = false;
gridView3.Columns["id"].Visible = false;
}
public static bool judgedepartment(string yonghu)
{
bool flag = false;
version version = new version();
string sql = "select * from tb_update";
DataTable dt = SQLhelp.GetDataTable(sql, CommandType.Text);
string sql1 = "select * from tb_operator where 用户名 = '" + yonghu + "'";
DataTable dt1 = SQLhelp.GetDataTable(sql1, CommandType.Text);
string 务器版本号 = version.getversion("zttogffice");
string 版本号 = dt.Rows[0]["版本号"].ToString();
string 部门 = dt.Rows[0]["部门"].ToString();
string 人员 = dt.Rows[0]["人员"].ToString();
if (务器版本号.Equals(版本号))
{
if (部门.Contains(dt1.Rows[0]["部门"].ToString()))
{
flag = true;
}
if (人员.Contains(yonghu))
{
flag = true;
}
}
if (部门.Equals("全员"))
{
flag = true;
}
return(flag);
}
private void FrShangchuan_Load(object sender, EventArgs e)
{
string sql1 = "select 纪要内容,完成责任人 from tb_jjiyaoneirong";
gridControl1.DataSource = SQLhelp.GetDataTable(sql1, CommandType.Text);
string sql8 = "select 用户名 from tb_operator ";
DataTable dtttt = SQLhelp.GetDataTable(sql8, CommandType.Text);
List <string> spaceminute = new List <string>();
for (int i = 0; i < dtttt.Rows.Count; i++)
{
string n = dtttt.Rows[i]["用户名"].ToString();
spaceminute.Add(n);
}
foreach (string s in spaceminute)
{
repositoryItemComboBox2.Items.Add(s);
}
string sql123 = "select 部门 from tb_bumen ";
DataTable daa = SQLhelp.GetDataTable(sql123, CommandType.Text);
List <string> spaceminute1 = new List <string>();
for (int i = 0; i < daa.Rows.Count; i++)
{
string n = daa.Rows[i]["部门"].ToString();
spaceminute1.Add(n);
}
foreach (string s in spaceminute1)
{
comboBoxEdit1.Properties.Items.Add(s);
}
}
public void Reload()
{
string strsql = "select 用户名,权限管理,部门,序号,报告组 from tb_operator ";
dataGridViewX2.DataSource = SQLhelp.GetDataTable(strsql, CommandType.Text);
}
public void Reload()
{
string sql = "select id,会议时间,会议主题,参会人员,纪要上传人,纪要类型 from tb_xiangxi where 纪要类型='会议' ";
DataTable dt1 = SQLhelp.GetDataTable(sql, CommandType.Text);
DataTable table = new DataTable();
//创建table的第一列
DataColumn priceColumn = new DataColumn();
//该列的数据类型
priceColumn.DataType = System.Type.GetType("System.String");
//该列得名称
priceColumn.ColumnName = "会议时间";
DataColumn taxColumn = new DataColumn();
taxColumn.DataType = System.Type.GetType("System.String");
taxColumn.ColumnName = "会议主题";
table.Columns.Add(priceColumn);
table.Columns.Add(taxColumn);
for (int i = 0; i < dt1.Rows.Count; i++)
{
string panduan1 = dt1.Rows[i]["纪要类型"].ToString();
if (panduan1 == "会议")
{
string str = dt1.Rows[i]["参会人员"].ToString();
//正则表达式
Match m;
Regex r = new Regex(yonghu);
m = r.Match(str);
string panduan = m.ToString();
if (panduan != "")
{
DataRow dr = table.NewRow();
string huiyishijian1 = dt1.Rows[i]["会议时间"].ToString();
string huiyizhuti1 = dt1.Rows[i]["会议主题"].ToString();
if (huiyizhuti != huiyizhuti1)
{
huiyizhuti = huiyizhuti1;
dr["会议时间"] = dt1.Rows[i]["会议时间"].ToString();
dr["会议主题"] = dt1.Rows[i]["会议主题"].ToString();
table.Rows.Add(dr);
}
}
}
}
//个人的绑定
}
private void FrPresentation_Load(object sender, EventArgs e)
{
string sql = "select 用户名,部门,序号 from tb_operator where 用户名='" + yonghu + "'";
DataTable jieguo = SQLhelp.GetDataTable(sql, CommandType.Text);
bumen = jieguo.Rows[0]["部门"].ToString();
bianhao = jieguo.Rows[0]["序号"].ToString();
string sql1 = "select 部门 from tb_bumen";
DataTable aaaa = SQLhelp.GetDataTable(sql1, CommandType.Text);
List <string> spaceminute = new List <string>();
for (int i = 0; i < aaaa.Rows.Count; i++)
{
string n = aaaa.Rows[i]["部门"].ToString();
spaceminute.Add(n);
}
foreach (string s in spaceminute)
{
comboBoxEx1.Items.Add(s);
}
}
private void Form1_Load(object sender, EventArgs e)
{
String versionlocal = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
label3.Text = versionlocal;
version version = new version();
getData getData = new getData();
getData.getiprouter();
//if (version.judgeversion(versionlocal) == true)
//{
// this.Close();
// downloadexe downloadexe = new downloadexe();
// downloadexe.Show();
//}
//else
//{
System.Diagnostics.Process[] myProcesses = System.Diagnostics.Process.GetProcessesByName("ztoffice"); //获取指定的进程名
if (myProcesses.Length > 1) //如果可以获取到知道的进程名则说明已经启动
{
MessageBox.Show("程序已启动！");
Application.Exit(); //关闭系统
}
this.txtZerenren1.Text = Properties.Settings.Default.name;
bool flag = Properties.Settings.Default.isrem;
if (flag)
{
string sql_pass = "******" + txtZerenren1.Text.Trim() + "'";
String password = Convert.ToString(SQLhelp.ExecuteScalar(sql_pass, CommandType.Text));
this.checkbox1.Checked = true;
this.txtPwd.Text = password;
}
string sql = "select 用户名 from tb_operator";
DataTable aaaa = SQLhelp.GetDataTable(sql, CommandType.Text);
List <string> spaceminute = new List <string>();
for (int i = 0; i < aaaa.Rows.Count; i++)
{
string n = aaaa.Rows[i]["用户名"].ToString();
spaceminute.Add(n);
}
foreach (string s in spaceminute)
{
//comboBox1.Items.Add(s);
}
//}
}
private void buttonX2_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确认提交吗？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
string quorysql = "select * from tb_xiangxi where id='" + id + "'";
DataTable dt1 = SQLhelp.GetDataTable(quorysql, CommandType.Text);
string 纪要内容 = dt1.Rows[0]["纪要内容"].ToString();
string 纪要类型 = dt1.Rows[0]["纪要类型"].ToString();
string shangchuanren = dt1.Rows[0]["纪要上传人"].ToString();
//string message = 纪要类型+"纪要内容:" + 纪要内容 + ","+yonghu+"已回复,请查看";
//NetWork3J NetWork3J = new NetWork3J(yonghu, "http://" + MyGlobal.ip + ":81/");
//NetWork3J.sendmessageById(shangchuanren, message);
try
{
if (txtName.Text != "")
{
DateTime shijian = DateTime.Now;
string sql1 = "insert into tb_huiyi (落实措施,落实情况,定位,创建人,创建时间,附件格式,附件名称,附件) values('" + txtluoshicuoshi.Text + "','" + txtluoshiqingkuang.Text + "','" + id + "','" + yonghu + "','" + shijian + "','" + fileType + "','" + fileName + "',@pic)";
SQLhelp.ExecuteNonquery(sql1, CommandType.Text, files);
string sql2 = "Select id from tb_huiyi where 落实措施='" + txtluoshicuoshi.Text + "' and 落实情况='" + txtluoshiqingkuang.Text + "' and 创建人='" + yonghu + "' and 创建时间='" + shijian + "'";
SQLhelp.ExecuteScalar(sql2, CommandType.Text);
string sql = "update tb_xiangxi set 落实措施='" + txtluoshicuoshi.Text + "',落实情况='" + txtluoshiqingkuang.Text + "',更新='有更新！' where id='" + id + "'";
SQLhelp.ExecuteScalar(sql, CommandType.Text);
MessageBox.Show("提交成功！", "软件提示");
DialogResult = DialogResult.OK;
this.Close();
}
if (txtName.Text == "")
{
DateTime shijian = DateTime.Now;
string sql1 = "insert into tb_huiyi (落实措施,落实情况,定位,创建人,创建时间) values('" + txtluoshicuoshi.Text + "','" + txtluoshiqingkuang.Text + "','" + id + "','" + yonghu + "','" + shijian + "')";
SQLhelp.ExecuteScalar(sql1, CommandType.Text);
string sql = "update tb_xiangxi set 落实措施='" + txtluoshicuoshi.Text + "',落实情况='" + txtluoshiqingkuang.Text + "',更新='有更新！' where id='" + id + "'";
SQLhelp.ExecuteScalar(sql, CommandType.Text);
MessageBox.Show("提交成功！", "软件提示");
DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("提交 " + fileName + " 时候发生了 " + ex.Message);
}
}
}
private void FrShangchuan_Load(object sender, EventArgs e)
{
string sql = "select 部门 from tb_bumen";
DataTable aaaa = SQLhelp.GetDataTable(sql, CommandType.Text);
List <string> spaceminute = new List <string>();
for (int i = 0; i < aaaa.Rows.Count; i++)
{
string n = aaaa.Rows[i]["部门"].ToString();
spaceminute.Add(n);
}
foreach (string s in spaceminute)
{
comboBox1.Items.Add(s);
}
DataGridViewComboBoxExColumn column = new DataGridViewComboBoxExColumn();
column.Name = "完成责任人";
column.DataPropertyName = "用户名";
column.HeaderText = "完成责任人";
column.DropDownStyle = ComboBoxStyle.DropDownList;
this.dataGridViewX1.Columns.Add(column);
string sql1 = "select 用户名 from tb_operator";
DataTable aaaaa = SQLhelp.GetDataTable(sql1, CommandType.Text);
List <string> spaceminute1 = new List <string>();
for (int i = 0; i < aaaaa.Rows.Count; i++)
{
string n = aaaaa.Rows[i]["用户名"].ToString();
spaceminute1.Add(n);
}
foreach (string s in spaceminute1)
{
column.Items.Add(s);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (comboBoxEdit1.SelectedIndex == -1)
{
MessageBox.Show("请先选择部门！");
}
string sql = "select 用户名 from tb_operator where 部门='" + comboBoxEdit1.Text + "'";
DataTable aaaa = SQLhelp.GetDataTable(sql, CommandType.Text);
List <string> spaceminute = new List <string>();
for (int i = 0; i < aaaa.Rows.Count; i++)
{
string n = aaaa.Rows[i]["用户名"].ToString();
spaceminute.Add(n);
}
foreach (string s in spaceminute)
{
textBox1.Text += s + ";";
}
}
private void FrAppointment_Load(object sender, EventArgs e)
{
string sql = "select 部门 from tb_bumen";
DataTable aaaa = SQLhelp.GetDataTable(sql, CommandType.Text);
List <string> spaceminute = new List <string>();
for (int i = 0; i < aaaa.Rows.Count; i++)
{
string n = aaaa.Rows[i]["部门"].ToString();
spaceminute.Add(n);
}
foreach (string s in spaceminute)
{
comboBoxEdit1.Properties.Items.Add(s);
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox2.Items.Clear();
string sql = "select 用户名 from tb_operator where 部门='" + comboBox1.Text + "'";
DataTable aaaa = SQLhelp.GetDataTable(sql, CommandType.Text);
List <string> spaceminute = new List <string>();
for (int i = 0; i < aaaa.Rows.Count; i++)
{
string n = aaaa.Rows[i]["用户名"].ToString();
spaceminute.Add(n);
}
foreach (string s in spaceminute)
{
comboBox2.Items.Add(s);
}
}
public void reload2()
{
if (yonghu == "桑甜")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,完成时间,已完成,完成时间节点,考核绩效点 from tb_xiangxi where 已完成=1 and 纪要类型='指示项' ";
dataGridViewX3.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "聂燕")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,完成时间,已完成,完成时间节点,考核绩效点 from tb_xiangxi where 已完成=1 and 纪要类型='指示项' ";
dataGridViewX3.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "庄卫星")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,完成时间,已完成,完成时间节点,考核绩效点 from tb_xiangxi where 已完成=1 and 纪要类型='指示项' ";
dataGridViewX3.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "赵蕾蕾")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,完成时间,已完成 ,完成时间节点,考核绩效点 from tb_xiangxi where 已完成=1 and 纪要类型='指示项' ";
dataGridViewX3.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "徐魏巍")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,完成时间,已完成,完成时间节点,考核绩效点 from tb_xiangxi where 已完成=1 and 纪要类型='指示项' ";
dataGridViewX3.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "蔡红兵")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,完成时间,已完成,完成时间节点,考核绩效点 from tb_xiangxi where 已完成=1 and 纪要类型='指示项' ";
dataGridViewX3.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "钱陆亦")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,完成时间,已完成,完成时间节点,考核绩效点 from tb_xiangxi where 已完成=1 and 纪要类型='指示项' ";
dataGridViewX3.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
string chaxun = toolchaxun.Text;
string sql = " SELECT 员工姓名,报告类型,提交时间,员工备注,批复,报告标题,编号,接收人 from tb_wenjian where 员工姓名 = '" + TextBox1 + "'";
DataTable dt = SQLhelp.GetDataTable(sql, CommandType.Text);
DataTable table = new DataTable();
//创建table的第一列
DataColumn priceColumn = new DataColumn();
//该列的数据类型
priceColumn.DataType = System.Type.GetType("System.String");
//该列得名称
priceColumn.ColumnName = "员工姓名";
DataColumn taxColumn = new DataColumn();
taxColumn.DataType = System.Type.GetType("System.String");
//列名
taxColumn.ColumnName = "报告类型";
DataColumn taxColumn1 = new DataColumn();
taxColumn1.DataType = System.Type.GetType("System.String");
//列名
taxColumn1.ColumnName = "提交时间";
DataColumn taxColumn2 = new DataColumn();
taxColumn2.DataType = System.Type.GetType("System.String");
//列名
taxColumn2.ColumnName = "员工备注";
DataColumn taxColumn3 = new DataColumn();
taxColumn3.DataType = System.Type.GetType("System.String");
//列名
taxColumn3.ColumnName = "批复";
DataColumn taxColumn4 = new DataColumn();
taxColumn4.DataType = System.Type.GetType("System.String");
//列名
taxColumn4.ColumnName = "报告标题";
DataColumn taxColumn5 = new DataColumn();
taxColumn5.DataType = System.Type.GetType("System.String");
//列名
taxColumn5.ColumnName = "编号";
table.Columns.Add(priceColumn);
table.Columns.Add(taxColumn);
table.Columns.Add(taxColumn1);
table.Columns.Add(taxColumn2);
table.Columns.Add(taxColumn3);
table.Columns.Add(taxColumn4);
table.Columns.Add(taxColumn5);
for (int i = 0; i < dt.Rows.Count; i++)
{
//string str = dt.Rows[i]["接收人"].ToString();
////正则表达式
//Match m;
//Regex r = new Regex(yonghu);
//m = r.Match(str);
//string panduan = m.ToString();
//if (panduan != "")
//{
DataRow dr = table.NewRow();
dr["员工姓名"] = dt.Rows[i]["员工姓名"].ToString();
dr["报告类型"] = dt.Rows[i]["报告类型"].ToString();
dr["提交时间"] = dt.Rows[i]["提交时间"].ToString();
dr["员工备注"] = dt.Rows[i]["员工备注"].ToString();
dr["批复"] = dt.Rows[i]["批复"].ToString();
dr["报告标题"] = dt.Rows[i]["报告标题"].ToString();
dr["编号"] = dt.Rows[i]["编号"].ToString();
table.Rows.Add(dr);
//}
}
//个人的绑定
gridControl2.DataSource = table;
}
public void Reload()
{
string strsql = "select 会议时间,会议主题,主持人,记录人,参会人员 from tb_xiangxi where 会议时间='" + shijian + "' ";
DataTable dt = SQLhelp.GetDataTable(strsql, CommandType.Text);
for (int i = 0; i < dt.Rows.Count; i++)
{
textshijian.Text = dt.Rows[i]["会议时间"].ToString();
txtcanhuirenyuan.Text = dt.Rows[i]["参会人员"].ToString();
textjiluren.Text = dt.Rows[i]["记录人"].ToString();
textzhuchiren.Text = dt.Rows[i]["主持人"].ToString();
textzhuti.Text = dt.Rows[i]["会议主题"].ToString();
}
string sql1 = "select id,会议时间,纪要内容,完成责任人,落实措施,完成时间,落实情况,已查看,已完成,完成时间节点,考核绩效点,更新,纪要上传人,批复 from tb_xiangxi where 会议时间='" + shijian + "'";
DataTable dt1 = SQLhelp.GetDataTable(sql1, CommandType.Text);
string wanchengshijian = DateTime.Now.ToString();
DateTime zuizhong = DateTime.Now;
for (int i = 0; i < dt1.Rows.Count; i++)
{
string jiedan = dt1.Rows[i]["完成时间节点"].ToString();
string yiwancheng = dt1.Rows[i]["已完成"].ToString();
if (yiwancheng != "1")
{
if (jiedan != "")
{
DateTime kaishi = Convert.ToDateTime(dt1.Rows[i]["会议时间"]);
DateTime jieshu = Convert.ToDateTime(dt1.Rows[i]["完成时间节点"]);
string kaishi1 = Convert.ToDateTime(dt1.Rows[i]["会议时间"]).ToString("yyyy - MM - dd");
string jieshu1 = Convert.ToDateTime(dt1.Rows[i]["完成时间节点"]).ToString("yyyy - MM - dd");
string zerenren = dt1.Rows[i]["完成责任人"].ToString();
string neirong = dt1.Rows[i]["纪要内容"].ToString();
string shijian = dt1.Rows[i]["会议时间"].ToString();
if (jieshu1 != kaishi1)
{
if (zuizhong < jieshu)
{
string xiugai = "update tb_xiangxi set 考核绩效点=0 Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "' and 纪要内容='" + neirong + "'";
SQLhelp.ExecuteScalar(xiugai, CommandType.Text);
}
if (zuizhong > jieshu)
{
TimeSpan shijianshu = zuizhong - jieshu;
int shuliang = Convert.ToInt32(shijianshu.TotalDays - 0.5);
int shuliang1 = (Convert.ToInt32((shuliang / 7)) + 1) * 2;
string xiugai = "update tb_xiangxi set 考核绩效点='" + shuliang1 + "' Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "' and 纪要内容='" + neirong + "'";
SQLhelp.ExecuteScalar(xiugai, CommandType.Text);
}
}
if (jieshu1 == kaishi1)
{
string xiugai = "update tb_xiangxi set 考核绩效点=0 Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "' and 纪要内容='" + neirong + "'";
SQLhelp.ExecuteScalar(xiugai, CommandType.Text);
}
}
}
}
gridControl1.DataSource = dt1;
}
public void Reload3()
{
string sql = "select id,会议时间,会议主题,纪要内容,完成责任人,落实措施,完成时间,落实情况,考核绩效点,已完成 from tb_xiangxi where 纪要类型='会议' and 已完成=1";
dataGridViewX4.DataSource = SQLhelp.GetDataTable(sql, CommandType.Text);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtZerenren1.Text.Trim()))
{
MessageBox.Show("登录用户不许为空！", "软件提示");
return;
}
if (String.IsNullOrEmpty(txtPwd.Text))
{
MessageBox.Show("登录密码不许为空！", "软件提示");
txtPwd.Focus();
return;
}
//用户编码不重复
string strSql = "select * from tb_operator where 用户名 = '" + txtZerenren1.Text.Trim() + "'";
if (Convert.ToString(SQLhelp.ExecuteScalar(strSql, CommandType.Text)) == "")
{
MessageBox.Show("登录用户不正确！", "软件提示");
return;
}
try
{
DataTable dt = SQLhelp.GetDataTable(strSql, CommandType.Text);
DataRow dr = dt.Rows[0];
string a = dt.Rows[0]["用户名"].ToString(); //用户名
string ce = dt.Rows[0]["密码"].ToString();
if (txtPwd.Text != dt.Rows[0]["密码"].ToString()) //若密码不相同
{
MessageBox.Show("登录密码不正确！", "软件提示");
txtPwd.Focus();
}
else
{
String Triton = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
version version = new version();
if (version.pluto(Triton, "zttoffice") && judgedepartment(a))
{
downloadexe downloadexe = new downloadexe();
downloadexe.ShowDialog();
this.Close();
}
else if (version.pluto1(Triton))
{
version.setprocess();
}
else
{
BonusSkins.Register();
SkinManager.EnableFormSkins();
UserLookAndFeel.Default.SetSkinStyle("Office 2010 Blue"); // 设置皮肤样式
getdevice getdevice = new getdevice();
getData getData = new getData();
//string s = Convert.ToDateTime(getData.getservertime());
Dictionary <string, string> dty = getdevice.getdevice1();
//getdevice.readdata(dt.Rows[0]["用户名"].ToString());
string sql = "insert into tb_denglu (登录人,登录时间,mac号,cpuid,硬盘序号,操作系统,内外网,公网ip,内网ip,显卡信息,机子类型,版本号) values('" + dt.Rows[0]["用户名"].ToString() + "','" + Convert.ToDateTime(getData.getservertime())
+ "','" + dty["mac号"] + "','" + dty["cpuid"] + "','" + dty["硬盘序号"] + "','" + dty["操作系统"] + "','" + dty["内外网"] + "','" + dty["公网ip"] + "','" + dty["内网ip"] + "','" + dty["显卡信息"] + "','" + dty["机子类型"] + "','" + Triton + "')";
xiangmusql.ExecuteScalar(sql, CommandType.Text);
aa.yonghu = dt.Rows[0]["用户名"].ToString();
Properties.Settings.Default.isrem = this.checkbox1.Checked;
Properties.Settings.Default.name = this.txtZerenren1.Text;
Properties.Settings.Default.Save();
byte[] byData = new byte[100];
char[] charData = new char[1000];
FileStream file = new FileStream(Application.StartupPath + "\\提示.txt", FileMode.Open);
file.Seek(0, SeekOrigin.Begin);
file.Read(byData, 0, 100);
Decoder d = Encoding.Default.GetDecoder();
d.GetChars(byData, 0, byData.Length, charData, 0);
file.Close();
FileStream fs = new FileStream(Application.StartupPath + "\\提示.txt", FileMode.Open);
//获得字节数组
byte[] data = System.Text.Encoding.Default.GetBytes("1");
//开始写入
fs.Write(data, 0, data.Length);
//清空缓冲区、关闭流
fs.Flush();
fs.Close();
if (charData[0].ToString() == "0")
{
Frtishi form1 = new Frtishi();
form1.yonghu = dt.Rows[0]["用户名"].ToString();
form1.Show();
this.Hide();
}
string sql3 = "select mac号 from tb_mac where mac号='" + dty["mac号"] + "'";
DataTable dt1 = xiangmusql.GetDataTable(sql3, CommandType.Text);
if (dt1.Rows.Count < 1)
{
Frtishi1 Frtishi1 = new Frtishi1(dty["mac号"]);
Frtishi1.ShowDialog();
}
else
{
if (charData[0].ToString() == "1")
{
aa.Show();
this.Hide();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
}
}
public void reload1()
{
if (yonghu == "桑甜")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,更新,是否有回复,完成时间节点,考核绩效点,关联责任人,指示项附件名称 from tb_xiangxi where 已完成=0 and 纪要类型='指示项' ";
dataGridViewX1.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "聂燕")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,更新,是否有回复,完成时间节点,考核绩效点,关联责任人,指示项附件名称 from tb_xiangxi where 已完成=0 and 纪要类型='指示项' ";
dataGridViewX1.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "庄卫星")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,更新,是否有回复,完成时间节点,考核绩效点,关联责任人,指示项附件名称 from tb_xiangxi where 已完成=0 and 纪要类型='指示项' ";;
dataGridViewX1.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "赵蕾蕾")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,更新,是否有回复,完成时间节点,考核绩效点,关联责任人,指示项附件名称 from tb_xiangxi where 已完成=0 and 纪要类型='指示项' ";
dataGridViewX1.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "徐魏巍")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,更新,是否有回复,完成时间节点,考核绩效点,关联责任人,指示项附件名称 from tb_xiangxi where 已完成=0 and 纪要类型='指示项' ";
dataGridViewX1.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "蔡红兵")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,更新,是否有回复,完成时间节点,考核绩效点,关联责任人,指示项附件名称 from tb_xiangxi where 已完成=0 and 纪要类型='指示项' ";
dataGridViewX1.DataSource = SQLhelp.GetDataTable(strsql1, CommandType.Text);
}
if (yonghu == "钱陆亦")
{
string strsql1 = "select id,会议时间,纪要内容,批复,纪要上传人,完成责任人,更新,是否有回复,完成时间节点,考核绩效点,关联责任人,指示项附件名称 from tb_xiangxi where 已完成=0 and 纪要类型='指示项' ";
DataTable dt = SQLhelp.GetDataTable(strsql1, CommandType.Text);
string wanchengshijian = DateTime.Now.ToString();
DateTime zuizhong = DateTime.Now;
for (int i = 0; i < dt.Rows.Count; i++)
{
string jiedan = dt.Rows[i]["完成时间节点"].ToString();
if (jiedan != "")
{
DateTime kaishi = Convert.ToDateTime(dt.Rows[i]["会议时间"]);
DateTime jieshu = Convert.ToDateTime(dt.Rows[i]["完成时间节点"]);
string kaishi1 = Convert.ToDateTime(DateTime.Now).ToString("yyyy - MM - dd");
string jieshu1 = Convert.ToDateTime(dt.Rows[i]["完成时间节点"]).ToString("yyyy - MM - dd");
string zerenren = dt.Rows[i]["完成责任人"].ToString();
string neirong = dt.Rows[i]["纪要内容"].ToString();
string shijian = dt.Rows[i]["会议时间"].ToString();
if (jieshu1 != kaishi1)
{
if (zuizhong < jieshu)
{
string xiugai = "update tb_xiangxi set 考核绩效点=0 Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "' and 纪要内容='" + neirong + "'";
SQLhelp.ExecuteScalar(xiugai, CommandType.Text);
}
if (zuizhong > jieshu)
{
TimeSpan shijianshu = zuizhong - jieshu;
int shuliang = Convert.ToInt32(shijianshu.TotalDays - 0.5);
int shuliang1 = (Convert.ToInt32((shuliang / 7)) + 1) * 2;
string xiugai = "update tb_xiangxi set 考核绩效点='" + shuliang1 + "' Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "' and 纪要内容='" + neirong + "'";
SQLhelp.ExecuteScalar(xiugai, CommandType.Text);
}
}
if (jieshu1 == kaishi1)
{
string xiugai = "update tb_xiangxi set 考核绩效点=0 Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "' and 纪要内容='" + neirong + "'";
SQLhelp.ExecuteScalar(xiugai, CommandType.Text);
}
}
}
dataGridViewX1.DataSource = dt;
}
}
private void FrService_Load(object sender, EventArgs e)
{
string sql = "select 公告标题,公告人,公告时间 from tb_gonggao where 公告类型='公告' order by 公告时间 desc ";
DataTable dt = SQLhelp.GetDataTable(sql, CommandType.Text);
dataGridViewX1.DataSource = dt;
string sql1 = "select 公告标题,公告人,公告时间,公告接收人 from tb_gonggao where 公告类型='选择型' order by 公告时间 desc ";
DataTable dt1 = SQLhelp.GetDataTable(sql1, CommandType.Text);
DataTable table = new DataTable();
//创建table的第一列
DataColumn priceColumn = new DataColumn();
//该列的数据类型
priceColumn.DataType = System.Type.GetType("System.String");
//该列得名称
priceColumn.ColumnName = "公告标题";
DataColumn taxColumn = new DataColumn();
taxColumn.DataType = System.Type.GetType("System.String");
//列名
taxColumn.ColumnName = "公告人";
DataColumn taxColumn1 = new DataColumn();
taxColumn1.DataType = System.Type.GetType("System.String");
//列名
taxColumn1.ColumnName = "公告时间";
table.Columns.Add(priceColumn);
table.Columns.Add(taxColumn);
table.Columns.Add(taxColumn1);
for (int i = 0; i < dt1.Rows.Count; i++)
{
string str = dt1.Rows[i]["公告接收人"].ToString();
//正则表达式
Match m;
Regex r = new Regex(yonghu);
m = r.Match(str);
string panduan = m.ToString();
if (panduan != "")
{
DataRow dr = table.NewRow();
string a = dt1.Rows[i]["公告标题"].ToString();
dr["公告标题"] = dt1.Rows[i]["公告标题"].ToString();
dr["公告人"] = dt1.Rows[i]["公告人"].ToString();
dr["公告时间"] = dt1.Rows[i]["公告时间"].ToString();
table.Rows.Add(dr);
}
}
//个人的绑定
dataGridViewX3.DataSource = table;
string sql11 = "select 公告标题,公告人,公告时间 from tb_gonggao where 公告类型='人力' order by 公告时间 desc ";
dataGridViewX2.DataSource = SQLhelp.GetDataTable(sql11, CommandType.Text);
}
//public void Reload()
//{
// string sql = "select 编号,员工姓名,报告类型,提交时间,员工备注,批复,报告标题,附件名称 from tb_wenjian where 员工姓名='" + yonghu + "'";
// DataTable baobiao = SQLhelp.GetDataTable(sql, CommandType.Text);
// gridControl1.DataSource = baobiao;
//}
public void Reload()
{
DateTime dangqian = DateTime.Now;
DateTime bangeyue = dangqian.AddDays(-7);
string sql = "select 员工姓名,报告类型,提交时间,员工备注,附件名称,批复,报告标题,编号,接收人 from tb_wenjian where 提交时间>'" + bangeyue + "' order by 提交时间 desc ";
DataTable dt = SQLhelp.GetDataTable(sql, CommandType.Text);
DataTable table = new DataTable();
//创建table的第一列
DataColumn priceColumn = new DataColumn();
//该列的数据类型
priceColumn.DataType = System.Type.GetType("System.String");
//该列得名称
priceColumn.ColumnName = "员工姓名";
DataColumn taxColumn = new DataColumn();
taxColumn.DataType = System.Type.GetType("System.String");
//列名
taxColumn.ColumnName = "报告类型";
DataColumn taxColumn1 = new DataColumn();
taxColumn1.DataType = System.Type.GetType("System.String");
//列名
taxColumn1.ColumnName = "提交时间";
DataColumn taxColumn2 = new DataColumn();
taxColumn2.DataType = System.Type.GetType("System.String");
//列名
taxColumn2.ColumnName = "员工备注";
DataColumn taxColumn3 = new DataColumn();
taxColumn3.DataType = System.Type.GetType("System.String");
//列名
taxColumn3.ColumnName = "批复";
DataColumn taxColumn4 = new DataColumn();
taxColumn4.DataType = System.Type.GetType("System.String");
//列名
taxColumn4.ColumnName = "报告标题";
DataColumn taxColumn5 = new DataColumn();
taxColumn5.DataType = System.Type.GetType("System.String");
//列名
taxColumn5.ColumnName = "编号";
DataColumn taxColumn6 = new DataColumn();
taxColumn6.DataType = System.Type.GetType("System.String");
//列名
taxColumn6.ColumnName = "附件名称";
table.Columns.Add(priceColumn);
table.Columns.Add(taxColumn);
table.Columns.Add(taxColumn1);
table.Columns.Add(taxColumn2);
table.Columns.Add(taxColumn3);
table.Columns.Add(taxColumn4);
table.Columns.Add(taxColumn5);
table.Columns.Add(taxColumn6);
for (int i = 0; i < dt.Rows.Count; i++)
{
string str = dt.Rows[i]["接收人"].ToString();
//正则表达式
Match m;
Regex r = new Regex(yonghu);
m = r.Match(str);
string panduan = m.ToString();
if (panduan != "")
{
DataRow dr = table.NewRow();
dr["员工姓名"] = dt.Rows[i]["员工姓名"].ToString();
dr["报告类型"] = dt.Rows[i]["报告类型"].ToString();
dr["提交时间"] = dt.Rows[i]["提交时间"].ToString();
dr["员工备注"] = dt.Rows[i]["员工备注"].ToString();
dr["批复"] = dt.Rows[i]["批复"].ToString();
dr["报告标题"] = dt.Rows[i]["报告标题"].ToString();
dr["编号"] = dt.Rows[i]["编号"].ToString();
dr["附件名称"] = dt.Rows[i]["附件名称"].ToString();
table.Rows.Add(dr);
}
}
//个人的绑定
gridControl1.DataSource = table;
}
private void toolStripButton1_Click_1(object sender, EventArgs e)
{
if (yonghu == "桑甜" || yonghu == "聂燕" || yonghu == "庄卫星" || yonghu == "赵蕾蕾")
{
string sql = "select 员工姓名,报告类型,提交时间,员工备注,批复,报告标题,编号,接收人 from tb_wenjian order by 提交时间 desc ";
DataTable dt = SQLhelp.GetDataTable(sql, CommandType.Text);
DataTable table = new DataTable();
//创建table的第一列
DataColumn priceColumn = new DataColumn();
//该列的数据类型
priceColumn.DataType = System.Type.GetType("System.String");
//该列得名称
priceColumn.ColumnName = "员工姓名";
DataColumn taxColumn = new DataColumn();
taxColumn.DataType = System.Type.GetType("System.String");
//列名
taxColumn.ColumnName = "报告类型";
DataColumn taxColumn1 = new DataColumn();
taxColumn1.DataType = System.Type.GetType("System.String");
//列名
taxColumn1.ColumnName = "提交时间";
DataColumn taxColumn2 = new DataColumn();
taxColumn2.DataType = System.Type.GetType("System.String");
//列名
taxColumn2.ColumnName = "员工备注";
DataColumn taxColumn3 = new DataColumn();
taxColumn3.DataType = System.Type.GetType("System.String");
//列名
taxColumn3.ColumnName = "批复";
DataColumn taxColumn4 = new DataColumn();
taxColumn4.DataType = System.Type.GetType("System.String");
//列名
taxColumn4.ColumnName = "报告标题";
DataColumn taxColumn5 = new DataColumn();
taxColumn5.DataType = System.Type.GetType("System.String");
//列名
taxColumn5.ColumnName = "编号";
table.Columns.Add(priceColumn);
table.Columns.Add(taxColumn);
table.Columns.Add(taxColumn1);
table.Columns.Add(taxColumn2);
table.Columns.Add(taxColumn3);
table.Columns.Add(taxColumn4);
table.Columns.Add(taxColumn5);
for (int i = 0; i < dt.Rows.Count; i++)
{
string str = dt.Rows[i]["接收人"].ToString();
//正则表达式
Match m;
Regex r = new Regex(yonghu);
m = r.Match(str);
string panduan = m.ToString();
if (panduan != "")
{
DataRow dr = table.NewRow();
dr["员工姓名"] = dt.Rows[i]["员工姓名"].ToString();
dr["报告类型"] = dt.Rows[i]["报告类型"].ToString();
dr["提交时间"] = dt.Rows[i]["提交时间"].ToString();
dr["员工备注"] = dt.Rows[i]["员工备注"].ToString();
dr["批复"] = dt.Rows[i]["批复"].ToString();
dr["报告标题"] = dt.Rows[i]["报告标题"].ToString();
dr["编号"] = dt.Rows[i]["编号"].ToString();
table.Rows.Add(dr);
}
}
//个人的绑定
gridControl2.DataSource = table;
}
}
private void btntijiao_Click(object sender, EventArgs e)
{
if (dateEdit2.DateTime <= dateEdit1.DateTime)
{
MessageBox.Show("请重新设置时间！");
return;
}
if (comboBoxEdit1.SelectedIndex == -1)
{
MessageBox.Show("请选择部门！");
return;
}
if (textBox1.Text == "")
{
MessageBox.Show("请选择人员！");
return;
}
if (comboBoxEdit3.SelectedIndex == -1)
{
MessageBox.Show("请选择会议室！");
return;
}
if (textBox2.Text == "")
{
MessageBox.Show("请输入会议室主题！");
return;
}
TimeSpan time = dateEdit2.DateTime - dateEdit1.DateTime;
int xiaoshi = (int)time.TotalHours;
if (xiaoshi > 14)
{
MessageBox.Show("时间设定过长！");
return;
}
string sql1 = "select * from tb_huiyishi where 预约会议室='" + comboBoxEdit3.Text + "'";
DataTable table = SQLhelp.GetDataTable(sql1, CommandType.Text);
for (int i = 0; i < table.Rows.Count; i++)
{
DateTime kaishi = Convert.ToDateTime(table.Rows[i]["预约开始时间"]);
DateTime jieshu = Convert.ToDateTime(table.Rows[i]["预约结束时间"]);
if (dateEdit1.DateTime < jieshu && dateEdit2.DateTime > kaishi || dateEdit1.DateTime > kaishi && dateEdit2.DateTime < jieshu || dateEdit1.DateTime < kaishi && dateEdit2.DateTime > jieshu)
{
MessageBox.Show("预约时间有重叠！");
return;
}
}
if (MessageBox.Show("确认提交吗？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
string sql = "insert into tb_huiyishi (预约会议室,预约人员,预约开始时间,预约结束时间,会议室主题) values('" + comboBoxEdit3.Text + "','" + textBox1.Text + "','" + dateEdit1.DateTime + "','" + dateEdit2.DateTime + "','" + textBox2.Text + "')";
SQLhelp.ExecuteScalar(sql, CommandType.Text);
MessageBox.Show("预约成功！");
this.Close();
DialogResult = DialogResult.OK;
}
}
