public void MyBind() { B_ProjectWork bprojectwork = new B_ProjectWork(); if (Request.QueryString["Pid"] != null) { int Pid = DataConverter.CLng(Request.QueryString["Pid"].Trim());//2; mproject=bproject.GetProjectByid(Pid); DataView dv = bprojectwork.SelectWorkByPID(Pid); this.m_projectname = mproject.ProjectName; this.Egv.DataSource = dv; this.Egv.DataKeyNames = new string[] { "WorkID" }; this.Egv.DataBind(); } else { DataTable dt = bprojectwork.GetProjectWorkAll(); this.Egv.DataSource = dt; this.Egv.DataBind(); } }
public void InitPage() { B_Project bpro = new B_Project(); B_ProjectWork bwork=new B_ProjectWork(); M_Project mpro = new M_Project(); StringBuilder strbul = new StringBuilder(); int rid = 0; if (Request.QueryString["pid"] != null) { rid = DataConverter.CLng(Request.QueryString["pid"].Trim()); mpro = bpro.GetProjectByid(rid); LblProName.Text = mpro.ProjectName; LblProIntro.Text = mpro.ProjectIntro; LblStartDate.Text = mpro.StartDate.ToShortDateString(); if (mpro.EndDate.ToShortDateString() == DateTime.MaxValue.ToShortDateString()) { LblEndDate.Text = ""; } else { LblEndDate.Text = mpro.EndDate.ToShortDateString(); } DataView dv=bwork.SelectWorkByPID(rid); if (dv.Table.Rows.Count > 0) { foreach (DataRow dr in dv.Table.Rows) { strbul.Append("<a href='DiscussList.aspx?wid=" + dr["WorkID"] + "&pid=" + Request.QueryString["pid"] + "'>" + dr["WorkName"] + "</a> <a href='DiscussList.aspx?wid=" + dr["WorkID"] + "&pid=" + Request.QueryString["pid"] + "'>查看讨论</a><br/>"); } } else { strbul.Append("暂无工作内容!"); } LblContent.Text = strbul.ToString(); } }
public string CountRate(int projectid) { int result = 0; int FinishCount = this.bllwork.CountFinishWork(projectid); if (FinishCount == 0) return "0%"; else { result = FinishCount * 100 / CountWork(projectid); this.mproject = this.bll.GetProjectByid(projectid); if (result == 100) { this.mproject.Status = 1; } else { this.mproject.Status = 0; } this.bll.Update(this.mproject); return result+"%"; } }
protected void EBtnSubmit_Click(object sender, EventArgs e) { M_Project mproject=new M_Project(); mproject.ProjectName=TxtProjectName.Text.Trim(); mproject.ProjectIntro=TxtProjectIntro.Text.Trim(); mproject.StartDate=DataConverter.CDate(tbUBday.Value.Trim()); if (!string.IsNullOrEmpty(txtEndDay.Value.Trim())) mproject.EndDate = DataConverter.CDate(txtEndDay.Value.Trim()); else mproject.EndDate=DateTime.MaxValue;//new DateTime(); mproject.Uid = this.m_uid; mproject.Status = 0; if (Request.QueryString["rid"] != null) mproject.RequireID = DataConverter.CLng(Request.QueryString["rid"].Trim()); else mproject.RequireID = 0;//无需求ID也可以由管理员自己添加项目 B_Project bproject=new B_Project(); if (bproject.Add(mproject)) { Response.Write("<script language=javascript> alert('项目添加成功!');window.document.location.href='ProjectManage.aspx';</script>"); } }
public bool Update(M_Project m_Project) { return dal.Update(m_Project); }
public bool Add(M_Project projectInfo) { return dal.Add(projectInfo); }
public bool Add(M_Project m_project) { string strSql = "PR_Project_Add"; SqlParameter[] parameter = GetParameters(m_project); return SqlHelper.ExecuteProc(strSql, parameter); }
private M_Project GetProjectInfoFromReader(SqlDataReader reader) { M_Project info = new M_Project(); info.ProjectID = DataConverter.CLng(reader["ProjectID"].ToString()); info.ProjectName = reader["ProjectName"].ToString(); info.ProjectIntro = reader["ProjectIntro"].ToString(); info.RequireID = DataConverter.CLng(reader["RequireID"].ToString()); info.Uid = DataConverter.CLng(reader["UserID"].ToString()); info.StartDate = DataConverter.CDate(reader["StartDate"]); info.EndDate = DataConverter.CDate(reader["EndDate"]); info.Status = DataConverter.CLng(reader["Status"]); return info; }
private SqlParameter[] GetParameters(M_Project m_project) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@ProjectID", SqlDbType.Int), new SqlParameter("@ProjectName", SqlDbType.NVarChar,255), new SqlParameter("@ProjectIntro", SqlDbType.NText,16), new SqlParameter("@RequireID", SqlDbType.Int,4), new SqlParameter("@StartDate", SqlDbType.DateTime,8), new SqlParameter("@EndDate", SqlDbType.DateTime,8), new SqlParameter("@Status", SqlDbType.Int,4), new SqlParameter("@UserID", SqlDbType.Int,4) }; parameter[0].Value = m_project.ProjectID; parameter[1].Value = m_project.ProjectName; parameter[2].Value = m_project.ProjectIntro; parameter[3].Value = m_project.RequireID; parameter[4].Value = m_project.StartDate; parameter[5].Value = m_project.EndDate; parameter[6].Value = m_project.Status; parameter[7].Value = m_project.Uid; return parameter; }
public bool Update(M_Project m_project) { SqlParameter[] cmdParams = GetParameters(m_project); ; return SqlHelper.ExecuteProc("PR_Project_Update", cmdParams); }