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;
}
}
