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