public static int CheckInsert(HotelGroupEntity hotelGroupEntity) { OracleParameter[] parm ={ new OracleParameter("GROUPCODE",OracleType.VarChar), new OracleParameter("GROUPNM",OracleType.VarChar) }; HotelGroupDBEntity dbParm = (hotelGroupEntity.HotelGroupDBEntity.Count > 0) ? hotelGroupEntity.HotelGroupDBEntity[0] : new HotelGroupDBEntity(); parm[0].Value = dbParm.HotelGroupCode; parm[1].Value = dbParm.Name_CN; hotelGroupEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelGroup", "t_lm_b_hotelgroup_sigle", false, parm); if (hotelGroupEntity.QueryResult.Tables.Count > 0 && hotelGroupEntity.QueryResult.Tables[0].Rows.Count > 0) { return 1; } return 0; }
public static int Update(HotelGroupEntity hotelGroupEntity) { hotelGroupEntity.LogMessages.MsgType = MessageType.INFO; hotelGroupEntity.LogMessages.Content = _nameSpaceClass + "Update"; LoggerHelper.LogWriter(hotelGroupEntity.LogMessages); try { return HotelGroupDA.Update(hotelGroupEntity); } catch (Exception ex) { hotelGroupEntity.LogMessages.MsgType = MessageType.ERROR; hotelGroupEntity.LogMessages.Content = _nameSpaceClass + "Update Error: " + ex.Message; LoggerHelper.LogWriter(hotelGroupEntity.LogMessages); throw ex; } }
public static int CheckUpdate(HotelGroupEntity hotelGroupEntity) { OracleParameter[] parm ={ new OracleParameter("ID",OracleType.Number), new OracleParameter("GROUPNM",OracleType.VarChar) }; HotelGroupDBEntity dbParm = (hotelGroupEntity.HotelGroupDBEntity.Count > 0) ? hotelGroupEntity.HotelGroupDBEntity[0] : new HotelGroupDBEntity(); parm[0].Value = int.Parse(dbParm.HotelGroupID.ToString()); parm[1].Value = dbParm.Name_CN; hotelGroupEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelGroup", "t_lm_b_hotelgroup_updatesigle", false, parm); if (hotelGroupEntity.QueryResult.Tables.Count > 0 && hotelGroupEntity.QueryResult.Tables[0].Rows.Count > 0) { return 1; } return 0; }
public static int Insert(HotelGroupEntity hotelGroupEntity) { if (hotelGroupEntity.HotelGroupDBEntity.Count == 0) { return 0; } if (hotelGroupEntity.LogMessages == null) { return 0; } if (CheckInsert(hotelGroupEntity) > 0) { return 2; } HotelGroupDBEntity dbParm = (hotelGroupEntity.HotelGroupDBEntity.Count > 0) ? hotelGroupEntity.HotelGroupDBEntity[0] : new HotelGroupDBEntity(); OracleParameter[] parm ={ new OracleParameter("ID",OracleType.Number), new OracleParameter("GROUPCODE",OracleType.VarChar), new OracleParameter("NAMEZH",OracleType.VarChar), new OracleParameter("DESCRIPTIONZH",OracleType.VarChar), new OracleParameter("BANDTYPE",OracleType.VarChar), new OracleParameter("ONLINESTATUS",OracleType.VarChar) }; parm[0].Value = getMaxIDfromSeq("t_lm_b_hotelgroup_seq"); parm[1].Value = dbParm.HotelGroupCode; parm[2].Value = dbParm.Name_CN; parm[3].Value = dbParm.Description; parm[4].Value = dbParm.BandType; parm[5].Value = dbParm.OnlineStatus; DbManager.ExecuteSql("HotelGroup", "t_lm_b_hotelgroup_insert", parm); return 1; }
public static int Update(HotelGroupEntity hotelGroupEntity) { if (hotelGroupEntity.HotelGroupDBEntity.Count == 0) { return 0; } if (hotelGroupEntity.LogMessages == null) { return 0; } if (CheckUpdate(hotelGroupEntity) > 0) { return 2; } HotelGroupDBEntity dbParm = (hotelGroupEntity.HotelGroupDBEntity.Count > 0) ? hotelGroupEntity.HotelGroupDBEntity[0] : new HotelGroupDBEntity(); OracleParameter[] parm ={ new OracleParameter("ID",OracleType.Number), new OracleParameter("GROUPCODE",OracleType.VarChar), new OracleParameter("NAMEZH",OracleType.VarChar), new OracleParameter("DESCRIPTIONZH",OracleType.VarChar), new OracleParameter("BANDTYPE",OracleType.VarChar), new OracleParameter("ONLINESTATUS",OracleType.VarChar) }; parm[0].Value = dbParm.HotelGroupID; parm[1].Value = dbParm.HotelGroupCode; parm[2].Value = dbParm.Name_CN; parm[3].Value = dbParm.Description; parm[4].Value = dbParm.BandType; parm[5].Value = dbParm.OnlineStatus; DbManager.ExecuteSql("HotelGroup", "t_lm_b_hotelgroup_update", parm); //if (!String.IsNullOrEmpty(dbParm.Type) && "1".Equals(dbParm.Type)) //{ // OracleParameter[] parm ={ // new OracleParameter("ID",OracleType.Number), // new OracleParameter("GROUPCODE",OracleType.VarChar), // new OracleParameter("NAMEZH",OracleType.VarChar), // new OracleParameter("DESCRIPTIONZH",OracleType.VarChar), // new OracleParameter("BANDTYPE",OracleType.VarChar) // }; // parm[0].Value = dbParm.HotelGroupID; // parm[1].Value = dbParm.HotelGroupCode; // parm[2].Value = dbParm.Name_CN; // parm[3].Value = dbParm.Description; // parm[4].Value = dbParm.BandType; // DbManager.ExecuteSql("HotelGroup", "t_lm_b_hotelgroup_update", parm); //} //else //{ // OracleParameter[] parm ={ // new OracleParameter("ID",OracleType.Number) // }; // parm[0].Value = dbParm.HotelGroupID; // DbManager.ExecuteSql("HotelGroup", "t_lm_b_hotelgroup_delete", parm); //} return 1; }
public static HotelGroupEntity Select(HotelGroupEntity hotelGroupEntity) { OracleParameter[] parm ={ new OracleParameter("ID",OracleType.Number) }; HotelGroupDBEntity dbParm = (hotelGroupEntity.HotelGroupDBEntity.Count > 0) ? hotelGroupEntity.HotelGroupDBEntity[0] : new HotelGroupDBEntity(); if (String.IsNullOrEmpty(dbParm.HotelGroupID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HotelGroupID; } hotelGroupEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelGroup", "t_lm_b_hotelgroup", false, parm); return hotelGroupEntity; }