protected void btnSearch_Click(object sender, EventArgs e)
{
string getResult = string.Empty;
//string strMobile = this.lbLoginMobile.Text;
//getResult = getSignByPhoneForCC(strMobile);
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity userGroupDBEntity = new UserDBEntity();
userGroupDBEntity.LoginMobile = this.lbLoginMobile.Text.Trim();
_userEntity.UserDBEntity.Add(userGroupDBEntity);
_userEntity = UserSearchBP.getSignByPhoneForCC(_userEntity);
getResult = _userEntity.UserDBEntity[0].SignKey;
if (getResult == "")
{
detailMessageContent.InnerHtml = GetLocalResourceObject("ErrorMessage").ToString();
}
else
{
this.lbSignKey.Text = getResult;
}
}
private void BindUserMainListDetail()
{
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity userGroupDBEntity = new UserDBEntity();
userGroupDBEntity.UserID = hidUserID.Value;
_userEntity.UserDBEntity.Add(userGroupDBEntity);
DataSet dsMainResult = UserSearchBP.UserMainListSelect(_userEntity).QueryResult;
if (dsMainResult.Tables.Count == 0 || dsMainResult.Tables[0].Rows.Count == 0)
{
detailMessageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString();
return;
}
lbUserID.Text = dsMainResult.Tables[0].Rows[0]["ID"].ToString();
lbLoginMobile.Text = dsMainResult.Tables[0].Rows[0]["LOGINMOBILE"].ToString();
ViewState["phonenumber"] = dsMainResult.Tables[0].Rows[0]["LOGINMOBILE"].ToString();//手机号码
lbSignKey.Text = dsMainResult.Tables[0].Rows[0]["SIGN_KEY"].ToString();
lbSignDate.Text = dsMainResult.Tables[0].Rows[0]["SIGNDATE"].ToString();
lbCreateDT.Text = dsMainResult.Tables[0].Rows[0]["CREATEDT"].ToString();
lbAllCount.Text = dsMainResult.Tables[0].Rows[0]["ALLCOUNT"].ToString();
lbCompleCount.Text = dsMainResult.Tables[0].Rows[0]["COMPLECOUNT"].ToString();
lbRegchanel.Text = dsMainResult.Tables[0].Rows[0]["REGCHANELNM"].ToString();
lbDvtoken.Text = dsMainResult.Tables[0].Rows[0]["DVTOKEN"].ToString();
lbPlatform.Text = dsMainResult.Tables[0].Rows[0]["PLATFORMNM"].ToString();
lbVrsion.Text = dsMainResult.Tables[0].Rows[0]["VRSION"].ToString();
lbUserCash.Text = dsMainResult.Tables[0].Rows[0]["USERCASH"].ToString();
}
private void BindUserMainListDetail()
{
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity userGroupDBEntity = new UserDBEntity();
userGroupDBEntity.UserID = hidUserID.Value;
_userEntity.UserDBEntity.Add(userGroupDBEntity);
DataSet dsMainResult = UserSearchBP.UserCashMainListSelect(_userEntity).QueryResult;
if (dsMainResult.Tables.Count == 0 || dsMainResult.Tables[0].Rows.Count == 0)
{
messageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString();
return;
}
lbUserID.Text = dsMainResult.Tables[0].Rows[0]["ID"].ToString();
lbLoginMobile.Text = dsMainResult.Tables[0].Rows[0]["LOGINMOBILE"].ToString();
lbAllCount.Text = dsMainResult.Tables[0].Rows[0]["ALLCOUNT"].ToString();
lbCompleCount.Text = dsMainResult.Tables[0].Rows[0]["COMPLECOUNT"].ToString();
lbRegchanel.Text = dsMainResult.Tables[0].Rows[0]["REGCHANELNM"].ToString();
lbPlatform.Text = dsMainResult.Tables[0].Rows[0]["PLATFORMNM"].ToString();
lbSignIn.Text = dsMainResult.Tables[0].Rows[0]["CREATETIME"].ToString();
lbUseCash.Text = dsMainResult.Tables[0].Rows[0]["USECASH"].ToString();
lbCashApl.Text = dsMainResult.Tables[0].Rows[0]["CASHAPL"].ToString();
lbCashVer.Text = dsMainResult.Tables[0].Rows[0]["CASHVER"].ToString();
}
private void BindViewCSUserListDetail()
{
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity userGroupDBEntity = new UserDBEntity();
userGroupDBEntity.UserID = lbLoginMobile.Text.Trim();
_userEntity.UserDBEntity.Add(userGroupDBEntity);
DataSet dsDetailResult = UserSearchBP.UserCashDetailListSelect(_userEntity).QueryResult;
gridViewCSUserListDetail.DataSource = dsDetailResult.Tables[0].DefaultView;
gridViewCSUserListDetail.DataKeyNames = new string[] { "PKEY", "SELTYPE" };//主键
gridViewCSUserListDetail.DataBind();
}
private DataSet GetYujiDataSource()
{
messageContent.InnerHtml = "";
string HotelID = "";
string CityID = "";
string TagID = "";
string SalesID = "";
if ("0".Equals(ddpConrultType.SelectedValue.Trim()))
{
CityID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
else if ("1".Equals(ddpConrultType.SelectedValue.Trim()))
{
TagID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
else if ("2".Equals(ddpConrultType.SelectedValue.Trim()))
{
HotelID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
else if ("3".Equals(ddpConrultType.SelectedValue.Trim()))
{
SalesID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = hidUserID.Value.Trim().Substring((hidUserID.Value.Trim().IndexOf('[') + 1), (hidUserID.Value.Trim().IndexOf(']') - 1));
usergroupEntity.HotelID = HotelID;
usergroupEntity.CityID = CityID;
usergroupEntity.TagID = TagID;
usergroupEntity.SalesID = SalesID;
usergroupEntity.RType = ddpConrultType.SelectedValue.Trim();
_userEntity.UserDBEntity.Add(usergroupEntity);
return UserSearchBP.PreConsultRoomUserSelect(_userEntity).QueryResult;
}
private void BindmyHistoryGridDetail()
{
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity userGroupDBEntity = new UserDBEntity();
userGroupDBEntity.UserID = lbLoginMobile.Text.Trim();
userGroupDBEntity.Pkey = hidPkey.Value.Trim();
userGroupDBEntity.SelectType = hidSelectType.Value.Trim();
_userEntity.UserDBEntity.Add(userGroupDBEntity);
DataSet dsDetailResult = UserSearchBP.UserCashPopListSelect(_userEntity).QueryResult;
myGridView.DataSource = dsDetailResult.Tables["MASTER"].DefaultView;
myGridView.DataKeyNames = new string[] { "PKEY" };//主键
myGridView.DataBind();
myHistoryGridView.DataSource = dsDetailResult.Tables["DETAIL"].DefaultView;
myHistoryGridView.DataKeyNames = new string[] { "CHDTIME" };//主键
myHistoryGridView.DataBind();
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "AddNewlist();", true);
}
protected void btnRefush_Click(object sender, EventArgs e)
{
messageContent.InnerHtml = "";
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserNo = hidSelecID.Value.Trim();
_userEntity.UserDBEntity.Add(usergroupEntity);
DataSet dsResult = UserSearchBP.ReviewConsultRoomUserDetail(_userEntity).QueryResult;
roomDetailGridView.DataSource = dsResult.Tables[0].DefaultView;
roomDetailGridView.DataKeyNames = new string[] { "HEXID" };//主键
roomDetailGridView.DataBind();
string strTemp = "";
for (int i = 0; i < roomDetailGridView.Rows.Count; i++)
{
//首先判断是否是数据行
if (roomDetailGridView.Rows[i].RowType == DataControlRowType.DataRow)
{
strTemp = roomDetailGridView.DataKeys[i].Values[0].ToString().Trim();
if (String.IsNullOrEmpty(strTemp))
{
continue;
}
roomDetailGridView.Rows[i].Cells[0].Attributes.Add("bgcolor", "#FF6666");
}
}
}
private void BindReviewUserListGrid()
{
//messageContent.InnerHtml = "";
//if (!checkNum(txtUserCountFrom.Value.Trim()) || !checkNum(txtUserCountTo.Value.Trim()))
//{
// messageContent.InnerHtml = GetLocalResourceObject("ErrorNum").ToString();
// return;
//}
//if ((!String.IsNullOrEmpty(txtUserCountFrom.Value.ToString().Trim()) && !String.IsNullOrEmpty(txtUserCountTo.Value.ToString().Trim())) && (int.Parse(txtUserCountFrom.Value.ToString().Trim()) > int.Parse(txtUserCountTo.Value.ToString().Trim())))
//{
// messageContent.InnerHtml = GetLocalResourceObject("Error1").ToString();
// return;
//}
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["UserID"].ToString())) ? null : ViewState["UserID"].ToString();
usergroupEntity.RegistStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RegistStart"].ToString())) ? null : ViewState["RegistStart"].ToString();
usergroupEntity.RegistEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RegistEnd"].ToString())) ? null : ViewState["RegistEnd"].ToString();
usergroupEntity.RegChannelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RegChannelID"].ToString())) ? null : ViewState["RegChannelID"].ToString();
usergroupEntity.PlatformID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PlatformID"].ToString())) ? null : ViewState["PlatformID"].ToString();
usergroupEntity.OrderFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderFrom"].ToString())) ? null : ViewState["OrderFrom"].ToString();
usergroupEntity.OrderTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderTo"].ToString())) ? null : ViewState["OrderTo"].ToString();
usergroupEntity.OrderSucFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderSucFrom"].ToString())) ? null : ViewState["OrderSucFrom"].ToString();
usergroupEntity.OrderSucTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderSucTo"].ToString())) ? null : ViewState["OrderSucTo"].ToString();
//usergroupEntity.OrderCount = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderCount"].ToString())) ? null : ViewState["OrderCount"].ToString();
//usergroupEntity.OrderSuccCount = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderSucCount"].ToString())) ? null : ViewState["OrderSucCount"].ToString();
usergroupEntity.LoginStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginStart"].ToString())) ? null : ViewState["LoginStart"].ToString();
usergroupEntity.LoginEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginEnd"].ToString())) ? null : ViewState["LoginEnd"].ToString();
usergroupEntity.LoginSizeStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginSizeStart"].ToString())) ? null : ViewState["LoginSizeStart"].ToString();
usergroupEntity.LoginSizeEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginSizeEnd"].ToString())) ? null : ViewState["LoginSizeEnd"].ToString();
usergroupEntity.TicketType = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Type"].ToString())) ? null : ViewState["Type"].ToString();
usergroupEntity.TicketData = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Data"].ToString())) ? null : ViewState["Data"].ToString();
usergroupEntity.PackageName = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["packagename"].ToString())) ? null : ViewState["packagename"].ToString();
usergroupEntity.AmountFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["amountfrom"].ToString())) ? null : ViewState["amountfrom"].ToString();
usergroupEntity.AmountTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["amountto"].ToString())) ? null : ViewState["amountto"].ToString();
usergroupEntity.PickfromDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["pickfromdate"].ToString())) ? null : ViewState["pickfromdate"].ToString();
usergroupEntity.PicktoDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["picktodate"].ToString())) ? null : ViewState["picktodate"].ToString();
usergroupEntity.TicketTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["tickettime"].ToString())) ? null : ViewState["tickettime"].ToString();
if (gridViewCSReviewUserList != null && gridViewCSReviewUserList.Columns.Count > 0 && String.IsNullOrEmpty(usergroupEntity.TicketType) && String.IsNullOrEmpty(usergroupEntity.OrderFrom) && String.IsNullOrEmpty(usergroupEntity.OrderTo) && String.IsNullOrEmpty(usergroupEntity.OrderSucFrom) && String.IsNullOrEmpty(usergroupEntity.OrderSucTo))
{
gridViewCSReviewUserList.Columns[7].Visible = false;
gridViewCSReviewUserList.Columns[8].Visible = false;
}
else
{
gridViewCSReviewUserList.Columns[7].Visible = true;
gridViewCSReviewUserList.Columns[8].Visible = true;
}
_userEntity.PageCurrent = AspNetPager1.CurrentPageIndex;
_userEntity.PageSize = gridViewCSReviewUserList.PageSize;
//usergroupEntity.SelectType = hidSelectType.Value;
_userEntity.UserDBEntity.Add(usergroupEntity);
DataSet dsResult = UserSearchBP.ReviewSelect(_userEntity).QueryResult;
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
{
if (dsResult.Tables[0].Rows[i]["LOGINMOBILE"].ToString().Trim() == "" && dsResult.Tables[0].Rows[i]["THIRD_PARTY_VENDOR"].ToString().Trim() == "")
{
dsResult.Tables[0].Rows[i]["LOGINMOBILE"] = "游客";
}
else if (dsResult.Tables[0].Rows[i]["LOGINMOBILE"].ToString().Trim() == "" && dsResult.Tables[0].Rows[i]["THIRD_PARTY_VENDOR"].ToString().Trim() == "QUNAR")
{
dsResult.Tables[0].Rows[i]["LOGINMOBILE"] = "QUNAR";
}
}
}
gridViewCSReviewUserList.DataSource = dsResult.Tables[0].DefaultView;
gridViewCSReviewUserList.DataKeyNames = new string[] { "ID" };//主键
gridViewCSReviewUserList.DataBind();
AspNetPager1.PageSize = gridViewCSReviewUserList.PageSize;
AspNetPager1.RecordCount = CountLmSystemLog();
//this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true);
ScriptManager.RegisterStartupScript(this.UpdatePanel3, this.GetType(), "setScript", "SetAClickEvent()", true);
//lbCount.Text = dsResult.Tables[0].Rows.Count.ToString();
}
protected void btnDel_Click(object sender, EventArgs e)
{
string strID = hidConID.Value.ToString();
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserNo = strID;
_userEntity.UserDBEntity.Add(usergroupEntity);
int iResult = UserGroupBP.DeleteConsultRoomUser(_userEntity);
_commonEntity.LogMessages = _userEntity.LogMessages;
_commonEntity.CommonDBEntity = new List<CommonDBEntity>();
CommonDBEntity commonDBEntity = new CommonDBEntity();
commonDBEntity.Event_Type = "巡房条件-删除";
commonDBEntity.Event_ID = hidUserID.Value.ToString().Trim();
string conTent = GetLocalResourceObject("EventDeleteMessage").ToString();
conTent = string.Format(conTent, usergroupEntity.UserNo);
commonDBEntity.Event_Content = conTent;
if (iResult == 1)
{
commonDBEntity.Event_Result = GetLocalResourceObject("DelSuccess").ToString();
messageContent.InnerHtml = GetLocalResourceObject("DelSuccess").ToString();
//BindReviewUserListGrid();
if (hidConID.Value.Equals(hidSelecID.Value))
{
roomDetailGridView.DataSource = null;
roomDetailGridView.DataBind();
}
ScriptManager.RegisterStartupScript(this.UpdatePanel3, this.GetType(), "updateScript", "BtnDelCompleteStyle();", true);
}
else
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error5").ToString();
messageContent.InnerHtml = GetLocalResourceObject("Error5").ToString();
}
_commonEntity.CommonDBEntity.Add(commonDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
}
protected void btnOK_Click(object sender, EventArgs e)
{
messageContent.InnerHtml = "";
string HotelID = "";
string CityID = "";
string TagID = "";
string SalesID = "";
if (String.IsNullOrEmpty(hidAddAutoVal.Value.Trim()))
{
if ("0".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error7").ToString();
}
else if ("1".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error8").ToString();
}
else if ("2".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error9").ToString();
}
else if ("3".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error91").ToString();
}
ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
if (!hidAddAutoVal.Value.Trim().Contains("[") || !hidAddAutoVal.Value.Trim().Contains("]"))
{
if ("0".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error10").ToString();
}
else if ("1".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error11").ToString();
}
else if ("2".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error12").ToString();
}
else if ("2".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error101").ToString();
}
ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
if ("0".Equals(ddpConrultType.SelectedValue.Trim()))
{
CityID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
else if ("1".Equals(ddpConrultType.SelectedValue.Trim()))
{
TagID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
else if ("2".Equals(ddpConrultType.SelectedValue.Trim()))
{
HotelID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
else if ("3".Equals(ddpConrultType.SelectedValue.Trim()))
{
SalesID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
//usergroupEntity.UserID = hidUserID.Value.Trim().Substring((hidUserID.Value.Trim().IndexOf('[') + 1), (hidUserID.Value.Trim().IndexOf(']') - 1));
usergroupEntity.HotelID = HotelID;
usergroupEntity.CityID = CityID;
usergroupEntity.TagID = TagID;
usergroupEntity.SalesID = SalesID;
usergroupEntity.RType = ddpConrultType.SelectedValue.Trim();
_userEntity.UserDBEntity.Add(usergroupEntity);
DataSet dsResult = UserSearchBP.PreConsultRoomUserSelect(_userEntity).QueryResult;
addHotelView.DataSource = dsResult.Tables[0].DefaultView;
addHotelView.DataKeyNames = new string[] { "HOTELID" };//主键
addHotelView.DataBind();
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
lbAddTotal.Text = dsResult.Tables[0].Rows.Count.ToString();
}
else
{
lbAddTotal.Text = "0";
}
dvBtnSty.Style.Add("display", "");
dvBtnOK.Style.Add("display", "none");
ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "updateScript", "BtnOKCompleteStyle();", true);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
messageContent.InnerHtml = "";
string HotelID = "";
string CityID = "";
string TagID = "";
string SalesID = "";
if (String.IsNullOrEmpty(hidUserID.Value.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error14").ToString();
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
if (String.IsNullOrEmpty(hidAddAutoVal.Value.Trim()))
{
if ("0".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error7").ToString();
}
else if ("1".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error8").ToString();
}
else if ("2".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error9").ToString();
}
else if ("3".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error91").ToString();
}
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
if (!hidAddAutoVal.Value.Trim().Contains("[") || !hidAddAutoVal.Value.Trim().Contains("]"))
{
if ("0".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error10").ToString();
}
else if ("1".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error11").ToString();
}
else if ("2".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error12").ToString();
}
else if ("2".Equals(ddpConrultType.SelectedValue.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error101").ToString();
}
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
if ("0".Equals(ddpConrultType.SelectedValue.Trim()))
{
CityID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
else if ("1".Equals(ddpConrultType.SelectedValue.Trim()))
{
//CityID = hidAddAutoVal2.Value.Trim().Substring((hidAddAutoVal2.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal2.Value.Trim().IndexOf(']') - 1));
TagID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
else if ("2".Equals(ddpConrultType.SelectedValue.Trim()))
{
HotelID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
else if ("3".Equals(ddpConrultType.SelectedValue.Trim()))
{
SalesID = hidAddAutoVal.Value.Trim().Substring((hidAddAutoVal.Value.Trim().IndexOf('[') + 1), (hidAddAutoVal.Value.Trim().IndexOf(']') - 1));
}
if ("2".Equals(ddpConrultType.SelectedValue.Trim()) && hidALDelHT.Value.Contains(HotelID))
{
messageContent.InnerHtml = GetLocalResourceObject("Error13").ToString();
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = hidUserID.Value.Trim().Substring((hidUserID.Value.Trim().IndexOf('[') + 1), (hidUserID.Value.Trim().IndexOf(']') - 1));
usergroupEntity.HotelID = HotelID;
usergroupEntity.CityID = CityID;
usergroupEntity.TagID = TagID;
usergroupEntity.SalesID = SalesID;
usergroupEntity.RType = ddpConrultType.SelectedValue.Trim();
usergroupEntity.ALDelHT = hidALDelHT.Value.ToString();
_userEntity.UserDBEntity.Add(usergroupEntity);
int iResult = UserGroupBP.InsertConsultRoomUser(_userEntity);
_commonEntity.LogMessages = _userEntity.LogMessages;
_commonEntity.CommonDBEntity = new List<CommonDBEntity>();
CommonDBEntity commonDBEntity = new CommonDBEntity();
commonDBEntity.Event_Type = "巡房条件-保存";
commonDBEntity.Event_ID = hidUserID.Value.ToString().Trim();
string conTent = GetLocalResourceObject("EventInsertMessage").ToString();
string conval = "";
if ("0".Equals(usergroupEntity.RType))
{
conval = usergroupEntity.CityID;
}
else if ("1".Equals(usergroupEntity.RType))
{
conval = usergroupEntity.CityID + "-" + usergroupEntity.TagID;
}
else if ("2".Equals(usergroupEntity.RType))
{
conval = usergroupEntity.HotelID;
}
else if ("3".Equals(usergroupEntity.RType))
{
conval = usergroupEntity.SalesID;
}
conTent = string.Format(conTent, usergroupEntity.UserID, usergroupEntity.RType, conval);
commonDBEntity.Event_Content = conTent;
if (iResult == 1)
{
commonDBEntity.Event_Result = GetLocalResourceObject("InsertSuccess").ToString();
messageContent.InnerHtml = GetLocalResourceObject("InsertSuccess").ToString();
dvBtnSty.Style.Add("display", "none");
dvBtnOK.Style.Add("display", "");
lbAddTotal.Text = "0";
hidALDelHT.Value = "";
hidAddDelHTID.Value = "";
hidALDelTP.Value = "";
addHotelView.DataSource = null;
addHotelView.DataBind();
//BindReviewUserListGrid();
ScriptManager.RegisterStartupScript(this.UpdatePanel3, this.GetType(), "updateScript", "BtnADDCompleteStyle();", true);
}
else if (iResult == 2)
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error2").ToString();
messageContent.InnerHtml = GetLocalResourceObject("Error2").ToString();
}
else if (iResult == 3)
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error3").ToString();
messageContent.InnerHtml = GetLocalResourceObject("Error3").ToString();
}
else
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error4").ToString();
messageContent.InnerHtml = GetLocalResourceObject("Error4").ToString();
}
_commonEntity.CommonDBEntity.Add(commonDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
}
//导出Excel文件
protected void btnExport_Click(object sender, EventArgs e)
{
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["UserID"].ToString())) ? null : ViewState["UserID"].ToString();
usergroupEntity.RegistStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RegistStart"].ToString())) ? null : ViewState["RegistStart"].ToString();
usergroupEntity.RegistEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RegistEnd"].ToString())) ? null : ViewState["RegistEnd"].ToString();
usergroupEntity.RegChannelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RegChannelID"].ToString())) ? null : ViewState["RegChannelID"].ToString();
usergroupEntity.PlatformID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PlatformID"].ToString())) ? null : ViewState["PlatformID"].ToString();
usergroupEntity.OrderFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderFrom"].ToString())) ? null : ViewState["OrderFrom"].ToString();
usergroupEntity.OrderTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderTo"].ToString())) ? null : ViewState["OrderTo"].ToString();
usergroupEntity.OrderSucFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderSucFrom"].ToString())) ? null : ViewState["OrderSucFrom"].ToString();
usergroupEntity.OrderSucTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderSucTo"].ToString())) ? null : ViewState["OrderSucTo"].ToString();
//usergroupEntity.OrderCount = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderCount"].ToString())) ? null : ViewState["OrderCount"].ToString();
//usergroupEntity.OrderSuccCount = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderSucCount"].ToString())) ? null : ViewState["OrderSucCount"].ToString();
usergroupEntity.LoginStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginStart"].ToString())) ? null : ViewState["LoginStart"].ToString();
usergroupEntity.LoginEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginEnd"].ToString())) ? null : ViewState["LoginEnd"].ToString();
usergroupEntity.LoginSizeStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginSizeStart"].ToString())) ? null : ViewState["LoginSizeStart"].ToString();
usergroupEntity.LoginSizeEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginSizeEnd"].ToString())) ? null : ViewState["LoginSizeEnd"].ToString();
usergroupEntity.TicketType = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Type"].ToString())) ? null : ViewState["Type"].ToString();
usergroupEntity.TicketData = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Data"].ToString())) ? null : ViewState["Data"].ToString();
usergroupEntity.PackageName = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["packagename"].ToString())) ? null : ViewState["packagename"].ToString();
usergroupEntity.AmountFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["amountfrom"].ToString())) ? null : ViewState["amountfrom"].ToString();
usergroupEntity.AmountTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["amountto"].ToString())) ? null : ViewState["amountto"].ToString();
usergroupEntity.PickfromDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["pickfromdate"].ToString())) ? null : ViewState["pickfromdate"].ToString();
usergroupEntity.PicktoDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["picktodate"].ToString())) ? null : ViewState["picktodate"].ToString();
usergroupEntity.TicketTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["tickettime"].ToString())) ? null : ViewState["tickettime"].ToString();
//usergroupEntity.SelectType = hidSelectType.Value;
_userEntity.UserDBEntity.Add(usergroupEntity);
DataSet dsResult = UserSearchBP.ExportReviewSelect(_userEntity).QueryResult;
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
{
if (dsResult.Tables[0].Rows[i]["LOGINMOBILE"].ToString().Trim() == "" && dsResult.Tables[0].Rows[i]["THIRD_PARTY_VENDOR"].ToString().Trim() == "")
{
dsResult.Tables[0].Rows[i]["LOGINMOBILE"] = "游客";
}
else if (dsResult.Tables[0].Rows[i]["LOGINMOBILE"].ToString().Trim() == "" && dsResult.Tables[0].Rows[i]["THIRD_PARTY_VENDOR"].ToString().Trim() == "QUNAR")
{
dsResult.Tables[0].Rows[i]["LOGINMOBILE"] = "QUNAR";
}
}
}
CommonFunction.ExportExcelForLM(dsResult);
//background.Style.Add("display", "none");
//progressBar.Style.Add("display", "none");
}
private int CountLmSystemLog()
{
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["UserID"].ToString())) ? null : ViewState["UserID"].ToString();
usergroupEntity.RegistStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RegistStart"].ToString())) ? null : ViewState["RegistStart"].ToString();
usergroupEntity.RegistEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RegistEnd"].ToString())) ? null : ViewState["RegistEnd"].ToString();
usergroupEntity.RegChannelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RegChannelID"].ToString())) ? null : ViewState["RegChannelID"].ToString();
usergroupEntity.PlatformID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PlatformID"].ToString())) ? null : ViewState["PlatformID"].ToString();
usergroupEntity.OrderFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderFrom"].ToString())) ? null : ViewState["OrderFrom"].ToString();
usergroupEntity.OrderTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderTo"].ToString())) ? null : ViewState["OrderTo"].ToString();
usergroupEntity.OrderSucFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderSucFrom"].ToString())) ? null : ViewState["OrderSucFrom"].ToString();
usergroupEntity.OrderSucTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderSucTo"].ToString())) ? null : ViewState["OrderSucTo"].ToString();
//usergroupEntity.OrderCount = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderCount"].ToString())) ? null : ViewState["OrderCount"].ToString();
//usergroupEntity.OrderSuccCount = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderSucCount"].ToString())) ? null : ViewState["OrderSucCount"].ToString();
usergroupEntity.LoginStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginStart"].ToString())) ? null : ViewState["LoginStart"].ToString();
usergroupEntity.LoginEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginEnd"].ToString())) ? null : ViewState["LoginEnd"].ToString();
usergroupEntity.LoginSizeStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginSizeStart"].ToString())) ? null : ViewState["LoginSizeStart"].ToString();
usergroupEntity.LoginSizeEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["LoginSizeEnd"].ToString())) ? null : ViewState["LoginSizeEnd"].ToString();
usergroupEntity.TicketType = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Type"].ToString())) ? null : ViewState["Type"].ToString();
usergroupEntity.TicketData = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Data"].ToString())) ? null : ViewState["Data"].ToString();
usergroupEntity.PackageName = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["packagename"].ToString())) ? null : ViewState["packagename"].ToString();
usergroupEntity.AmountFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["amountfrom"].ToString())) ? null : ViewState["amountfrom"].ToString();
usergroupEntity.AmountTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["amountto"].ToString())) ? null : ViewState["amountto"].ToString();
usergroupEntity.PickfromDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["pickfromdate"].ToString())) ? null : ViewState["pickfromdate"].ToString();
usergroupEntity.PicktoDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["picktodate"].ToString())) ? null : ViewState["picktodate"].ToString();
usergroupEntity.TicketTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["tickettime"].ToString())) ? null : ViewState["tickettime"].ToString();
_userEntity.UserDBEntity.Add(usergroupEntity);
DataSet dsResult = UserSearchBP.ReviewSelectCount(_userEntity).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;
}
private void BindViewCSUserListDetail()
{
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity userGroupDBEntity = new UserDBEntity();
userGroupDBEntity.UserID = hidUserID.Value;
_userEntity.UserDBEntity.Add(userGroupDBEntity);
DataSet dsDetailResult = UserSearchBP.UserDetailListSelect(_userEntity).QueryResult;
// 获取GridView排序数据列及排序方向
string sortExpression = gridViewCSUserListDetail.Attributes["SortExpression"];
string sortDirection = gridViewCSUserListDetail.Attributes["SortDirection"];
// 根据GridView排序数据列及排序方向设置显示的默认数据视图
if ((!string.IsNullOrEmpty(sortExpression)) && (!string.IsNullOrEmpty(sortDirection)))
{
dsDetailResult.Tables[0].DefaultView.Sort = string.Format("{0} {1}", sortExpression, sortDirection);
}
gridViewCSUserListDetail.DataSource = dsDetailResult.Tables[0].DefaultView;
gridViewCSUserListDetail.DataKeyNames = new string[] { "LMID" };//主键
gridViewCSUserListDetail.DataBind();
}
private void BindReviewUserListGrid()
{
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = hidUserID.Value.Trim().Substring((hidUserID.Value.Trim().IndexOf('[') + 1), (hidUserID.Value.Trim().IndexOf(']') - 1));
_userEntity.UserDBEntity.Add(usergroupEntity);
DataSet dsResult = UserSearchBP.ReviewConsultRoomUserSelect(_userEntity).QueryResult;
gridViewCSReviewUserList.DataSource = dsResult.Tables[0].DefaultView;
gridViewCSReviewUserList.DataKeyNames = new string[] { "ID" };//主键
gridViewCSReviewUserList.DataBind();
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
lbUserHotelNum.Text = dsResult.Tables[0].Compute("sum(HTSUM)", "true").ToString();
}
else
{
lbUserHotelNum.Text = "0";
}
}
private string GetUserIDFromMobile(string strMobile)
{
string strResult = "";
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity userGroupDBEntity = new UserDBEntity();
userGroupDBEntity.LoginMobile = strMobile;
_userEntity.UserDBEntity.Add(userGroupDBEntity);
DataSet dsDetailResult = UserSearchBP.GetUserIDFromMobile(_userEntity).QueryResult;
if (dsDetailResult.Tables.Count > 0 && dsDetailResult.Tables[0].Rows.Count > 0)
{
strResult = dsDetailResult.Tables[0].Rows[0][0].ToString();
}
return strResult;
}
//protected void gridViewCSReviewUserList_RowDeleting(object sender, GridViewDeleteEventArgs e)
//{
// string strID = gridViewCSReviewUserList.DataKeys[e.RowIndex].Value.ToString();
// _userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
// _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
// _userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
// _userEntity.LogMessages.Username = UserSession.Current.UserDspName;
// _userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
// _userEntity.UserDBEntity = new List<UserDBEntity>();
// UserDBEntity usergroupEntity = new UserDBEntity();
// usergroupEntity.UserNo = strID;
// _userEntity.UserDBEntity.Add(usergroupEntity);
// int iResult = UserGroupBP.DeleteConsultRoomUser(_userEntity);
// _commonEntity.LogMessages = _userEntity.LogMessages;
// _commonEntity.CommonDBEntity = new List<CommonDBEntity>();
// CommonDBEntity commonDBEntity = new CommonDBEntity();
// commonDBEntity.Event_Type = "巡房条件-删除";
// commonDBEntity.Event_ID = hidUserID.Value.ToString().Trim();
// string conTent = GetLocalResourceObject("EventDeleteMessage").ToString();
// conTent = string.Format(conTent, usergroupEntity.UserNo);
// commonDBEntity.Event_Content = conTent;
// if (iResult == 1)
// {
// commonDBEntity.Event_Result = GetLocalResourceObject("DelSuccess").ToString();
// messageContent.InnerHtml = GetLocalResourceObject("DelSuccess").ToString();
// BindReviewUserListGrid();
// //ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "BtnDelCompleteStyle();", true);
// }
// else
// {
// commonDBEntity.Event_Result = GetLocalResourceObject("Error5").ToString();
// messageContent.InnerHtml = GetLocalResourceObject("Error5").ToString();
// }
// _commonEntity.CommonDBEntity.Add(commonDBEntity);
// CommonBP.InsertEventHistory(_commonEntity);
//}
/// <summary>
/// 分配所有 城市 下面 所有酒店 到 该用户名下
/// 获取 该用户已绑定信息 获取所有城市 绑定到该用户名下
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAllotAllCitys_Click(object sender, EventArgs e)
{
#region 判断是否 有用户
if (String.IsNullOrEmpty(hidSelecUserID.Value.Trim()))
{
messageContent.InnerHtml = "订单审核任务分配绑定城市失败，请选择用户！";
ScriptManager.RegisterStartupScript(this.UpdatePanel2, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
if (!hidSelecUserID.Value.Trim().Contains("[") || !hidSelecUserID.Value.Trim().Contains("]"))
{
messageContent.InnerHtml = "订单审核任务分配绑定城市失败，请选择用户！";
ScriptManager.RegisterStartupScript(this.UpdatePanel2, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
#endregion
hidUserID.Value = hidSelecUserID.Value;
#region 获取该用户 已绑定的 城市 酒店 商圈 信息
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = hidUserID.Value.Trim().Substring((hidUserID.Value.Trim().IndexOf('[') + 1), (hidUserID.Value.Trim().IndexOf(']') - 1));
_userEntity.UserDBEntity.Add(usergroupEntity);
DataSet dsResult = UserSearchBP.ReviewConsultPOrderUserSelect(_userEntity).QueryResult;//用户绑定信息
#endregion
#region 获取所有城市
CityEntity _cityEntity = new CityEntity();
_cityEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_cityEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_cityEntity.LogMessages.Username = UserSession.Current.UserDspName;
_cityEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_cityEntity.CityDBEntity = new List<CityDBEntity>();
CityDBEntity cityDBEntity = new CityDBEntity();
_cityEntity.CityDBEntity.Add(cityDBEntity);
DataSet dsCityResult = CityBP.Select(_cityEntity).QueryResult;
#endregion
for (int i = 0; i < dsCityResult.Tables[0].Rows.Count; i++)
{
DataRow[] rows = dsResult.Tables[0].Select("CONSULTVAL='" + dsCityResult.Tables[0].Rows[i]["CONSULTVAL"].ToString() + "'");
if (rows.Length == 0)//当前城市没有绑定 将该城市 绑定到该用户下面
{
string CityID = dsCityResult.Tables[0].Rows[i]["cityID"].ToString();
#region 保存城市 记录日志
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = hidUserID.Value.Trim().Substring((hidUserID.Value.Trim().IndexOf('[') + 1), (hidUserID.Value.Trim().IndexOf(']') - 1));
usergroupEntity.CityID = CityID;
usergroupEntity.RType = "0";//城市
_userEntity.UserDBEntity.Add(usergroupEntity);
int iResult = UserGroupBP.InsertConsultPOrderUser(_userEntity);
_commonEntity.LogMessages = _userEntity.LogMessages;
_commonEntity.CommonDBEntity = new List<CommonDBEntity>();
CommonDBEntity commonDBEntity = new CommonDBEntity();
commonDBEntity.Event_Type = "订单审核任务分配-All-批量城市-保存";
commonDBEntity.Event_ID = hidUserID.Value.ToString().Trim();
string conTent = GetLocalResourceObject("EventInsertMessage").ToString();
string conval = usergroupEntity.CityID;
conTent = string.Format(conTent, usergroupEntity.UserID, usergroupEntity.RType, conval);
commonDBEntity.Event_Content = conTent;
if (iResult == 1)
{
commonDBEntity.Event_Result = GetLocalResourceObject("InsertSuccess").ToString();
}
else if (iResult == 2)
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error2").ToString();
}
else if (iResult == 3)
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error3").ToString();
}
else
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error4").ToString();
}
_commonEntity.CommonDBEntity.Add(commonDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
#endregion
}
}
ScriptManager.RegisterStartupScript(this.UpdatePanel2, this.GetType(), "updateScriptAll", "BtnCompleteStyle();", true);
}