private void bindDdl()
{
DataTable mydt = new DataTable("cs");
DataColumn dc = null;
dc = mydt.Columns.Add("cid", Type.GetType("System.Int32"));
dc = mydt.Columns.Add("cname", Type.GetType("System.String"));
DataRow newRow;
newRow = mydt.NewRow();
newRow["cid"] = "1";
newRow["cname"] = "是";
mydt.Rows.Add(newRow);
newRow = mydt.NewRow();
newRow["cid"] = "0";
newRow["cname"] = "否";
mydt.Rows.Add(newRow);
this.txtstatus.DataSource = mydt;
txtstatus.DisplayMember = "cname";
txtstatus.ValueMember = "cid";
BLL.tb_order dalo = new BLL.tb_order();
DataTable dt = dalo.GetList(1000, "o_type=1", "o_id desc").Tables[0];
this.txtorder.DataSource = dt;
txtorder.DisplayMember = "o_no";
txtorder.ValueMember = "o_id";
}
private void bindDdl()
{
BLL.tb_order dalo = new BLL.tb_order();
DataTable dt = dalo.GetList(1000, "o_type=2", "o_id desc").Tables[0];
this.txtorder.DataSource = dt;
txtorder.DisplayMember = "o_no";
txtorder.ValueMember = "o_id";
}
private void bindData(string where)
{
DataSet ds = dal.GetList(String.IsNullOrEmpty(where) ? " " : where);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "订单编号";
dataGridView1.Columns[2].HeaderText = "下单时间";
dataGridView1.Columns[3].HeaderText = "商品编号";
dataGridView1.Columns[4].HeaderText = "商品名称";
dataGridView1.Columns[5].HeaderText = "订单数量";
dataGridView1.Columns[6].HeaderText = "订单总额";
dataGridView1.Columns[7].HeaderText = "客户姓名";
dataGridView1.Columns[8].HeaderText = "客户电话";
dataGridView1.Columns[9].HeaderText = "客户地址";
dataGridView1.Columns[10].HeaderText = "所在地邮编";
dataGridView1.Columns[11].HeaderText = "提货人姓名";
dataGridView1.Columns[12].HeaderText = "备注说明";
dataGridView1.Columns[13].Visible = false;
dataGridView1.Columns[14].Visible = false;
}
private void bindDdl()
{
BLL.tb_order dalo = new BLL.tb_order();
DataTable dt = dalo.GetList(1000, "o_type=3", "o_type desc").Tables[0];
}
