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