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