using Newtonsoft.Json.Linq;
|
using Pub_Class;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Web.Http;
|
using WebAPI.Models;
|
namespace WebAPI.Controllers
|
{
|
/**
|
* 找货单单
|
*/
|
public class Sc_CheckToolsRepairWorkBillListController : ApiController
|
{
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更）
|
|
private json objJsonResult = new json();
|
public DataSet ds = new DataSet();
|
public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
public WebServer webserver = new WebServer();
|
|
public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //模具报废入库对应单据类
|
public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill(); //模具报废入库对应单据类
|
|
public DLL.ClsSc_MouldRepairInBill BillNew01 = new DLL.ClsSc_MouldRepairInBill(); //模具改制入库对应单据类
|
public DLL.ClsSc_MouldRepairInBill BillOld01 = new DLL.ClsSc_MouldRepairInBill(); //模具改制入库对应单据类
|
|
/// <summary>
|
/// 根据包装单 返回此包装单内的相关信息
|
/// </summary>
|
/// <returns></returns>
|
|
/// <summary>
|
/// 检具维修工单列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Sc_CheckToolsRepairWorkBillList/GetCheckToolsRepairWorkBillList")]
|
[HttpGet]
|
public object GetCheckToolsRepairWorkBillList(string sWhere)
|
{
|
try
|
{
|
|
ds = Sc_CheckToolsRepairWorkBillList(sWhere);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "返回记录成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception ex)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
#region sql语句
|
|
|
public static DataSet Sc_CheckToolsRepairWorkBillList(string sWhere)
|
{
|
return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairInBillList ", "h_v_Sc_MouldRepairInBillList");
|
}
|
|
|
|
|
|
|
///// <summary>
|
///// 检具点检计划表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_CheckToolsDotCheckPlan/GetCheckToolsDotCheckPlanBillList")]
|
//[HttpGet]
|
//public object GetCheckToolsDotCheckPlanBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_CheckToolsDotCheckPlanBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_CheckToolsDotCheckPlanBillList_s(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsDotCheckPlanBillList ", "h_v_Sc_CheckToolsDotCheckPlanBillList");
|
//}
|
//#endregion
|
|
///// <summary>
|
///// 检具保养记录表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_CheckToolsMaintainBill/GetCheckToolsMaintainBillList")]
|
//[HttpGet]
|
//public object GetCheckToolsMaintainBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_CheckToolsMaintainBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_CheckToolsMaintainBillList_s(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsMaintainBillList ", "h_v_Sc_CheckToolsMaintainBillList");
|
//}
|
//#endregion
|
|
///// <summary>
|
///// 模具保养记录表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldMaintainBill/GetMouldMaintainBillList")]
|
//[HttpGet]
|
//public object GetMouldMaintainBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_MouldMaintainBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_MouldMaintainBillList_s(string sWhere)
|
//{
|
// if (sWhere == null || sWhere.Equals(""))
|
// {
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintain", "h_v_Sc_MouldMaintain");
|
// }
|
// else
|
// {
|
// string sql1 = "select * from h_v_Sc_MouldMaintain where 1 = 1 ";
|
// string sql = sql1 + sWhere;
|
// return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldMaintain");
|
|
// }
|
// //return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainBillList ", "h_v_Sc_MouldMaintainBillList");
|
//}
|
//#endregion
|
|
|
|
///// <summary>
|
///// 模具点检计划表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldDotCheckPlanBill/GetMouldDotCheckPlanBillList")]
|
//[HttpGet]
|
//public object GetMouldDotCheckPlanBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_MouldDotCheckPlanBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_MouldDotCheckPlanBillList_s(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckPlanBillList ", "h_v_Sc_MouldDotCheckPlanBillList");
|
//}
|
//#endregion
|
|
///// <summary>
|
///// 模具点检记录表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldDotCheckBill/GetMouldDotCheckBillList")]
|
//[HttpGet]
|
//public object GetMouldDotCheckBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_MouldDotCheckBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_MouldDotCheckBillList_s(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList where 1=1 "+sWhere+" ", "h_v_Sc_MouldDotCheckBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 检具保养计划表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_CheckToolsMaintainPlanBill/GetCheckToolsMaintainPlanBillList")]
|
//[HttpGet]
|
//public object GetCheckToolsMaintainPlanBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_CheckToolsMaintainPlanBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_CheckToolsMaintainPlanBillList_s(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsMaintainPlanBillList ", "h_v_Sc_CheckToolsMaintainPlanBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 模具保养计划表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldMaintainPlanBill/GetMouldMaintainPlanBillList")]
|
//[HttpGet]
|
//public object GetMouldMaintainPlanBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_MouldMaintainPlanBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_MouldMaintainPlanBillList_s(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainPlanBillList ", "h_v_Sc_MouldMaintainPlanBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 模具故障登记表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldConkBookBill/GetMouldConkBookBillList")]
|
//[HttpGet]
|
//public object GetMouldConkBookBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_MouldConkBookBillList_s(sWhere);
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "Sucess！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_MouldConkBookBillList_s(string sWhere)
|
//{
|
// DataSet ds;
|
// if (sWhere == null || sWhere.Equals(""))
|
// {
|
// ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList " + sWhere, "h_v_Sc_MouldConkBookBillList");
|
// }
|
// else
|
// {
|
// string sql1 = "select * from h_v_Sc_MouldConkBookBillList where 1 = 1 ";
|
// string sql = sql1 + sWhere;
|
// ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldConkBookBillList");
|
// }
|
// return ds;
|
//}
|
//#endregion
|
|
|
|
///// <summary>
|
///// 模具维修验收单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldRepairCheckBill/GetMouldRepairCheckBillList")]
|
//[HttpGet]
|
//public object GetMouldRepairCheckBillList(string sWhere)
|
//{
|
// try
|
// {
|
// ds = Sc_MouldRepairCheckBillList_s(sWhere);
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_MouldRepairCheckBillList_s(string sWhere)
|
//{
|
// DataSet ds;
|
// if (sWhere == null || sWhere.Equals(""))
|
// {
|
// ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairCheckBillList_Edit " + sWhere, "h_v_Sc_MouldRepairCheckBillList_Edit");
|
// }
|
// else
|
// {
|
// string sql1 = "select * from h_v_Sc_MouldRepairCheckBillList_Edit where 1 = 1 ";
|
// string sql = sql1 + sWhere;
|
// ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairCheckBillList_Edit");
|
// }
|
// return ds;
|
//}
|
//#endregion
|
|
///// <summary>
|
///// 检具维修验收单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_CheckToolsRepairCheckBill/GetCheckToolsRepairCheckBillList")]
|
//[HttpGet]
|
//public object GetCheckToolsRepairCheckBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_CheckToolsRepairCheckBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_CheckToolsRepairCheckBillList_s(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsRepairCheckBillList ", "h_v_Sc_CheckToolsRepairCheckBillList");
|
//}
|
//#endregion
|
|
|
//#region sql语句
|
|
|
////public static DataSet Sc_MouldRepairCheckBillList_s(string sWhere)
|
////{
|
//// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairCheckBillList ", "h_v_Sc_MouldRepairCheckBillList");
|
////}
|
//#endregion
|
|
///// <summary>
|
///// 模具维修工单表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sb_MouldRepairWorkBill/GetMouldRepairWorkBillList")]
|
//[HttpGet]
|
//public object GetMouldRepairWorkBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_MouldRepairWorkBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_MouldRepairWorkBillList_s(string sWhere)
|
//{
|
// if (sWhere == null || sWhere.Equals(""))
|
// {
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairWorkBillList " + sWhere, "h_v_Sc_MouldRepairWorkBillList");
|
// }
|
// else
|
// {
|
// string sql1 = "select * from h_v_Sc_MouldRepairWorkBillList where 1 = 1 ";
|
// string sql = sql1 + sWhere;
|
// return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairWorkBillList");
|
// }
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 检具故障登记表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_CheckToolsConkBookBill/GetCheckToolsConkBookBillList")]
|
//[HttpGet]
|
//public object GetCheckToolsConkBookBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_CheckToolsConkBookBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_CheckToolsConkBookBillList_s(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsConkBookBillList ", "h_v_Sc_CheckToolsConkBookBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 检具点检记录表列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_CheckToolsDotCheckBill/GetCheckToolsDotCheckBillList")]
|
//[HttpGet]
|
//public object GetCheckToolsDotCheckBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_CheckToolsDotCheckBillList_s(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_CheckToolsDotCheckBillList_s(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsDotCheckBillList ", "h_v_Sc_CheckToolsDotCheckBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 调拨单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Kf_MoveStockBill/GetMoveStockBillList")]
|
//[HttpGet]
|
//public object GetMoveStockBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetMoveStockBillList(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_GetMoveStockBillList(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_MoveStockBillList ", "h_v_IF_MoveStockBillList");
|
//}
|
//#endregion
|
|
///// <summary>
|
///// 生产领料单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Kf_MateOutBill/GetMateOutBillList")]
|
//[HttpGet]
|
//public object GetMateOutBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetMateOutBillList(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_GetMateOutBillList(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_MateOutBillList ", "h_v_IF_MateOutBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 销售出库单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Kf_SellOutBill/GetSellOutBillList")]
|
//[HttpGet]
|
//public object GetSellOutBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetSellOutBillList(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_GetSellOutBillList(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList ", "h_v_IF_SellOutBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 其他出库单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Kf_OtherOutBill/GetOtherOutBillList")]
|
//[HttpGet]
|
//public object GetOtherOutBillList(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetOtherOutBillList(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_GetOtherOutBillList(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Kf_OtherOutBillList ", "h_v_Kf_OtherOutBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 委外出库单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Kf_EntrustOutBill/GetEntrustOutBill")]
|
//[HttpGet]
|
//public object GetEntrustOutBill(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetEntrustOutBill(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_GetEntrustOutBill(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Kf_EntrustOutBillList ", "h_v_Kf_EntrustOutBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 采购入库单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Kf_POStockInBill/GetPOStockInBill")]
|
//[HttpGet]
|
//public object GetPOStockInBill(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetPOStockInBill(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_GetPOStockInBill(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_POStockInBillList ", "h_v_IF_POStockInBillList");
|
//}
|
//#endregion
|
|
|
|
///// <summary>
|
///// 产品入库单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Kf_ProductInBill/GetProductInBill")]
|
//[HttpGet]
|
//public object GetProductInBill(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetProductInBill(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_GetProductInBill(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_ProductInBillList ", "h_v_IF_ProductInBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 其他入库单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Kf_OtherInBill/GetOtherInBill")]
|
//[HttpGet]
|
//public object GetOtherInBill(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetOtherInBill(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_GetOtherInBill(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Kf_OtherInBillList ", "h_v_Kf_OtherInBillList");
|
//}
|
//#endregion
|
|
|
///// <summary>
|
///// 委外入库单列表
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Kf_EntrustInBill/GetEntrustInBill")]
|
//[HttpGet]
|
//public object GetEntrustInBill(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetEntrustInBill(sWhere);
|
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//#region sql语句
|
|
|
//public static DataSet Sc_GetEntrustInBill(string sWhere)
|
//{
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Kf_EntrustInBillList ", "h_v_Kf_EntrustInBillList");
|
//}
|
//#endregion
|
|
|
////测试专用接口
|
//[Route("LookingFor/Test")]
|
//[HttpGet]
|
//public object Test(string HbillNo)//Sc_CheckToolsRepair/GetCheckToolsRepairWorkBillList
|
//{
|
// DataSet ds;
|
// ds = new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_Xs_SellOutFindSP '" + HbillNo + "'", "h_p_Xs_SellOutFindSP");
|
|
// if (Pub_Class.ClsPub.isLong(ds.Tables[0].Rows.Count) >= 0)
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "true！";
|
// objJsonResult.data = ds.Tables[0];//ds.Tables[0].Rows[1][0]
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "false！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
|
|
//#endregion
|
|
|
//#region 模具维修单保存/编辑
|
///// <summary>
|
///// 保存模具维修单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sb_MouldRepairWorkBill/SaveGetMouldRepairWorkBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldRepairWorkBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DAL.ClsSb_MouldRepairWorkBill oBill = new DAL.ClsSb_MouldRepairWorkBill();
|
// List<Model.ClsSb_MouldRepairWorkBillMain> lsmain = new List<Model.ClsSb_MouldRepairWorkBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Gy_MouldRepairWorkBillMain(msg2);
|
// foreach (Model.ClsSb_MouldRepairWorkBillMain oItem in lsmain)
|
// {
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3807";
|
// oItem.HBillSubType = "3807";
|
// //oItem.HBillNo = ""; //单据号
|
// //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
// //oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
|
// //oItem.HPeriod = 0;
|
// //oItem.HRepairBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修开始日期
|
// //oItem.HRepairEndDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --维修结束日期
|
// //oItem.HRepairContent = ""; //维修内容
|
// //oItem.HCycleUnit = ""; //时间单位(小时，天)
|
// //oItem.HPlanTimes = 0; //计划维修工时
|
// //oItem.HTimes = 0; //实际维修工时
|
// //oItem.HEmpID = 0; //维修人(Gy_Employee)
|
// //oItem.HManagerID = 0; //主管(Gy_Employee)
|
// //oItem.HDeptID = 0; //维修部门(Gy_Department)
|
// //oItem.HExplanation = ""; //--维修要求
|
// //oItem.HInnerBillNo = ""; // --内部单据号
|
// //oItem.HMouldID = 0; //成品模具ID
|
// //oItem.HSupID = 0; //--供应商（Gy_Supplier）
|
// //oItem.HRepairType = ""; //--维修类型（内部维修，委外维修） addnew
|
// //oItem.HNewModel = ""; //维修后新规格
|
// //oItem.HNewDesignLife = 0; //新设计寿命
|
// //oItem.HRepairID = 0; //维修项目(Gy_Repair)
|
// //oItem.HRemark = ""; //备注
|
// //oItem.HMainSourceInterID = oItem.HInterID;
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSb_MouldRepairWorkBillSub> ls = new List<Model.ClsSb_MouldRepairWorkBillSub>();
|
// ls = oListModels.getObjectByJson_Gy_MouldRepairWorkBillSub(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSb_MouldRepairWorkBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //oItemSub.HRepairID = 0; //维修项目
|
// //oItemSub.HRepairExplanation =""; //维修要求
|
// //oItemSub.HManagerID = 0; //负责人ID
|
// //oItemSub.HMoney = 0; //维修费用
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#region[模具维修列表编辑时获取表头数据]
|
//[Route("Sb_MouldRepairWorkBill/Sb_MouldRepairWorkBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sb_MouldRepairWorkBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldRepairWorkBillList_Edit where hmainid= " + HID + " ", "h_v_Sc_MouldRepairWorkBillList_Edit");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在维修单号" };
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
|
//#region[模具维修列表编辑时获取表体数据]
|
//[Route("Sb_MouldRepairWorkBill/Sb_MouldRepairWorkBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sb_MouldRepairWorkBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
// //ds = oCN.RunProcReturn("select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark from Sc_MouldRepairWorkBillSub", "Sc_MouldRepairWorkBillSub");
|
// ds = oCN.RunProcReturn("select HRepairID, 子维修项目代码 HRepairCode,子维修项目 HRepairName,子维修要求 HRepairExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,维修费用 HMoney,表体备注 HRemark from h_v_Sc_MouldRepairWorkBillList_Edit", "h_v_Sc_MouldRepairWorkBillList_Edit");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
// //string sql1 = "select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark from Sc_MouldRepairWorkBillSub where 1 = 1 ";
|
// string sql1 = "select HRepairID,子维修项目代码 HRepairCode,子维修项目 HRepairName,子维修要求 HRepairExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,维修费用 HMoney,表体备注 HRemark from h_v_Sc_MouldRepairWorkBillList_Edit where 1 = 1 ";
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairWorkBillList_Edit");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region [模具维修单删除功能]
|
///// <summary>
|
///// 模具维修单删除功能
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sb_MouldRepairWorkBill/DeltetMouldRepairWorkBill")]
|
//[HttpGet]
|
//public object DeltetMouldRepairWorkBill(string HInterID)
|
//{
|
// //编辑权限
|
// //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // objJsonResult.code = "0";
|
// // objJsonResult.count = 0;
|
// // objJsonResult.Message = "无删除权限！";
|
// // objJsonResult.data = null;
|
// // return objJsonResult;
|
// //}
|
|
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSb_MouldRepairWorkBill oBill = new DAL.ClsSb_MouldRepairWorkBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#region [模具维修单审核、反审核]
|
///// <summary>
|
/////
|
///// </summary>
|
///// <param name="HInterID">单据ID</param>
|
///// <param name="IsAudit">审核(0),反审核(1)</param>
|
///// <param name="CurUserName">审核人</param>
|
///// <returns></returns>
|
//[Route("Sb_MouldRepairWorkBill/AuditProcessReportList")]
|
//[HttpGet]
|
//public object AuditProcessReportList(int HInterID, int IsAudit, string CurUserName)
|
//{
|
// string ModRightNameCheck = "Sb_MouldRepairWorkBill_Check";
|
// DBUtility.ClsPub.CurUserName=CurUserName;
|
// try
|
// {
|
// //审核权限
|
// if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName))
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "审核失败！无权限！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (HInterID <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "HInterID小于0！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// DAL.ClsSb_MouldRepairWorkBill oBill = new DAL.ClsSb_MouldRepairWorkBill();
|
// //查看是否已审核,关闭,作废
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HCloseMan.Trim() != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已关闭!不能再次审核！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HDeleteMan.Trim() != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已作废!不能再次审核！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (IsAudit == 0) //审核判断
|
// {
|
// if (oBill.omodel.HChecker.Trim() != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已审核!不能再次审核！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// if (IsAudit == 1) //反审核判断
|
// {
|
// if (oBill.omodel.HChecker.Trim() == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未审核!不需要反审核!";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (IsAudit == 0) //审核提交
|
// {
|
// //审核提交
|
// if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "审核成功";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// if (IsAudit == 1) //反审核提交
|
// {
|
// //反审核提交AbandonCheck
|
// if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "反审核成功";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// return objJsonResult;
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "审核失败或者反审核失败！" + e.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
|
|
//#region 模具维修验收单保存/编辑
|
///// <summary>
|
///// 保存模具维修单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldRepairCheckBill/SaveGetMouldRepairCheckBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldRepairCheckBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
// string msg4 = sArray[2].ToString();
|
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DLL.ClsSc_MouldRepairCheckBill oBill = new DLL.ClsSc_MouldRepairCheckBill();
|
// List<Model.ClsSc_MouldRepairCheckBillMain> lsmain = new List<Model.ClsSc_MouldRepairCheckBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Gy_MouldRepairCheckBillMain(msg2);
|
// foreach (Model.ClsSc_MouldRepairCheckBillMain oItem in lsmain)
|
// {
|
// oItem.HMaker = msg4;
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3817";
|
// oItem.HBillSubType = "3817";
|
// //oItem.HBillNo = ""; //单据号
|
// //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// //oItem.HInnerBillNo = ""; // --内部单据号
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
// //oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
|
// //oItem.HPeriod = 0;
|
// //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期
|
// //oItem.HCheckResult = ""; //验收结论--(正常，异常)
|
// //oItem.HEmpID = 0; //验收人(Gy_Employee)
|
// //oItem.HManagerID = 0; //负责人(Gy_Employee)
|
// //oItem.HDeptID = 0; //验收部门(Gy_Department)
|
// //oItem.HExplanation = ""; //摘要(故障描述)
|
// //oItem.HRemark = ""; //备注
|
|
// //oItem.HMainSourceInterID = oItem.HInterID;
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldRepairCheckBillSub> ls = new List<Model.ClsSc_MouldRepairCheckBillSub>();
|
// ls = oListModels.getObjectByJson_Gy_MouldRepairCheckBillSub(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSc_MouldRepairCheckBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
|
// //oItemSub.HRepairCheckID = 0; //验收项目ID
|
// //oItemSub.HRepairCheckContent = ""; //验收内容
|
// //oItemSub.HManagerID = 0; //负责人ID
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// //oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //oItemSub.HRepairID = 0; //维修项目
|
// //oItemSub.HRepairExplanation =""; //维修要求
|
|
// //oItemSub.HMoney = 0; //维修费用
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#region[模具维修验收单编辑时获取表头数据]
|
//[Route("Sc_MouldRepairCheckBill/Sb_MouldRepairCheckBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sb_MouldRepairCheckBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldRepairCheckBillList_Edit where hmainid= " + HID + " ", "h_v_Sc_MouldRepairCheckBillList_Edit");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在维修单号" };
|
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
|
//#region[模具维修验收单编辑时获取表体数据]
|
//[Route("Sc_MouldRepairCheckBill/Sb_MouldRepairCheckBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sb_MouldRepairCheckBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
|
// //ds = oCN.RunProcReturn("select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub", "Sc_MouldRepairCheckBillSub");
|
// ds = oCN.RunProcReturn("select HRepairCheckID,验收项目代码 HRepairCheckCode,验收项目 HRepairCheckName,验收内容 HRepairCheckContent,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldRepairCheckBillList_Edit", "h_v_Sc_MouldRepairCheckBillList_Edit");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
|
// //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 ";
|
// string sql1 = "select HRepairCheckID,验收项目代码 HRepairCheckCode,验收项目 HRepairCheckName,验收内容 HRepairCheckContent,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldRepairCheckBillList_Edit where 1 = 1 ";
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairCheckBillList_Edit");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region [模具维修验收单删除功能]
|
///// <summary>
|
///// 模具维修单删除功能
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldRepairCheckBill/DeltetMouldRepairCheckBill")]
|
//[HttpGet]
|
//public object DeltetMouldRepairCheckBill(string HInterID)
|
//{
|
// //编辑权限
|
// //if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairCheckBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // objJsonResult.code = "0";
|
// // objJsonResult.count = 0;
|
// // objJsonResult.Message = "无删除权限！";
|
// // objJsonResult.data = null;
|
// // return objJsonResult;
|
// //}
|
|
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSc_MouldRepairCheckBill oBill = new DAL.ClsSc_MouldRepairCheckBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
|
//#region 模具故障登记表
|
|
//#region 模具故障登记表保存/编辑
|
///// <summary>
|
///// 保存模具维修单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldConkBookBill/SaveGetMouldConkBookBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldConkBookBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DAL.ClsSc_MouldConkBookBill oBill = new DAL.ClsSc_MouldConkBookBill();
|
// List<Model.ClsSc_MouldConkBookBillMain> lsmain = new List<Model.ClsSc_MouldConkBookBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Gy_MouldConkBookBillMain(msg2);
|
// foreach (Model.ClsSc_MouldConkBookBillMain oItem in lsmain)
|
// {
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// DBUtility.ClsPub.CurUserName = UserName;
|
// oItem.HBillType = "3815";
|
// oItem.HBillSubType = "3815";
|
// //oItem.HBillNo = ""; //单据号
|
// //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// //oItem.HInnerBillNo = ""; // --内部单据号
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
// //oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
|
// //oItem.HPeriod = 0;
|
// //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期
|
// //oItem.HCheckResult = ""; //验收结论--(正常，异常)
|
// //oItem.HEmpID = 0; //验收人(Gy_Employee)
|
// //oItem.HManagerID = 0; //负责人(Gy_Employee)
|
// //oItem.HDeptID = 0; //验收部门(Gy_Department)
|
// //oItem.HExplanation = ""; //摘要(故障描述)
|
// //oItem.HRemark = ""; //备注
|
|
// //oItem.HMainSourceInterID = oItem.HInterID;
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldConkBookBillSub> ls = new List<Model.ClsSc_MouldConkBookBillSub>();
|
// ls = oListModels.getObjectByJson_Gy_MouldConkBookBillSub(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSc_MouldConkBookBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
|
// //oItemSub.HRepairCheckID = 0; //验收项目ID
|
// //oItemSub.HRepairCheckContent = ""; //验收内容
|
// //oItemSub.HManagerID = 0; //负责人ID
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// //oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //oItemSub.HRepairID = 0; //维修项目
|
// //oItemSub.HRepairExplanation =""; //维修要求
|
|
// //oItemSub.HMoney = 0; //维修费用
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#region[模具故障登记表编辑时获取表头数据]
|
//[Route("Sc_MouldConkBookBill/Sb_MouldConkBookBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sb_MouldConkBookBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldConkBookBillList_Edit where hmainid= " + HID + " ", "h_v_Sc_MouldConkBookBillList_Edit");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在维修单号" };
|
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
|
//#region[模具故障登记表编辑时获取表体数据]
|
//[Route("Sc_MouldConkBookBill/Sb_MouldConkBookBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sb_MouldConkBookBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
|
// //ds = oCN.RunProcReturn("select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub", "Sc_MouldRepairCheckBillSub");
|
// ds = oCN.RunProcReturn("select HConkReasonID,故障原因代码 HConkReasonCode,故障原因 HConkReasonName,故障原因描述 HConkExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldConkBookBillList_Edit", "h_v_Sc_MouldConkBookBillList_Edit");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
|
// //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 ";
|
// string sql1 = "select HConkReasonID,故障原因代码 HConkReasonCode,故障原因 HConkReasonName,故障原因描述 HConkExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldConkBookBillList_Edit where 1 = 1 ";
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldConkBookBillList_Edit");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region [模具故障登记表删除功能]
|
///// <summary>
|
///// 模具维修单删除功能
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldConkBookBill/DeltetMouldConkBookBill")]
|
//[HttpGet]
|
//public object DeltetMouldConkBookBill(string HInterID)
|
//{
|
// //编辑权限
|
// //if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // objJsonResult.code = "0";
|
// // objJsonResult.count = 0;
|
// // objJsonResult.Message = "无删除权限！";
|
// // objJsonResult.data = null;
|
// // return objJsonResult;
|
// //}
|
|
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSc_MouldConkBookBill oBill = new DAL.ClsSc_MouldConkBookBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
//#endregion
|
|
|
//#region 模具保养计划单
|
|
//#region 模具保养计划单 保存/编辑
|
///// <summary>
|
///// 保存模具保养计划单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldMaintainPlanBill/SaveGetMouldMaintainPlanBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldMaintainPlanBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DAL.ClsSc_MouldMaintainPlanBill oBill = new DAL.ClsSc_MouldMaintainPlanBill();
|
// List<Model.ClsSc_MouldMaintainPlanBillMain> lsmain = new List<Model.ClsSc_MouldMaintainPlanBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Gy_MouldMaintainPlanBillMain(msg2);
|
// foreach (Model.ClsSc_MouldMaintainPlanBillMain oItem in lsmain)
|
// {
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3818";
|
// oItem.HBillSubType = "3818";
|
|
// //oItem.HInterID =0;
|
// //oItem.HBillNo = "";
|
// oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// //oItem.HMakeDate = "";
|
// //oItem.HYear = "";
|
// //oItem.HPeriod = "";
|
// //oItem.HRemark = "";
|
// //oItem.HCycleUnit = "";
|
// //oItem.HCheckCycle = "";
|
// //oItem.HBeginDate = "";
|
// //oItem.HEndDate = "";
|
// //oItem.HInnerBillNo = "";
|
// //oItem.HExplanation = "";
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldMaintainPlanBillSub> ls = new List<Model.ClsSc_MouldMaintainPlanBillSub>();
|
// ls = oListModels.getObjectByJson_Gy_MouldMaintainPlanBillSub(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSc_MouldMaintainPlanBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //HMaterID = "";//配件代码
|
// //HUnitID = "";//单位代码
|
// //HQty = "";//实际用量
|
// //HQtyMust = "";//单位用量
|
// //HRemark = "";//备注
|
// //oItemSub.HRepairID = 0; //维修项目
|
// //oItemSub.HRepairExplanation =""; //维修要求
|
// //oItemSub.HManagerID = 0; //负责人ID
|
// //oItemSub.HMoney = 0; //维修费用
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
//#region[模具保养计划单编辑时获取表头数据]
|
//[Route("Sc_MouldMaintainPlanBill/Sc_MouldMaintainPlanBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sc_MouldMaintainPlanBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldMaintainPlanBillList where hmainid= " + HID + " ", "h_v_Sc_MouldMaintainPlanBillList");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在保养计划单" };
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
//#region[模具保养计划单编辑时获取表题数据]
|
//[Route("Sc_MouldMaintainPlanBill/Sc_MouldMaintainPlanBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sc_MouldMaintainPlanBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
// ds = oCN.RunProcReturn("select HMaterID,HUnitID,HQty,HQtyMust,HRemark from Sc_MouldMaintainPlanBillSub", "Sc_MouldMaintainPlanBillSub");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
// string sql1 = "select HMaterID,HUnitID,HQty,HQtyMust,HRemark from Sc_MouldMaintainPlanBillSub where 1 = 1 ";
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "Sc_MouldMaintainPlanBillSub");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
//#region [模具保养计划单删除功能]
|
///// <summary>
|
///// 模具维修单删除功能
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldMaintainPlanBill/DeltetMouldMaintainPlanBill")]
|
//[HttpGet]
|
//public object DeltetMouldMaintainPlanBill(string HInterID)
|
//{
|
// //编辑权限
|
// //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // objJsonResult.code = "0";
|
// // objJsonResult.count = 0;
|
// // objJsonResult.Message = "无删除权限！";
|
// // objJsonResult.data = null;
|
// // return objJsonResult;
|
// //}
|
|
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSc_MouldMaintainPlanBill oBill = new DAL.ClsSc_MouldMaintainPlanBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#endregion
|
|
//#region 模具保养记录表
|
|
//#region 模具保养记录表 保存/编辑
|
///// <summary>
|
///// 保存模具维修单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldMaintainBill/SaveGetMouldMaintainBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldMaintainBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
// string msg4 = sArray[2].ToString();
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DAL.ClsSc_MouldMaintainBill oBill = new DAL.ClsSc_MouldMaintainBill();
|
// List<Model.ClsSc_MouldMaintainBillMain> lsmain = new List<Model.ClsSc_MouldMaintainBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Sc_MouldMaintainBillMain(msg2);
|
// foreach (Model.ClsSc_MouldMaintainBillMain oItem in lsmain)
|
// {
|
// UserName = oItem.HMaker; //制单人
|
// DBUtility.ClsPub.CurUserName = UserName;
|
// oItem.HBillType = "3819";
|
// oItem.HBillSubType = "3819";
|
|
// //oItem.HInterID =0;
|
// //oItem.HBillNo = "";
|
// oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// //oItem.HMakeDate = "";
|
// //oItem.HYear = "";
|
// //oItem.HPeriod = "";
|
// //oItem.HRemark = "";
|
// //oItem.HCycleUnit = "";
|
// //oItem.HCheckCycle = "";
|
// //oItem.HBeginDate = "";
|
// //oItem.HEndDate = "";
|
// //oItem.HInnerBillNo = "";
|
// //oItem.HExplanation = "";
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //保养项表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldMaintainRuleBillSub_Item> ls = new List<Model.ClsSc_MouldMaintainRuleBillSub_Item>();
|
// ls = oListModels.getObjectByJson_Sc_MouldMaintainRuleBillSub_Item(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSc_MouldMaintainRuleBillSub_Item oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// oItemSub.HRelationQty = 0; //关联数量
|
// oBill.DetailCol.Add(oItemSub);
|
|
// }
|
// //配件项表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg4 = msg4.Substring(1, msg4.Length - 2);
|
// msg4 = msg4.Replace("\\", "");
|
// msg4 = msg4.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldMaintainBillSub> ls1 = new List<Model.ClsSc_MouldMaintainBillSub>();
|
// ls1 = oListModels.getObjectByJson_Sc_MouldMaintainBillSub(msg4);
|
// int j = 0;
|
// foreach (Model.ClsSc_MouldMaintainBillSub Sub in ls1)
|
// {
|
|
// j++;
|
// Sub.HEntryID = j;
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// Sub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// Sub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// Sub.HSourceInterID = 0; // 源单主内码
|
// Sub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// Sub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //HMaterID = "";//配件代码
|
// //HUnitID = "";//单位代码
|
// //HQty = "";//实际用量
|
// //HQtyMust = "";//单位用量
|
// //HRemark = "";//备注
|
|
// oBill.DetailColl.Add(Sub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#region[模具保养记录表编辑时获取表头数据]
|
//[Route("Sc_MouldMaintainBill/Sc_MouldMaintainBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sc_MouldMaintainBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldMaintain where hmainid= " + HID + " ", "h_v_Sc_MouldMaintain");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在保养记录表" };
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
|
//#region[模具保养记录表编辑时获取表题数据]
|
//[Route("Sc_MouldMaintainBill/Sc_MouldMaintainBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sc_MouldMaintainBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
// ds = oCN.RunProcReturn("select HMaterID,HUnitID,HQty,HQtyMust,HRemark,HManagerID from Sc_MouldMaintainBillSub", "Sc_MouldMaintainBillSub");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
// string sql1 = "select HMaterID,HUnitID,HQty,HQtyMust,HRemark,HManagerID from Sc_MouldMaintainBillSub where 1 = 1 ";
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "Sc_MouldMaintainBillSub");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region[模具保养记录表编辑时获取表体数据新(保养项列表、配件项列表)]
|
//[Route("Sc_MouldMaintainBill/Sc_MouldMaintainBillListProjectDetaiNew")]
|
//[HttpGet]
|
//public object Sc_MouldMaintainBillListProjectDetaiNew(string HInterID)
|
//{
|
|
// DataSet ds,ds1;
|
// List<object> list = new List<object>();
|
// string Swhere = "";
|
// try
|
// {
|
// if (HInterID != "" || HInterID != null)
|
// {
|
// Swhere = " and hmainid='" + HInterID + "'";
|
// }
|
// else
|
// {
|
// Swhere = HInterID;
|
// }
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// //获取保养项目编辑数据
|
// string sql = "select HMaintainItemID, 保养项目代码 HMaintainItemNumber,保养项目名称 HMaintainItem,保养部位 HMaintainPart,具体要求 HClaim,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName,表体备注 HRemark from h_v_Sc_MouldMaintainBillListItem where 1 = 1 " + Swhere + "";
|
// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainBillListItem");
|
// //获取配件项目编辑数据
|
// string sql1 = "select HMaterID, 配件代码 HMaterNumber,配件名称 HMaterName,规格型号 HMaterSpec,HUnitID,单位代码 HUnitNumber,单位名称 HUnitName,实际用量 HQty,标准用量 HQtyMust,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName,表体备注 HRemark from h_v_Sc_MouldMaintainBillList where 1 = 1 " + Swhere + "";
|
// ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainBillList");
|
// list.Add(ds.Tables[0]);
|
// list.Add(ds1.Tables[0]);
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.list = list;
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region [模具保养记录表删除功能]
|
// /// <summary>
|
// /// 模具维修单删除功能
|
// /// </summary>
|
// /// <returns></returns>
|
// [Route("Sc_MouldMaintainBill/DeltetSc_MouldMaintainBill")]
|
//[HttpGet]
|
//public object DeltetSc_MouldMaintainBill(string HInterID)
|
//{
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSc_MouldMaintainBill oBill = new DAL.ClsSc_MouldMaintainBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#endregion
|
|
//#region 模具点检记录表
|
|
//#region 模具点检记录表 保存/编辑
|
///// <summary>
|
///// 保存模具维修单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldDotCheckBill/SaveGetMouldDotCheckBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldDotCheckBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DAL.ClsSc_MouldDotCheckBill oBill = new DAL.ClsSc_MouldDotCheckBill();
|
// List<Model.ClsSc_MouldDotCheckBillMain> lsmain = new List<Model.ClsSc_MouldDotCheckBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Sc_MouldDotCheckBillMain(msg2);
|
// foreach (Model.ClsSc_MouldDotCheckBillMain oItem in lsmain)
|
// {
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3821";
|
// oItem.HBillSubType = "3821";
|
|
// //oItem.HInterID =0;
|
// //oItem.HBillNo = "";
|
// oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// //oItem.HMakeDate = "";
|
// //oItem.HYear = "";
|
// //oItem.HPeriod = "";
|
// //oItem.HRemark = "";
|
// //oItem.HCycleUnit = "";
|
// //oItem.HCheckCycle = "";
|
// //oItem.HBeginDate = "";
|
// //oItem.HEndDate = "";
|
// //oItem.HInnerBillNo = "";
|
// //oItem.HExplanation = "";
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldDotCheckBillSub> ls = new List<Model.ClsSc_MouldDotCheckBillSub>();
|
// ls = oListModels.getObjectByJson_Sc_MouldDotCheckBillSub(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSc_MouldDotCheckBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //HMaterID = "";//配件代码
|
// //HUnitID = "";//单位代码
|
// //HQty = "";//实际用量
|
// //HQtyMust = "";//单位用量
|
// //HRemark = "";//备注
|
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
|
//#region[模具点检记录表编辑时获取表头数据]
|
//[Route("Sc_MouldDotCheckBill/Sc_MouldDotCheckBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sc_MouldDotCheckBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldDotCheckBillList where hmainid= " + HID + " ", "h_v_Sc_MouldDotCheckBillList");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在点检记录表" };
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
//#region[模具点检记录表编辑时获取表题数据]
|
//[Route("Sc_MouldDotCheckBill/Sc_MouldDotCheckBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sc_MouldDotCheckBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
// ds = oCN.RunProcReturn("select 点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName from h_v_Sc_MouldDotCheckBillList", "h_v_Sc_MouldDotCheckBillList");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
// string sql1 = "select 点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName from h_v_Sc_MouldDotCheckBillList where 1 = 1 ";
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldDotCheckBillList");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region [模具点检记录表删除功能]
|
///// <summary>
|
///// 模具维修单删除功能
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldDotCheckBill/DeltetSc_MouldDotCheckBill")]
|
//[HttpGet]
|
//public object DeltetSc_MouldDotCheckBill(string HInterID)
|
//{
|
// //编辑权限
|
// //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // objJsonResult.code = "0";
|
// // objJsonResult.count = 0;
|
// // objJsonResult.Message = "无删除权限！";
|
// // objJsonResult.data = null;
|
// // return objJsonResult;
|
// //}
|
|
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSc_MouldDotCheckBill oBill = new DAL.ClsSc_MouldDotCheckBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
|
//#endregion
|
|
//#region 模具点检计划表
|
|
//#region 模具点检计划表 保存/编辑
|
///// <summary>
|
///// 保存模具维修单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldDotCheckPlanBill/SaveGetMouldDotCheckPlanBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldDotCheckPlanBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DAL.ClsSc_MouldDotCheckPlanBill oBill = new DAL.ClsSc_MouldDotCheckPlanBill();
|
// List<Model.ClsSc_MouldDotCheckPlanBillMain> lsmain = new List<Model.ClsSc_MouldDotCheckPlanBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Sc_MouldDotCheckPlanBillMain(msg2);
|
// foreach (Model.ClsSc_MouldDotCheckPlanBillMain oItem in lsmain)
|
// {
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3821";
|
// oItem.HBillSubType = "3821";
|
|
// //oItem.HInterID =0;
|
// //oItem.HBillNo = "";
|
// oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// //oItem.HMakeDate = "";
|
// //oItem.HYear = "";
|
// //oItem.HPeriod = "";
|
// //oItem.HRemark = "";
|
// //oItem.HCycleUnit = "";
|
// //oItem.HCheckCycle = "";
|
// //oItem.HBeginDate = "";
|
// //oItem.HEndDate = "";
|
// //oItem.HInnerBillNo = "";
|
// //oItem.HExplanation = "";
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldDotCheckPlanBillSub> ls = new List<Model.ClsSc_MouldDotCheckPlanBillSub>();
|
// ls = oListModels.getObjectByJson_Sc_MouldDotCheckPlanBillSub(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSc_MouldDotCheckPlanBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //HMaterID = "";//配件代码
|
// //HUnitID = "";//单位代码
|
// //HQty = "";//实际用量
|
// //HQtyMust = "";//单位用量
|
// //HRemark = "";//备注
|
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
|
//#region[模具点检计划表编辑时获取表头数据]
|
//[Route("Sc_MouldDotCheckPlanBill/Sc_MouldDotCheckPlanBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sc_MouldDotCheckPlanBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldDotCheckPlanBillList where hmainid= " + HID + " ", "h_v_Sc_MouldDotCheckPlanBillList");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在点检计划表" };
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
//#region[模具点检计划表编辑时获取表题数据]
|
//[Route("Sc_MouldDotCheckPlanBill/Sc_MouldDotCheckPlanBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sc_MouldDotCheckPlanBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
// ds = oCN.RunProcReturn("select HDotCheckItem,HDotCheckPart,HClaim,HRemark,HManagerID from Sc_MouldDotCheckPlanBillSub", "Sc_MouldDotCheckPlanBillSub");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
// string sql1 = "select HDotCheckItem,HDotCheckPart,HClaim,HRemark,HManagerID from Sc_MouldDotCheckPlanBillSub where 1 = 1 ";
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "Sc_MouldDotCheckPlanBillSub");
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何计划！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
|
//#region [模具点检计划表删除功能]
|
///// <summary>
|
///// 模具维修单删除功能
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldDotCheckPlanBill/DeltetSc_MouldDotCheckPlanBillBill")]
|
//[HttpGet]
|
//public object DeltetSc_MouldDotCheckPlanBillBill(string HInterID)
|
//{
|
// //编辑权限
|
// //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // objJsonResult.code = "0";
|
// // objJsonResult.count = 0;
|
// // objJsonResult.Message = "无删除权限！";
|
// // objJsonResult.data = null;
|
// // return objJsonResult;
|
// //}
|
|
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSc_MouldDotCheckPlanBill oBill = new DAL.ClsSc_MouldDotCheckPlanBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
|
//#endregion
|
|
|
|
//#region 模具报废入库单
|
|
|
|
//#region[模具报废入库单编辑时获取表头数据]
|
//[Route("Sc_MouldScrapInHouseBill/Sc_MouldScrapInHouseBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sc_MouldScrapInHouseBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldScrapInHouseBillList where hmainid= " + HID + " ", "h_v_Sc_MouldScrapInHouseBillList");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在维修单号" };
|
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
|
//#region[模具报废入库单编辑时获取表体数据]
|
//[Route("Sc_MouldScrapInHouseBill/Sc_MouldScrapInHouseBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sc_MouldScrapInHouseBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
// ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,HPropertyID,辅助属性代码 HPropertyCode,辅助属性名称 HPropertyName,
|
// HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位名称 HSecUnitName, HUnitID, 计量单位代码 HUnitCode, 计量单位名称 HUnitName, 批次 HBatchNo,
|
// 设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife, 实收数量 HQty, 单价 HPrice, 金额 HMoney, HWHID, 收料仓库代码 HWHCode, 收料仓库名称 HWHName,
|
// HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 备注 HRemark
|
// FROM h_v_Sc_MouldScrapInHouseBillList"), "h_v_Sc_MouldScrapInHouseBillList");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
|
// //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 ";
|
// string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,HPropertyID,辅助属性代码 HPropertyCode,辅助属性名称 HPropertyName,
|
// HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位名称 HSecUnitName, HUnitID, 计量单位代码 HUnitCode, 计量单位名称 HUnitName, 批次 HBatchNo,
|
// 设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife, 实收数量 HQty, 单价 HPrice, 金额 HMoney, HWHID, 收料仓库代码 HWHCode, 收料仓库名称 HWHName,
|
// HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 备注 HRemark
|
// FROM h_v_Sc_MouldScrapInHouseBillList where 1 = 1 ");
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldScrapInHouseBillList");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region 模具报废入库单保存/编辑
|
///// <summary>
|
///// 保存模具报废入库单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldScrapInHouseBill/SaveGetMouldScrapInHouseBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldScrapInHouseBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
// string refSav = sArray[2].ToString();
|
|
// string UserName = "";
|
// string s = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DLL.ClsSc_MouldScrapInBill oBill = new DLL.ClsSc_MouldScrapInBill();
|
// List<Models.ClsSc_MouldStockBillMain> lsmain = new List<Models.ClsSc_MouldStockBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Gy_MouldScrapInHouseBillMain(msg2);
|
// foreach (Models.ClsSc_MouldStockBillMain oItem in lsmain)
|
// {
|
// if (refSav == "Add")
|
// {
|
// //单据号是否重复
|
// if (BillNew0.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld0.omodel.HInterID))
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据号重复！不允许保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// if (refSav == "Update")
|
// {
|
// if (BillOld0.ShowBill(oItem.HInterID, ref s) == false)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "此单据有误！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// //判断是否可编辑
|
// if (BillOld0.omodel.HChecker != "" && BillOld0.omodel.HChecker != null)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "此单据已经被审核，不允许修改！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// if (BillOld0.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "此单据处于不可编辑状态，不允许修改！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld0, ref s))
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = s + "，不允许修改";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3831";
|
// oItem.HBillSubType = "3831";
|
// //oItem.HBillNo = ""; //单据号
|
// //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// //oItem.HInnerBillNo = ""; // --内部单据号
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
// //oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
|
// //oItem.HPeriod = 0;
|
// //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期
|
// //oItem.HCheckResult = ""; //验收结论--(正常，异常)
|
// //oItem.HEmpID = 0; //验收人(Gy_Employee)
|
// //oItem.HManagerID = 0; //负责人(Gy_Employee)
|
// //oItem.HDeptID = 0; //验收部门(Gy_Department)
|
// //oItem.HExplanation = ""; //摘要(故障描述)
|
// //oItem.HRemark = ""; //备注
|
|
// //oItem.HMainSourceInterID = oItem.HInterID;
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Models.ClsSc_MouldStockBillSub> ls = new List<Models.ClsSc_MouldStockBillSub>();
|
// ls = oListModels.getObjectByJson_Gy_MouldScrapInHouseBillSub(msg3);
|
// int i = 0;
|
// foreach (Models.ClsSc_MouldStockBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
|
// //oItemSub.HRepairCheckID = 0; //验收项目ID
|
// //oItemSub.HRepairCheckContent = ""; //验收内容
|
// //oItemSub.HManagerID = 0; //负责人ID
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// //oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //oItemSub.HRepairID = 0; //维修项目
|
// //oItemSub.HRepairExplanation =""; //维修要求
|
// //oItemSub.HMoney = 0; //维修费用
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
|
|
|
//#region 模具报废入库单保存
|
|
//[Route("Sc_MouldScrapInHouseBill/SaveGetMouldScrapInHouseBillList_PDA")]
|
//[HttpPost]
|
//public object SaveGetMouldScrapInHouseBillList_PDA([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
|
// string UserName = "";
|
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DLL.ClsSc_MouldScrapInBill oBill = new DLL.ClsSc_MouldScrapInBill();
|
// List<Models.ClsSc_MouldStockBillMain> lsmain = new List<Models.ClsSc_MouldStockBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Gy_MouldScrapInHouseBillMain(msg2);
|
// foreach (Models.ClsSc_MouldStockBillMain oItem in lsmain)
|
// {
|
// //单据号是否重复
|
// if (BillNew0.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld0.omodel.HInterID))
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据号重复！不允许保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3831";
|
// oItem.HBillSubType = "3831";
|
// //oItem.HBillNo = ""; //单据号
|
// //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// //oItem.HInnerBillNo = ""; // --内部单据号
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
// //oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
|
// //oItem.HPeriod = 0;
|
// //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期
|
// //oItem.HCheckResult = ""; //验收结论--(正常，异常)
|
// //oItem.HEmpID = 0; //验收人(Gy_Employee)
|
// //oItem.HManagerID = 0; //负责人(Gy_Employee)
|
// //oItem.HDeptID = 0; //验收部门(Gy_Department)
|
// //oItem.HExplanation = ""; //摘要(故障描述)
|
// //oItem.HRemark = ""; //备注
|
|
// //oItem.HMainSourceInterID = oItem.HInterID;
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //子表体数据
|
|
// List<Models.ClsSc_MouldStockBillSub> ls = new List<Models.ClsSc_MouldStockBillSub>();
|
// ls = oListModels.getObjectByJson_Gy_MouldScrapInHouseBillSub(msg2);
|
// int i = 0;
|
// foreach (Models.ClsSc_MouldStockBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
|
// //oItemSub.HRepairCheckID = 0; //验收项目ID
|
// //oItemSub.HRepairCheckContent = ""; //验收内容
|
// //oItemSub.HManagerID = 0; //负责人ID
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// //oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //oItemSub.HRepairID = 0; //维修项目
|
// //oItemSub.HRepairExplanation =""; //维修要求
|
// //oItemSub.HMoney = 0; //维修费用
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#endregion
|
|
//#region 模具处理出库单
|
|
//#region 模具处理出库单列表
|
|
//[Route("Sc_MouldScrapOutHouseBill/GetMouldScrapOutHouseBill")]
|
//[HttpGet]
|
//public object GetMouldScrapOutHouseBill(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetMouldScrapOutHouseBill(sWhere);
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//public static DataSet Sc_GetMouldScrapOutHouseBill(string sWhere)
|
//{
|
// if (sWhere == null || sWhere.Equals(""))
|
// {
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldScrapOutHouseBillList ", "h_v_Sc_MouldScrapOutHouseBillList");
|
// }
|
// else
|
// {
|
// string sql1 = "select * from h_v_Sc_MouldScrapOutHouseBillList where 1 = 1 ";
|
// string sql = sql1 + sWhere;
|
// return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldScrapOutHouseBillList");
|
// }
|
//}
|
|
//#endregion
|
|
//#region[模具处理出库单编辑时获取表头数据]
|
//[Route("Sc_MouldScrapOutHouseBill/Sc_MouldScrapOutHouseBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sc_MouldScrapOutHouseBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldScrapOutHouseBillList where hmainid= " + HID + " ", "h_v_Sc_MouldScrapOutHouseBillList");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在维修单号" };
|
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
|
//#region[模具处理出库单编辑时获取表体数据]
|
//[Route("Sc_MouldScrapOutHouseBill/Sc_MouldScrapOutHouseBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sc_MouldScrapOutHouseBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
// ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,HPropertyID,辅助属性代码 HPropertyCode,辅助属性名称 HPropertyName,
|
// HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位名称 HSecUnitName, 换算率 HSecUnitRate, HUnitID, 计量单位代码 HUnitCode, 计量单位名称 HUnitName, 批次 HBatchNo,
|
// 设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife, 实发数量 HQty, 单价 HPrice, 金额 HMoney, HWHID, 发货仓库代码 HWHCode, 发货仓库名称 HWHName,
|
// HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 备注 HRemark FROM h_v_Sc_MouldScrapOutHouseBillList"), "h_v_Sc_MouldScrapOutHouseBillList");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
|
// //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 ";
|
// string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,HPropertyID,辅助属性代码 HPropertyCode,辅助属性名称 HPropertyName,
|
// HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位名称 HSecUnitName, 换算率 HSecUnitRate, HUnitID, 计量单位代码 HUnitCode, 计量单位名称 HUnitName, 批次 HBatchNo,
|
// 设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife, 实发数量 HQty, 单价 HPrice, 金额 HMoney, HWHID, 发货仓库代码 HWHCode, 发货仓库名称 HWHName,
|
// HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 备注 HRemark FROM h_v_Sc_MouldScrapOutHouseBillList where 1 = 1 ");
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldScrapOutHouseBillList");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region 模具处理出库单保存/编辑
|
///// <summary>
|
///// 保存模具处理出库单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldScrapOutHouseBill/SaveGetMouldScrapOutHouseBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldScrapOutHouseBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DLL.ClsSc_MouldScrapOutBill oBill = new DLL.ClsSc_MouldScrapOutBill();
|
// List<Model.ClsSc_MouldStockBillMain> lsmain = new List<Model.ClsSc_MouldStockBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Gy_MouldScrapOutHouseBillMain(msg2);
|
// foreach (Model.ClsSc_MouldStockBillMain oItem in lsmain)
|
// {
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3832";
|
// oItem.HBillSubType = "3832";
|
// //oItem.HBillNo = ""; //单据号
|
// //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// //oItem.HInnerBillNo = ""; // --内部单据号
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
// //oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
|
// //oItem.HPeriod = 0;
|
// //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期
|
// //oItem.HCheckResult = ""; //验收结论--(正常，异常)
|
// //oItem.HEmpID = 0; //验收人(Gy_Employee)
|
// //oItem.HManagerID = 0; //负责人(Gy_Employee)
|
// //oItem.HDeptID = 0; //验收部门(Gy_Department)
|
// //oItem.HExplanation = ""; //摘要(故障描述)
|
// //oItem.HRemark = ""; //备注
|
|
// //oItem.HMainSourceInterID = oItem.HInterID;
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldStockBillSub> ls = new List<Model.ClsSc_MouldStockBillSub>();
|
// ls = oListModels.getObjectByJson_Gy_MouldScrapOutHouseBillSub(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSc_MouldStockBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
|
// //oItemSub.HRepairCheckID = 0; //验收项目ID
|
// //oItemSub.HRepairCheckContent = ""; //验收内容
|
// //oItemSub.HManagerID = 0; //负责人ID
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// //oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //oItemSub.HRepairID = 0; //维修项目
|
// //oItemSub.HRepairExplanation =""; //维修要求
|
// //oItemSub.HMoney = 0; //维修费用
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#region [模具处理出库单删除功能]
|
///// <summary>
|
///// 模具处理出库库单删除功能
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldScrapOutHouseBill/DeltetMouldScrapOutHouseBill")]
|
//[HttpGet]
|
//public object DeltetMouldScrapOutHouseBill(string HInterID)
|
//{
|
// //编辑权限
|
// //if (!DBUtility.ClsPub.Security_Log("Sc_MouldScrapOutBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // objJsonResult.code = "0";
|
// // objJsonResult.count = 0;
|
// // objJsonResult.Message = "无删除权限！";
|
// // objJsonResult.data = null;
|
// // return objJsonResult;
|
// //}
|
|
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSc_MouldScrapInBill oBill = new DAL.ClsSc_MouldScrapInBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#region [模具处理出库单审核、反审核]
|
///// <summary>
|
/////
|
///// </summary>
|
///// <param name="HInterID">单据ID</param>
|
///// <param name="IsAudit">审核(0),反审核(1)</param>
|
///// <param name="CurUserName">审核人</param>
|
///// <returns></returns>
|
//[Route("Sc_MouldScrapOutHouseBill/AuditMouldScrapOutList")]
|
//[HttpGet]
|
//public object AuditMouldScrapOutList(int HInterID, int IsAudit, string CurUserName)
|
//{
|
// string ModRightNameCheck = "Sc_MouldScrapOutBill_Check";
|
// DBUtility.ClsPub.CurUserName = CurUserName;
|
// try
|
// {
|
// //审核权限
|
// if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName))
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "审核失败！无权限！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (HInterID <= 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "HInterID小于0！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// DLL.ClsSc_MouldScrapOutBill oBill = new DLL.ClsSc_MouldScrapOutBill();
|
// //查看是否已审核,关闭,作废
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HCloseMan.Trim() != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已关闭!不能再次审核！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HDeleteMan.Trim() != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已作废!不能再次审核！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (IsAudit == 0) //审核判断
|
// {
|
// if (oBill.omodel.HChecker.Trim() != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已审核!不能再次审核！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// if (IsAudit == 1) //反审核判断
|
// {
|
// if (oBill.omodel.HChecker.Trim() == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未审核!不需要反审核!";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (IsAudit == 0) //审核提交
|
// {
|
// //审核提交
|
// if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "审核成功";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// if (IsAudit == 1) //反审核提交
|
// {
|
// //反审核提交AbandonCheck
|
// if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
// {
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "反审核成功";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// return objJsonResult;
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "审核失败或者反审核失败！" + e.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#endregion
|
|
#region 器具改制入库单
|
|
#region 器具改制入库单据维护列表
|
|
[Route("Sc_CheckToolsRepairWorkBillList/GetMouldRepairInBillList")]
|
[HttpGet]
|
public object GetMouldRepairInBillList(string sWhere,string user, string Organization)
|
{
|
try
|
{
|
//编辑权限
|
if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairIn_SingleBillList", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无查看权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
ds = Sc_MouldRepairInBillList(sWhere,Organization);
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "返回记录成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception ex)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
public static DataSet Sc_MouldRepairInBillList(string sWhere,string Organization)
|
{
|
string sql1 = string.Format(@"select * from h_v_Sc_MouldRepairInBillList where 库存组织='" + Organization + "'");
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by 制单日期 desc", "h_v_Sc_MouldRepairInBillList");
|
}
|
else
|
{
|
string sql = sql1 + sWhere+ "order by 制单日期 desc";
|
return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairInBillList");
|
}
|
|
}
|
|
#endregion
|
|
#region[器具改制入库单编辑时获取表体数据]
|
[Route("Sc_MouldRepairInBill/Sc_MouldRepairInBillListCheckDetai")]
|
[HttpGet]
|
public object Sc_MouldRepairInBillListCheckDetai(string sqlWhere)
|
{
|
DataSet ds;
|
DataSet ds1;
|
List<object> list = new List<object>();
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sqlWhere == null || sqlWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,
|
批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust,
|
实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName
|
FROM h_v_Sc_MouldRepairInBillList"), "h_v_Sc_MouldRepairInBillList");
|
|
|
}
|
else
|
{
|
|
//string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 ";
|
string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,
|
批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust,
|
实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName
|
FROM h_v_Sc_MouldRepairInBillList where 1=1 ");
|
string sql = sql1 + sqlWhere;
|
ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairInBillList");
|
|
}
|
//查汇总
|
ds1 = oCN.RunProcReturn(string.Format(@"select 物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实收数量)实收数量,
|
hwhid,max(仓库代码)仓库代码,max(仓库)仓库,子备注 from h_v_Sc_MouldRepairInBillList
|
where 1=1 " + sqlWhere + " group by 物料代码,规格型号,hwhid,批次,子备注"), "h_v_Sc_MouldRepairInBillList");
|
|
list.Add(ds.Tables[0]);
|
list.Add(ds1.Tables[0]);
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.list = list;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
}
|
return objJsonResult;
|
}
|
#endregion
|
|
#region 器具改制入库单保存/编辑
|
/// <summary>
|
/// 保存器具改制入库单
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
[Route("Sc_MouldRepairInBill/SaveGetMouldRepairInBillList")]
|
[HttpPost]
|
public object SaveGetMouldRepairInBillList([FromBody] JObject msg)
|
{
|
var _value = msg["msg"].ToString();
|
string msg1 = _value.ToString();
|
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string msg2 = sArray[0].ToString();
|
string msg3 = sArray[1].ToString();
|
string refSav = sArray[2].ToString();
|
string msg4 = sArray[3].ToString();
|
|
string UserName = "";
|
string s = "";
|
ListModels oListModels = new ListModels();
|
try
|
{
|
//编辑权限
|
if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairIn_SingleBill_Edit", 1, false, msg4))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无保存权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
DLL.ClsSc_MouldRepairInBill oBill = new DLL.ClsSc_MouldRepairInBill();
|
List<Models.ClsSc_MouldRepairInBillMain> lsmain = new List<Models.ClsSc_MouldRepairInBillMain>();
|
msg2 = msg2.Replace("\\", "");
|
msg2 = msg2.Replace("\n", ""); //\n
|
lsmain = oListModels.getObjectByJson_Gy_MouldRepairInHouseBillMain(msg2);
|
foreach (Models.ClsSc_MouldRepairInBillMain oItem in lsmain)
|
{
|
if (refSav == "Add")
|
{
|
//单据号是否重复
|
if (BillNew01.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld0.omodel.HInterID))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据号重复！不允许保存！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
if (refSav == "Update")
|
{
|
if (BillOld01.ShowBill(oItem.HInterID, ref s) == false)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "此单据有误！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//判断是否可编辑
|
if (BillOld0.omodel.HChecker != "" && BillOld0.omodel.HChecker != null)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "此单据已经被审核，不允许修改！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (BillOld0.omodel.HBillStatus > 1)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "此单据处于不可编辑状态，不允许修改！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld0, ref s))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = s + "，不允许修改";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
//oItem.HMaker = "";
|
UserName = oItem.HMaker; //制单人
|
oItem.HBillType = "3826";
|
oItem.HBillSubType = "3826";
|
//oItem.HBillNo = ""; //单据号
|
//oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
//oItem.HInnerBillNo = ""; // --内部单据号
|
oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
//oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
|
//oItem.HPeriod = 0;
|
//oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期
|
//oItem.HCheckResult = ""; //验收结论--(正常，异常)
|
//oItem.HEmpID = 0; //验收人(Gy_Employee)
|
//oItem.HManagerID = 0; //负责人(Gy_Employee)
|
//oItem.HDeptID = 0; //验收部门(Gy_Department)
|
//oItem.HExplanation = ""; //摘要(故障描述)
|
//oItem.HRemark = ""; //备注
|
|
//oItem.HMainSourceInterID = oItem.HInterID;
|
|
//oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
oBill.omodel = oItem;
|
}
|
//表体数据
|
//按 },{来拆分数组 //去掉【和】
|
msg3 = msg3.Substring(1, msg3.Length - 2);
|
msg3 = msg3.Replace("\\", "");
|
msg3 = msg3.Replace("\n", ""); //\n
|
//msg2 = msg2.Replace("'", "’");
|
List<Models.ClsSc_MouldRepairInBillSub> ls = new List<Models.ClsSc_MouldRepairInBillSub>();
|
ls = oListModels.getObjectByJson_Gy_MouldRepairInHouseBillSub(msg3);
|
int i = 0;
|
foreach (Models.ClsSc_MouldRepairInBillSub oItemSub in ls)
|
{
|
|
i++;
|
oItemSub.HEntryID = i;
|
|
//oItemSub.HRepairCheckID = 0; //验收项目ID
|
//oItemSub.HRepairCheckContent = ""; //验收内容
|
//oItemSub.HManagerID = 0; //负责人ID
|
//oItemSub.HCloseMan = ""; //行关闭
|
oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
oItemSub.HCloseType = false; //关闭类型
|
//oItemSub.HRemark = ""; //备注
|
oItemSub.HSourceInterID = 0; // 源单主内码
|
oItemSub.HSourceEntryID = 0; //源单子内码
|
//oItemSub.HSourceBillNo = ""; //源单单号
|
//oItemSub.HSourceBillType = ""; //源单类型
|
//oItemSub.HRelationQty = 0; //关联数量
|
//oItemSub.HRelationMoney = 0; //关联金额
|
//oItemSub.HRepairID = 0; //维修项目
|
//oItemSub.HRepairExplanation =""; //维修要求
|
//oItemSub.HMoney = 0; //维修费用
|
oBill.DetailColl.Add(oItemSub);
|
|
}
|
//保存
|
//保存完毕后处理
|
bool bResult;
|
if (oBill.omodel.HInterID == 0)
|
{
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
//保存成功
|
string sql = string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' ");
|
oCn.RunProc(sql);
|
}
|
else
|
{
|
bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
//修改成功
|
//string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID 1,{oBill.omodel.HInterID.ToString()},' ' ");
|
string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID ");
|
oCn.RunProc(sql);
|
}
|
if (bResult)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "保存成功！";
|
//WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！" + e.ToString();
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region [器具改制入库单审核、反审核]
|
/// <summary>
|
/// 审核
|
/// </summary>
|
/// <param name="HInterID">单据ID</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Sc_MouldRepairInBill/set_CheckBill")]
|
[HttpGet]
|
public object set_CheckBill(int HInterID, string CurUserName)
|
{
|
string ModRightNameCheck = "Sc_MouldRepairInBill_Check";
|
DBUtility.ClsPub.CurUserName = CurUserName;
|
DLL.ClsSc_MouldRepairInBill oBill = new DLL.ClsSc_MouldRepairInBill();
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//审核前判断是否允许
|
string s = "";
|
if (!DBUtility.Xt_BaseBillFun.Fun_AllowCheckBill(oBill, ref s))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = s + "，不允许审核";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (HInterID <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "HInterID小于0！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
Int64 lngBillKey = 0;
|
lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
//查看是否已审核,关闭,作废
|
if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
if (oBill.omodel.HCloseMan.Trim() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已关闭!不能再次审核！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (oBill.omodel.HDeleteMan.Trim() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已作废!不能再次审核！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (oBill.omodel.HChecker.Trim() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已审核!不能再次审核！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//审核提交
|
if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "审核成功";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
/// <summary>
|
/// 反审核
|
/// </summary>
|
/// <param name="HInterID">单据ID</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Sc_MouldRepairInBill/set_AbandonCheck")]
|
[HttpGet]
|
public object set_AbandonCheck(int HInterID, string CurUserName)
|
{
|
string ModRightNameCheck = "Sc_MouldRepairInBill_Check";
|
DBUtility.ClsPub.CurUserName = CurUserName;
|
DLL.ClsSc_MouldRepairInBill oBill = new DLL.ClsSc_MouldRepairInBill();
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "反审核失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//反审核前判断
|
string s = "";
|
if (!DBUtility.Xt_BaseBillFun.Fun_AllowCheckBill(oBill, ref s))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = s + "，不允许反审核";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (HInterID <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "HInterID小于0！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
Int64 lngBillKey = 0;
|
lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
//查看是否已审核,关闭,作废
|
if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
if (oBill.omodel.HCloseMan.Trim() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已关闭!不能再次反审核！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (oBill.omodel.HDeleteMan.Trim() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已作废!不能再次反审核！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (oBill.omodel.HChecker.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据未审核!不需要反审核!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//反审核提交AbandonCheck
|
if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "反审核成功";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "反审核失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region [器具改制入库单删除功能]
|
/// <summary>
|
/// 器具改制入库单删除功能
|
/// </summary>
|
/// <returns></returns>
|
[Route("Sc_MouldRepairInBill/DeltetMouldRepairInBill")]
|
[HttpGet]
|
public object DeltetMouldRepairInBill(string HInterID,string user)
|
{
|
//编辑权限
|
if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairIn_SingleBill_Delete", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无删除权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
|
Int64 lngBillKey = 0;
|
lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
if (lngBillKey == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据ID为空！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
DLL.ClsSc_MouldProdBackBill oBill = new DLL.ClsSc_MouldProdBackBill();
|
if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
if (oBill.omodel.HBillStatus > 1)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (oBill.omodel.HChecker != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已经审核,不能删除！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//删除前查找当前单据的所有器具ID
|
//string swhere = "";
|
//DataSet ds = oCn.RunProcReturn("select HMaterID from Sc_MouldStockBillSub where HinterID=" + HInterID, "Sc_MouldStockBillSub");
|
//for (var i = 0; i < ds.Tables[0].Rows.Count; i++)
|
//{
|
// swhere = swhere + ds.Tables[0].Rows[i]["HMaterID"].ToString() + ",";
|
//}
|
//swhere = swhere.Substring(0, swhere.Length - 1);
|
bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
if (IsDete)
|
{
|
//删除成功修改器具档案位置
|
//string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID 0,0,'{swhere}' ");
|
string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID ");
|
oCn.RunProc(sql);
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据未找到";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region[模具改制入库单编辑时获取表头数据]
|
[Route("Sc_CheckToolsRepairWorkBillList/Sc_MouldRepairInHouseBillListCheckDetai")]
|
[HttpGet]
|
public ApiResult<DataSet> Sc_MouldRepairInHouseBillListCheckDetai(string HID)
|
{
|
if (string.IsNullOrEmpty(HID))
|
return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldRepairInBillList where hmainid= " + HID + " ", "h_v_Sc_MouldRepairInBillList");
|
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
return new ApiResult<DataSet> { code = -1, msg = "不存在单号" };
|
|
return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
}
|
#endregion
|
|
#region 器具改制入库单审核/反审核
|
[Route("Sc_MouldRepairInBill/AuditMouldRepairInBill")]
|
[HttpGet]
|
public object AuditMouldRepairInBill(string HInterID, string user, int flag)
|
{
|
//flag=1 审核； flag=2 反审核
|
//编辑权限
|
if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldRepairIn_SingleBill_Check", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无审核权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
Int64 lngBillKey = 0;
|
lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
if (lngBillKey == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据ID为空！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill();
|
if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
if (flag == 1)
|
{
|
if (oBill.omodel.HBillStatus == 2)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "当前单据已审核，无需再次审核";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
string HCheckDate = DateTime.Now.Date.ToString();
|
oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker ='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3826' and HInterID=" + HInterID);
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "审核成功！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
else
|
{
|
if (oBill.omodel.HBillStatus == 1)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "当前单据未审核，无需反审核";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
string HCheckDate = DateTime.Now.Date.ToString();
|
oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3826' and HInterID=" + HInterID);
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "反审核成功！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据未找到";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
#endregion
|
|
//#region 模具领用单
|
|
//#region 模具领用单列表
|
|
//[Route("Sc_MouldProdOutBill/GetMouldProdOutBill")]
|
//[HttpGet]
|
//public object GetMouldProdOutBill(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetMouldProdOutBill(sWhere);
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//public static DataSet Sc_GetMouldProdOutBill(string sWhere)
|
//{
|
// if (sWhere == null || sWhere.Equals(""))
|
// {
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldProdOutHouseBillList ", "h_v_Sc_MouldProdOutHouseBillList");
|
// }
|
// else
|
// {
|
// string sql1 = "select * from h_v_Sc_MouldProdOutHouseBillList where 1 = 1 ";
|
// string sql = sql1 + sWhere;
|
// return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdOutHouseBillList");
|
// }
|
|
//}
|
|
//#endregion
|
|
//#region[模具领用单编辑时获取表头数据]
|
//[Route("Sc_MouldProdOutBill/Sc_MouldProdOutBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sc_MouldProdOutBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldProdOutHouseBillList where hmainid= " + HID + " ", "h_v_Sc_MouldProdOutHouseBillList");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在退库单号" };
|
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
|
//#region[模具领用单编辑时获取表体数据]
|
//[Route("Sc_MouldProdOutBill/Sc_MouldProdOutBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sc_MouldProdOutBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
// ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,
|
// 设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty,
|
// 单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID,
|
// 仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark FROM h_v_Sc_MouldProdOutHouseBillList"), "h_v_Sc_MouldProdOutHouseBillList");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
|
// //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 ";
|
// string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,
|
// 设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty,
|
// 单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID,
|
// 仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark FROM h_v_Sc_MouldProdOutHouseBillList where 1 = 1 ");
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldProdOutHouseBillList");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region 模具领用单保存/编辑
|
///// <summary>
|
///// 保存模具领用单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldProdOutBill/SaveGetMouldProdOutBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldProdOutBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill();
|
// List<Model.ClsSc_MouldProdOutBillMain> lsmain = new List<Model.ClsSc_MouldProdOutBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Gy_MouldProdOutBillMain(msg2);
|
// foreach (Model.ClsSc_MouldProdOutBillMain oItem in lsmain)
|
// {
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3802";
|
// oItem.HBillSubType = "3802";
|
// //oItem.HBillNo = ""; //单据号
|
// //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// //oItem.HInnerBillNo = ""; // --内部单据号
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
// //oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
|
// //oItem.HPeriod = 0;
|
// //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期
|
// //oItem.HCheckResult = ""; //验收结论--(正常，异常)
|
// //oItem.HEmpID = 0; //验收人(Gy_Employee)
|
// //oItem.HManagerID = 0; //负责人(Gy_Employee)
|
// //oItem.HDeptID = 0; //验收部门(Gy_Department)
|
// //oItem.HExplanation = ""; //摘要(故障描述)
|
// //oItem.HRemark = ""; //备注
|
|
// //oItem.HMainSourceInterID = oItem.HInterID;
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldStockBillSub> ls = new List<Model.ClsSc_MouldStockBillSub>();
|
// ls = oListModels.getObjectByJson_Gy_MouldStockBillSub(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSc_MouldStockBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
|
// //oItemSub.HRepairCheckID = 0; //验收项目ID
|
// //oItemSub.HRepairCheckContent = ""; //验收内容
|
// //oItemSub.HManagerID = 0; //负责人ID
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// //oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //oItemSub.HRepairID = 0; //维修项目
|
// //oItemSub.HRepairExplanation =""; //维修要求
|
// //oItemSub.HMoney = 0; //维修费用
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#region [模具处理领用单删除功能]
|
///// <summary>
|
///// 模具处理领用单删除功能
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldProdOutBill/DeltetMouldProdOutBill")]
|
//[HttpGet]
|
//public object DeltetMouldProdOutBill(string HInterID)
|
//{
|
// //编辑权限
|
// //if (!DBUtility.ClsPub.Security_Log("Sc_MouldProdBackBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // objJsonResult.code = "0";
|
// // objJsonResult.count = 0;
|
// // objJsonResult.Message = "无删除权限！";
|
// // objJsonResult.data = null;
|
// // return objJsonResult;
|
// //}
|
|
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#endregion
|
|
//#region 模具寿命调整单
|
|
//#region 模具寿命调整表
|
|
//[Route("Sc_MouldLifeChangeBill/GetMouldLifeChangeBill")]
|
//[HttpGet]
|
//public object GetMouldLifeChangeBill(string sWhere)
|
//{
|
// try
|
// {
|
|
// ds = Sc_GetMouldLifeChangeBill(sWhere);
|
// objJsonResult.code = "1";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "返回记录成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// return objJsonResult;
|
// }
|
// catch (Exception ex)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
|
//public static DataSet Sc_GetMouldLifeChangeBill(string sWhere)
|
//{
|
// if (sWhere == null || sWhere.Equals(""))
|
// {
|
// return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldLifeChangeBillList ", "h_v_Sc_MouldLifeChangeBillList");
|
// }
|
// else
|
// {
|
// string sql1 = "select * from h_v_Sc_MouldLifeChangeBillList where 1 = 1 ";
|
// string sql = sql1 + sWhere;
|
// return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldLifeChangeBillList");
|
// }
|
|
//}
|
|
//#endregion
|
|
//#region[模具寿命调整单编辑时获取表头数据]
|
//[Route("Sc_MouldLifeChangeBill/Sc_GetMouldLifeChangeBillListCheckDetai")]
|
//[HttpGet]
|
//public ApiResult<DataSet> Sc_Sc_GetMouldLifeChangeBillListCheckDetai(string HID)
|
//{
|
// if (string.IsNullOrEmpty(HID))
|
// return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
// var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldLifeChangeBillList where hmainid= " + HID + " ", "h_v_Sc_MouldLifeChangeBillList");
|
// if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
|
// return new ApiResult<DataSet> { code = -1, msg = "不存在退库单号" };
|
|
// return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
|
//}
|
//#endregion
|
|
//#region[模具寿命调整单编辑时获取表体数据]
|
//[Route("Sc_MouldLifeChangeBill/Sc_MouldLifeChangeBillListProjectDetai")]
|
//[HttpGet]
|
//public object Sc_MouldLifeChangeBillListProjectDetai(string sqlWhere)
|
//{
|
// DataSet ds;
|
// try
|
// {
|
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
// if (sqlWhere == null || sqlWhere.Equals(""))
|
// {
|
// ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具 HMaterName,规格型号 HMaterSpec,HPropertyID,辅助属性代码 HPropertyCode,辅助属性 HPropertyName,
|
// HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位 HSecUnitName,换算率 HSecUnitRate,
|
// HUnitID, 计量单位代码 HUnitCode, 计量单位 HUnitName,
|
// 设计寿命 HDesignLife, 原剩余寿命 HLeaveLife, 新剩余寿命 HNewLife,表体备注 HRemark
|
// FROM h_v_Sc_MouldLifeChangeBillList_Edit"), "h_v_Sc_MouldLifeChangeBillList_Edit");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// else
|
// {
|
|
// //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 ";
|
// string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具 HMaterName,规格型号 HMaterSpec,HPropertyID,辅助属性代码 HPropertyCode,辅助属性 HPropertyName,
|
// HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位 HSecUnitName,换算率 HSecUnitRate,
|
// HUnitID, 计量单位代码 HUnitCode, 计量单位 HUnitName,
|
// 设计寿命 HDesignLife, 原剩余寿命 HLeaveLife, 新剩余寿命 HNewLife,表体备注 HRemark
|
// FROM h_v_Sc_MouldLifeChangeBillList_Edit where 1 = 1 ");
|
// string sql = sql1 + sqlWhere;
|
// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldLifeChangeBillList_Edit");
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "获取信息成功！";
|
// objJsonResult.data = ds.Tables[0];
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
// objJsonResult.data = null;
|
// }
|
// return objJsonResult;
|
//}
|
//#endregion
|
|
//#region 模具寿命调整单保存/编辑
|
///// <summary>
|
///// 保存模具领用单
|
///// </summary>
|
///// <param name="msg"></param>
|
///// <returns></returns>
|
//[Route("Sc_MouldLifeChangeBill/SaveGetMouldLifeChangeBillList")]
|
//[HttpPost]
|
//public object SaveGetMouldLifeChangeBillList([FromBody] JObject msg)
|
//{
|
// var _value = msg["msg"].ToString();
|
// string msg1 = _value.ToString();
|
// string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
// string msg2 = sArray[0].ToString();
|
// string msg3 = sArray[1].ToString();
|
|
|
// string UserName = "";
|
// ListModels oListModels = new ListModels();
|
// try
|
// {
|
// DLL.ClsSc_MouldLifeChangeBill oBill = new DLL.ClsSc_MouldLifeChangeBill();
|
// List<Model.ClsSc_MouldLifeChangeBillMain> lsmain = new List<Model.ClsSc_MouldLifeChangeBillMain>();
|
// msg2 = msg2.Replace("\\", "");
|
// msg2 = msg2.Replace("\n", ""); //\n
|
// lsmain = oListModels.getObjectByJson_Gy_MouldLifeChangeBillMain(msg2);
|
// foreach (Model.ClsSc_MouldLifeChangeBillMain oItem in lsmain)
|
// {
|
// //oItem.HMaker = "";
|
// UserName = oItem.HMaker; //制单人
|
// oItem.HBillType = "3824";
|
// oItem.HBillSubType = "3824";
|
// //oItem.HBillNo = ""; //单据号
|
// //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
|
// //oItem.HInnerBillNo = ""; // --内部单据号
|
// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
// oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
// //oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
|
// //oItem.HPeriod = 0;
|
// //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期
|
// //oItem.HCheckResult = ""; //验收结论--(正常，异常)
|
// //oItem.HEmpID = 0; //验收人(Gy_Employee)
|
// //oItem.HManagerID = 0; //负责人(Gy_Employee)
|
// //oItem.HDeptID = 0; //验收部门(Gy_Department)
|
// //oItem.HExplanation = ""; //摘要(故障描述)
|
// //oItem.HRemark = ""; //备注
|
|
// //oItem.HMainSourceInterID = oItem.HInterID;
|
|
// //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// oBill.omodel = oItem;
|
// }
|
// //表体数据
|
// //按 },{来拆分数组 //去掉【和】
|
// msg3 = msg3.Substring(1, msg3.Length - 2);
|
// msg3 = msg3.Replace("\\", "");
|
// msg3 = msg3.Replace("\n", ""); //\n
|
// //msg2 = msg2.Replace("'", "’");
|
// List<Model.ClsSc_MouldLifeChangeBillSub> ls = new List<Model.ClsSc_MouldLifeChangeBillSub>();
|
// ls = oListModels.getObjectByJson_Gy_MouldLifeChangeBillSub(msg3);
|
// int i = 0;
|
// foreach (Model.ClsSc_MouldLifeChangeBillSub oItemSub in ls)
|
// {
|
|
// i++;
|
// oItemSub.HEntryID = i;
|
|
// //oItemSub.HRepairCheckID = 0; //验收项目ID
|
// //oItemSub.HRepairCheckContent = ""; //验收内容
|
// //oItemSub.HManagerID = 0; //负责人ID
|
// //oItemSub.HCloseMan = ""; //行关闭
|
// oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
// oItemSub.HCloseType = false; //关闭类型
|
// //oItemSub.HRemark = ""; //备注
|
// oItemSub.HSourceInterID = 0; // 源单主内码
|
// oItemSub.HSourceEntryID = 0; //源单子内码
|
// //oItemSub.HSourceBillNo = ""; //源单单号
|
// //oItemSub.HSourceBillType = ""; //源单类型
|
// //oItemSub.HRelationQty = 0; //关联数量
|
// //oItemSub.HRelationMoney = 0; //关联金额
|
// //oItemSub.HRepairID = 0; //维修项目
|
// //oItemSub.HRepairExplanation =""; //维修要求
|
// //oItemSub.HMoney = 0; //维修费用
|
// oBill.DetailColl.Add(oItemSub);
|
|
// }
|
// //保存
|
// //保存完毕后处理
|
// bool bResult;
|
// if (oBill.omodel.HInterID == 0)
|
// {
|
// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// else
|
// {
|
// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// }
|
// if (bResult)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = "保存成功！";
|
// //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！" + e.ToString();
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#region [模具寿命调整单删除功能]
|
///// <summary>
|
///// 模具处理领用单删除功能
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Sc_MouldLifeChangeBill/DeltetMouldLifeChangeBill")]
|
//[HttpGet]
|
//public object DeltetMouldLifeChangeBill(string HInterID)
|
//{
|
// //编辑权限
|
// //if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeChangeBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // objJsonResult.code = "0";
|
// // objJsonResult.count = 0;
|
// // objJsonResult.Message = "无删除权限！";
|
// // objJsonResult.data = null;
|
// // return objJsonResult;
|
// //}
|
|
|
// Int64 lngBillKey = 0;
|
// lngBillKey = DBUtility.ClsPub.isLong(HInterID);
|
// if (lngBillKey == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据ID为空！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DLL.ClsSc_MouldLifeChangeBill oBill = new DLL.ClsSc_MouldLifeChangeBill();
|
// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// if (oBill.omodel.HBillStatus > 1)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// if (oBill.omodel.HChecker != "")
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据已经审核,不能删除！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
|
// bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (IsDete)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 1;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// else
|
// {
|
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// }
|
// else
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "单据未找到";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
//}
|
//#endregion
|
|
//#endregion
|
}
|
}
|
#endregion
|
