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