public static void save设计点(String Style_Id, Dto尺寸 Dto尺寸) { SQLmtm.DoUpdate( "s_style_fit_r" , new string[] { "PHASE_CD", "ITEM_CD", "ITEM_VALUE", "FIT_VALUE", "FM_VALUE", "DELETE_FLAG", "VERSION", "CREATE_USER", "IN_VALUE", "OUT_VALUE" } , new string[] { "AUDIT_PHASE_CD-PHASE_CD_10", Dto尺寸.ITEM_CD, Dto尺寸.ITEM_VALUE, Dto尺寸.FIT_VALUE, Dto尺寸.FM_VALUE, "0", "1", "46", Dto尺寸.IN_VALUE, Dto尺寸.OUT_VALUE } , new string[] { "STYLE_ID" } , new string[] { Style_Id } ); }
/// <summary> /// 更改订单打印状态 /// </summary> /// <param name="orderid"></param> /// <param name="b"></param> public static void UpdataOrderPrintFlag(String orderid, bool b) { if (b == true) { SQLmtm.DoUpdate("o_order_p", new string[] { "PRINT_FLAG" }, new string[] { "1" }, new string[] { "ORDER_ID" }, new string[] { orderid }); } else { SQLmtm.DoUpdate("o_order_p", new string[] { "PRINT_FLAG" }, new string[] { "0" }, new string[] { "ORDER_ID" }, new string[] { orderid }); } }
/* * 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> /// 修改设计点 /// </summary> /// <param name="Dto设计点"></param> /// <param name="styleid"></param> public static void Change设计点(Dto设计点 Dto设计点, String styleid) { SQLmtm.DoUpdate("s_style_option_r", new string[] { "OPTION_VALUE" }, new string[] { Dto设计点.OPTION_VALUE }, new string[] { "SYS_STYLE_ID", "ITEM_VALUE" }, new string[] { styleid, Dto设计点.ITEM_VALUE }); }
/// <summary> /// 更改订单状态(MS_01未签收)(MS_02已签收)(MS_03已完成) /// </summary> /// <param name="remark_id"></param> /// <param name="status"></param> public static void UpdataStatus(String remark_id, String status) { SQLmtm.DoUpdate("t_remark", new string[] { "status" }, new string[] { status }, new string[] { "remark_id" }, new string[] { remark_id }); }
/// <summary> /// 保存Answer任务 /// </summary> /// <param name="taskDTO"></param> public static void SaveAnswer任务(TaskDTO taskDTO) { SQLmtm.DoUpdate("t_remark", new string[] { "A_JSON", "A_FILE", "status" }, new string[] { taskDTO.A_JSON, taskDTO.A_FILE, taskDTO.status }, new string[] { "remark_id" }, new string[] { taskDTO.remark_id }); }
/// <summary> /// 更改面料 /// </summary> /// <param name="orderid"></param> /// <param name="fabricid"></param> public static void ChangeFabric(String styleid, String fabricid) { SQLmtm.DoUpdate("s_style_p", new string[] { "SYTLE_FABRIC_ID" }, new string[] { fabricid }, new string[] { "SYS_STYLE_ID" }, new string[] { styleid }); }