//修改菜单是否显示 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; }