/// <summary> /// 实体转换 /// <summary> private static Model.MGetHelp TranEntity(DataRow dr) { if (dr != null) { Model.MGetHelp model = new Model.MGetHelp(); if (!string.IsNullOrEmpty(dr["Id"].ToString())) { model.Id = int.Parse(dr["Id"].ToString()); } model.SQMID = dr["SQMID"].ToString(); if (!string.IsNullOrEmpty(dr["SQMoney"].ToString())) { model.SQMoney = decimal.Parse(dr["SQMoney"].ToString()); } model.SQCode = dr["SQCode"].ToString(); if (!string.IsNullOrEmpty(dr["SQDate"].ToString())) { model.SQDate = DateTime.Parse(dr["SQDate"].ToString()); } if (!string.IsNullOrEmpty(dr["PPState"].ToString())) { model.PPState = int.Parse(dr["PPState"].ToString()); } if (!string.IsNullOrEmpty(dr["ConfirmState"].ToString())) { model.ConfirmState = int.Parse(dr["ConfirmState"].ToString()); } if (!string.IsNullOrEmpty(dr["HelpType"].ToString())) { model.HelpType = int.Parse(dr["HelpType"].ToString()); } if (!string.IsNullOrEmpty(dr["MFLMoney"].ToString())) { model.MFLMoney = decimal.Parse(dr["MFLMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["MatchMoney"].ToString())) { model.MatchMoney = decimal.Parse(dr["MatchMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["MoneyType"].ToString())) { model.MoneyType = dr["MoneyType"].ToString(); } model.Remark = dr["Remark"].ToString(); if (!string.IsNullOrEmpty(dr["ComfirmDate"].ToString())) { model.ComfirmDate = DateTime.Parse(dr["ComfirmDate"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(Model.MGetHelp model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update MGetHelp set "); strSql.Append(" SQMID = @SQMID , "); //strSql.Append(" SQMoney = @SQMoney , "); strSql.Append(" SQCode = @SQCode , "); strSql.Append(" SQDate = @SQDate , "); strSql.Append(" PPState = @PPState , "); strSql.Append(" ConfirmState = @ConfirmState , "); strSql.Append(" MFLMoney = @MFLMoney , "); strSql.Append(" MatchMoney = @MatchMoney , "); strSql.Append(" HelpType = @HelpType , "); strSql.Append(" MoneyType = @MoneyType , "); strSql.Append(" Remark = @Remark, "); strSql.Append(" ComfirmDate = @ComfirmDate "); strSql.Append(" where Id=@Id "); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@SQMID", SqlDbType.VarChar, 50), //new SqlParameter("@SQMoney", SqlDbType.Decimal,9) , new SqlParameter("@SQCode", SqlDbType.VarChar, 50), new SqlParameter("@SQDate", SqlDbType.DateTime), new SqlParameter("@PPState", SqlDbType.Int, 4), new SqlParameter("@ConfirmState", SqlDbType.Int, 4), new SqlParameter("@MFLMoney", SqlDbType.Decimal, 9), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@MatchMoney", SqlDbType.Decimal, 9), new SqlParameter("@HelpType", SqlDbType.Int, 4), new SqlParameter("@MoneyType", SqlDbType.VarChar, 50), new SqlParameter("@ComfirmDate", SqlDbType.DateTime) }; parameters[0].Value = model.Id; parameters[1].Value = model.SQMID; //parameters[2].Value = model.SQMoney; parameters[2].Value = model.SQCode; parameters[3].Value = model.SQDate; parameters[4].Value = model.PPState; parameters[5].Value = model.ConfirmState; parameters[6].Value = model.MFLMoney; parameters[7].Value = model.Remark; parameters[8].Value = model.MatchMoney; parameters[9].Value = model.HelpType; parameters[10].Value = model.MoneyType; parameters[11].Value = model.ComfirmDate; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
private string create_xlTab(Model.MGetHelp get) { StringBuilder strText = new StringBuilder(); strText.AppendFormat("<ul class=\"xlTab\">"); strText.AppendFormat("<li class=\"parent\"><a href=\"javascript:void(0)\" class=\"iconmenu\">"); strText.AppendFormat("<th>"); strText.AppendFormat("时间日期:{0} 订单总额:{1}元", get.SQDate.ToString("yyyy-MM-dd HH:mm:ss"), (get.SQMoney).ToString("F0")); strText.AppendFormat("</th>"); strText.AppendFormat("</a>"); strText.AppendFormat("<ul class=\"children collapse\">"); # region 匹配记录
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(Model.MGetHelp model, Hashtable MyHs) { model.SQCode = Guid.NewGuid().ToString().Replace("-", "").Replace(" ", "").ToUpper().Substring(0, 15); //校验编号是否重复,重复的话重新生成 while (CommonBase.GetSingle("select SQCode from MGetHelp where SQCode='" + model.SQCode + "'") != null) { model.SQCode = Guid.NewGuid().ToString().Replace("-", "").Replace(" ", "").ToUpper().Substring(0, 15); } string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MGetHelp("); strSql.Append("SQMID,SQMoney,SQCode,SQDate,PPState,ConfirmState,MFLMoney,Remark,MatchMoney,HelpType,MoneyType,ComfirmDate"); strSql.Append(") values ("); strSql.Append("@SQMID,@SQMoney,@SQCode,@SQDate,@PPState,@ConfirmState,@MFLMoney,@Remark,@MatchMoney,@HelpType,@MoneyType,@ComfirmDate"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@SQMID", SqlDbType.VarChar, 50), new SqlParameter("@SQMoney", SqlDbType.Decimal, 9), new SqlParameter("@SQCode", SqlDbType.VarChar, 50), new SqlParameter("@SQDate", SqlDbType.DateTime), new SqlParameter("@PPState", SqlDbType.Int, 4), new SqlParameter("@ConfirmState", SqlDbType.Int, 4), new SqlParameter("@MFLMoney", SqlDbType.Decimal, 9), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@MatchMoney", SqlDbType.Decimal, 9), new SqlParameter("@HelpType", SqlDbType.Int, 4), new SqlParameter("@MoneyType", SqlDbType.VarChar, 50), new SqlParameter("@ComfirmDate", SqlDbType.DateTime) }; parameters[0].Value = model.SQMID; parameters[1].Value = model.SQMoney; parameters[2].Value = model.SQCode; parameters[3].Value = model.SQDate; parameters[4].Value = model.PPState; parameters[5].Value = model.ConfirmState; parameters[6].Value = model.MFLMoney; parameters[7].Value = model.Remark; parameters[8].Value = model.MatchMoney; parameters[9].Value = model.HelpType; parameters[10].Value = model.MoneyType; parameters[11].Value = model.ComfirmDate; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Insert(Model.MGetHelp model) { return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable()))); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.MGetHelp model) { return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable()))); }
public static bool Update(Model.MGetHelp model) { return(WE_Project.DAL.MGetHelp.Update(model)); }
public static Hashtable Update(Model.MGetHelp model, Hashtable MyHs) { return(WE_Project.DAL.MGetHelp.Update(model, MyHs)); }
public static bool Insert(Model.MGetHelp model) { return(WE_Project.DAL.MGetHelp.Insert(model)); }
public static Hashtable Insert(Model.MGetHelp model, Hashtable MyHs) { return(WE_Project.DAL.MGetHelp.Insert(model, MyHs)); }
/// <summary> /// 卖出许愿果 /// </summary> public static string GetHelp(Model.Member member, string moneyType, decimal sqMoney, Hashtable MyHs, bool isMoneyChcek = true) { if (!member.MState) { return("1*您的账号未激活,请先激活账号!"); } if (member.Role.IsAdmin) { return("1*不可申请"); } //卖出许愿果开关 if (!BLL.MMMConfig.Model.GetHelpSwitch || !SystemTimeRange.TimeIsClose(BLL.MMMConfig.Model.GetHelpTimes, DateTime.Now)) { return("1*当前时间不能申请"); } int getdaycount = Convert.ToInt32(BLL.CommonBase.GetSingle("SELECT COUNT(*) FROM MGetHelp WHERE SQMID='" + member.MID + "' and DATEDIFF(DAY,SQDate,GETDATE())=0 AND PPState<>5;")); if (getdaycount > 0) { return("1*当日卖出订单只可选择一种进行"); } int getcount = Convert.ToInt32(BLL.CommonBase.GetSingle("SELECT COUNT(*) FROM MGetHelp WHERE SQMID='" + member.MID + "' AND PPState<3;")); if (getcount > 0) { return("1*您有未完成的订单"); } decimal HelpBase = BLL.MMMConfig.Model.GetHelpBase; decimal HelpMax = BLL.MMMConfig.Model.GetHelpMax; if (moneyType == "MJB")//许愿池派单 { HelpBase = BLL.MMMConfig.Model.GetHelpDayTotalMoney; HelpMax = BLL.MMMConfig.Model.OfferHelpDayTotalMoney * member.MConfig.MJB; var lastmodel = BLL.MGetHelp.GetList(" SQMID='" + member.MID + "' order by SQDate desc ").FirstOrDefault(); if (lastmodel != null) { if (lastmodel.SQMoney > sqMoney) { return("1*您的申请额度不能比上一单小"); } } } if (sqMoney % HelpBase != 0) { return("1*提现金额应为" + HelpBase + "的倍数"); } if (sqMoney > HelpMax || sqMoney < BLL.MMMConfig.Model.GetHelpMin) { return("1*提现失败,提现范围应在" + BLL.MMMConfig.Model.GetHelpMin + "-" + HelpMax); } //校验买入许愿果次数 //if (!CanApplyHelp(member.MID, BLL.MMMConfig.Model.GetHelpRangeTimes, BLL.MMMConfig.Model.GetHelpRangeCount, false, moneyType)) //{ // return "1*申请失败,您" + BLL.MMMConfig.Model.GetHelpRangeTimes + "分钟内只能申请" + BLL.MMMConfig.Model.GetHelpRangeCount + "次"; //} //需要一个买入许愿果的订单,并且已经打过预付款的 //object offid= BLL.CommonBase.GetSingle("select ID from MOfferHelp where SQMID='aaa111' and PPState in(0,1,2,3) and MatchMoney>= MFLMoney;"); //if (offid != null) //{ // Model.MOfferHelp offer= BLL.MOfferHelp.GetModel(offid); // if (offer != null) // { // decimal yfkmoney= Convert.ToDecimal( BLL.CommonBase.GetSingle("SELECT ISNULL( SUM(MatchMoney),0) FROM MHelpMatch WHERE MatchState=3 and offerid in("+offer.Id+")")); // if (yfkmoney < offer.MFLMoney) // { // return "1*请打过预付款再提现"; // } // } // else { // return "1*提现失败,数据有误,请联系管理员"; // } //} //else { // return "1*提现失败,请买入许愿果并付预付款后再提现"; //} //如果是动态奖金就限制额度 //if (moneyType == "MJB") //{ // decimal mjbsum = BLL.MGetHelp.GetSumMoney(" SQMID='" + member.MID + "' and PPState<=3 and MoneyType='MJB'; "); // decimal mjbedu=member.MConfig.SHMoney * BLL.MMMConfig.Model.GetHelpFloat; // if ((mjbsum + sqMoney) >mjbedu ) // return "1*动态奖金提现额度不够,您还能提现" + (mjbedu - mjbsum); // //动态奖金消耗排单币 // Model.ConfigDictionary dicmcw= DAL.ConfigDictionary.GetConfigDictionary(Convert.ToInt32(sqMoney), "MGetMGP", ""); // decimal getmgp = Convert.ToDecimal(dicmcw.DValue) * Convert.ToDecimal(sqMoney); // if(!BLL.ChangeMoney.EnoughChange(member.MID,getmgp,"MGP")) // return "1*提现失败,排单币不足"; // else // BLL.ChangeMoney.HBChangeTran(getmgp, member.MID, BLL.Member.ManageMember.TModel.MID, "TXBH", member, "MGP", "卖出许愿果需" + getmgp + "个排单币", MyHs); //} //校验马夫罗是否足够 if (!isMoneyChcek || BLL.ChangeMoney.EnoughChange(member.MID, sqMoney, moneyType)) { Model.MGetHelp get = new Model.MGetHelp(); get.ConfirmState = 0; //get.MFLMoney = sqMoney; get.PPState = 0; get.MoneyType = moneyType; //get.SQCode = Guid.NewGuid().ToString("N").ToUpper(); get.SQDate = DateTime.Now; get.SQMID = member.MID; get.SQMoney = sqMoney; get.ComfirmDate = DateTime.MaxValue; //get.Remark = Request.Form["BankCode"]; //Hashtable hs = new Hashtable(); BLL.MGetHelp.Insert(get, MyHs); //扣除马夫罗 BLL.ChangeMoney.HBChangeTran(get.SQMoney, member.MID, BLL.Member.ManageMember.TModel.MID, "GET", null, moneyType, member.MID + "申请获得" + get.SQMoney + "的帮助", MyHs); return("1*0"); //if (BLL.CommonBase.RunHashtable(MyHs)) //{ // return "1*0"; //} //else //{ // return "1*提交申请失败"; //} } else { return("1*您的" + BLL.Reward.List[moneyType].RewardName + "余额不足"); } //} }