public makeoverclass_update(data_define.makeover_class define_makeoverclass)
{
InitializeComponent();
oper_makeoverclass= new operation.o_makeoverclass();
_definemakeoverclass = new data_define.makeover_class();
_definemakeoverclass = define_makeoverclass;
}
public getwaterkind_update(data_define.getwater_kind define_getwaterkind)
{
InitializeComponent();
oper_getwaterkind = new operation.o_getwaterkind();
_definegetwaterkind = new data_define.getwater_kind();
_definegetwaterkind = define_getwaterkind;
}
public type_update(data_define.type define_type)
{
InitializeComponent();
oper_type = new operation.o_type();
_definetype=new data_define.type();
_definetype = define_type;
}
public List<data_define.trade> trade_listdt(data_define.trade model)
{
string str1 = "";
List<data_define.trade> _listtrade = new List<data_define.trade>();
if (model.trade_id > 0)
{ str1 = "where t_trade.trade_id=" + model.trade_id + ""; }
else if (model.type_id> 0)
{
if (str1.Length > 0)
{
str1 = str1 + " and t_trade.type_id='" + model.type_id + "'";
}
else
{
str1 = "where t_trade.type_id=" + model.type_id + "";
}
}
string sql = string.Format("SELECT t_trade.*, t_type.type_name AS type_name FROM t_type INNER JOIN t_trade ON t_type.type_id = t_trade.type_id " + str1);
DataTable ddt = sqlconn.DBIBase.Instance.ExecuteDataTable(sql);
if (ddt.Rows.Count > 0)
{
for (int i = 0; i < ddt.Rows.Count; i++)
{
data_define.trade _model = new data_define.trade();
_model.trade_id = int.Parse(ddt.Rows[i]["trade_id"].ToString());
_model.type_id = int.Parse(ddt.Rows[i]["type_id"].ToString());
_model.trade_name = ddt.Rows[i]["trade_name"].ToString();
_model.type_name = ddt.Rows[i]["type_name"].ToString();
_listtrade.Add(_model);
}
}
return _listtrade;
}
public makeoverkind_update(data_define.makeover_kind define_makeoverkind)
{
InitializeComponent();
oper_makeoverkind = new operation.o_makeoverkind();
_definemakeoverkind = new data_define.makeover_kind();
_definemakeoverkind = define_makeoverkind;
}
public List<data_define.type> type_listdt(data_define.type model)
{
string str1 = "";
List<data_define.type> _listtype = new List<data_define.type>();
if (model.type_id > 0)
{ str1 = "where t_type.type_id=" + model.type_id + ""; }
else if (model.type_name.Length > 0)
{
if (str1.Length > 0)
{
str1 = str1 + " and t_type.type_name='" + model.type_name + "'";
}
else
{
str1 = "where t_type.type_name=" + model.type_name + "";
}
}
string sql = string.Format("select * from t_type " + str1);
DataTable ddt=sqlconn.DBIBase.Instance.ExecuteDataTable(sql);
if(ddt.Rows.Count>0)
{
for(int i=0;i<ddt.Rows.Count;i++)
{
data_define.type _model = new data_define.type();
_model.type_id=int.Parse(ddt.Rows[i]["type_id"].ToString());
_model.type_name=ddt.Rows[i]["type_name"].ToString();
_listtype.Add(_model);
}
}
return _listtype;
}
public trade_update(data_define.trade define_trade)
{
InitializeComponent();
_definetrade = new data_define.trade();
_definetrade = define_trade;
operation.o_type oper_type = new operation.o_type();
//this
this.type_name.DataSource = oper_type.type_dt(0).DefaultView;
this.type_name.ValueMember = "type_id";
this.type_name.DisplayMember = "type_name";
}
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 bool add(data_define.trade model)
{
string sql = "";
if (model.type_id > 0)
{
sql = string.Format("select max(trade_id) as trade_id from t_trade where type_id=" + model.type_id);
DataTable dt = sqlconn.DBIBase.Instance.ExecuteDataTable(sql);
if (dt.Rows[0]["trade_id"].ToString()!=string.Empty)
{
model.trade_id = int.Parse(dt.Rows[0]["trade_id"].ToString()) + 1;
}
else
{
model.trade_id = int.Parse(model.type_id.ToString() + "01");
}
sql = string.Format("insert into t_trade(trade_id,type_id,trade_name) values ({0},{1},'{2}')", model.trade_id,model.type_id,model.trade_name);
}
return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql);
}
public bool exists(data_define.type model)
{
string str1 = "";
if (model.type_id > 0)
{ str1 = "where t_type.type_id=" +model.type_id + ""; }
else if (model.type_name.Length > 0)
{
if(str1.Length>0)
{
str1 = str1 + " and t_type.type_name='" + model.type_name + "'";
}
else
{
str1 = "where t_type.type_name=" + model.type_name + "";
}
}
string sql = string.Format("select * from t_type " + str1);
return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql);
}
public List<data_define.getwater_kind> getwaterkind_listdt(data_define.getwater_kind model)
{
string str1 = "";
List<data_define.getwater_kind> _listgetwaterkind = new List<data_define.getwater_kind>();
if (model.getwater_kind_id > 0)
{ str1 = "where t_getwater_kind.getwater_kind_id=" + model.getwater_kind_id + ""; }
string sql = string.Format("select * from t_getwater_kind " + str1);
DataTable ddt = sqlconn.DBIBase.Instance.ExecuteDataTable(sql);
if (ddt.Rows.Count > 0)
{
for (int i = 0; i < ddt.Rows.Count; i++)
{
data_define.getwater_kind _model = new data_define.getwater_kind();
_model.getwater_kind_id = int.Parse(ddt.Rows[i]["getwater_kind_id"].ToString());
_model.getwater_kind_name= ddt.Rows[i]["getwater_kind_name"].ToString();
_model.remark = ddt.Rows[i]["remark"].ToString();
_listgetwaterkind.Add(_model);
}
}
return _listgetwaterkind;
}
public List<data_define.makeover_class> makeoverclass_listdt(data_define.makeover_class model)
{
string str1 = "";
List<data_define.makeover_class> _listmakeoverclass = new List<data_define.makeover_class>();
if (model.makeover_classid> 0)
{ str1 = "where t_makeover_class.makeover_classid=" + model.makeover_classid + ""; }
string sql = string.Format("select * from t_makeover_class " + str1);
DataTable ddt = sqlconn.DBIBase.Instance.ExecuteDataTable(sql);
if (ddt.Rows.Count > 0)
{
for (int i = 0; i < ddt.Rows.Count; i++)
{
data_define.makeover_class _model = new data_define.makeover_class();
_model.makeover_classid= int.Parse(ddt.Rows[i]["makeover_classid"].ToString());
_model.makeover_class_name = ddt.Rows[i]["makeover_class_name"].ToString();
_model.remark = ddt.Rows[i]["remark"].ToString();
_listmakeoverclass.Add(_model);
}
}
return _listmakeoverclass;
}
public bool add(data_define.makeover_class model)
{
string sql = string.Format("insert into t_makeover_class(makeover_class_name,remark) values ('{0}','{1}')", model.makeover_class_name, model.remark);
return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql);
}
public bool update(data_define.makeover_class model)
{
return data_makeoverclass.update(model);
}
public bool add(data_define.getwater_kind model)
{
string sql = string.Format("insert into t_getwater_kind(getwater_kind_name,remark) values ('{0}','{1}')", model.getwater_kind_name,model.remark);
return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool add(data_define.makeover_class model)
{
return data_makeoverclass.add(model);
}
public List<data_define.makeover_class> dt(data_define.makeover_class model)
{
//List<type> tt=new List<type>();
return data_makeoverclass.makeoverclass_listdt(model);
}
public bool update(data_define.makeover_class model)
{
string sql = string.Format("update t_makeover_class set makeover_class_name='{0}',remark='{1}' where makeover_class_id={2}", model.makeover_class_name, model.remark, model.makeover_classid);
return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool add(data_define.wateruser model)
{
return data_wateruser.add(model);
}
public bool update(data_define.getwater_kind model)
{
string sql = string.Format("update t_getwater_kind set getwater_kind_name='{0}',remark='{1}' where getwater_kind_id={2}", model.getwater_kind_name,model.remark,model.getwater_kind_id);
return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool add(data_define.trade model)
{
return data_trade.add(model);
}
public bool update(data_define.type model)
{
string sql = string.Format("update t_type set type_name='{0}' where type_id={1}", model.type_name, model.type_id);
return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql);
}
public DataTable dt(data_define.wateruser model)
{
return data_wateruser.wateruserdt(model);
}
public bool update(data_define.makeover_kind model)
{
return data_makeoverkind.update(model);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool add(data_define.makeover_kind model)
{
return data_makeoverkind.add(model);
}
//sqlconn.DBIBase dbi = new sqlconn.DBIBase("");
public bool add(data_define.type model)
{
string sql = string.Format("insert into t_type(type_name) values ('{0}')", model.type_name);
return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql);
}
public bool update(data_define.trade model)
{
return data_trade.update(model);
}
public List<data_define.trade> dt(data_define.trade model)
{
//List<type> tt=new List<type>();
return data_trade.trade_listdt(model);
}
public List<data_define.makeover_kind> dt(data_define.makeover_kind model)
{
//List<type> tt=new List<type>();
return data_makeoverkind.makeoverkind_listdt(model);
}
public bool add(data_define.linkman model)
{
string sql = string.Format("insert into t_linkman(wateruser_id,is_check,name,branch,duty,phone,handphone,isnote)"
+ " values({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}')",model.wateruser_id,model.is_check,model.name,model.branch,model.duty,model.phone,model.handphone,model.isnote);
return sqlconn.DBIBase.Instance.ExecuteNonQuery(sql);
}
