public static UserEntity getSignByPhoneForCC(UserEntity userEntity)
{
string DataString = string.Empty;
UserDBEntity dbParm = (userEntity.UserDBEntity.Count > 0) ? userEntity.UserDBEntity[0] : new UserDBEntity();
DataString = "{\"mobile\":\"" + dbParm.LoginMobile + "\"," + "\"isUpdate\":\"" + "1" + "\"}";
string SaveCashBackRequestUrl = JsonRequestURLBuilder.getSignByPhoneForCCV2();// +PostSignKey(DataString);
CallWebPage callWebPage = new CallWebPage();
string strSaveCashBack = callWebPage.CallWebByURL(SaveCashBackRequestUrl, DataString);
JObject oSaveCashBack = JObject.Parse(strSaveCashBack);
if ("success".Equals(JsonRequestURLBuilder.GetJsonStringValue(oSaveCashBack, "message").Trim('"')))
{
userEntity.Result = 1;
userEntity.UserDBEntity[0].SignKey = JsonRequestURLBuilder.GetJsonStringValue(oSaveCashBack, "result").Trim('"');
//string oIDs = oSaveCashBack.SelectToken("result").ToString();
//JObject oID = JObject.Parse(oIDs);
//userEntity.UserDBEntity[0].SignKey = oID.SelectToken("sn").ToString().Trim('"');
}
else
{
string ErrorMSG = JsonRequestURLBuilder.GetJsonStringValue(oSaveCashBack, "message").Trim('"');
userEntity.ErrorMSG = ErrorMSG;
userEntity.Result = 2;
}
return userEntity;
}
public static int DeleteConsultRoomUser(UserEntity userEntity)
{
userEntity.LogMessages.MsgType = MessageType.INFO;
userEntity.LogMessages.Content = _nameSpaceClass + "DeleteConsultRoomUser";
LoggerHelper.LogWriter(userEntity.LogMessages);
try
{
return UserGroupDA.DeleteConsultRoomUser(userEntity);
}
catch (Exception ex)
{
userEntity.LogMessages.MsgType = MessageType.ERROR;
userEntity.LogMessages.Content = _nameSpaceClass + "DeleteConsultRoomUser Error: " + ex.Message;
LoggerHelper.LogWriter(userEntity.LogMessages);
throw ex;
}
}
public static UserEntity GetPlatFormList(UserEntity userEntity)
{
userEntity.LogMessages.MsgType = MessageType.INFO;
userEntity.LogMessages.Content = _nameSpaceClass + "CommonSelect";
LoggerHelper.LogWriter(userEntity.LogMessages);
try
{
return UserSearchDA.GetPlatFormList(userEntity);
}
catch (Exception ex)
{
userEntity.LogMessages.MsgType = MessageType.ERROR;
userEntity.LogMessages.Content = _nameSpaceClass + "CommonSelect Error: " + ex.Message;
LoggerHelper.LogWriter(userEntity.LogMessages);
throw ex;
}
}
public static UserEntity ReviewSelectCount(UserEntity userEntity)
{
UserDBEntity dbParm = (userEntity.UserDBEntity.Count > 0) ? userEntity.UserDBEntity[0] : new UserDBEntity();
string SqlString = "t_lm_user_review_count";
if (String.IsNullOrEmpty(dbParm.TicketType))
{
OracleParameter[] parm ={
new OracleParameter("UserID",OracleType.VarChar),
new OracleParameter("RegistStart",OracleType.VarChar),
new OracleParameter("RegistEnd",OracleType.VarChar),
new OracleParameter("RegChannelID",OracleType.VarChar),
new OracleParameter("PlatformID",OracleType.VarChar),
new OracleParameter("OrderFrom",OracleType.VarChar),
new OracleParameter("OrderTo",OracleType.VarChar),
new OracleParameter("OrderSucFrom",OracleType.VarChar),
new OracleParameter("OrderSucTo",OracleType.VarChar),
new OracleParameter("LoginStart",OracleType.VarChar),
new OracleParameter("LoginEnd",OracleType.VarChar),
new OracleParameter("LoginSizeStart",OracleType.VarChar),
new OracleParameter("LoginSizeEnd",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.UserID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.UserID;
SqlString = "t_lm_user_review_user_count";
}
if (String.IsNullOrEmpty(dbParm.RegistStart))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.RegistStart;
}
if (String.IsNullOrEmpty(dbParm.RegistEnd))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.RegistEnd;
}
if (String.IsNullOrEmpty(dbParm.RegChannelID))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.RegChannelID;
}
if (String.IsNullOrEmpty(dbParm.PlatformID))
{
parm[4].Value = DBNull.Value;
}
else
{
parm[4].Value = dbParm.PlatformID;
}
if (String.IsNullOrEmpty(dbParm.OrderFrom))
{
parm[5].Value = DBNull.Value;
}
else
{
parm[5].Value = dbParm.OrderFrom;
}
if (String.IsNullOrEmpty(dbParm.OrderTo))
{
parm[6].Value = DBNull.Value;
}
else
{
parm[6].Value = dbParm.OrderTo;
}
if (String.IsNullOrEmpty(dbParm.OrderSucFrom))
{
parm[7].Value = DBNull.Value;
}
else
{
parm[7].Value = dbParm.OrderSucFrom;
}
if (String.IsNullOrEmpty(dbParm.OrderSucTo))
{
parm[8].Value = DBNull.Value;
}
else
{
parm[8].Value = dbParm.OrderSucTo;
}
if (String.IsNullOrEmpty(dbParm.LoginStart))
{
parm[9].Value = DBNull.Value;
}
else
{
parm[9].Value = dbParm.LoginStart;
}
if (String.IsNullOrEmpty(dbParm.LoginEnd))
{
parm[10].Value = DBNull.Value;
}
else
{
parm[10].Value = dbParm.LoginEnd;
}
if (String.IsNullOrEmpty(dbParm.LoginSizeStart))
{
parm[11].Value = DBNull.Value;
}
else
{
parm[11].Value = dbParm.LoginSizeStart;
}
if (String.IsNullOrEmpty(dbParm.LoginSizeEnd))
{
parm[12].Value = DBNull.Value;
}
else
{
parm[12].Value = dbParm.LoginSizeEnd;
}
if (String.IsNullOrEmpty(dbParm.OrderFrom) && String.IsNullOrEmpty(dbParm.OrderTo) && String.IsNullOrEmpty(dbParm.OrderSucFrom) && String.IsNullOrEmpty(dbParm.OrderSucTo))
{
SqlString = ("t_lm_user_review_count".Equals(SqlString)) ? "t_lm_user_review_no_order_count" : "t_lm_user_review_user_no_order_count";
}
userEntity.QueryResult = DbManager.Query("User", SqlString , true, parm);
}
else
{
OracleParameter[] parm ={
new OracleParameter("PACKAGENAME",OracleType.VarChar),
new OracleParameter("AMOUNTFROM",OracleType.Int32),
new OracleParameter("AMOUNTTO",OracleType.Int32),
new OracleParameter("STARTDATE",OracleType.VarChar),
new OracleParameter("ENDDATE",OracleType.VarChar),
new OracleParameter("PACKAGETYPE",OracleType.VarChar),
new OracleParameter("TICKETDT",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.PackageName))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.PackageName;
}
if (String.IsNullOrEmpty(dbParm.AmountFrom))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.AmountFrom;
}
if (String.IsNullOrEmpty(dbParm.AmountTo))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.AmountTo;
}
if (String.IsNullOrEmpty(dbParm.PickfromDate))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.PickfromDate;
}
if (String.IsNullOrEmpty(dbParm.PicktoDate))
{
parm[4].Value = DBNull.Value;
}
else
{
parm[4].Value = dbParm.PicktoDate;
}
if (String.IsNullOrEmpty(dbParm.TicketType))
{
parm[5].Value = DBNull.Value;
}
else
{
parm[5].Value = dbParm.TicketType;
}
if (String.IsNullOrEmpty(dbParm.TicketTime))
{
parm[6].Value = DBNull.Value;
}
else
{
parm[6].Value = dbParm.TicketTime;
}
//if (String.IsNullOrEmpty(dbParm.TicketType))
//{
// parm[0].Value = DBNull.Value;
//}
//else
//{
// parm[0].Value = dbParm.TicketType;
//}
string strSql = "";
if ("1".Equals(dbParm.TicketData))
{
strSql = "t_lm_user_review_ticketype_ord_count";
}
else
{
strSql = "t_lm_user_review_ticketype_all_count";
}
userEntity.QueryResult = DbManager.Query("User", strSql, true, parm);
}
return userEntity;
}
public static UserEntity ReviewConsultRoomUserSelect(UserEntity paymentEntity)
{
OracleParameter[] parm ={
new OracleParameter("USERID",OracleType.VarChar)
};
UserDBEntity dbParm = (paymentEntity.UserDBEntity.Count > 0) ? paymentEntity.UserDBEntity[0] : new UserDBEntity();
if (String.IsNullOrEmpty(dbParm.UserID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.UserID;
}
DataSet dsResult = DbManager.Query("User", "t_lm_consult_room_user_main_select", true, parm);
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && dsResult.Tables[0].Select("CONSULTTYPE='销售'").Length > 0)
{
for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
{
if ("销售".Equals(dsResult.Tables[0].Rows[i]["CONSULTTYPE"].ToString().Trim()))
{
dsResult.Tables[0].Rows[i]["CONSULTVAL"] = GetSalesName(dsResult.Tables[0].Rows[i]["CONSULTVAL"].ToString().Trim());
}
}
}
paymentEntity.QueryResult = dsResult;
return paymentEntity;
}
public static UserEntity ReviewConsultRoomUserDetail(UserEntity paymentEntity)
{
OracleParameter[] parm ={
new OracleParameter("KEYID",OracleType.VarChar)
};
UserDBEntity dbParm = (paymentEntity.UserDBEntity.Count > 0) ? paymentEntity.UserDBEntity[0] : new UserDBEntity();
if (String.IsNullOrEmpty(dbParm.UserNo))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.UserNo;
}
paymentEntity.QueryResult = DbManager.Query("User", "t_lm_consult_room_user_detail_select", true, parm);
return paymentEntity;
}
public static UserEntity ReviewConsultPOrderUserSelect(UserEntity paymentEntity)
{
OracleParameter[] parm ={
new OracleParameter("USERID",OracleType.VarChar)
};
UserDBEntity dbParm = (paymentEntity.UserDBEntity.Count > 0) ? paymentEntity.UserDBEntity[0] : new UserDBEntity();
if (String.IsNullOrEmpty(dbParm.UserID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.UserID;
}
paymentEntity.QueryResult = DbManager.Query("User", "t_lm_consult_porder_user_main_select", true, parm);
return paymentEntity;
}
public static UserEntity GetUserIDFromMobile(UserEntity userEntity)
{
userEntity.LogMessages.MsgType = MessageType.INFO;
userEntity.LogMessages.Content = _nameSpaceClass + "GetUserIDFromMobile";
LoggerHelper.LogWriter(userEntity.LogMessages);
try
{
return UserSearchDA.GetUserIDFromMobile(userEntity);
}
catch (Exception ex)
{
userEntity.LogMessages.MsgType = MessageType.ERROR;
userEntity.LogMessages.Content = _nameSpaceClass + "GetUserIDFromMobile Error: " + ex.Message;
LoggerHelper.LogWriter(userEntity.LogMessages);
throw ex;
}
}
public static int InsertConsultRoomUser(UserEntity userEntity)
{
if (userEntity.UserDBEntity.Count == 0)
{
return 0;
}
if (userEntity.LogMessages == null)
{
return 0;
}
if (CheckConsultInsert(userEntity) > 0)
{
return 2;
}
UserDBEntity dbParm = (userEntity.UserDBEntity.Count > 0) ? userEntity.UserDBEntity[0] : new UserDBEntity();
OracleParameter[] parm ={
new OracleParameter("USERID",OracleType.VarChar),
new OracleParameter("RTYPE",OracleType.VarChar),
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("TAGID",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("CREATEUSER",OracleType.VarChar),
new OracleParameter("TCID",OracleType.Int32),
new OracleParameter("SALESID",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.UserID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.UserID;
}
if (String.IsNullOrEmpty(dbParm.RType))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.RType;
}
if (String.IsNullOrEmpty(dbParm.CityID))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.CityID;
}
if (String.IsNullOrEmpty(dbParm.TagID))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.TagID;
}
if (String.IsNullOrEmpty(dbParm.HotelID))
{
parm[4].Value = DBNull.Value;
}
else
{
parm[4].Value = dbParm.HotelID;
}
parm[5].Value = userEntity.LogMessages.Username;
parm[6].Value = getMaxIDfromSeq("T_LM_CONSULT_ROOM_SEQ");
if (String.IsNullOrEmpty(dbParm.SalesID))
{
parm[7].Value = DBNull.Value;
}
else
{
parm[7].Value = dbParm.SalesID;
}
HotelVp.Common.DBUtility.DbManager.ExecuteSql("User", "t_lm_consult_room_user_insert", parm);//t_lm_consult_room_seq.nextval
if (dbParm.ALDelHT.Length > 0)
{
List<CommandInfo> sqlList = new List<CommandInfo>();
string[] alHotel = dbParm.ALDelHT.Split(',');
foreach (string strHotel in alHotel)
{
if (String.IsNullOrEmpty(strHotel.Trim()))
{
continue;
}
CommandInfo InsertHotelExInfo = new CommandInfo();
OracleParameter[] lmHotelExParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("TLCRID",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("CREATEUSER",OracleType.VarChar)
};
lmHotelExParm[0].Value = getMaxIDfromSeq("T_LM_CONSULT_ROOM_HOTEL_EX_SEQ");
lmHotelExParm[1].Value = parm[6].Value;
lmHotelExParm[2].Value = strHotel;
lmHotelExParm[3].Value = userEntity.LogMessages.Username;
InsertHotelExInfo.SqlName = "User";
InsertHotelExInfo.SqlId = "t_lm_consult_room_hotel_insert";
InsertHotelExInfo.Parameters = lmHotelExParm;
sqlList.Add(InsertHotelExInfo);
}
DbManager.ExecuteSqlTran(sqlList);
}
return 1;
}
public static UserEntity GetRegChannelList(UserEntity userEntity)
{
userEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("User", "t_lm_regchnnel_list", true);
return userEntity;
}
public static UserEntity GetPlatFormList(UserEntity userEntity)
{
userEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("User", "t_lm_platForm_list", true);
return userEntity;
}
public static UserEntity CreateUserSelect(UserEntity userEntity)
{
userEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("User", "t_lm_usergroup_select", true);
return userEntity;
}
public static UserEntity CommonSelect(UserEntity userEntity)
{
userEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("City", "t_fc_city", true);
return userEntity;
}
public static UserEntity UserCashPopListSelect(UserEntity paymentEntity)
{
OracleParameter[] parm ={
new OracleParameter("USERID",OracleType.VarChar),
new OracleParameter("PKEY",OracleType.VarChar)
};
UserDBEntity dbParm = (paymentEntity.UserDBEntity.Count > 0) ? paymentEntity.UserDBEntity[0] : new UserDBEntity();
if (String.IsNullOrEmpty(dbParm.UserID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.UserID;
}
if (String.IsNullOrEmpty(dbParm.Pkey))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.Pkey;
}
string strSql = "";
if ("0".Equals(dbParm.SelectType))
{
strSql = "t_lm_user_cash_detail_appl_select";
}
else
{
strSql = "t_lm_user_cash_detail_back_select";
}
DataSet dsResult = new DataSet();
dsResult.Tables.Add(DbManager.Query("User", strSql,true, parm).Tables[0].Copy());
dsResult.Tables[0].TableName = "MASTER";
OracleParameter[] detailParm ={
new OracleParameter("USERID",OracleType.VarChar),
new OracleParameter("PKEY",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.UserID))
{
detailParm[0].Value = DBNull.Value;
}
else
{
detailParm[0].Value = dbParm.UserID;
}
if (String.IsNullOrEmpty(dbParm.Pkey))
{
detailParm[1].Value = DBNull.Value;
}
else
{
detailParm[1].Value = dbParm.Pkey;
}
string strDetailSql = "";
if ("0".Equals(dbParm.SelectType))
{
strDetailSql = "t_lm_user_cash_appl_detail_select";
}
else
{
strDetailSql = "t_lm_user_cash_back_detail_select";
}
dsResult.Tables.Add(DbManager.Query("User", strDetailSql,true, detailParm).Tables[0].Copy());
dsResult.Tables[1].TableName = "DETAIL";
paymentEntity.QueryResult = dsResult;
return paymentEntity;
}
public static UserEntity ReviewSelectCount(UserEntity userEntity)
{
userEntity.LogMessages.MsgType = MessageType.INFO;
userEntity.LogMessages.Content = _nameSpaceClass + "ReviewSelectCount";
LoggerHelper.LogWriter(userEntity.LogMessages);
try
{
return UserSearchDA.ReviewSelectCount(userEntity);
}
catch (Exception ex)
{
userEntity.LogMessages.MsgType = MessageType.ERROR;
userEntity.LogMessages.Content = _nameSpaceClass + "ReviewSelectCount Error: " + ex.Message;
LoggerHelper.LogWriter(userEntity.LogMessages);
throw ex;
}
}
public static int DeleteConsultRoomUser(UserEntity userEntity)
{
if (userEntity.UserDBEntity.Count == 0)
{
return 0;
}
if (userEntity.LogMessages == null)
{
return 0;
}
//if (CheckConsultDel(userEntity) > 0)
//{
// return 2;
//}
UserDBEntity dbParm = (userEntity.UserDBEntity.Count > 0) ? userEntity.UserDBEntity[0] : new UserDBEntity();
OracleParameter[] parm ={
new OracleParameter("CONID",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.UserNo))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.UserNo;
}
HotelVp.Common.DBUtility.DbManager.ExecuteSql("User", "t_lm_consult_room_user_del", parm);
return 1;
}
public static int CheckConsultInsert(UserEntity userEntity)
{
UserDBEntity dbParm = (userEntity.UserDBEntity.Count > 0) ? userEntity.UserDBEntity[0] : new UserDBEntity();
OracleParameter[] parm ={
new OracleParameter("USERID",OracleType.VarChar),
new OracleParameter("RTYPE",OracleType.VarChar),
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("TAGID",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("SALESID",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.UserID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.UserID;
}
if (String.IsNullOrEmpty(dbParm.RType))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.RType;
}
if (String.IsNullOrEmpty(dbParm.CityID))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.CityID;
}
if (String.IsNullOrEmpty(dbParm.TagID))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.TagID;
}
if (String.IsNullOrEmpty(dbParm.HotelID))
{
parm[4].Value = DBNull.Value;
}
else
{
parm[4].Value = dbParm.HotelID;
}
if (String.IsNullOrEmpty(dbParm.SalesID))
{
parm[5].Value = DBNull.Value;
}
else
{
parm[5].Value = dbParm.SalesID;
}
string strSql = "t_lm_consult_room_insert_city_check";
if ("1".Equals(dbParm.RType))
{
strSql = "t_lm_consult_room_insert_tag_check";
}
else if ("2".Equals(dbParm.RType))
{
strSql = "t_lm_consult_room_insert_hotel_check";
}
else if ("3".Equals(dbParm.RType))
{
strSql = "t_lm_consult_room_insert_sales_check";
}
userEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("User", strSql, false, parm);
if (userEntity.QueryResult.Tables.Count > 0 && userEntity.QueryResult.Tables[0].Rows.Count > 0)
{
return 1;
}
return 0;
}
public static UserEntity GetUserIDFromMobile(UserEntity userEntity)
{
OracleParameter[] parm ={
new OracleParameter("MOBILE",OracleType.VarChar)
};
UserDBEntity dbParm = (userEntity.UserDBEntity.Count > 0) ? userEntity.UserDBEntity[0] : new UserDBEntity();
if (String.IsNullOrEmpty(dbParm.LoginMobile))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.LoginMobile;
}
userEntity.QueryResult = DbManager.Query("User", "t_lm_user_select_userid", true, parm);
return userEntity;
}
public static UserEntity PreConsultRoomUserSelect(UserEntity paymentEntity)
{
OracleParameter[] parm ={
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("TAGID",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("SALESID",OracleType.VarChar)
};
UserDBEntity dbParm = (paymentEntity.UserDBEntity.Count > 0) ? paymentEntity.UserDBEntity[0] : new UserDBEntity();
string strSql = "";
if ("0".Equals(dbParm.RType))
{
parm[0].Value = dbParm.CityID;
parm[1].Value = DBNull.Value;
parm[2].Value = DBNull.Value;
parm[3].Value = DBNull.Value;
strSql = "t_lm_consult_room_user_pre_city";
}
else if ("1".Equals(dbParm.RType))
{
parm[0].Value = DBNull.Value;
parm[1].Value = dbParm.TagID;
parm[2].Value = DBNull.Value;
parm[3].Value = DBNull.Value;
strSql = "t_lm_consult_room_user_pre_tag";
}
else if ("2".Equals(dbParm.RType))
{
parm[0].Value = DBNull.Value;
parm[1].Value = DBNull.Value;
parm[2].Value = dbParm.HotelID;
parm[3].Value = DBNull.Value;
strSql = "t_lm_consult_room_user_pre_hotel";
}
else if ("3".Equals(dbParm.RType))
{
parm[0].Value = DBNull.Value;
parm[1].Value = DBNull.Value;
parm[2].Value = DBNull.Value;
parm[3].Value = dbParm.SalesID;
strSql = "t_lm_consult_room_user_pre_sales";
}
paymentEntity.QueryResult = DbManager.Query("User", strSql, true, parm);
return paymentEntity;
}
public static UserEntity getSignByPhoneForCC(UserEntity userEntity)
{
userEntity.LogMessages.MsgType = MessageType.INFO;
userEntity.LogMessages.Content = _nameSpaceClass + "getSignByPhoneForCC";
LoggerHelper.LogWriter(userEntity.LogMessages);
try
{
return UserSearchSA.getSignByPhoneForCC(userEntity);
}
catch (Exception ex)
{
userEntity.LogMessages.MsgType = MessageType.ERROR;
userEntity.LogMessages.Content = _nameSpaceClass + "getSignByPhoneForCC Error: " + ex.Message;
LoggerHelper.LogWriter(userEntity.LogMessages);
throw ex;
}
}