protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); ProjectPaperBll projectPaperBll = new ProjectPaperBll(); Label label = (Label)this.GridView1.Rows[e.RowIndex].FindControl("lbID"); TextBox textBox = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtName"); DropDownList CboTP2; CboTP2 = (DropDownList)this.GridView1.Rows[e.RowIndex].FindControl("CboTP2"); if (label != null && textBox != null) { projectPaperEntity.PPID = Convert.ToInt32(label.Text.ToString()); // projectPaperEntity.PTID = txtName2; projectPaperEntity.PTID = int.Parse(CboTP2.SelectedValue); projectPaperEntity.Name = textBox.Text.ToString(); projectPaperEntity.FhdateTime = DateTime.Now; if (projectPaperBll.Update2(projectPaperEntity)) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "msg", "alert('更新成功');", true); } else { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "msg", "alert('更新失败');", true); } } this.GridView1.EditIndex = -1; this.LoadData(0, ""); }
public void Asp5(GridView gv, AspNetPager pager, ProjectPaperEntity en) { SqlParameter[] para = new SqlParameter[4]; para[0] = new SqlParameter("@PPID", SqlDbType.Int); para[0].Value = en.PPID; para[1] = new SqlParameter("@Name", SqlDbType.VarChar, 256); para[1].Value = en.Name; para[2] = new SqlParameter("@PTID", SqlDbType.Int); para[2].Value = en.PTID; para[3] = new SqlParameter("@ClientID", SqlDbType.VarChar, 256); para[3].Value = en.ClientID; string comstr = "with ProjectPaperInfo as \r\n(\r\n\tselect (case when State=2 then '已承接' else '未承接' end) as IsAccept,ProjectPaper.PPID,ProjectPaper.Name,ProjectPaper.FhdateTime,PTName,Row_Number() over(order by PPID ) as row_number from ProjectPaper,PaperType where 1=1 and PaperType.PTID=ProjectPaper.PTID and ClientID=@ClientID"; string comstr2 = "select count(*) from ProjectPaper where 1=1"; if (en.PPID != 0) { comstr += " and PPID = @PPID"; comstr2 += " and PPID = @PPID"; } if (en.Name != null) { comstr += " and Name Like '%'+@Name+'%'"; comstr2 += " and Name Like '%'+@Name+'%'"; } comstr += ") select * from ProjectPaperInfo where row_number>{0} and row_number<={1};"; comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(comstr2, para)); gv.DataSource = this.db.GetDataTable(comstr, para); gv.DataBind(); }
protected void LoadData(int PPID, string Name) { ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); ProjectPaperBll projectPaperBll = new ProjectPaperBll(); projectPaperEntity.PPID = PPID; projectPaperEntity.Name = Name; projectPaperBll.Asp(this.GridView1, this.AspNetPager1, projectPaperEntity); }
protected void LoadData(int PPID, string Name) { ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); ProjectPaperBll projectPaperBll = new ProjectPaperBll(); projectPaperEntity.PPID = PPID; projectPaperEntity.Name = Name; projectPaperEntity.ClientID = base.Session["ClientID"].ToString();; projectPaperBll.Asp5(this.GridView1, this.AspNetPager1, projectPaperEntity); }
public bool Delete(ProjectPaperEntity en) { string sql = " delete from ProjectPaper where PPID = @PPID "; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PPID", SqlDbType.Int, 4) }; para[0].Value = en.PPID; return(this.db.ExecuteSql(sql, para) == 1); }
protected void LinkButton2_Command(object sender, CommandEventArgs e) { ProjectPaperBll projectPaperBll = new ProjectPaperBll(); ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); projectPaperEntity.PPID = Convert.ToInt32(e.CommandArgument.ToString().Trim()); projectPaperBll.Asp2(this.GridView2, this.AspNetPager1, projectPaperEntity); // this.Label2.Text = projectPaperEntity.ClassID.ToString().Trim(); this.Look.Visible = true; this.add.Visible = false; }
public DataTable GetProblemNum(ProjectPaperEntity en) { DataBase db = new DataBase(); string sql = "select ProblemNum from ProblemPaper where PPID=@PPID"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PPID", SqlDbType.Int) }; para[0].Value = en.PPID; return(db.GetDataTable(sql, para)); }
public DataTable GetById(ProjectPaperEntity en) { DataBase db = new DataBase(); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PPID", SqlDbType.Int, 4) }; param[0].Value = en.PPID; string sql = "select ProjectPaper.*,PaperType.PTName from ProjectPaper,PaperType where PPID=@PPID and PaperType.PTID=ProjectPaper.PTID"; return(db.GetDataTable(sql, param)); }
public bool Update3(ProjectPaperEntity en) { string sql = "update ProjectPaper set DepartmentID=@DepartmentID,ProjectHead=@ProjectHead,State=2 where PPID=@PPID"; SqlParameter[] para = new SqlParameter[4]; para[0] = new SqlParameter("@PTID", SqlDbType.Int); para[0].Value = en.PTID; para[1] = new SqlParameter("@DepartmentID", SqlDbType.Int); para[1].Value = en.DepartmentId; para[2] = new SqlParameter("@ProjectHead", SqlDbType.VarChar, 256); para[2].Value = en.ProjectHead; para[3] = new SqlParameter("@PPID", SqlDbType.Int); para[3].Value = en.PPID; return(this.db.ExecuteSql(sql, para) == 1); }
private void BindView2() { RecordEntity userIntegralDetailEntity = new RecordEntity(); RecordBll userIntegralDetailBll = new RecordBll(); userIntegralDetailEntity.PpID = Convert.ToInt32(this.ViewState["id"]); userIntegralDetailBll.Asp(this.GridView2, this.AspNetPager2, userIntegralDetailEntity); ProjectPaperEntity userEntity = new ProjectPaperEntity(); ProjectPaperBll userBll = new ProjectPaperBll(); userEntity.PPID = Convert.ToInt32(this.ViewState["id"]); DataTable byID = userBll.GetById(userEntity); if (byID != null && byID.Rows.Count == 1) { this.Label1.Text = byID.Rows[0]["Name"].ToString(); } }
public void bind() { ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); ProjectPaperBll projectPaperBll = new ProjectPaperBll(); projectPaperEntity.PPID = Convert.ToInt32(base.Request.QueryString["PPID"]); DataTable byID = projectPaperBll.GetById(projectPaperEntity); if (byID != null && byID.Rows.Count == 1) { this.Name.Text = byID.Rows[0]["Name"].ToString(); this.TextBox1.Text = byID.Rows[0]["RegisterDate"].ToString(); this.TextBox2.Text = byID.Rows[0]["OverDate"].ToString(); this.PaperType.Items.Insert(0, byID.Rows[0]["PTName"].ToString()); this.FCKeditor1.Value = byID.Rows[0]["PPDesc"].ToString(); } }
public bool Update2(ProjectPaperEntity en) { string sql = "update ProjectPaper set PTID=@PTID,Name=@Name,FhdateTime=@FhdateTime where PPID=@PPID"; SqlParameter[] para = new SqlParameter[4]; para[0] = new SqlParameter("@PTID", SqlDbType.Int); para[0].Value = en.PTID; para[1] = new SqlParameter("@Name", SqlDbType.VarChar, 256); para[1].Value = en.Name; para[2] = new SqlParameter("@FhdateTime", SqlDbType.DateTime); para[2].Value = en.FhdateTime; para[3] = new SqlParameter("@PPID", SqlDbType.Int); para[3].Value = en.PPID; return(this.db.ExecuteSql(sql, para) == 1); }
public void bind(int PPID) { ProjectPaperEntity en = new ProjectPaperEntity(); ProjectPaperBll projectPaperBll = new ProjectPaperBll(); en.PPID = PPID; DataTable byId = projectPaperBll.GetById(en); if (byId.Rows.Count >= 1) { this.Name.Text = byId.Rows[0]["Name"].ToString(); this.PaperType.Items.Insert(0, byId.Rows[0]["PTName"].ToString()); this.TextBox1.Text = byId.Rows[0]["RegisterDate"].ToString(); this.TextBox2.Text = byId.Rows[0]["OverDate"].ToString(); this.TextBox3.Text = byId.Rows[0]["FhdateTime"].ToString(); this.FCKeditor1.Value = byId.Rows[0]["PPDesc"].ToString(); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); ProjectPaperBll projectPaperBll = new ProjectPaperBll(); Label label = (Label)this.GridView1.Rows[e.RowIndex].Cells[1].FindControl("lbID"); int num = int.Parse(label.Text.ToString()); projectPaperEntity.PPID = num; if (projectPaperBll.Delete(projectPaperEntity)) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "msg", "alert('删除成功');", true); } else { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "msg", "alert('删除失败');", true); } this.LoadData(0, ""); return; }
protected void addPaper_Click(object sender, EventArgs e) { ProjectPaperBll problemPaperBll = new ProjectPaperBll(); ProjectPaperEntity problemPaperEntity = new ProjectPaperEntity(); problemPaperEntity.Name = this.Name.Text.Trim(); if (this.PRKIDList.SelectedIndex <= 0) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('必须选择试卷类型');</script>"); return; } if (this.PaperType.SelectedIndex <= 0) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('必须选择试卷来源类型');</script>"); return; } problemPaperEntity.PTID = Convert.ToInt32(this.PaperType.SelectedValue); if (this.FCKeditor1.Value != null && this.FCKeditor1.Value != "") { problemPaperEntity.PPDesc = this.FCKeditor1.Value; } else { problemPaperEntity.PPDesc = ""; } problemPaperEntity.SelfResource = ""; problemPaperEntity.FhdateTime = DateTime.Now; if (problemPaperBll.Add(problemPaperEntity)) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('项目添加成功');</script>"); this.bindPaperType(); this.bindPRKIDList(); this.FCKeditor1.Value = ""; this.Name.Text = ""; base.Response.Redirect("ProjectInternetion.aspx"); return; } this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('添加失败');</script>"); }
protected void Button3_Click(object sender, EventArgs e) { string ManagerID = this.Session["ManagerID"].ToString().Trim(); ManagerBll managerBll = new ManagerBll(); DataTable byID = managerBll.GetByID(new ManagerEnitity { ManagerID = ManagerID }); ProjectPaperBll projectPaperBll = new ProjectPaperBll(); ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); projectPaperEntity.PPID = Convert.ToInt32(Label2.Text); projectPaperEntity.ProjectHead = byID.Rows[0]["ManagerName"].ToString().Trim(); projectPaperEntity.DepartmentId = Convert.ToInt32(this.OkDepartment.SelectedValue); projectPaperBll.Update3(projectPaperEntity); base.ClientScript.RegisterStartupScript(base.GetType(), "msg", "<script>alert('项目分配成功');</script>"); }
protected void LinkButton1_Click(object sender, EventArgs e) { ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); ProjectPaperBll projectPaperBll = new ProjectPaperBll(); for (int i = 0; i < this.GridView1.Rows.Count; i++) { CheckBox checkBox = (CheckBox)this.GridView1.Rows[i].FindControl("chkBox"); if (checkBox != null && checkBox.Checked) { Label label = (Label)this.GridView1.Rows[i].FindControl("lbID"); if (label != null) { projectPaperEntity.PPID = int.Parse(label.Text.ToString().Trim()); projectPaperBll.Delete(projectPaperEntity); } } } this.LoadData(0, ""); }
public void Asp2(GridView gv, AspNetPager pager, ProjectPaperEntity en) { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@PPID", SqlDbType.Int, 4); param[0].Value = en.PPID; string comstr = "with ProjectPaperInfo as\r\n(select ProjectPaper.Name,ProjectPaper.ProjectHead,Department.* from ProjectPaper,Department where ProjectPaper.State =2 and ProjectPaper.DepartmentID=Department.DepartmentID "; string comstr2 = "select count(*) from ProjectPaper "; if (en.PPID != 0) { comstr += " and ProjectPaper.PPID=@PPID "; comstr2 += " where ProjectPaper.PPID=@PPID "; } comstr += " )select * from ProjectPaperInfo;"; comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); DataBase db = new DataBase(); pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param)); gv.DataSource = db.GetDataTable(comstr, param); gv.DataBind(); }
protected void addPaper_Click(object sender, EventArgs e) { ProjectPaperBll projectPaperBll = new ProjectPaperBll(); ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); projectPaperEntity.Name = this.Name.Text.Trim(); if (this.PaperType.SelectedIndex <= 0) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('必须选择项目类型');</script>"); return; } projectPaperEntity.PTID = int.Parse(this.PaperType.SelectedValue); if (this.FCKeditor1.Value != null && this.FCKeditor1.Value != "") { projectPaperEntity.PPDesc = this.FCKeditor1.Value; } else { projectPaperEntity.PPDesc = ""; } projectPaperEntity.PPID = Convert.ToInt32(base.Request.QueryString["PPID"]); projectPaperEntity.SelfResource = ""; projectPaperEntity.RegisterDate = DateTime.Parse(TextBox1.Text); projectPaperEntity.OverDate = DateTime.Parse(TextBox2.Text); if (projectPaperBll.Update6(projectPaperEntity)) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('项目添加成功');</script>"); this.bindPaperType(); this.FCKeditor1.Value = ""; this.Name.Text = ""; base.Response.Redirect("ProjectInternection.aspx"); return; } this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('添加失败');</script>"); }
protected void LoadData(int PPID, string Name) { ProjectPaperEntity projectPaperEntity = new ProjectPaperEntity(); ProjectPaperBll projectPaperBll = new ProjectPaperBll(); string userID = this.Session["UserID"].ToString().Trim(); UserBll userBll = new UserBll(); DataTable byID = userBll.GetByID(new UserEntity { UserID = userID }); if (byID != null && byID.Rows.Count == 1) { projectPaperEntity.DepartmentId = Convert.ToInt32(byID.Rows[0]["DepartmentId"]); } projectPaperEntity.PPID = PPID; projectPaperEntity.Name = Name; projectPaperBll.Asp666(this.GridView1, this.AspNetPager1, projectPaperEntity); }
public bool Update6(ProjectPaperEntity en) { string sql = "update ProjectPaper set PTID=@PTID,Name=@Name,RegisterDate=@RegisterDate,OverDate=@OverDate,PPDesc=@PPDesc where PPID=@PPID"; SqlParameter[] para = new SqlParameter[6]; para[0] = new SqlParameter("@PTID", SqlDbType.Int); para[0].Value = en.PTID; para[1] = new SqlParameter("@Name", SqlDbType.VarChar, 256); para[1].Value = en.Name; para[2] = new SqlParameter("@RegisterDate", SqlDbType.DateTime); para[2].Value = en.RegisterDate; para[3] = new SqlParameter("@PPID", SqlDbType.Int); para[3].Value = en.PPID; para[4] = new SqlParameter("@OverDate", SqlDbType.DateTime); para[4].Value = en.OverDate; para[5] = new SqlParameter("@PPDesc", SqlDbType.VarChar, 5000); para[5].Value = en.PPDesc; return(this.db.ExecuteSql(sql, para) == 1); }
public bool Add2(ProjectPaperEntity en) { string sql = "insert into ProjectPaper(PTID,Name,RegisterDate,OverDate,PPDesc) values (@PTID,@Name,@RegisterDate,@OverDate,@PPDesc) "; SqlParameter[] para = new SqlParameter[5]; para[0] = new SqlParameter("@PTID", SqlDbType.Int); para[0].Value = en.PTID; para[1] = new SqlParameter("@Name", SqlDbType.VarChar, 256); para[1].Value = en.Name; para[2] = new SqlParameter("@RegisterDate", SqlDbType.DateTime); para[2].Value = en.RegisterDate; para[3] = new SqlParameter("@OverDate", SqlDbType.DateTime); para[3].Value = en.OverDate; para[4] = new SqlParameter("@PPDesc", SqlDbType.VarChar, 1024); para[4].Value = en.PPDesc; return(this.db.ExecuteSql(sql, para) == 1); }
public bool Update3(ProjectPaperEntity en) { ProjectPaperDal dal = new ProjectPaperDal(); return(dal.Update3(en)); }
public DataTable GetById(ProjectPaperEntity en) { ProjectPaperDal dal = new ProjectPaperDal(); return(dal.GetById(en)); }
public bool Delete(ProjectPaperEntity en) { ProjectPaperDal dal = new ProjectPaperDal(); return(dal.Delete(en)); }
public bool Add2(ProjectPaperEntity en) { ProjectPaperDal dal = new ProjectPaperDal(); return(dal.Add2(en)); }
public DataTable GetProblemNum(ProjectPaperEntity en) { ProjectPaperDal dal = new ProjectPaperDal(); return(dal.GetProblemNum(en)); }
public void Asp5(GridView gv, AspNetPager pager, ProjectPaperEntity en) { ProjectPaperDal dal = new ProjectPaperDal(); dal.Asp5(gv, pager, en); }