public List <AM_盘点清查主表> 查询盘点主表()
{
string sql = "SELECT ID,盘点名称 FROM dbo.AM_盘点清查主表 where 是否关闭='否' order by 创建时间 desc";
SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
List <AM_盘点清查主表> list = new List <AM_盘点清查主表>();
while (read.Read())
{
AM_盘点清查主表 model = new AM_盘点清查主表();
model.ID = Convert.ToInt32(read["ID"]);
model.盘点名称 = read["盘点名称"].ToString();
list.Add(model);
}
return(list);
}
protected void Button2_Click(object sender, EventArgs e)
{
AM_盘点清查主表 model = new AM_盘点清查主表();
model.创建人 = 创建人.Text;
model.创建时间 = DateTime.Now;
model.盘点范围 = 盘点范围.SelectedText;
model.盘点名称 = 任务标题.Text;
model.是否关闭 = "否";
model.盘点方式 = "";
//int oky = bll.创建盘点主表(model);
if (bll.创建盘点主表(model) > 0)
{
//提示信息
Alert alert = new Alert();
alert.Message = "创建成功，各单位盘点结束后请关闭";
alert.Title = "提示信息";
alert.MessageBoxIcon = MessageBoxIcon.Success;
alert.Show();
Window1.Hidden = true;
}
}
public int 创建盘点主表(AM_盘点清查主表 model)
{
return(sql.创建盘点主表(model));
}
public int 创建盘点主表(AM_盘点清查主表 model)
{
string sql = string.Format("INSERT INTO dbo.AM_盘点清查主表(创建人,盘点范围,盘点方式,创建时间,盘点名称,备注,是否关闭 ) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", model.创建人, model.盘点范围, model.盘点方式, model.创建时间, model.盘点名称, model.备注, model.是否关闭);
return(Convert.ToInt32(DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql)));
}
