public object getOrderContain(Dictionary <string, object> dicParas) { string errMsg = string.Empty; string orderFlwId = dicParas.ContainsKey("orderFlwId") ? dicParas["orderFlwId"].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参数无效")); } string storedProcedure = "GetOrderContainById"; SqlParameter[] sqlParameter = new SqlParameter[2]; sqlParameter[0] = new SqlParameter("@StoreId", SqlDbType.VarChar); sqlParameter[0].Value = userTokenDataModel.StoreId; sqlParameter[1] = new SqlParameter("@OrderFlwId", SqlDbType.Int); sqlParameter[1].Value = orderFlwId; System.Data.DataSet ds = XCCloudBLL.GetStoredProcedureSentence(storedProcedure, sqlParameter); if (ds != null && ds.Tables.Count == 2 && ds.Tables[0].Rows.Count > 0) { OrderMainModel main = Utils.GetModelList <OrderMainModel>(ds.Tables[0]).ToList()[0]; List <OrderDetailModel> detail = Utils.GetModelList <OrderDetailModel>(ds.Tables[1]).ToList(); OrderInfoModel model = new OrderInfoModel(main, detail); return(ResponseModelFactory.CreateSuccessModel <OrderInfoModel>(isSignKeyReturn, model)); } else { return(new ResponseModel(Return_Code.T, "", Result_Code.F, "订单信息不存在")); } }
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 getMember(Dictionary <string, object> dicParas) { XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty; string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty; if (string.IsNullOrEmpty(icCardId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员卡号无效")); } if (string.IsNullOrEmpty(storeId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "门店号无效")); } string storedProcedure = "GetMember"; SqlParameter[] parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@ICCardID", icCardId); parameters[1] = new SqlParameter("@StoreID", storeId); parameters[2] = new SqlParameter("@Result", SqlDbType.Int); parameters[2].Direction = System.Data.ParameterDirection.Output; parameters[3] = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 200); parameters[3].Direction = System.Data.ParameterDirection.Output; System.Data.DataSet ds = XCCloudBLL.GetStoredProcedureSentence(storedProcedure, parameters); if (parameters[2].Value.ToString() == "1") { var baseMemberModel = Utils.GetModelList <BaseMemberModel>(ds.Tables[0]).ToList()[0]; return(ResponseModelFactory <BaseMemberModel> .CreateModel(isSignKeyReturn, baseMemberModel)); } return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员信息不存在")); }
public object getFoodDetail(Dictionary <string, object> dicParas) { XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); string foodId = dicParas.ContainsKey("foodId") ? dicParas["foodId"].ToString() : string.Empty; if (string.IsNullOrEmpty(foodId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "套餐名不能为空")); } string sql = "exec GetFoodDetail @StoreId,@FoodId "; SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@StoreId", userTokenDataModel.StoreId); parameters[1] = new SqlParameter("@FoodId", foodId); System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { List <FoodDetailModel> list1 = Utils.GetModelList <FoodDetailModel>(ds.Tables[0]).ToList(); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, list1)); } else { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据")); } }
public object getFoodList(Dictionary <string, object> dicParas) { XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); string customerType = dicParas.ContainsKey("customerType") ? dicParas["customerType"].ToString() : string.Empty; string memberLevelId = dicParas.ContainsKey("memberLevelId") ? dicParas["memberLevelId"].ToString() : string.Empty; string foodTypeStr = dicParas.ContainsKey("foodTypeStr") ? dicParas["foodTypeStr"].ToString() : string.Empty; if (string.IsNullOrEmpty(memberLevelId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "会员等级无效")); } string sql = "exec GetFoodListInfo @StoreId,@CustomerType,@MemberLevelId,@FoodTypeStr "; SqlParameter[] parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@StoreId", userTokenDataModel.StoreId); parameters[1] = new SqlParameter("@CustomerType", customerType); parameters[2] = new SqlParameter("@MemberLevelId", memberLevelId); parameters[3] = new SqlParameter("@FoodTypeStr", foodTypeStr); System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { List <FoodInfoModel> list1 = Utils.GetModelList <FoodInfoModel>(ds.Tables[0]).ToList(); for (int i = 0; i < list1.Count; i++) { List <FoodInfoPriceModel> listFoodInfoPriceModel = new List <FoodInfoPriceModel>(); FoodInfoPriceModel foodInfoModel = new FoodInfoPriceModel(0, list1[i].FoodPrice); listFoodInfoPriceModel.Add(foodInfoModel); if (list1[i].AllowCoin == 1) { foodInfoModel = new FoodInfoPriceModel(1, list1[i].Coins); listFoodInfoPriceModel.Add(foodInfoModel); } if (list1[i].AllowPoint == 1) { foodInfoModel = new FoodInfoPriceModel(2, list1[i].Points); listFoodInfoPriceModel.Add(foodInfoModel); } if (list1[i].AllowLottery == 1) { foodInfoModel = new FoodInfoPriceModel(3, list1[i].Lottery); listFoodInfoPriceModel.Add(foodInfoModel); } list1[i].priceListModel = listFoodInfoPriceModel; } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, list1)); } return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据")); }
public object getMemberLevel(Dictionary <string, object> dicParas) { XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); string storedProcedure = "GetMemberLevel"; SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@StoreId", userTokenDataModel.StoreId); System.Data.DataSet ds = XCCloudBLL.GetStoredProcedureSentence(storedProcedure, parameters); List <Data_MemberLevelModel> list = Utils.GetModelList <Data_MemberLevelModel>(ds.Tables[0]); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, list)); }
public object getMemberOpenCardFoodInfo(Dictionary <string, object> dicParas) { XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); string MemberLevelId = dicParas.ContainsKey("memberLevelId") ? dicParas["memberLevelId"].ToString() : string.Empty; string sql = "exec GetMemberOpenCardFoodInfo @StoreId,@MemberLevelId"; SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@StoreId", userTokenDataModel.StoreId); parameters[1] = new SqlParameter("@MemberLevelId", MemberLevelId); System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { List <OpenCardFoodInfoModel> list1 = Utils.GetModelList <OpenCardFoodInfoModel>(ds.Tables[0]).ToList(); //for (int i = 0; i < list1.Count; i++) //{ // List<FoodInfoPriceModel> listFoodInfoPriceModel = new List<FoodInfoPriceModel>(); // FoodInfoPriceModel foodInfoModel = new FoodInfoPriceModel(0, list1[i].FoodPrice); // listFoodInfoPriceModel.Add(foodInfoModel); // if (list1[i].AllowCoin == 1) // { // foodInfoModel = new FoodInfoPriceModel(1, list1[i].Coins); // listFoodInfoPriceModel.Add(foodInfoModel); // } // if (list1[i].AllowPoint == 1) // { // foodInfoModel = new FoodInfoPriceModel(2, list1[i].Points); // listFoodInfoPriceModel.Add(foodInfoModel); // } // if (list1[i].AllowLottery == 1) // { // foodInfoModel = new FoodInfoPriceModel(3, list1[i].Lottery); // listFoodInfoPriceModel.Add(foodInfoModel); // } // list1[i].priceListModel = listFoodInfoPriceModel; //} return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, list1)); } return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "无数据")); }
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())); } }
public static void TestInit() { StoreIDDataModel tokenDataModel = new StoreIDDataModel("S0100022", "778852013145", "lijunjie"); XCCloudUserTokenBusiness.SetUserToken("3", (int)RoleType.StoreUser, tokenDataModel); }
public object register(Dictionary <string, object> dicParas) { XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); string errMsg = string.Empty; string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty; string mobile = dicParas.ContainsKey("mobile") ? dicParas["mobile"].ToString() : string.Empty; string wechat = dicParas.ContainsKey("wechat") ? dicParas["wechat"].ToString() : string.Empty; string qq = dicParas.ContainsKey("qq") ? dicParas["qq"].ToString() : string.Empty; string imme = dicParas.ContainsKey("imme") ? dicParas["imme"].ToString() : string.Empty; string cardShape = dicParas.ContainsKey("cardShape") ? dicParas["cardShape"].ToString() : string.Empty; string memberName = dicParas.ContainsKey("memberName") ? dicParas["memberName"].ToString() : string.Empty; string birthday = dicParas.ContainsKey("birthday") ? dicParas["birthday"].ToString() : string.Empty; string gender = dicParas.ContainsKey("gender") ? dicParas["gender"].ToString() : string.Empty; string identityCard = dicParas.ContainsKey("identityCard") ? dicParas["identityCard"].ToString() : string.Empty; string email = dicParas.ContainsKey("email") ? dicParas["email"].ToString() : string.Empty; string leftHandCode = dicParas.ContainsKey("leftHandCode") ? dicParas["leftHandCode"].ToString() : string.Empty; string rightHandCode = dicParas.ContainsKey("rightHandCode") ? dicParas["rightHandCode"].ToString() : string.Empty; string photo = dicParas.ContainsKey("photo") ? dicParas["photo"].ToString() : string.Empty; string memberLevelId = dicParas.ContainsKey("memberLevelId") ? dicParas["memberLevelId"].ToString() : string.Empty; string foodId = dicParas.ContainsKey("foodId") ? dicParas["foodId"].ToString() : string.Empty; string payCount = dicParas.ContainsKey("payCount") ? dicParas["payCount"].ToString() : string.Empty; string realPay = dicParas.ContainsKey("realPay") ? dicParas["realPay"].ToString() : string.Empty; string freePay = dicParas.ContainsKey("freePay") ? dicParas["freePay"].ToString() : string.Empty; string repeatCode = dicParas.ContainsKey("repeatCode") ? dicParas["repeatCode"].ToString() : string.Empty; string icCardId = dicParas.ContainsKey("icCardId") ? dicParas["icCardId"].ToString() : string.Empty; string workStation = dicParas.ContainsKey("workStation") ? dicParas["workStation"].ToString() : string.Empty; string note = dicParas.ContainsKey("note") ? dicParas["note"].ToString() : string.Empty; string deposit = dicParas.ContainsKey("deposit") ? dicParas["deposit"].ToString() : string.Empty; string payType = dicParas.ContainsKey("payType") ? dicParas["payType"].ToString() : string.Empty; string saleCoinType = dicParas.ContainsKey("saleCoinType") ? dicParas["saleCoinType"].ToString() : string.Empty; if (!checkRegisterParas(dicParas, out errMsg)) { ResponseModel responseModel = new ResponseModel(Return_Code.T, "", Result_Code.F, errMsg); return(responseModel); } string storedProcedure = "RegisterMember"; String[] Ary = new String[] { "数据0", "数据1", "数据2", "数据3", "数据4", "数据5", "数据6", "数据7", "数据8", "数据9", "数据10", "数据11", "数据12", "数据13", "数据14", "数据15", "数据16", "数据17", "数据18", "数据19", "数据20", "数据21", "数据22", "数据23", "数据24", "数据25", "数据26", "数据27" }; List <object> listParas = new List <object>(); listParas.Add(storeId); //StoreId listParas.Add(mobile); //Mobile listParas.Add(wechat); //WeChat listParas.Add(qq); //QQ listParas.Add(imme); //IMME listParas.Add(int.Parse(cardShape)); //CardShape listParas.Add(memberName); //MemberName listParas.Add("888888"); //MemberPassword listParas.Add(birthday); //Birthday listParas.Add(gender); //Gender listParas.Add(identityCard); //IdentityCard listParas.Add(email); //EMail listParas.Add(leftHandCode); //LeftHandCode listParas.Add(rightHandCode); //RightHandCode listParas.Add(photo); //Photo listParas.Add(int.Parse(memberLevelId)); //MemberLevelId listParas.Add(int.Parse(foodId)); //FoodId listParas.Add(decimal.Parse(payCount)); //payCount listParas.Add(decimal.Parse(realPay)); //realPay listParas.Add(decimal.Parse(freePay)); //freePay listParas.Add(int.Parse(repeatCode)); //repeatCode listParas.Add(int.Parse(icCardId)); //icCardId listParas.Add(workStation); //workStation listParas.Add(int.Parse(userTokenModel.LogId)); //UserId listParas.Add(decimal.Parse(deposit)); //deposit listParas.Add((long)0); //icCardUID listParas.Add(int.Parse(payType)); //payType listParas.Add(int.Parse(saleCoinType)); //saleCoinType List <SqlDataRecord> listSqlDataRecord = new List <SqlDataRecord>(); SqlMetaData[] MetaDataArr = new SqlMetaData[] { new SqlMetaData("StoreId", SqlDbType.VarChar, 15), new SqlMetaData("Mobile", SqlDbType.VarChar, 20), new SqlMetaData("WeChat", SqlDbType.VarChar, 64), new SqlMetaData("QQ", SqlDbType.VarChar, 64), new SqlMetaData("IMME", SqlDbType.VarChar, 64), new SqlMetaData("CardShape", SqlDbType.Int), new SqlMetaData("MemberName", SqlDbType.VarChar, 50), new SqlMetaData("MemberPassword", SqlDbType.VarChar, 20), new SqlMetaData("Birthday", SqlDbType.VarChar, 16), new SqlMetaData("Gender", SqlDbType.VarChar, 1), new SqlMetaData("IdentityCard", SqlDbType.VarChar, 50), new SqlMetaData("EMail", SqlDbType.VarChar, 50), new SqlMetaData("LeftHandCode", SqlDbType.VarChar, 5000), new SqlMetaData("RightHandCode", SqlDbType.VarChar, 5000), new SqlMetaData("Photo", SqlDbType.VarChar, 100), new SqlMetaData("MemberLevelId", SqlDbType.Int), new SqlMetaData("FoodId", SqlDbType.Int), new SqlMetaData("PayCount", SqlDbType.Decimal), new SqlMetaData("RealPay", SqlDbType.Decimal), new SqlMetaData("FreePay", SqlDbType.Decimal), new SqlMetaData("RepeatCode", SqlDbType.Int), new SqlMetaData("ICCardId", SqlDbType.Int), new SqlMetaData("WorkStation", SqlDbType.VarChar, 50), new SqlMetaData("UserId", SqlDbType.Int), new SqlMetaData("Deposit", SqlDbType.Decimal), new SqlMetaData("ICCardUID", SqlDbType.BigInt), new SqlMetaData("PayType", SqlDbType.Int), new SqlMetaData("SaleCoinType", SqlDbType.Int) }; var record = new SqlDataRecord(MetaDataArr); for (int i = 0; i < Ary.Length; i++) { record.SetValue(i, listParas[i]); } listSqlDataRecord.Add(record); SqlParameter[] sqlParameter = new SqlParameter[4]; sqlParameter[0] = new SqlParameter("@RegisterMember", SqlDbType.Structured); sqlParameter[0].Value = listSqlDataRecord; sqlParameter[1] = new SqlParameter("@Note", SqlDbType.Text); sqlParameter[1].Value = note; sqlParameter[2] = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 200); sqlParameter[2].Direction = ParameterDirection.Output; sqlParameter[3] = new SqlParameter("@Result", SqlDbType.Int); sqlParameter[3].Direction = ParameterDirection.Output; System.Data.DataSet ds = XCCloudBLL.GetStoredProcedureSentence(storedProcedure, sqlParameter); if (sqlParameter[3].Value.ToString() == "1") { var baseMemberModel = Utils.GetModelList <BaseMemberModel>(ds.Tables[0]).ToList()[0]; return(ResponseModelFactory <BaseMemberModel> .CreateModel(isSignKeyReturn, baseMemberModel)); } else { return(new ResponseModel(Return_Code.T, "", Result_Code.F, sqlParameter[2].Value.ToString())); } }