/// <summary> /// 动态保存订单 /// </summary> /// <param name="orderDto"></param> public static void DynamicSaveOrder(OrderDto orderDto) { DataRow drstyle = SQLmtm.GetDataRow("SELECT MAX(SYS_STYLE_ID) SYS_STYLE_ID FROM `s_style_p`"); orderDto.style_id = (Convert.ToInt32(drstyle["SYS_STYLE_ID"]) + 1).ToString(); //orderDto.style_id = FunctionHelper.generateBillNo("s_style_p", "SYS_STYLE_ID", "", "0000"); SQLmtm.DoInsert( "s_style_fit_r" , new string[] { "STYLE_ID", "PHASE_CD", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "DELETE_FLAG", "VERSION", "CREATE_USER", "IN_VALUE", "OUT_VALUE" } , new string[] { orderDto.style_id, "AUDIT_PHASE_CD-PHASE_CD_10", orderDto.Dto尺寸.ITEM_CD, orderDto.Dto尺寸.ITEM_VALUE, orderDto.Dto尺寸.FIT_VALUE, orderDto.Dto尺寸.FM_VALUE, "0", "1", "46", orderDto.Dto尺寸.IN_VALUE, orderDto.Dto尺寸.OUT_VALUE } ); SQLmtm.DoInsert( "a_customer_fit_value_r" , new string[] { "CUSTOMER_ID", "CUSTOMER_NAME", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "IN_VALUE", "OUT_VALUE", "STATUS", "DELETE_FLAG", "CUSTOMER_COUNT_ID" } , new string[] { orderDto.CUSTOMER_ID, orderDto.CUSTOMER_NAME, orderDto.Dto尺寸.ITEM_CD, orderDto.Dto尺寸.ITEM_VALUE, orderDto.Dto尺寸.FIT_VALUE, orderDto.Dto尺寸.FM_VALUE, orderDto.Dto尺寸.IN_VALUE, orderDto.Dto尺寸.OUT_VALUE, "0", "0", orderDto.CUSTOMER_COUNT_ID } ); SQLmtm.DoInsert( "s_style_p" , new string[] { "SYS_STYLE_ID", "SHOP_ID", "STYLE_CD", "STYLE_KBN", "STYLE_CATEGORY_CD", "SYTLE_FABRIC_ID", "STYLE_SIZE_GROUP_CD", "STYLE_SIZE_CD", "STYLE_MAKE_TYPE", "ENABLE_FLAG", "DELETE_FLAG", "VERSION", "STYLE_NAME_CN", "REMARKS", "CUSTOMER_COUNT_ID", "STYLE_FIT_CD", "REF_STYLE_ID", "STYLE_DRESS_CATEGORY", "STYLE_DESIGN_TYPE", "STYLE_PUBLISH_CATEGORY_CD", "SYTLE_YEAR", "SYTLE_SEASON" } , new string[] { orderDto.style_id, "18", "", "STYLE_SOURCE-STYLE_SOURCE_50", orderDto.STYLE_CATEGORY_CD, orderDto.SYTLE_FABRIC_ID, orderDto.STYLE_SIZE_GROUP_CD, orderDto.STYLE_SIZE_CD, "4SMA-4M", "1", "0", "1", orderDto.STYLE_NAME_CN, "", orderDto.CUSTOMER_COUNT_ID, orderDto.STYLE_FIT_CD, orderDto.REF_STYLE_ID, orderDto.STYLE_DRESS_CATEGORY, orderDto.STYLE_DESIGN_TYPE, orderDto.STYLE_PUBLISH_CATEGORY_CD, orderDto.SYTLE_YEAR, orderDto.SYTLE_SEASON } ); foreach (Dto设计点 dto in orderDto.Dto设计点s) { SQLmtm.DoInsert("s_style_option_r", new string[] { "SYS_STYLE_ID", "ITEM_CD", "ITEM_VALUE", "OPTION_VALUE", "ENABLE_FLAG", "DELETE_FLAG" }, new string[] { orderDto.style_id, dto.ITEM_CD, dto.ITEM_VALUE, dto.OPTION_VALUE, "1", "0" }); } RestCall.httpGetMethod("https://shirtmtm.com/fragsmart-mtm/customer/update/payment?styleId=" + orderDto.style_id + "&customerId=" + orderDto.CUSTOMER_ID + "&addressId=" + orderDto.ADDRESS_ID + "&number=" + orderDto.ORDER_NUMBER); //RestCall.httpGetMethod("http://localhost:8080/customer/update/payment?styleId=" + orderDto.style_id + "&customerId=" + orderDto.CUSTOMER_ID + "&addressId=" + orderDto.ADDRESS_ID + "&number=" + orderDto.ORDER_NUMBER); DataRow ORDER_ID = SQLmtm.GetDataRow("SELECT MAX(ORDER_ID) AS ORDER_ID FROM `o_order_p`"); int order_id = Convert.ToInt32(ORDER_ID["ORDER_ID"]); //order_id++; SQLmtm.DoInsert("o_order_brand_r", new string[] { "OGNIZATION_ID", "SHOP_ID", "BRAND_ID", "ORDER_ID" }, new string[] { "95", "18", "", order_id.ToString() }); SQLmtm.DoInsert("t_order_type", new string[] { "ORDER_ID", "ORDER_TYPE" }, new string[] { order_id.ToString(), "1" }); }
// 获取分录的token数据 public static List <TokenDataDto> getEntryTokenData(String billTokenId, String billMetaId, String entryMetaId) { String resultStr = RestCall.httpGetMethod(XindianAppConfig.businessServiceUri + "/bill/entry/bill-meta-id/bill-token-id/entry-meta-id?entryMetaId=" + entryMetaId + "&billMetaId=" + billMetaId + "&billTokenId=" + billTokenId); Result result = Newtonsoft.Json.JsonConvert.DeserializeObject <Result>(resultStr);; if (result.resultCode == 0) { return(Newtonsoft.Json.JsonConvert.DeserializeObject <List <TokenDataDto> >(result.data.ToString())); } else { MessageBox.Show("获取数据失败!"); return(null); } }
// 根据metaId和tokenId获取tokenDataDTO public static TokenDataDto getTokenDataDTO(String metaId, String tokenId) { String resultStr = RestCall.httpGetMethod(XindianAppConfig.businessServiceUri + "/bill/bill/meta-id/token-id?metaId=" + metaId + "&tokenId=" + tokenId); Result result = Newtonsoft.Json.JsonConvert.DeserializeObject <Result>(resultStr);; if (result.resultCode == 0 && null != result.data) { return(Newtonsoft.Json.JsonConvert.DeserializeObject <TokenDataDto>(result.data.ToString())); } else { MessageBox.Show("获取数据失败!"); return(null); } }
private void stylechangesave_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("确认保存吗?", "保存", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { if (this.shuliang.Text == "" || this.mianliaoname.Text == "" || this.chicun01.Text == "") { MessageBox.Show("请填写完整"); return; } try { Frm定制下单修改尺寸.styleid = StyleService.GetNewStyleID(); //尺寸保存 ImpService.StandardModelsSizeSive(this.chooseStyleSize); //s_style_p写入数据 ImpService.insertS_Style_P(styleCard); //设计点保存 ImpService.StandardModelsDesignSive(); //o_order_p写入数据 //RestCall.httpGetMethod("https://shirtmtm.com/fragsmart-mtm/customer/update/payment?styleId=" + styleid.ToString() + "&customerId=" + CreateCustomer.cUSTOMER_ID.ToString() + "&addressId=" + CreateCustomer.aDDRESS_ID.ToString() + "&number=" + this.shuliang.Text); RestCall.httpGetMethod("http://localhost:8080/customer/update/payment?styleId=" + Frm定制下单修改尺寸.styleid.ToString() + "&customerId=" + Frm客户.cUSTOMER_ID.ToString() + "&addressId=" + Frm客户.aDDRESS_ID.ToString() + "&number=" + this.shuliang.Text); DataRow ORDER_ID = SQLmtm.GetDataRow("SELECT MAX(ORDER_ID) AS ORDER_ID FROM `o_order_p`"); int order_id = Convert.ToInt32(ORDER_ID["ORDER_ID"]); //order_id++; SQLmtm.DoInsert("o_order_brand_r", new string[] { "OGNIZATION_ID", "SHOP_ID", "BRAND_ID", "ORDER_ID" }, new string[] { "95", "18", "", order_id.ToString() }); SQLmtm.DoInsert("t_order_type", new string[] { "ORDER_ID", "ORDER_TYPE" }, new string[] { order_id.ToString(), "2" }); MessageBox.Show("保存成功"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { return; } }
public static UserInfoDetails GetUserInfoDetails(string userId) { string url = XindianAppConfig.businessServiceUri + "/user/information?userId=" + userId; string rv = RestCall.httpGetMethod(url); if (string.IsNullOrEmpty(rv)) { return(null); } Result ret = Newtonsoft.Json.JsonConvert.DeserializeObject <Result>(rv); if (ret.resultCode == 0 && ret.data != null) { UserInfoDetails datas = Newtonsoft.Json.JsonConvert.DeserializeObject <UserInfoDetails>(ret.data.ToString()); return(datas); } else { return(null); } //return null; }
// 调用存储过程 public static void storeProcedure(String metaId, String tokenId) { String resultStr = RestCall.httpGetMethod(XindianAppConfig.businessServiceUri + "/bill/submit/storeProcedure?metaId=" + metaId + "&tokenId=" + tokenId); }