private static Tab_SmartPerson_QA ToModel(DataRow row)
{
Tab_SmartPerson_QA model = new Tab_SmartPerson_QA();
model.Idx = row.IsNull("Idx")?null:(System.Int32?)row["Idx"];
model.UserUId_Fx = row.IsNull("UserUId_Fx")?null:(System.Int32?)row["UserUId_Fx"];
model.QuestionTypeId_FxIdx = row.IsNull("QuestionTypeId_FxIdx")?null:(System.Int32?)row["QuestionTypeId_FxIdx"];
model.AnswerContent = row.IsNull("AnswerContent")?null:(System.String)row["AnswerContent"];
model.AnswerDate = row.IsNull("AnswerDate")?null:(System.DateTime?)row["AnswerDate"];
model.QuestionContent = row.IsNull("QuestionContent")?null:(System.String)row["QuestionContent"];
model.QuestionDate = row.IsNull("QuestionDate")?null:(System.DateTime?)row["QuestionDate"];
model.StateBool = row.IsNull("StateBool")?null:(System.String)row["StateBool"];
model.SmartPersonIdx_Fx = row.IsNull("SmartPersonIdx_Fx")?null:(System.Int32?)row["SmartPersonIdx_Fx"];
return(model);
}
public int AddNew(Tab_SmartPerson_QA model)
{
string sql = "insert into Tab_SmartPerson_QA(UserUId_Fx,QuestionTypeId_FxIdx,AnswerContent,AnswerDate,QuestionContent,QuestionDate,StateBool,SmartPersonIdx_Fx) values(@UserUId_Fx,@QuestionTypeId_FxIdx,@AnswerContent,@AnswerDate,@QuestionContent,@QuestionDate,@StateBool,@SmartPersonIdx_Fx); select @@identity ;";
int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql
, new SqlParameter("@UserUId_Fx", model.UserUId_Fx)
, new SqlParameter("@QuestionTypeId_FxIdx", model.QuestionTypeId_FxIdx)
, new SqlParameter("@AnswerContent", model.AnswerContent)
, new SqlParameter("@AnswerDate", model.AnswerDate)
, new SqlParameter("@QuestionContent", model.QuestionContent)
, new SqlParameter("@QuestionDate", model.QuestionDate)
, new SqlParameter("@StateBool", model.StateBool)
, new SqlParameter("@SmartPersonIdx_Fx", model.SmartPersonIdx_Fx)
));
return(Idx);
}
public bool Update(Tab_SmartPerson_QA model)
{
string sql = "update Tab_SmartPerson_QA set UserUId_Fx=@UserUId_Fx,QuestionTypeId_FxIdx=@QuestionTypeId_FxIdx,AnswerContent=@AnswerContent,AnswerDate=@AnswerDate,QuestionContent=@QuestionContent,QuestionDate=@QuestionDate,StateBool=@StateBool,SmartPersonIdx_Fx=@SmartPersonIdx_Fx where Idx=@Idx";
int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql
, new SqlParameter("@UserUId_Fx", model.UserUId_Fx)
, new SqlParameter("@QuestionTypeId_FxIdx", model.QuestionTypeId_FxIdx)
, new SqlParameter("@AnswerContent", model.AnswerContent)
, new SqlParameter("@AnswerDate", model.AnswerDate)
, new SqlParameter("@QuestionContent", model.QuestionContent)
, new SqlParameter("@QuestionDate", model.QuestionDate)
, new SqlParameter("@StateBool", model.StateBool)
, new SqlParameter("@SmartPersonIdx_Fx", model.SmartPersonIdx_Fx)
, new SqlParameter("Idx", model.Idx)
);
return(rows > 0);
}
public Tab_SmartPerson_QA Get(string Idx)
{
DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_SmartPerson_QA 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_SmartPerson_QA model = ToModel(row);
return(model);
}
