/// <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 });
}
