public int Add(Model.BugIssue model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BugIssue (");
strSql.Append("BI_FK_SR_ID,BI_FK_S_ID,BI_FK_TT_ID,BI_Title,BI_Type,BI_Content,BI_EnvironmentServer,BI_TopologyName,BI_Remark,BI_CaseNumber,BI_CreateDate,BI_Status,BI_Owner,BI_CloseTime,BI_ReferenceBIID,BI_UpdateTime,BI_Priority) values (");
strSql.Append("@BI_FK_SR_ID,@BI_FK_S_ID,@BI_FK_TT_ID,@BI_Title,@BI_Type,@BI_Content,@BI_EnvironmentServer,@BI_TopologyName,@BI_Remark,@BI_CaseNumber,@BI_CreateDate,@BI_Status,@BI_Owner,@BI_CloseTime,@BI_ReferenceBIID,@BI_UpdateTime,@BI_Priority)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@BI_FK_SR_ID", SqlDbType.Int, 4),
new SqlParameter("@BI_FK_S_ID", SqlDbType.Int, 4),
new SqlParameter("@BI_FK_TT_ID", SqlDbType.Int, 4),
new SqlParameter("@BI_Title", SqlDbType.VarChar, 300),
new SqlParameter("@BI_Type", SqlDbType.VarChar, 10),
new SqlParameter("@BI_Content", SqlDbType.NVarChar),
new SqlParameter("@BI_EnvironmentServer", SqlDbType.VarChar, 100),
new SqlParameter("@BI_TopologyName", SqlDbType.VarChar, 50),
new SqlParameter("@BI_Remark", SqlDbType.VarChar),
new SqlParameter("@BI_CaseNumber", SqlDbType.VarChar, 100),
new SqlParameter("@BI_CreateDate", SqlDbType.VarChar, 20),
new SqlParameter("@BI_Status", SqlDbType.VarChar, 10),
new SqlParameter("@BI_Owner", SqlDbType.Int, 4),
new SqlParameter("@BI_CloseTime", SqlDbType.VarChar, 20),
new SqlParameter("@BI_ReferenceBIID", SqlDbType.Int, 4),
new SqlParameter("@BI_UpdateTime", SqlDbType.VarChar, 20),
new SqlParameter("@BI_Priority", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.BI_FK_SR_ID;
parameters[1].Value = model.BI_FK_S_ID;
parameters[2].Value = model.BI_FK_TT_ID;
parameters[3].Value = model.BI_Title;
parameters[4].Value = model.BI_Type;
parameters[5].Value = model.BI_Content;
parameters[6].Value = model.BI_EnvironmentServer;
parameters[7].Value = model.BI_TopologyName;
parameters[8].Value = model.BI_Remark;
parameters[9].Value = model.BI_CaseNumber;
parameters[10].Value = model.BI_CreateDate;
parameters[11].Value = model.BI_Status;
parameters[12].Value = model.BI_Owner;
parameters[13].Value = model.BI_CloseTime;
parameters[14].Value = model.BI_ReferenceBIID;
parameters[15].Value = model.BI_UpdateTime;
parameters[16].Value = model.BI_Priority;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void AddBugIssue(HttpContext context)
{
Model.BugIssue model = new Model.BugIssue();
BLL.BugIssue bll = new BLL.BugIssue();
model.BI_FK_SR_ID = Convert.ToInt32(string.IsNullOrEmpty(context.Request["BI_FK_SR_ID"]) ? "0" : context.Request["BI_FK_SR_ID"]);
model.BI_FK_S_ID = Convert.ToInt32(string.IsNullOrEmpty(context.Request["BI_FK_S_ID"]) ? "0" : context.Request["BI_FK_S_ID"]);
model.BI_FK_TT_ID = Convert.ToInt32(string.IsNullOrEmpty(context.Request["BI_FK_TT_ID"]) ? "0" : context.Request["BI_FK_TT_ID"]);
model.BI_Title = context.Request["BI_Title"];
model.BI_Type = context.Request["BI_Type"];
model.BI_Content = context.Request["BI_Content"];
model.BI_EnvironmentServer = context.Request["BI_EnvironmentServer"];
model.BI_TopologyName = context.Request["BI_TopologyName"];
model.BI_Remark = "";
model.BI_CaseNumber = context.Request["BI_CaseNumber"];
model.BI_CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.BI_Status = "Open";
model.BI_Owner = Convert.ToInt32(context.Request["BI_Owner"]);
model.BI_CloseTime = "";
model.BI_ReferenceBIID = 0;
model.BI_UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.BI_Priority = context.Request["BI_Priority"];
int AddRes = bll.Add(model);
if (AddRes > 0)
{
// Add Daily Report
BLL.V_DailyReport bllDR = new BLL.V_DailyReport();
bllDR.Add(model.BI_Owner.ToString(), AddRes, "BI");
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
public int Add(Model.BugIssue model)
{
return(dal.Add(model));
}
