public int Add(Model.BugIssueReply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BugIssueReply (BIR_FK_BI_ID,BIR_Content,BIR_CreateTime,BIR_CreateUser) values (");
strSql.Append("@BIR_FK_BI_ID,@BIR_Content,@BIR_CreateTime,@BIR_CreateUser)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@BIR_FK_BI_ID", SqlDbType.Int, 4),
new SqlParameter("@BIR_Content", SqlDbType.NVarChar),
new SqlParameter("@BIR_CreateTime", SqlDbType.VarChar, 20),
new SqlParameter("@BIR_CreateUser", SqlDbType.Int, 4)
};
parameters[0].Value = model.BIR_FK_BI_ID;
parameters[1].Value = model.BIR_Content;
parameters[2].Value = model.BIR_CreateTime;
parameters[3].Value = model.BIR_CreateUser;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void AddBugIssueReply(HttpContext context)
{
BLL.BugIssueReply bll = new BLL.BugIssueReply();
Model.BugIssueReply model = new Model.BugIssueReply();
model.BIR_FK_BI_ID = Convert.ToInt32(context.Request["BIR_FK_BI_ID"]);
model.BIR_Content = context.Request["BIR_Content"];
model.BIR_CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.BIR_CreateUser = Convert.ToInt32(context.Request["BIR_CreateUser"]);
int AddRes = bll.Add(model);
if (AddRes > 0)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
public int Add(Model.BugIssueReply model)
{
return(dal.Add(model));
}
