public object checkOpenCard(Dictionary <string, object> dicParas) { XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty; string mobile = dicParas.ContainsKey("mobile") ? dicParas["mobile"].ToString() : string.Empty; if (!userTokenDataModel.StoreId.Equals(storeId)) { ResponseModel responseModel = new ResponseModel(Return_Code.T, "", Result_Code.F, "门店信息不正确"); return(responseModel); } string storedProcedure = "CheckStoreCanOpenCard"; SqlParameter[] sqlParameter = new SqlParameter[4]; sqlParameter[0] = new SqlParameter("@StoreId", SqlDbType.VarChar, 15); sqlParameter[0].Value = storeId; sqlParameter[1] = new SqlParameter("@Mobile", SqlDbType.VarChar, 11); sqlParameter[1].Value = mobile; sqlParameter[2] = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 200); sqlParameter[2].Direction = ParameterDirection.Output; sqlParameter[3] = new SqlParameter("@Return", SqlDbType.Int); sqlParameter[3].Direction = ParameterDirection.ReturnValue; XCCloudBLL.ExecuteStoredProcedureSentence(storedProcedure, sqlParameter); if (sqlParameter[3].Value.ToString() == "1") { return(new ResponseModel(Return_Code.T, "", Result_Code.T, "")); } else { return(new ResponseModel(Return_Code.T, "", Result_Code.F, sqlParameter[2].Value.ToString())); } }
public object getMemberRepeatCode(Dictionary <string, object> dicParas) { XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty; string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty; if (string.IsNullOrEmpty(storeId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店号不能为空")); } StoreInfoCacheModel storeInfo = null; if (!XCCloudStoreBusiness.IsEffectiveStore(storeId, ref storeInfo)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店号无效")); } if (string.IsNullOrEmpty(icCardId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员卡号无效")); } //获取会员信息 string storedProcedure = "GetMemberRepeatCode"; SqlParameter[] parameters = new SqlParameter[5]; parameters[0] = new SqlParameter("@ICCardID", icCardId); parameters[1] = new SqlParameter("@StoreID", storeId); parameters[2] = new SqlParameter("@RepeatCode", SqlDbType.Int); parameters[2].Direction = System.Data.ParameterDirection.Output; parameters[3] = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 200); parameters[3].Direction = System.Data.ParameterDirection.Output; parameters[4] = new SqlParameter("@Return", SqlDbType.Int); parameters[4].Direction = System.Data.ParameterDirection.ReturnValue; XCCloudBLL.ExecuteStoredProcedureSentence(storedProcedure, parameters); if (parameters[4].Value.ToString() == "1") { var obj = new { repeatCode = parameters[2].Value.ToString() }; return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj)); } else { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员卡无效")); } }
//开通班次 public static bool OpenSchedule(string storeId, int userId, string scheduleName, string workStation, out int currentSchedule, out string openTime, out string errMsg) { errMsg = string.Empty; string checkDate = System.DateTime.Now.ToString("yyyy-MM-dd"); string sql = "OpenSchedule"; SqlParameter[] parameters = new SqlParameter[9]; parameters[0] = new SqlParameter("@CheckDate", checkDate); parameters[1] = new SqlParameter("@StoreId", storeId); parameters[2] = new SqlParameter("@UserId", userId); parameters[3] = new SqlParameter("@scheduleName", scheduleName); parameters[4] = new SqlParameter("@workStation", workStation); parameters[5] = new SqlParameter("@CurrentSchedule", 0); parameters[5].Direction = System.Data.ParameterDirection.Output; parameters[6] = new SqlParameter("@OpenTime", System.Data.SqlDbType.VarChar, 20); parameters[6].Direction = System.Data.ParameterDirection.Output; parameters[7] = new SqlParameter("@ErrMsg", System.Data.SqlDbType.VarChar, 50); parameters[7].Direction = System.Data.ParameterDirection.Output; parameters[8] = new SqlParameter("@ReturnValue", 0); parameters[8].Direction = System.Data.ParameterDirection.ReturnValue; XCCloudBLL.ExecuteStoredProcedureSentence(sql, parameters); int result = Convert.ToInt32(parameters[8].Value); if (result >= 1) { currentSchedule = Convert.ToInt32(parameters[5].Value); openTime = parameters[6].Value.ToString(); return(true); } else { errMsg = parameters[7].Value.ToString(); currentSchedule = 0; openTime = string.Empty; return(false); } }
public object payOrder(Dictionary <string, object> dicParas) { string errMsg = string.Empty; string orderFlwId = dicParas.ContainsKey("orderFlwId") ? dicParas["orderFlwId"].ToString() : string.Empty; string openICCardId = dicParas.ContainsKey("openICCardId") ? dicParas["openICCardId"].ToString() : string.Empty; string workStation = dicParas.ContainsKey("workStation") ? dicParas["workStation"].ToString() : string.Empty; string authorId = dicParas.ContainsKey("authorId") ? dicParas["authorId"].ToString() : string.Empty; string realPay = dicParas.ContainsKey("realPay") ? dicParas["realPay"].ToString() : string.Empty; XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); if (string.IsNullOrEmpty(orderFlwId)) { return(new ResponseModel(Return_Code.T, "", Result_Code.F, "订单Id参数无效")); } if (!Utils.IsNumeric(openICCardId) || int.Parse(openICCardId) < 0) { return(new ResponseModel(Return_Code.T, "", Result_Code.F, "开通卡号参数无效")); } if (!Utils.IsNumeric(authorId) || int.Parse(authorId) < 0) { return(new ResponseModel(Return_Code.T, "", Result_Code.F, "授权Id无效")); } if (string.IsNullOrEmpty(workStation)) { return(new ResponseModel(Return_Code.T, "", Result_Code.F, "工作站参数无效")); } if (!Utils.IsNumeric(realPay) && decimal.Parse(realPay) <= 0) { return(new ResponseModel(Return_Code.T, "", Result_Code.F, "实付金额无效")); } string storedProcedure = "FinishOrderPayment"; SqlParameter[] sqlParameter = new SqlParameter[9]; sqlParameter[0] = new SqlParameter("@StoreID", SqlDbType.VarChar); sqlParameter[0].Value = userTokenDataModel.StoreId; sqlParameter[1] = new SqlParameter("@OrderFlwId", SqlDbType.Int); sqlParameter[1].Value = orderFlwId; sqlParameter[2] = new SqlParameter("@OpenICCardId", SqlDbType.Int); sqlParameter[2].Value = openICCardId; sqlParameter[3] = new SqlParameter("@RealPay", SqlDbType.Decimal); sqlParameter[3].Value = realPay; sqlParameter[4] = new SqlParameter("@UserID", SqlDbType.Int); sqlParameter[4].Value = userTokenModel.LogId; sqlParameter[5] = new SqlParameter("@WorkStation", SqlDbType.VarChar); sqlParameter[5].Value = workStation; sqlParameter[6] = new SqlParameter("@AuthorID", SqlDbType.Int); sqlParameter[6].Value = authorId; sqlParameter[7] = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 200); sqlParameter[7].Direction = ParameterDirection.Output; sqlParameter[8] = new SqlParameter("@Return", SqlDbType.Int); sqlParameter[8].Direction = ParameterDirection.ReturnValue; XCCloudBLL.ExecuteStoredProcedureSentence(storedProcedure, sqlParameter); if (sqlParameter[8].Value.ToString() == "1") { return(new ResponseModel(Return_Code.T, "", Result_Code.T, "")); } else { return(new ResponseModel(Return_Code.T, "", Result_Code.F, sqlParameter[7].Value.ToString())); } }
public object addOrder(Dictionary <string, object> dicParas) { string errMsg = string.Empty; XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); if (!CheckAddOrderParams(dicParas, out errMsg)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, errMsg)); } string buyDetailsJson = dicParas.ContainsKey("buyDetails") ? dicParas["buyDetails"].ToString() : string.Empty; List <OrderBuyDetailModel> buyDetailList = Utils.DataContractJsonDeserializer <List <OrderBuyDetailModel> >(buyDetailsJson); string customerType = dicParas.ContainsKey("customerType") ? dicParas["customerType"].ToString() : string.Empty; string memberLevelId = dicParas.ContainsKey("memberLevelId") ? dicParas["memberLevelId"].ToString() : string.Empty; //string foodCount = dicParas.ContainsKey("foodCount") ? dicParas["foodCount"].ToString() : string.Empty; //string goodCount = dicParas.ContainsKey("goodCount") ? dicParas["goodCount"].ToString() : string.Empty; string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty; string payCount = dicParas.ContainsKey("payCount") ? dicParas["payCount"].ToString() : string.Empty; string freePay = dicParas.ContainsKey("freePay") ? dicParas["freePay"].ToString() : string.Empty; string realPay = dicParas.ContainsKey("realPay") ? dicParas["realPay"].ToString() : string.Empty; string scheduleId = dicParas.ContainsKey("scheduleId") ? dicParas["scheduleId"].ToString() : string.Empty; string workStation = dicParas.ContainsKey("workStation") ? dicParas["workStation"].ToString() : string.Empty; string authorId = dicParas.ContainsKey("authorId") ? dicParas["authorId"].ToString() : string.Empty; string note = dicParas.ContainsKey("note") ? dicParas["note"].ToString() : string.Empty; string orderSource = dicParas.ContainsKey("orderSource") ? dicParas["orderSource"].ToString() : string.Empty; string saleCoinType = dicParas.ContainsKey("saleCoinType") ? dicParas["saleCoinType"].ToString() : string.Empty; string mobile = dicParas.ContainsKey("mobile") ? dicParas["mobile"].ToString() : string.Empty; string storedProcedure = "CreateOrder"; String[] Ary = new String[] { "数据0", "数据1", "数据2", "数据3" }; List <SqlDataRecord> listSqlDataRecord = new List <SqlDataRecord>(); SqlMetaData[] MetaDataArr = new SqlMetaData[] { new SqlMetaData("foodId", SqlDbType.Int), new SqlMetaData("foodCount", SqlDbType.Int), new SqlMetaData("payType", SqlDbType.Int), new SqlMetaData("payNum", SqlDbType.Decimal) }; for (int i = 0; i < buyDetailList.Count; i++) { List <object> listParas = new List <object>(); listParas.Add(buyDetailList[i].FoodId); listParas.Add(buyDetailList[i].FoodCount); listParas.Add(buyDetailList[i].PayType); listParas.Add(buyDetailList[i].PayNum); var record = new SqlDataRecord(MetaDataArr); for (int j = 0; j < Ary.Length; j++) { record.SetValue(j, listParas[j]); } listSqlDataRecord.Add(record); } SqlParameter[] sqlParameter = new SqlParameter[18]; sqlParameter[0] = new SqlParameter("@FoodDetail", SqlDbType.Structured); sqlParameter[0].Value = listSqlDataRecord; sqlParameter[1] = new SqlParameter("@StoreID", SqlDbType.VarChar); sqlParameter[1].Value = userTokenDataModel.StoreId; sqlParameter[2] = new SqlParameter("@ICCardID", SqlDbType.Int); sqlParameter[2].Value = icCardId; sqlParameter[3] = new SqlParameter("@PayCount", SqlDbType.Decimal); sqlParameter[3].Value = payCount; sqlParameter[4] = new SqlParameter("@FreePay", SqlDbType.Decimal); sqlParameter[4].Value = freePay; sqlParameter[5] = new SqlParameter("@RealPay", SqlDbType.Decimal); sqlParameter[5].Value = realPay; sqlParameter[6] = new SqlParameter("@UserID", SqlDbType.Int); sqlParameter[6].Value = userTokenModel.LogId; sqlParameter[7] = new SqlParameter("@MemberLevelId", SqlDbType.Int); sqlParameter[7].Value = memberLevelId; sqlParameter[8] = new SqlParameter("@WorkStation", SqlDbType.VarChar); sqlParameter[8].Value = workStation; sqlParameter[9] = new SqlParameter("@AuthorID", SqlDbType.Int); sqlParameter[9].Value = authorId; sqlParameter[10] = new SqlParameter("@Note", SqlDbType.VarChar); sqlParameter[10].Value = note; sqlParameter[11] = new SqlParameter("@OrderSource", SqlDbType.Int); sqlParameter[11].Value = orderSource; sqlParameter[12] = new SqlParameter("@SaleCoinType", SqlDbType.Int); sqlParameter[12].Value = saleCoinType; sqlParameter[13] = new SqlParameter("@CustomerType", SqlDbType.Int); sqlParameter[13].Value = customerType; sqlParameter[14] = new SqlParameter("@Mobile", SqlDbType.VarChar); sqlParameter[14].Value = mobile; sqlParameter[15] = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 200); sqlParameter[15].Direction = ParameterDirection.Output; sqlParameter[16] = new SqlParameter("@OrderFlwID", SqlDbType.Int); sqlParameter[16].Direction = ParameterDirection.Output; sqlParameter[17] = new SqlParameter("@Return", SqlDbType.Int); sqlParameter[17].Direction = ParameterDirection.ReturnValue; XCCloudBLL.ExecuteStoredProcedureSentence(storedProcedure, sqlParameter); if (sqlParameter[17].Value.ToString() == "1") { var obj = new { orderFlwId = Convert.ToInt32(sqlParameter[16].Value) }; return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, obj)); } else { return(new ResponseModel(Return_Code.T, "", Result_Code.F, sqlParameter[15].Value.ToString())); } }