public static bool OpenSchedule(string dbName, int userId, string macAddress, string diskId, string workStation, out int currentSchedule, out string errMsg)
{
errMsg = string.Empty;
string checkDate = System.DateTime.Now.ToString("yyyy-MM-dd");
string sql = "OpenSchedule";
SqlParameter[] parameters = new SqlParameter[8];
parameters[0] = new SqlParameter("@CheckDate", checkDate);
parameters[1] = new SqlParameter("@UserId", userId);
parameters[2] = new SqlParameter("@macAddress", macAddress);
parameters[3] = new SqlParameter("@diskId", diskId);
parameters[4] = new SqlParameter("@workStation", workStation);
parameters[5] = new SqlParameter("@CurrentSchedule", 0);
parameters[5].Direction = System.Data.ParameterDirection.Output;
parameters[6] = new SqlParameter("@OffLineUserId", 0);
parameters[6].Direction = System.Data.ParameterDirection.Output;
parameters[7] = new SqlParameter("@ReturnValue", 0);
parameters[7].Direction = System.Data.ParameterDirection.ReturnValue;
XCGameBLL.ExecuteStoredProcedureSentence(sql, dbName, parameters);
int result = Convert.ToInt32(parameters[6].Value);
if (result >= 1)
{
currentSchedule = Convert.ToInt32(parameters[5].Value);
return(true);
}
else
{
errMsg = "开班出现错误";
currentSchedule = 0;
return(false);
}
}
public object transICCardCoins(Dictionary <string, object> dicParas)
{
XCCloudManaUserTokenModel userTokenModel = (XCCloudManaUserTokenModel)(dicParas[Constant.XCGameManaUserToken]);
string cardIdOut = dicParas.ContainsKey("cardIdOut") ? dicParas["cardIdOut"].ToString() : string.Empty;
string cardIdOutPassword = dicParas.ContainsKey("cardIdOutPassword") ? dicParas["cardIdOutPassword"].ToString() : string.Empty;
string cardIdIn = dicParas.ContainsKey("cardIdIn") ? dicParas["cardIdIn"].ToString() : string.Empty;
string coins = dicParas.ContainsKey("coins") ? dicParas["coins"].ToString() : string.Empty;
string mobileName = dicParas.ContainsKey("mobileName") ? dicParas["mobileName"].ToString() : string.Empty;
StoreBusiness store = new StoreBusiness();
string errMsg = string.Empty;
StoreCacheModel storeModel = null;
StoreBusiness storeBusiness = new StoreBusiness();
if (!storeBusiness.IsEffectiveStore(userTokenModel.StoreId, ref storeModel, out errMsg))
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
if (storeModel.StoreDBDeployType == 0)
{
string storeProc = "TransICCardCoins";
SqlParameter[] parameters = new SqlParameter[8];
parameters[0] = new SqlParameter("@CardIdOut", cardIdOut);
parameters[1] = new SqlParameter("@CardIdOutPassword", cardIdOutPassword);
parameters[2] = new SqlParameter("@CardIdIn", cardIdIn);
parameters[3] = new SqlParameter("@Coins", coins);
parameters[4] = new SqlParameter("@UserId", userTokenModel.XCGameUserId);
parameters[5] = new SqlParameter("@Mobile", userTokenModel.Mobile);
parameters[6] = new SqlParameter("@ErrMsg", System.Data.SqlDbType.VarChar, 200);
parameters[6].Direction = System.Data.ParameterDirection.Output;
parameters[7] = new SqlParameter("@Return", 0);
parameters[7].Direction = System.Data.ParameterDirection.ReturnValue;
XCGameBLL.ExecuteStoredProcedureSentence(storeProc, storeModel.StoreDBName, parameters);
if (Convert.ToInt32(parameters[7].Value) == 1)
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, parameters[6].Value.ToString()));
}
}
else if (storeModel.StoreDBDeployType == 1)
{
string sn = System.Guid.NewGuid().ToString().Replace("-", "");
UDPSocketCommonQueryAnswerModel answerModel = null;
string radarToken = string.Empty;
if (DataFactory.SendMemberTransOperate(sn, storeModel.StoreID.ToString(), storeModel.StorePassword, mobileName, userTokenModel.Mobile, cardIdIn, cardIdOut, int.Parse(coins), out radarToken, out errMsg))
{
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg));
}
answerModel = null;
int whileCount = 0;
while (answerModel == null && whileCount <= 25)
{
//获取应答缓存数据
whileCount++;
System.Threading.Thread.Sleep(1000);
answerModel = UDPSocketCommonQueryAnswerBusiness.GetAnswerModel(sn, 1);
}
if (answerModel != null)
{
MemberTransOperateResultNotifyRequestModel model = (MemberTransOperateResultNotifyRequestModel)(answerModel.Result);
//移除应答缓存数据
UDPSocketCommonQueryAnswerBusiness.Remove(sn);
if (model.Result_Code == "1")
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.T, ""));
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, model.Result_Msg));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "系统没有响应"));
}
}
else
{
return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店设置错误"));
}
}