private void timer3_Tick(object sender, EventArgs e)
{
if (yonghu == "袁天坤")
{
string sql1 = "select id,接单编号,机修件ERP,客户名称,部门,工件名称,加工内容,计量单位,机修件数量,接单日期,预交时间,联系人,责任人,加工单位备注,当前状态,合同号,供方名称,附件名称 from tb_caigouliaodan where 加工单位备注='自制' and 完成='机修待审批' and 当前状态='待责任人审核' order by 接单日期";
DataTable dt = SQLhelp.GetDataTablexiangmuguanli(sql1, CommandType.Text);
if (dt.Columns.Count > 0)
{
MessageBox.Show("有自制机修件待审批");
}
}
else if (yonghu == "袁鹏")
{
string sql1 = "select id,接单编号,机修件ERP,客户名称,部门,工件名称,加工内容,计量单位,机修件数量,接单日期,预交时间,联系人,责任人,加工单位备注,当前状态,合同号,供方名称,附件名称 from tb_caigouliaodan where 加工单位备注='自制' and 完成='机修待审批' and 当前状态='机修待袁鹏审批' order by 接单日期";
DataTable dt = SQLhelp.GetDataTablexiangmuguanli(sql1, CommandType.Text);
if (dt.Rows.Count > 0)
{
MessageBox.Show("有自制机修件待审批");
}
}
else if (yonghu == "于嘉嘉")
{
string sql1 = "select id,接单编号,机修件ERP,客户名称,部门,工件名称,加工内容,计量单位,机修件数量,接单日期,预交时间,联系人,责任人,加工单位备注,当前状态,合同号,供方名称,附件名称 from tb_caigouliaodan where 加工单位备注='外协' and 完成='机修待审批' order by 接单日期";
DataTable dt = SQLhelp.GetDataTablexiangmuguanli(sql1, CommandType.Text);
if (dt.Rows.Count > 0)
{
MessageBox.Show("有外协机修件待审批");
}
}
}
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 dataGridViewX2_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
int dingwei = Convert.ToInt32(dataGridViewX2.CurrentRow.Cells["id"].Value);
string shangchuanren = dataGridViewX2.CurrentRow.Cells["纪要上传人"].Value.ToString();
if (shangchuanren == yonghu)
{
string sql1 = "update tb_xiangxi set 更新='' where id='" + dingwei + "'";
SQLhelp.ExecuteScalar(sql1, CommandType.Text);
Frhuifuhuiyijiyao form = new Frhuifuhuiyijiyao();
form.yonghu = yonghu;
form.dingwei = dingwei;
form.ShowDialog();
Reload();
}
if (shangchuanren != yonghu)
{
Frhuifuhuiyijiyao form = new Frhuifuhuiyijiyao();
form.yonghu = yonghu;
form.dingwei = dingwei;
form.ShowDialog();
}
}
private void gridView1_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
if (e.Button == System.Windows.Forms.MouseButtons.Left && e.Clicks == 2)
{
if (gridView1.RowCount <= 0)//判断是否选中要删除的行
{
MessageBox.Show("请选中行！");
return;
}
string shijian = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "提交时间").ToString();
if (shijian != "")
{
string a = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "报告标题").ToString();
string b = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "员工姓名").ToString();
string baogaoleixing = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "报告类型").ToString();
string chaxun11 = "select 文件类型 from tb_wenjian where 员工姓名='" + b + "'and 提交时间='" + shijian + "' and 报告类型='" + baogaoleixing + "'";
leixing = SQLhelp.ExecuteScalar(chaxun11, CommandType.Text).ToString();
byte[] mypdffile = null;
string sql = "Select 文件 From tb_wenjian Where 报告标题='" + a + "' and 提交时间='" + shijian + "'and 员工姓名='" + b + "' ";
mypdffile = SQLhelp.duqu(sql, CommandType.Text);
this.Cursor = Cursors.WaitCursor;
string aaaa = System.Environment.CurrentDirectory;
string lujing = aaaa + "\\" + a + "1" + "." + leixing;
FileStream fs = new FileStream(lujing, FileMode.Create);
fs.Write(mypdffile, 0, mypdffile.Length);
fs.Flush();
fs.Close();
this.Cursor = Cursors.Default;
Frchakanbaogao form1 = new Frchakanbaogao();
form1.lujing = lujing;
form1.Show();
}
}
}
private void 查看指示项附件ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridViewX1.Rows.Count <= 0)
{
MessageBox.Show("请选中行！");
return;
}
if (Convert.ToString(dataGridViewX1.CurrentRow.Cells["指示项附件名称"].Value) == "")
{
MessageBox.Show("没有附件！");
return;
}
if (Convert.ToString(dataGridViewX1.CurrentRow.Cells["指示项附件名称"].Value) != "")
{
string zerenren = dataGridViewX1.CurrentRow.Cells["待完成指示项内容"].Value.ToString();
string shijian = dataGridViewX1.CurrentRow.Cells["会议时间1"].Value.ToString();
string aa = "Select 指示项附件类型 From tb_xiangxi Where 纪要内容='" + zerenren + "' and 会议时间='" + shijian + "'";
string leixing = SQLhelp.ExecuteScalar(aa, CommandType.Text).ToString();
string mingcheng = Convert.ToString(dataGridViewX1.CurrentRow.Cells["待完成指示项内容"].Value);
byte[] mypdffile = null;
string sql = "Select 指示项附件 From tb_xiangxi Where 纪要内容='" + zerenren + "' and 会议时间='" + shijian + "'";
mypdffile = SQLhelp.duqu(sql, CommandType.Text);
Random ran = new Random();
string aaaa = System.Environment.CurrentDirectory;
string lujing = aaaa + "\\" + mingcheng + "." + leixing;
dakai(mypdffile, lujing);
}
}
public void Reload()
{
string strsql = "select 用户名,权限管理,部门,序号,报告组 from tb_operator ";
dataGridViewX2.DataSource = SQLhelp.GetDataTable(strsql, CommandType.Text);
}
private void toolDelete_Click(object sender, EventArgs e)
{
if (dataGridViewX2.Rows.Count <= 0)//判断是否选中要删除的行
{
MessageBox.Show("请选中行");
return;
}
//弹出确认删除对话框
if (dataGridViewX2.Rows.Count > 0)
{
DialogResult result = MessageBox.Show("确实要删除吗？", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
//删除选定行
DataGridViewRow dgvr = dataGridViewX2.CurrentRow;//获取当前选中行
string code = dgvr.Cells["用户名"].Value.ToString();
string strSql1 = "delete from tb_operator where 用户名= '" + code + "' ";
string result1 = Convert.ToString(SQLhelp.ExecuteScalar(strSql1, CommandType.Text));
MessageBox.Show("删除成功！", "软件提示");
}
Reload();
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
string sql1 = "select 密码 from tb_operator where 用户名='" + yonghu + "'";
string jiumima = SQLhelp.ExecuteScalar(sql1, CommandType.Text).ToString();
if (txtJiu.Text != jiumima)
{
MessageBox.Show("旧密码输入错误，请重新输入！");
return;
}
else
{
if (txtXin.Text == txtQueren.Text)
{
string sql2 = "update tb_operator set 密码='" + txtXin.Text + "' where 用户名='" + yonghu + "'";
SQLhelp.ExecuteScalar(sql2, CommandType.Text);
MessageBox.Show("密码修改成功！");
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("两次密码输入不相同，请重新输入！");
return;
}
}
}
private void 查看附件ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (gridView1.RowCount <= 0)
{
MessageBox.Show("请选中行！");
return;
}
if (Convert.ToString(this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "指示项附件名称")) == "")
{
MessageBox.Show("没有附件！");
return;
}
if (Convert.ToString(this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "指示项附件名称")) != "")
{
string zerenren = Convert.ToString(this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "纪要内容"));
string shijian = Convert.ToString(this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "会议时间"));
string aa = "Select 指示项附件类型 From tb_xiangxi Where 纪要内容='" + zerenren + "' and 会议时间='" + shijian + "'";
string leixing = SQLhelp.ExecuteScalar(aa, CommandType.Text).ToString();
string mingcheng = Convert.ToString(this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "指示项附件名称"));
byte[] mypdffile = null;
string sql4 = "Select 指示项附件 From tb_xiangxi Where 纪要内容='" + zerenren + "' and 会议时间='" + shijian + "'";
mypdffile = SQLhelp.duqu(sql4, CommandType.Text);
this.Cursor = Cursors.WaitCursor;
string aaaa = System.Environment.CurrentDirectory;
string bbbb = mingcheng.Replace("?", "1");
string lujing = aaaa + "\\" + bbbb + "1" + "." + leixing;
FileStream fs = new FileStream(lujing, FileMode.Create);
fs.Write(mypdffile, 0, mypdffile.Length);
fs.Flush();
fs.Close();
this.Cursor = Cursors.Default;
System.Diagnostics.Process.Start(lujing);
}
}
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 取消完成ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (gridView1.RowCount <= 0)
{
MessageBox.Show("请选中行！");
return;
}
string zerenren = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "完成责任人").ToString();
string huiyishijian = textshijian.Text;
string huiyizhuti = textzhuti.Text;
string chaxun = "select 纪要上传人 from tb_xiangxi Where 完成责任人='" + zerenren + "' and 会议时间='" + huiyishijian + "'";
string ren = SQLhelp.ExecuteScalar(chaxun, CommandType.Text).ToString();
if (yonghu != ren)
{
MessageBox.Show("无权限！");
return;
}
try
{
string xiugai = "update tb_xiangxi set 已完成=0 Where 完成责任人='" + zerenren + "' and 会议时间='" + huiyishijian + "'";
SQLhelp.ExecuteScalar(xiugai, CommandType.Text);
MessageBox.Show("修改成功！");
Reload();
}
catch (Exception ex)
{
MessageBox.Show("发生错误：" + ex.Message);
}
}
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 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;
}
private void 确认完成ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (gridView3.RowCount <= 0)
{
MessageBox.Show("请选中行！");
return;
}
string id = Convert.ToString(this.gridView3.GetRowCellValue(this.gridView3.FocusedRowHandle, "id"));
try
{
string wanchengshijian = DateTime.Now.ToString();
DateTime zuizhong = DateTime.Now;
string jiedian = Convert.ToString(this.gridView3.GetRowCellValue(this.gridView3.FocusedRowHandle, "完成时间节点"));
if (jiedian == "")
{
MessageBox.Show("请先让责任人输入完成时间节点，再确认完成");
return;
}
if (MessageBox.Show("确认完成吗？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
string xiugai = "update tb_xiangxi set 已完成=1,完成时间='" + wanchengshijian + "' Where id='" + id + "'";
SQLhelp.ExecuteScalar(xiugai, CommandType.Text);
MessageBox.Show("修改成功！");
Reload();
}
}
catch (Exception ex)
{
MessageBox.Show("发生错误：" + ex.Message);
}
}
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 查看ToolStripMenuItem_Click(object sender, EventArgs e)
{
int dingwei = Convert.ToInt32(this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "id"));
string shangchuanren = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "纪要上传人").ToString();
if (shangchuanren == yonghu)
{
string sql1 = "update tb_xiangxi set 更新='' where id='" + dingwei + "'";
SQLhelp.ExecuteScalar(sql1, CommandType.Text);
Frhuifuhuiyijiyao form = new Frhuifuhuiyijiyao();
form.yonghu = yonghu;
form.dingwei = dingwei;
form.ShowDialog();
Reload();
}
if (shangchuanren != yonghu)
{
Frhuifuhuiyijiyao form = new Frhuifuhuiyijiyao();
form.yonghu = yonghu;
form.dingwei = dingwei;
form.ShowDialog();
}
}
private void 保存时间ToolStripMenuItem_Click(object sender, EventArgs e)
{
string zerenren = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "完成责任人").ToString();
string neirong = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "纪要内容").ToString();
string shijian = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "会议时间").ToString();
string jiyaoshangchuanren = gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "纪要上传人").ToString();
if (yonghu != jiyaoshangchuanren)
{
MessageBox.Show("无权限！");
return;
}
try
{
for (int i = 0; i < gridView1.RowCount; i++)
{
string id = gridView1.GetRowCellValue(i, "id").ToString();
string shiijandianjie = gridView1.GetRowCellValue(i, "完成时间节点").ToString();
if (shiijandianjie != "")
{
string sql2 = "update tb_xiangxi set 完成时间节点= '" + Convert.ToDateTime(shiijandianjie) + "' where id= '" + id + "'";
SQLhelp.ExecuteScalar(sql2, CommandType.Text);
}
}
MessageBox.Show("修改成功！");
Reload();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
string aaa = "Select 附件名称 From tb_xiangxi Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "'";
mingcheng = SQLhelp.ExecuteScalar(aaa, CommandType.Text).ToString();
byte[] mypdffile = null;
string sql = "Select 附件 From tb_xiangxi Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "'";
mypdffile = SQLhelp.duqu(sql, CommandType.Text);
try
{
Random ran = new Random();
string aaaa = System.Environment.CurrentDirectory;
lujing = aaaa + "\\" + mingcheng + "." + leixing;
FileStream fs = new FileStream(lujing, FileMode.Create);
fs.Write(mypdffile, 0, mypdffile.Length);
fs.Flush();
fs.Close();
}
catch { }
System.Diagnostics.Process.Start(lujing);
}
private void 批复ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridViewX1.Rows.Count <= 0)//判断是否选中要删除的行
{
MessageBox.Show("请选中行");
return;
}
string zerenren = dataGridViewX1.CurrentRow.Cells["完成责任人"].Value.ToString();
string neirong = dataGridViewX1.CurrentRow.Cells["待完成指示项内容"].Value.ToString();
string shijian = dataGridViewX1.CurrentRow.Cells["会议时间1"].Value.ToString();
string sql = "select 纪要上传人 from tb_xiangxi where 会议时间='" + shijian + "' and 完成责任人='" + zerenren + "' and 纪要类型='指示项'";
string shangchuanren = SQLhelp.ExecuteScalar(sql, CommandType.Text).ToString();
if (yonghu != shangchuanren)
{
MessageBox.Show("非指示项发起人无权限批复！");
return;
}
FrZhishixiangpifu form = new FrZhishixiangpifu();
form.zerenren = zerenren;
form.shijian = shijian;
form.ShowDialog();
if (form.DialogResult == DialogResult.OK)
{
reload1();
}
}
private void 保存时间ToolStripMenuItem_Click(object sender, EventArgs e)
{
string zerenren = dataGridViewX2.CurrentRow.Cells["完成责任人"].Value.ToString();
string neirong = dataGridViewX2.CurrentRow.Cells["纪要内容"].Value.ToString();
string shijian = dataGridViewX2.CurrentRow.Cells["会议时间"].Value.ToString();
string jiyaoshangchuanren = dataGridViewX2.CurrentRow.Cells["纪要上传人"].Value.ToString();
if (yonghu != jiyaoshangchuanren)
{
MessageBox.Show("无权限！");
return;
}
try
{
for (int i = 0; i < dataGridViewX2.Rows.Count; i++)
{
string id = dataGridViewX2.Rows[i].Cells["id"].Value.ToString();
string shiijandianjie = dataGridViewX2.Rows[i].Cells["完成时间节点"].Value.ToString();
if (shiijandianjie != "")
{
string sql2 = "update tb_xiangxi set 完成时间节点= '" + Convert.ToDateTime(shiijandianjie) + "' where id= '" + id + "'";
SQLhelp.ExecuteScalar(sql2, CommandType.Text);
}
}
MessageBox.Show("修改成功！");
Reload();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void 查看附件ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridViewX1.Rows.Count <= 0)
{
MessageBox.Show("请选中行！");
return;
}
string zerenren = dataGridViewX1.CurrentRow.Cells["完成责任人"].Value.ToString();
string neirong = dataGridViewX1.CurrentRow.Cells["纪要内容"].Value.ToString();
string shijian = dataGridViewX1.CurrentRow.Cells["会议时间1"].Value.ToString();
string aa = "Select 附件格式 From tb_xiangxi Where 完成责任人='" + zerenren + "' and 纪要内容='" + neirong + "' and 会议时间='" + shijian + "'";
string leixing = SQLhelp.ExecuteScalar(aa, CommandType.Text).ToString();
string panduan = SQLhelp.ExecuteScalar(aa, CommandType.Text).ToString();
if (panduan == "")
{
MessageBox.Show("没有附件！");
return;
}
string aaa = "Select 附件名称 From tb_xiangxi Where 完成责任人='" + zerenren + "' and 纪要内容='" + neirong + "' and 会议时间='" + shijian + "'";
string mingcheng = SQLhelp.ExecuteScalar(aaa, CommandType.Text).ToString();
byte[] mypdffile = null;
string ConStr = "Data Source=10.15.1.252;Initial Catalog=db_office;user id=sa;password=zttZTT123";
SqlConnection con = new SqlConnection(ConStr);
SqlCommand cmd = new SqlCommand("", con);
cmd.CommandText = "Select 附件 From tb_xiangxi Where 完成责任人='" + zerenren + "' and 纪要内容='" + neirong + "' and 会议时间='" + shijian + "'";
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
mypdffile = (byte[])dr.GetValue(0);
}
con.Close();
this.Cursor = Cursors.WaitCursor;
try
{
Random ran = new Random();
string aaaa = System.Environment.CurrentDirectory;
lujing = aaaa + "\\" + mingcheng + "." + leixing;
FileStream fs = new FileStream(lujing, FileMode.Create);
fs.Write(mypdffile, 0, mypdffile.Length);
fs.Flush();
fs.Close();
}
catch { }
this.Cursor = Cursors.Default;
System.Diagnostics.Process.Start(lujing);
}
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 Formzhujiemian_Load(object sender, EventArgs e)
{
//labelX2.Text = "欢迎你！" + yonghu;
string sql = "select 权限管理 from tb_operator where 用户名='" + yonghu + "'";
if (Convert.ToInt32(SQLhelp.ExecuteScalar(sql, CommandType.Text)) == 0)
{
appViewTile.Visible = false;
Formchaxunxiangxi f = new Formchaxunxiangxi();
}
}
private void simpleButton3_Click(object sender, EventArgs e)
{
string strSql11 = "select 接收人分组 from tb_operator where 用户名='" + yonghu + "' ";
string fenzu = SQLhelp.ExecuteScalar(strSql11, CommandType.Text).ToString();
if (fenzu == "")
{
MessageBox.Show("请先设置接收人分组！");
return;
}
textBox1.Text = fenzu;
}
private void 查看详情ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridViewX1.Rows.Count <= 0)//判断是否选中要删除的行
{
MessageBox.Show("请选中行！");
return;
}
string a = dataGridViewX1.CurrentRow.Cells["公告标题"].Value.ToString();
string aa = "Select 公告附件类型 From tb_gonggao Where 公告标题='" + a + "'";
leixing = SQLhelp.ExecuteScalar(aa, CommandType.Text).ToString();
string panduan = SQLhelp.ExecuteScalar(aa, CommandType.Text).ToString();
if (panduan == "")
{
MessageBox.Show("该公告没有附件！");
return;
}
string sqll = "Select 公告附件类型 From tb_gonggao Where 公告标题='" + a + "'";
leixing = SQLhelp.ExecuteScalar(sqll, CommandType.Text).ToString();
byte[] mypdffile = null;
string sql = "Select 公告附件 From tb_gonggao Where 公告标题='" + a + "' and 公告类型='公告'";
mypdffile = SQLhelp.duqu(sql, CommandType.Text);
try
{
Random ran = new Random();
//int RandKey = ran.Next(0, 999999999);
//string suijishu = RandKey.ToString();
string aaaa = System.Environment.CurrentDirectory;
lujing = aaaa + "\\" + a + "." + leixing;
FileStream fs = new FileStream(lujing, FileMode.Create);
fs.Write(mypdffile, 0, mypdffile.Length);
fs.Flush();
fs.Close();
}
catch { }
this.Cursor = Cursors.Default;
System.Diagnostics.Process.Start(lujing);
}
private void 确认完成ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridViewX1.Rows.Count <= 0)
{
MessageBox.Show("请选中行！");
return;
}
string zerenren = dataGridViewX1.CurrentRow.Cells["完成责任人"].Value.ToString();
string neirong = dataGridViewX1.CurrentRow.Cells["待完成指示项内容"].Value.ToString();
string shijian = dataGridViewX1.CurrentRow.Cells["会议时间1"].Value.ToString();
string chaxun = "select 纪要上传人 from tb_xiangxi Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "' and 纪要内容='" + neirong + "'";
string ren = SQLhelp.ExecuteScalar(chaxun, CommandType.Text).ToString();
if (yonghu != ren)
{
MessageBox.Show("无权限！");
return;
}
try
{
string wanchengshijian = DateTime.Now.ToString();
DateTime zuizhong = DateTime.Now;
string jiedian = dataGridViewX1.CurrentRow.Cells["完成时间节点2"].Value.ToString();
if (jiedian == "")
{
MessageBox.Show("请先让责任人输入完成时间节点，再确认完成");
return;
}
if (MessageBox.Show("确认完成吗？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
string xiugai = "update tb_xiangxi set 已完成=1,完成时间='" + wanchengshijian + "' Where 完成责任人='" + zerenren + "' and 会议时间='" + shijian + "' and 纪要内容='" + neirong + "'";
SQLhelp.ExecuteScalar(xiugai, CommandType.Text);
MessageBox.Show("修改成功！");
reload1();
Reload();
reload2();
}
}
catch (Exception ex)
{
MessageBox.Show("发生错误：" + ex.Message);
}
}
private void 载toolStripMenuItem_Click(object sender, EventArgs e)
{
if (gridView2.RowCount <= 0)//判断是否选中要删除的行
{
MessageBox.Show("请选中行！");
return;
}
FolderBrowserDialog lujingg = new FolderBrowserDialog();
if (lujingg.ShowDialog() == DialogResult.OK)
{
string xuanzelujing = lujingg.SelectedPath;
string yonghu = gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "员工姓名").ToString();
string baogaoleixing = gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "报告类型").ToString();
string shijian = gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "提交时间").ToString();
string jingque = shijian.Substring(0, 10);
try
{
byte[] mypdffile = null;
string ConStr = "Select 文件,员工姓名,日期 From tb_wenjian Where 员工姓名='" + yonghu + "'and 提交时间='" + shijian + "' and 报告类型='" + baogaoleixing + "'";
mypdffile = SQLhelp.duqu(ConStr, CommandType.Text);
string dt1 = "Select 员工姓名 From tb_wenjian Where 员工姓名='" + yonghu + "'and 提交时间='" + shijian + "' and 报告类型='" + baogaoleixing + "'";
string mingcheng = SQLhelp.ExecuteScalar(dt1, CommandType.Text).ToString();
string dt2 = "Select 日期 From tb_wenjian Where 员工姓名='" + yonghu + "'and 提交时间='" + shijian + "' and 报告类型='" + baogaoleixing + "'";
string shijian1 = SQLhelp.ExecuteScalar(dt2, CommandType.Text).ToString();
string lujing = xuanzelujing + "\\" + mingcheng + shijian1 + baogaoleixing + ".doc";
FileStream fs = new FileStream(lujing, FileMode.Create);
fs.Write(mypdffile, 0, mypdffile.Length);
fs.Flush();
fs.Close();
MessageBox.Show("下载成功");//显示异常信息
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);//显示异常信息
}
}
}
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 一键下载toolStripMenuItem_Click(object sender, EventArgs e)
{
string sql = "select 权限管理 from tb_operator where 用户名='" + yonghu + "'";
if (Convert.ToInt32(SQLhelp.ExecuteScalar(sql, CommandType.Text)) == 0)
{
MessageBox.Show("无权限！");
return;
}
if (gridView2.RowCount <= 0)
{
MessageBox.Show("请选中行！");
return;
}
FrDetails form1 = new FrDetails();
form1.yonghu = yonghu;
form1.ShowDialog();
}
