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