//修改菜单是否显示
public static int UpdateFaqByID(FAQEntity faqEntity)
{
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("QUSETION_HEAD",OracleType.VarChar),
new OracleParameter("ANSWER_BODY",OracleType.VarChar)
};
FAQDBEntity dbParm = (faqEntity.FAQDBEntity.Count > 0) ? faqEntity.FAQDBEntity[0] : new FAQDBEntity();
parm[0].Value = dbParm.ID;
if (String.IsNullOrEmpty(dbParm.QUSETION_HEAD))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.QUSETION_HEAD;
}
if (String.IsNullOrEmpty(dbParm.ANSWER_BODY))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.ANSWER_BODY;
}
int result = HotelVp.Common.DBUtility.DbManager.ExecuteSql("FAQInfo", "t_lm_qa_update", parm);
return result;
}
//删除
public static int DeleteFaqByID(FAQEntity faqEntity)
{
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.Int32)
};
FAQDBEntity dbParm = (faqEntity.FAQDBEntity.Count > 0) ? faqEntity.FAQDBEntity[0] : new FAQDBEntity();
parm[0].Value = dbParm.ID;
int result = HotelVp.Common.DBUtility.DbManager.ExecuteSql("FAQInfo", "t_lm_qa_delete", parm);
return result;
}
public static int Insert(FAQEntity faqEntity)
{
faqEntity.LogMessages.MsgType = MessageType.INFO;
faqEntity.LogMessages.Content = _nameSpaceClass + "Insert";
LoggerHelper.LogWriter(faqEntity.LogMessages);
try
{
return FAQDA.Insert(faqEntity);
}
catch (Exception ex)
{
faqEntity.LogMessages.MsgType = MessageType.ERROR;
faqEntity.LogMessages.Content = _nameSpaceClass + "Insert Error: " + ex.Message;
LoggerHelper.LogWriter(faqEntity.LogMessages);
throw ex;
}
}
public static FAQEntity CommonSelect(FAQEntity faqEntity)
{
faqEntity.LogMessages.MsgType = MessageType.INFO;
faqEntity.LogMessages.Content = _nameSpaceClass + " CommonSelect";
LoggerHelper.LogWriter(faqEntity.LogMessages);
try
{
return FAQDA.BindFAQList(faqEntity);
}
catch (Exception ex)
{
faqEntity.LogMessages.MsgType = MessageType.ERROR;
faqEntity.LogMessages.Content = _nameSpaceClass + " CommonSelect Error: " + ex.Message;
LoggerHelper.LogWriter(faqEntity.LogMessages);
throw ex;
}
}
public static FAQEntity BindFAQList(FAQEntity faqEntity)
{
faqEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("FAQInfo", "t_lm_qa_select", false);
return faqEntity;
}
