private void select_zhi(string tzid) { sql_sel s1 = new sql_sel(); string[] zhi1 = s1.select_dataread_only_zu_where("B台账", "*", "R序号", tzid); ArrayList imglist = s1.select_array_byte_little("B图片", "R图片", "R所属台账序号", tzid); longbotu1.arry = imglist; longbotu1.leixin = s1.select_dataread_all_zu_where("B图片", "R图片类型", "R所属台账序号", tzid); longbotu1.load(); try { byte[] syt_bytes = (byte[])s1.select_only("B示意图", "R示意图", "R所属台账编号", tzid); string_to_img sti1 = new string_to_img(); img_width_change iwc1 = new img_width_change(); pictureBox1.Image = iwc1.change(sti1.byte_img(syt_bytes, "jpg"), pictureBox1.Width, pictureBox1.Height); } catch { Graphics g1 = Graphics.FromImage(pictureBox1.Image); g1.FillRectangle(Brushes.White, new Rectangle(0, 0, pictureBox1.Width, pictureBox1.Height)); //涂成白色 Font font = new Font("黑体", 20, FontStyle.Bold); Brush sb1 = new SolidBrush(Color.Yellow); g1.DrawString("这个台账没有示意图!", font, sb1, 20, 20); pictureBox1.Image = pictureBox1.Image; } wenzi_fuzhi(zhi1); Text = "远望谷—铁路车号识别—台账详情:" + ID1 + "。" + username + ",欢迎您!"; whjlb(ID1); }
private void updata_taizhang_Load(object sender, EventArgs e) { AcceptButton = save; if (ID1 == "") { MessageBox.Show("没有选择台账!", username + ",无法打开页面!", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } else { try { Text = "远望谷—铁路车号识别—修改台账:" + ID1 + "。" + username + ",欢迎您!"; chushihua(); select_zhi(ID1); xuanzetupian1.AfterSelectEvent += new Action <string[], string[], ArrayList>(xuanzetupian_AfterSelectEvent); xuanzetupian1.leixin = leixin; xuanzetupian1.name = name; xuanzetupian1.samons = imglist; xuanzetupian1.load(); sql_sel s1 = new sql_sel(); shiyitu = (byte[])s1.select_only("B示意图", "R示意图", "R所属台账编号", ID1); } catch { MessageBox.Show("没有选择台账!", username + ",无法打开页面!", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } } }
private void my_creat_Click(object sender, EventArgs e) { sql_sel s3 = new sql_sel(); list_ID = s3.select_dataread_all_zu_where("B台账", "R序号", "R创建人", username); tree_id(list_ID); }
private void csz(string wid) { sql_sel s1 = new sql_sel(); string r = ""; for (int j = 0; j < lie().Length; j++) { r = r + lie()[j]; if (j < lie().Length - 1) { r = r + ","; } } string[] wh_xx = s1.select_dataread_only_zu_where("B维护记录", r, "R序号", wh_id); whxm.Text = wh_xx[0]; gzxx.Text = wh_xx[1]; fssj.Text = wh_xx[2]; whsj.Text = wh_xx[3]; jjbf.Text = wh_xx[4]; whjg.Text = wh_xx[5]; whr.Text = wh_xx[6]; lxr.Text = wh_xx[7]; lxdh.Text = wh_xx[8]; tz_id = wh_xx[9]; }
private void tree() { treeView1.ContextMenuStrip = contextMenuStrip1; TreeNode topNode = treeView1.Nodes.Add("所有台账"); sql_sel s1 = new sql_sel(); string[] readfzx = s1.select_dataread_all_zu("B分中心", "R分中心"); TreeNode[] fzx = new TreeNode[readfzx.Length]; for (int i = 0; i < readfzx.Length; i++) { fzx[i] = new TreeNode(readfzx[i].ToString()); topNode.Nodes.Add(fzx[i]); string[] readfz = s1.select_dataread_all_zu_where("B铁路局", "R铁路局", "R所属分中心", readfzx[i]); TreeNode[] fz = new TreeNode[readfzx.Length]; for (int j = 0; j < readfz.Length; j++) { fz[j] = new TreeNode(readfz[j].ToString()); fzx[i].Nodes.Add(fz[j]); string[] qiyeguotie = { "国铁", "企业" }; for (int iii = 0; iii < qiyeguotie.Length; iii++) { TreeNode iiii = new TreeNode(qiyeguotie[iii]); fz[j].Nodes.Add(iiii); } } } topNode.Expand(); treeView1.SelectedNode = topNode; }
private void tree_afterselect() { listView1.Items.Clear(); sql_sel s3 = new sql_sel(); if (treeView1.SelectedNode.Text == "所有台账") { list_ID = s3.select_dataread_all_zu("B台账", "R序号"); } else { if (treeView1.SelectedNode.Text == "国铁" || treeView1.SelectedNode.Text == "企业") { string sql_xx = " R所属铁路局 = '" + treeView1.SelectedNode.Parent.Text + "' and R是否企业= '" + treeView1.SelectedNode.Text + "'"; list_ID = s3.select_string_where_t("B台账", "R序号", sql_xx); } else { string sql_xx = " R所属铁路局 = '" + treeView1.SelectedNode.Text + " ' or R所属分中心= '" + treeView1.SelectedNode.Text + "'"; list_ID = s3.select_string_where_t("B台账", "R序号", sql_xx); } } tree_id(list_ID); select_ID = null; }
private void user_load() { user_list.Items.Clear(); sql_sel s1 = new sql_sel(); us_name = s1.select_dataread_all_zu("B用户", "R姓名"); us_name = names_shai(); if (us_name.Length != 0) { string tiaojian = ""; for (int i = 0; i < us_name.Length; i++) { tiaojian = tiaojian + " R姓名 = '" + us_name[i] + "' "; if (i < us_name.Length - 1) { tiaojian = tiaojian + " or "; } } ArrayList ar = s1.select_array_most("B用户", "R姓名,R分中心,R职位,R电话", tiaojian); for (int i1 = 0; i1 < ar.Count; i1++) { string[] aa = (string[])ar[i1]; string[] ab = new string[aa.Length + 1]; ab[0] = (i1 + 1).ToString(); for (int jjj = 1; jjj < ab.Length; jjj++) { ab[jjj] = aa[jjj - 1]; } ListViewItem subitem = new ListViewItem(ab); user_list.Items.Add(subitem); } } select_name = null; }
private void zhiwei_del(string select_zhiwei) { DialogResult dr; dr = MessageBox.Show(username + "您好!您确定要删除职位: " + select_zhiwei + " 吗?", "警告!!!", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { if (select_zhiwei != null & select_zhiwei != "") { sql_sel s1 = new sql_sel(); if (s1.delete_only("B职位", "R职位", select_zhiwei) == 1) { MessageBox.Show("删除" + select_zhiwei + "成功!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); zhiwei_load(); } else { MessageBox.Show("删除" + select_zhiwei + "失败,请重试!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("未选择要删除的职位!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
void del(string select_name) { if (select_name == username) { MessageBox.Show("你不能删除自己!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { DialogResult dr; dr = MessageBox.Show(username + "您好!您确定要删除用户: " + select_name + " 吗?删除后不可恢复!!!", "警告!!!", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { if (select_name != null & select_name != "") { sql_sel s1 = new sql_sel(); if (s1.delete_only("B用户", "R姓名", select_name) == 1) { MessageBox.Show("删除" + select_name + "成功!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); user_load(); } else { MessageBox.Show("删除" + select_name + "失败,请重试!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("未选择要删除的用户!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }
private void del_whjl_Click(object sender, EventArgs e) { if (wh_id != null) { user_x ux1 = new user_x(username, "删除", "维护记录"); if (ux1.sy() > 0) { DialogResult dr; dr = MessageBox.Show(username + "您好!您确定要删除台账 " + mincheng.Text + " 的维护记录" + whxm.Text + "吗?删除后不可恢复!!!", "警告!!!", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { sql_sel sqq1 = new sql_sel(); ux1.insert_log(mincheng.Text); MessageBox.Show("删除了台账 " + mincheng.Text + " 的" + sqq1.delete_only("B维护记录", "R序号", wh_id) + "条维护记录" + whxm.Text + " !", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); b1 = true; Close(); } } else { ux1.cw_message(); } } else { MessageBox.Show("未选择台账!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public bool del(string ID1) { bool a = false; if (ID1 != null & ID1 != "") { user_x ux1 = new user_x(username, "删除", "台账"); if (ux1.sy() > 0) { sql_sel sqq1 = new sql_sel(); DialogResult dr; dr = MessageBox.Show(username + "您好!您确定要删除台账: " + sqq1.select_only("B台账", "R名称", "R序号", ID1) + " 吗?删除后不可恢复!!!", "警告!!!", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { ux1.insert_log(ux1.TZ_name(ID1)); MessageBox.Show("删除了编号为:" + ID1 + "的" + sqq1.delete_only("B台账", "R序号", ID1) + "个台账,台账的" + sqq1.delete_only("B示意图", "R所属台账编号", ID1) + "张示意图和" + sqq1.delete_only("B图片", "R所属台账序号", ID1) + "张图片也被同时删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); sqq1.delete_only("B维护记录", "R所属台账编号", ID1); a = true; } } else { ux1.cw_message(); } } else { MessageBox.Show("未选择台账!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); a = false; } return(a); }
private void my_anzhuan_Click(object sender, EventArgs e) { listView1.Items.Clear(); sql_sel s3 = new sql_sel(); list_ID = s3.select_string_where_t("B台账", "R序号", "R安装人员 like '%" + username + "%'"); tree_id(list_ID); }
private void save_Click(object sender, EventArgs e) { user_x ux1 = new user_x(username, "添加", "台账"); sql_sel s1 = new sql_sel(); ux1.insert_log(mincheng.Text); MessageBox.Show("添加了" + s1.insert_only("B台账", dbo(), values()) + "条数据!台账里有" + img_add() + "张图片," + shiyitu_add() + "示意图!", "提示", MessageBoxButtons.OK); ID.Text = Convert.ToString(int.Parse(ID.Text) + 1); }
private void my_whsb_Click(object sender, EventArgs e) { listView1.Items.Clear(); sql_sel s3 = new sql_sel(); array_jian arqc = new array_jian(); list_ID = arqc.quchong(s3.select_string_where_t("B维护记录", "R所属台账编号", "R维护人 like '%" + username + "%'")); tree_id(list_ID); }
private void select_zhi(string tzid) { sql_sel s1 = new sql_sel(); zhi1 = s1.select_dataread_only_zu_where("B台账", "*", "R序号", tzid); imglist = s1.select_array_byte_little("B图片", "R图片", "R所属台账序号", tzid); leixin = s1.select_dataread_all_zu_where("B图片", "R图片类型", "R所属台账序号", tzid); name = s1.select_dataread_all_zu_where("B图片", "R图片名称", "R所属台账序号", tzid); wenzi_fuzhi(zhi1); }
private void button1_Click(object sender, EventArgs e) { string teshuleixin = "@image"; sql_sel s1 = new sql_sel(); s1.conn(); string sql = "insert into dbo.pic(image) values (" + teshuleixin + ")"; s1.sql_insert(sql, byte1, teshuleixin); s1.close(); }
private void caozuo_list() { caozuojilu.Items.Clear(); sql_sel s1 = new sql_sel(); ArrayList list = s1.select_array_all_order("B操作记录", "*", "R序号", "desc"); foreach (string[] i in list) { caozuojilu.Items.Add(i[5] + " " + i[4] + " " + i[3] + "了" + i[2] + " " + i[1]); } }
private void load() { Text = "远望谷—客服中心— " + username + " 用户信息"; sql_sel s1 = new sql_sel(); name.Text = username; pw.Text = (string)s1.select_only("B用户", "R密码", "R姓名", username); bumen.Text = (string)s1.select_only("B用户", "R分中心", "R姓名", username); zw.Text = (string)s1.select_only("B用户", "R职位", "R姓名", username); phone.Text = (string)s1.select_only("B用户", "R电话", "R姓名", username); }
private void button2_Click(object sender, EventArgs e) { sql_sel s1 = new sql_sel(); s1.conn(); string sql = "select image From dbo.pic where ID='" + textBox1.Text + "'"; byte[] b = (byte[])s1.select(sql); File.WriteAllBytes(@"D:\read.gif", b); s1.close(); }
private void xinhao_Load(object sender, EventArgs e) { Text = "远望谷—铁路车号识别—设备型号管理!。" + username + ",欢迎您!"; load(); sql_sel s1 = new sql_sel(); array_jian ar = new array_jian(); string[] sbmc = ar.quchong(s1.select_dataread_all_zu("B设备型号", "R名称")); shebei.Items.AddRange(sbmc); shebei.SelectedIndex = 0; }
private void csh(string ID1) { sql_sel s1 = new sql_sel(); string r = "R名称,R型号"; string[] tzxinxi = s1.select_dataread_only_zu_where("B台账", r, "R序号", ID1); mincheng.Text = tzxinxi[0]; xinhao.Text = tzxinxi[1]; ID.Text = ID1; Text = "远望谷—铁路车号识别—查看维护记录:" + tz_id + "!" + username + ",欢迎您!"; }
private void del_cg_Click(object sender, EventArgs e) { try { sql_sel s1 = new sql_sel(); MessageBox.Show("成功删除型号 " + cg_list.SelectedItem.ToString() + " " + s1.delete_only("B设备型号", "R型号", cg_list.SelectedItem.ToString()) + "个磁钢型号!", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Information); load(); } catch { MessageBox.Show("没有选择要删除的型号!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void zt_del_Click(object sender, EventArgs e) { try { sql_sel s1 = new sql_sel(); MessageBox.Show("成功删除型号 " + zt_list.SelectedItem.ToString() + " " + s1.delete_only("B安装状态", "R安装状态", zt_list.SelectedItem.ToString()) + "个安装状态型号!", "删除成功", MessageBoxButtons.OK, MessageBoxIcon.Information); load(); } catch { MessageBox.Show("没有选择要删除的项目!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void fengzhongxin_SelectedIndexChanged(object sender, EventArgs e) { tieluju.Items.Clear(); try { sql_sel s2 = new sql_sel(); string[] readtlu = s2.select_dataread_all_zu_where("B铁路局", "R铁路局", "R所属分中心", fengzhongxin.Text); tieluju.Items.AddRange(readtlu); tieluju.SelectedIndex = 0; } catch { tieluju.Items.Add(" "); } }
private void tjwhjl_Click(object sender, EventArgs e) { sql_sel s2 = new sql_sel(); if (ID1 != null) { user_x ux1 = new user_x(username, "添加", "维护记录"); ux1.insert_log(mincheng.Text); MessageBox.Show("向" + ID1 + "号台账" + mincheng.Text + "添加了" + s2.insert_only("B维护记录", lie(), zhi()) + "条维护记录!", username + ",维护记录添加成功!", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有选择需要添加维护记录的台账!", username + ",维护记录添加失败!", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void add_zt_Click(object sender, EventArgs e) { try { sql_sel s1 = new sql_sel(); string[] r = { "R安装状态" }; string[] v = { zt.Text }; MessageBox.Show("成功添加安装状态 " + zt.Text + " " + s1.insert_only("B安装状态", r, v) + "条!", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Information); load(); } catch { MessageBox.Show("添加失败,请重试!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void add_Click(object sender, EventArgs e) { try { sql_sel s1 = new sql_sel(); string[] r = { "R名称", "R型号" }; string[] v = { shebei.Text, xh.Text }; MessageBox.Show("成功为" + shebei.Text + "添加型号 " + xh.Text + " " + s1.insert_only("B设备型号", r, v) + "条!", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Information); load(); } catch { MessageBox.Show("添加失败,请重试!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void up_mima_Click(object sender, EventArgs e) { sql_sel s1 = new sql_sel(); string[] r = { "R密码" }; string[] v = { pw.Text }; if (s1.update_only("B用户", r, v, "R姓名", username) == 1) { MessageBox.Show(username + ",恭喜您,密码修改成功!", "密码修改成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(username + ",遗憾,密码修改失败!", "密码修改失败", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void change_p_Click(object sender, EventArgs e) { sql_sel s1 = new sql_sel(); string[] r = { "R电话" }; string[] v = { phone.Text }; if (s1.update_only("B用户", r, v, "R姓名", username) == 1) { MessageBox.Show(username + ",恭喜您,新电话为" + phone.Text + "!", "电话修改成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(username + ",遗憾,电话修改失败!", "电话修改失败", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void button3_Click(object sender, EventArgs e) { sql_sel s1 = new sql_sel(); s1.conn(); string sql = "select R示意图 From dbo.B示意图 where R所属台账编号='" + textBox1.Text + "'"; byte[] b = (byte[])s1.select(sql); MemoryStream ms = new MemoryStream(b); Image image = System.Drawing.Image.FromStream(ms); img_width_change a = new img_width_change(); image = a.change(image, pictureBox2.Width, pictureBox2.Height); pictureBox2.Image = image; s1.close(); }