public static PromotionEntity DetailSelect(PromotionEntity promotionEntity)
{
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.VarChar)
};
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
parm[0].Value = dbParm.ID;
promotionEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Promotion", "t_lm_promotionmsg_detail_select", false, parm);
return promotionEntity;
}
public static DataSet GetBalanceRoomList(PromotionEntity promotionEntity)
{
OracleParameter[] parm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("PRICECD",OracleType.VarChar)
};
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
parm[0].Value = dbParm.HotelID;
parm[1].Value = dbParm.RateCode;
return HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_balancerom_priceroomlist", true, parm);;
}
public static bool CheckInsert(PromotionEntity promotionEntity)
{
OracleParameter[] parm ={
new OracleParameter("TITLE",OracleType.VarChar)
};
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
parm[0].Value = dbParm.Title;
DataSet dsResult = HotelVp.Common.DBUtility.DbManager.Query("Promotion", "t_lm_promotion_check_insert", false, parm);
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
return false;
}
else
{
return true;
}
}
public static PromotionEntity GetCityList(PromotionEntity promotionEntity)
{
promotionEntity.LogMessages.MsgType = MessageType.INFO;
promotionEntity.LogMessages.Content = _nameSpaceClass + "GetCityList";
LoggerHelper.LogWriter(promotionEntity.LogMessages);
try
{
return PromotionDA.GetCityList(promotionEntity);
}
catch (Exception ex)
{
promotionEntity.LogMessages.MsgType = MessageType.ERROR;
promotionEntity.LogMessages.Content = _nameSpaceClass + "GetCityList Error: " + ex.Message;
LoggerHelper.LogWriter(promotionEntity.LogMessages);
throw ex;
}
}
private static DataSet CheckErrUpdate(PromotionEntity promotionEntity)
{
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
string SQLString = "";
OracleParameter[] parm ={
new OracleParameter("STARTDTIME",OracleType.VarChar),
new OracleParameter("ENDDTIME",OracleType.VarChar),
new OracleParameter("PROTYPE",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("COMMONLIST",OracleType.VarChar),
new OracleParameter("PRIORITY",OracleType.VarChar),
new OracleParameter("TITLE",OracleType.VarChar),
new OracleParameter("ID",OracleType.VarChar)
};
parm[0].Value = dbParm.StartDTime;
parm[1].Value = dbParm.EndDTime;
parm[2].Value = dbParm.Type;
if ("0".Equals(dbParm.Type))
{
SQLString = "t_lm_promotion_check_err_update_all";
parm[3].Value = DBNull.Value;
parm[4].Value = DBNull.Value;
}
else if ("1".Equals(dbParm.Type))
{
parm[3].Value = DBNull.Value;
if ("1".Equals(dbParm.ChkType))
{
SQLString = "t_lm_promotion_check_err_update_city_chk";
parm[4].Value = DBNull.Value;
}
else
{
SQLString = "t_lm_promotion_check_err_update_city";
parm[4].Value = dbParm.CommonList;
}
}
else if ("2".Equals(dbParm.Type))
{
parm[3].Value = DBNull.Value;
if ("1".Equals(dbParm.ChkType))
{
SQLString = "t_lm_promotion_check_err_update_group_chk";
parm[4].Value = DBNull.Value;
}
else
{
SQLString = "t_lm_promotion_check_err_update_group";
parm[4].Value = dbParm.CommonList;
}
}
else if ("3".Equals(dbParm.Type))
{
parm[3].Value = DBNull.Value;
if ("1".Equals(dbParm.ChkType))
{
SQLString = "t_lm_promotion_check_err_update_hotel_chk";
parm[4].Value = DBNull.Value;
}
else
{
SQLString = "t_lm_promotion_check_err_update_hotel";
parm[4].Value = dbParm.CommonList;
}
}
else if ("4".Equals(dbParm.Type))
{
if ("1".Equals(dbParm.ChkType))
{
SQLString = "t_lm_promotion_check_err_update_room_chk";
parm[3].Value = DBNull.Value;
parm[4].Value = DBNull.Value;
}
else
{
SQLString = "t_lm_promotion_check_err_update_room";
parm[3].Value = dbParm.HotelID;
parm[4].Value = dbParm.CommonList;
}
}
parm[5].Value = dbParm.Priority;
parm[6].Value = dbParm.Title;
parm[7].Value = dbParm.ID;
return HotelVp.Common.DBUtility.DbManager.Query("Promotion", SQLString, false, parm);
}
//private static string AppendString(string param)
//{
// string result = "";
// string[] temp = param.Split(',');
// foreach (string strTemp in temp)
// {
// result = (!String.IsNullOrEmpty(strTemp)) ? result + "'" + strTemp + "'," : result;
// }
// result = (result.Length > 1) ? result.Substring(0, result.Length - 1) : result;
// return result;
//}
//private static bool IsMobileNumber(string str_telephone)
//{
// return System.Text.RegularExpressions.Regex.IsMatch(str_telephone, @"(1[3,4,5,8][0-9])\d{8}$");
//}
public static PromotionEntity Update(PromotionEntity promotionEntity)
{
if (promotionEntity.PromotionDBEntity.Count == 0)
{
promotionEntity.Result = 0;
return promotionEntity;
}
if (promotionEntity.LogMessages == null)
{
promotionEntity.Result = 0;
return promotionEntity;
}
if (!CheckUpdate(promotionEntity))
{
promotionEntity.Result = 2;
return promotionEntity;
}
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
if ("1".Equals(dbParm.Status))
{
DataSet dsErr = CheckErrUpdate(promotionEntity);
if (dsErr.Tables.Count > 0 && dsErr.Tables[0].Rows.Count > 0)
{
promotionEntity.Result = 3;
promotionEntity.ErrorMSG = dsErr.Tables[0].Rows[0]["pro_title"].ToString();
return promotionEntity;
}
}
List<CommandInfo> sqlList = new List<CommandInfo>();
string strImageID = "";
if (!String.IsNullOrEmpty(dbParm.ImagePath))
{
CommandInfo InsertLmImagesInfo = new CommandInfo();
OracleParameter[] lmImagesParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("TITLE",OracleType.VarChar),
new OracleParameter("PATH",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.Imageid))
{
lmImagesParm[0].Value = getMaxIDfromSeq("T_IMAGE_SEQ");
}
else
{
lmImagesParm[0].Value = dbParm.Imageid;
}
lmImagesParm[1].Value = DBNull.Value;
lmImagesParm[2].Value = dbParm.ImagePath;
InsertLmImagesInfo.SqlName = "Promotion";
if (String.IsNullOrEmpty(dbParm.Imageid))
{
InsertLmImagesInfo.SqlId = "t_lm_promotion_t_images_insert";
}
else
{
InsertLmImagesInfo.SqlId = "t_lm_promotion_t_images_update";
}
InsertLmImagesInfo.Parameters = lmImagesParm;
sqlList.Add(InsertLmImagesInfo);
strImageID = lmImagesParm[0].Value.ToString();
}
CommandInfo InsertLmPromMsgInfo = new CommandInfo();
OracleParameter[] lmPromMsgParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("TITLE",OracleType.VarChar),
new OracleParameter("PRIORITY",OracleType.VarChar),
new OracleParameter("STARTDTIME",OracleType.VarChar),
new OracleParameter("ENDDTIME",OracleType.VarChar),
new OracleParameter("CONTENT",OracleType.VarChar),
new OracleParameter("IMAGEID",OracleType.VarChar),
new OracleParameter("STATUS",OracleType.VarChar),
new OracleParameter("OPERATEUSER",OracleType.VarChar),
new OracleParameter("RATECODE",OracleType.VarChar),
new OracleParameter("PROMETHODID",OracleType.VarChar)
};
lmPromMsgParm[0].Value = dbParm.ID;
lmPromMsgParm[1].Value = dbParm.Title;
lmPromMsgParm[2].Value = dbParm.Priority;
lmPromMsgParm[3].Value = dbParm.StartDTime;
lmPromMsgParm[4].Value = dbParm.EndDTime;
lmPromMsgParm[5].Value = dbParm.Content;
if (String.IsNullOrEmpty(strImageID))
{
lmPromMsgParm[6].Value = DBNull.Value;
}
else
{
lmPromMsgParm[6].Value = strImageID;
}
lmPromMsgParm[7].Value = dbParm.Status;
lmPromMsgParm[8].Value = (promotionEntity.LogMessages != null) ? promotionEntity.LogMessages.Userid : "";
lmPromMsgParm[9].Value = String.IsNullOrEmpty(dbParm.RateCode) ? "" : dbParm.RateCode;
lmPromMsgParm[10].Value = dbParm.Promethodid;
InsertLmPromMsgInfo.SqlName = "Promotion";
InsertLmPromMsgInfo.SqlId = "t_lm_promotionmsg_update";
InsertLmPromMsgInfo.Parameters = lmPromMsgParm;
sqlList.Add(InsertLmPromMsgInfo);
CommandInfo UpdateLmPromMsgDetailDelInfo = new CommandInfo();
OracleParameter[] lmPromMsgDetailDelParm ={
new OracleParameter("ID",OracleType.Int32)
};
lmPromMsgDetailDelParm[0].Value = dbParm.ID;
UpdateLmPromMsgDetailDelInfo.SqlName = "Promotion";
UpdateLmPromMsgDetailDelInfo.SqlId = "t_lm_promotionmsg_detail_update";
UpdateLmPromMsgDetailDelInfo.Parameters = lmPromMsgDetailDelParm;
sqlList.Add(UpdateLmPromMsgDetailDelInfo);
string PromotionCommonKey = String.IsNullOrEmpty(ConfigurationManager.AppSettings["PromotionCommonKey"]) ? "000000" : ConfigurationManager.AppSettings["PromotionCommonKey"].ToString();
CommandInfo InsertLmPromMsgDetailInfo = new CommandInfo();
OracleParameter[] lmPromMsgDetailParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("PROTYPE",OracleType.VarChar),
new OracleParameter("COMMONLIST",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("LINKURL",OracleType.VarChar)
};
lmPromMsgDetailParm[0].Value = lmPromMsgParm[0].Value;
lmPromMsgDetailParm[1].Value = dbParm.Type;
InsertLmPromMsgDetailInfo.SqlName = "Promotion";
if ("0".Equals(dbParm.Type))
{
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_all_insert";
lmPromMsgDetailParm[2].Value = DBNull.Value;
lmPromMsgDetailParm[3].Value = DBNull.Value;
}
else if ("1".Equals(dbParm.Type))
{
lmPromMsgDetailParm[2].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromMsgDetailParm[3].Value = DBNull.Value;
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_city_insert";
}
else if ("2".Equals(dbParm.Type))
{
lmPromMsgDetailParm[2].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromMsgDetailParm[3].Value = DBNull.Value;
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_group_insert";
}
else if ("3".Equals(dbParm.Type))
{
lmPromMsgDetailParm[2].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromMsgDetailParm[3].Value = DBNull.Value;
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_hotel_insert";
}
else if ("4".Equals(dbParm.Type))
{
lmPromMsgDetailParm[2].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromMsgDetailParm[3].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey : dbParm.HotelID;
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_room_insert";
}
if (String.IsNullOrEmpty(dbParm.LinkUrl))
{
lmPromMsgDetailParm[4].Value = DBNull.Value;
}
else
{
lmPromMsgDetailParm[4].Value = dbParm.LinkUrl;
}
InsertLmPromMsgDetailInfo.Parameters = lmPromMsgDetailParm;
sqlList.Add(InsertLmPromMsgDetailInfo);
if (dbParm.UserGroupList.Length > 0)
{
CommandInfo InsertLmPromMsgUserGroupInfo = new CommandInfo();
OracleParameter[] lmPromMsgDetailUserGroupParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("PROTYPE",OracleType.VarChar),
new OracleParameter("USERGROUPLIST",OracleType.VarChar),
new OracleParameter("LINKURL",OracleType.VarChar)
};
lmPromMsgDetailUserGroupParm[0].Value = lmPromMsgParm[0].Value;
lmPromMsgDetailUserGroupParm[1].Value = "5";
lmPromMsgDetailUserGroupParm[2].Value = dbParm.UserGroupList;
if (String.IsNullOrEmpty(dbParm.LinkUrl))
{
lmPromMsgDetailUserGroupParm[3].Value = DBNull.Value;
}
else
{
lmPromMsgDetailUserGroupParm[3].Value = dbParm.LinkUrl;
}
InsertLmPromMsgUserGroupInfo.SqlName = "Promotion";
InsertLmPromMsgUserGroupInfo.SqlId = "t_lm_promotionmsg_usergroup_insert";
InsertLmPromMsgUserGroupInfo.Parameters = lmPromMsgDetailUserGroupParm;
sqlList.Add(InsertLmPromMsgUserGroupInfo);
}
DbManager.ExecuteSqlTran(sqlList);
SetPromotionData(promotionEntity, strImageID);
promotionEntity.Result = 1;
return promotionEntity;
}
public static int SetPromotionData(PromotionEntity promotionEntity, string strImageID)
{
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
List<CommandInfo> sqlList = new List<CommandInfo>();
CommandInfo UpdateLmPromInfo = new CommandInfo();
OracleParameter[] lmPromParm ={
new OracleParameter("ID",OracleType.VarChar)
};
lmPromParm[0].Value = dbParm.ID;
UpdateLmPromInfo.SqlName = "Promotion";
UpdateLmPromInfo.SqlId = "t_lm_promotion_update";
UpdateLmPromInfo.Parameters = lmPromParm;
sqlList.Add(UpdateLmPromInfo);
if ("1".Equals(dbParm.Status))
{
string PromotionCommonKey = String.IsNullOrEmpty(ConfigurationManager.AppSettings["PromotionCommonKey"]) ? "000000" : ConfigurationManager.AppSettings["PromotionCommonKey"].ToString();
CommandInfo InsertLmPromInfo = new CommandInfo();
OracleParameter[] lmPromInserParm ={
new OracleParameter("ID",OracleType.VarChar),
new OracleParameter("TITLE",OracleType.VarChar),
new OracleParameter("PRIORITY",OracleType.VarChar),
new OracleParameter("STARTDTIME",OracleType.VarChar),
new OracleParameter("ENDDTIME",OracleType.VarChar),
new OracleParameter("CONTENT",OracleType.VarChar),
new OracleParameter("IMAGEID",OracleType.VarChar),
new OracleParameter("STATUS",OracleType.VarChar),
new OracleParameter("OPERATEUSER",OracleType.VarChar),
new OracleParameter("RATECODE",OracleType.VarChar),
new OracleParameter("PROTYPE",OracleType.VarChar),
new OracleParameter("COMMONLIST",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("USERGROUPLIST",OracleType.VarChar),
new OracleParameter("PROMETHODID",OracleType.VarChar),
new OracleParameter("LINKURL",OracleType.VarChar)
};
lmPromInserParm[0].Value = dbParm.ID;
lmPromInserParm[1].Value = dbParm.Title;
lmPromInserParm[2].Value = dbParm.Priority;
lmPromInserParm[3].Value = dbParm.StartDTime;
lmPromInserParm[4].Value = dbParm.EndDTime;
lmPromInserParm[5].Value = dbParm.Content;
lmPromInserParm[6].Value = strImageID;
lmPromInserParm[7].Value = dbParm.Status;
lmPromInserParm[8].Value = (promotionEntity.LogMessages != null) ? promotionEntity.LogMessages.Userid : "";
lmPromInserParm[9].Value = String.IsNullOrEmpty(dbParm.RateCode) ? "" : dbParm.RateCode;
lmPromInserParm[10].Value = dbParm.Type;
if ("0".Equals(dbParm.Type))
{
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_all_insert";
lmPromInserParm[11].Value = DBNull.Value;
lmPromInserParm[12].Value = DBNull.Value;
lmPromInserParm[14].Value = dbParm.Promethodid;
}
else if ("1".Equals(dbParm.Type))
{
lmPromInserParm[11].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromInserParm[12].Value = DBNull.Value;
lmPromInserParm[14].Value = dbParm.Promethodid;
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_city_insert";
}
else if ("2".Equals(dbParm.Type))
{
lmPromInserParm[11].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromInserParm[12].Value = DBNull.Value;
lmPromInserParm[14].Value = dbParm.Promethodid;
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_group_insert";
}
else if ("3".Equals(dbParm.Type))
{
lmPromInserParm[11].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromInserParm[12].Value = DBNull.Value;
lmPromInserParm[14].Value = dbParm.Promethodid;
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_hotel_insert";
}
else if ("4".Equals(dbParm.Type))
{
lmPromInserParm[11].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromInserParm[12].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey : dbParm.HotelID;
lmPromInserParm[14].Value = dbParm.Promethodid;
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_room_insert";
}
if (dbParm.UserGroupList.Length > 0)
{
lmPromInserParm[13].Value = dbParm.UserGroupList.Substring(0, dbParm.UserGroupList.Length - 1);
}
else
{
lmPromInserParm[13].Value = DBNull.Value;
}
if (String.IsNullOrEmpty(dbParm.LinkUrl))
{
lmPromInserParm[15].Value = DBNull.Value;
}
else
{
lmPromInserParm[15].Value = dbParm.LinkUrl;
}
InsertLmPromInfo.SqlName = "Promotion";
InsertLmPromInfo.Parameters = lmPromInserParm;
sqlList.Add(InsertLmPromInfo);
}
DbManager.ExecuteSqlTran(sqlList);
return 1;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
messageContent.InnerHtml = "";
bool bflag = true;
string errMsg = GetLocalResourceObject("Error").ToString();
if (String.IsNullOrEmpty(txtPromotionTitle.Value.Trim()))
{
errMsg = errMsg +"<br/>"+ GetLocalResourceObject("Error1").ToString();
bflag=false;
}
if (StringUtility.Text_Length(txtPromotionTitle.Value.ToString().Trim()) > 45)
{
errMsg = errMsg + "<br/>" + GetLocalResourceObject("Error8").ToString();
bflag = false;
}
if (String.IsNullOrEmpty(dpKeepStart.Value.Trim()) || String.IsNullOrEmpty(dpKeepEnd.Value.Trim()))
{
errMsg = errMsg + "<br/>" + GetLocalResourceObject("Error2").ToString();
bflag = false;
}
if (!"0".Equals(hidCommonType.Value) && !"1".Equals(hidChkCommonType.Value) && String.IsNullOrEmpty(hidCommonList.Value.Trim()))
{
errMsg = errMsg + "<br/>" + GetLocalResourceObject("Error3").ToString();
bflag = false;
}
if (!chkAllUserGroup.Checked && String.IsNullOrEmpty(hidUserGroupList.Value.Trim()))
{
errMsg = errMsg + "<br/>" + GetLocalResourceObject("Error4").ToString();
bflag = false;
}
if (String.IsNullOrEmpty(txtPromDescZh.Text.Trim()))
{
errMsg = errMsg + "<br/>" + GetLocalResourceObject("Error5").ToString();
bflag = false;
}
if (StringUtility.Text_Length(txtPromDescZh.Text.Trim()) > 540)
{
errMsg = errMsg + "<br/>" + GetLocalResourceObject("Error11").ToString();
bflag = false;
}
if (StringUtility.Text_Length(txtImgFilePath.Value.ToString().Trim()) > 1000)
{
errMsg = errMsg + "<br/>" + GetLocalResourceObject("Error10").ToString();
bflag = false;
}
if ("0".Equals(hidCommonType.Value) && StringUtility.Text_Length(txtLinkUrl.Text.Trim()) > 500)
{
errMsg = errMsg + "<br/>" + GetLocalResourceObject("Error12").ToString();
bflag = false;
}
if (!bflag)
{
messageContent.InnerHtml = errMsg;
UpdatePanel6.Update();
return;
}
_promotionEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_promotionEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_promotionEntity.LogMessages.Username = UserSession.Current.UserDspName;
_promotionEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_promotionEntity.PromotionDBEntity = new List<PromotionDBEntity>();
PromotionDBEntity promotionEntity = new PromotionDBEntity();
promotionEntity.Title = txtPromotionTitle.Value.ToString().Trim();
promotionEntity.Priority = ddpPriorityList.SelectedValue;
promotionEntity.StartDTime = dpKeepStart.Value;
promotionEntity.EndDTime = dpKeepEnd.Value;
promotionEntity.Type = hidCommonType.Value;
promotionEntity.ChkType = hidChkCommonType.Value;
promotionEntity.CommonList = hidCommonList.Value;
promotionEntity.HotelID = (hidHotelID.Value.Length > 0) ? hidHotelID.Value.Substring((hidHotelID.Value.IndexOf('[') + 1), (hidHotelID.Value.IndexOf(']') - 1)) : "";
promotionEntity.UserGroupList = hidUserGroupList.Value;
promotionEntity.Content = txtPromDescZh.Text.ToString().Trim();
// promotionEntity.Imageid = "1";//image_src 本地路径||服务器路径||IMAGEID
promotionEntity.Imageid = txtImgFilePath.Value.Trim();
promotionEntity.RateCode = ddpPriceType.SelectedValue;
promotionEntity.Promethodid = ddpPromotionType.SelectedValue;
promotionEntity.LinkUrl = ("0".Equals(hidCommonType.Value)) ? txtLinkUrl.Text.Trim() : "";
_promotionEntity.PromotionDBEntity.Add(promotionEntity);
_promotionEntity = PromotionBP.Insert(_promotionEntity);
int iResult =_promotionEntity.Result;
_commonEntity.LogMessages = _promotionEntity.LogMessages;
_commonEntity.CommonDBEntity = new List<CommonDBEntity>();
CommonDBEntity commonDBEntity = new CommonDBEntity();
commonDBEntity.Event_Type = "新建促销信息-添加";
commonDBEntity.Event_ID = txtPromotionTitle.Value.ToString().Trim();
string conTent = GetLocalResourceObject("EventInsertMessage").ToString();
conTent = string.Format(conTent, txtPromotionTitle.Value.ToString().Trim(), ddpPriorityList.SelectedValue, dpKeepStart.Value, dpKeepEnd.Value, hidCommonType.Value,hidHotelID.Value + hidCommonList.Value, hidUserGroupList.Value, txtPromDescZh.Text.ToString().Trim(), "1");//image_src 本地路径||服务器路径||IMAGEID
commonDBEntity.Event_Content = conTent;
if (iResult == 1)
{
commonDBEntity.Event_Result = GetLocalResourceObject("InsertSuccess").ToString();
messageContent.InnerHtml = GetLocalResourceObject("InsertSuccess").ToString();
hidCommonList.Value = "";
hidUserGroupList.Value = "";
}
else if (iResult == 2)
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error6").ToString();
messageContent.InnerHtml = GetLocalResourceObject("Error6").ToString();
}
else if (iResult == 3)
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error9").ToString();
messageContent.InnerHtml = string.Format(GetLocalResourceObject("Error9").ToString(), _promotionEntity.ErrorMSG);
}
else
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error7").ToString();
messageContent.InnerHtml = GetLocalResourceObject("Error7").ToString();
}
_commonEntity.CommonDBEntity.Add(commonDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
UpdatePanel6.Update();
}
//protected void ddpPriceType_SelectedIndexChanged(object sender, EventArgs e)
//{
// if (ddpPriceType.SelectedValue == "LMBAR")
// {
// dvlm2.Style.Add("display","none");
// dvlm.Style.Add("display", "");
// }
// else
// {
// dvlm2.Style.Add("display","");
// dvlm.Style.Add("display", "none");
// }
// //UpdatePanel4.Update();
//}
protected void ddpPriceType_SelectedIndexChanged(object sender, EventArgs e)
{
if ("LMBAR".Equals(ddpPriceType.SelectedValue))
{
ddpGuaid.SelectedValue = "PP";
ddpCxlid.SelectedValue = "PT100";
}
else
{
ddpGuaid.SelectedValue = "RH04";
ddpCxlid.SelectedValue = "NP24";
}
PromotionEntity _promotionEntity = new PromotionEntity();
_promotionEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_promotionEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_promotionEntity.LogMessages.Username = UserSession.Current.UserDspName;
_promotionEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_promotionEntity.PromotionDBEntity = new List<PromotionDBEntity>();
PromotionDBEntity promotionEntity = new PromotionDBEntity();
string strHotel = wctHotel.AutoResult.ToString();
if (String.IsNullOrEmpty(strHotel) || !strHotel.Contains("[") || !strHotel.Contains("]"))
{
return;
}
promotionEntity.HotelID = strHotel.Substring((strHotel.IndexOf('[') + 1), (strHotel.IndexOf(']') - 1)); ;
promotionEntity.RateCode = ddpPriceType.SelectedValue;
_promotionEntity.PromotionDBEntity.Add(promotionEntity);
DataSet dsResult = PromotionBP.GetHotelRoomListAll(_promotionEntity);
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
ddpHotelRoomList.DataTextField = "ROOMNM";
ddpHotelRoomList.DataValueField = "ROOMCODE";
ddpHotelRoomList.DataSource = dsResult;
ddpHotelRoomList.DataBind();
//UpdatePanel2.Update();
}
}
public static DataSet GetHotelRoomListAll(PromotionEntity promotionEntity)
{
//OracleParameter[] parm ={
// new OracleParameter("HOTELID",OracleType.VarChar)
// };
//PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
//if (String.IsNullOrEmpty(dbParm.HotelID))
//{
// parm[0].Value = DBNull.Value;
//}
//else
//{
// parm[0].Value = dbParm.HotelID;
//}
//return HotelVp.Common.DBUtility.DbManager.Query("Promotion", "t_lm_hotelroom_list", false, parm);
OracleParameter[] parm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("PRICECD",OracleType.VarChar)
};
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
if (String.IsNullOrEmpty(dbParm.HotelID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.HotelID;
}
if (String.IsNullOrEmpty(dbParm.RateCode))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.RateCode;
}
return HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_balancerom_priceroomlist_all", false, parm);
}
public static PromotionEntity Update(PromotionEntity promotionEntity)
{
promotionEntity.LogMessages.MsgType = MessageType.INFO;
promotionEntity.LogMessages.Content = _nameSpaceClass + "Update";
LoggerHelper.LogWriter(promotionEntity.LogMessages);
try
{
promotionEntity = PromotionDA.Update(promotionEntity);
if (promotionEntity.Result == 1)
{
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
if ("3".Equals(dbParm.Type))
{
HotelInfoSA.RefushHotelList((("1".Equals(dbParm.ChkType)) ? "ALL" : dbParm.CommonList.TrimEnd(',')));
}
}
return promotionEntity;
}
catch (Exception ex)
{
promotionEntity.LogMessages.MsgType = MessageType.ERROR;
promotionEntity.LogMessages.Content = _nameSpaceClass + "Update Error: " + ex.Message;
LoggerHelper.LogWriter(promotionEntity.LogMessages);
throw ex;
}
}
public static DataSet GetHotelRoomListAll(PromotionEntity promotionEntity)
{
promotionEntity.LogMessages.MsgType = MessageType.INFO;
promotionEntity.LogMessages.Content = _nameSpaceClass + "GetHotelRoomListAll";
LoggerHelper.LogWriter(promotionEntity.LogMessages);
try
{
return PromotionDA.GetHotelRoomListAll(promotionEntity);
}
catch (Exception ex)
{
promotionEntity.LogMessages.MsgType = MessageType.ERROR;
promotionEntity.LogMessages.Content = _nameSpaceClass + "GetHotelRoomListAll Error: " + ex.Message;
LoggerHelper.LogWriter(promotionEntity.LogMessages);
throw ex;
}
}
protected void btnSelectHotel_Click(object sender, EventArgs e)
{
messageContent.InnerHtml = "";
if (String.IsNullOrEmpty(wctHotel.AutoResult) || String.IsNullOrEmpty(hidHotelID.Value))
{
messageContent.InnerHtml = GetLocalResourceObject("Error1").ToString();
//UpdatePanel6.Update();
return;
}
if (!wctHotel.AutoResult.Equals(hidHotelID.Value))
{
messageContent.InnerHtml = GetLocalResourceObject("Error10").ToString();
//UpdatePanel6.Update();
return;
}
PromotionEntity _promotionEntity = new PromotionEntity();
_promotionEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_promotionEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_promotionEntity.LogMessages.Username = UserSession.Current.UserDspName;
_promotionEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_promotionEntity.PromotionDBEntity = new List<PromotionDBEntity>();
PromotionDBEntity promotionEntity = new PromotionDBEntity();
string strHotel = wctHotel.AutoResult.ToString();
promotionEntity.HotelID = strHotel.Substring((strHotel.IndexOf('[') + 1), (strHotel.IndexOf(']') - 1)); ;
_promotionEntity.PromotionDBEntity.Add(promotionEntity);
DataSet dsResult = PromotionBP.GetHotelRoomList(_promotionEntity);
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
chkHotelRoomList.DataTextField = "HOTELROOMNM";
chkHotelRoomList.DataValueField = "HOTELROOMCODE";
chkHotelRoomList.DataSource = dsResult;
chkHotelRoomList.DataBind();
//UpdatePanel2.Update();
}
else
{
chkHotelRoomList.DataSource = dsResult;
chkHotelRoomList.DataBind();
//UpdatePanel2.Update();
messageContent.InnerHtml = GetLocalResourceObject("Error9").ToString();
}
//UpdatePanel6.Update();
}
public static PromotionEntity GetCityList(PromotionEntity promotionEntity)
{
promotionEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Promotion", "t_fc_city", false);
return promotionEntity;
}
public static PromotionEntity PromotioningSelect(PromotionEntity promotionEntity)
{
promotionEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Promotion", "t_lm_promotionmsg_ing", false);
return promotionEntity;
}
public static PromotionEntity GetHotelGroupList(PromotionEntity promotionEntity)
{
promotionEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Promotion", "t_lm_hotelgroup_list", false);
return promotionEntity;
}
public static PromotionEntity PromotionMsgSelect(PromotionEntity promotionEntity)
{
if (promotionEntity.PromotionDBEntity.Count == 0)
{
return promotionEntity;
}
if (promotionEntity.LogMessages == null)
{
return promotionEntity;
}
OracleParameter[] parm ={
new OracleParameter("ProTitle",OracleType.VarChar),
new OracleParameter("StartBeginDTime",OracleType.VarChar),
new OracleParameter("StartEndDTime",OracleType.VarChar),
new OracleParameter("EndBeginDTime",OracleType.VarChar),
new OracleParameter("EndEndDTime",OracleType.VarChar)
};
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
if (String.IsNullOrEmpty(dbParm.Title))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.Title;
}
if (String.IsNullOrEmpty(dbParm.StartBeginDTime))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.StartBeginDTime;
}
if (String.IsNullOrEmpty(dbParm.StartEndDTime))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.StartEndDTime;
}
if (String.IsNullOrEmpty(dbParm.EndBeginDTime))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.EndBeginDTime;
}
if (String.IsNullOrEmpty(dbParm.EndEndDTime))
{
parm[4].Value = DBNull.Value;
}
else
{
parm[4].Value = dbParm.EndEndDTime;
}
promotionEntity.QueryResult = DbManager.Query("Promotion", "t_lm_promotionmsg_review_select", false, parm);
return promotionEntity;
}
private void GetRoomList()
{
PromotionEntity _promotionEntity = new PromotionEntity();
_promotionEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_promotionEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_promotionEntity.LogMessages.Username = UserSession.Current.UserDspName;
_promotionEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_promotionEntity.PromotionDBEntity = new List<PromotionDBEntity>();
PromotionDBEntity promotionEntity = new PromotionDBEntity();
string strHotel = wctHotel.AutoResult.ToString();
if (String.IsNullOrEmpty(strHotel) || !strHotel.Contains("[") || !strHotel.Contains("]"))
{
SetDdpEmptyList();
messageContent.InnerHtml = GetLocalResourceObject("Error9").ToString();
return;
}
promotionEntity.HotelID = strHotel.Substring((strHotel.IndexOf('[') + 1), (strHotel.IndexOf(']') - 1)); ;
promotionEntity.RateCode = ddpPriceType.SelectedValue;
_promotionEntity.PromotionDBEntity.Add(promotionEntity);
DataSet dsResult = PromotionBP.GetHotelRoomListAll(_promotionEntity);
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
ddpHotelRoomList.DataTextField = "ROOMNM";
ddpHotelRoomList.DataValueField = "ROOMCODE";
ddpHotelRoomList.DataSource = dsResult;
ddpHotelRoomList.DataBind();
//UpdatePanel2.Update();
}
else
{
SetDdpEmptyList();
//UpdatePanel2.Update();
messageContent.InnerHtml = GetLocalResourceObject("Error9").ToString();
}
}
protected void btnSelectHotel_Click(object sender, EventArgs e)
{
messageContent.InnerHtml = "";
if (String.IsNullOrEmpty(wctHotel.AutoResult) || String.IsNullOrEmpty(hidHotelID.Value))
{
messageContent.InnerHtml = GetLocalResourceObject("Error1").ToString();
//UpdatePanel6.Update();
return;
}
if (String.IsNullOrEmpty(dpKeepStart.Value.Trim()) || String.IsNullOrEmpty(dpKeepEnd.Value.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("Error2").ToString();
//UpdatePanel6.Update();
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "SetHotelControlVal('" + hidHotelID.Value + "');", true);
return;
}
hidKeepStart.Value = dpKeepStart.Value.Trim();
hidKeepEnd.Value = dpKeepEnd.Value.Trim();
hidHotelID.Value = wctHotel.AutoResult;
PromotionEntity _promotionEntity = new PromotionEntity();
_promotionEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_promotionEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_promotionEntity.LogMessages.Username = UserSession.Current.UserDspName;
_promotionEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_promotionEntity.PromotionDBEntity = new List<PromotionDBEntity>();
PromotionDBEntity promotionEntity = new PromotionDBEntity();
string strHotel = wctHotel.AutoResult.ToString();
promotionEntity.HotelID = strHotel.Substring((strHotel.IndexOf('[') + 1), (strHotel.IndexOf(']') - 1)); ;
_promotionEntity.PromotionDBEntity.Add(promotionEntity);
DataSet dsResult = PromotionBP.GetHotelRoomList(_promotionEntity);
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
chkHotelRoomList.DataTextField = "HOTELROOMNM";
chkHotelRoomList.DataValueField = "HOTELROOMCODE";
chkHotelRoomList.DataSource = dsResult;
chkHotelRoomList.DataBind();
//UpdatePanel2.Update();
}
else
{
chkHotelRoomList.DataSource = dsResult;
chkHotelRoomList.DataBind();
//UpdatePanel2.Update();
messageContent.InnerHtml = GetLocalResourceObject("Error9").ToString();
}
dvRoomList.Style.Add("display", "");
dvAutoComplete.Style.Add("display", "none");
lbHotel.Text = wctHotel.AutoResult;
dvlbHotel.Style.Add("display", "");
dvSelectHotel.Style.Add("display", "none");
lbStart.Text = dpKeepStart.Value.Trim();
lbEnd.Text = dpKeepEnd.Value.Trim();
dvLbTime.Style.Add("display", "");
dvKeepTime.Style.Add("display", "none");
//UpdatePanel1.Update();
//UpdatePanel4.Update();
//UpdatePanel8.Update();
//UpdatePanel6.Update();
//this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DtControlStyle(true);", true);
BindHistoryListGrid();
}
