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