예제 #1
0
    private int m_uid = 1; //测试用

    #endregion Fields

    #region Methods

    protected void EBtnSubmit_Click(object sender, EventArgs e)
    {
        string strusername = TxtUserName.Text.Trim();
        string strcontent = TxtRequireContent.Text.Trim();
        B_ClientRequire bclientrequire = new B_ClientRequire();
        M_ClientRequire mrequire=new M_ClientRequire();
        mrequire.Require=strcontent;
        mrequire.UserID=this.m_uid;
        mrequire.ReuqireDate=DateTime.Now;
        if (bclientrequire.Add(mrequire))
        {
            Response.Write("<script language=javascript> alert('添加成功!');window.document.location.href='ProjectList.aspx';</script>");
        }
    }
예제 #2
0
 private SqlParameter[] GetParameters(M_ClientRequire ClientRequireinfo)
 {
     SqlParameter[] parameter = new SqlParameter[] {
         new SqlParameter("@RequireID", SqlDbType.Int),
         new SqlParameter("@UserID", SqlDbType.Int),
         new SqlParameter("@Require", SqlDbType.NText,16),
         new SqlParameter("@ReuqireDate", SqlDbType.DateTime,8),
     };
     parameter[0].Value = ClientRequireinfo.RequireID;
     parameter[1].Value = ClientRequireinfo.UserID;
     parameter[2].Value = ClientRequireinfo.Require;
     parameter[3].Value = ClientRequireinfo.ReuqireDate;
     return parameter;
 }
예제 #3
0
 public bool Update(M_ClientRequire CRinfo)
 {
     return dal.Add(CRinfo);
 }
예제 #4
0
 public bool Update(M_ClientRequire ClientRequireinfo)
 {
     SqlParameter[] cmdParams = GetParameters(ClientRequireinfo); ;
     return SqlHelper.ExecuteProc("PR_ClientRequire_Update", cmdParams);
 }
예제 #5
0
 public bool Add(M_ClientRequire ClientRequireinfo)
 {
     string strSql = "PR_ClientRequire_Add";
     SqlParameter[] parameter = GetParameters(ClientRequireinfo);
     return SqlHelper.ExecuteProc(strSql, parameter);
 }