protected void Page_Load(object sender, EventArgs e)
{
string id = "";
//CheckBoxList_Reciever初始化
if (!IsPostBack)
{
try
{
id = Request.QueryString[0].ToString();
this.Label1.Text = id;
}
catch { }
if (id == "")
{
this.begindate.Text = DateTime.Now.ToShortDateString();
this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString();
}
else
{
//绑定CheckBoxList前面的部分
Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material();
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
model = bll2.GetModel(int.Parse(id));
this.Name.Text = model.Name;
this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString();
this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString();
//绑定是否显示过期
if (model.Outdisplay == "是")
{
this.CheckBox1.Checked = true;
}
//绑定CheckBoxList
DataSet ds = new DataSet();
Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver();
ds = bll.W_Receiver_Mid(id);
this.CheckBoxList_Reciever.DataSource = ds;
CheckBoxList_Reciever.DataTextField = "Receiver";
CheckBoxList_Reciever.DataValueField = "Id";
CheckBoxList_Reciever.DataBind();
//添加选定内容 陈湘军
//修改存储过程 W_Receiver_Mid，添加dormacy字段
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
CheckBoxList_Reciever.Items[i].Selected = (ds.Tables[0].Rows[i]["dormacy"].ToString() == "提交");
}
catch { }
}
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.W_Material model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update W_Material set ");
strSql.Append("Name=@Name,");
strSql.Append("Begindate=@Begindate,");
strSql.Append("Enddate=@Enddate,");
strSql.Append("Number=@Number,");
strSql.Append("Address=@Address");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
new SqlParameter("@Begindate", SqlDbType.DateTime),
new SqlParameter("@Enddate", SqlDbType.DateTime),
new SqlParameter("@Number", SqlDbType.VarChar, 150),
new SqlParameter("@Address", SqlDbType.VarChar, 150),
};
parameters[0].Value = model.Id;
parameters[1].Value = model.Name;
parameters[2].Value = model.Begindate;
parameters[3].Value = model.Enddate;
parameters[4].Value = model.Number;
parameters[5].Value = model.Address;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.W_Material model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into W_Material(");
strSql.Append("Name,Begindate,Enddate,Number,Address)");
strSql.Append(" values (");
strSql.Append("@Name,@Begindate,@Enddate,@Number,@Address)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
new SqlParameter("@Begindate", SqlDbType.DateTime),
new SqlParameter("@Enddate", SqlDbType.DateTime),
new SqlParameter("@Number", SqlDbType.VarChar, 150),
new SqlParameter("@Address", SqlDbType.VarChar, 150)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Begindate;
parameters[2].Value = model.Enddate;
parameters[3].Value = model.Number;
parameters[4].Value = model.Address;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (this.Name.Text == "")
{
this.Label2.Text = "请输入材料名";
return;
}
//对Material表的输入
DateTime begindate = Convert.ToDateTime(this.begindate.Text);
DateTime enddate = Convert.ToDateTime(this.enddate.Text);
string name = this.Name.Text.Trim();
string address = this.TextBox_Address.Text.Trim();
string number = this.TextBox_Number.Text.Trim();
Maticsoft.Model.W_Material material = new Maticsoft.Model.W_Material();
Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material();
material.Name = name;
material.Begindate = begindate;
material.Enddate = enddate;
material.Address = address;
material.Number = number;
int id;
if (this.Label1.Text == "")
{
id = bll.Add(material);
}
else
{
id = int.Parse(this.Label1.Text.Trim());
bll.Update(material);
}
Maticsoft.Model.W_Receivestate receivestate = new Maticsoft.Model.W_Receivestate();
Maticsoft.BLL.W_Receivestate bllstate = new Maticsoft.BLL.W_Receivestate();
receivestate.MaterialId = id;
//对W_Receivestate表的操作
bllstate.Delete(id);
for (int i = 0; i < this.CheckBoxList_Reciever.Items.Count; i++)
{
if (this.CheckBoxList_Reciever.Items[i].Selected)
{
receivestate.ReceiverId = this.CheckBoxList_Reciever.Items[i].Value;
bllstate.Add(receivestate);
}
}
if (id > 1)
{
//this.Label_Msg.Text = "提交成功!";
}
Response.Redirect("ManagerMaterial.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
string id = "";
//CheckBoxList_Reciever初始化
if (!IsPostBack)
{
try
{
id = Request.QueryString[0].ToString();
this.Label1.Text = id;
}
catch { }
DataSet ds = new DataSet();
Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver();
ds = bll.GetAllList();
this.CheckBoxList_Reciever.DataSource = ds;
CheckBoxList_Reciever.DataTextField = "Receiver";
CheckBoxList_Reciever.DataValueField = "Id";
CheckBoxList_Reciever.DataBind();
if (id == "")
{
this.TextBox_Address.Text = "http://kjc.jstu.edu.cn/news.aspx?id=205";
this.TextBox_Number.Text = "申报书一式三份，活页7份";
this.begindate.Text = DateTime.Now.ToShortDateString();
this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString();
}
else
{
Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material();
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
model = bll2.GetModel(int.Parse( id));
this.Name.Text = model.Name;
this.begindate.Text = (Convert.ToDateTime( model.Begindate)).ToShortDateString();
this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString();
this.TextBox_Address.Text = model.Address;
this.TextBox_Number.Text = model.Number;
DataSet ds2 = new DataSet();
Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate();
ds2 = bll3.GetList("MaterialId=" + id);
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
int j = int.Parse(ds2.Tables[0].Rows[i][2].ToString());
this.CheckBoxList_Reciever.Items[j-1].Selected=true ;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = "";
//CheckBoxList_Reciever初始化
if (!IsPostBack)
{
try
{
id = Request.QueryString[0].ToString();
this.Label1.Text = id;
}
catch { }
DataSet ds = new DataSet();
Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver();
ds = bll.GetAllList();
this.CheckBoxList_Reciever.DataSource = ds;
CheckBoxList_Reciever.DataTextField = "Receiver";
CheckBoxList_Reciever.DataValueField = "Id";
CheckBoxList_Reciever.DataBind();
if (id == "")
{
this.TextBox_Address.Text = "http://kjc.jstu.edu.cn/news.aspx?id=205";
this.TextBox_Number.Text = "申报书一式三份，活页7份";
this.begindate.Text = DateTime.Now.ToShortDateString();
this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString();
}
else
{
Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material();
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
model = bll2.GetModel(int.Parse(id));
this.Name.Text = model.Name;
this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString();
this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString();
this.TextBox_Address.Text = model.Address;
this.TextBox_Number.Text = model.Number;
DataSet ds2 = new DataSet();
Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate();
ds2 = bll3.GetList("MaterialId=" + id);
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
int j = int.Parse(ds2.Tables[0].Rows[i][2].ToString());
this.CheckBoxList_Reciever.Items[j - 1].Selected = true;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = "";
//CheckBoxList_Reciever初始化
if (!IsPostBack)
{
try
{
id = Request.QueryString[0].ToString();
this.Label1.Text = id;
}
catch { }
if (id == "")
{
this.begindate.Text = DateTime.Now.ToShortDateString();
this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString();
}
else
{
//绑定CheckBoxList前面的部分
Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material();
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
model = bll2.GetModel(int.Parse(id));
this.Name.Text = model.Name;
this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString();
this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString();
//绑定CheckBoxList
DataSet ds = new DataSet();
Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver();
ds = bll.W_Receiver_Mid(id);
this.CheckBoxList_Reciever.DataSource = ds;
CheckBoxList_Reciever.DataTextField = "Receiver";
CheckBoxList_Reciever.DataValueField = "Id";
CheckBoxList_Reciever.DataBind();
}
}
}
///// <summary>
///// 更新一条记录是否过期显示问题
///// </summary>
//public void Delete(int Id)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("update W_Material set ");
// strSql.Append("OutDisplay=@OutDisplay");
// strSql.Append(" where Id=@Id ");
// SqlParameter[] parameters = {
// new SqlParameter("@Id", SqlDbType.Int,4),
// new SqlParameter("@OutDisplay", SqlDbType.Char,10)};
// parameters[0].Value = Id;
// DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
//}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.W_Material GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,Name,Begindate,Enddate,Number,Address,Outdisplay from W_Material ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
if (ds.Tables[0].Rows[0]["Begindate"].ToString() != "")
{
model.Begindate = DateTime.Parse(ds.Tables[0].Rows[0]["Begindate"].ToString());
}
if (ds.Tables[0].Rows[0]["Enddate"].ToString() != "")
{
model.Enddate = DateTime.Parse(ds.Tables[0].Rows[0]["Enddate"].ToString());
}
model.Number = ds.Tables[0].Rows[0]["Number"].ToString();
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
if (ds.Tables[0].Rows[0]["Outdisplay"].ToString() != "")
{
model.Outdisplay = ds.Tables[0].Rows[0]["Outdisplay"].ToString();
}
return(model);
}
else
{
return(null);
}
}
protected void Bind(int Id)
{
Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material();
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
model = bll.GetModel(Id);
this.lblId.Text = model.Id.ToString();
this.lblName.Text = model.Name;
this.lblBeginDate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString();
this.lblEnddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString();
this.Label_Address.Text = model.Address;
this.Label_Number.Text = model.Number;
DataSet ds2 = new DataSet();
Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate();
ds2 = bll3.GetList("MaterialId=" + Id);
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
int j = int.Parse(ds2.Tables[0].Rows[i][2].ToString());
Maticsoft.BLL.W_Receiver bll4 = new Maticsoft.BLL.W_Receiver();
Maticsoft.Model.W_Receiver model4 = new Maticsoft.Model.W_Receiver();
model4 = bll4.GetModel(j);
this.lblReceiver.Text += model4.Receiver + " ";
}
DataSet ds5 = new DataSet();
Maticsoft.BLL.W_Receivestate bll5 = new Maticsoft.BLL.W_Receivestate();
ds5 = bll5.GetList("MaterialId=" + Id + "and Dormacy = '提交'");
for (int i = 0; i < ds5.Tables[0].Rows.Count; i++)
{
int j = int.Parse(ds5.Tables[0].Rows[i][2].ToString());
Maticsoft.BLL.W_Receiver bll4 = new Maticsoft.BLL.W_Receiver();
Maticsoft.Model.W_Receiver model4 = new Maticsoft.Model.W_Receiver();
model4 = bll4.GetModel(j);
this.Label_IsHanded.Text += model4.Receiver + " ";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = "";
//CheckBoxList_Reciever初始化
if (!IsPostBack)
{
try
{
id = Request.QueryString[0].ToString();
this.Label1.Text = id;
}
catch { }
if (id == "")
{
this.begindate.Text = DateTime.Now.ToShortDateString();
this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString();
}
else
{
//绑定CheckBoxList前面的部分
Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material();
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
model = bll2.GetModel(int.Parse(id));
this.Name.Text = model.Name;
this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString();
this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString();
//绑定CheckBoxList
DataSet ds = new DataSet();
Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver();
ds = bll.W_Receiver_Mid(id);
this.CheckBoxList_Reciever.DataSource = ds;
CheckBoxList_Reciever.DataTextField = "Receiver";
CheckBoxList_Reciever.DataValueField = "Id";
CheckBoxList_Reciever.DataBind();
}
}
}
protected void Bind(int Id)
{
Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material();
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
model = bll.GetModel(Id);
this.lblId.Text = model.Id.ToString();
this.lblName.Text = model.Name;
this.lblBeginDate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString();
this.lblEnddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString();
this.Label_Address.Text = model.Address;
this.Label_Number.Text = model.Number;
DataSet ds2 = new DataSet();
Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate();
ds2 = bll3.GetList("MaterialId=" + Id);
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
int j = int.Parse(ds2.Tables[0].Rows[i][2].ToString());
Maticsoft.BLL.W_Receiver bll4 = new Maticsoft.BLL.W_Receiver();
Maticsoft.Model.W_Receiver model4 = new Maticsoft.Model.W_Receiver();
model4 = bll4.GetModel(j);
this.lblReceiver.Text += model4.Receiver + " ";
}
DataSet ds5 = new DataSet();
Maticsoft.BLL.W_Receivestate bll5 = new Maticsoft.BLL.W_Receivestate();
ds5 = bll5.GetList("MaterialId=" + Id + "and Dormacy = '提交'");
for (int i = 0; i < ds5.Tables[0].Rows.Count; i++)
{
int j = int.Parse(ds5.Tables[0].Rows[i][2].ToString());
Maticsoft.BLL.W_Receiver bll4 = new Maticsoft.BLL.W_Receiver();
Maticsoft.Model.W_Receiver model4 = new Maticsoft.Model.W_Receiver();
model4 = bll4.GetModel(j);
this.Label_IsHanded.Text += model4.Receiver + " ";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = "";
//CheckBoxList_Reciever初始化
if (!IsPostBack)
{
try
{
id = Request.QueryString[0].ToString();
this.Label1.Text = id;
}
catch { }
if (id == "")
{
this.begindate.Text = DateTime.Now.ToShortDateString();
this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString();
}
else
{
//绑定CheckBoxList前面的部分
Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material();
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
model = bll2.GetModel(int.Parse(id));
this.Name.Text = model.Name;
this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString();
this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString();
//绑定是否显示过期
if (model.Outdisplay == "是")
this.CheckBox1.Checked = true;
//绑定CheckBoxList
DataSet ds = new DataSet();
Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver();
ds = bll.W_Receiver_Mid(id);
this.CheckBoxList_Reciever.DataSource = ds;
CheckBoxList_Reciever.DataTextField = "Receiver";
CheckBoxList_Reciever.DataValueField = "Id";
CheckBoxList_Reciever.DataBind();
//添加选定内容 陈湘军
//修改存储过程 W_Receiver_Mid，添加dormacy字段
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
CheckBoxList_Reciever.Items[i].Selected = (ds.Tables[0].Rows[i]["dormacy"].ToString() == "提交");
}
catch { }
}
}
}
}
}
///// <summary>
///// 更新一条记录是否过期显示问题
///// </summary>
//public void Delete(int Id)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("update W_Material set ");
// strSql.Append("OutDisplay=@OutDisplay");
// strSql.Append(" where Id=@Id ");
// SqlParameter[] parameters = {
// new SqlParameter("@Id", SqlDbType.Int,4),
// new SqlParameter("@OutDisplay", SqlDbType.Char,10)};
// parameters[0].Value = Id;
// DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
//}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.W_Material GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,Name,Begindate,Enddate,Number,Address,Outdisplay from W_Material ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = Id;
Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
if (ds.Tables[0].Rows[0]["Begindate"].ToString() != "")
{
model.Begindate = DateTime.Parse(ds.Tables[0].Rows[0]["Begindate"].ToString());
}
if (ds.Tables[0].Rows[0]["Enddate"].ToString() != "")
{
model.Enddate = DateTime.Parse(ds.Tables[0].Rows[0]["Enddate"].ToString());
}
model.Number = ds.Tables[0].Rows[0]["Number"].ToString();
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
if (ds.Tables[0].Rows[0]["Outdisplay"].ToString() != "")
{
model.Outdisplay = ds.Tables[0].Rows[0]["Outdisplay"].ToString();
}
return model;
}
else
{
return null;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (this.Name.Text == "")
{
this.Label2.Text = "请输入材料名";
return;
}
//对Material表的输入
DateTime begindate = Convert .ToDateTime (this .begindate .Text );
DateTime enddate = Convert.ToDateTime(this.enddate .Text);
string name = this.Name .Text.Trim();
string address = this.TextBox_Address.Text.Trim();
string number = this.TextBox_Number.Text.Trim();
Maticsoft.Model.W_Material material = new Maticsoft.Model.W_Material();
Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material();
material.Name = name;
material.Begindate = begindate;
material.Enddate = enddate;
material.Address = address;
material.Number = number;
int id;
if (this.Label1.Text == "")
id = bll.Add(material);
else
{
id = int.Parse( this.Label1.Text.Trim());
bll.Update(material);
}
Maticsoft.Model.W_Receivestate receivestate = new Maticsoft.Model.W_Receivestate();
Maticsoft.BLL.W_Receivestate bllstate = new Maticsoft.BLL.W_Receivestate();
receivestate.MaterialId = id;
//对W_Receivestate表的操作
bllstate.Delete(id);
for (int i = 0; i < this.CheckBoxList_Reciever.Items.Count; i++)
{
if (this.CheckBoxList_Reciever.Items[i].Selected)
{
receivestate.ReceiverId = this.CheckBoxList_Reciever.Items[i].Value;
bllstate.Add(receivestate);
}
}
if (id > 1)
{
//this.Label_Msg.Text = "提交成功!";
}
Response.Redirect("ManagerMaterial.aspx");
}
