using DAL;
using DBUtility;
using Model;
using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using Newtonsoft.Json.Linq;
using SQLHelper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI;
using WebAPI.Models;
using WebAPI.Service;
namespace WebAPI.Controllers
{
public class WebAPIController : ApiController
{
public string sWhere = "";
public WebServer webserver = new WebServer();
public DataSet ds = new DataSet();
private json objjson = new json();
private json objJsonResult = new json();
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
//public static string sUrl = "http://183.129.128.86:9090/WEBS-WMSTest/WebService1.asmx";
// private POInStockBillServices oclscg_poinstockbillmain = new POInStockBillServices();
///
/// 送货单表头信息
///
///
///
[Route("Web/GetMAXNum")]
[HttpGet]
public object GetMAXNum(string HBillType)
{
try
{
string HBillNo = "";
Int64 HInterID = 0;//显示的字段
HInterID = DBUtility.ClsPub.CreateBillID(HBillType, ref DBUtility.ClsPub.sExeReturnInfo);
HBillNo = DBUtility.ClsPub.CreateBillCode(HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
//----------创建虚表------------------------
DataTable dt_Main = new DataTable("Json");
dt_Main.Columns.Add("HBillNo", typeof(string));
dt_Main.Columns.Add("HInterID", typeof(int));
//---------创建新行------------------------
DataRow dr_main = dt_Main.NewRow();//创建新行
dt_Main.Rows.Add(dr_main);//将新行加入到表中
dr_main["HBillNo"] = DBUtility.ClsPub.isStrNull(HBillNo);
dr_main["HInterID"] = DBUtility.ClsPub.isLong(HInterID);
if (HBillNo == null || HInterID == 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败";
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功";
objjson.data = dt_Main;
return objjson;
}
}
catch (Exception e)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + e.ToString();
objjson.data = null;
return objjson;
}
}
[Route("Web/GetMAXNumPDA")]
[HttpGet]
public object GetMAXNumPDA(string HBillType)
{
try
{
string HBillNo = "";
string sErrMsg = "";
Int64 HInterID = 0;//显示的字段
HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref sErrMsg);
HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(HBillType, ref sErrMsg, true);
DataSet ds;
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
ds = oCN.RunProcReturn("exec h_p_IF_CheckBillIDExists_WMS " + HInterID + ",'" + HBillNo + "'", "h_p_IF_CheckBillIDExists_WMS");
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
sErrMsg = "存在重复单据内码或单据号的单据，不允许新增，请退出后重新登录！";
objjson.code = "0";
objjson.count = 0;
objjson.Message = sErrMsg;
objjson.data = null;
return objjson;
}
else if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "1")
{
sErrMsg = "存在重复单据内码或单据号的单据，不允许新增，请退出后重新登录！";
objjson.code = "0";
objjson.count = 0;
objjson.Message = sErrMsg;
objjson.data = null;
return objjson;
}
else
{
//----------创建虚表------------------------
DataTable dt_Main = new DataTable("Json");
dt_Main.Columns.Add("HBillNo", typeof(string));
dt_Main.Columns.Add("HInterID", typeof(int));
//---------创建新行------------------------
DataRow dr_main = dt_Main.NewRow();//创建新行
dt_Main.Rows.Add(dr_main);//将新行加入到表中
dr_main["HBillNo"] = DBUtility.ClsPub.isStrNull(HBillNo);
dr_main["HInterID"] = DBUtility.ClsPub.isLong(HInterID);
//返回数据
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功";
objjson.data = dt_Main;
return objjson;
}
}
catch (Exception e)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + e.ToString();
objjson.data = null;
return objjson;
}
}
//[Route("Web/Get_MaxBillNoAndID")]
//[HttpGet]
//public object Get_MaxBillNoAndID(string HBillType)
//{
// try
// {
// string HBillNo = "";
// Int64 HInterID = 0;//显示的字段
// HInterID = DBUtility.ClsPub.CreateBillID(HBillType, ref DBUtility.ClsPub.sExeReturnInfo);
// HBillNo = DBUtility.ClsPub.CreateBillCode(HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
// //----------创建虚表------------------------
// DataTable dt_Main = new DataTable("Json");
// dt_Main.Columns.Add("HBillNo", typeof(string));
// dt_Main.Columns.Add("HInterID", typeof(int));
// //---------创建新行------------------------
// DataRow dr_main = dt_Main.NewRow();//创建新行
// dt_Main.Rows.Add(dr_main);//将新行加入到表中
// dr_main["HBillNo"] = DBUtility.ClsPub.isStrNull(HBillNo);
// dr_main["HInterID"] = DBUtility.ClsPub.isLong(HInterID);
// if (HBillNo == null || HInterID == 0)
// {
// objjson.code = "0";
// objjson.count = 0;
// objjson.Message = "获取失败";
// objjson.data = null;
// return objjson;
// }
// else
// {
// objjson.code = "0";
// objjson.count = 1;
// objjson.Message = "获取成功";
// objjson.data = dt_Main;
// return objjson;
// }
// }
// catch (Exception e)
// {
// objjson.code = "0";
// objjson.count = 0;
// objjson.Message = "获取失败" + e.ToString();
// objjson.data = null;
// return objjson;
// }
//}
///
/// 登录
///
/// 用户名
/// 密码
/// 组织
///
[Route("Web/GetUser")]
[HttpGet]
public object GetUser(string UserName, string PassWord, string HOrgName)
{
try
{
DataSet ds = null;
ClsCN oCnLoc = new ClsCN();
DAL.ClsUser oUser = new DAL.ClsUser();
ds = oUser.CheckMainID(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "密码错误！";
objjson.data = null;
return objjson;
}
string sql = string.Format(@" select a.* from Gy_UserByOrgRelation a
where a.HUserID = '{0}' and a.HOrgID = '{1}'", UserName, HOrgName);
DataSet _ds = oCnLoc.RunProcReturn(sql, "h_p_Xt_UserRelationOrg_Check");
//if (_ds == null || _ds.Tables[0].Rows.Count == 0)
//{
// objjson.code = "0";
// objjson.count = 0;
// objjson.Message = "用户" + UserName + "没有该组织权限";
// objjson.data = null;
// return objjson;
//}
objjson.code = "0";
objjson.count = 1;
objjson.Message = "登录成功！";
objjson.data = ds.Tables[0];
return objjson;
}
catch (Exception e)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "登录异常！" + e.Message;
objjson.data = null;
return objjson; ;
}
}
///
/// 修改密码
///
///
///
///
[Route("Web/GetXGPassword")]
[HttpGet]
public object GetXGPassword(string UserName, string oldPassword, string PassWord, string Repassword)
{
try
{
ClsCN oCn = new ClsCN();
DataSet oDs = new DataSet();
//==========
oDs = oCn.RunProcReturn("select Czmm from Gy_Czygl where Czybm='" + UserName + "'", "Gy_Czygl");
if (PassWord.Trim() != Repassword.Trim())
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "2次密码不一致！";
objjson.data = oDs.Tables[0];
return objjson; ;
}
//===========
if (oDs == null || oDs.Tables[0].Rows.Count == 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "没有这个用户，不能修改密码！";
objjson.data = null;
return objjson; ;
}
else
{
oCn.RunProc("update Gy_Czygl set Czmm='" + ClsPub.StrToPsd(PassWord.Trim()) + "' where Czybm='" + UserName.Trim() + "'");
objjson.code = "0";
objjson.count = 1;
objjson.Message = "* 密码修改成功！";
objjson.data = null;
return objjson; ;
}
}
catch (Exception)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "修改密码异常！";
objjson.data = null;
return objjson; ;
}
}
//撤销缓存列表记录
[Route("Web/Rescind_Json")]
[HttpGet]
public object Rescind_Json(long sHInterID, string sBillNo, string sBillType)
{
string sErrMsg = string.Empty;
try
{
if (webserver.RescindBillList(sHInterID, sBillNo, sBillType, ref sErrMsg))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "删除成功！";
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "删除失败！";
objJsonResult.data = null;
return objJsonResult;
}
}
catch (Exception)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "删除失败！";
objJsonResult.data = null;
return objJsonResult;
}
}
//删除缓存列表记录
[Route("Web/Delete_Json")]
[HttpGet]
public object Delete_Json(long sHInterID)
{
string sErrMsg = string.Empty;
try
{
if (webserver.DeleteBillList(sHInterID, ref sErrMsg))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "删除成功！";
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "删除失败！";
objJsonResult.data = null;
return objJsonResult;
}
}
catch (Exception)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "删除失败！";
objJsonResult.data = null;
return objJsonResult;
}
}
//缓存列表刷新
[Route("Web/DisBillEntryList_Mate_Webs_Json")]
[HttpGet]
public object DisBillEntryList_Webs_Json(string HBillType, string sWhere)
{
try
{
ds = webserver.GetKf_PonderationBillMain_TempList(HBillType, sWhere);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！";
objJsonResult.data = null;
return objJsonResult;
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "获取信息成功！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
//根据内码返回缓存列表信息
[Route("Web/GetPonderationBill")]
[HttpGet]
public object GetPonderationBill(long HInterID)
{
try
{
ds = webserver.GetPonderationBill(HInterID);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！";
objJsonResult.data = null;
return objJsonResult;
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "获取信息成功！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
//根据拖条码返回条码档案表唯一码信息
[Route("GroupOrder/GetBillEntry_TmpListGroupOrder")]
[HttpGet]
public object GetBillEntry_TmpListGroupOrder(string HBarCode)
{
try
{
ds = webserver.GetBarCode(HBarCode);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！";
objJsonResult.data = null;
return objJsonResult;
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "获取信息成功！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
//根据网格选中记录去修改条码档案、组托单子表记录并重新生成组托单sum表
[Route("GroupOrderBill/Edit")]
[HttpGet]
public object Edit(string HBarCode1, Int64 HQty)
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
try
{
oCN.RunProc("update Gy_BarCodeBill set HQty = " + HQty.ToString() + " where HBarCode = '" + HBarCode1 + "'");
oCN.RunProc("update Sc_PackUnionBillSub set HQty = " + HQty.ToString() + " where HBarCode = '" + HBarCode1 + "'");
DataSet ds = oCN.RunProcReturn("exec h_p_DisPlayBarCode '" + HBarCode1 + "'", "h_p_DisPlayBarCode");
long HInterIDTTM = 0;
long HInterID = 0;
string HBarCode_Pack = "";
string HBarCode = "";
string HUser = "";
HInterIDTTM = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID_TTM"]);
HBarCode_Pack = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBarCode_Pack"]);
HUser = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HMaker"]);
HInterID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"]);
oCN.RunProc("exec h_p_WMS_PackUnionBill_SumSubBill " + HInterIDTTM.ToString() + ",'" + HBarCode_Pack + "','3783','" + HUser + "'," + HInterID.ToString()); //根据箱条码，写入 SUM表，SUM条码档案
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "修改成功！";
objJsonResult.data = null;
return objJsonResult;
}
//DataSet DS1 = webserver.GetBarCode(HBarCode); //HSPID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSPID"]);
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
//if (DS1 == null || DS1.Tables[0].Rows.Count <= 0)
// {
// objjson.code = "0";
// objjson.count = 0;
// objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
// objjson.data = null;
// return objjson;
// }
// else
// {
// objjson.code = "0";
// objjson.count = 1;
// objjson.Message = "获取成功!";
// objjson.data = DS1.Tables[0];
// return objjson;
// }
//}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
//根据网格选中记录的唯一码 去删除条码档案 组托单子表 组托单sum表的唯一码数据
[Route("GroupOrderBill/Delete")]
[HttpGet]
public object Delete(string HBarCode1)
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
try
{
oCN.RunProc("delete from Gy_BarCodeBill where HBarCode = '" + HBarCode1 + "'");
oCN.RunProc("delete from Sc_PackUnionBillSub where HBarCode = '" + HBarCode1 + "'");
oCN.RunProc("delete from Sc_PackUnionBillSub_Sum where HBarCode = '" + HBarCode1 + "'"); //HSPID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSPID"]);
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "删除成功！";
objJsonResult.data = null;
return objJsonResult;
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
//if (DS1 == null || DS1.Tables[0].Rows.Count <= 0)
// {
// objjson.code = "0";
// objjson.count = 0;
// objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
// objjson.data = null;
// return objjson;
// }
// else
// {
// objjson.code = "0";
// objjson.count = 1;
// objjson.Message = "获取成功!";
// objjson.data = DS1.Tables[0];
// return objjson;
// }
//}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "删除失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
//根据黑点/白点返回不良代码、不良内码
[Route("Web/GetHWBDot")]
[HttpGet]
public object GetHBW(long HBadType)
{
try
{
ds = webserver.GetHBW(HBadType);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！";
objJsonResult.data = null;
return objJsonResult;
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "获取信息成功！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
//删除表记录
[Route("Web/Delete_Table")]
[HttpGet]
public object Delete_Table(string sqlStr)
{
try
{
//SQLHelper oCn;
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
oCN.RunProc(sqlStr);
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "删除成功！";
objJsonResult.data = null;
return objJsonResult;
}
catch (Exception)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "删除失败！异常";
objJsonResult.data = null;
return objJsonResult;
}
}
#region 基础资料
///
/// 获取仓库列表
///
///
[Route("Web/GetWarehouseList_Json")]
[HttpGet]
public object GetWarehouseList_Json(string Warehouse)
{
sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (Warehouse != "")
{
sWhere = sWhere + " and ( HNumber like '%" + Warehouse + "%' or HName like '%" + Warehouse + "%' or HUSEORGID like '%" + Warehouse + "%' ) ";
}
try
{
ds = webserver.GetWarehouseList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取仓库列表
///
///
[Route("Web/GetWarehouseList_Json_New")]
[HttpGet]
public object GetWarehouseList_Json_New(string Warehouse, Int64 HOrgID)
{
sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID =" + HOrgID + "";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (Warehouse != "")
{
sWhere = sWhere + " and ( HNumber like '%" + Warehouse + "%' or HName like '%" + Warehouse + "%' or HUSEORGID like '%" + Warehouse + "%' ) ";
}
try
{
WebS.WebService1 oWeb = new WebS.WebService1();
ds = oWeb.GetWarehouseList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取仓位列表
///
///
[Route("Web/GetStockPlaceList_Json")]
[HttpGet]
public object GetStockPlaceList_Json(string StockPlace, Int64 HWhID)
{
sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (HWhID == 0)
{
if (StockPlace != "")
{
sWhere = " Where HStopFlag=0 and ( HNumber like '%" + StockPlace + "%' or HName like '%" + StockPlace + "%' ) ";
}
else
{
sWhere = " Where HStopFlag=0 ";
}
}
else
{
if (StockPlace != "")
{
sWhere = " Where HStopFlag=0 and HWHID=" + HWhID.ToString() + " and ( HNumber like '%" + StockPlace + "%' or HName like '%" + StockPlace + "%' ) ";
}
else
{
sWhere = " Where HStopFlag=0 and HWHID=" + HWhID.ToString();
}
}
try
{
ds = webserver.GetStockPlaceList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取仓位列表
///
///
[Route("Web/GetStockPlaceList_Json_NEW")]
[HttpGet]
public object GetStockPlaceList_Json_NEW(string StockPlace, Int64 HWhID, Int64 HOrgID)
{
WebS.WebService1 oWeb = new WebS.WebService1();
sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + HOrgID + "";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (HWhID == 0)
{
if (StockPlace != "")
{
sWhere = " Where HStopFlag=0 and ( HNumber like '%" + StockPlace + "%' or HName like '%" + StockPlace + "%' ) ";
}
else
{
sWhere = " Where HStopFlag=0 ";
}
}
else
{
if (StockPlace != "")
{
sWhere = " Where HStopFlag=0 and HWHID=" + HWhID.ToString() + " and HWHID=" + HWhID.ToString() + " and ( HNumber like '%" + StockPlace + "%' or HName like '%" + StockPlace + "%' ) ";
}
else
{
sWhere = " Where HStopFlag=0 and HWHID=" + HWhID.ToString();
}
}
try
{
//ds = webserver.GetStockPlaceList(sWhere, ref DBUtility.ClsPub.sErrInfo);
ds = oWeb.GetStockPlaceList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// /扫描仓位二维码带出仓库仓位
///
///
///
///
[Route("Web/GetSpName_Json")]
[HttpGet]
public object GetSpName_Json(string HBarCode)
{
string[] sArray = HBarCode.Remove(0, 3).Split(';');
long HSpID = DBUtility.ClsPub.isLong(sArray[1]);
var HWHID = DBUtility.ClsPub.isLong(sArray[0]);
try
{
ds = webserver.GetSPInfoByIDandHWHIDandOrg(HSpID, HWHID, 001, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取供应商列表
///
///
[Route("Web/GetSupplierList_Json")]
[HttpGet]
public object GetSupplierList_Json(string Supplier, Int64 HOrgID)
{
sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID =" + HOrgID + "";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (Supplier != "")
{
sWhere = sWhere + " and ( HNumber like '%" + Supplier + "%' or HName like '%" + Supplier + "%' or HUSEORGID like '%" + Supplier + "%' ) ";
}
try
{
WebS.WebService1 oWeb = new WebS.WebService1();
ds = oWeb.GetSupplierList(sWhere, ref DBUtility.ClsPub.sErrInfo);
//ds = webserver.GetSupplierList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取职员列表
///
///
[Route("Web/GetEmployeeList_Json")]
[HttpGet]
public object GetEmployeeList_Json(string Employee, Int64 HGroupID)
{
sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (HGroupID == 0)
{
if (Employee != "")
{
sWhere = " Where HStopFlag=0 and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' ) ";
}
else
{
sWhere = " Where HStopFlag=0 ";
}
}
else
{
if (Employee != "")
{
sWhere = " Where HStopFlag=0 and HWHID=" + HGroupID.ToString() + " and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' ) ";
}
else
{
sWhere = " Where HStopFlag=0 and HWHID=" + HGroupID.ToString();
}
}
try
{
string sql = $"Select * from h_v_IF_Emp {sWhere} Order by HNumber";
ds = oCN.RunProcReturn(sql, "h_v_IF_Emp");
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取班组列表
///参数：string sql。
///返回值：object。
///
[Route("Web/GetProductionTeamList_Json")]
[HttpGet]
public object GetProductionTeamList_Json(string sWhere)
{
DataSet ds;
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
ds = oCN.RunProcReturn("Select HItemID,班组代码 班组代码,班组名称 班组 from h_v_GroupList where 1=1 " + sWhere + " Order by HItemID ", "h_v_GroupList");
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败";
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception e)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + e.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取部门列表
///
///
[Route("Web/GetDepartmentList_Json")]
[HttpGet]
public object GetDepartmentList_Json(string Department)
{
sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (Department != "")
{
sWhere = sWhere + " and ( HNumber like '%" + Department + "%' or HName like '%" + Department + "%' ) ";
}
try
{
ds = webserver.GetDepartmentList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取组织列表
///
///
[Route("Web/GetOrganizationList_Json")]
[HttpGet]
public object GetOrganizationList_Json()
{
WebS.WebService1 oWebs1 = new WebS.WebService1();
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
////sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
//if (Organization != "")
//{
// sWhere = sWhere + " and ( HNumber like '%" + Organization + "%' or HName like '%" + Organization + "%' ) ";
//}
try
{
ds = oWebs1.get_ORGANIZATIONSList();
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取物料列表
///
///
[Route("Web/GetMaterialList_Json")]
[HttpGet]
public object GetMaterialList_Json(string sWhere)
{
try
{
ds = webserver.GetMaterialList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取单位列表
///
///
[Route("Web/GetUnitList_Json")]
[HttpGet]
public object GetUnitList_Json(string Unit)
{
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (Unit != "")
{
sWhere = sWhere + " and ( HNumber like '%" + Unit + "%' or HName like '%" + Unit + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Unit where HStopflag=0 Order by HItemID ", "Gy_Unit");
}
else
{
string sql1 = "Select HItemID,HNumber ,HName from Gy_Unit where HStopflag=0 and HEndFlag=1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_Unit");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取客户列表
///
///
[Route("Web/GetCustomerList_Json")]
[HttpGet]
public object GetCustomerList_Json(string Customer)
{
sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (Customer != "")
{
sWhere = sWhere + " and ( HNumber like '%" + Customer + "%' or HName like '%" + Customer + "%' ) ";
}
try
{
ds = webserver.GetCustomerList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取工序列表
///
///参数：string sql。
///返回值：object。
///
[Route("Web/GetProcList_Json")]
[HttpGet]
public object GetProcList_Json(string sWhere)
{
DataSet ds;
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (sWhere != "")
{
sWhere = " and ( HNumber like '%" + sWhere + "%' or HName like '%" + sWhere + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
ds = oCN.RunProcReturn("Select HItemID,HNumber 工序代码,HName 工序 from Gy_Process where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Process");
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败";
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception e)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + e.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取当前数据库名
///
///
[Route("Web/GetDataBases")]
[HttpGet]
public object GetDataBases()
{
try
{
ClsCN oCn = new ClsCN();
DataSet oDs = new DataSet();
//==========
oDs = oCn.RunProcReturn("Select Name From Master..SysDataBases Where DbId=(Select Dbid From Master..SysProcesses Where Spid = @@spid)", "SysDataBases");
objjson.code = "1";
objjson.count = 1;
objjson.Message = "获取成功！";
objjson.data = oDs.Tables[0];
return objjson; ;
}
catch (Exception e)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败！异常" + e.ToString();
objjson.data = null;
return objjson; ;
}
}
#region 产线中心列表查询
[Route("Web/Gy_LineCenter_Json")]
[HttpGet]
public object Gy_LineCenter_Json(string BadReason)
{
if (BadReason != "")
{
sWhere = sWhere + " and ( HNumber like '%" + BadReason + "%' or HName like '%" + BadReason + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_LineCenter where HStopflag=0 Order by HItemID ", "Gy_LineCenter");
}
else
{
string sql1 = "Select HItemID,HNumber ,HName from Gy_LineCenter where HStopflag=0 and HEndFlag=1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_LineCenter");
sWhere = "";
}
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
#endregion
#region 不良原因设置列表/保存/编辑/删除方法
///
/// 获取不良原因列表
///
///
[Route("Web/GetBadReasonList_Json")]
[HttpGet]
public object GetBadReasonList_Json(string BadReason)
{
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (BadReason != "")
{
sWhere = sWhere + " and ( HNumber like '%" + BadReason + "%' or HName like '%" + BadReason + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_BadReason where HStopflag=0 Order by HItemID ", "Gy_BadReason");
}
else
{
string sql1 = "Select HItemID,HNumber ,HName from Gy_BadReason where HStopflag=0 and HEndFlag=1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_BadReason");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 保存不良原因
///
///
///
[Route("SaveGy_BadReasonList")]
[HttpPost]
public object SaveGy_BadReasonList([FromBody] JObject msg)
{
DataSet ds;
var _value = msg["msg"].ToString();
string msg3 = _value.ToString();
string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
string msg1 = sArray[0].ToString();
string msg2 = sArray[1].ToString();
//查看权限
if (!DBUtility.ClsPub.Security_Log("Gy_BadReason_Edit", 1, false, msg2))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无保存权限！";
objJsonResult.data = null;
return objJsonResult;
}
Int64 HItemID = 0;
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
//获取最大ID值赋值
DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) HItemID from Gy_BadReason ", "Gy_BadReason");
if (Maxds != null || Maxds.Tables[0].Rows.Count > 0)
{
//HItemID= Maxds.Tables[0].Rows[0]["HItemID"]
var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]);
maxid += 1;
HItemID = maxid;
}
ListModels oListModels = new ListModels();
try
{
WebAPI.DLL.ClsGy_BadReason_Ctl oBill = new WebAPI.DLL.ClsGy_BadReason_Ctl();
List lsmain = new List();
msg1 = msg1.Replace("\\", "");
msg1 = msg1.Replace("\n", ""); //\n
lsmain = oListModels.getObjectByJson_Gy_BadReason(msg1);
foreach (Model.ClsGy_BadReason_Model oItem in lsmain)
{
if (oItem.HNumber.Trim() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！代码不能为空！";
objJsonResult.data = 1;
return objJsonResult;
}
if (oItem.HName.Trim() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！名称不能为空！";
objJsonResult.data = 1;
return objJsonResult;
}
if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim()))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！";
objJsonResult.data = 1;
return objJsonResult;
}
//查询数据中是否存在重复代码
ds = oCN.RunProcReturn("select * from Gy_BadReason where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_BadReason");
if (oItem.HNumber.Trim() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！代码为空！";
objJsonResult.data = 1;
return objJsonResult;
}
//新增时判断
if (oItem.HItemID == 0)
{
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！代码重复！";
objJsonResult.data = 1;
return objJsonResult;
}
//检查父级是否存在
string sParent;
sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
if (sParent.Trim() == "")
{
oBill.oModel.HParentID = 0;
}
else
{
if (oBill.HavParentCode(sParent.Trim(), HItemID))
{
oBill.oModel.HParentID = oBill.oModel.HItemID;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
objJsonResult.data = 1;
return objJsonResult;
}
}
}
else//编辑时判断
{
//检查父级是否存在
string sParent;
sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
if (sParent.Trim() == "")
{
oBill.oModel.HParentID = 0;
}
else
{
if (oBill.HavParentCode(sParent.Trim(), oItem.HItemID))
{
oBill.oModel.HParentID = oBill.oModel.HItemID;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
objJsonResult.data = 1;
return objJsonResult;
}
}
}
//得到短代码
string sShortNumber;
sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim());
if (sShortNumber.Trim() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！短代码为空！";
objJsonResult.data = 1;
return objJsonResult;
}
oItem.HShortNumber = sShortNumber;//短代码
oItem.HEndFlag = true;//末级标志
oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //等级
oBill.oModel = oItem;
}
//保存
//保存完毕后处理
bool bResult;
if (oBill.oModel.HItemID == 0)
{
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
bResult = oBill.AddNew();
}
else
{
bResult = oBill.ModifyByID(oBill.oModel.HItemID);
}
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;
}
}
///
/// 不良原因获取信息
///
///
[Route("GetGy_BadReasonDetail")]
[HttpGet]
public ApiResult GetGy_BadReasonDetail(string HID)
{
var model = LuBaoSevice.GetGy_BadReasonBillDetail(HID);
return model;
}
///
/// 不良原因删除功能
///
///
[Route("DeltetGy_BadReason")]
[HttpGet]
public object DeltetGy_BadReason(string HItemID, string user)
{
DataSet ds;
//string ModRightNameCheck = "Sc_ProcessReport_check";
try
{
//删除权限
if (!DBUtility.ClsPub.Security_Log("Gy_BadReason_Delete", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无删除权限！";
objJsonResult.data = null;
return objJsonResult;
}
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (string.IsNullOrWhiteSpace(HItemID))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HItemID为空！";
objJsonResult.data = null;
return objJsonResult;
}
oCN.BeginTran();//开始事务
ds = oCN.RunProcReturn("select * from Gy_BadReason where HItemID=" + HItemID, "Gy_BadReason");
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有数据，无法删除！";
objJsonResult.data = null;
return objJsonResult; ;
}
//var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]);
//if (HStopflag)
//{
// oCN.RollBack();//回滚事务
// objJsonResult.code = "0";
// objJsonResult.count = 0;
// objJsonResult.Message = "数据已删除无法再次删除！";
// objJsonResult.data = null;
// return objJsonResult;
//}
oCN.RunProc("delete Gy_BadReason where HItemID=" + HItemID);
oCN.Commit();//提交事务
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "数据删除成功！";
objJsonResult.data = null;
return objJsonResult; ;
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "删除失败！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
///
/// 报废原因
///
///
[Route("Web/GetScrapReasonList_Json")]
[HttpGet]
public object GetScrapReasonList_Json(string BadReason)
{
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (BadReason != "" && BadReason != null)
{
sWhere = sWhere + " and ( HNumber like '%" + BadReason + "%' or HName like '%" + BadReason + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ScrapReason where HStopflag=0 Order by HItemID ", "Gy_ScrapReason");
}
else
{
string sql1 = "Select HItemID,HNumber ,HName from Gy_ScrapReason where HStopflag=0 and HEndFlag=1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_ScrapReason");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取工序计划单列表
///
///
[Route("Web/GetPlanList_Json")]
[HttpGet]
public object GetPlanList_Json(string Billno)
{
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (Billno != "")
{
sWhere = sWhere + " and ( 单据号 like '%" + Billno + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("select hmainid,hsubid,单据号,HMaterID,物料代码,物料名称,HCenterID,工作中心,规格型号,计划数量 from h_v_Sc_ProcessPlanList", "h_v_Sc_ProcessPlanList");
}
else
{
string sql1 = "select hmainid,hsubid,单据号,HMaterID,物料代码,物料名称,HCenterID,工作中心,规格型号,计划数量 from h_v_Sc_ProcessPlanList where 1=1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessPlanList");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取登录页组织列
///
///
[Route("Web/GetOrganizations")]
[HttpGet]
public object GetOrganizations()
{
try
{
ClsCN oCn = new ClsCN();
DataSet oDs = new DataSet();
//==========
oDs = oCn.RunProcReturn("select HItemID ID,Hname Name,HStopflag Stopflag from Xt_ORGANIZATIONS", "Xt_ORGANIZATIONS");
objjson.code = "1";
objjson.count = 1;
objjson.Message = "获取成功！";
objjson.data = oDs.Tables[0];
return objjson; ;
}
catch (Exception e)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败！异常" + e.ToString();
objjson.data = null;
return objjson; ;
}
}
#endregion
///
/// 获取职务列表
///
///
[Route("Web/GetDutyList_Json")]
[HttpGet]
public object GetDutyList_Json(string Duty)
{
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (Duty != "")
{
sWhere = sWhere + " and ( HNumber like '%" + Duty + "%' or HName like '%" + Duty + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Duty where HStopflag=0 Order by HItemID ", "Gy_Duty");
}
else
{
string sql1 = "Select HItemID,HNumber ,HName from Gy_Duty where HStopflag=0 and HEndFlag=1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_Duty");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取宿舍列表
///
///
[Route("Web/GetDormList_Json")]
[HttpGet]
public object GetDormList_Json(string Dorm)
{
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (Dorm != "")
{
sWhere = sWhere + " and ( HNumber like '%" + Dorm + "%' or HName like '%" + Dorm + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Dorm where HStopflag=0 Order by HItemID ", "Gy_Dorm");
}
else
{
string sql1 = "Select HItemID,HNumber ,HName from Gy_Dorm where HStopflag=0 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_Dorm");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取工种列表
///
///
[Route("Web/GetWorkTypeList_Json")]
[HttpGet]
public object GetWorkTypeList_Json(string WorkType)
{
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (WorkType != "")
{
sWhere = sWhere + " and ( HNumber like '%" + WorkType + "%' or HName like '%" + WorkType + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_WorkType where HStopflag=0 Order by HItemID ", "Gy_WorkType");
}
else
{
string sql1 = "Select HItemID,HNumber ,HName from Gy_WorkType where HStopflag=0 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_WorkType");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取核算方式组列表
///
///
[Route("Web/GetClassTimePrjGroupList_Json")]
[HttpGet]
public object GetClassTimePrjGroupList_Json(string ClassTimePrjGroup)
{
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (ClassTimePrjGroup != "")
{
sWhere = sWhere + " and ( HNumber like '%" + ClassTimePrjGroup + "%' or HName like '%" + ClassTimePrjGroup + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrjGroup");
}
else
{
string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
[Route("Web/GetClassTimePrjGroupBillList_Json")]
[HttpGet]
public object GetClassTimePrjGroupBillList_Json(string sWhere, string user)
{
if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有查看权限";
objJsonResult.data = null;
return objJsonResult;
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
string sql = "Select a.HItemID ,HNumber 核算方式组代码,HName 核算方式组名称,HDeptID,b.部门名称 部门 from Gy_ClassTimePrjGroup a left join h_v_Gy_Department b on a.HDeptID=b.HItemID";
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup");
}
else
{
sql = sql + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 核算方式组编辑
///
///
///
///
[Route("Web/GetClassTimePrjGroupBillEdit_Json")]
[HttpGet]
public object GetClassTimePrjGroupBillEdit_Json(string sWhere)
{
//if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj", 1, false, user))
//{
// objJsonResult.code = "0";
// objJsonResult.count = 0;
// objJsonResult.Message = "没有查看权限";
// objJsonResult.data = null;
// return objJsonResult;
//}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
string sql = "select a.HNumber,a.HName,a.HDeptID,b.HName as 仓库名称 from Gy_ClassTimePrjGroup a left join Gy_Department b on a.HDeptID = b.HItemID where a.hitemid = " + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup");
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "1";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
#region 删除核算方式组
///
/// 核算方式列表删除按钮
///参数：string sql。
///返回值：object。
///
[Route("Web/DeleteClassTimePrjGroupBillList")]
[HttpGet]
public object DeleteClassTimePrjGroupBillList(long HItemID, string User)
{
try
{
if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj_Delete", 1, false, User))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有删除权限";
objJsonResult.data = null;
return objJsonResult;
}
oCN.BeginTran();
string sql = "delete from Gy_ClassTimePrjGroup where HItemID =" + HItemID;
oCN.RunProc(sql);
oCN.Commit();
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "删除成功";
objJsonResult.data = null;
return objJsonResult;
}
catch (Exception e)
{
oCN.RollBack();
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "Exception！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
///
/// 保存获取核算方式组
///
///
///
[Route("Web/SaveGetClassTimePrjGroupList")]
[HttpGet]
public object SaveGetClassTimePrjGroupList(string HNumber, string HName, string HDeptID, string refSav, string user, string HItem)
{
try
{
int HItemID = int.Parse(HItem);
//编辑权限
if (!DBUtility.ClsPub.Security_Log_second("Gy_ClassTimePrj", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无保存权限！";
objJsonResult.data = null;
return objJsonResult;
}
string sql = "";
if (refSav == "Add")
{
sql = "Insert Into Gy_ClassTimePrjGroup " +
"(HNumber,HName,HStopflag,HRemark,HShortNumber,HParentID,HLevel" +
",HEndFlag,HHelpCode,HDeptID,HGroupID,HUseFlag" +
") " +
" values('" + HNumber + "','" + HName + "','','',0,0,0,0,''," + HDeptID + ",0,'未使用'" + ") ";
}
else
{
sql = "UpDate Gy_ClassTimePrjGroup set HNumber='" + HNumber + "',HName='" + HName + "',HDeptID=" + HDeptID + " where HItemID=" + HItemID;
}
oCN.RunProc(sql);
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "保存成功";
objJsonResult.data = 1;
return objJsonResult;
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！" + e.ToString();
objJsonResult.data = 1;
return objJsonResult;
}
}
///
/// 获取岗位列表
///
///
[Route("Web/GetGy_PostList_Json")]
[HttpGet]
public object GetGy_PostList_Json(string ParamPost)
{
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (ParamPost != "")
{
sWhere = sWhere + " and ( HNumber like '%" + ParamPost + "%' or HName like '%" + ParamPost + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Post where HStopflag=0 Order by HItemID ", "Gy_Post");
}
else
{
string sql1 = "Select HItemID,HNumber ,HName from Gy_Post where HStopflag=0 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_Post");
}
//ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取点检项目列表
///
///
[Route("Web/GetCheckItemList_Json")]
[HttpGet]
public object GetCheckItemList_Json(string CheckItem)
{
DataSet ds;
try
{
sWhere = " Where HStopFlag=0 and HEndFlag=1";
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
if (CheckItem != "" && CheckItem != null)
{
sWhere = sWhere + " and ( HNumber like '%" + CheckItem + "%' or HName like '%" + CheckItem + "%' ) ";
ds = oCN.RunProcReturn("Select HItemID,HNumber,HName from Gy_DotCheck " + sWhere + " Order by HItemID ", "Gy_DotCheck");
}
else
{
ds = oCN.RunProcReturn("Select HItemID,HNumber,HName from Gy_DotCheck " + sWhere + " Order by HItemID ", "Gy_DotCheck");
}
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取生产任务单列表
///
///
[Route("Web/GetSc_ICMOBillListView")]
[HttpGet]
public object GetSc_ICMOBillListView(string ICMOBill, int OrganizationID)
{
if (ICMOBill != "")
{
sWhere = " where 1=1 and 单据号 like '%" + ICMOBill + "%' ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1=1 and isnull(审核人,'')<>'' and isnull(关闭人,'')='' and isnull(行关闭人,'')='' order by 单据号 desc,hsubid ", "h_v_IF_ICMOBillList");
}
else
{
string sql = "select * from h_v_IF_ICMOBillList " + sWhere + " and isnull(审核人,'')<>'' and isnull(关闭人,'')='' and isnull(行关闭人,'')='' order by 单据号 desc,hsubid ";
ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillList");
}
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取生产任务单列表
///
///
[Route("Web/GetSc_ICMOBillListView2")]
[HttpGet]
public object GetSc_ICMOBillListView2(int page, int limit, string ICMOBill, int OrganizationID)
{
try
{
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
int count = 0;
int pageNum = page;
int pageSize = limit;
string sWhere = "";
if (ICMOBill == null || ICMOBill.Equals(""))
{
sWhere = " where 1=1";
}
else
{
sWhere = " where 1=1 and 单据号 like '%" + ICMOBill + "%'";
}
DataSet ds0 = oCn.RunProcReturn("select count(*) CountNum from h_v_Sc_ICMOBillList " + sWhere + "", "h_v_Sc_ICMOBillList");
count = int.Parse(ds0.Tables[0].Rows[0]["CountNum"].ToString());
//string sql = string.Format(@"select top " + pageSize + " hmainid,日期,单据号,箱号条形码,净重,毛重,皮重,生产组织,部门,操作员,客户标签号,物料代码,物料名称,计量单位代码,计量单位名称,数量,制单人,制单日期 from(select row_number() over (order by hmainid desc) as RowNumber,hmainid,日期,单据号,箱号条形码,净重,毛重,皮重,生产组织,部门,操作员,客户标签号,物料代码,物料名称,计量单位代码,计量单位名称,数量,制单人,制单日期 from h_v_PackUnionBillList " + sWhere + ") as A where RowNumber >" + pageSize + " *(" + pageNum + "-1)");
string sql = string.Format(@"select * from h_v_Sc_ICMOBillList " + sWhere + " and isnull(审核人,'')<>'' order by hmainid offset ((" + pageNum + "-1)*" + pageSize + ") rows fetch next " + pageSize + " rows only");
ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_ICMOBillList");
string aa = ds.Tables[0].Columns[0].ToString();
if (ds.Tables[0].Rows.Count > 0)
{
objJsonResult.code = "1";
objJsonResult.count = count;
objJsonResult.Message = "返回记录成功！";
objJsonResult.data = JsonConvert.DeserializeObject(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" })); //序列化DataSet中的时间格式，然后再反序列化回来
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "暂无记录！";
objJsonResult.data = null;
return objJsonResult;
}
}
catch (Exception ex)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
objJsonResult.data = null;
return objJsonResult;
}
//if (ICMOBill != "")
//{
// sWhere = " where 1=1 and 单据号 like '%" + ICMOBill + "%' ";
//}
//try
//{
// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
// if (sWhere == null || sWhere.Equals(""))
// {
// ds = oCN.RunProcReturn("select * from h_v_Sc_ICMOBillList where 1=1 and isnull(审核人,'')<>'' order by 单据号 desc,hsubid ", "h_v_Sc_ICMOBillList");
// }
// else
// {
// string sql = "select * from h_v_Sc_ICMOBillList " + sWhere + " and isnull(审核人,'')<>'' order by 单据号 desc,hsubid ";
// ds = oCN.RunProcReturn(sql, "h_v_Sc_ICMOBillList");
// }
// if (ds == null || ds.Tables[0].Rows.Count <= 0)
// {
// objjson.code = "0";
// objjson.count = 0;
// objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
// objjson.data = null;
// return objjson;
// }
// else
// {
// objjson.code = "0";
// objjson.count = 1;
// objjson.Message = "获取成功!";
// objjson.data = ds.Tables[0];
// return objjson;
// }
//}
//catch (Exception ex)
//{
// objjson.code = "0";
// objjson.count = 0;
// objjson.Message = "获取失败" + ex.ToString();
// objjson.data = null;
// return objjson;
//}
}
///
/// 获取工序流转卡列表
///
///
[Route("Web/GetSc_ProcessExchangeBillListView")]
[HttpGet]
public object GetSc_ProcessExchangeBillListView(string ICMOBill, int OrganizationID)
{
if (ICMOBill != "")
{
sWhere = " where 1=1 and 单据号 like '%" + ICMOBill + "%' ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList where 1=1 order by 单据号 desc,hsubid ", "h_v_Sc_ProcessExchangeBillList");
}
else
{
string sql = "select * from h_v_Sc_ProcessExchangeBillList " + sWhere + " order by 单据号 desc,hsubid ";
ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessExchangeBillList");
}
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取检验项目列表
///
///
[Route("Web/GetGy_QCCheckItem")]
[HttpGet]
public object GetGy_QCCheckItem(string CheckItem, int OrganizationID)
{
if (CheckItem != "")
{
sWhere = " and ( HNumber like '%" + CheckItem + "%' or HName like '%" + CheckItem + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("Select HItemID,HNumber 代码,HName 名称 ,HQCCheckClassID 检验项目类别 from Gy_QCCheckItem where HStopflag=0 Order by HItemID ", "Gy_QCCheckItem");
}
else
{
string sql = "Select HItemID,HNumber 代码,HName 名称 ,HQCCheckClassID 检验项目类别 from Gy_QCCheckItem where HStopflag=0 " + sWhere + "Order by HItemID ";
ds = oCN.RunProcReturn(sql, "Gy_QCCheckItem");
}
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 获取检验方案列表
///
///
[Route("Web/GetGy_QCCheckProject")]
[HttpGet]
public object GetGy_QCCheckProject(string CheckProject, int OrganizationID)
{
if (CheckProject != "")
{
sWhere = " and ( HBillNo like '%" + CheckProject + "%' or HName like '%" + CheckProject + "%' ) ";
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
string sql = "Select HinterID HItemID,HBillNo 检验方案代码,HName 方案名称 from Gy_QCCheckProjectMain where 1 = 1 " + sWhere + "Order by HinterID ";
ds = oCN.RunProcReturn(sql, "Gy_QCCheckProjectMain");
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "1";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 根据检验方案主内码获取检验项目
///
///
[Route("Web/GetCheckItemByCheckProjectID")]
[HttpGet]
public object GetCheckItemByCheckProjectID(int CheckProjectID)
{
if (CheckProjectID <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "检验方案未选择";
objjson.data = null;
return objjson;
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
string sql = "select c.HItemID HQCCheckItemID,c.HName 检验项目,b.HQCStd,b.HQCUnit HUnit from Gy_QCCheckProjectMain a left join Gy_QCCheckProjectSub b on a.HInterID = b.HInterID left join Gy_QCCheckItem c on b.HQCCheckItemID = c.HItemID where a.HInterID = " + CheckProjectID;
ds = oCN.RunProcReturn(sql, "Gy_QCCheckProjectMain");
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
objjson.data = null;
return objjson;
}
else
{
objjson.code = "1";
objjson.count = 1;
objjson.Message = "获取成功!";
objjson.data = ds.Tables[0];
return objjson;
}
}
catch (Exception ex)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "获取失败" + ex.ToString();
objjson.data = null;
return objjson;
}
}
///
/// 根据器具主内码获取器具保养检验项目
///
///
[Route("Web/GetMaintainItemtemByMouldProjectID")]
[HttpGet]
public object GetMaintainItemtemByMouldProjectID(int MouldProjectID)
{
if (MouldProjectID <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "产品器具未选择";
objjson.data = null;
return objjson;
}
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
List