public wateruser_add() { InitializeComponent(); define_wateruser = new data_define.wateruser(); oper_wateruser = new operation.o_wateruser(); oper_trade = new operation.o_trade(); oper_getwaterkind = new operation.o_getwaterkind(); oper_type = new operation.o_type(); }
//public bool update(data_define.trade model) //{ // string sql = ""; // if (model.trade_id > 0) // { // int tradeid = model.trade_id; // sql = string.Format("select max(trade_id) from t_trade where type_id=" + model.type_id); // DataTable dt = sqlconn.DBIBase.Instance.ExecuteDataTable(sql); // if (dt.Rows.Count > 0) // { // model.trade_id = int.Parse(dt.Rows[0]["trade_id"].ToString()) + 1; // } // sql = string.Format("update t_trade set trade_id={0},type_id={1},trade_name='{2}' where trade_id={3})", model.trade_id, model.type_id, model.trade_name, tradeid); // } // return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql); //} public List<data_define.wateruser> wateruser_listdt(data_define.wateruser model) { string str1 = ""; List<data_define.wateruser> _listwateruser = new List<data_define.wateruser>(); if (model.wateruser_id > 0) { str1 = "where t_wateruser.wateruser_id=" + model.wateruser_id + ""; } else if (model.trade_id > 0) { if (str1.Length > 0) { str1 = str1 + " and t_wateruser.trade_id='" + model.trade_id + "'"; } else { str1 = "where t_wateruser.trade_id=" + model.trade_id + ""; } } string sql = string.Format("SELECT * from v_wateruser " + str1); DataTable ddt = sqlconn.DBIBase.Instance.ExecuteDataTable(sql); if (ddt.Rows.Count > 0) { for (int i = 0; i < ddt.Rows.Count; i++) { data_define.wateruser _model = new data_define.wateruser(); _model.wateruser_id = int.Parse(ddt.Rows[i]["wateruser_id"].ToString()); _model.waterusername = ddt.Rows[i]["wateruser"].ToString(); _model.wateruser_num = ddt.Rows[i]["wateruser_num"].ToString(); _model.corporate = ddt.Rows[i]["corporate"].ToString(); _model.address = ddt.Rows[i]["address"].ToString(); _model.post = ddt.Rows[i]["post"].ToString(); _model.fax = ddt.Rows[i]["fax"].ToString(); _model.email = ddt.Rows[i]["email"].ToString(); _model.trade_id = int.Parse(ddt.Rows[i]["trade_id"].ToString()); //_model.photo=byte[]() _model.is_economize = ddt.Rows[i]["is_economize"].ToString(); _model.test_year = int.Parse(ddt.Rows[i]["test_year"].ToString()); _model.getwater_kind_id = int.Parse(ddt.Rows[i]["getwater_kind_id"].ToString()); _model.getwater_num = ddt.Rows[i]["getwater_num"].ToString(); _model.waterbeed = ddt.Rows[i]["waterbeed"].ToString(); _model.watermeter_num = int.Parse(ddt.Rows[i]["watermeter_num"].ToString()); _model.waterpeople = int.Parse(ddt.Rows[i]["waterpeople"].ToString()); _model.waterpeople_unit = ddt.Rows[i]["waterpeople_unit"].ToString(); _model.year_output = int.Parse(ddt.Rows[i]["year_output"].ToString()); _model.unit = ddt.Rows[i]["unit"].ToString(); _model.remark = ddt.Rows[i]["remark"].ToString(); _model.trade_name = ddt.Rows[i]["tradename"].ToString(); _model.getwater_kindname = ddt.Rows[i]["getwater_kind_name"].ToString(); _listwateruser.Add(_model); } } return _listwateruser; }