protected void Button1_Click(object sender, EventArgs e)
{
School盘点任务表 model = new School盘点任务表();
model.称 = this.项目名称.Text;
model.盘点单号 = 单号.Text;
model.起始时间 = Convert.ToDateTime(DatePicker1.Text);
model.截止时间 = Convert.ToDateTime(DatePicker2.Text);
model.等级 = 1;
//后续判断下checked
model.清查范围 = rbtnFirst.Text;
model.清查ID = "全部";
model.完成状态 = "进行中";
model.盘点方式 = RadioButton1.Text;
model.备注 = TextBox1.Text;
model.学校ID = 1;
model.盘点完成 = "1";
School清查盘点BLL bll = new School清查盘点BLL();
if (bll.addpdrw(model))
{
Alert.Show("chengg！");
Window1.Hidden = true;
//Window1.Hidden();
}
else
{
Alert.Show("xxx！");
}
}
public Boolean addpdrw(School盘点任务表 model)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT ");
sb.Append(" INTO");
sb.Append(" 盘点任务表 (名称,盘点单号,起始时间,截止时间,等级,清查范围,清查ID,盘点方式,描述,学校ID,盘点完成,完成状态)");
sb.Append("VALUES");
sb.Append("(");
sb.Append(" @名称");
sb.Append(",@盘点单号");
sb.Append(",@起始时间");
sb.Append(",@截止时间");
sb.Append(",@等级");
sb.Append(",@清查范围");
sb.Append(",@清查ID");
sb.Append(",@盘点方式");
sb.Append(",@描述");
sb.Append(",@学校ID");
sb.Append(",@盘点完成");
sb.Append(",@完成状态");
sb.Append(" )");
SqlParameter[] para =
{
new SqlParameter("@名称", model.称),
new SqlParameter("@盘点单号", model.盘点单号),
new SqlParameter("@起始时间", model.起始时间),
new SqlParameter("@截止时间", model.截止时间),
new SqlParameter("@等级", model.等级),
new SqlParameter("@清查范围", model.清查范围),
new SqlParameter("@清查ID", model.清查ID),
new SqlParameter("@盘点方式", model.盘点方式),
new SqlParameter("@描述", model.备注),
new SqlParameter("@学校ID", model.学校ID),
new SqlParameter("@盘点完成", model.盘点完成),
new SqlParameter("@完成状态", model.完成状态),
};
int insertNum = DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sb.ToString(), para);
if (insertNum > 0)
{
return(true);
}
else
{
return(false);
}
}
public Boolean addpdrw(School盘点任务表 model)
{
return(us.addpdrw(model));
}
