public void BindReviewLmSystemLogListGrid() { HotelBlackEntity _hotelblackEntity = new HotelBlackEntity(); _hotelblackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelblackEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelblackEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelblackEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelblackEntity.HotelBlackDBEntity = new List<HotelBlackDBEntity>(); HotelBlackDBEntity hotelblackdbEntity = new HotelBlackDBEntity(); if (ViewState["strHotel"].ToString() != "") { hotelblackdbEntity.HotelId = ViewState["strHotel"].ToString(); } hotelblackdbEntity.Source = this.DropChannel.SelectedValue; _hotelblackEntity.HotelBlackDBEntity.Add(hotelblackdbEntity); _hotelblackEntity.PageCurrent = AspNetPager1.CurrentPageIndex; _hotelblackEntity.PageSize = gridHotelList.PageSize; DataSet dsResult = HotelBlackBP.GetHotelBlackList(_hotelblackEntity).QueryResult; this.gridHotelList.DataSource = dsResult.Tables[0].DefaultView; this.gridHotelList.DataBind(); AspNetPager1.PageSize = gridHotelList.PageSize; AspNetPager1.RecordCount = CountLmSystemLog(); }
public static int DeleteHotelBlackList(HotelBlackEntity hotelblackEntity) { OracleParameter[] parm ={ new OracleParameter("ID",OracleType.Number) }; HotelBlackDBEntity dbParm = (hotelblackEntity.HotelBlackDBEntity.Count > 0) ? hotelblackEntity.HotelBlackDBEntity[0] : new HotelBlackDBEntity(); if (String.IsNullOrEmpty(dbParm.ID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.ID; } DbManager.ExecuteSql("HotelBlackList", "t_lm_hotel_blacklist_delete", parm); return 1; }
public static int InsertHotelBlackList(HotelBlackEntity hotelblackEntity) { hotelblackEntity.LogMessages.MsgType = MessageType.INFO; hotelblackEntity.LogMessages.Content = _nameSpaceClass + "InsertHotelBlackList"; LoggerHelper.LogWriter(hotelblackEntity.LogMessages); try { return HotelBlackDA.InsertHotelBlackList(hotelblackEntity); } catch (Exception ex) { hotelblackEntity.LogMessages.MsgType = MessageType.ERROR; hotelblackEntity.LogMessages.Content = _nameSpaceClass + "InsertHotelBlackList Error: " + ex.Message; LoggerHelper.LogWriter(hotelblackEntity.LogMessages); throw ex; } }
public int CountLmSystemLog() { HotelBlackEntity _hotelblackEntity = new HotelBlackEntity(); _hotelblackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelblackEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelblackEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelblackEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelblackEntity.HotelBlackDBEntity = new List<HotelBlackDBEntity>(); HotelBlackDBEntity hotelblackdbEntity = new HotelBlackDBEntity(); if (ViewState["strHotel"].ToString() != "") { hotelblackdbEntity.HotelId = ViewState["strHotel"].ToString(); } hotelblackdbEntity.Source = this.DropChannel.SelectedValue; DataSet dsResult = HotelBlackBP.GetHotelBlackListByCount(_hotelblackEntity).QueryResult; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsResult.Tables[0].Rows[0][0].ToString())) { return int.Parse(dsResult.Tables[0].Rows[0][0].ToString()); } return 0; }
public static HotelBlackEntity GetHotelBlackList(HotelBlackEntity hotelblackEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("ISBLACK",OracleType.VarChar) }; HotelBlackDBEntity dbParm = (hotelblackEntity.HotelBlackDBEntity.Count > 0) ? hotelblackEntity.HotelBlackDBEntity[0] : new HotelBlackDBEntity(); if (String.IsNullOrEmpty(dbParm.HotelId)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HotelId; ; } if (String.IsNullOrEmpty(dbParm.Source)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.Source; ; } if (String.IsNullOrEmpty(dbParm.IsBlack)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.IsBlack; ; } string SqlString = XmlSqlAnalyze.GotSqlTextFromXml("HotelBlackList", "t_lm_hotel_blacklist_search"); //hotelblackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelBlackList", "t_lm_hotel_blacklist_search", true, parm); hotelblackEntity.QueryResult = DbManager.Query(SqlString, parm, (hotelblackEntity.PageCurrent - 1) * hotelblackEntity.PageSize, hotelblackEntity.PageSize, true); return hotelblackEntity; }
public static HotelBlackEntity GetHotelBlackListByCount(HotelBlackEntity hotelblackEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("ISBLACK",OracleType.VarChar) }; HotelBlackDBEntity dbParm = (hotelblackEntity.HotelBlackDBEntity.Count > 0) ? hotelblackEntity.HotelBlackDBEntity[0] : new HotelBlackDBEntity(); if (String.IsNullOrEmpty(dbParm.HotelId)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HotelId; ; } if (String.IsNullOrEmpty(dbParm.Source)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.Source; ; } if (String.IsNullOrEmpty(dbParm.IsBlack)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.IsBlack; ; } hotelblackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelBlackList", "t_lm_hotel_blacklist_search_bycount", true, parm); return hotelblackEntity; }
protected void gridHotelList_RowDeleting(object sender, GridViewDeleteEventArgs e) { MessageContent.InnerHtml = ""; HotelBlackEntity _hotelblackEntity = new HotelBlackEntity(); _hotelblackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelblackEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelblackEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelblackEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelblackEntity.HotelBlackDBEntity = new List<HotelBlackDBEntity>(); HotelBlackDBEntity hotelblackdbEntity = new HotelBlackDBEntity(); string isBlack = gridHotelList.DataKeys[e.RowIndex].Values[1].ToString(); hotelblackdbEntity.ID = gridHotelList.DataKeys[e.RowIndex].Values[0].ToString(); hotelblackdbEntity.IsBlack = isBlack == "黑名单" ? "0" : "1"; _hotelblackEntity.HotelBlackDBEntity.Add(hotelblackdbEntity); //删除 //int i = HotelBlackBP.DeleteHotelBlackList(_hotelblackEntity); //MessageContent.InnerHtml = i == 1 ? "黑名单酒店删除成功!" : "黑名单酒店删除失败!"; //修改 int i = HotelBlackBP.UpdateHotelBlackList(_hotelblackEntity); MessageContent.InnerHtml = i == 1 ? "黑名单酒店处理成功!" : "黑名单酒店处理失败!"; //btnSearch_Click(null, null); ScriptManager.RegisterStartupScript(Page, this.GetType(), "btnDeleteE", "BtnCompleteStyle();", true); ScriptManager.RegisterStartupScript(this.UpdatePanel2, this.GetType(), "keyDeleteClickEvent1", "btnSeachClick()", true); }
protected void btnUpdateHotelBlack_Click(object sender, EventArgs e) { string strHotel = wctHotelDiv.AutoResult; this.HidHotelValue.Value = strHotel; strHotel = strHotel.Substring((strHotel.IndexOf('[') + 1), (strHotel.IndexOf(']') - 1)); HotelBlackEntity _hotelblackEntity = new HotelBlackEntity(); _hotelblackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelblackEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelblackEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelblackEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelblackEntity.HotelBlackDBEntity = new List<HotelBlackDBEntity>(); HotelBlackDBEntity hotelblackdbEntity = new HotelBlackDBEntity(); hotelblackdbEntity.HotelId = strHotel; hotelblackdbEntity.Source = this.DropChannelDiv.SelectedValue; hotelblackdbEntity.IsBlack = "1";//0和空为白名单 ; 1=黑名单 hotelblackdbEntity.UpdateUser = UserSession.Current.UserDspName; _hotelblackEntity.HotelBlackDBEntity.Add(hotelblackdbEntity); int i = HotelBlackBP.UpdateHotelBlackListByExist(_hotelblackEntity); MessageContent.InnerHtml = i == 1 ? "黑名单酒店添加成功!" : "黑名单酒店添加失败!"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "btnAdd", "BtnCompleteStyle();", true); ScriptManager.RegisterStartupScript(this.UpdatePanel3, this.GetType(), "keyClickEvent2", "btnSeachClick()", true); }
/// <summary> /// 添加黑名单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAddHotelBlack_Click(object sender, EventArgs e) { MessageContent.InnerHtml = ""; string strHotel = wctHotelDiv.AutoResult; this.HidHotelValue.Value = strHotel; strHotel = strHotel.Substring((strHotel.IndexOf('[') + 1), (strHotel.IndexOf(']') - 1)); HotelBlackEntity _hotelblackEntity = new HotelBlackEntity(); _hotelblackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelblackEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelblackEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelblackEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelblackEntity.HotelBlackDBEntity = new List<HotelBlackDBEntity>(); HotelBlackDBEntity hotelblackdbEntity = new HotelBlackDBEntity(); hotelblackdbEntity.HotelId = strHotel; hotelblackdbEntity.Source = this.DropChannelDiv.SelectedValue; _hotelblackEntity.HotelBlackDBEntity.Add(hotelblackdbEntity); DataTable dtResult = HotelBlackBP.RepeatHotelBlackList(_hotelblackEntity).QueryResult.Tables[0]; _hotelblackEntity.HotelBlackDBEntity.Clear(); if (dtResult != null && dtResult.Rows.Count > 0) { //MessageContentDiv.InnerHtml = "该酒店已存在!"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "btnAdd2", "invokeOpen3();", true); ScriptManager.RegisterStartupScript(Page, this.GetType(), "btnAdd3", "btnConfirm('" + dtResult.Rows[0]["is_black"].ToString().Replace("1", "黑名单").Replace("0", "白名单") + "');", true); ScriptManager.RegisterStartupScript(Page, this.GetType(), "btnSet", "SetControlValue2();", true); return; } this.HidHotelValue.Value = ""; hotelblackdbEntity.HotelId = strHotel; hotelblackdbEntity.Source = this.DropChannelDiv.SelectedValue; hotelblackdbEntity.IsBlack = "1";//0和空为白名单 ; 1=黑名单 hotelblackdbEntity.CreateUser = UserSession.Current.UserDspName; _hotelblackEntity.HotelBlackDBEntity.Add(hotelblackdbEntity); int i = HotelBlackBP.InsertHotelBlackList(_hotelblackEntity); MessageContent.InnerHtml = i == 1 ? "黑名单酒店添加成功!" : "黑名单酒店添加失败!"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "btnAdd", "BtnCompleteStyle();", true); //btnSearch_Click(null, null); ScriptManager.RegisterStartupScript(this.UpdatePanel3, this.GetType(), "keyClickEvent2", "btnSeachClick()", true); }
public static int UpdateHotelBlackListByExist(HotelBlackEntity hotelblackEntity) { OracleParameter[] parm ={ new OracleParameter("ISBLACK",OracleType.VarChar), new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("UPDATEUSER",OracleType.VarChar) }; HotelBlackDBEntity dbParm = (hotelblackEntity.HotelBlackDBEntity.Count > 0) ? hotelblackEntity.HotelBlackDBEntity[0] : new HotelBlackDBEntity(); if (String.IsNullOrEmpty(dbParm.IsBlack)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.IsBlack; } if (String.IsNullOrEmpty(dbParm.HotelId)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.HotelId; } if (String.IsNullOrEmpty(dbParm.Source)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.Source; } if (String.IsNullOrEmpty(dbParm.UpdateUser)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.UpdateUser; } DbManager.ExecuteSql("HotelBlackList", "t_lm_hotel_blacklist_update_exist", parm); return 1; }
public static HotelBlackEntity RepeatHotelBlackList(HotelBlackEntity hotelblackEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar) }; HotelBlackDBEntity dbParm = (hotelblackEntity.HotelBlackDBEntity.Count > 0) ? hotelblackEntity.HotelBlackDBEntity[0] : new HotelBlackDBEntity(); parm[0].Value = dbParm.HotelId; parm[1].Value = dbParm.Source; hotelblackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelBlackList", "t_lm_hotel_blacklist_repeat", true, parm); return hotelblackEntity; }
public static int InsertHotelBlackList(HotelBlackEntity hotelblackEntity) { OracleParameter[] parm ={ new OracleParameter("ID",OracleType.Number), new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("ISBLACK",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("CREATEUSER",OracleType.VarChar) }; HotelBlackDBEntity dbParm = (hotelblackEntity.HotelBlackDBEntity.Count > 0) ? hotelblackEntity.HotelBlackDBEntity[0] : new HotelBlackDBEntity(); parm[0].Value = getMaxIDfromSeq("t_lm_hotel_blacklist_SEQ"); //:ID,:HOTELID,:ISBLACK,:SOURCE,sysdate,:CREATEUSER if (String.IsNullOrEmpty(dbParm.HotelId)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.HotelId; } if (String.IsNullOrEmpty(dbParm.IsBlack)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.IsBlack; } if (String.IsNullOrEmpty(dbParm.Source)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.Source; } if (String.IsNullOrEmpty(dbParm.CreateUser)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.CreateUser; } DbManager.ExecuteSql("HotelBlackList", "t_lm_hotel_blacklist_insert", parm); return 1; }