void MP_onCommonEvent(object sender, CommonInfo e) { Invoke(new MethodInvoker( delegate() { try { if (comboBox1.SelectedIndex == -1) return; if (e.InstrId == (comboBox1.SelectedItem as Instrument).ID) { lbAsk.Text = e.Ask.ToString(); lbBid.Text = e.Bid.ToString(); lblastPrice.Text = e.LastDealPrice.ToString(); lblastVolume.Text = e.LastDealVolume.ToString(); lbDeals.Text = e.TotalDeals.ToString(); lbVolumes.Text = e.TotalVolume.ToString(); lbPos.Text = e.CurrentPosition.ToString(); lbSells.Text = e.OrderSellCnt.ToString(); lbBuys.Text = e.OrderBuyCnt.ToString(); lbTimeStamp.Text = e.TimeStamp.ToString(); } } catch (Exception err) { MessageBox.Show(err.Message); } })); }
public static void ParseIPN(int orderID, string transID, string status, int storeID, int portalID, string userName, int customerID, string sessionCode) { GoogleCheckOutHandler ph = new GoogleCheckOutHandler(); try { OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = storeID; cf.PortalID = portalID; cf.AddedBy = userName; // UpdateOrderDetails AspxOrderDetails objad = new AspxOrderDetails(); SQLHandler sqlH = new SQLHandler(); // use split to split array we already have using "=" as delimiter // WcfSession ws = new WcfSession(); odinfo.OrderID = orderID;//ws.GetSessionVariable("OrderID"); odinfo.ResponseReasonText = status; odinfo.TransactionID = transID; ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; objad.UpdateOrderDetails(ot); // UpdateItemQuantity } catch (Exception ex) { throw ex; } }
/// <summary> /// 查看游戏里面所有道具 /// </summary> /// <returns></returns> public Message itemShop_QueryALL() { string serverIP = null; string itemName1 = null; string userID = null; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ServerIP).m_bValueBuffer); itemName1 = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ItemName).m_bValueBuffer); userID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_UserID).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_ItemShopAPI_AllGameItem); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_ItemShopAPI_AllGameItem); //请求所有分类道具列表 ds = ItemShopInfo.itemShop_QueryAll(serverIP, itemName1, userID); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); //道具编号 byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.O2JAM2_ItemCode, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //道具名 object itemName; if (ds.Tables[0].Rows[i].IsNull(1) == false) { itemName = ds.Tables[0].Rows[i].ItemArray[1]; } else { itemName = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, itemName); strut.AddTagKey(TagName.O2JAM2_ItemName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); //道具名 object descrpt; if (ds.Tables[0].Rows[i].IsNull(2) == false) { descrpt = ds.Tables[0].Rows[i].ItemArray[2]; } else { descrpt = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, descrpt); strut.AddTagKey(TagName.O2JAM2_Context, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); //道具使用次数 int timelimits = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]); if (timelimits == -1) { timelimits = 0; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, timelimits); strut.AddTagKey(TagName.O2JAM2_Timeslimt, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //使用时限 //道具使用次数 int dayslimits = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[4]); if (dayslimits == -1) { dayslimits = 0; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, dayslimits); strut.AddTagKey(TagName.O2JAM2_DayLimit, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_ITEMSHOP_QUERY_RESP, 5)); } else { return(Message.COMMON_MES_RESP(lg.O2JAM2API_ItemShopAPI_NoGameItem, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_ITEMSHOP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(lg.O2JAM2API_AccountInfoAPI_NoAccount, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_ITEMSHOP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查看玩家身上道具 /// </summary> /// <returns></returns> public Message itemShop_Owner_Query() { string serverIP = null; string userID = null; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ServerIP).m_bValueBuffer); userID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_UserID).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_AllBodyItem); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_AllBodyItem); //请求玩家身上的道具 ds = ItemShopInfo.AvatarItemList_Query(serverIP, userID); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); //道具编号 byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.O2JAM2_ItemCode, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //道具名 bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[1])); strut.AddTagKey(TagName.O2JAM2_ItemName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); //最小等级 bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.O2JAM2_Level, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //道具位置 bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[3]); strut.AddTagKey(TagName.O2JAM2_Position, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //道具使用次数 int timelimits = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[4]); if (timelimits == -1) { timelimits = 0; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, timelimits); strut.AddTagKey(TagName.O2JAM2_Timeslimt, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //道具时间限制 bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[5]); strut.AddTagKey(TagName.O2JAM2_DateLimit, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_AVATORLIST_QUERY_RESP, 6)); } else { return(Message.COMMON_MES_RESP(lg.O2JAM2API_ItemShopAPI_NoBodyItem, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_AVATORLIST_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(lg.O2JAM2API_AccountInfoAPI_NoAccount, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_AVATORLIST_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
private void toolSave_Click(object sender, EventArgs e) { string sError = ""; string ID, RoleID, RoleName, SortID, State; ID = sID; RoleID = this.txtRoleID.Text.Trim(); RoleName = this.txtRoleName.Text.Trim(); SortID = CommonInfo.CLng(this.txtSortID.Text.Trim()).ToString(); State = this.cmbState.Text.Trim(); StringBuilder strSql = new StringBuilder(); if (sID.Trim() == "") { strSql = new StringBuilder(); strSql.Append("insert into TQx_Dept("); strSql.Append("DeptID,DeptName,SortID,State,IsSheBeiHz)"); strSql.Append(" values ("); strSql.Append("@DeptID,@DeptName,@SortID,@State,@IsSheBeiHz)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@DeptID", SqlDbType.VarChar, 50), new SqlParameter("@DeptName", SqlDbType.VarChar, 50), new SqlParameter("@SortID", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.VarChar, 50) }; parameters[0].Value = RoleID; parameters[1].Value = RoleName; parameters[2].Value = SortID; parameters[3].Value = State; SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters, out sError); if (sError.Trim() != "") { MessageBox.Show("保存失败,错误:" + sError, "提示"); return; } //清空 this.toolQingKong_Click(null, null); } else { strSql = new StringBuilder(); strSql.Append("update TQx_Dept set "); strSql.Append("DeptName=@DeptName,"); strSql.Append("SortID=@SortID,"); strSql.Append("State=@State"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@DeptName", SqlDbType.VarChar, 50), new SqlParameter("@SortID", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.VarChar, 50), new SqlParameter("@ID", SqlDbType.BigInt, 8) }; parameters[0].Value = RoleName; parameters[1].Value = SortID; parameters[2].Value = State; parameters[3].Value = ID; SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters, out sError); if (sError.Trim() != "") { MessageBox.Show("保存失败,错误:" + sError, "提示"); return; } this.Close(); } }
/// <summary> /// 删除用户状态查询 /// </summary> /// <param name="index">第几页</param> /// <param name="pageSize">每页记录数</param> /// <returns></returns> public Message Soccer_DeletedCharacterinfo_Query(int index, int pageSize) { System.Data.DataSet ds = null; string serverIP = null; string str_type = ""; string str_string = ""; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_ServerIP).m_bValueBuffer); str_type = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_Type).m_bValueBuffer); str_string = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_String).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + str_string + lg.Soccer_CharacterInfoAPI_AccountInfo); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + str_string + lg.Soccer_CharacterInfoAPI_AccountInfo); ds = SOCCERCharacterInfo.Soccer_DeletedCharacterinfo_Query(serverIP, str_type, str_string); if (ds != null && ds.Tables[0].Rows.Count > 0) { //总页数 int pageCount = 0; pageCount = ds.Tables[0].Rows.Count % pageSize; if (pageCount > 0) { pageCount = ds.Tables[0].Rows.Count / pageSize + 1; } else { pageCount = ds.Tables[0].Rows.Count / pageSize; } if (index + pageSize > ds.Tables[0].Rows.Count) { pageSize = ds.Tables[0].Rows.Count - index; } Query_Structure[] structList = new Query_Structure[pageSize]; for (int i = index; i < index + pageSize; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[0])); strut.AddTagKey(TagName.Soccer_loginId, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[1])); strut.AddTagKey(TagName.Soccer_charidx, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[2])); strut.AddTagKey(TagName.Soccer_charname, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[3])); strut.AddTagKey(TagName.Soccer_charsex, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[4])); strut.AddTagKey(TagName.Soccer_charpos, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[5])); strut.AddTagKey(TagName.Soccer_charpoint, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[6])); strut.AddTagKey(TagName.Soccer_charlevel, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[7])); strut.AddTagKey(TagName.Soccer_charexp, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[8])); strut.AddTagKey(TagName.Soccer_match, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[9])); strut.AddTagKey(TagName.Soccer_win, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[10])); strut.AddTagKey(TagName.Soccer_lose, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[11])); strut.AddTagKey(TagName.Soccer_drop, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[12])); strut.AddTagKey(TagName.Soccer_draw, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[13])); strut.AddTagKey(TagName.Soccer_deleted_date, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[14])); strut.AddTagKey(TagName.Soccer_status, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount)); structList[i - index] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_DELETEDCHARACTERINFO_QUERY_RESP, 16)); } else { return(Message.COMMON_MES_RESP(lg.Soccer_CharacterInfoAPI_NoBan, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_DELETEDCHARACTERINFO_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_DELETEDCHARACTERINFO_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 检查角色信息 /// </summary> /// <returns></returns> public Message Soccer_CharCheck() { System.Data.DataSet ds = null; string serverIP = null; int char_idx = 0; string kind = ""; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_ServerIP).m_bValueBuffer); TLV_Structure struts = new TLV_Structure(TagName.Soccer_charidx, 4, msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_charidx).m_bValueBuffer); char_idx = (int)struts.toInteger(); kind = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_kind).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + char_idx + lg.Soccer_CharacterInfoAPI_AccountInfo); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + char_idx + lg.Soccer_CharacterInfoAPI_AccountInfo); ds = SOCCERCharacterInfo.Soccer_CharCheck(serverIP, char_idx, kind); if (kind == "socket") { if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[1])); strut.AddTagKey(TagName.Soccer_char_max, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2])); strut.AddTagKey(TagName.Soccer_char_cnt, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3])); strut.AddTagKey(TagName.Soccer_ret, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_CHARCHECK_QUERY_RESP, 3)); } else { return(Message.COMMON_MES_RESP(lg.Soccer_CharacterInfoAPI_NoBan, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_CHARCHECK_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } else { if (ds != null && ds.Tables[1].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[1].Rows.Count]; for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[1].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[1].Rows[i].ItemArray[1])); strut.AddTagKey(TagName.Soccer_char_max, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[1].Rows[i].ItemArray[2])); strut.AddTagKey(TagName.Soccer_char_cnt, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[1].Rows[i].ItemArray[3])); strut.AddTagKey(TagName.Soccer_ret, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_CHARCHECK_QUERY_RESP, 3)); } else { return(Message.COMMON_MES_RESP(lg.Soccer_CharacterInfoAPI_NoBan, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_CHARCHECK_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_CHARCHECK_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
public void Setup() { ConfigTestEnv.Init(); AutoMapperConfiguration.Init <IBaseEntity, IDomainViewModel, IDomainEntityType>(); // DomainEntityTpe G_UnitOfWork = new TestUnitOfWork(); _CacheManager = EngineContext.Current.Resolve <ICacheManager>(); G_IRule = new Moq.Mock <IRule>() { CallBase = true }; G_CommonInfo = new CommonInfo(); G_mockFilterFactory = new Moq.Mock <IFilterFactory>() { CallBase = true }; //Initialize Fakes // Context _Context = new Moq.Mock <ReposContext>() { CallBase = true }; //Repos G_mockSubCategoryRepository = new Moq.Mock <IRepository <SubCategory> >() { CallBase = true }; //Services G_mockServiceHandlerFactory = new Moq.Mock <IServiceHandlerFactory>() { CallBase = true }; G_mockSubCategoriesService = new Moq.Mock <ISubCategoriesService>() { CallBase = true }; G_mockSubCategoryTypesService = new Moq.Mock <ISubCategoryTypesService>() { CallBase = true }; G_mockCategoriesService = new Moq.Mock <ICategoriesService>() { CallBase = true }; G_mockSubCategoryItemsService = new Moq.Mock <ISubCategoryItemsService>() { CallBase = true }; G_mockSubCategoryClassItemService = new Moq.Mock <ISubCategoryClassItemsService> { CallBase = true }; // IQueryable setup //Category category = null; //SubCategory subCategory = null; //BaseEntity baseEntity = null; //IQueryable<BaseEntity> BaseEntityQueryable // = new[] { baseEntity, }.Where(query => query != null).AsQueryable(); var dataCategories = new List <Category> { new TestCategory { CategoryName = new DomainEntityTypeString { Value = "AAA" } }, new TestCategory { CategoryName = new DomainEntityTypeString { Value = "BBB" } }, new TestCategory { CategoryName = new DomainEntityTypeString { Value = "ZZZ" } }, }.AsQueryable(); //Mock Setups _Context.Setup(c => c.SaveChanges()).Returns(1); //var Set = _Context.Object.Set<SubCategory>(); // var DB = new TestDbSet<SubCategory>(); // _Context.Setup(m => m.Set<SubCategory>()).Returns(DB); // services G_mockSubCategoriesService.Setup(s => s.Verify(It.IsAny <ModelStateDictionary>())).Returns(Result.Success); // Repos //IEnumerable<IBaseEntity> Ent = new List<BaseEntity>(); G_mockSubCategoryRepository.Setup(s => s.ModifiedEntities).Returns(It.IsAny <EntityRules>()); //G_mockSubCategoryRepository // .Setup(s => s.Verify(It.IsAny<ServiceRuleFunc<bool>>() // , It.IsAny<ModelStateDictionary>() // , It.IsAny<object>())).Returns(Result.Success); }
/// <summary> /// 恢复临时密码 /// </summary> /// <param name="serverIP">服务器Ip</param> /// <param name="account">帐号名</param> /// <returns></returns> public static int ReTmpPassWord_Query(string serverIP, string serverName, int UserByID, int userid, string username, ref string strDesc) { DataSet ds = null; int result = -1; string RelPwd = null; string sql = null; try { //获取本地真实密码 sql = "select sql_statement from sqlexpress where sql_type='JW2_GetRelPassWord_Query' and sql_condition = 'JW2_GetRelPassWord_Query'"; System.Data.DataSet ds1 = SqlHelper.ExecuteDataset(sql); if (ds1 != null && ds1.Tables[0].Rows.Count > 0) { sql = ds1.Tables[0].Rows[0].ItemArray[0].ToString(); sql = string.Format(sql, serverName, userid); ds = SqlHelper.ExecuteDataset(sql); if (ds != null && ds.Tables[0].Rows.Count > 0) { RelPwd = ds.Tables[0].Rows[0].ItemArray[0].ToString(); //恢复临时密码 serverIP = CommonInfo.JW2_FindDBIP(serverIP, 8); sql = "select sql_statement from sqlexpress where sql_type='JW2_TmpPassWord_Query' and sql_condition = 'JW2_TmpPassWord_Query'"; System.Data.DataSet ds2 = SqlHelper.ExecuteDataset(sql); if (ds2 != null && ds2.Tables[0].Rows.Count > 0) { sql = ds2.Tables[0].Rows[0].ItemArray[0].ToString(); sql = string.Format(sql, RelPwd, userid); result = MySqlHelper.ExecuteNonQuery(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2loginDB), sql); } if (result == 1) { //更新本地临时密码状态 sql = "select sql_statement from sqlexpress where sql_type='JW2_UpdateTmpPassWord_Query' and sql_condition = 'JW2_UpdateTmpPassWord_Query'"; System.Data.DataSet ds3 = SqlHelper.ExecuteDataset(sql); if (ds3 != null && ds3.Tables[0].Rows.Count > 0) { sql = ds3.Tables[0].Rows[0].ItemArray[0].ToString(); sql = string.Format(sql, serverName, userid, 0); SqlHelper.ExecCommand(sql); } } } else { result = 2; } } if (result == 1) { strDesc = "恢复用户" + username.ToString() + "临时密码成功,请稍等,系统处理中!"; SqlHelper.insertGMtoolsLog(UserByID, "劲舞团2", serverIP, "JW2_TmpPassWord_Query", "恢复用户" + username.ToString() + "临时密码,成功(恢复临时密码,jw2)"); } else { strDesc = "恢复用户" + username.ToString() + "临时密码失败,确认该玩家是否设置临时密码!"; SqlHelper.insertGMtoolsLog(UserByID, "劲舞团2", serverIP, "JW2_TmpPassWord_Query", "恢复用户" + username.ToString() + "临时密码,失败(恢复临时密码,jw2)"); } } catch (MySqlException ex) { strDesc = "数据库连接失败,请重新尝试!"; SqlHelper.errLog.WriteLog("服务器IP" + serverIP + ex.Message); } return(result); }
/// <summary> /// 瑜伽达人/导师 主页 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Details(int id, int page = 1) { #region 站内信-信息数量 int tinstatcount = 0; int follcount = 0; int zancount = 0; int msgcount = 0; method.InstationInfo(user.Uid, out tinstatcount, out follcount, out zancount, out msgcount); ViewBag.tinstatcount = tinstatcount; ViewBag.follcount = follcount; ViewBag.zancount = zancount; ViewBag.msgcount = msgcount; ViewBag.AllCount = tinstatcount + follcount + zancount + msgcount; #endregion ///Follow iType ViewBag.UserType = 1; ViewBag.id = id; int strUid = user.Uid; int iLoginID = user.Uid;//登录用户ID ViewBag.iLoginID = user.Uid; #region 导师专页 基本信息 ViewYogisModels temp = new ViewYogisModels(); temp = client.GetYogisModelsById(id); if (!temp.IsNullOrEmpty()) { ///昵称 ViewBag.NickName = clientUser.GetYogaUserById(temp.UID).NickName; strUid = temp.UID; ViewBag.strUid = temp.UID; ///位置 string strCountryID = ""; string strProvinceID = ""; string strCityID = ""; string strDistrictID = ""; if (temp.CountryID != null && temp.CountryID != 0) { strCountryID = GetItemName(temp.CountryID.Value) + "· "; } if (temp.ProvinceID != null && temp.ProvinceID != 0) { strProvinceID = GetItemName(temp.ProvinceID.Value) + " · "; } if (temp.CityID != null && temp.CityID != 0) { strCityID = GetItemName(temp.CityID.Value) + " ·"; } if (temp.DistrictID != null && temp.DistrictID != 0) { strDistrictID = GetItemName(temp.DistrictID.Value); } ViewBag.AddRessName = strCountryID + strProvinceID + strCityID + strDistrictID; ///流派 if (!string.IsNullOrEmpty(temp.YogaTypeid)) { string[] ids = temp.YogaTypeid.Split(','); foreach (var i in ids) { ViewBag.YogaTypeid += GetItemName(Convert.ToInt32(i)) + " "; } } else { ViewBag.YogaTypeid = ""; } ViewBag.listGroup = temp; } #endregion //关注 粉丝 人气 ViewFollow viewMoel = new ViewFollow(); using (FollowServiceClient followClient = new FollowServiceClient()) { ViewBag.iCount = followClient.GetFollowByUid(id); ViewBag.FCount = followClient.GetFollowByCount(id); } #region 瑜伽圈 List <ViewFollow> listFollow = new List <ViewFollow>(); listFollow = clientFoll.GetFollowUidQuiltList(id); ViewFollow vm = clientFoll.GetFollowById(iLoginID, strUid); ViewBag.isfollow = vm == null ? false : vm.isfollow; List <ViewFollowUserDetail> list2Group = new List <ViewFollowUserDetail>(); #region string idsUid = string.Join(",", listFollow.Where(a => a.Uid != id).Select(a => a.Uid)); string idsQuiltUid = string.Join(",", listFollow.Where(a => a.QuiltUid != id).Select(a => a.QuiltUid)); string idsval = idsUid + "," + idsQuiltUid; //数组 var idslist = idsval.Split(',').Distinct(); foreach (var item in idslist) { if (!string.IsNullOrEmpty(item)) { ViewFollowUserDetail model = new ViewFollowUserDetail(); ViewYogaUser modelyoga = clientUser.GetYogaUserById(Convert.ToInt32(item)); if (modelyoga.UserType == 0) { //专页id和被关注id是同一个 //习练者 ViewYogaUserDetail udmodel = clientDetail.GetYogaUserDetailById(Convert.ToInt32(item)); model.spic = CommonInfo.GetDisplayImg(udmodel.DisplayImg); model.userurl = "/YogaUserDetail/Details/"; model.uid = udmodel.UID; //登录表 model.nickname = modelyoga.NickName; list2Group.Add(model); } else if (modelyoga.UserType == 1) { #region 导师 ViewYogisModels mmodel = client.GetYogisModelsById(Convert.ToInt32(item)); model.spic = CommonInfo.GetDisplayImg(mmodel.DisplayImg); //登录表 model.nickname = modelyoga.NickName; if (mmodel.YogisLevel != null) { if (mmodel.YogisLevel == 4) { model.userurl = "/YogaGuru/Details/"; model.nickname = mmodel.RealName; } else { model.userurl = "/YogisModels/Details/"; } } else { model.userurl = "/YogisModels/Details/"; } model.uid = mmodel.UID; #endregion list2Group.Add(model); } } } #endregion ViewBag.list2Group = list2Group; #endregion #region 相册 List <ViewYogaPicture> listPic = new List <ViewYogaPicture>(); int piccount = 0; listPic = clientPic.GetYogaPicturePageList(id, 1, 7, out piccount); if (listPic.Count() > 0) { ViewBag.listPic = listPic; } #endregion int rcount = 0; int mcount = 0; int pagesize = 10; ViewBag.msginfo = method.listMessage(id, 0, page, out mcount);//留言 评论 ViewBag.mcount = mcount; ViewBag.rcount = clientMsg.GettMessageUid(id, 1).Count(); #region 我的日志列表 int count = 0; List <ViewtWriteLog> listwriteLog = logClient.GettWriteLogPageList(id, 1, 6, out count); List <ViewtWriteLogGroup> listLog = new List <ViewtWriteLogGroup>(); foreach (var item in listwriteLog) { ViewtWriteLogGroup model = new ViewtWriteLogGroup(); model.entity = item; ViewYogaUser userEntity = clientUser.GetYogaUserById(item.Uid.Value); if (userEntity != null) { model.UserName = userEntity.NickName; } else { model.UserName = ""; } listLog.Add(model); } ViewBag.listLog = listLog; #endregion ViewBag.url = Request.Url.AbsolutePath; Webdiyer.WebControls.Mvc.PagedList <ViewtMessageGroup> l = new Webdiyer.WebControls.Mvc.PagedList <ViewtMessageGroup>(ViewBag.msginfo, page, pagesize, mcount); string strRec = ""; if (!string.IsNullOrEmpty(Request.Form["levelid"])) { strRec = Request.Form["levelid"]; } if (Session["levelid"] != null) { if (string.IsNullOrEmpty(strRec)) { strRec = Session["levelid"].ToString(); } } if (!string.IsNullOrEmpty(strRec)) { if (strRec == "1") { #region 推荐数据 List <ViewtMessage> recommendEntity = new List <ViewtMessage>(); recommendEntity = clientMsg.GettMessageUidList(id, 1, page, pagesize, out rcount); List <ViewtMessageGroup> listGroupRec = new List <ViewtMessageGroup>(); foreach (var item in recommendEntity) { ViewtMessageGroup model = new ViewtMessageGroup(); model.entity = item; model.entity.iZan = zanclient.ZanCount(item.ID, item.FormType.Value); //被留言人 ViewYogaUser yuser = clientUser.GetYogaUserById(item.ToUid.Value); if (yuser != null) { model.ToUser = yuser.NickName; model.UserType = yuser.UserType; } //留言人 ViewYogaUser usermodel = clientUser.GetYogaUserById(item.FromUid.Value); if (usermodel != null) { model.FromUser = usermodel.NickName; model.UserType = usermodel.UserType; } if (item.FormType == 0) { //习练者头像 using (YogaUserDetailServiceClient clientDet = new YogaUserDetailServiceClient()) { ViewYogaUserDetail ViewDet = new ViewYogaUserDetail(); if (item.FromUid != 0) { model.DisplayImg = clientDet.GetYogaUserDetailById(item.FromUid.Value).DisplayImg; } model.sUrl = "/YogaUserDetail/Details/" + item.FromUid.Value; } } else { //导师头像 using (YogisModelsServiceClient clientDet = new YogisModelsServiceClient()) { ViewYogisModels ViewDet = new ViewYogisModels(); if (item.FromUid != 0) { model.DisplayImg = clientDet.GetYogisModelsById(item.FromUid.Value).DisplayImg; } model.sUrl = "/YogisModels/Details/" + item.FromUid.Value; } } //回复 List <ViewtMessage> listM = clientMsg.GettMessageParentID(item.ID); List <ViewtMessageGroup> entitylist = new List <ViewtMessageGroup>(); foreach (var it in listM) { ViewtMessageGroup entityMsg = new ViewtMessageGroup(); entityMsg.entity = it; //被留言人 ViewYogaUser yuser2 = clientUser.GetYogaUserById(it.ToUid.Value); if (yuser2 != null) { entityMsg.ToUser = yuser2.NickName; } //留言人 ViewYogaUser usermodel2 = clientUser.GetYogaUserById(it.FromUid.Value); if (usermodel2 != null) { entityMsg.FromUser = usermodel2.NickName; } entitylist.Add(entityMsg); } model.msgList = entitylist; listGroupRec.Add(model); } ViewBag.RecInfo = listGroupRec; #endregion Session["levelid"] = strRec; Webdiyer.WebControls.Mvc.PagedList <ViewtMessageGroup> l2 = new Webdiyer.WebControls.Mvc.PagedList <ViewtMessageGroup>(ViewBag.RecInfo, page, pagesize, rcount); if (Request.IsAjaxRequest()) { return(PartialView("PartialRec", l2)); } } } if (Request.IsAjaxRequest()) { Session["levelid"] = 0; return(PartialView("PartialRec", l)); } return(View(l)); }
/// <summary> /// 修改临时密码 /// </summary> /// <param name="serverIP">服务器Ip</param> /// <param name="account">帐号名</param> /// <returns></returns> public static int TmpPassWord_Query(string serverIP, string serverName, int UserByID, int userid, string username, string TmpPwd, ref string strDesc) { DataSet ds = null; int result = -1; string RelPwd = null; string sql = null; MD5Encrypt st = new MD5Encrypt(); //string sign = st.getMD5ofStr(TmpPwd).ToLower(); string sign = TmpPwd; try { //查询是否被修改过 sql = "select sql_statement from sqlexpress where sql_type='JW2_SearchTmpPWD_Staute_Query' and sql_condition = 'JW2_SearchTmpPWD_Staute_Query'"; System.Data.DataSet ds4 = SqlHelper.ExecuteDataset(sql); if (ds4 != null && ds4.Tables[0].Rows.Count > 0) { sql = ds4.Tables[0].Rows[0].ItemArray[0].ToString(); sql = string.Format(sql, serverName, userid); System.Data.DataSet ds5 = SqlHelper.ExecuteDataset(sql); if (ds5.Tables[0].Rows.Count == 0) { //获取真实密码 serverIP = CommonInfo.JW2_FindDBIP(serverIP, 3); sql = "select sql_statement from sqlexpress where sql_type='JW2_GetPassWord_Query' and sql_condition = 'JW2_GetPassWord_Query'"; System.Data.DataSet ds1 = SqlHelper.ExecuteDataset(sql); if (ds1 != null && ds1.Tables[0].Rows.Count > 0) { sql = ds1.Tables[0].Rows[0].ItemArray[0].ToString(); sql = string.Format(sql, userid); ds = MySqlHelper.ExecuteDataset(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2loginDB), sql); if (ds != null && ds.Tables[0].Rows.Count > 0) { serverIP = CommonInfo.JW2_FindDBIP(serverIP, 8); RelPwd = ds.Tables[0].Rows[0].ItemArray[0].ToString(); //修改密码 sql = "select sql_statement from sqlexpress where sql_type='JW2_TmpPassWord_Query' and sql_condition = 'JW2_TmpPassWord_Query'"; System.Data.DataSet ds2 = SqlHelper.ExecuteDataset(sql); if (ds2 != null && ds2.Tables[0].Rows.Count > 0) { sql = ds2.Tables[0].Rows[0].ItemArray[0].ToString(); sql = string.Format(sql, sign, userid); result = MySqlHelper.ExecuteNonQuery(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2loginDB), sql); } if (result == 1) { //记录真实和临时密码在125上 sql = "select sql_statement from sqlexpress where sql_type='JW2_InsertTmpPassWord_Query' and sql_condition = 'JW2_InsertTmpPassWord_Query'"; System.Data.DataSet ds3 = SqlHelper.ExecuteDataset(sql); if (ds3 != null && ds3.Tables[0].Rows.Count > 0) { sql = ds3.Tables[0].Rows[0].ItemArray[0].ToString(); sql = string.Format(sql, serverName, userid, username, RelPwd, TmpPwd, sign, 1); result = SqlHelper.ExecCommand(sql); } } } } } else { result = 2; } } if (result == 1) { strDesc = "修改用户" + username.ToString() + "临时密码成功,请稍等,系统处理中!"; SqlHelper.insertGMtoolsLog(UserByID, "劲舞团2", serverIP, "JW2_TmpPassWord_Query", "修改用户" + username.ToString() + "临时密码,成功(修改临时密码,jw2)"); } else { strDesc = "修改用户" + username.ToString() + "临时密码失败,确认该玩家是否设置临时密码!"; SqlHelper.insertGMtoolsLog(UserByID, "劲舞团2", serverIP, "JW2_TmpPassWord_Query", "修改用户" + username.ToString() + "临时密码,失败(修改临时密码,jw2)"); } } catch (System.Exception ex) { strDesc = "数据库连接失败,请重新尝试!"; SqlHelper.errLog.WriteLog("服务器IP" + serverIP + ex.Message); } return(result); }
/// <summary> /// 格式化json /// </summary> /// <param name="imgs"></param> /// <returns></returns> private string FormateJson(List <ViewYogaPicture> imgs, int uid, int imgid) { //获得当前相册人 ViewYogisModels model = null; ViewYogaUserDetail udetail = null; ViewYogaUser u = null; string defaultimg = string.Empty; string defaultname = string.Empty; YogaUserDetailServiceClient udetailClient = new YogaUserDetailServiceClient(); YogisModelsServiceClient modelClient = new YogisModelsServiceClient(); YogaUserServiceClient userClient = new YogaUserServiceClient(); u = userClient.GetYogaUserById(uid); if (u != null) { //习练者 if (u.UserType == 0) { udetail = udetailClient.GetYogaUserDetailById(uid); if (udetail != null) { defaultimg = CommonInfo.GetDisplayImg(udetail.DisplayImg); defaultname = u.NickName; } } else { //导师 model = modelClient.GetYogisModelsById(uid); if (model != null) { defaultimg = CommonInfo.GetDisplayImg(model.DisplayImg); //大师 //if (model.YogisLevel == 4) defaultname = model.RealName; //else // defaultname = u.NickName; } } } tMessageServiceClient mesClient = new tMessageServiceClient(); StringBuilder sb = new StringBuilder(); sb.Append("{"); sb.Append("\"code\":1,"); sb.Append("\"album\":\"默认相册\","); sb.Append(String.Format("\"showimages\":\"{0}\",", imgid)); sb.Append("\"thumbList\":["); using (tMessageServiceClient msgClient = new tMessageServiceClient()) { foreach (ViewYogaPicture img in imgs) { sb.Append("{"); sb.Append("\"id\":"); sb.Append(String.Format("\"{0}\",", img.Pid)); sb.Append("\"title\":"); sb.Append("\"相册\","); sb.Append("\"user\":"); sb.Append(String.Format("\"{0}\",", defaultname)); sb.Append("\"avatar\":"); sb.Append(String.Format("\"{0}\",", defaultimg)); sb.Append("\"time\":"); sb.Append(string.Format("\"{0}\",", img.CreateTime == null?"":Convert.ToDateTime(img.CreateTime).ToString("yyyy-MM-dd HH:mm"))); sb.Append("\"desc\":"); sb.Append(string.Format("\"{0}\",", img.PictureContent)); sb.Append("\"thumb\":"); sb.Append(string.Format("\"{0}\",", img.PictureOriginal)); sb.Append("\"large\":"); sb.Append(string.Format("\"{0}\",", img.PictureOriginal)); sb.Append("\"comment\":"); sb.Append("["); List <ViewtMessage> messages = mesClient.GettMessageUid(img.Pid, 5); foreach (ViewtMessage v in messages) { string defcovimg = string.Empty; string defname = string.Empty; if (v.FormType == 0) { udetail = udetailClient.GetYogaUserDetailById((int)v.FromUid); if (udetail != null) { defcovimg = CommonInfo.GetDisplayImg(udetail.DisplayImg); } u = userClient.GetYogaUserById((int)v.FromUid); if (u != null) { defname = u.NickName; } } else { model = modelClient.GetYogisModelsById((int)v.FromUid); if (model != null) { defcovimg = CommonInfo.GetDisplayImg(model.DisplayImg); defname = model.RealName; } } sb.Append("{"); sb.Append("\"avatar\":"); sb.Append(String.Format("\"{0}\",", defcovimg)); sb.Append("\"user\":"); sb.Append(String.Format("\"{0}\",", defname)); sb.Append("\"msg\":"); sb.Append(String.Format("\"{0}\"", v.sContent)); sb.Append("},"); } if (messages != null && messages.Count > 0) { sb.Remove(sb.Length - 1, 1); } sb.Append("]"); sb.Append("},"); } } if (imgs != null && imgs.Count > 0) { sb.Remove(sb.Length - 1, 1); } sb.Append("]"); sb.Append("}"); return(sb.ToString()); }
/// <summary> /// 评论/留言 /// </summary> /// <param name="id"></param> /// <returns></returns> public List <ViewtMessageGroup> listMessage(int id, int page, int pagesize, out int rcount) { #region 留言 if (page == 0) { page = 1; } List <ViewtMessage> msgEntity = new List <ViewtMessage>(); msgEntity = client.GettMessageUidList(id, 4, page, pagesize, out rcount); List <ViewtMessageGroup> listGroupMsg = new List <ViewtMessageGroup>(); foreach (var item in msgEntity) { ViewtMessageGroup model = new ViewtMessageGroup(); model.entity = item; //被留言人 ViewYogaUser yuser = clientUser.GetYogaUserById(item.ToUid.Value); if (yuser != null) { model.ToUser = yuser.NickName; } //留言人 ViewYogaUser usermodel = clientUser.GetYogaUserById(item.FromUid.Value); if (usermodel != null) { model.FromUser = usermodel.NickName; } #region 头像 if (item.FormType == 0) { //习练者头像 using (YogaUserDetailServiceClient clientDet = new YogaUserDetailServiceClient()) { ViewYogaUserDetail ViewDet = new ViewYogaUserDetail(); if (item.FromUid != 0) { ViewDet = clientDet.GetYogaUserDetailById(item.FromUid.Value); if (ViewDet != null) { model.DisplayImg = CommonInfo.GetDisplayImg(ViewDet.DisplayImg); } model.sUrl = "/YogaUserDetail/Details/" + item.FromUid.Value; } } } else { //导师头像 using (YogisModelsServiceClient clientDet = new YogisModelsServiceClient()) { ViewYogisModels ViewDet = new ViewYogisModels(); if (item.FromUid != 0) { ViewDet = clientDet.GetYogisModelsById(item.FromUid.Value); if (ViewDet != null) { model.DisplayImg = CommonInfo.GetDisplayImg(ViewDet.DisplayImg); } model.sUrl = "/YogisModels/Details/" + item.FromUid.Value; } } } #endregion //strPic //回复 List <ViewtMessage> listM = client.GettMessageParentID(item.ID); List <ViewtMessageGroup> entitylist = new List <ViewtMessageGroup>(); foreach (var it in listM) { ViewtMessageGroup entityMsg = new ViewtMessageGroup(); entityMsg.entity = it; //被留言人 ViewYogaUser yuser2 = clientUser.GetYogaUserById(it.ToUid.Value); if (yuser2 != null) { entityMsg.ToUser = yuser2.NickName; } //留言人 ViewYogaUser usermodel2 = clientUser.GetYogaUserById(it.FromUid.Value); if (usermodel2 != null) { entityMsg.FromUser = usermodel2.NickName; } #region 头像 if (it.FormType == 0) { //习练者头像 using (YogaUserDetailServiceClient clientDet = new YogaUserDetailServiceClient()) { ViewYogaUserDetail ViewDet = new ViewYogaUserDetail(); if (it.FromUid != 0) { ViewDet = clientDet.GetYogaUserDetailById(it.FromUid.Value); if (ViewDet != null) { entityMsg.DisplayImg = CommonInfo.GetDisplayImg(ViewDet.DisplayImg); } entityMsg.sUrl = "/YogaUserDetail/Details/" + it.FromUid.Value; } } } else { //导师头像 using (YogisModelsServiceClient clientDet = new YogisModelsServiceClient()) { ViewYogisModels ViewDet = new ViewYogisModels(); if (it.FromUid != 0) { ViewDet = clientDet.GetYogisModelsById(it.FromUid.Value); if (ViewDet != null) { entityMsg.DisplayImg = CommonInfo.GetDisplayImg(ViewDet.DisplayImg); } entityMsg.sUrl = "/YogisModels/Details/" + it.FromUid.Value; } } } #endregion entitylist.Add(entityMsg); } model.msgList = entitylist; listGroupMsg.Add(model); } #endregion return(listGroupMsg); }
/// <summary> /// 删除玩家礼物盒上道具 /// </summary> /// <returns></returns> public Message GiftBox_MessageItem_Delete() { int result = -1; int operateUserID = 0; string serverIP = null; string userID = null; int itemCode = 0; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ServerIP).m_bValueBuffer); TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer); operateUserID = (int)strut.toInteger(); userID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_UserID).m_bValueBuffer); strut = new TLV_Structure(TagName.O2JAM2_ItemCode, 4, msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ItemCode).m_bValueBuffer); itemCode = (int)strut.toInteger(); result = ItemShopInfo.giftBox_Delete(operateUserID, serverIP, userID, itemCode); if (result == 1) { SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem + itemCode + lg.API_Delete + lg.API_Success + "!"); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem + itemCode + lg.API_Delete + lg.API_Success + "!"); return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_ITEMSHOP_DELETE_RESP)); } else { SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem + itemCode + lg.API_Delete + lg.API_Failure + "!"); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem + itemCode + lg.API_Delete + lg.API_Failure + "!"); return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_ITEMSHOP_DELETE_RESP)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(lg.O2JAM2API_AccountInfoAPI_NoAccount, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_ITEMSHOP_DELETE_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
public void Test_SubCategoryControl_Create_Is_Not_Valid() { var dataSubCategories = new List <SubCategory> { new TestSubCategory { Id = 1, SubCategoryName = new DomainEntityTypeString { Value = "ABC" } }, new TestSubCategory { Id = 2, SubCategoryName = new DomainEntityTypeString { Value = "ZZZ" } }, new TestSubCategory { Id = 3, SubCategoryName = new DomainEntityTypeString { Value = "MMM" } }, }.AsQueryable(); G_mockSubCategoriesService.Setup(s => s.GetAll()).Returns(dataSubCategories); //var sc = new Moq.Mock<SubCategory>(); var sc = new TestSubCategory(); G_mockSubCategoriesService.Setup(s => s.CreateServiceEntity()).Returns(sc); var si = new Moq.Mock <SubCategoryClassItem>(); G_mockSubCategoryClassItemService.Setup(s => s.CreateServiceEntity()).Returns(si.Object); var _ServiceHandlerFactory = new TestServiceHandlerFactory(); var _Filter = new TestFilterFactory(); var _rule = new TestRulesFactory(); var common = new CommonInfo(); var controller = new SubCategoryController(G_mockCategoriesService.Object , G_mockSubCategoriesService.Object , G_mockSubCategoryTypesService.Object , G_mockSubCategoryItemsService.Object , _ServiceHandlerFactory , G_mockSubCategoryClassItemService.Object , _Filter , _rule , common , G_UnitOfWork ); SetWebControllerInstance.Initialize(controller); var res = controller.GetAvailableCategory(1, 1); dynamic attr = new ExpandoObject(); // attr.propList = new List<PropListKeyPair>(); // attr.Filter = new List<FilterKeyPair>(); var Model = new SubCategoryModel { SubCategoryName = new DomainEntityTypeString { Value = string.Empty, Attributes = null } , CategoryId = new DomainEntityTypeInt { Value = int.MaxValue , Attributes = attr } , CategoryTypeId = new DomainEntityTypeInt { Value = int.MaxValue } }; controller.Create(Model); var isTrue = controller.ModelState .SelectMany(c => c.Value.Errors) .Any(a => a.ErrorMessage.Contains("SubCategoryName")); Assert.IsTrue(!isTrue, "Failed to throw exception."); }
public static PayPalHandler ParseAfterIPN(string postData, int storeID, int portalID, string userName, int customerID, string sessionCode, string TemplateName, string addressPath) { String sKey, sValue; PayPalHandler ph = new PayPalHandler(); string transID = string.Empty; try { String[] StringArray = postData.Split('\n'); /* * loop is set to start at 1 rather than 0 because first string in array will be single word SUCCESS or FAIL Only used to verify post data */ OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = storeID; cf.PortalID = portalID; cf.AddedBy = userName; AspxOrderDetails objad = new AspxOrderDetails(); SQLHandler sqlH = new SQLHandler(); odinfo.OrderID = int.Parse(HttpContext.Current.Session["OrderID"].ToString()); int i; for (i = 1; i < StringArray.Length - 1; i++) { String[] StringArray1 = StringArray[i].Split('='); sKey = StringArray1[0]; sValue = HttpUtility.UrlDecode(StringArray1[1]); switch (sKey) { case "payment_status": odinfo.ResponseReasonText = Convert.ToString(sValue); break; case "mc_fee": break; case "payer_email": break; case "Tx Token": break; case "txn_id": odinfo.TransactionID = Convert.ToString(sValue); transID = Convert.ToString(sValue); break; } } ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; HttpContext.Current.Session.Remove("OrderID"); HttpContext.Current.Session.Remove("OrderCollection"); return ph; } catch (Exception ex) { throw ex; } }
/// <summary> /// 取回玩家光線飛車仓库密码 /// </summary> /// <returns></returns> public Message Get_WarehousePassword() { int operateUserID = 0; string serverIP = null; string account = null; string passwd = null; string email = null; int characterID = 0; int result = -1; try { TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer); operateUserID = (int)strut.toInteger(); serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer); account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_NyUserID).m_bValueBuffer); email = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Email).m_bValueBuffer); string signpasswd = MD5EncryptAPI.nextID(6); MD5Encrypt st = new MD5Encrypt(); passwd = st.getMD5ofStr(signpasswd).ToLower(); strut = new TLV_Structure(TagName.RayCity_CharacterID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_CharacterID).m_bValueBuffer); characterID = (int)strut.toInteger(); SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Set + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_WarehousePassword); Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Set + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_WarehousePassword); result = GlobalAccount.Get_WarehousePassword(operateUserID, serverIP, characterID, account, signpasswd, passwd); if (result == 1) { if (sendRayCityMail("*****@*****.**", email, account, signpasswd) == 1) { return(Message.COMMON_MES_RESP("SCUESS", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_WareHousePwd_Update_Resp)); } else { return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_WareHousePwd_Update_Resp)); } } else { return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_WareHousePwd_Update_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message); return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_WareHousePwd_Update_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
// // GET: /Message/Details/5 public ActionResult MyMessage(int iType, int page = 1) { ViewBag.delif = iType; ViewBag.iType = 2; int count = 0; ViewBag.uid = user.Uid; int pagesize = 10; List <ViewLogsMessages> logsmsgs = new List <ViewLogsMessages>(); ViewLogsMessages lm; List <ViewtWriteLog> ls = logclient.GettWriteLogPageListByMessage(iType, user.Uid, page, pagesize, out count); foreach (ViewtWriteLog log in ls) { lm = new ViewLogsMessages(); //留言人 ViewYogaUser usermodel = clientUser.GetYogaUserById(log.Uid.Value); if (usermodel != null) { ViewBag.currentname = lm.name = usermodel.NickName; if (usermodel.UserType == 0) { ViewBag.url = lm.userurl = "/YogaUserDetail/Details/" + log.Uid; ViewYogaUserDetail ViewDet = udclient.GetYogaUserDetailById((int)log.Uid); if (ViewDet != null) { ViewBag.DisplayImg = CommonInfo.GetDisplayImg(ViewDet.DisplayImg); } } else { ViewBag.url = lm.userurl = "/YogisModels/Details/" + log.Uid; ViewYogisModels ViewDet = mclient.GetYogisModelsById((int)log.Uid); if (ViewDet != null) { ViewBag.DisplayImg = CommonInfo.GetDisplayImg(ViewDet.DisplayImg); } } } lm.id = log.ID.ToString(); lm.title = log.sTitle; lm.imgurl = GetFirstImages(log.sContent); string noContent = NoHTML(log.sContent); if (noContent.Length > 120) { noContent = noContent.Substring(0, 120) + "..."; } lm.content = noContent; int mescount = 0; lm.messages = listMessage(log.ID, 1, 50, out mescount); lm.messagescount = mescount; logsmsgs.Add(lm); } Webdiyer.WebControls.Mvc.PagedList <ViewLogsMessages> pagelist = new Webdiyer.WebControls.Mvc.PagedList <ViewLogsMessages>(logsmsgs, page, pagesize, count); if (Request.IsAjaxRequest()) { return(PartialView("PartialMsg", pagelist)); } else { return(View(pagelist)); } }
/// <summary> /// GM帳號查询,已封停和未封停 /// </summary> /// <returns></returns> public Message GMAccount_Query(int index, int pageSize) { string serverIP = null; string account = null; int accountState = 0; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer); account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_NyUserID).m_bValueBuffer); TLV_Structure strut = new TLV_Structure(TagName.RayCity_AccountState, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_AccountState).m_bValueBuffer); accountState = (int)strut.toInteger(); SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_GMAccount + account + lg.RayCityAPI_BanAccount); Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_GMAccount + account + lg.RayCityAPI_BanAccount); ds = GlobalAccount.GMAccount_Query(serverIP, account, accountState); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = Message.buildTLV(ds, index, pageSize, false); return(Message.COMMON_MES_RESP(structList, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_GMUser_Query_Resp, (int)structList[0].structLen)); } else { return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_GMUser_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message); return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_GMUser_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 修改玩家停封信息 /// </summary> /// <returns></returns> public Message AccountState_Modify() { int operateUserID = 0; int result = -1; string serverIP = ""; string loginid = ""; int m_id = 0; int m_auth = 0; try { TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer); operateUserID = (int)strut.toInteger(); serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_ServerIP).m_bValueBuffer); loginid = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_loginId).m_bValueBuffer); strut = new TLV_Structure(TagName.Soccer_m_id, 4, msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_m_id).m_bValueBuffer); m_id = (int)strut.toInteger(); strut = new TLV_Structure(TagName.Soccer_m_auth, 4, msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_m_auth).m_bValueBuffer); m_auth = (int)strut.toInteger(); result = SOCCERCharacterInfo.AccountState_Modify(operateUserID, serverIP, loginid, m_id, m_auth); if (result == 0) { SqlHelper.log.WriteLog(lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + loginid + lg.API_Update + lg.Soccer_CharacterInfoAPI_BanInfo + lg.API_Success + "!"); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + loginid + lg.API_Update + lg.Soccer_CharacterInfoAPI_BanInfo + lg.API_Success + "!"); return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ACCOUNTSTATE_MODIFY_RESP)); } else { SqlHelper.log.WriteLog(lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + loginid + lg.API_Update + lg.Soccer_CharacterInfoAPI_BanInfo + lg.API_Failure + "!"); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + loginid + lg.API_Update + lg.Soccer_CharacterInfoAPI_BanInfo + lg.API_Failure + "!"); return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ACCOUNTSTATE_MODIFY_RESP)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ACCOUNTSTATE_MODIFY_RESP)); } }
/// <summary> /// 公告資訊查询 /// </summary> /// <returns></returns> public Message RayCity_BoardList_Query() { string serverIP = null; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Notices); Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Notices); ds = GlobalAccount.BoardList_Query(serverIP); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0])); strut.AddTagKey(TagName.RayCity_NoticeID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[1])); strut.AddTagKey(TagName.RayCity_StartDate, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i][2].ToString())); strut.AddTagKey(TagName.RayCity_EndDate, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i][3].ToString())); strut.AddTagKey(TagName.RayCity_Interval, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[4])); strut.AddTagKey(TagName.RayCity_Repeat, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds.Tables[0].Rows[i].ItemArray[5])); strut.AddTagKey(TagName.RayCity_Message, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds.Tables[0].Rows[i].ItemArray[6])); strut.AddTagKey(TagName.RayCity_use_state, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Query_Resp, 7)); } else { return(Message.COMMON_MES_RESP(lg.RayCityAPI_NoNotices, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message); return(Message.COMMON_MES_RESP(lg.RayCityAPI_NoNotices, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 恢复角色信息 /// </summary> /// <returns></returns> public Message Soccer_CharItems_Recovery() { int operateUserID = 0; int result = -1; string serverIP = ""; int char_idx = 0; try { TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer); operateUserID = (int)strut.toInteger(); serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_ServerIP).m_bValueBuffer); strut = new TLV_Structure(TagName.Soccer_charidx, 4, msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_charidx).m_bValueBuffer); char_idx = (int)strut.toInteger(); result = SOCCERCharacterInfo.Soccer_CharItems_Recovery(operateUserID, serverIP, char_idx); if (result == 0) { SqlHelper.log.WriteLog(lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + char_idx + lg.Soccer_CharacterInfoAPI_Recovery + lg.Soccer_CharacterInfoAPI_Character + lg.API_Update + lg.API_Success + "!"); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + char_idx + lg.Soccer_CharacterInfoAPI_Recovery + lg.Soccer_CharacterInfoAPI_Character + lg.API_Update + lg.API_Success + "!"); return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_CHARITEMS_RECOVERY_QUERY_RESP)); } else { SqlHelper.log.WriteLog(lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + char_idx + lg.Soccer_CharacterInfoAPI_Recovery + lg.Soccer_CharacterInfoAPI_Character + lg.API_Update + lg.API_Failure + "!"); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + char_idx + lg.Soccer_CharacterInfoAPI_Recovery + lg.Soccer_CharacterInfoAPI_Character + lg.API_Update + lg.API_Failure + "!"); return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_CHARITEMS_RECOVERY_QUERY_RESP)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_CHARITEMS_RECOVERY_QUERY_RESP)); } }
/// <summary> /// 查看该玩家的帐号信息 /// </summary> /// <returns></returns> public Message CR_Account_Query() { System.Data.DataSet result = null; string serverIP = ""; string account = ""; string userNick = ""; int action = 0; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_ServerIP).m_bValueBuffer); TLV_Structure tlv = new TLV_Structure(TagName.CR_ACTION, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_ACTION).m_bValueBuffer); action = (int)tlv.toInteger(); if (action == 1) { account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_ACCOUNT).m_bValueBuffer); } else if (action == 2) { userNick = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_NickName).m_bValueBuffer); } SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_AccountInfoAPI_Account + account + lg.CR_AccountInfoAPI_AccountInfo); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_AccountInfoAPI_Account + account + lg.CR_AccountInfoAPI_AccountInfo); result = CRAccountInfo.CR_Account_Query(serverIP, account, userNick, action); if (result != null && result.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[result.Tables[0].Rows.Count]; for (int i = 0; i < result.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure(9); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(result.Tables[0].Rows[0].ItemArray[0])); strut.AddTagKey(TagName.CR_PSTID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);; bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(result.Tables[0].Rows[0].ItemArray[1])); strut.AddTagKey(TagName.CR_Passord, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(result.Tables[0].Rows[0].ItemArray[2])); strut.AddTagKey(TagName.CR_UserID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(result.Tables[0].Rows[0].ItemArray[3])); strut.AddTagKey(TagName.CR_ACCOUNT, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(result.Tables[0].Rows[0].ItemArray[4])); strut.AddTagKey(TagName.CR_NickName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(result.Tables[0].Rows[0].ItemArray[5])); strut.AddTagKey(TagName.CR_SEX, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(result.Tables[0].Rows[0].ItemArray[6])); strut.AddTagKey(TagName.CR_NUMBER, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(result.Tables[0].Rows[0].ItemArray[7])); strut.AddTagKey(TagName.CR_ServerIP, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(result.Tables[0].Rows[0].ItemArray[8])); strut.AddTagKey(TagName.CR_ActiveDate, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.CR_ADMIN, ServiceKey.CR_ACCOUNT_QUERY_RESP, 9)); } else { return(Message.COMMON_MES_RESP(lg.CR_AccountInfoAPI_NoAccount, Msg_Category.CR_ADMIN, ServiceKey.CR_ACCOUNT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception) { return(Message.COMMON_MES_RESP(0, Msg_Category.CR_ADMIN, ServiceKey.CR_ACCOUNT_QUERY_RESP, TagName.CR_STATUS, TagFormat.TLV_INTEGER)); } }
public void checkPropertyBinding(CommonInfo commonInfo) { this.expr.checkPropertyBinding(commonInfo); }
/// <summary> /// 查看该玩家是否被激活 /// </summary> /// <returns></returns> public Message CR_AccountActive_Query() { System.Data.DataSet result = null; int status = -1; string serverIP = "61.129.90.151"; string account = null; string passwd = null; string number = null; try { //serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_ServerIP).m_bValueBuffer); // account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_ACCOUNT).m_bValueBuffer); passwd = account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_Passord).m_bValueBuffer); number = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_NUMBER).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_AccountInfoAPI_Account + account + lg.CR_AccountInfoAPI_ActiveState); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_AccountInfoAPI_Account + account + lg.CR_AccountInfoAPI_ActiveState); result = CRAccountInfo.CR_AccountActive_Query(account, passwd, number); if (result != null && result.Tables[0].Rows.Count > 0) { //密码错误 if (!result.Tables[0].Rows[0].ItemArray[1].Equals(passwd)) { status = 2; byte[] bgMsg_Status = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, status); TLV_Structure Msg_Status = new TLV_Structure(TagName.CR_STATUS, (uint)bgMsg_Status.Length, bgMsg_Status); byte[] baMsg_Pass = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, result.Tables[0].Rows[0].ItemArray[1]); TLV_Structure Msg_Pass = new TLV_Structure(TagName.CR_Passord, (uint)baMsg_Pass.Length, baMsg_Pass); Packet_Body body = new Packet_Body(new TLV_Structure[] { Msg_Status, Msg_Pass }, 2); Packet_Head head = new Packet_Head(SeqID_Generator.Instance().GetNewSeqID(), Msg_Category.CR_ADMIN, ServiceKey.CR_ACCOUNTACTIVE_QUERY_RESP, body.m_uiBodyLen); return(new Message(new Packet(head, body))); } //激活码未被使用过 else if (result.Tables[0].Rows[0].ItemArray[2].Equals("n")) { status = 3; return(Message.COMMON_MES_RESP(status, Msg_Category.CR_ADMIN, ServiceKey.CR_ACCOUNTACTIVE_QUERY, TagName.CR_STATUS, TagFormat.TLV_INTEGER)); } // 激活码已被使用 else if (result.Tables[0].Rows[0].ItemArray[2].Equals("y")) { status = 4; byte[] bgMsg_Status = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, status); TLV_Structure Msg_Status = new TLV_Structure(TagName.CR_STATUS, (uint)bgMsg_Status.Length, bgMsg_Status); byte[] baMsg_Account = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, result.Tables[0].Rows[0].ItemArray[3]); TLV_Structure Msg_Account = new TLV_Structure(TagName.CR_ACCOUNT, (uint)baMsg_Account.Length, baMsg_Account); Packet_Body body = new Packet_Body(new TLV_Structure[] { Msg_Status, Msg_Account }, 2); Packet_Head head = new Packet_Head(SeqID_Generator.Instance().GetNewSeqID(), Msg_Category.CR_ADMIN, ServiceKey.CR_ACCOUNTACTIVE_QUERY_RESP, body.m_uiBodyLen); return(new Message(new Packet(head, body))); } else { return(Message.COMMON_MES_RESP(1, Msg_Category.CR_ADMIN, ServiceKey.CR_ACCOUNTACTIVE_QUERY, TagName.CR_STATUS, TagFormat.TLV_INTEGER)); } /*// 查询帐号未被激活 * else if (!result.Tables[0].Rows[0].ItemArray[3].Equals(account)) * { * status = 5; * } * // 查询帐号已被激活 * else if (result.Tables[0].Rows[0].ItemArray[3].Equals(account)) * { * status = 6; * }*/ } return(Message.COMMON_MES_RESP(1, Msg_Category.CR_ADMIN, ServiceKey.CR_ACCOUNTACTIVE_QUERY, TagName.CR_STATUS, TagFormat.TLV_INTEGER)); } catch (System.Exception) { return(Message.COMMON_MES_RESP(1, Msg_Category.CR_ADMIN, ServiceKey.CR_ACCOUNTACTIVE_QUERY, TagName.CR_STATUS, TagFormat.TLV_INTEGER)); } }
public void checkPropertyBinding(CommonInfo commonInfo) { }
/// <summary> /// calculation /// </summary> /// <param name="table"></param> /// <param name="IllegalDate"></param> /// <returns></returns> public static void HandlerIllegal(DataTable table, string IllegalDate) { try { string token = UserTokenHelper.GetToken(); //handle illegledata #region handle illegledata if (table == null || table.Rows.Count == 0) { LogHelper.WriteInfo(string.Format("违法检测-没有违法统计数据,不进行数据检测,检测时间:{0}", IllegalDate)); return; } LogHelper.WriteInfo(string.Format("违法检测-开始违法检测,检测时间:{0}", IllegalDate)); #region calculation basicdata LogHelper.WriteInfo(string.Format("违法检测-获取检测数据")); //1.basic string getSvgSql = string.Format("select * from p_IllegalMonitor order by SpottingId "); //SQLiteParameter para = new SQLiteParameter(DbType.String, "") { Value=""}; List <IllegalMonitorModel> svglist = DbHelper.GetList <IllegalMonitorModel>(getSvgSql, null); //2.yesterday string yesDate = Convert.ToDateTime(IllegalDate).AddDays(-1).ToString("yyyy-MM-dd"); string getyesData = string.Format("select * from PUNISH_ILLEGALVEHICLECOUNT where OCCERDATE='{0}'", yesDate); DataTable yestable = new DataTable(); using (OracleConnection conn = new OracleConnection(ConfigManage.SysConfig.DbConn)) { OracleDataAdapter sda = new OracleDataAdapter(getyesData, conn); sda.Fill(yestable); } List <IllegalVehicleCount> yesDataList = DataTableListHelper.ToList <IllegalVehicleCount>(yestable); //3.lastweek string lastweekDate = Convert.ToDateTime(IllegalDate).AddDays(-7).ToString("yyyy-MM-dd"); string getlastweekData = string.Format("select * from PUNISH_ILLEGALVEHICLECOUNT where OCCERDATE='{0}'", lastweekDate); DataTable lastweektable = new DataTable(); using (OracleConnection conn = new OracleConnection(ConfigManage.SysConfig.DbConn)) { OracleDataAdapter sda = new OracleDataAdapter(getlastweekData, conn); sda.Fill(lastweektable); } List <IllegalVehicleCount> lastweekDataList = DataTableListHelper.ToList <IllegalVehicleCount>(lastweektable); #endregion foreach (DataRow item in table.Rows) { string SpottingId = item["SPOTTINGID"].ToString(); try { #region illegal compute string IllegalTypeNo = item["ILLEGALTYPENO"].ToString(); string LegalizeIllegalTypeNo = item["LEGALIZEILLEGALTYPENO"].ToString(); int IllegalCount = Convert.ToInt32(item["COUNT"].ToString()); //find illegl svg IllegalMonitorModel model = svglist.Where(p => p.SpottingId == SpottingId && p.IllegalTypeNo == IllegalTypeNo && p.LegalizeIllegalTypeNo == LegalizeIllegalTypeNo).FirstOrDefault(); IllegalVehicleCount yesCount = yesDataList.Where(p => p.SpottingId == SpottingId && p.IllegalTypeNo == IllegalTypeNo && p.LegalIzeIllegalTypeNo == LegalizeIllegalTypeNo).FirstOrDefault(); IllegalVehicleCount lastweekCount = lastweekDataList.Where(p => p.SpottingId == SpottingId && p.IllegalTypeNo == IllegalTypeNo && p.LegalIzeIllegalTypeNo == LegalizeIllegalTypeNo).FirstOrDefault(); //calculation #region if (model == null) { LogHelper.WriteInfo( string.Format("违法检测-检测路口:{0},检测违法自定义编号:{1},标准代码{2},不存在比对基础", SpottingId, IllegalTypeNo, LegalizeIllegalTypeNo)); } else { LogHelper.WriteInfo( string.Format("违法检测-检测路口:{0},检测违法自定义编号:{1},标准代码{2},存在比对基础", SpottingId, IllegalTypeNo, LegalizeIllegalTypeNo)); } #endregion #region int H = 0, L = 0, X = IllegalCount; decimal V = 0, Ho = 0, Ao = 0, Lo = 0, Bo = 0, Vo = 0, Co = 0; if (model == null && yesCount == null && lastweekCount == null) { LogHelper.WriteInfo( string.Format("违法检测-数据不进行检测比对,所有比对基础参数无法获得" + SpottingId)); continue; } if (model != null) { Ho = model.SvgH; Lo = model.SvgL; Vo = model.SvgV; V = model.SvgC; } else { V = X; } if (lastweekCount == null) { H = X; } else { H = Convert.ToInt32(lastweekCount.Count); } if (yesCount == null) { L = X; } else { L = Convert.ToInt32(yesCount.Count); } if (model != null && yesCount != null && lastweekCount != null) { Ao = 0.20m; Bo = 0.35m; Co = 0.45m; } else if (model != null && yesCount != null) { Ao = 0.00m; Bo = 0.40m; Co = 0.60m; } else if (model != null && lastweekCount != null) { Ao = 0.30m; Bo = 0.00m; Co = 0.70m; } else if (yesCount != null && lastweekCount != null) { Ao = 0.25m; Bo = 0.75m; Co = 0.00m; } else if (yesCount != null) { Ao = 0.00m; Bo = 1.00m; Co = 0.00m; } else if (lastweekCount != null) { Ao = 1.00m; Bo = 0.00m; Co = 0.00m; } else if (model != null) { Ao = 0.00m; Bo = 0.00m; Co = 1.00m; } #endregion LogHelper.WriteInfo( string.Format(SpottingId + "违法检测-该路口检测中,检测参数为:X:{0},H:{1},L:{2},V:{3},Ho:{4},Lo:{5},Vo:{6},Ao:{7},Bo:{8},Co:{9}", X, H, L, V, Ho, Lo, Vo, Ao, Bo, Co)); decimal fx = ((Math.Abs((decimal)Math.Abs(X - H) / (decimal)H - Ho)) * Ao) + ((Math.Abs((decimal)Math.Abs(X - L) / (decimal)L - Lo)) * Bo) + ((Math.Abs((decimal)Math.Abs(X - V) / (decimal)V - Vo)) * Co); //update model #region string sql = string.Empty; SQLiteParameter[] paras; if (model == null) { decimal h = lastweekCount == null ? 1.00m : ((decimal)Math.Abs(X - H)) / (decimal)H; decimal l = yesCount == null ? 1.00m : ((decimal)Math.Abs(X - L)) / (decimal)L; sql = @"insert into p_IllegalMonitor(Id,SpottingId,IllegalTypeNo,LegalizeIllegalTypeNo,SvgC,SvgH,SvgL,SvgV,UpdateDate,Remark) values(@Id,@SpottingId,@IllegalTypeNo,@LegalizeIllegalTypeNo,@SvgC,@SvgH,@SvgL,@SvgV,@UpdateDate,@Remark)"; paras = new SQLiteParameter[] { new SQLiteParameter("@Id", DbType.String) { Value = Guid.NewGuid().ToString("N") }, new SQLiteParameter("@SpottingId", DbType.String) { Value = SpottingId }, new SQLiteParameter("@IllegalTypeNo", DbType.String) { Value = IllegalTypeNo }, new SQLiteParameter("@LegalizeIllegalTypeNo", DbType.String) { Value = LegalizeIllegalTypeNo }, new SQLiteParameter("@SvgC", DbType.Decimal) { Value = IllegalCount }, new SQLiteParameter("@SvgH", DbType.Decimal) { Value = h }, new SQLiteParameter("@SvgL", DbType.Decimal) { Value = l }, new SQLiteParameter("@SvgV", DbType.Decimal) { Value = ((decimal)Math.Abs(X - V)) / (decimal)V }, new SQLiteParameter("@UpdateDate", DbType.DateTime) { Value = DateTime.Now }, new SQLiteParameter("@Remark", DbType.String) { Value = string.Empty } }; } else { decimal sv = model.SvgV == 0.00m ? (((decimal)Math.Abs(X - V)) / (decimal)V) : ((decimal)model.SvgV + ((decimal)Math.Abs(X - V)) / (decimal)V) / (decimal)2; sql = @"update p_IllegalMonitor set SvgC=@SvgC,SvgH=@SvgH,SvgL=@SvgL,SvgV=@SvgV,UpdateDate=@UpdateDate where Id=@Id"; paras = new SQLiteParameter[] { new SQLiteParameter("@Id", DbType.String) { Value = model.Id }, new SQLiteParameter("@SvgC", DbType.Decimal) { Value = (decimal)(model.SvgC + IllegalCount) / (decimal)2 }, new SQLiteParameter("@SvgH", DbType.Decimal) { Value = ((decimal)model.SvgH + ((decimal)Math.Abs(X - H)) / (decimal)H) / (decimal)2 }, new SQLiteParameter("@SvgL", DbType.Decimal) { Value = ((decimal)model.SvgL + ((decimal)Math.Abs(X - L)) / (decimal)L) / (decimal)2 }, new SQLiteParameter("@SvgV", DbType.Decimal) { Value = sv }, new SQLiteParameter("@UpdateDate", DbType.DateTime) { Value = DateTime.Now } }; } int result = DbHelper.InsertValue(sql, paras); #endregion #region send message bool isSend = true; var count = IllegalCount + IllegalCount * fx; if (count <= ConfigManage.SysConfig.FloatingRange && IllegalCount <= ConfigManage.SysConfig.FloatingRange) { isSend = false; } if (Math.Round(Math.Abs(fx), 2) > Math.Round(ConfigManage.SysConfig.NoticePercent, 2) && isSend) { LogHelper.WriteInfo( string.Format(SpottingId + "违法检测-该路口增/减比例超过设定比例,检测值{0},设置比例{1},进行报警,发送消息。", fx, ConfigManage.SysConfig.NoticePercent)); Spotting spo = CommonInfo.GetSpottingName(SpottingId); //api var SysMessage = new SysMessage { MessageId = Guid.NewGuid().ToString("N"), Content = string.Format("违法每日检测,检测违法日期:{7},路口:{5}(编号:{6},Id:{0}),标准违法代码:{1},自定义违法代码:{2},违法数量:{4},检测浮动比例:{3}", SpottingId, LegalizeIllegalTypeNo, IllegalTypeNo, fx.ToString("p2"), IllegalCount, spo == null ? SpottingId + "?" : spo.SpottingName, spo == null ? SpottingId + "?" : spo.SpottingNo, IllegalDate), Sender = "admin", NoticeType = "IllegalDailyStatistics", FromType = "每日违法检测工具" }; using (var httpClient = new HttpClient()) { if (!string.IsNullOrEmpty(token)) { try { httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", token); var responseJson = httpClient.PostAsync(ConfigManage.SysConfig.ApiAddress, SysMessage, new System.Net.Http.Formatting.JsonMediaTypeFormatter()).Result.Content.ReadAsAsync <ApiResult <string> >().Result; if (!responseJson.HasError) { LogHelper.WriteInfo( string.Format(SpottingId + "违法检测-消息推送完成,消息:{0}", JsonConvert.SerializeObject(SysMessage))); } else { LogHelper.WriteInfo( string.Format(SpottingId + "违法检测-消息推送错误,错误:{0}", responseJson.Message)); } } catch (Exception e) { LogHelper.WriteInfo( string.Format(SpottingId + "违法检测-消息推送异常,异常:{0}", e.ToString())); } } else { LogHelper.WriteInfo( string.Format(SpottingId + "违法检测-IMS Token获取失败")); } } } #endregion LogHelper.WriteInfo( string.Format(SpottingId + "违法检测-该路口检测完毕,检测值为:{0}", fx)); #endregion } catch (Exception e) { LogHelper.WriteInfo(string.Format("违法检测异常:路口-{0}", SpottingId)); } } #endregion } catch (Exception e) { LogHelper.Error(string.Format("违法检测-检测异常:{0}", e.ToString())); } }
/// <summary> /// 查看玩家礼物盒的道具 /// </summary> /// <returns></returns> public Message giftBox_Query(int index, int pageSize) { string serverIP = null; string userID = null; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ServerIP).m_bValueBuffer); userID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_UserID).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem); //请求所有分类道具列表 ds = ItemShopInfo.O2JAM2GiftBox_Query(serverIP, userID); if (ds != null && ds.Tables[0].Rows.Count > 0) { //总页数 int pageCount = 0; pageCount = ds.Tables[0].Rows.Count % pageSize; if (pageCount > 0) { pageCount = ds.Tables[0].Rows.Count / pageSize + 1; } else { pageCount = ds.Tables[0].Rows.Count / pageSize; } if (index + pageSize > ds.Tables[0].Rows.Count) { pageSize = ds.Tables[0].Rows.Count - index; } Query_Structure[] structList = new Query_Structure[pageSize]; for (int i = index; i < index + pageSize; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1); //道具编号 byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.O2JAM2_ItemCode, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //道具名 object itemName; if (ds.Tables[0].Rows[i].IsNull(1) == false) { itemName = ds.Tables[0].Rows[i].ItemArray[1]; } else { itemName = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, itemName); strut.AddTagKey(TagName.O2JAM2_ItemName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); //使用次数 int timeslimits = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2]); if (timeslimits == -1) { timeslimits = 0; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, timeslimits); strut.AddTagKey(TagName.O2JAM2_DayLimit, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //使用期限 int dayslimits = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]); if (dayslimits == -1) { dayslimits = 0; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, dayslimits); strut.AddTagKey(TagName.O2JAM2_DayLimit, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //主题 object title; if (ds.Tables[0].Rows[i].IsNull(4) == false) { title = ds.Tables[0].Rows[i].ItemArray[4]; } else { title = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, title); strut.AddTagKey(TagName.O2JAM2_Title, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); //内容 object context; if (ds.Tables[0].Rows[i].IsNull(5) == false) { context = ds.Tables[0].Rows[i].ItemArray[5]; } else { context = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, context); strut.AddTagKey(TagName.O2JAM2_Context, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); //赠送日期 object sendDate; if (ds.Tables[0].Rows[i].IsNull(6) == false) { sendDate = ds.Tables[0].Rows[i].ItemArray[6]; } else { sendDate = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, sendDate); strut.AddTagKey(TagName.SDO_SendTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); //总页数 strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount)); structList[i - index] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_MESSAGE_QUERY_RESP, 8)); } else { return(Message.COMMON_MES_RESP(lg.O2JAM2API_ItemShopAPI_NoGiftItem, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_MESSAGE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(lg.O2JAM2API_AccountInfoAPI_NoAccount, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_MESSAGE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
private void OnCommon(CommonInfo e) { if (onCommonEvent != null) onCommonEvent(this, e); }
/// <summary> /// 添加玩家礼物盒上的道具 /// </summary> /// <returns></returns> public Message GiftBox_MessageItem_Add() { int operateUserID = 0; string userID = null; string serverIP = null; int itemCode = 0; string title = null; string context = null; int timesLimit = 0; int dayLimit = 0; int result = -1; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ServerIP).m_bValueBuffer); TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer); operateUserID = (int)strut.toInteger(); strut = new TLV_Structure(TagName.O2JAM2_ItemCode, 4, msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ItemCode).m_bValueBuffer); itemCode = (int)strut.toInteger(); userID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_UserID).m_bValueBuffer); strut = new TLV_Structure(TagName.O2JAM2_Timeslimt, 4, msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_Timeslimt).m_bValueBuffer); timesLimit = (int)strut.toInteger(); strut = new TLV_Structure(TagName.O2JAM2_DayLimit, 4, msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_DayLimit).m_bValueBuffer); dayLimit = (int)strut.toInteger(); title = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_Title).m_bValueBuffer); context = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_Context).m_bValueBuffer); result = ItemShopInfo.giftBox_Insert(operateUserID, serverIP, userID, itemCode, title, context, timesLimit, dayLimit); if (result == 1) { SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem + itemCode + lg.API_Add + lg.API_Success + "!"); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem + itemCode + lg.API_Add + lg.API_Success + "!"); return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_MESSAGE_CREATE_RESP)); } else { SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem + itemCode + lg.API_Add + lg.API_Failure + "!"); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + userID + lg.O2JAM2API_ItemShopAPI_GiftItem + itemCode + lg.API_Add + lg.API_Failure + "!"); return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_MESSAGE_CREATE_RESP)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(lg.O2JAM2API_AccountInfoAPI_NoAccount, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_MESSAGE_CREATE_RESP)); } }
/// <summary> /// 重置玩家初始位置 /// </summary> /// <returns></returns> public Message SetResetPos() { string serverIP = null; string account = null; int operateUserID = 0; int characterID = 0; int result = -1; try { account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_NyUserID).m_bValueBuffer); TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer); operateUserID = (int)strut.toInteger(); serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer); strut = new TLV_Structure(TagName.RayCity_CharacterID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_CharacterID).m_bValueBuffer); characterID = (int)strut.toInteger(); result = CharacterInfo.SetResetPos(operateUserID, serverIP, account, characterID); if (result == 1) { SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Again + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_firstAddress + lg.API_Success); Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_firstAddress + lg.API_Success); return(Message.COMMON_MES_RESP("SUCCESS", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_SetPos_Update_Resp)); } else { SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Again + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_firstAddress + lg.API_Failure); Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_firstAddress + lg.API_Failure); return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_SetPos_Update_Resp)); } } catch (System.Exception ex) { SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message); return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_ConnectionState_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
public static string Parse(string transId, string invoice, string POrderno, int responseCode, int responsereasonCode, string responsetext, int storeID, int portalID, string userName, int customerID, string sessionCode) { try { OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = storeID; cf.PortalID = portalID; cf.AddedBy = userName; AspxOrderDetails objad = new AspxOrderDetails(); SQLHandler sqlH = new SQLHandler(); odinfo.OrderID = int.Parse(HttpContext.Current.Session["OrderID"].ToString()); odinfo.TransactionID = odinfo.ResponseCode.ToString(transId); odinfo.InvoiceNumber = Convert.ToString(invoice); odinfo.PurchaseOrderNumber = Convert.ToString(POrderno); odinfo.ResponseCode = Convert.ToInt32(responseCode); odinfo.ResponseReasonCode = Convert.ToInt32(responsereasonCode); odinfo.ResponseReasonText = Convert.ToString(responsetext); ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; objad.UpdateOrderDetails(ot); if (HttpContext.Current.Session["OrderCollection"] != null) { OrderDetailsCollection orderdata2 = new OrderDetailsCollection(); orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; objad.UpdateItemQuantity(orderdata2); } HttpContext.Current.Session.Remove("OrderID"); return "This transaction has been approved"; } catch (Exception ex) { throw ex; } }
/// <summary> /// 批量創建帳號 /// </summary> /// <returns></returns> public Message PlayerAccount_Create() { string serverIP = null; string account = null; int operateUserID = 0; string NyUserID = null; string NyPassWD = null; int startNum = 0; int endNum = 0; int result = -1; try { TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer); operateUserID = (int)strut.toInteger(); serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer); NyUserID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_NyUserID).m_bValueBuffer); NyPassWD = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_NyPassword).m_bValueBuffer); strut = new TLV_Structure(TagName.RayCity_StartNum, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_StartNum).m_bValueBuffer); startNum = (int)strut.toInteger(); strut = new TLV_Structure(TagName.RayCity_EndNum, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_EndNum).m_bValueBuffer); endNum = (int)strut.toInteger(); result = CharacterInfo.CreatePlayerAccount(operateUserID, serverIP, NyUserID, NyPassWD, startNum, endNum); if (result == 1) { SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.API_Create + lg.RayCityAPI_Account + lg.RayCityAPI_Char + NyUserID + lg.API_From + startNum + lg.API_To + endNum + lg.API_Success); Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.API_Create + lg.RayCityAPI_Account + lg.RayCityAPI_Char + NyUserID + lg.API_From + startNum + lg.API_To + endNum + lg.API_Success); return(Message.COMMON_MES_RESP("SUCCESS", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_PlayerAccount_Create_Resp)); } else { SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.API_Create + lg.RayCityAPI_Account + lg.RayCityAPI_Char + NyUserID + lg.API_From + startNum + lg.API_To + endNum + lg.API_Failure); Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.API_Create + lg.RayCityAPI_Account + lg.RayCityAPI_Char + NyUserID + lg.API_From + startNum + lg.API_To + endNum + lg.API_Failure); return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_PlayerAccount_Create_Resp)); } } catch (System.Exception ex) { SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message); return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_PlayerAccount_Create_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
void OnEnable() { m_ComInfoScript = m_ComInfo.GetComponent<CommonInfo>(); }
/// <summary> /// 玩家排行榜 /// </summary> /// <returns></returns> public Message PlayerSkill_Query() { string serverIP = null; int accountID = 0; int characterID = 0; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer); TLV_Structure strut = new TLV_Structure(TagName.RayCity_AccountID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_AccountID).m_bValueBuffer); accountID = (int)strut.toInteger(); strut = new TLV_Structure(TagName.RayCity_CharacterID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_CharacterID).m_bValueBuffer); characterID = (int)strut.toInteger(); SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_AccountInfo); Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_AccountInfo); ds = CharacterInfo.characterInfo_Query(serverIP, characterID, accountID); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = Message.buildTLV(ds, 0, 1, false); return(Message.COMMON_MES_RESP(structList, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_Character_Query_Resp, (int)structList[0].structLen)); } else { return(Message.COMMON_MES_RESP(lg.RayCityAPI_NoAccountInfo, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_Character_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message); return(Message.COMMON_MES_RESP(lg.RayCityAPI_NoAccountInfo, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_Character_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
// Use this for initialization void Start() { m_ComInfoScript = m_ComInfo.GetComponent<CommonInfo>(); Physics.gravity = new Vector3(0.0f,-4.9f,0.0f); m_fBallTimer = 0.0f; m_tGameMode.Start(); }
public void ParseAfterIPN(string postData, AspxCommonInfo aspxCommonObj, string templateName, string addressPath) { var ph = new PayPalHandler(); string transId = string.Empty; string orderStatus = string.Empty; try { //split response into string array using whitespace delimeter String[] stringArray = postData.Split('\n'); // NOTE: /* * loop is set to start at 1 rather than 0 because first * string in array will be single word SUCCESS or FAIL * Only used to verify post data */ var ot = new OrderDetailsCollection(); var odinfo = new OrderDetailsInfo(); var cms = new CartManageSQLProvider(); var cf = new CommonInfo { StoreID = aspxCommonObj.StoreID, PortalID = aspxCommonObj.PortalID, AddedBy = aspxCommonObj.UserName }; // UpdateOrderDetails var sqlH = new OracleHandler(); // use split to split array we already have using "=" as delimiter int i; for (i = 1; i < stringArray.Length - 1; i++) { String[] stringArray1 = stringArray[i].Split('='); String sKey = stringArray1[0]; String sValue = HttpUtility.UrlDecode(stringArray1[1]); // set string vars to hold variable names using a switch switch (sKey) { case "payment_status": odinfo.ResponseReasonText = Convert.ToString(sValue); orderStatus = Convert.ToString(sValue); break; case "mc_fee": // ph.PaymentFee = Convert.ToDouble(sValue); break; case "payer_email": // ph.PayerEmail = Convert.ToString(sValue); break; case "Tx Token": // ph.TxToken = Convert.ToString(sValue); break; case "txn_id": odinfo.TransactionID = Convert.ToString(sValue); transId = Convert.ToString(sValue); break; } } ot.ObjCommonInfo = cf; //odinfo.OrderStatusID = 8; //objad.UpdateOrderDetails(ot); if (odinfo.ResponseReasonText.ToLower().Trim() == "completed") { if (HttpContext.Current.Session["OrderCollection"] != null) { var orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; AspxOrderController.UpdateItemQuantity(orderdata2); } } cms.ClearCartAfterPayment(aspxCommonObj); //invoice transID if (HttpContext.Current.Session["OrderCollection"] != null) { var orderdata = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; orderdata.ObjOrderDetails.OrderStatus = orderStatus; EmailTemplate.SendEmailForOrder(aspxCommonObj.PortalID, orderdata, addressPath, templateName, transId); } HttpContext.Current.Session.Remove("OrderCollection"); } catch (Exception ex) { throw ex; } }