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