Reply to thread

Message

<blockquote data-quote="3.5G" data-source="post: 7936390" data-attributes="member: 158943">using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.OleDb;using System.Windows.Forms;namespace Nawco_Systemz.c_db{&nbsp; &nbsp; class jobOrder_db&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; clsOdbc cls_Con = new clsOdbc();&nbsp; &nbsp; &nbsp; &nbsp; OleDbCommand cmdForm = new OleDbCommand();&nbsp; &nbsp; &nbsp; &nbsp; //************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; //auto id&nbsp; &nbsp; &nbsp; &nbsp; public int autoid()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int id = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbCommand command = cls_Con.cn.CreateCommand();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command.CommandText = &quot;SELECT MAX(prid) FROM production&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (command.ExecuteScalar() != DBNull.Value)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id = Convert.ToInt32(command.ExecuteScalar());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command.Dispose();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (id == 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id = 7541;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id++;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return id;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //add JOB order&nbsp; &nbsp; &nbsp; &nbsp; public Boolean add_job_order(b_bis.jobOrder_bis ib)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cmdOpen(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.CommandText = &quot;insert into Production(prid, aid, qty, sdate, edate, status) values (?,?,?,?,?,?)&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@prid&quot;, OleDbType.Numeric).Value = ib.p_joid;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@aid&quot;, OleDbType.Char).Value = ib.p_asm.p_aid;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@qty&quot;, OleDbType.Decimal).Value = ib.p_qty;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@sdate&quot;, OleDbType.Date).Value = ib.p_jsdate;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@edate&quot;, OleDbType.Date).Value = ib.p_jedate;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@status&quot;, OleDbType.Numeric).Value = ib.p_status;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cmdClose(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.Write(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //add JOB _ items&nbsp; &nbsp; &nbsp; &nbsp; public Boolean add_job_material(b_bis.jobOrder_bis ib)&nbsp; &nbsp; &nbsp; &nbsp; {MessageBox.Show(ib.p_mt.p_mid);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cmdOpen(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.CommandText = &quot;insert into pro_mid(prid, mid, type, qty, price, avgprice) values (?,?,?,?,?,?)&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@prid&quot;, OleDbType.Numeric).Value = ib.p_joid;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@mid&quot;, OleDbType.Char).Value = ib.p_mt.p_mid;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@type&quot;, OleDbType.Char).Value = ib.p_descr;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@qty&quot;, OleDbType.Decimal).Value = ib.p_qty;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@price&quot;, OleDbType.Decimal).Value = ib.p_price;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@avgprice&quot;, OleDbType.Decimal).Value = ib.p_avgprice;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cmdClose(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.Write(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //**************************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; //add JOB _ items&nbsp; &nbsp; &nbsp; &nbsp; public Boolean add_job_extra(b_bis.jobOrder_bis ib)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cmdOpen(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.CommandText = &quot;insert into jo_other(prid, qty, descr, cost) values (?,?,?,?)&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@prid&quot;, OleDbType.Numeric).Value = ib.p_joid;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@qty&quot;, OleDbType.Numeric).Value = ib.p_qty;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@descr&quot;, OleDbType.Char).Value = ib.p_descr;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@cost&quot;, OleDbType.Decimal).Value = ib.p_price;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cmdClose(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.Write(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //**************************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; //List assembly products&nbsp; &nbsp; &nbsp; &nbsp; public ArrayList list_search(string name, string opt, DateTime date1, DateTime date2)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ArrayList listg = new ArrayList();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string sql;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = &quot;SELECT Production.prid, Production.aid, Production.qty, Production.sdate, Assembly.name, Production.status&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; FROM Assembly INNER JOIN Production ON Assembly.aid = Production.aid&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; WHERE Assembly.name LIKE '&quot; + name + &quot;%'&nbsp; ORDER BY Production.prid desc&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (opt == &quot;all&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = &quot;SELECT Production.prid, Production.aid, Production.qty, Production.sdate, Assembly.name, Production.status&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; FROM Assembly INNER JOIN Production ON Assembly.aid = Production.aid ORDER BY Production.prid desc&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else if (opt == &quot;sts0&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = &quot;SELECT Production.prid, Production.aid, Production.qty, Production.sdate, Assembly.name, Production.status&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; FROM Assembly INNER JOIN Production ON Assembly.aid = Production.aid WHERE Production.status=0&nbsp; ORDER BY Production.prid desc&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else if (opt == &quot;date&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = &quot;SELECT Production.prid, Production.aid, Production.qty, Production.sdate, Assembly.name, Production.status&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; FROM Assembly INNER JOIN Production ON Assembly.aid = Production.aid WHERE (Production.status=0)&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; AND (Production.sdate BETWEEN #&quot; + date1.ToString(&quot;d&quot;) + &quot;# AND #&quot; + date2.ToString(&quot;d&quot;) + &quot;#)&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; ORDER BY Production.prid desc&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //MessageBox.Show(sql);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbCommand cmd = new OleDbCommand(sql, cls_Con.cn);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbDataReader dr = cmd.ExecuteReader();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (dr.Read())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b_bis.jobOrder_bis jt = new b_bis.jobOrder_bis();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b_bis.assembly_bis at = new b_bis.assembly_bis();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_joid = Convert.ToInt32(dr[0]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; at.p_aid = (string)dr[1];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; at.p_name = (string)dr[4];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_asm = at;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_qty = Convert.ToDecimal(dr[2]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_jsdate = Convert.ToDateTime(dr[3]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_status = Convert.ToInt32(dr[5]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; listg.Add(jt);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Dispose();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dr.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;DB error : &quot; + exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return listg;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; //List jobs&nbsp; &nbsp; &nbsp; &nbsp; //************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; public ArrayList list_JO(int id)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ArrayList listx = new ArrayList();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string sql;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = &quot;select * from Production where prid =&quot; + id;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //MessageBox.Show(sql);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbCommand cmd = new OleDbCommand(sql, cls_Con.cn);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbDataReader dr = cmd.ExecuteReader();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (dr.Read())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b_bis.jobOrder_bis jt = new b_bis.jobOrder_bis();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b_bis.assembly_bis at = new b_bis.assembly_bis();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_joid = Convert.ToInt32(dr[0]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; at.p_aid = (string)dr[1];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_asm = at;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_qty = Convert.ToDecimal(dr[2]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_jsdate = Convert.ToDateTime(dr[3]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_jedate = Convert.ToDateTime(dr[4]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_status = Convert.ToInt32(dr[5]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //MessageBox.Show(met.p_mid + &quot;-&quot; + met.p_name + &quot;-&quot; + met.p_price + &quot;-&quot; + met.p_avgprice + &quot;-&quot; + met.p_qty + &quot;-&quot; + met.p_status);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; listx.Add(jt);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Dispose();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dr.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;DB error : &quot; + exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return listx;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; //List jobs material&nbsp; &nbsp; &nbsp; &nbsp; //************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; public ArrayList list_pro_mid(int id)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ArrayList listx = new ArrayList();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string sql;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = &quot;SELECT pro_mid.prid, pro_mid.mid, pro_mid.qty, pro_mid.price, pro_mid.avgprice, Material.Name, pro_mid.type&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; FROM Material INNER JOIN pro_mid ON Material.mid = pro_mid.mid WHERE pro_mid.prid=&quot;+ id;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //MessageBox.Show(sql);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbCommand cmd = new OleDbCommand(sql, cls_Con.cn);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbDataReader dr = cmd.ExecuteReader();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (dr.Read())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b_bis.jobOrder_bis jt = new b_bis.jobOrder_bis();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b_bis.material_bis mt = new b_bis.material_bis();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_joid = Convert.ToInt32(dr[0]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mt.p_mid = (string)dr[1];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mt.p_name = (string)dr[5];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_mt = mt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_qty = Convert.ToDecimal(dr[2]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_price = Convert.ToDecimal(dr[3]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_avgprice = Convert.ToDecimal(dr[4]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_descr = (string)dr[5];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; listx.Add(jt);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Dispose();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dr.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;DB error : &quot; + exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return listx;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; //List jobs other expenses&nbsp; &nbsp; &nbsp; &nbsp; //************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; public ArrayList list_pro_other(int id)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ArrayList listx = new ArrayList();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string sql;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = &quot;SELECT * FROM jo_other WHERE prid=&quot; + id;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //MessageBox.Show(sql);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbCommand cmd = new OleDbCommand(sql, cls_Con.cn);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbDataReader dr = cmd.ExecuteReader();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (dr.Read())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b_bis.jobOrder_bis jt = new b_bis.jobOrder_bis();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_descr = (string)dr[2];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_qty = Convert.ToDecimal(dr[3]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jt.p_price = Convert.ToDecimal(dr[4]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; listx.Add(jt);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Dispose();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dr.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;DB error : &quot; + exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return listx;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //add JOB order&nbsp; &nbsp; &nbsp; &nbsp; public Boolean add_mati(b_bis.jobOrder_bis ib)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cmdOpen(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.CommandText = &quot;insert into MatI(prid, mdate) values (?,?)&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@prid&quot;, OleDbType.Numeric).Value = ib.p_joid;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@mdate&quot;, OleDbType.Date).Value = ib.p_jsdate;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cmdClose(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.Write(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //update JOB order&nbsp; &nbsp; &nbsp; &nbsp; public Boolean update_status(int prid)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cmdOpen(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.CommandText = &quot;UPDATE Production SET status= 1 WHERE prid= ?&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@prid&quot;, OleDbType.Numeric).Value = prid;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cmdClose(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.Write(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //************************************************************************************&nbsp; &nbsp; &nbsp; &nbsp; //auto id&nbsp; &nbsp; &nbsp; &nbsp; public int count_mi(int id)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int idx=0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OleDbCommand command = cls_Con.cn.CreateCommand();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command.CommandText = &quot;SELECT max(id) FROM MatI WHERE prid=&quot; + id;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (command.ExecuteScalar() != DBNull.Value)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; idx = Convert.ToInt32(command.ExecuteScalar());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command.Dispose();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return idx;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //Delete material issue&nbsp; &nbsp; &nbsp; &nbsp; public Boolean delmat(int prid)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cmdOpen(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.CommandText = &quot;Delete * From MatI where prid= ?&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmdForm.Parameters.Add(&quot;@prid&quot;, OleDbType.Numeric).Value = prid;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cls_Con.cmdClose(cmdForm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception exp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.Write(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(exp.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; finally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.cls_Con.cn.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}</blockquote>

[QUOTE="3.5G, post: 7936390, member: 158943"] using System; using System.Collections; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.OleDb; using System.Windows.Forms; namespace Nawco_Systemz.c_db { class jobOrder_db { clsOdbc cls_Con = new clsOdbc(); OleDbCommand cmdForm = new OleDbCommand(); //************************************************************************************ //auto id public int autoid() { int id = 0; OleDbCommand command = cls_Con.cn.CreateCommand(); command.CommandText = "SELECT MAX(prid) FROM production"; cls_Con.cn.Open(); if (command.ExecuteScalar() != DBNull.Value) id = Convert.ToInt32(command.ExecuteScalar()); cls_Con.cn.Close(); command.Dispose(); if (id == 0) { id = 7541; } else { id++; } return id; } //add JOB order public Boolean add_job_order(b_bis.jobOrder_bis ib) { try { this.cls_Con.cmdOpen(cmdForm); cmdForm.CommandText = "insert into Production(prid, aid, qty, sdate, edate, status) values (?,?,?,?,?,?)"; cmdForm.Parameters.Add("@prid", OleDbType.Numeric).Value = ib.p_joid; cmdForm.Parameters.Add("@aid", OleDbType.Char).Value = ib.p_asm.p_aid; cmdForm.Parameters.Add("@qty", OleDbType.Decimal).Value = ib.p_qty; cmdForm.Parameters.Add("@sdate", OleDbType.Date).Value = ib.p_jsdate; cmdForm.Parameters.Add("@edate", OleDbType.Date).Value = ib.p_jedate; cmdForm.Parameters.Add("@status", OleDbType.Numeric).Value = ib.p_status; cls_Con.cmdClose(cmdForm); return true; } catch (Exception exp) { Console.Write(exp.Message); MessageBox.Show(exp.Message); return false; } finally { this.cls_Con.cn.Close(); } } //add JOB _ items public Boolean add_job_material(b_bis.jobOrder_bis ib) {MessageBox.Show(ib.p_mt.p_mid); try { this.cls_Con.cmdOpen(cmdForm); cmdForm.CommandText = "insert into pro_mid(prid, mid, type, qty, price, avgprice) values (?,?,?,?,?,?)"; cmdForm.Parameters.Add("@prid", OleDbType.Numeric).Value = ib.p_joid; cmdForm.Parameters.Add("@mid", OleDbType.Char).Value = ib.p_mt.p_mid; cmdForm.Parameters.Add("@type", OleDbType.Char).Value = ib.p_descr; cmdForm.Parameters.Add("@qty", OleDbType.Decimal).Value = ib.p_qty; cmdForm.Parameters.Add("@price", OleDbType.Decimal).Value = ib.p_price; cmdForm.Parameters.Add("@avgprice", OleDbType.Decimal).Value = ib.p_avgprice; cls_Con.cmdClose(cmdForm); return true; } catch (Exception exp) { Console.Write(exp.Message); MessageBox.Show(exp.Message); return false; } finally { this.cls_Con.cn.Close(); } } //************************************************************************************************** //add JOB _ items public Boolean add_job_extra(b_bis.jobOrder_bis ib) { try { this.cls_Con.cmdOpen(cmdForm); cmdForm.CommandText = "insert into jo_other(prid, qty, descr, cost) values (?,?,?,?)"; cmdForm.Parameters.Add("@prid", OleDbType.Numeric).Value = ib.p_joid; cmdForm.Parameters.Add("@qty", OleDbType.Numeric).Value = ib.p_qty; cmdForm.Parameters.Add("@descr", OleDbType.Char).Value = ib.p_descr; cmdForm.Parameters.Add("@cost", OleDbType.Decimal).Value = ib.p_price; cls_Con.cmdClose(cmdForm); return true; } catch (Exception exp) { Console.Write(exp.Message); MessageBox.Show(exp.Message); return false; } finally { this.cls_Con.cn.Close(); } } //************************************************************************************************** //List assembly products public ArrayList list_search(string name, string opt, DateTime date1, DateTime date2) { ArrayList listg = new ArrayList(); string sql; try { sql = "SELECT Production.prid, Production.aid, Production.qty, Production.sdate, Assembly.name, Production.status" + " FROM Assembly INNER JOIN Production ON Assembly.aid = Production.aid"+ " WHERE Assembly.name LIKE '" + name + "%' ORDER BY Production.prid desc"; if (opt == "all") { sql = "SELECT Production.prid, Production.aid, Production.qty, Production.sdate, Assembly.name, Production.status" + " FROM Assembly INNER JOIN Production ON Assembly.aid = Production.aid ORDER BY Production.prid desc"; } else if (opt == "sts0") { sql = "SELECT Production.prid, Production.aid, Production.qty, Production.sdate, Assembly.name, Production.status" + " FROM Assembly INNER JOIN Production ON Assembly.aid = Production.aid WHERE Production.status=0 ORDER BY Production.prid desc"; } else if (opt == "date") { sql = "SELECT Production.prid, Production.aid, Production.qty, Production.sdate, Assembly.name, Production.status" + " FROM Assembly INNER JOIN Production ON Assembly.aid = Production.aid WHERE (Production.status=0)"+ " AND (Production.sdate BETWEEN #" + date1.ToString("d") + "# AND #" + date2.ToString("d") + "#)"+ " ORDER BY Production.prid desc"; } //MessageBox.Show(sql); OleDbCommand cmd = new OleDbCommand(sql, cls_Con.cn); cls_Con.cn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { b_bis.jobOrder_bis jt = new b_bis.jobOrder_bis(); b_bis.assembly_bis at = new b_bis.assembly_bis(); jt.p_joid = Convert.ToInt32(dr[0]); at.p_aid = (string)dr[1]; at.p_name = (string)dr[4]; jt.p_asm = at; jt.p_qty = Convert.ToDecimal(dr[2]); jt.p_jsdate = Convert.ToDateTime(dr[3]); jt.p_status = Convert.ToInt32(dr[5]); listg.Add(jt); } cls_Con.cn.Close(); cmd.Dispose(); dr.Close(); } catch (Exception exp) { MessageBox.Show("DB error : " + exp.Message); } finally { this.cls_Con.cn.Close(); } return listg; } //************************************************************************************ //List jobs //************************************************************************************ public ArrayList list_JO(int id) { ArrayList listx = new ArrayList(); string sql; try { sql = "select * from Production where prid =" + id; //MessageBox.Show(sql); OleDbCommand cmd = new OleDbCommand(sql, cls_Con.cn); cls_Con.cn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { b_bis.jobOrder_bis jt = new b_bis.jobOrder_bis(); b_bis.assembly_bis at = new b_bis.assembly_bis(); jt.p_joid = Convert.ToInt32(dr[0]); at.p_aid = (string)dr[1]; jt.p_asm = at; jt.p_qty = Convert.ToDecimal(dr[2]); jt.p_jsdate = Convert.ToDateTime(dr[3]); jt.p_jedate = Convert.ToDateTime(dr[4]); jt.p_status = Convert.ToInt32(dr[5]); //MessageBox.Show(met.p_mid + "-" + met.p_name + "-" + met.p_price + "-" + met.p_avgprice + "-" + met.p_qty + "-" + met.p_status); listx.Add(jt); } cls_Con.cn.Close(); cmd.Dispose(); dr.Close(); } catch (Exception exp) { MessageBox.Show("DB error : " + exp.Message); } finally { this.cls_Con.cn.Close(); } return listx; } //************************************************************************************ //List jobs material //************************************************************************************ public ArrayList list_pro_mid(int id) { ArrayList listx = new ArrayList(); string sql; try { sql = "SELECT pro_mid.prid, pro_mid.mid, pro_mid.qty, pro_mid.price, pro_mid.avgprice, Material.Name, pro_mid.type" + " FROM Material INNER JOIN pro_mid ON Material.mid = pro_mid.mid WHERE pro_mid.prid="+ id; //MessageBox.Show(sql); OleDbCommand cmd = new OleDbCommand(sql, cls_Con.cn); cls_Con.cn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { b_bis.jobOrder_bis jt = new b_bis.jobOrder_bis(); b_bis.material_bis mt = new b_bis.material_bis(); jt.p_joid = Convert.ToInt32(dr[0]); mt.p_mid = (string)dr[1]; mt.p_name = (string)dr[5]; jt.p_mt = mt; jt.p_qty = Convert.ToDecimal(dr[2]); jt.p_price = Convert.ToDecimal(dr[3]); jt.p_avgprice = Convert.ToDecimal(dr[4]); jt.p_descr = (string)dr[5]; listx.Add(jt); } cls_Con.cn.Close(); cmd.Dispose(); dr.Close(); } catch (Exception exp) { MessageBox.Show("DB error : " + exp.Message); } finally { this.cls_Con.cn.Close(); } return listx; } //************************************************************************************ //List jobs other expenses //************************************************************************************ public ArrayList list_pro_other(int id) { ArrayList listx = new ArrayList(); string sql; try { sql = "SELECT * FROM jo_other WHERE prid=" + id; //MessageBox.Show(sql); OleDbCommand cmd = new OleDbCommand(sql, cls_Con.cn); cls_Con.cn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { b_bis.jobOrder_bis jt = new b_bis.jobOrder_bis(); jt.p_descr = (string)dr[2]; jt.p_qty = Convert.ToDecimal(dr[3]); jt.p_price = Convert.ToDecimal(dr[4]); listx.Add(jt); } cls_Con.cn.Close(); cmd.Dispose(); dr.Close(); } catch (Exception exp) { MessageBox.Show("DB error : " + exp.Message); } finally { this.cls_Con.cn.Close(); } return listx; } //add JOB order public Boolean add_mati(b_bis.jobOrder_bis ib) { try { this.cls_Con.cmdOpen(cmdForm); cmdForm.CommandText = "insert into MatI(prid, mdate) values (?,?)"; cmdForm.Parameters.Add("@prid", OleDbType.Numeric).Value = ib.p_joid; cmdForm.Parameters.Add("@mdate", OleDbType.Date).Value = ib.p_jsdate; cls_Con.cmdClose(cmdForm); return true; } catch (Exception exp) { Console.Write(exp.Message); MessageBox.Show(exp.Message); return false; } finally { this.cls_Con.cn.Close(); } } //update JOB order public Boolean update_status(int prid) { try { this.cls_Con.cmdOpen(cmdForm); cmdForm.CommandText = "UPDATE Production SET status= 1 WHERE prid= ?"; cmdForm.Parameters.Add("@prid", OleDbType.Numeric).Value = prid; cls_Con.cmdClose(cmdForm); return true; } catch (Exception exp) { Console.Write(exp.Message); MessageBox.Show(exp.Message); return false; } finally { this.cls_Con.cn.Close(); } } //************************************************************************************ //auto id public int count_mi(int id) { int idx=0; OleDbCommand command = cls_Con.cn.CreateCommand(); command.CommandText = "SELECT max(id) FROM MatI WHERE prid=" + id; cls_Con.cn.Open(); if (command.ExecuteScalar() != DBNull.Value) { idx = Convert.ToInt32(command.ExecuteScalar()); } cls_Con.cn.Close(); command.Dispose(); return idx; } //Delete material issue public Boolean delmat(int prid) { try { this.cls_Con.cmdOpen(cmdForm); cmdForm.CommandText = "Delete * From MatI where prid= ?"; cmdForm.Parameters.Add("@prid", OleDbType.Numeric).Value = prid; cls_Con.cmdClose(cmdForm); return true; } catch (Exception exp) { Console.Write(exp.Message); MessageBox.Show(exp.Message); return false; } finally { this.cls_Con.cn.Close(); } } } } [/QUOTE]

Verification

Awruddata maasa keeyada?

Search

Latest ads

Reply to thread