public ActionResult roomlistindex(string id)
{
int hid = HCRequest.getInt("hid");
DateTime indate = HCRequest.getDate("indate");
DateTime outdate = HCRequest.getDate("outdate");
string hotelweixinid = HCRequest.GetString("hotelweixinid");
double graderate = WeiXinPublic.ConvertHelper.ToDouble(HCRequest.GetClearStr("graderate"));
double reduce = WeiXinPublic.ConvertHelper.ToDouble(HCRequest.GetString("reduce"));
int couponType = WeiXinPublic.ConvertHelper.ToInt(HCRequest.GetString("coupontype"));
string gradename = HCRequest.GetString("gradename");
string membershow = HCRequest.GetString("membershow");
string dingfangmember = HCRequest.GetString("dingfangmember");
int ismember = WeiXinPublic.ConvertHelper.ToInt(HCRequest.GetString("ismember"));;
var memberCardCustomList = new List <Models.Home.MemberCardCustom>();
var memberinfo = new Repository.MemberInfo();
if (membershow == "1")
{
memberinfo = hotel3g.Repository.MemberHelper.GetMemberInfo(hotelweixinid);
if (memberinfo == null)
{
memberinfo = new Repository.MemberInfo();
}
}
if (ismember == 0 || membershow == "1")
{
int customcount = 0;
DataTable db_CardCustom = MemberCardCustom.GetMemberCardCustomList(hotelweixinid, out customcount, 1, 50, "", "");
memberCardCustomList = DataTableToEntity.GetEntities <Models.Home.MemberCardCustom>(db_CardCustom).ToList();
}
ViewData["customlist"] = memberCardCustomList;
ViewData["memberinfo"] = memberinfo;
ViewData["membershow"] = membershow;
string ratejson = ActionController.getratejson(hid, indate, outdate, hotelweixinid, graderate, reduce, couponType);
ViewData["ratejson"] = ratejson;
ViewData["graderate"] = graderate;
ViewData["reduce"] = reduce;
ViewData["coupontype"] = couponType;
ViewData["gradename"] = gradename;
ViewData["dingfangmember"] = dingfangmember;
ViewData["ismember"] = ismember;
return(View());
}
public static int UpdateModel(MemberCardCustom model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MemberCardCustom set ");
strSql.Append(" Reduce = @Reduce , ");
strSql.Append(" JiFen = @JiFen , ");
strSql.Append(" CardLevel = @CardLevel , ");
strSql.Append(" LastUpdateTime = @LastUpdateTime , ");
strSql.Append(" CardName = @CardName , ");
strSql.Append(" IncreaseType = @IncreaseType , ");
strSql.Append(" Rooms = @Rooms , ");
strSql.Append(" BuyMoney = @BuyMoney , ");
strSql.Append(" CouponType = @CouponType , ");
strSql.Append(" Discount = @Discount ");
strSql.Append(" where Id=@Id and WeixinId=@WeixinId");
int row = HotelCloud.SqlServer.SQLHelper.Run_SQL(strSql.ToString(), HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
{ "Reduce", new HotelCloud.SqlServer.DBParam {
ParamValue = model.Reduce.ToString()
} },
{ "JiFen", new HotelCloud.SqlServer.DBParam {
ParamValue = model.JiFen.ToString()
} },
{ "CardLevel", new HotelCloud.SqlServer.DBParam {
ParamValue = model.CardLevel.ToString()
} },
{ "LastUpdateTime", new HotelCloud.SqlServer.DBParam {
ParamValue = model.LastUpdateTime.ToString()
} },
{ "CardName", new HotelCloud.SqlServer.DBParam {
ParamValue = model.CardName.ToString()
} },
{ "WeixinId", new HotelCloud.SqlServer.DBParam {
ParamValue = model.WeixinId.ToString()
} },
{ "IncreaseType", new HotelCloud.SqlServer.DBParam {
ParamValue = model.IncreaseType.ToString()
} },
{ "Rooms", new HotelCloud.SqlServer.DBParam {
ParamValue = model.Rooms.ToString()
} },
{ "BuyMoney", new HotelCloud.SqlServer.DBParam {
ParamValue = model.BuyMoney.ToString()
} },
{ "CouponType", new HotelCloud.SqlServer.DBParam {
ParamValue = model.CouponType.ToString()
} },
{ "Discount", new HotelCloud.SqlServer.DBParam {
ParamValue = model.Discount.ToString()
} },
{ "Id", new HotelCloud.SqlServer.DBParam {
ParamValue = model.Id.ToString()
} },
});
return(row);
}
public ActionResult Index(string id)
{
string key = HotelCloud.Common.HCRequest.GetString("key");
string hotelWeixinid = string.Empty;
string userWeixinid = string.Empty;
if (!string.IsNullOrEmpty(key) && key.Contains("@"))
{
List <string> list = key.Split('@').ToList();
hotelWeixinid = list[0];
userWeixinid = list[1];
hotel3g.Models.Cookies.SetCookies("userWeixinNO", userWeixinid, 30, hotelWeixinid);
ViewData["hotelWeixinid"] = hotelWeixinid;
ViewData["userWeixinid"] = userWeixinid;
ViewData["generatesign"] = WeiXin.Common.ValidateSignProduct.GenerateSign(hotelWeixinid, userWeixinid);
}
int hid = Convert.ToInt32(id);
ViewData["hid"] = hid;
string firstimgurl = null;
string MemberCardRuleJson = ActionController.getMemberCardIntegralRule(userWeixinid, hotelWeixinid);
ViewData["MemberCardRuleJson"] = MemberCardRuleJson;
Hashtable MemberCardRuleJsonobj = Newtonsoft.Json.JsonConvert.DeserializeObject <Hashtable>(MemberCardRuleJson);
Hashtable ruletable = Newtonsoft.Json.JsonConvert.DeserializeObject <Hashtable>(MemberCardRuleJsonobj["rule"].ToString());
double graderate = WeiXinPublic.ConvertHelper.ToDouble(ruletable["GradeRate"]);
ViewData["graderate"] = graderate;
double reduce = WeiXinPublic.ConvertHelper.ToDouble(ruletable["Reduce"]);
ViewData["reduce"] = reduce;
int couponType = WeiXinPublic.ConvertHelper.ToInt(ruletable["CouponType"]);
ViewData["couponType"] = couponType;
string gradeName = WeiXinPublic.ConvertHelper.ToString(ruletable["GradeName"]);
ViewData["gradeName"] = gradeName;
DateTime indate = DateTime.Now.Date;
DateTime outdate = DateTime.Now.AddDays(1).Date;
if (!string.IsNullOrEmpty(HCRequest.GetString("indate")) && !string.IsNullOrEmpty(HCRequest.GetString("outdate")))
{
if (HCRequest.getDate("outdate").Date <= DateTime.Now.Date.AddMonths(2))
{
indate = HCRequest.getDate("indate");
outdate = HCRequest.getDate("outdate");
}
}
ViewData["indate"] = indate;
ViewData["outdate"] = outdate;
ViewData["ratejson"] = ActionController.getratejson(hid, indate, outdate, hotelWeixinid, graderate, out firstimgurl, reduce, couponType);
Models.Hotel hotel = ActionController.gethotelinfo(hid, hotelWeixinid);
ViewData["hotel"] = hotel;
ViewData["firstimgurl"] = firstimgurl;
//string commentopen = string.Empty;
//string membershow = string.Empty;
//string dingfangmember = string.Empty;
//string sql = "select comment,showmemberprice,dingfang_MemberOnly from WeiXinNO with (nolock) where weixinId=@weixinId ";
//DataTable db_open = SQLHelper.Get_DataTable(sql, SQLHelper.GetCon(), new Dictionary<string, DBParam>()
// {{"weixinId",new DBParam(){ParamValue=hotelWeixinid}},
// });
//if (db_open.Rows.Count > 0)
//{
// commentopen = db_open.Rows[0]["comment"].ToString();
// membershow = db_open.Rows[0]["showmemberprice"].ToString();
// dingfangmember = db_open.Rows[0]["dingfang_MemberOnly"].ToString();
//}
//ViewData["commentopen"] = commentopen;
//ViewData["membershow"] = membershow;
//ViewData["dingfangmember"] = dingfangmember;
ModuleAuthorityResponse ModuleAuthority = hotel3g.Models.DAL.AuthorityHelper.ModuleAuthority(hotelWeixinid);
ViewData["commentopen"] = ModuleAuthority.comment;
ViewData["membershow"] = ModuleAuthority.membership_price;
ViewData["dingfangmember"] = ModuleAuthority.membership_room;
//控制弹窗
ViewData["memberbasics"] = ModuleAuthority.module_memberbasics;
BaseHotelCommentInfo baseHotelCommentInfo = new BaseHotelCommentInfo();
if (ModuleAuthority.comment == 1)
{
Comment comment = new Comment();
baseHotelCommentInfo = comment.GetBaseInfo(hid);
}
ViewData["baseHotelCommentInfo"] = baseHotelCommentInfo;
var memberCardCustomList = new List <Models.Home.MemberCardCustom>();
var memberinfo = new Repository.MemberInfo();
if (ModuleAuthority.membership_price == 1)
{
memberinfo = hotel3g.Repository.MemberHelper.GetMemberInfo(hotelWeixinid);
if (memberinfo == null)
{
memberinfo = new Repository.MemberInfo();
}
}
int ismember = Convert.ToBoolean(MemberCardRuleJsonobj["becomeMember"].ToString()) ? 0 : 1;
if (ismember == 0 || ModuleAuthority.membership_price == 1)
{
int customcount = 0;
DataTable db_CardCustom = MemberCardCustom.GetMemberCardCustomList(hotelWeixinid, out customcount, 1, 50, "", "");
memberCardCustomList = DataTableToEntity.GetEntities <Models.Home.MemberCardCustom>(db_CardCustom).ToList();
}
ViewData["customlist"] = memberCardCustomList;
ViewData["memberinfo"] = memberinfo;
return(View());
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int AddModel(MemberCardCustom model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MemberCardCustom(");
strSql.Append("Reduce,JiFen,CardLevel,AddTime,LastUpdateTime,CardName,HotelId,WeixinId,IncreaseType,Rooms,BuyMoney,CouponType,Discount,Status");
strSql.Append(") values (");
strSql.Append("@Reduce,@JiFen,@CardLevel,@AddTime,@LastUpdateTime,@CardName,@HotelId,@WeixinId,@IncreaseType,@Rooms,@BuyMoney,@CouponType,@Discount,@Status");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
string obj = HotelCloud.SqlServer.SQLHelper.Get_Value(strSql.ToString(), HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
{ "Reduce", new HotelCloud.SqlServer.DBParam {
ParamValue = model.Reduce.ToString()
} },
{ "JiFen", new HotelCloud.SqlServer.DBParam {
ParamValue = model.JiFen.ToString()
} },
{ "CardLevel", new HotelCloud.SqlServer.DBParam {
ParamValue = model.CardLevel.ToString()
} },
{ "AddTime", new HotelCloud.SqlServer.DBParam {
ParamValue = model.AddTime.ToString()
} },
{ "LastUpdateTime", new HotelCloud.SqlServer.DBParam {
ParamValue = model.LastUpdateTime.ToString()
} },
{ "CardName", new HotelCloud.SqlServer.DBParam {
ParamValue = model.CardName.ToString()
} },
{ "HotelId", new HotelCloud.SqlServer.DBParam {
ParamValue = model.HotelId.ToString()
} },
{ "WeixinId", new HotelCloud.SqlServer.DBParam {
ParamValue = model.WeixinId.ToString()
} },
{ "IncreaseType", new HotelCloud.SqlServer.DBParam {
ParamValue = model.IncreaseType.ToString()
} },
{ "Rooms", new HotelCloud.SqlServer.DBParam {
ParamValue = model.Rooms.ToString()
} },
{ "BuyMoney", new HotelCloud.SqlServer.DBParam {
ParamValue = model.BuyMoney.ToString()
} },
{ "CouponType", new HotelCloud.SqlServer.DBParam {
ParamValue = model.CouponType.ToString()
} },
{ "Discount", new HotelCloud.SqlServer.DBParam {
ParamValue = model.Discount.ToString()
} },
{ "Status", new HotelCloud.SqlServer.DBParam {
ParamValue = model.Status.ToString()
} },
});
if (!string.IsNullOrEmpty(obj))
{
return(Convert.ToInt32(obj));
}
return(0);
}
