public type_add() { InitializeComponent(); define_type = new data_define.type(); oper_type = new operation.o_type(); }
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; }