protected void btnSubmit_Click(object sender, EventArgs e)
{
string idx = Request["Idx"];
DBEntity.Tab_QA_Sisley ent = new DBEntity.Tab_QA_Sisley();
ent.PassBool = this.PassBool.Text;
ent.QuestionSubTypeIdx_Fx = Convert.ToInt32(this.QuestionSubTypeIdx_Fx.SelectedValue);
ent.ContentAnswer = this.ContentAnswer.Text;
ent.ContentQuestion = this.ContentQuestion.Text;
ent.DateAsk = Convert.ToDateTime(this.DateAsk.Value);
ent.ManagerUserName = "******";
ent.DateAnswer = DateTime.Now;
if (string.IsNullOrEmpty(idx))
{
ent.AddNew(ent);
}
else
{
ent.Idx = Convert.ToInt32(idx);
ent.Update(ent);
}
//Cmn.Js.ShowAlert("操作成功！");
Cmn.Js.ExeScript("location.href='sisleyQA_Manage.aspx'");
}
private static Tab_QA_Sisley ToModel(DataRow row)
{
Tab_QA_Sisley model = new Tab_QA_Sisley();
model.Idx = row.IsNull("Idx")?null:(System.Int32?)row["Idx"];
model.ContentQuestion = row.IsNull("ContentQuestion")?null:(System.String)row["ContentQuestion"];
model.ContentAnswer = row.IsNull("ContentAnswer")?null:(System.String)row["ContentAnswer"];
model.DateAsk = row.IsNull("DateAsk")?null:(System.DateTime?)row["DateAsk"];
model.DateAnswer = row.IsNull("DateAnswer")?null:(System.DateTime?)row["DateAnswer"];
model.PassBool = row.IsNull("PassBool")?null:(System.String)row["PassBool"];
model.ManagerUserName = row.IsNull("ManagerUserName")?null:(System.String)row["ManagerUserName"];
model.QuestionSubTypeIdx_Fx = row.IsNull("QuestionSubTypeIdx_Fx")?null:(System.Int32?)row["QuestionSubTypeIdx_Fx"];
return(model);
}
public int AddNew(Tab_QA_Sisley model)
{
string sql = "insert into Tab_QA_Sisley(ContentQuestion,ContentAnswer,DateAsk,DateAnswer,PassBool,ManagerUserName,QuestionSubTypeIdx_Fx) values(@ContentQuestion,@ContentAnswer,@DateAsk,@DateAnswer,@PassBool,@ManagerUserName,@QuestionSubTypeIdx_Fx); select @@identity ;";
int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql
, new SqlParameter("@ContentQuestion", model.ContentQuestion)
, new SqlParameter("@ContentAnswer", model.ContentAnswer)
, new SqlParameter("@DateAsk", model.DateAsk)
, new SqlParameter("@DateAnswer", model.DateAnswer)
, new SqlParameter("@PassBool", model.PassBool)
, new SqlParameter("@ManagerUserName", model.ManagerUserName)
, new SqlParameter("@QuestionSubTypeIdx_Fx", model.QuestionSubTypeIdx_Fx)
));
return(Idx);
}
public bool Update(Tab_QA_Sisley model)
{
string sql = "update Tab_QA_Sisley set ContentQuestion=@ContentQuestion,ContentAnswer=@ContentAnswer,DateAsk=@DateAsk,DateAnswer=@DateAnswer,PassBool=@PassBool,ManagerUserName=@ManagerUserName,QuestionSubTypeIdx_Fx=@QuestionSubTypeIdx_Fx where Idx=@Idx";
int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql
, new SqlParameter("@ContentQuestion", model.ContentQuestion)
, new SqlParameter("@ContentAnswer", model.ContentAnswer)
, new SqlParameter("@DateAsk", model.DateAsk)
, new SqlParameter("@DateAnswer", model.DateAnswer)
, new SqlParameter("@PassBool", model.PassBool)
, new SqlParameter("@ManagerUserName", model.ManagerUserName)
, new SqlParameter("@QuestionSubTypeIdx_Fx", model.QuestionSubTypeIdx_Fx)
, new SqlParameter("Idx", model.Idx)
);
return(rows > 0);
}
public Tab_QA_Sisley Get(string Idx)
{
DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_QA_Sisley where Idx=@Idx",
new SqlParameter("Idx", Idx)).Tables[0];
if (dt.Rows.Count > 1)
{
throw new Exception("more than 1 row was found");
}
if (dt.Rows.Count <= 0)
{
return(null);
}
DataRow row = dt.Rows[0];
Tab_QA_Sisley model = ToModel(row);
return(model);
}
