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