public bool Add(M_ClientRequire ClientRequireinfo) { string strSql = "PR_ClientRequire_Add"; SqlParameter[] parameter = GetParameters(ClientRequireinfo); return(SqlHelper.ExecuteProc(strSql, parameter)); }
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); }
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>"); } }
public bool Update(M_ClientRequire CRinfo) { return(dal.Add(CRinfo)); }
public bool Update(M_ClientRequire ClientRequireinfo) { SqlParameter[] cmdParams = GetParameters(ClientRequireinfo);; return(SqlHelper.ExecuteProc("PR_ClientRequire_Update", cmdParams)); }