/// <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 + "余额不足");
}
//}
}
