public void ListBind2() { Tunnel.BLL.Tunnel_items ti = new Tunnel.BLL.Tunnel_items(); Tunnel.Model.Tunnel_items tii = new Tunnel.Model.Tunnel_items(); List <Tunnel.Model.Tunnel_items> ilist = new List <Tunnel.Model.Tunnel_items>(); DropDownList1.Items.Clear(); ilist = ti.GetModelList(" year='" + DropDownList2.SelectedValue + "' and moon='" + DropDownList3.SelectedValue + "'"); foreach (Tunnel.Model.Tunnel_items item in ilist) { DropDownList1.Items.Add(new ListItem(item.i_name, item.i_id.ToString())); } DropDownList1.Items.Insert(0, new ListItem("请选择", "0")); }
protected void btnSave_Click(object sender, EventArgs e) { Tunnel.BLL.Tunnel_items ti = new Tunnel.BLL.Tunnel_items(); Tunnel.Model.Tunnel_items tii = new Tunnel.Model.Tunnel_items(); tii.i_name = txtItems.Text.Trim(); tii.year = TextBox1.Text; tii.moon = TextBox2.Text; if (ti.GetModelList("1=1 and i_name = '" + tii.i_name + "' and year = '" + tii.year + "' and moon = '" + tii.moon + "'").Count == 0) { if (ti.Add(tii) > 0) { Tunnel.Common.Message.Show("添加工程项目成功!"); } else { Tunnel.Common.Message.Show("添加工程项目失败!"); } } else { Tunnel.Common.Message.Show("本月存在该项目!"); } }
public void ListBind() { DropDownList1.Items.Clear(); DropDownList2.Items.Clear(); DropDownList3.Items.Clear(); Tunnel.BLL.Tunnel_items ti = new Tunnel.BLL.Tunnel_items(); Tunnel.Model.Tunnel_items tii = new Tunnel.Model.Tunnel_items(); List <Tunnel.Model.Tunnel_items> ilist = new List <Tunnel.Model.Tunnel_items>(); for (int i = 2009; i < 2019; i++) { DropDownList2.Items.Add(new ListItem(i.ToString(), i.ToString())); } for (int i = 1; i < 13; i++) { if (i.ToString().Length == 2) { DropDownList3.Items.Add(new ListItem(i.ToString(), i.ToString())); } else { DropDownList3.Items.Add(new ListItem("0" + i.ToString(), "0" + i.ToString())); } } DateTime dt = DateTime.Now.AddMonths(-1); DropDownList2.Items.FindByValue(dt.Year.ToString()).Selected = true; DropDownList3.Items.FindByValue(dt.Month.ToString().Length > 1 ? dt.Month.ToString() : "0" + dt.Month.ToString()).Selected = true; ilist = ti.GetModelList(" year='" + DropDownList2.SelectedValue + "' and moon='" + DropDownList3.SelectedValue + "'"); foreach (Tunnel.Model.Tunnel_items item in ilist) { DropDownList1.Items.Add(new ListItem(item.i_name, item.i_id.ToString())); } DropDownList1.Items.Insert(0, new ListItem("请选择", "0")); }