public int Add(Model.Scenario model, bool UpdateHaveScenario)
{
DAL.TaskTotal dalTaskTotal = new DAL.TaskTotal();
int AddRes = dal.Add(model);
if (UpdateHaveScenario)
{
bool UpdateRes = dalTaskTotal.UpdateHaveScenario(model.S_FK_TT_ID, true);
if (AddRes > 0)
{
if (UpdateRes)
{
return(AddRes);
}
else
{
return(0);
}
}
else
{
return(0);
}
}
else
{
return(AddRes);
}
}
public int Add(Model.Scenario model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Scenario(S_FK_TT_ID,S_ScenarioName,S_CreateDate,S_IsDelete,S_HaveRole)");
strSql.Append(" values ");
strSql.Append("(@S_FK_TT_ID,@S_ScenarioName,@S_CreateDate,@S_IsDelete,@S_HaveRole)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@S_FK_TT_ID", SqlDbType.Int, 4),
new SqlParameter("@S_ScenarioName", SqlDbType.VarChar, 300),
new SqlParameter("@S_CreateDate", SqlDbType.VarChar, 20),
new SqlParameter("@S_IsDelete", SqlDbType.Int, 4),
new SqlParameter("@S_HaveRole", SqlDbType.VarChar, 5)
};
parameters[0].Value = model.S_FK_TT_ID;
parameters[1].Value = model.S_ScenarioName;
parameters[2].Value = model.S_CreateDate;
parameters[3].Value = model.S_IsDelete;
parameters[4].Value = model.S_HaveRole;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void UpdateScenarioInfo(HttpContext context)
{
BLL.Scenario bll = new BLL.Scenario();
Model.Scenario model = new Model.Scenario();
model.S_ScenarioName = context.Request["S_ScenarioName"];
model.S_ID = int.Parse(context.Request["S_ID"]);
bool EditRes = bll.Edit(model);
if (EditRes)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
private void AddScenarioInfo(HttpContext context)
{
BLL.Scenario bll = new BLL.Scenario();
Model.Scenario model = new Model.Scenario();
model.S_FK_TT_ID = int.Parse(context.Request["S_FK_TT_ID"]);
model.S_ScenarioName = context.Request["S_ScenarioName"];
model.S_CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.S_IsDelete = 0;
model.S_HaveRole = "No";
int AddRes = bll.Add(model, false);
if (AddRes > 0)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
public int AddBatch(int ScenarioNumber, Model.Scenario model)
{
string[] arrScenarioName = model.S_ScenarioNames.Split(new string[] { "@@" }, StringSplitOptions.RemoveEmptyEntries);
StringBuilder strSql = new StringBuilder();
foreach (string ScenarioName in arrScenarioName)
{
strSql.Append("insert into Scenario(S_FK_TT_ID,S_ScenarioName,S_CreateDate,S_IsDelete,S_HaveRole)");
strSql.Append(string.Format(" values ({0},'{1}','{2}',{3},'{4}');", model.S_FK_TT_ID, ScenarioName, model.S_CreateDate, model.S_IsDelete, model.S_HaveRole));
}
int EffRow = DbHelperSQL.ExecuteSql(strSql.ToString());
if (ScenarioNumber == EffRow)
{
return(EffRow);
}
else
{
return(0);
}
}
public int AddBatch(int ScenarioNumber, Model.Scenario model)
{
DAL.TaskTotal dalTaskTotal = new DAL.TaskTotal();
int AddRes = dal.AddBatch(ScenarioNumber, model);
bool UpdateRes = dalTaskTotal.UpdateHaveScenario(model.S_FK_TT_ID, true);
if (AddRes > 0)
{
if (UpdateRes)
{
return(AddRes);
}
else
{
return(0);
}
}
else
{
return(0);
}
}
public bool Edit(Model.Scenario model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Scenario set S_ScenarioName=@S_ScenarioName where S_ID=@S_ID");
SqlParameter[] parameters =
{
new SqlParameter("@S_ScenarioName", SqlDbType.VarChar, 300),
new SqlParameter("@S_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.S_ScenarioName;
parameters[1].Value = model.S_ID;
int res = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (res > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Edit(Model.Scenario model)
{
return(dal.Edit(model));
}
