/// <summary> /// 保存订单任务 /// </summary> /// <param name="taskDTo"></param> public static void Save订单任务(TaskDTO taskDTo) { if (taskDTo.remark_id == "" || taskDTo.remark_id == null) { SQLmtm.DoInsert("t_remark", new string[] { "order_id", "remark", "file_name", "template_id", "data", "style_id", "ref_style_id", "serial_number", "status" }, new string[] { taskDTo.order_id, taskDTo.remark, taskDTo.file_name, taskDTo.template_id, taskDTo.data, taskDTo.style_id, taskDTo.ref_style_id, taskDTo.serial_number, taskDTo.status }); } }
/// <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" }); }
/* * public static void uploadTaskFile(String taskId, String empId) * { * OpenFileDialog ofd = new OpenFileDialog(); * ofd.Title = "请选择文件"; * ofd.Filter = "(*xlsx;*.xls;*.docx;*.doc;*.pdf)|*xlsx;*.xls;*.docx;*.doc;*.pdf"; * //ofd.ShowDialog(); * if (ofd.ShowDialog() == DialogResult.OK) * { * Byte[] byteArray = FileBinaryConvertHelper.File2Bytes(ofd.FileName); * String fileStr = Convert.ToBase64String(byteArray); * * String uuid = System.Guid.NewGuid().ToString("N"); * string sql = "insert into file (id,filename,file)" + " values('" + uuid + "'" + " , '" + ofd.SafeFileName + "'" + " , '" + fileStr + "'); "; + DBUtil.ExecuteSQL(sql); + sql = "update custom_appointment_assignee" + " set file_id = '" + uuid + "'" + " , status = '" + (int)EnumAssignment.已完成 + "'" + " where task_id = '" + taskId + "' and emp_id = '" + empId + "'; "; + int i = DBUtil.ExecuteSQL(sql); + //int i = DocService.UpdataMoBan(str, ofd.SafeFileName, fileName); + if (i != 0) + { + MessageBox.Show("上传成功"); + } + } + }*/ /// <summary> /// 保存备注文档 /// </summary> /// <param name="file"></param> /// <param name="fileName"></param> /// <param name="orderid"></param> public static void SaveRemarkFile(String file, String fileName, String orderid) { String sql = "SELECT * FROM t_remark WHERE order_id='" + orderid + "'"; if (SQLmtm.GetDataRow(sql) == null) { SQLmtm.DoInsert("t_remark", new string[] { "order_id", "remark", "file_name" }, new string[] { orderid, file, fileName }); } else { SQLmtm.DoUpdate("t_remark", new string[] { "remark" }, new string[] { file }, new string[] { "order_id" }, new string[] { orderid }); } }
/// <summary> /// 面料打印log信息写入 /// </summary> /// <param name="id"></param> public static void InsertMianLiaoLog(String id) { DataRow dr = SQLmtm.GetDataRow("SELECT\n" + " * \n"+ "FROM\n" + " t_material_log \n"+ "WHERE\n" + " material_id = "+ id + ";"); if (dr == null) { SQLmtm.DoInsert("t_material_log", new string[] { "material_id", "enable_flag" }, new string[] { id, "1" }); } }
/// <summary> /// 生成出库单 /// </summary> /// <param name="godown_date"></param> /// <param name="godown_code"></param> /// <param name="shop_id"></param> /// <param name="barCodeInfoDtos"></param> public static void generateStockOut(DateTime godown_date, String godown_code, String shop_id, BindingList <BarCodeInfoDto> barCodeInfoDtos) { String godown_id = System.Guid.NewGuid().ToString("N"); // 出货单 SQLmtm.DoInsert( "t_godown_bill" , new string[] { "godown_id", "godown_date", "godown_code", "shop_id" } , new string[] { godown_id, godown_date.ToString(), godown_code, shop_id } ); // 出货单分录 foreach (BarCodeInfoDto barCodeInfo in barCodeInfoDtos) { SQLmtm.DoInsert( "t_godown_entry" , new string[] { "godown_entry_id", "godown_id", "barcode_id", "is_validate" } , new string[] { System.Guid.NewGuid().ToString("N"), godown_id, barCodeInfo.Id, "1" } ); } }
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; } }
/// <summary> /// 无订单打印日志 /// </summary> /// <param name="dTO"></param> public static void save_noorder_print_p(DTO无订单打印 dTO) { int i = SQLmtm.DoInsert("a_noorder_print_p", new string[] { "clothes_log_id", "shop_id", "style_id", "materials_id", "size_cd", "json" }, new string[] { dTO.clothes_log_id, dTO.shop_id, dTO.style_id, dTO.materials_id, dTO.size_cd, dTO.json }); }