物料管理体系

物料管理体系
可对于物料举行收支库注销、盘问、统计等操作123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Windows.Forms;namespaceFORU_SMS_.BaseClass{publicclassDataClass{BaseClass.DataConnDconn=newDataConn();SqlDataAdapterMysda;DataSetMyds;DataTableMydt;SqlCo妹妹andSqlCom;//返回一个DataSetpublicDataSetGetDataSet(stringsql,stringdt){Mysda=newSqlDataAdapter(sql,Dconn.OpenConn());Myds=newDataSet();Mysda.Fill(Myds,dt);returnMyds;}//绑定ComboBox控件publicvoidBindComboBox(stringsql,stringdt,stringPar_Name,ComboBoxcbox){Myds=GetDataSet(sql,dt);cbox.DataSource=Myds.Tables[dt];cbox.DisplayMember=Par_Name;}//实施SQL语句，无返回值publicvoidExecuteSql(stringsql){try{SqlCom=newSqlCo妹妹and(sql,Dconn.OpenConn());SqlCom.ExecuteNonQuery();}catch(Exceptione){thrownewException(e.Message);}finally{Dconn.CloseConn();}}//验证用户上岸publicboolChkLogin(stringtxtUser,stringtxtPass){boolstrEnter=false;