/// <summary> /// s_style_p插入数据 /// </summary> /// <param name="change"></param> /// <param name="uc"></param> public static void insertS_Style_P(Frm定制下单修改尺寸 change, UC款式卡片 uc) { Frm定制下单修改尺寸.sTYLE_SIZE_CD = SizeService.SizeCD(change.chicun01.Text.Trim(), Frm定制下单修改尺寸.stylesizedt); //DataRow drstyle = SQLmtm.GetDataRow("SELECT MAX(SYS_STYLE_ID) SYS_STYLE_ID FROM `s_style_p`"); //Change.styleid = Convert.ToInt32(drstyle["SYS_STYLE_ID"]); //Change.styleid++; 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[] { Frm定制下单修改尺寸.styleid.ToString(), "18", "", "STYLE_SOURCE-STYLE_SOURCE_50", uc.sTYLE_CATEGORY_CD, Frm面料选择.mianliaoid, uc.sTYLE_SIZE_GROUP_CD, Frm定制下单修改尺寸.sTYLE_SIZE_CD, "4SMA-4M", "1", "0", "1", uc.kuanshimingcheng, "", Frm客户.customer_countid.ToString(), uc.sTYLE_FIT_CD, uc.kuanshiid, uc.sTYLE_DRESS_CATEGORY, uc.sTYLE_DESIGN_TYPE, uc.sTYLE_PUBLISH_CATEGORY_CD, uc.sYTLE_YEAR, uc.sYTLE_SEASON }); }
/// <summary> /// 动态设计点保存 /// </summary> /// <param name="change"></param> public static void DynamicSaveDesign(Frm定制下单修改尺寸 change) { UC设计点选择 c = new UC设计点选择(); foreach (Control card in change.panel6.Controls) { if (card is UC设计点选择) { c = (UC设计点选择)card; SQLmtm.DoInsert("s_style_option_r", new string[] { "SYS_STYLE_ID", "ITEM_CD", "ITEM_VALUE", "OPTION_VALUE", "ENABLE_FLAG", "DELETE_FLAG" }, new string[] { Frm定制下单修改尺寸.styleid.ToString(), c.PitemCd, c.PitemValue, c.itemValue, "1", "0" }); } } }
/// <summary> /// 保存尺寸a_customer_fit_value_r,s_style_fit_r插入数据 /// </summary> /// <param name="sTYLE_FIT_ID"></param> /// <param name="customername"></param> /// <param name="fitv"></param> /// <param name="ftvl"></param> /// <param name="inftvl"></param> /// <param name="outftvl"></param> public static void insertFit_R(int sTYLE_FIT_ID, string customername, Fit_ValueDTo fitv, String ftvl, String inftvl, String outftvl) { SQLmtm.DoInsert("a_customer_fit_value_r", new string[] { "STYLE_FIT_ID", "CUSTOMER_ID", "CUSTOMER_NAME", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE" , "IN_VALUE", "OUT_VALUE", "STATUS", "DELETE_FLAG", "CUSTOMER_COUNT_ID" }, new string[] { sTYLE_FIT_ID.ToString(), Frm客户.cUSTOMER_ID.ToString(), customername, "SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_POSTU003,SHIRT_POSTU003,SHIRT_POSTU003,SHIRT_POSTU003,", "CIRCU_ITEM_01,CIRCU_ITEM_02,CIRCU_ITEM_03,CIRCU_ITEM_04,CIRCU_ITEM_05,CIRCU_ITEM_06,CIRCU_ITEM_07,LENGT_ITEM_08,CIRCU_ITEM_08,CIRCU_ITEM_18,CIRCU_ITEM_17,LENGT_ITEM_01,LENGT_ITEM_02,POSTU_ITEM_09,POSTU_ITEM_07,LENGT_ITEM_05,LENGT_ITEM_06,POSTU_ITEM_01,POSTU_ITEM_02,CIRCU_ITEM_21,CIRCU_ITEM_19,", ftvl, "CIRCU_ITEM_01,CIRCU_ITEM_02,CIRCU_ITEM_03,CIRCU_ITEM_04,CIRCU_ITEM_05,CIRCU_ITEM_06,CIRCU_ITEM_07,LENGT_ITEM_08,CIRCU_ITEM_08,CIRCU_ITEM_18,CIRCU_ITEM_17,LENGT_ITEM_01,LENGT_ITEM_02,POSTU_ITEM_09,POSTU_ITEM_07,LENGT_ITEM_05,LENGT_ITEM_06,POSTU_ITEM_01,POSTU_ITEM_02,CIRCU_ITEM_21,CIRCU_ITEM_19,", inftvl, outftvl, "0", "0", Frm客户.customer_countid.ToString() }); 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[] { Frm定制下单修改尺寸.styleid.ToString(), "AUDIT_PHASE_CD-PHASE_CD_10", "SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_CIRCU001,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_LENGT002,SHIRT_POSTU003,SHIRT_POSTU003,SHIRT_POSTU003,SHIRT_POSTU003", "CIRCU_ITEM_01,CIRCU_ITEM_02,CIRCU_ITEM_03,CIRCU_ITEM_04,CIRCU_ITEM_05,CIRCU_ITEM_06,CIRCU_ITEM_07,LENGT_ITEM_08,CIRCU_ITEM_08,CIRCU_ITEM_18,CIRCU_ITEM_17,LENGT_ITEM_01,LENGT_ITEM_02,POSTU_ITEM_09,POSTU_ITEM_07,LENGT_ITEM_05,LENGT_ITEM_06,POSTU_ITEM_01,POSTU_ITEM_02,CIRCU_ITEM_21,CIRCU_ITEM_19", ftvl, "CIRCU_ITEM_01,CIRCU_ITEM_02,CIRCU_ITEM_03,CIRCU_ITEM_04,CIRCU_ITEM_05,CIRCU_ITEM_06,CIRCU_ITEM_07,LENGT_ITEM_08,CIRCU_ITEM_08,CIRCU_ITEM_18,CIRCU_ITEM_17,LENGT_ITEM_01,LENGT_ITEM_02,POSTU_ITEM_09,POSTU_ITEM_07,LENGT_ITEM_05,LENGT_ITEM_06,POSTU_ITEM_01,POSTU_ITEM_02,CIRCU_ITEM_21,CIRCU_ITEM_19", "0", "1", "46", inftvl, outftvl }); }
/// <summary> /// 标准款尺寸保存 /// </summary> /// <param name="dt"></param> public static void StandardModelsSizeSive(DataTable dt) { Fit_ValueDTo fitv = new Fit_ValueDTo(); foreach (DataRow dr in dt.Rows) { fitv.icadd(dr["ITEM_CD"].ToString()); fitv.ivadd(dr["ITEM_VALUE"].ToString()); fitv.fvadd(dr["ITEM_FIT_VALUE"].ToString()); fitv.fmvadd(dr["ITEM_VALUE"].ToString()); fitv.invadd("0"); fitv.outvadd("0"); } 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[] { Frm客户.cUSTOMER_ID.ToString(), Frm客户.customer_name, fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, fitv.iN_VALUE, fitv.oUT_VALUE, "0", "0", Frm客户.customer_countid.ToString() }); 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[] { Frm定制下单修改尺寸.styleid.ToString(), "AUDIT_PHASE_CD-PHASE_CD_10", fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, "0", "1", "46", fitv.iN_VALUE, fitv.oUT_VALUE }); }
/// <summary> /// 标准款设计点保存 /// </summary> public static void StandardModelsDesignSive() { try { String sql = "SELECT * FROM s_style_option_r WHERE SYS_STYLE_ID='" + Frm定制下单修改尺寸.kuanshiid + "'"; DataTable dt = SQLmtm.GetDataTable(sql); foreach (DataRow dr in dt.Rows) { SQLmtm.DoInsert( "s_style_option_r" , new string[] { "SYS_STYLE_ID", "ITEM_CD", "ITEM_VALUE", "OPTION_VALUE", "ENABLE_FLAG", "DELETE_FLAG" } , new string[] { Frm定制下单修改尺寸.styleid.ToString(), dr["ITEM_CD"].ToString(), dr["ITEM_VALUE"].ToString(), dr["OPTION_VALUE"].ToString(), "1", "0" } ); } } catch (Exception ex) { MessageBox.Show("错误信息: " + ex.Message); return; } }
/// <summary> /// 动态保存尺寸 /// </summary> /// <param name="change"></param> public static void DynamicSaveSize(Frm定制下单修改尺寸 change, int sTYLE_FIT_ID, String customername) { ImpService.TurnChiCunZero(change); Fit_ValueDTo fitv = new Fit_ValueDTo(); foreach (Control card in change.panel4.Controls) { if (card is UC尺寸卡片) { UC尺寸卡片 c = (UC尺寸卡片)card; fitv.icadd(c.iTEM_CD); fitv.ivadd(c.iTEM_VALUE); fitv.fvadd(c.chengyi.Text); fitv.fmvadd(c.iTEM_VALUE); fitv.invadd(c.jia.Text); fitv.outvadd(c.jian.Text); } } SQLmtm.DoInsert("a_customer_fit_value_r", new string[] { "STYLE_FIT_ID", "CUSTOMER_ID", "CUSTOMER_NAME", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "IN_VALUE", "OUT_VALUE", "STATUS", "DELETE_FLAG", "CUSTOMER_COUNT_ID" }, new string[] { sTYLE_FIT_ID.ToString(), Frm客户.cUSTOMER_ID.ToString(), customername, fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, fitv.iN_VALUE, fitv.oUT_VALUE, "0", "0", Frm客户.customer_countid.ToString() }); 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[] { Frm定制下单修改尺寸.styleid.ToString(), "AUDIT_PHASE_CD-PHASE_CD_10", fitv.iTEM_CD, fitv.iTEM_VALUE, fitv.fitValue, fitv.fM_VALUE, "0", "1", "46", fitv.iN_VALUE, fitv.oUT_VALUE }); }
private void simpleButton1_Click(object sender, EventArgs e) { if (this.shengao.Text == "" || this.tizhong.Text == "" || this.tixing.Text == "" || this.jianxing.Text == "" || this.fuxing.Text == "" || this.tunxing.Text == "") { MessageBox.Show("请填写完整"); return; } this.customerZero(); customer_name = this.xing.Text + this.ming.Text; if (this.sex.Text == "男") { sEX_CD = "SEX-M_10"; sexno = "0"; } else { sEX_CD = "SEX-W_20"; sexno = "1"; } DataRow dr_customerid = SQLmtm.GetDataRow("SELECT MAX(CUSTOMER_ID) AS CUSTOMER_ID FROM a_customer_p "); cUSTOMER_ID = Convert.ToInt32(dr_customerid["CUSTOMER_ID"]); cUSTOMER_ID++; int i1 = SQLmtm.DoInsert("a_customer_p", new string[] { "CUSTOMER_ID", "CUSTOMER_FIRST_NAME", "CUSTOMER_LAST_NAME", "MOBILE", "DEFAULT_ADDR_FLAG", "SEX_CD", "E_MAIL_URL", "DELETE_FLAG", "VERSION", "CUSTOMER_STATUS" }, new string[] { cUSTOMER_ID.ToString(), this.xing.Text, this.ming.Text, this.shouji.Text, "0", sEX_CD, this.eml.Text, "0", "1", "CUSTOMER_SOURCE-CS_SHOP" }); if (i1 != 1) { MessageBox.Show("保存失败"); } //a_customer_fit_count_r int i14 = SQLmtm.DoInsert("a_customer_fit_count_r", new string[] { "CUSTOMER_ID", "CUSTOMER_NAME", "SEX", "AGE", "CREATE_DATE", "DELETE_FLAG", "DEFAULT_FLAG", "DATA_COMPLETE" }, new string[] { cUSTOMER_ID.ToString(), customer_name, sexno, this.nianling.Text, DateTime.Now.ToUniversalTime().ToString(), "0", "1", "1" }); DataRow dr_customer_countid = SQLmtm.GetDataRow("SELECT MAX(ID) AS ID FROM a_customer_fit_count_r"); customer_countid = Convert.ToInt32(dr_customer_countid["ID"]); if (i14 != 1) { MessageBox.Show("保存失败"); } //门店客户表 int i2 = SQLmtm.DoInsert("a_shop_customer_r", new string[] { "SHOP_CUSTOMER_ID", "SHOP_ID", "CUSTOMER_ID" }, new string[] { (cUSTOMER_ID - 1).ToString(), "18", cUSTOMER_ID.ToString() }); ////取量体id //DataRow dr_customerfitid = SQLmtm.GetDataRow("SELECT MAX(CUSTOMER_FIT_ID) AS CUSTOMER_FIT_ID FROM a_customer_fit_r"); //cUSTOMER_FIT_ID = Convert.ToInt32(dr_customerfitid["CUSTOMER_FIT_ID"]); //cUSTOMER_FIT_ID++; if (i2 != 1) { MessageBox.Show("保存失败"); } //身高 int i3 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_09", "0", this.shengao.Text, customer_countid.ToString() }); if (i3 != 1) { MessageBox.Show("保存失败"); } //体重 int i4 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_10", "0", this.tizhong.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i4 != 1) { MessageBox.Show("保存失败"); } //肩宽CODE int i5 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_05", "0", this.jiankuan.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i5 != 1) { MessageBox.Show("保存失败"); } //胸围CODE int i6 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_02", "0", this.xiongwei.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i6 != 1) { MessageBox.Show("保存失败"); } //腰围CODE int i7 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_12", "0", this.yaowei.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i7 != 1) { MessageBox.Show("保存失败"); } //臀围CODE int i8 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_03", "0", this.tunwei.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i8 != 1) { MessageBox.Show("保存失败"); } //身长CODE int i9 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_04", "0", this.shenchang.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i9 != 1) { MessageBox.Show("保存失败"); } //领围CODE int i10 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_01", "0", this.lingwei.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i10 != 1) { MessageBox.Show("保存失败"); } //腕围CODE int i11 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_08", "0", this.wanwei.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i11 != 1) { MessageBox.Show("保存失败"); } //袖长CODE int i12 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_06", "0", this.xiuchang.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i12 != 1) { MessageBox.Show("保存失败"); } //上臂袖肥CODE int i13 = SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_ITEM_07", "0", this.shangbixiufei.Text, customer_countid.ToString() }); //cUSTOMER_FIT_ID++; if (i13 != 1) { MessageBox.Show("保存失败"); } //腹型CODE switch (this.fuxing.Text) { case "凹陷": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_02", "0", "4", customer_countid.ToString() }); break; case "平坦": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_02", "0", "5", customer_countid.ToString() }); break; case "微凸": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_02", "0", "6", customer_countid.ToString() }); break; case "中凸": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_02", "0", "7", customer_countid.ToString() }); break; case "重凸": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_02", "0", "8", customer_countid.ToString() }); break; } //cUSTOMER_FIT_ID++; //体型CODE switch (this.tixing.Text) { case "超瘦": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_03", "0", "CD03_01", customer_countid.ToString() }); break; case "标准": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_03", "0", "CD03_02", customer_countid.ToString() }); break; case "微胖": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_03", "0", "CD03_03", customer_countid.ToString() }); break; case "肥胖": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_03", "0", "CD03_04", customer_countid.ToString() }); break; case "肌肉": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_03", "0", "CD03_05", customer_countid.ToString() }); break; case "健身达人": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_03", "0", "CD03_06", customer_countid.ToString() }); break; } //cUSTOMER_FIT_ID++; //特征CODE switch (this.shentitezheng.Text) { case "背部厚实": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_05", "0", "CD05_01", customer_countid.ToString() }); break; case "脖子特别粗": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_05", "0", "CD05_02", customer_countid.ToString() }); break; case "臀部特别大": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_05", "0", "CD05_03", customer_countid.ToString() }); break; case "手臂特别长": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_05", "0", "CD05_04", customer_countid.ToString() }); break; case "肩部特别宽": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_05", "0", "CD05_05", customer_countid.ToString() }); break; case "脖子特别短": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_05", "0", "CD05_06", customer_countid.ToString() }); break; } //cUSTOMER_FIT_ID++; //肩型 switch (this.jianxing.Text) { case "平肩": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_01", "0", "1", customer_countid.ToString() }); break; case "溜肩": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_01", "0", "2", customer_countid.ToString() }); break; case "正常": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_01", "0", "3", customer_countid.ToString() }); break; } //cUSTOMER_FIT_ID++; //背型 switch (this.tunxing.Text) { case "挺胸": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_04", "0", "CD04_01", customer_countid.ToString() }); break; case "直背": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_04", "0", "CD04_02", customer_countid.ToString() }); break; case "驼背": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_04", "0", "CD04_03", customer_countid.ToString() }); break; } //cUSTOMER_FIT_ID++; //臀型 switch (this.tunxing.Text) { case "正常": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_07", "0", "1", customer_countid.ToString() }); break; case "翘臀": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_07", "0", "2", customer_countid.ToString() }); break; case "平臀": SQLmtm.DoInsert("a_customer_fit_r", new string[] { "CUSTOMER_ID", "STYLE_CATEGORY_CD", "ITEM_CD", "ITEM_VALUE", "DELETE_FLAG", "FIT_VALUE", "FIT_COUNT_ID" }, new string[] { cUSTOMER_ID.ToString(), "STYLE_CATEGORY-SHIRT", "SHIRT_FITMT004", "FITMT_CODE_07", "0", "3", customer_countid.ToString() }); break; } DataRow dr_addressid = SQLmtm.GetDataRow("SELECT MAX(ADDRESS_ID) AS ADDRESS_ID FROM a_customer_address_p"); aDDRESS_ID = Convert.ToInt32(dr_addressid["ADDRESS_ID"]); aDDRESS_ID++; SQLmtm.DoInsert("a_customer_address_p", new string[] { "ADDRESS_ID", "CUSTOMER_ID", "DEFAULT_ADDR_FLAG", "CONSIGNEE", "ADDRESS_PROVINCE_CD", "ADDRESS_CITY_CD", "ADDRESS_DISTRICT", "ADDRESS_DETAIL", "ZIP_CODE", "MOBILE", "DELETE_FLAG" }, new string[] { aDDRESS_ID.ToString(), cUSTOMER_ID.ToString(), "1", this.shouhuoren.Text, this.shengfen.Text, this.chengshi.Text, this.qvyv.Text, this.xiangxidizhi.Text, this.youbian.Text, this.shoujianshouji.Text, "0" }); String listFitData = null; try { DataTable dt = SQLmtm.GetDataTable("SELECT CUSTOMER_ID,ITEM_CD,ITEM_VALUE,FIT_VALUE FROM `a_customer_fit_r` WHERE FIT_COUNT_ID='" + customer_countid.ToString() + "'"); foreach (DataRow dr in dt.Rows) { listFitData = listFitData + dr["ITEM_CD"].ToString() + "-" + dr["ITEM_VALUE"].ToString() + ":" + dr["FIT_VALUE"] + ","; } } catch { MessageBox.Show("保存失败"); return; } FitValueCalculate fvc = new FitValueCalculate(customer_countid.ToString(), listFitData); String fjsondata = Newtonsoft.Json.JsonConvert.SerializeObject(fvc); //String entryDataJson = Newtonsoft.Json.JsonConvert.SerializeObject(class1); RestCall.PostHttp("https://shirtmtm.com/fragsmart-mtm/customer/update/update", fjsondata); //RestCall.PostHttp("http://localhost:8080/customer/update/update", fjsondata); MessageBox.Show("保存成功"); this.Close(); }
/// <summary> /// 订单信息保存 /// </summary> private void stylechangesave_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("确认保存吗?", "保存", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { if (Frm面料选择.mianliaoid == "" || this.chicun01.Text == "" || this.shuliang.Text == "") { MessageBox.Show("请填写完整"); return; } DataRow drstylefit = SQLmtm.GetDataRow("SELECT MAX(STYLE_FIT_ID) as STYLE_FIT_ID FROM `a_customer_fit_value_r`"); int sTYLE_FIT_ID = Convert.ToInt32(drstylefit["STYLE_FIT_ID"]); sTYLE_FIT_ID++; DataRow drcustomer = SQLmtm.GetDataRow("select * from a_customer_p where CUSTOMER_ID='" + Frm客户.cUSTOMER_ID.ToString() + "'"); string customername = Convert.ToString(drcustomer["CUSTOMER_FIRST_NAME"]) + Convert.ToString(drcustomer["CUSTOMER_LAST_NAME"]); sTYLE_SIZE_CD = SizeService.SizeCD(this.chicun01.Text.Trim(), stylesizedt); DataRow drstyle = SQLmtm.GetDataRow("SELECT MAX(SYS_STYLE_ID) SYS_STYLE_ID FROM `s_style_p`"); styleid = Convert.ToInt32(drstyle["SYS_STYLE_ID"]); styleid++; //a_customer_fit_value_r,s_style_fit_r表存储 //ImpService.insertFit_R(sTYLE_FIT_ID, customername, fitv, ftvl, inftvl, outftvl); //动态尺寸保存 ImpService.DynamicSaveSize(this, sTYLE_FIT_ID, customername); //s_style_p储存 ImpService.insertS_Style_P(this, uc); //s_style_fit_r //设计点保存 //ImpService.SaveDesign(this); ImpService.DynamicSaveDesign(this); //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=" + 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(), "1" }); if (Convert.ToInt32(this.shuliang.Text) == Convert.ToInt32(this.shuliang.Text)) { MessageBox.Show("保存成功!"); //this.closeForm(); this.Close(); } else { MessageBox.Show("保存失败"); } } //else //{ // MessageBox.Show("请填写完整"); // //return; //} else { return; } }
/// <summary> /// 标准款s_style_p写入数据 /// </summary> /// <param name="uc"></param> public static void insertS_Style_P(UC款式卡片 uc) { 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[] { Frm定制下单修改尺寸.styleid.ToString(), "18", "", "STYLE_SOURCE-STYLE_SOURCE_50", uc.sTYLE_CATEGORY_CD, Frm面料选择.mianliaoid, uc.sTYLE_SIZE_GROUP_CD, Frm定制下单修改尺寸.sTYLE_SIZE_CD, "4SMA-4M", "1", "0", "1", uc.kuanshimingcheng, "", Frm客户.customer_countid.ToString(), uc.sTYLE_FIT_CD, uc.kuanshiid, uc.sTYLE_DRESS_CATEGORY, uc.sTYLE_DESIGN_TYPE, uc.sTYLE_PUBLISH_CATEGORY_CD, uc.sYTLE_YEAR, uc.sYTLE_SEASON }); }