public void OnCreated(int iSize, int iScore)
{
//_collider = transform.FindChild("Collider").GetComponent<Collider>();
GameObject collider = ResourceMgr.Instance.CreateObj("FishCollider_" + iSize);
if (collider != null)
{
collider.transform.SetParent(transform, false);
_collider = collider.GetComponent <Collider2D>();
}
//_iSize = iSize;
_animator = GetComponent <Animator>();
_transMouth = transform.FindChild("Mouth");
this._ln = UILotteryMgr.Creator(0);
this._ln.SetSize(iSize);
this._ln.SetNum(iScore);
}
/// <summary>
/// 充值成功后，绑定数据
/// </summary>
/// <param name="BuyID"></param>
private void BindDataForAliBuy(long BuyID)
{
DataTable dt = new DAL.Tables.T_AlipayBuyTemp().Open("", "ID=" + BuyID.ToString(), "");
if (dt == null || dt.Rows.Count == 0)
{
return;
}
DataRow dr = dt.Rows[0];
string HidIsuseID = dr["IsuseID"].ToString();
string playType = dr["PlayTypeID"].ToString();
bool IsCoBuy = Shove._Convert.StrToBool(dr["IsCoBuy"].ToString(), false);
string tb_Share = dr["Share"].ToString();
string tb_BuyShare = dr["BuyShare"].ToString();
string tb_AssureShare = dr["AssureShare"].ToString();
string tb_OpenUserList = dr["OpenUsers"].ToString();
string tb_Title = dr["Title"].ToString();
string tb_Description = dr["Description"].ToString();
string tbSecrecyLevel = dr["SecrecyLevel"].ToString();
string tb_LotteryNumber = dr["LotteryNumber"].ToString();
string tb_hide_SumMoney = dr["SumMoney"].ToString();
string tb_hide_AssureMoney = dr["AssureMoney"].ToString();
string HidLotteryID = dr["LotteryID"].ToString();
string tb_Multiple = dr["Multiple"].ToString();
if (tb_Multiple == "")
{
tb_Multiple = "1";
}
double SumMoney = 0;
int Share = 0;
int BuyShare = 0;
double AssureMoney = 0;
int Multiple = 0;
short SecrecyLevel = 0;
int PlayTypeID = 0;
int LotteryID = 0;
long IsuseID = 0;
try
{
SumMoney = double.Parse(tb_hide_SumMoney);
Share = int.Parse(tb_Share);
BuyShare = int.Parse(tb_BuyShare);
AssureMoney = double.Parse(tb_hide_AssureMoney);
Multiple = int.Parse(tb_Multiple);
SecrecyLevel = short.Parse(tbSecrecyLevel);
PlayTypeID = int.Parse(playType);
LotteryID = int.Parse(HidLotteryID);
IsuseID = long.Parse(HidIsuseID);
}
catch { }
if ((BuyShare == Share) && (AssureMoney == 0))
{
Share = 1;
BuyShare = 1;
}
double BuyMoney = BuyShare * (SumMoney / Share) + AssureMoney;
string LotteryNumber = tb_LotteryNumber;
if (!string.IsNullOrEmpty(LotteryNumber) && LotteryNumber[LotteryNumber.Length - 1] == '\n')
{
LotteryNumber = LotteryNumber.Substring(0, LotteryNumber.Length - 1);
}
StringBuilder sb = new StringBuilder();
sb.AppendLine("<script type='text/javascript' defer='defer'>");
sb.Append("$Id('playType").Append(PlayTypeID.ToString()).AppendLine("').checked = true;");
sb.AppendLine("clickPlayType('" + PlayTypeID.ToString() + "');");
sb.AppendLine("function BindDataForFromAli(){");
LotteryNumber = LotteryNumber.Replace("\r", "");
int LotteryNum = 0;
string Number = "";
foreach (string lotteryNumber in LotteryNumber.Split('\n'))
{
if (!string.IsNullOrEmpty(lotteryNumber))
{
LotteryNum += new SLS.Lottery()[LotteryID].ToSingle(lotteryNumber, ref Number, PlayTypeID).Length;
sb.AppendLine("var option = document.createElement('option');");
sb.AppendLine("$Id('list_LotteryNumber').options.add(option);");
sb.Append("option.innerText = '").Append(lotteryNumber).AppendLine("';");
sb.Append("option.value = '").Append(lotteryNumber).AppendLine("';");
}
}
if (IsCoBuy)
{
sb.AppendLine("$Id('CoBuy').checked = true;");
sb.AppendLine("oncbInitiateTypeClick();");
}
sb.Append("$Id('tb_LotteryNumber').value = '").Append(tb_LotteryNumber.Replace("\r", "\\r").Replace("\n", "\\n")).AppendLine("';");
sb.Append("$Id('tb_Share').value = '").Append(tb_Share).AppendLine("';");
sb.Append("$Id('tb_BuyShare').value = '").Append(tb_BuyShare).AppendLine("';");
sb.Append("$Id('tb_AssureShare').value = '").Append(tb_AssureShare).AppendLine("';");
sb.Append("$Id('tb_OpenUserList').value = '").Append(tb_OpenUserList).AppendLine("';");
sb.Append("$Id('tb_Title').value = '").Append(tb_Title).AppendLine("';");
sb.Append("$Id('tb_Description').value = '").Append(tb_Description.Replace("\r", "\\r").Replace("\n", "\\n")).AppendLine("';");
sb.Append("$Id('SecrecyLevel").Append(SecrecyLevel.ToString()).AppendLine("').checked = true;");
sb.Append("$Id('tb_hide_SumMoney').value = '").Append(tb_hide_SumMoney).AppendLine("';");
sb.Append("$Id('tb_hide_AssureMoney').value = '").Append(AssureMoney.ToString("N0")).AppendLine("';");
sb.Append("$Id('tb_Multiple').value = '").Append(Multiple.ToString()).AppendLine("';");
sb.Append("$Id('lab_AssureMoney').innerText = '").Append(AssureMoney.ToString("N0")).AppendLine("';");
sb.Append("$Id('lab_SumMoney').innerText = '").Append(SumMoney.ToString("N0")).AppendLine("';");
sb.Append("$Id('lab_Num').innerText = '").Append(LotteryNum.ToString()).AppendLine("';");
sb.Append("$Id('tb_SchemeMoney').value = '").Append(SumMoney.ToString()).AppendLine("';");
sb.AppendLine("CalcResult();");
sb.AppendLine("}");
if (playType.Length != LotteryID.ToString().Length + 2)
{
sb.AppendLine("BindDataForFromAli()");
}
sb.AppendLine("</script>");
script = sb.ToString();
}
/// <summary>
/// 获取用户近期竞猜记录【已开奖】(ExtraData 返回当前用户是否点阅过最新一期未开奖的记录)
/// </summary>
public PagedListP <AchievementModel> GetUserLastPlay(long uid, int lType, string playName, long userId)
{
string strsql = string.Empty;
string numsql = string.Empty;
string playSql = string.Empty;
var pager = new PagedListP <AchievementModel>();
pager.PageIndex = 1;
pager.PageSize = 10;
SqlParameter[] sp = new SqlParameter[] { };
if (playName == "全部")//全部
{
strsql = string.Format(@"select * from BettingRecord where UserId ={0} and lType = {1}", uid, lType);
numsql = string.Format(@"SELECT * FROM ( select row_number() over(order by l.SubTime desc ) as rowNumber, Num,l.SubTime,l.Issue,b.lType from LotteryRecord l
,BettingRecord b
where b.Issue=l.Issue and b.lType=l.lType
and b.UserId={0} and b.lType={1} and b.WinState in(3,4)
group by l.Issue,Num,l.SubTime,b.lType
)t
where rowNumber BETWEEN {2} AND {3} " , uid, lType, pager.StartIndex, pager.EndIndex);
playSql = string.Format(@" select top 1 * from BettingRecord where UserId={0}
and lType={1} and WinState=1 order by SubTime desc", uid, lType);
}
else
{
strsql = string.Format(@"
select * from BettingRecord where UserId ={0} and lType = {1} and PlayName = @PlayName", uid, lType);
numsql = string.Format(@"SELECT * FROM ( select row_number() over(order by l.SubTime desc ) as rowNumber, Num,l.SubTime,l.Issue,b.lType from LotteryRecord l
,BettingRecord b
where b.Issue=l.Issue and b.lType=l.lType
and b.UserId={0} and b.lType={1} and b.PlayName=@PlayName and b.WinState in(3,4)
group by l.Issue,Num,l.SubTime,b.lType
)t
where rowNumber BETWEEN {2} AND {3} " , uid, lType, pager.StartIndex, pager.EndIndex);
playSql = string.Format(@" select top 1 * from BettingRecord where UserId={0}
and lType={1} and WinState=1 and PlayName=@PlayName order by SubTime desc", uid, lType);
sp = new SqlParameter[] { new SqlParameter("@PlayName", playName) };
}
List <LotteryNum> listnum = Util.ReaderToList <LotteryNum>(numsql, sp);//我对应的开奖数据
List <BettingRecord> listbet = Util.ReaderToList <BettingRecord>(strsql, sp);
List <AchievementModel> list = new List <AchievementModel>();
if (listnum.Count > 0)
{
foreach (var item in listnum)
{
AchievementModel model = new AchievementModel();
LotteryNum l = new LotteryNum();
l.Issue = item.Issue;
l.Num = item.Num;
l.SubTime = Convert.ToDateTime(item.SubTime).ToString("yyyy-MM-dd");
l.lType = item.lType;
model.LotteryNum = l;
if (listbet.Count() > 0)
{
model.BettingRecord = listbet.Where(x => x.Issue == item.Issue).ToList();
}
list.Add(model);
}
}
pager.PageData = list;
//查询最新一期玩法
var lastPlay = Util.ReaderToList <BettingRecordViewModel>(playSql, sp);
var extraData = lastPlay.FirstOrDefault();
if (extraData != null)
{
//查询当前用户是否点阅过该记录
string isSubSql = "select count(1) from dbo.ComeOutRecord where Type="
+ (int)TransactionTypeEnum.点阅 + " and UserId=" + userId + " and OrderId=" + extraData.Id;
object objIsSub = SqlHelper.ExecuteScalar(isSubSql);
extraData.IsRead = objIsSub != null && Convert.ToInt32(objIsSub) > 0;
}
pager.ExtraData = extraData;
return(pager);
}
