private void textBox2_TextChanged(object sender, EventArgs e)
{
try
{
Convert.ToDecimal(textBox2.Text.Trim());
}
catch (FormatException)
{
textBox2.Text = "";
}
exsql eq = new exsql();
string NO = textBox2.Text.Trim();
string selstr = string.Format("SELECT person.personname, department.departname, person.position, person.other FROM person INNER JOIN department ON person.departid = department.departid WHERE (person.NO = {0})", NO);
SqlDataReader reader = eq.excutereader(selstr);
reader.Read();
try
{
Convert.ToString(reader[0]);
label31.Text = reader[0].ToString();
label29.Text = reader[1].ToString();
label28.Text = reader[2].ToString();
label27.Text = reader[3].ToString();
}
catch (InvalidOperationException)
{
//数据为空时不做任何处理
label31.Text = "";
label29.Text = "";
label28.Text = "";
label27.Text = "";
}
}
private void button1_Click_1(object sender, EventArgs e)
{
departid = Convert.ToInt32(comboBox1.SelectedValue);
if (comboBox1.Text == "*")
{
selstr = "SELECT equipname, COUNT(equipname) AS Expr1 FROM equipment GROUP BY equipname";
}
else
{
if (departid == 0)
{
MessageBox.Show("没有该部门，要查找所有部门，请输入\"*\"");
}
else
{
selstr = string.Format("SELECT equipname, COUNT(equipname) AS Expr1 FROM equipment WHERE departid = {0} GROUP BY equipname", departid);
}
}
flylib.exsql eq = new exsql();
DataSet ds = new DataSet();
ds = eq.excuterdataset(selstr);
报表管理.rpt.清查明细表 rpt = new EMS.报表管理.rpt.清查明细表();
rpt.SetDataSource(ds.Tables[0]);
TextObject depart = rpt.ReportDefinition.ReportObjects["Text18"] as TextObject;
depart.Text = comboBox1.Text;
crystalReportViewer1.ReportSource = rpt;
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
try
{
Convert.ToDecimal(textBox1.Text.Trim());
}
catch (FormatException)
{
textBox1.Text = "";
}
exsql eq = new exsql();
string sn = textBox1.Text.Trim();
//string selstr = string.Format("select equipname,typeid,logoid,specid,proddate,departid,other from equipment where sn='{0}'", sn);
string selstr = string.Format("SELECT equipment.equipname, equiptype.typename,equiprlogo.logoname, equiprspec.specname, equipment.proddate,department.departname, equipment.other,equipment.state,equipment.logid FROM equipment INNER JOIN equiptype ON equipment.typeid = equiptype.typeid INNER JOIN equiprlogo ON equipment.logoid = equiprlogo.logoid INNER JOIN equiprspec ON equipment.specid = equiprspec.specid INNER JOIN department ON equipment.departid = department.departid where sn='{0}'", sn);
SqlDataReader reader = eq.excutereader(selstr);
reader.Read();
try
{
Convert.ToString(reader[0]);
label20.Text = reader[0].ToString();
label19.Text = reader[1].ToString();
label18.Text = reader[2].ToString();
label17.Text = reader[3].ToString();
label16.Text = Convert.ToDateTime(reader[4]).ToString("yyyy-MM-dd");
label15.Text = reader[5].ToString();
label14.Text = reader[6].ToString();
if (reader[7].ToString() == "正常")
{
if (reader[8].ToString().Trim() != "")
{
label21.Text = "租出";
}
else
{
label21.Text = reader[7].ToString();
}
}
//赋值
}
catch (InvalidOperationException)
{
//数据为空时不做任何处理
label20.Text = "";
label19.Text = "";
label18.Text = "";
label17.Text = "";
label16.Text = "";
label15.Text = "";
label14.Text = "";
label21.Text = "";
}
}
private void report_Load(object sender, EventArgs e)
{
exsql eq = new exsql();
string rstr = "SELECT [user].username, role.role, authority.authority, subauthority.subauthority FROM [user] INNER JOIN userper ON [user].userid = userper.userid INNER JOIN role ON userper.roleid = role.roleid INNER JOIN authority ON userper.authorityid = authority.authorityid INNER JOIN subauthority ON userper.subauthorityid = subauthority.subauthorityid INNER JOIN userrole ON [user].userid = userrole.userid AND role.roleid = userrole.roleid INNER JOIN roleauthority ON role.roleid = roleauthority.roleid AND authority.authorityid = roleauthority.authorityid INNER JOIN authsub ON authority.authorityid = authsub.authorityid AND subauthority.subauthorityid = authsub.subauthorityid";
DataSet ds = eq.excuterdataset(rstr);
uras rpt = new uras();
rpt.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = rpt;
}
private void Main_Load(object sender, EventArgs e)
{
toolStripStatusLabel2.Text = this.username; //系统用户
toolStripStatusLabel4.Text = DateTime.Now.ToString("yyyy-MM-dd"); //系统日期
timer1.Enabled = true;
timer1.Interval = 1000;
//查询USERID
string selstr = string.Format("select userid from [user] where username='******'", username);
exsql eq = new exsql();
SqlDataReader reader = eq.excutereader(selstr);
reader.Read();
userid = Convert.ToInt32(reader[0]);
}
private void button1_Click(object sender, EventArgs e)
{
int sn = Convert.ToInt32(textBox1.Text.Trim());
string lenddate = DateTime.Now.ToString("yyyy-MM-dd");
int personid = Convert.ToInt32(textBox2.Text.Trim());
if (textBox1.Text == "" || label20.Text == "")
{
MessageBox.Show("请设备设备！");
}
else
{
if (textBox2.Text == "" || label31.Text == "")
{
MessageBox.Show("请选择人员！");
}
else
{
exsql eq = new exsql();
try
{
string checkstr = string.Format("select logid from equipment where sn={0}", sn);
SqlDataReader reader = eq.excutereader(checkstr);
reader.Read();
Convert.ToInt32(reader[0]);
MessageBox.Show("该设备已经租出！");
}
catch (InvalidCastException)
{
//写日志
string logstr = string.Format("insert into lendlgo(sn,lenddate,personid,lendUserid)values({0},'{1}',{2},{3})", sn, lenddate, personid, userid);
eq.excutesql(logstr);
//读log编码
string selstr = "SELECT MAX (logid) FROM lendlog";
SqlDataReader reader2 = eq.excutereader(selstr);
reader2.Read();
int logid = Convert.ToInt32(reader2[0]);
string upstr = string.Format("Update equipment set logid={0} where sn={1}", sn, logid);
eq.excutesql(upstr);
MessageBox.Show("租赁成功！");
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string starttime = dateTimePicker1.Value.ToString("yyyy-MM-dd");
string endtime = dateTimePicker2.Value.ToString("yyyy-MM-dd");
string selstr = string.Format("SELECT equiplog.logtid, equiplog.sn, person.personname, [user].username,equiplog.logtype, equiplog.optime, equiplog.other FROM equiplog INNER JOIN person ON equiplog.personid = person.personid CROSS JOIN [user] WHERE (sn LIKE '%{0}%') AND (logtype LIKE '%{1}%') AND(optime between '{2}' and '{3}')", textBox1.Text, comboBox1.Text, starttime, endtime);
DataSet ds = new DataSet();
exsql eq = new exsql();
ds = eq.excuterdataset(selstr);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[0].HeaderText = "序号";
dataGridView1.Columns[1].HeaderText = "设备编号";
dataGridView1.Columns[2].HeaderText = "职员";
dataGridView1.Columns[3].HeaderText = "管理员";
dataGridView1.Columns[4].HeaderText = "处理类型";
dataGridView1.Columns[5].HeaderText = "操作时间";
dataGridView1.Columns[6].HeaderText = "备注信息";
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "")
{
MessageBox.Show("工号或姓名不能为空！");
}
else
{
string NO = textBox1.Text.Trim();
string personname = textBox2.Text.Trim();
int departid = Convert.ToInt32(comboBox1.SelectedValue.ToString());
string position = comboBox2.Text.Trim();
string other = textBox3.Text;
string instr = string.Format("insert into person([NO],personname,departid,[position],other)values('{0}','{1}',{2},'{3}','{4}')", NO, personname, departid, position, other);
exsql eq = new exsql();
eq.excutesql(instr);
}
MessageBox.Show("插入成功！");
}
private void button1_Click(object sender, EventArgs e)
{
string sn = textBox1.Text.Trim();
string lendstarttime = dateTimePicker1.Value.ToString("yyyy-MM-dd");
string lendendtime = dateTimePicker2.Value.ToString("yyyy-MM-dd");
string selstr = string.Format("SELECT lendlog.logid, lendlog.sn, lendlog.lenddate, lendlog.returndate,person.personname, [user].username AS lendusername,user_1.username AS returnuser, lendlog.other FROM lendlog INNER JOIN [user] ON lendlog.lendUserid = [user].userid INNER JOIN [user] user_1 ON lendlog.returnUserid = user_1.userid INNER JOIN person ON lendlog.personid = person.personid WHERE (sn LIKE '%{0}%') AND(lenddate between '{1}' and '{2}')", sn, lendstarttime, lendendtime);
DataSet ds = new DataSet();
exsql eq = new exsql();
ds = eq.excuterdataset(selstr);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[0].HeaderText = "序号";
dataGridView1.Columns[1].HeaderText = "设备编号";
dataGridView1.Columns[2].HeaderText = "租出日期";
dataGridView1.Columns[3].HeaderText = "归还日期";
dataGridView1.Columns[4].HeaderText = "租借人";
dataGridView1.Columns[5].HeaderText = "租出管理员";
dataGridView1.Columns[6].HeaderText = "收还管理员";
dataGridView1.Columns[7].HeaderText = "备注信息";
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "")
{
MessageBox.Show("设备编号或名称不能为空！");
}
else
{
string sn = textBox1.Text.Trim();
string equipname = textBox2.Text.Trim();
int typeid = Convert.ToInt32(comboBox1.SelectedValue);
int logoid = Convert.ToInt32(comboBox2.SelectedValue);
int specid = Convert.ToInt32(comboBox3.SelectedValue);
int propid = Convert.ToInt32(comboBox5.SelectedValue);
string proddate = dateTimePicker1.Value.ToString("yyyyMMdd");
int departid = Convert.ToInt32(comboBox4.SelectedValue);
string other = textBox3.Text.Trim();
string instr = string.Format("insert into equipment(sn,equipname,typeid,logoid,specid,proddate,departid,other,propid)values('{0}','{1}',{2},{3},{4},'{5}',{6},'{7}',{8})", sn, equipname, typeid, logoid, specid, proddate, departid, other, propid);
exsql eq = new exsql();
eq.excutesql(instr);
MessageBox.Show("插入成功！");
}
}
private void button1_Click_1(object sender, EventArgs e)
{
typeid = Convert.ToInt32(comboBox1.SelectedValue);
departid = Convert.ToInt32(comboBox2.SelectedValue);
if (comboBox1.Text == "*")
{
if (comboBox2.Text == "*")
{
selstr = "SELECT equipment.sn, equipment.equipname, equiprlogo.logoname,equiprspec.specname, equipment.inputdate, equipment.proddate, equipment.state,equipment.inputer, equipment.other FROM equipment INNER JOIN equiprlogo ON equipment.logoid = equiprlogo.logoid INNER JOIN equiprspec ON equipment.specid = equiprspec.specid";
}
else
{
if (departid == 0)
{
MessageBox.Show("没有该该部门，要查找所有部门，请输入\"*\"");
}
else
{
selstr = string.Format("SELECT equipment.sn, equipment.equipname, equiprlogo.logoname,equiprspec.specname, equipment.inputdate, equipment.proddate, equipment.state,equipment.inputer, equipment.other FROM equipment INNER JOIN equiprlogo ON equipment.logoid = equiprlogo.logoid INNER JOIN equiprspec ON equipment.specid = equiprspec.specid where equipment.departid={0}", departid);
}
}
}
else
{
if (typeid == 0)
{
MessageBox.Show("没有该该类别，要查找所有类别，请输入\"*\"");
}
else
{
if (comboBox2.Text == "*")
{
selstr = string.Format("SELECT equipment.sn, equipment.equipname, equiprlogo.logoname,equiprspec.specname, equipment.inputdate, equipment.proddate, equipment.state,equipment.inputer, equipment.other FROM equipment INNER JOIN equiprlogo ON equipment.logoid = equiprlogo.logoid INNER JOIN equiprspec ON equipment.specid = equiprspec.specid where equipment.typeid={0}", typeid);
}
else
{
if (departid == 0)
{
MessageBox.Show("没有该该部门，要查找所有部门，请输入\"*\"");
}
else
{
selstr = string.Format("SELECT equipment.sn, equipment.equipname, equiprlogo.logoname,equiprspec.specname, equipment.inputdate, equipment.proddate, equipment.state,equipment.inputer, equipment.other FROM equipment INNER JOIN equiprlogo ON equipment.logoid = equiprlogo.logoid INNER JOIN equiprspec ON equipment.specid = equiprspec.specid where (equipment.typeid = {0}) AND (equipment.departid = {1})", typeid, departid);
}
}
}
}
flylib.exsql eq = new exsql();
DataSet ds = new DataSet();
ds = eq.excuterdataset(selstr);
报表管理.rpt.固定资产使用登记表 rpt = new EMS.报表管理.rpt.固定资产使用登记表();
rpt.SetDataSource(ds.Tables[0]);
TextObject type = rpt.ReportDefinition.ReportObjects["Text17"] as TextObject;
type.Text = comboBox1.Text;
TextObject depart = rpt.ReportDefinition.ReportObjects["Text13"] as TextObject;
depart.Text = comboBox2.Text;
crystalReportViewer1.ReportSource = rpt;
}
