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 trade_add()
{
InitializeComponent();
define_trade = new data_define.trade();
this.type_name.DataSource = oper_type.type_dt(0).DefaultView;
this.type_name.ValueMember = "type_id";
this.type_name.DisplayMember = "type_name";
}
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";
}
