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();
|
Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
|
//public static string sUrl = "http://183.129.128.86:9090/WEBS-WMSTest/WebService1.asmx";
|
// private POInStockBillServices oclscg_poinstockbillmain = new POInStockBillServices();
|
/// <summary>
|
/// 送货单表头信息
|
/// </summary>
|
/// <param name="sMsg"></param>
|
/// <returns></returns>
|
[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;
|
// }
|
//}
|
/// <summary>
|
/// 登录
|
/// </summary>
|
/// <param name="UserName">用户名</param>
|
/// <param name="PassWord">密码</param>
|
/// <param name="PassWord">组织</param>
|
/// <returns></returns>
|
[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; ;
|
}
|
}
|
/// <summary>
|
/// 菜单栏
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/MenuBar")]
|
[HttpGet]
|
public object MenuBar(string UserName)
|
{
|
try
|
{
|
//获取系统参数
|
string Ret = "";
|
if (oSystemParameter.ShowBill(ref Ret))
|
{
|
//判断客户为龙山汽配
|
if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配")
|
{
|
//判断是否有查询权限
|
if (!DBUtility.ClsPub.Security_Log("Xt_MenuBar_Unfold", 1, false, UserName))
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "无展开菜单栏权限!";
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
}
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "展开成功！";
|
objjson.data = 1;
|
return objjson;
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "异常！" + e.Message;
|
objjson.data = null;
|
return objjson; ;
|
}
|
}
|
/// <summary>
|
/// 修改密码
|
/// </summary>
|
/// <param name="UserName"></param>
|
/// <param name="PassWord"></param>
|
/// <returns></returns>
|
[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; ;
|
}
|
}
|
|
|
#region 用户设置
|
#region 获取用户信息
|
[Route("Gy_USERSet_PDA/GetGy_Czygl_Info")]
|
[HttpGet]
|
public object GetGy_Czygl_Info(string Czybm, string user)
|
{
|
try
|
{
|
//查看权限
|
//if (!DBUtility.ClsPub.Security_Log("Gy_ProjectStage_Query", 1, false, user))
|
//{
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "无查看权限！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
//}
|
|
string sql = @"select Czybm, Czymc, HWhID, HWhName, HSecManagerID, HSecManager, HKeeperID, HKeeper, HDeptID, HDept, HCloudUserName, HCloudUserPsd from Gy_Czygl where Czybm = '" + Czybm + "'";
|
ds = oCN.RunProcReturn(sql, "Gy_Czygl");
|
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "未找到相关数据！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
#region 保存用户信息
|
[Route("Gy_USERSet_PDA/SaveGy_Czygl_Info")]
|
[HttpPost]
|
public object SaveGy_Czygl_Info([FromBody] JObject sMainSub)
|
{
|
try
|
{
|
//获取参数
|
var _value = sMainSub["sMainSub"].ToString();
|
string msg1 = _value.ToString();
|
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
|
Int64 HWhID = Int64.Parse(sArray[0].ToString());
|
string HWhName = sArray[1].ToString();
|
Int64 HSecManagerID = Int64.Parse(sArray[2].ToString());
|
string HSecManager = sArray[3].ToString();
|
Int64 HKeeperID = Int64.Parse(sArray[4].ToString());
|
string HKeeper = sArray[5].ToString();
|
Int64 HDeptID = Int64.Parse(sArray[6].ToString());
|
string HDept = sArray[7].ToString();
|
string HCloudUserName = sArray[8].ToString().Trim();
|
string HCloudUserPsd = sArray[9].ToString().Trim();
|
|
string Czybm = sArray[10].ToString();
|
string user = sArray[11].ToString(); //操作用户的用户名
|
|
////判断是否有新增权限
|
//if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBillQualityStatus_Tmp_Edit", 1, false, user))
|
//{
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "无新增权限!";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
//}
|
|
string sql = "update Gy_Czygl set " +
|
"HWhID = " + HWhID +
|
", HWhName = '" + HWhName +
|
"', HSecManagerID = " + HSecManagerID +
|
", HSecManager = '" + HSecManager +
|
"', HKeeperID = " + HKeeperID +
|
", HKeeper = '" + HKeeper +
|
"', HDeptID = " + HDeptID +
|
", HDept = '" + HDept +
|
"', HCloudUserName = '" + HCloudUserName +
|
"', HCloudUserPsd = '" + HCloudUserPsd +
|
"' where Czybm = '" + Czybm + "'";
|
|
oCN.RunProc(sql);
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
#endregion
|
|
|
|
//撤销缓存列表记录
|
[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);
|
|
List<object> columnNameList = new List<object>();
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
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];
|
objJsonResult.list = columnNameList;
|
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 基础资料
|
/// <summary>
|
/// 获取仓库列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取仓库列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
|
|
/// <summary>
|
/// 获取仓位列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
|
///// <summary>
|
///// 获取仓位列表
|
///// </summary>
|
///// <returns></returns>
|
//[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 HUSEORGID = " + HOrgID + " 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;
|
// }
|
//}
|
|
|
/// <summary>
|
/// 获取仓位列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// /扫描仓位二维码带出仓库仓位
|
/// </summary>
|
/// <param name="StockPlace"></param>
|
/// <param name="HWhID"></param>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
|
/// <summary>
|
/// 获取供应商列表
|
/// </summary>
|
/// <returns></returns>
|
[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 '%" + HOrgID + "%' ) ";
|
}
|
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;
|
}
|
}
|
/// <summary>
|
/// 获取职员列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取班组列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取部门列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
|
/// <summary>
|
/// 获取组织列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取物料列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取单位列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取计量单位组列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetUnitGroupList_Json")]
|
[HttpGet]
|
public object GetUnitGroupList_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 != "" && Unit != null)
|
{
|
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_UnitGroup where HStopflag=0 Order by HItemID ", "Gy_UnitGroup");
|
}
|
else
|
{
|
string sql1 = "Select HItemID,HNumber 计量单位组代码,HName 计量单位组 from Gy_UnitGroup where HStopflag=0 and HEndFlag=1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "Gy_UnitGroup");
|
}
|
|
//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;
|
}
|
}
|
|
/// <summary>
|
/// 获取销售方式列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetSellStyleList_Json")]
|
[HttpGet]
|
public object GetSellStyleList_Json(string SellStyle)
|
{
|
if (SellStyle != "")
|
{
|
sWhere = sWhere + " and ( HNumber like '%" + SellStyle + "%' or HName like '%" + SellStyle + "%' ) ";
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_SellStyle where HStopflag=0 Order by HItemID ", "Gy_SellStyle");
|
}
|
else
|
{
|
string sql1 = "Select HItemID,HNumber ,HName from Gy_SellStyle where HStopflag=0 and HEndFlag=1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "Gy_SellStyle");
|
}
|
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 获取结算方式列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetSettleStyleList_Json")]
|
[HttpGet]
|
public object GetSettleStyleList_Json(string SettleStyle)
|
{
|
if (SettleStyle != "")
|
{
|
sWhere = sWhere + " and ( HNumber like '%" + SettleStyle + "%' or HName like '%" + SettleStyle + "%' ) ";
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_SettleStyle where HStopflag=0 Order by HItemID ", "Gy_SettleStyle");
|
}
|
else
|
{
|
string sql1 = "Select HItemID,HNumber ,HName from Gy_SettleStyle where HStopflag=0 and HEndFlag=1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "Gy_SettleStyle");
|
}
|
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 获取采购方式列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetPoStockStyleList_Json")]
|
[HttpGet]
|
public object GetPoStockStyleList_Json(string PoStockStyle)
|
{
|
if (PoStockStyle != "")
|
{
|
sWhere = sWhere + " and ( HNumber like '%" + PoStockStyle + "%' or HName like '%" + PoStockStyle + "%' ) ";
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_PoStockStyle where HStopflag=0 Order by HItemID ", "Gy_PoStockStyle");
|
}
|
else
|
{
|
string sql1 = "Select HItemID,HNumber ,HName from Gy_PoStockStyle where HStopflag=0 and HEndFlag=1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "Gy_PoStockStyle");
|
}
|
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 获取客户列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取工序列表
|
/// <summary>
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[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 ( p.HNumber like '%" + sWhere + "%' or p.HName like '%" + sWhere + "%' ) ";
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
ds = oCN.RunProcReturn("Select p.HItemID,p.HNumber 工序代码,p.HName 工序,w.HItemID 工作中心ID,w.HNumber 工作中心代码,w.HName 工作中心,d.HItemID 部门ID,d.HNumber 部门代码,d.HName 部门 from Gy_Process p left join Gy_WorkCenter w on p.HWorkCenterID = w.HItemID left join Gy_Department d on p.HDeptID = d.HItemID where p.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;
|
}
|
}
|
|
/// <summary>
|
/// 获取物料列表
|
/// <summary>
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("Web/GetMaterList_Json")]
|
[HttpGet]
|
public object GetMaterList_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 物料,HModel 规格型号 from Gy_Material where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Material");
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 获取模具列表
|
/// <summary>
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("Web/GetRelationList_Json")]
|
[HttpGet]
|
public object GetRelationList_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 模具,HModel 规格型号 from h_v_Gy_Mould where HStopflag=0 " + sWhere + " Order by HItemID ", "h_v_Gy_Mould");
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 获取当前数据库名
|
/// </summary>
|
/// <returns></returns>
|
[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 不良原因设置列表/保存/编辑/删除方法
|
/// <summary>
|
/// 获取不良原因列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
|
/// <summary>
|
/// 保存不良原因
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
[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<Model.ClsGy_BadReason_Model> lsmain = new List<Model.ClsGy_BadReason_Model>();
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 不良原因获取信息
|
/// </summary>
|
/// <returns></returns>
|
[Route("GetGy_BadReasonDetail")]
|
[HttpGet]
|
public ApiResult<DataSet> GetGy_BadReasonDetail(string HID)
|
{
|
var model = LuBaoSevice.GetGy_BadReasonBillDetail(HID);
|
return model;
|
}
|
|
/// <summary>
|
/// 不良原因删除功能
|
/// </summary>
|
/// <returns></returns>
|
[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
|
|
/// <summary>
|
/// 报废原因
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取工序计划单列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取登录页组织列
|
/// </summary>
|
/// <returns></returns>
|
[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
|
|
/// <summary>
|
/// 获取职务列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
|
|
/// <summary>
|
/// 获取宿舍列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取工种列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取核算方式组列表
|
/// </summary>
|
/// <returns></returns>
|
[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.部门代码,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;
|
}
|
}
|
/// <summary>
|
/// 核算方式组编辑
|
/// </summary>
|
/// <param name="sWhere"></param>
|
/// <param name="user"></param>
|
/// <returns></returns>
|
[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 删除核算方式组
|
/// <summary>
|
/// 核算方式列表删除按钮
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[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
|
/// <summary>
|
/// 保存获取核算方式组
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取岗位列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取设备主档列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetGy_EquipFileBillMainList_Json")]
|
[HttpGet]
|
public object GetGy_EquipFileBillMainList_Json(string EquipFileBill)
|
{
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
|
if (EquipFileBill != "")
|
{
|
sWhere = sWhere + " and ( HEquipFileNumber like '%" + EquipFileBill + "%' or HName like '%" + EquipFileBill + "%' ) ";
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain where 0=0 Order by HInterID ", "Gy_EquipFileBillMain");
|
}
|
else
|
{
|
string sql1 = "Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain where 0=0 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "Gy_EquipFileBillMain");
|
}
|
|
//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;
|
}
|
}
|
|
/// <summary>
|
/// 获取器具列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetGy_MouldFileMainList_Json")]
|
[HttpGet]
|
public object GetGy_MouldFileMainList_Json(string MouldFileMain)
|
{
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1";
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
|
if (MouldFileMain != "")
|
{
|
sWhere = sWhere + " and ( HNumber like '%" + MouldFileMain + "%' or HName like '%" + MouldFileMain + "%' ) ";
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("Select HInterID,HNumber,HName from Gy_MouldFileMain where 0=0 Order by HInterID ", "Gy_MouldFileMain");
|
}
|
else
|
{
|
string sql1 = "Select HInterID,HNumber,HName from Gy_MouldFileMain where 0=0 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "Gy_MouldFileMain");
|
}
|
|
//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;
|
}
|
}
|
|
/// <summary>
|
/// 获取点检项目列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
|
|
|
}
|
/// <summary>
|
/// 获取生产任务单列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
/// <summary>
|
/// 获取生产任务单列表
|
/// </summary>
|
/// <returns></returns>
|
[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<DataTable>(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;
|
//}
|
}
|
|
/// <summary>
|
/// 获取工序流转卡列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取检验项目列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取检验方案列表
|
/// </summary>
|
/// <returns></returns>
|
[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;
|
}
|
}
|
|
/// <summary>
|
/// 获取抽样方案列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetGy_SampleScheme")]
|
[HttpGet]
|
public object GetSampleScheme(string SampleScheme, int OrganizationID)
|
{
|
if (SampleScheme != "")
|
{
|
sWhere = " and ( 抽样方案代码 like '%" + SampleScheme + "%' or 抽样方案名称 like '%" + SampleScheme + "%' ) ";
|
}
|
try
|
{
|
List<object> columnNameList = new List<object>();
|
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
string sql = "Select * from h_v_Gy_GetSampleSchemeListView where 1 = 1 " + sWhere + "Order by hmainid ";
|
ds = oCN.RunProcReturn(sql, "h_v_Gy_GetSampleSchemeListView");
|
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
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 = "1";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
objjson.list = columnNameList;
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
/// <summary>
|
/// 获取检验值列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetGy_InspectValue")]
|
[HttpGet]
|
public object GetInspectValue(string InspectValue, int OrganizationID)
|
{
|
if (InspectValue != "")
|
{
|
sWhere = " and ( 检验值代码 like '%" + InspectValue + "%' or 检验值名称 like '%" + InspectValue + "%' ) ";
|
}
|
try
|
{
|
List<object> columnNameList = new List<object>();
|
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
string sql = "Select * from h_v_Gy_GetInspectValueList where 1 = 1 " + sWhere + "Order by hmainid ";
|
ds = oCN.RunProcReturn(sql, "h_v_Gy_GetInspectValueList");
|
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
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 = "1";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
objjson.list = columnNameList;
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
/// <summary>
|
/// 获取检仪器列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetGy_InspectInstruMent")]
|
[HttpGet]
|
public object GetGy_InspectInstruMent(string InspectInstruMent, int OrganizationID)
|
{
|
if (InspectInstruMent != "")
|
{
|
sWhere = " and ( 检验仪器代码 like '%" + InspectInstruMent + "%' or 检验仪器名称 like '%" + InspectInstruMent + "%' ) ";
|
}
|
try
|
{
|
List<object> columnNameList = new List<object>();
|
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
string sql = "Select * from h_v_Gy_InspectInstruMent where 1 = 1 " + sWhere + "Order by HItemID ";
|
ds = oCN.RunProcReturn(sql, "h_v_Gy_InspectInstruMent");
|
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
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 = "1";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
objjson.list = columnNameList;
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
/// <summary>
|
/// 根据检验方案主内码获取检验项目
|
/// </summary>
|
/// <returns></returns>
|
[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 * from h_v_Gy_GetQCCheckItemByProject where hmainid = " + 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;
|
}
|
}
|
|
/// <summary>
|
/// 根据器具主内码获取器具保养检验项目
|
/// </summary>
|
/// <returns></returns>
|
[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<object> list = new List<object>();
|
DataSet ds2;
|
DataSet ds1;
|
string sql1 = string.Format(@"select a.HInterID,a.HBillNo,t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
|
from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub_Item t on a.HInterID=t.HInterID
|
left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
|
left join Gy_Employee e on e.HItemID=t.HManagerID
|
where a.HInterID=(select HMouldMaintainRuleInterID from Gy_MouldFileMain where HInterID=" + MouldProjectID + ") ");
|
|
string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, m.HModel HMaterSpec,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark from Sc_MouldMaintainRuleBillMain a
|
left join Sc_MouldMaintainRuleBillSub b on a.HInterID=b.HInterID
|
left join h_v_IF_Material m on b.HMaterID=m.HItemID
|
left join h_v_IF_Unit u on b.HUnitID=u.HItemID
|
where a.HInterID=(select HMouldMaintainRuleInterID from Gy_MouldFileMain where HInterID=" + MouldProjectID + ") ");
|
ds1 = oCN.RunProcReturn(sql1, "Sc_MouldMaintainRuleBillMain");//保养
|
ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//配件
|
list.Add(ds1.Tables[0]);
|
list.Add(ds2.Tables[0]);
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.list = list;
|
return objJsonResult;
|
}
|
catch (Exception ex)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 根据器具主内码获取器具保养检验项目
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetMouldMaintainItemtemByMaintainRuleID")]
|
[HttpGet]
|
public object GetMouldMaintainItemtemByMaintainRuleID(int MouldMaintainRuleID)
|
{
|
|
if (MouldMaintainRuleID <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "器具保养规程未选择";
|
objjson.data = null;
|
return objjson;
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
List<object> list = new List<object>();
|
DataSet ds2;
|
DataSet ds1;
|
string sql1 = string.Format(@"select t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
|
from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub_Item t on a.HInterID=t.HInterID
|
left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
|
left join Gy_Employee e on e.HItemID=t.HManagerID
|
where a.HInterID=" + MouldMaintainRuleID);
|
|
string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, m.HModel HMaterSpec,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark from Sc_MouldMaintainRuleBillMain a
|
left join Sc_MouldMaintainRuleBillSub b on a.HInterID=b.HInterID
|
left join h_v_IF_Material m on b.HMaterID=m.HItemID
|
left join h_v_IF_Unit u on b.HUnitID=u.HItemID
|
where a.HInterID=" + MouldMaintainRuleID);
|
ds1 = oCN.RunProcReturn(sql1, "Sc_MouldMaintainRuleBillMain");//保养
|
ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//配件
|
list.Add(ds1.Tables[0]);
|
list.Add(ds2.Tables[0]);
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.list = list;
|
return objJsonResult;
|
}
|
catch (Exception ex)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
|
/// <summary>
|
/// 器具点检规程单列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Sc_MouldDotCheckRuleInter/GetMouldDotCheckRuleInterList")]
|
[HttpGet]
|
public object GetMouldDotCheckRuleInterList(string sWhere)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
string sql = string.Format(@"select * from h_v_Sc_MouldDotCheckRuleBillList ");
|
ds = oCN.RunProcReturn(sql + sWhere, "h_v_Sc_MouldDotCheckRuleBillList");
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 根据设备显示设备保养规程项目
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetMaintainItemtemByEquipProjectID")]
|
[HttpGet]
|
public object GetMaintainItemtemByEquipProjectID(string EquipProjectID)
|
{
|
if (EquipProjectID == null)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "产品器具未选择";
|
objjson.data = null;
|
return objjson;
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
List<object> list = new List<object>();
|
DataSet ds2;
|
DataSet ds1;
|
string sql1 = string.Format(@"select a.HInterID,a.HBillNo,t.HMaintainItemID HMaintainItemID,m.HNumber HMaintainItemNumber,t.HMaintainItem HMaintainItem,t.HMaintainPart HMaintainPart,t.HClaim HClaim,t.HManagerID HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
|
from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub_Item t on a.HInterID=t.HInterID
|
left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
|
left join Gy_Employee e on e.HItemID=t.HManagerID
|
where a.HInterID=(select HEquipMaintainRuleInterID from Gy_EquipFileBillMain where HInterID=" + EquipProjectID + ") ");
|
string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HRemark from Sb_EquipMaintainRuleBillMain a
|
left join Sb_EquipMaintainRuleBillSub b on a.HInterID=b.HInterID
|
left join h_v_IF_Material m on b.HMaterID=m.HItemID
|
left join h_v_IF_Unit u on b.HUnitID=u.HItemID
|
where a.HInterID=(select HEquipMaintainRuleInterID from Gy_EquipFileBillMain where HInterID=" + EquipProjectID + ") ");
|
|
ds1 = oCN.RunProcReturn(sql1, "Sb_EquipMaintainRuleBillMain");//保养
|
ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//配件
|
list.Add(ds1.Tables[0]);
|
list.Add(ds2.Tables[0]);
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.list = list;
|
return objJsonResult;
|
}
|
catch (Exception ex)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 根据设备保养规程显示设备保养规程项目
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetMaintainItemtemByMaintainRuleID")]
|
[HttpGet]
|
public object GetMaintainItemtemByMaintainRuleID(int EquipProjectID)
|
{
|
if (EquipProjectID <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "设备保养规程未选择";
|
objjson.data = null;
|
return objjson;
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
List<object> list = new List<object>();
|
DataSet ds2;
|
DataSet ds1;
|
string sql1 = string.Format(@"select t.HMaintainItemID HMaintainItemID,m.HNumber HMaintainItemNumber,t.HMaintainItem HMaintainItem,t.HMaintainPart HMaintainPart,t.HClaim HClaim,t.HManagerID HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
|
from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub_Item t on a.HInterID=t.HInterID
|
left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
|
left join Gy_Employee e on e.HItemID=t.HManagerID
|
where a.HInterID=" + EquipProjectID);
|
string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HRemark from Sb_EquipMaintainRuleBillMain a
|
left join Sb_EquipMaintainRuleBillSub b on a.HInterID=b.HInterID
|
left join h_v_IF_Material m on b.HMaterID=m.HItemID
|
left join h_v_IF_Unit u on b.HUnitID=u.HItemID
|
where a.HInterID=" + EquipProjectID);
|
|
ds1 = oCN.RunProcReturn(sql1, "Sb_EquipMaintainRuleBillMain");//保养
|
ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//配件
|
list.Add(ds1.Tables[0]);
|
list.Add(ds2.Tables[0]);
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.list = list;
|
return objJsonResult;
|
}
|
catch (Exception ex)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
|
/// <summary>
|
/// 根据设备显示设备点检程项目
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetDotCheckRuleItemByEquipProjectID")]
|
[HttpGet]
|
public object GetDotCheckRuleItemByEquipProjectID(int EquipProjectID)
|
{
|
if (EquipProjectID <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "产品器具未选择";
|
objjson.data = null;
|
return objjson;
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
string sql = string.Format(@"select b.HDotCheckItemID HDotCheckItemID,c.HNumber HDotCheckCode,b.HDotCheckItem,b.HDotCheckPart,b.HClaim,
|
b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark,a.HInterID,a.HBillNo from Sb_EquipDotCheckRuleBillMain a
|
left join Sb_EquipDotCheckRuleBillSub b on a.HInterID=b.HInterID
|
left join Gy_QCCheckItem c on c.HItemID=b.HDotCheckItemID
|
left join Gy_Employee e on e.HItemID=b.HManagerID
|
where a.HInterID=(select HEquipDotCheckRuleInterID from Gy_EquipFileBillMain where HInterID=" + EquipProjectID + ") ");
|
ds = oCN.RunProcReturn(sql, "Sb_EquipDotCheckRuleBillMain");
|
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;
|
}
|
}
|
/// <summary>
|
/// 根据设备点检规程显示设备点检程项目
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetDotCheckRuleItemByDotCheckRuleID")]
|
[HttpGet]
|
public object GetDotCheckRuleItemByDotCheckRuleID(int HDotCheckRuleInterID)
|
{
|
if (HDotCheckRuleInterID <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "设备点检规程未选择";
|
objjson.data = null;
|
return objjson;
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
string sql = string.Format(@"select b.HDotCheckItemID HDotCheckItemID,c.HNumber HDotCheckCode,b.HDotCheckItem,b.HDotCheckPart,b.HClaim,
|
b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark from Sb_EquipDotCheckRuleBillMain a
|
left join Sb_EquipDotCheckRuleBillSub b on a.HInterID=b.HInterID
|
left join Gy_QCCheckItem c on c.HItemID=b.HDotCheckItemID
|
left join Gy_Employee e on e.HItemID=b.HManagerID
|
where a.HInterID=" + HDotCheckRuleInterID);
|
ds = oCN.RunProcReturn(sql, "Sb_EquipDotCheckRuleBillMain");
|
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;
|
}
|
}
|
|
|
/// <summary>
|
/// 获取维修项目列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetRepairList_Json")]
|
[HttpGet]
|
public object GetRepairList_Json(string Repair)
|
{
|
if (Repair != "")
|
{
|
sWhere = " and ( HNumber like '%" + Repair + "%' or HName like '%" + Repair + "%' ) ";
|
}
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Repair where HStopflag=0 Order by HItemID ", "Gy_Repair");
|
}
|
else
|
{
|
string sql1 = "Select HItemID,HNumber ,HName from Gy_Repair where HStopflag=0 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "Gy_Repair");
|
}
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 获取扫码详情列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetWMSBarCodeDetailsList")]
|
[HttpGet]
|
public object GetWMSBarCodeDetailsList(int HInterID, string HBillType)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
ds = oCN.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp_Sum where HInterID=" + HInterID + " and HBillType='" + HBillType + "' Order by HItemID ", "h_v_KF_PonderationBillMain_Temp_Sum");
|
//ds = oCN.RunProcReturn("Select top 10 * from h_v_KF_PonderationBillMain_Temp_Sum Order by HInterID ", "h_v_KF_PonderationBillMain_Temp_Sum");
|
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;
|
}
|
}
|
|
|
/// <summary>
|
/// 根据ID删除缓存表中扫码记录
|
/// </summary>
|
/// <param name="sHitemID">缓存表ID</param>
|
/// <returns>object</returns>
|
[Route("Web/DelCacheList")]
|
[HttpGet]
|
public object DelCacheList(long sHitemID)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HitemID = " + sHitemID);
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "删除成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
|
|
#region [从数据库加载菜单]
|
public class MenuLoad
|
{
|
//public int HitemID { get; set; }
|
public string HitemID { get; set; }
|
//public int? HPartentID { get; set; }
|
public string HPartentID { get; set; }
|
public string HNumber { get; set; }
|
public string HName { get; set; }
|
public int HLevel { get; set; }
|
public string Hurl { get; set; }
|
public string HPicNum { get; set; }
|
public List<MenuLoad> childMenus { get; set; }
|
}
|
|
[Route("Web/MenuList")]
|
[HttpGet]
|
public object MenuList(string HMakeName, string HType)
|
{
|
try
|
{
|
List<MenuLoad> mu = new List<MenuLoad>(); //以父子级结构存放菜单清单信息
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //数据库操作工具
|
string sql = "select HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HPicNum from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' and HType = '" + HType + "' order by HPosition";
|
ds = oCn.RunProcReturn(sql, "Gy_MenuDefineSet"); //查询当前用户的自定义菜单数据
|
if (ds.Tables[0]==null || ds.Tables[0].Rows.Count == 0) //判断当前用户是否有设置过自定义信息，若记录数为0，则没有设置过，加载所有的菜单信息
|
{
|
sql = "Select * from Gy_Menu_1 where HType = '" + HType + "' Order by HPosition ";
|
ds = oCn.RunProcReturn(sql, "Gy_Menu");
|
}
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //将菜单的根节点保存到列表menu中
|
{
|
if (ds.Tables[0].Rows[i]["HPartentID"].ToString() == "0" || ds.Tables[0].Rows[i]["HitemID"].ToString() == ds.Tables[0].Rows[i]["HPartentID"].ToString()) //判断是否最外层根节点
|
{
|
MenuLoad tbj = new MenuLoad();
|
tbj.HitemID = ds.Tables[0].Rows[i]["HitemID"].ToString();
|
tbj.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString();
|
tbj.HName = ds.Tables[0].Rows[i]["HName"].ToString();
|
tbj.HPartentID = ds.Tables[0].Rows[i]["HPartentID"].ToString();
|
tbj.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString());
|
tbj.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString();
|
if (ds.Tables[0].Rows[i]["HPicNum"] != null)
|
{
|
tbj.HPicNum = ds.Tables[0].Rows[i]["HPicNum"].ToString();
|
}
|
mu.Add(tbj);
|
}
|
}
|
diguiLoad(ds.Tables[0], mu); //使用递归，将需要加载的数据以父子级的结构存放在mu中
|
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "查询成功！";
|
objJsonResult.data = Newtonsoft.Json.JsonConvert.SerializeObject(mu);
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
|
public void diguiLoad(DataTable dt, List<MenuLoad> tree)
|
{
|
for (int m = 0; m < tree.Count; m++)
|
{
|
tree[m].childMenus = new List<MenuLoad>();
|
for (int i = 0; i < dt.Rows.Count; i++)//第一次循环，得到所有根节点的子集
|
{
|
if (tree[m].HitemID.ToString() == dt.Rows[i]["HPartentID"].ToString() && dt.Rows[i]["HitemID"].ToString() != dt.Rows[i]["HPartentID"].ToString())
|
{
|
MenuLoad tbjson = new MenuLoad();
|
tbjson.HitemID = dt.Rows[i]["HitemID"].ToString();
|
tbjson.HPartentID = dt.Rows[i]["HPartentID"].ToString();
|
tbjson.HNumber = dt.Rows[i]["HNumber"].ToString();
|
tbjson.HName = dt.Rows[i]["HName"].ToString();
|
tbjson.HLevel = tree[m].HLevel;
|
tbjson.Hurl = dt.Rows[i]["Hurl"].ToString();
|
if (dt.Rows[i]["HPicNum"] != null)
|
{
|
tbjson.HPicNum = dt.Rows[i]["HPicNum"].ToString();
|
}
|
tree[m].childMenus.Add(tbjson);
|
}
|
}
|
for (int i = 0; i < tree[m].childMenus.Count; i++)
|
{
|
diguiLoad(dt, tree[m].childMenus);//再次用子集去循环，拿出子集的子集
|
}
|
}
|
|
}
|
|
#endregion
|
|
|
#region [菜单目录自定义]
|
|
#region 读取自定义数据
|
|
//对应Gy_Menu_1表中的记录，记录菜单清单，以及菜单中哪些被选中
|
public class MenuInit
|
{
|
public string HitemID;
|
public string HPartentID;
|
public string HNumber;
|
public string HName;
|
public int HLevel;
|
public string Hurl;
|
public string HType;
|
public bool HSelected;
|
}
|
|
//获取树状的自定义数据，类中的每个属性都是layui中树组件的渲染参数option的data属性值的参数
|
public class MenuDefineList
|
{
|
public string title { get; set; }
|
public string id { get; set; }
|
public string field { get; set; }
|
|
public List<MenuDefineList> children { get; set; }
|
public bool spread { get; set; }
|
public bool selected { get; set; }
|
|
}
|
|
//在自定义菜单界面，获取自定义菜单信息时，通过该类对象返回
|
public class MenuDefineResult
|
{
|
public List<MenuInit> dt; //记录Gy_Menu_1中的菜单清单，以及是否被选中
|
public List<MenuDefineList> tree; //根节点列表，在前端经过递归获取所有节点以及各节点是否选中
|
}
|
|
//自定义菜单：获取树组件数据
|
[Route("Web/MenuDefineSet")]
|
[HttpGet]
|
public object MenuDefineSet(string HMakeName, string HType)
|
{
|
try
|
{
|
//获取构建树状结构的数据
|
List<MenuInit> menuInitList = new List<MenuInit>(); //用以获取Gy_Menu_1中的所有菜单信息，以及对应节点是否被选中需要加载显示
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
ds = oCn.RunProcReturn("Select * from Gy_Menu_1 where HType = '" +HType + "' Order by HItemID ", "Gy_Menu"); //获取Gy_Menu_1中的所有菜单信息，用于为menuInitList列表充实数据
|
|
DataSet ds1 = new DataSet();
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //将Gy_Menu_1中的菜单信息及选中情况保存到menuInitList列表中，
|
{
|
//填充基本数据
|
MenuInit menuInit = new MenuInit();
|
menuInit.HitemID = ds.Tables[0].Rows[i]["HItemID"].ToString();
|
menuInit.HPartentID = ds.Tables[0].Rows[i]["HPartentID"].ToString();
|
menuInit.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString();
|
menuInit.HName = ds.Tables[0].Rows[i]["HName"].ToString();
|
menuInit.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString());
|
menuInit.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString();
|
menuInit.HType = ds.Tables[0].Rows[i]["HType"].ToString();
|
menuInit.HSelected = false;
|
|
//判断用户是否选中显示该菜单
|
String sql = "Select * from Gy_MenuDefineSet where HItemID = '" + ds.Tables[0].Rows[i]["HItemID"] + "' and HMakeName='" + HMakeName + "'";
|
ds1 = oCn.RunProcReturn(sql, "Gy_MenuDefineSet");
|
if (ds1.Tables[0].Rows.Count > 0) //对于Gy_Menu_1表中的菜单节点，通过检索在Gy_MenuDefineSet表中对应用户是否存在该节点的信息，判断该用户是否选中该节点需要加载显示在侧菜单栏
|
{
|
menuInit.HSelected = true;
|
}
|
menuInitList.Add(menuInit); //将Gy_Menu_1表中的菜单节点信息逐一添加到menuInitList列表中
|
}
|
|
|
//存储树状结构的数据
|
List<MenuDefineList> tree = new List<MenuDefineList>(); //用以获取菜单清单在layui中树组件渲染参数option中data值值的参数
|
for (int i = 0; i < menuInitList.Count; i++) //获取菜单清单中的根节点的渲染数据
|
{
|
if (menuInitList[i].HPartentID == "0" || menuInitList[i].HitemID == menuInitList[i].HPartentID) //判断是否是根节点
|
{
|
MenuDefineList define = new MenuDefineList();
|
define.id = menuInitList[i].HitemID;
|
define.field = menuInitList[i].HitemID;
|
define.title = menuInitList[i].HName;
|
define.spread = false;
|
define.selected = false;
|
if (menuInitList[i].HSelected == true)
|
{
|
define.selected = true;
|
}
|
tree.Add(define);
|
}
|
}
|
|
MenuDefineResult res = new MenuDefineResult();
|
res.dt = menuInitList;
|
res.tree = tree;
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "查询成功！";
|
objJsonResult.data = res;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 保存自定义数据
|
//用户接收前端传递的值：对于前端传递的被选中节点的数据，只需要各节点的id和title属性值，对于类SaveDefineMenu的HItemID、HName属性
|
public class SaveDefineMenu
|
{
|
public string HItemID;
|
public string HName;
|
}
|
|
//获取自定义菜单数据
|
[Route("Web/SaveMenuDefineSet")]
|
[HttpPost]
|
public object SaveMenuDefineSet([FromBody] JObject sMainSub)
|
{
|
try
|
{
|
//获取传参的自定义数据
|
var _value = sMainSub["sMainSub"].ToString();
|
string msg = _value.ToString();
|
string[] sArray = msg.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string HMakeName = sArray[1].ToString();
|
string saveData = sArray[0].ToString();
|
string HTypes = sArray[2].ToString();
|
List<SaveDefineMenu> saveDataList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<SaveDefineMenu>>(saveData);
|
|
//声明数据库操作工具
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
//设置数据库操作的回滚点，若在提交前报错，则回滚到该点，期间操作取消
|
oCN.BeginTran();
|
|
//删除当前用户的自定义数据
|
string sql = "delete from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' and HType = '" + HTypes + "'";
|
oCN.RunProc(sql);
|
|
//插入当前用户最新的自定义数据
|
for(int i=0;i< saveDataList.Count; i++)
|
{
|
sql = "select * from Gy_Menu_1 where HItemID = '" + saveDataList[i].HItemID + "'";
|
ds = oCn.RunProcReturn(sql,"Gy_Menu_1");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
string HPartentID = ds.Tables[0].Rows[0]["HPartentID"].ToString();
|
string HNumber = ds.Tables[0].Rows[0]["HNumber"].ToString();
|
int HLevel = int.Parse(ds.Tables[0].Rows[0]["HLevel"].ToString());
|
string Hurl = ds.Tables[0].Rows[0]["Hurl"].ToString();
|
string HType = ds.Tables[0].Rows[0]["HType"].ToString();
|
string HPicNum = ds.Tables[0].Rows[0]["HPicNum"].ToString();
|
|
if(HPartentID == "0" || HPartentID == ds.Tables[0].Rows[0]["HItemID"].ToString())
|
{
|
string HPosition = ds.Tables[0].Rows[0]["HPosition"].ToString();
|
sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','" + HPosition + "')";
|
oCN.RunProc(sql);
|
}
|
else
|
{
|
sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','z')";
|
oCN.RunProc(sql);
|
}
|
|
}
|
}
|
//提交数据库操作
|
oCN.Commit();
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "保存成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
|
|
#endregion
|
|
#endregion
|
|
|
|
#region 用户菜单快捷方式自定义
|
|
#region 获取用户快捷方式选择菜单
|
|
//快捷方式自定义菜单：获取树组件数据
|
[Route("Web/Xt_UserFastMenu_Display")]
|
[HttpGet]
|
public object Xt_UserFastMenu_Display(string HMakeName, string HType)
|
{
|
try
|
{
|
//获取构建树状结构的数据
|
List<MenuInit> menuInitList = new List<MenuInit>(); //用以获取Gy_Menu_1中的所有菜单信息，以及对应节点是否被选中需要加载显示
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
ds = oCn.RunProcReturn("Select * from Gy_Menu_1 where HType = '" + HType + "' Order by HItemID ", "Gy_Menu"); //获取Gy_Menu_1中的所有菜单信息，用于为menuInitList列表充实数据
|
|
DataSet ds1 = new DataSet();
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //将Gy_Menu_1中的菜单信息及选中情况保存到menuInitList列表中，
|
{
|
//填充基本数据
|
MenuInit menuInit = new MenuInit();
|
menuInit.HitemID = ds.Tables[0].Rows[i]["HItemID"].ToString();
|
menuInit.HPartentID = ds.Tables[0].Rows[i]["HPartentID"].ToString();
|
menuInit.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString();
|
menuInit.HName = ds.Tables[0].Rows[i]["HName"].ToString();
|
menuInit.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString());
|
menuInit.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString();
|
menuInit.HType = ds.Tables[0].Rows[i]["HType"].ToString();
|
menuInit.HSelected = false;
|
|
//判断用户是否选中显示该菜单
|
String sql = "Select * from Xt_UserFastMenu where HSubFuncID = '" + ds.Tables[0].Rows[i]["HItemID"] + "' and HUserID='" + HMakeName + "'";
|
ds1 = oCn.RunProcReturn(sql, "Xt_UserFastMenu");
|
if (ds1.Tables[0].Rows.Count > 0) //对于Gy_Menu_1表中的菜单节点，通过检索在Gy_MenuDefineSet表中对应用户是否存在该节点的信息，判断该用户是否选中该节点需要加载显示在侧菜单栏
|
{
|
menuInit.HSelected = true;
|
}
|
menuInitList.Add(menuInit); //将Gy_Menu_1表中的菜单节点信息逐一添加到menuInitList列表中
|
}
|
|
|
//存储树状结构的数据
|
List<MenuDefineList> tree = new List<MenuDefineList>(); //用以获取菜单清单在layui中树组件渲染参数option中data值值的参数
|
for (int i = 0; i < menuInitList.Count; i++) //获取菜单清单中的根节点的渲染数据
|
{
|
if (menuInitList[i].HPartentID == "0" || menuInitList[i].HitemID == menuInitList[i].HPartentID) //判断是否是根节点
|
{
|
MenuDefineList define = new MenuDefineList();
|
define.id = menuInitList[i].HitemID;
|
define.field = menuInitList[i].HitemID;
|
define.title = menuInitList[i].HName;
|
define.spread = false;
|
define.selected = false;
|
if (menuInitList[i].HSelected == true)
|
{
|
define.selected = true;
|
}
|
tree.Add(define);
|
}
|
}
|
|
MenuDefineResult res = new MenuDefineResult();
|
res.dt = menuInitList;
|
res.tree = tree;
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "查询成功！";
|
objJsonResult.data = res;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
|
#endregion
|
|
#region 保存用户快捷方式选择菜单
|
|
//保存用户快捷方式选择菜单
|
[Route("Web/Xt_UserFastMenu_Save")]
|
[HttpPost]
|
public object Xt_UserFastMenu_Save([FromBody] JObject sMainSub)
|
{
|
try
|
{
|
//获取传参的自定义数据
|
var _value = sMainSub["sMainSub"].ToString();
|
string msg = _value.ToString();
|
string[] sArray = msg.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string HMakeName = sArray[1].ToString();
|
string saveData = sArray[0].ToString();
|
string HTypes = sArray[2].ToString();
|
List<SaveDefineMenu> saveDataList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<SaveDefineMenu>>(saveData);
|
|
//声明数据库操作工具
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
//设置数据库操作的回滚点，若在提交前报错，则回滚到该点，期间操作取消
|
oCN.BeginTran();
|
|
//删除当前用户的自定义数据
|
string sql = "delete from Xt_UserFastMenu where HUserID = '" + HMakeName + "' and HType = '" + HTypes + "'";
|
oCN.RunProc(sql);
|
|
//插入当前用户最新的自定义数据
|
for (int i = 0; i < saveDataList.Count; i++)
|
{
|
sql = "select * from Gy_Menu_1 where HPartentID = '" + saveDataList[i].HItemID + "'";
|
ds = oCn.RunProcReturn(sql, "Gy_Menu_1");
|
if (ds.Tables[0].Rows.Count == 0) //判断该节点是否为最下级节点，即不存在子节点
|
{
|
sql = "select * from Gy_Menu_1 where HItemID = '" + saveDataList[i].HItemID + "'";
|
ds = oCn.RunProcReturn(sql, "Gy_Menu_1");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
string HUserID = HMakeName;
|
string HSubFuncID = ds.Tables[0].Rows[0]["HItemID"].ToString();
|
string HCaption = ds.Tables[0].Rows[0]["HName"].ToString();
|
string HType = ds.Tables[0].Rows[0]["HType"].ToString();
|
|
sql = "insert into Xt_UserFastMenu(HUserID,HSubFuncID,HCaption,HType) values('" + HUserID + "','" + HSubFuncID + "','" + HCaption + "','" + HType + "')";
|
oCN.RunProc(sql);
|
}
|
}
|
}
|
//提交数据库操作
|
oCN.Commit();
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "保存成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
|
#endregion
|
|
#region 加载console.html页面的快捷方式
|
//快捷方式自定义菜单：获取树组件数据
|
[Route("Web/Xt_UserFastMenu_Init")]
|
[HttpGet]
|
public object Xt_UserFastMenu_Init(string HMakeName, string HType)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
string sql = "select a.HSubFuncID, a.HCaption,a.HPicNum,b.Hurl from Xt_UserFastMenu as a join Gy_Menu_1 as b on a.HSubFuncID = b.HItemID where a.HUserID = '" + HMakeName + "' and b.HType = '" + HType + "' Order by a.HItemID";
|
ds = oCn.RunProcReturn(sql, "Xt_UserFastMenu"); //获取Xt_UserFastMenu中该用户设置的自定义菜单信息，用于在前端加载
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "查询成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 保存快捷方式的图标
|
[Route("Web/Xt_UserFastMenu_IconSave")]
|
[HttpGet]
|
public object Xt_UserFastMenu_IconSave(string Icon, string HItemID, string HMakeName)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
string sql = "update Xt_UserFastMenu set HPicNum = '" + Icon + "' where HSubFuncID='" + HItemID + "' and HUserID = '" + HMakeName + "'";
|
oCN.RunProc(sql); //获取Xt_UserFastMenu中该用户设置的自定义菜单信息，用于在前端加载
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "查询成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 获取快捷方式的图标
|
[Route("Web/Xt_UserFastMenu_IconGet")]
|
[HttpGet]
|
public object Xt_UserFastMenu_IconGet(string HItemID, string HMakeName)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
string sql = "select HPicNum from Xt_UserFastMenu where HSubFuncID='" + HItemID + "' and HUserID = '" + HMakeName + "'";
|
ds = oCn.RunProcReturn(sql, "Xt_UserFastMenu"); //获取Xt_UserFastMenu中该用户设置的自定义菜单信息，用于在前端加载
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "查询成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
#endregion
|
#endregion
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
///// <summary>
|
///// 产品入库缓存列表刷新信息
|
///// </summary>
|
///// <returns></returns>
|
//[Route("Web/chanpinruk")]
|
//[HttpGet]
|
//public object chanpinruk(string HBillType, string sHMaker, Int64 HOrgID)
|
//{
|
// try
|
// {
|
// ds = webserver.GetKf_PonderationBillMain_TempList_New(HBillType, sHMaker, HOrgID);
|
// 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;
|
// }
|
//}
|
|
|
/// <summary>
|
/// 产品入库缓存列表刷新信息
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/chanpinruk")]
|
[HttpGet]
|
public object chanpinruk(string HBillType, string sHMaker, Int64 HOrgID)
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
try
|
{
|
ds = oWebs.GetKf_PonderationBillMain_TempList_New(HBillType, sHMaker, HOrgID);
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 产品入库缓存列表刷新信息
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/chanpinruk1")]
|
[HttpGet]
|
public object chanpinruk1(string HBillType, string sHMaker, Int64 HOrgID)
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
try
|
{
|
ds = oWebs.GetKf_PonderationBillMain_TempList_New(HBillType, sHMaker, HOrgID);
|
|
if (ds == null)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
|
}
|
|
List<object> columnNameList = new List<object>();
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
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];
|
objJsonResult.list = columnNameList;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
#region PDA其他入库列表模块
|
/// <summary>
|
/// 其他入库缓存列表刷新信息
|
/// </summary>
|
/// <param name="HBillType"></param>
|
/// <param name="sHMaker"></param>
|
/// <param name="HOrgID"></param>
|
/// <returns></returns>
|
[Route("Web/GetOtherInBillMain_TempList_New")]
|
[HttpGet]
|
public object GetOtherInBillMain_TempList_New (string HBillType, string sHMaker, Int64 HOrgID)
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
try
|
{
|
List<object> columnNameList = new List<object>();
|
|
DataSet ds = oCN.RunProcReturn("exec h_p_KF_GetPonderationBillMain_TempList_New1 '" + HBillType + "','" + sHMaker + "'," + HOrgID.ToString(), "h_p_KF_GetPonderationBillMain_TempList_New1");
|
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = 0;
|
return objJsonResult;
|
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
|
}
|
else
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.data = ds.Tables[0];
|
objJsonResult.list = columnNameList;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
/// <summary>
|
/// 获取流水号列表
|
/// </summary>
|
/// <param name="HInterID"></param>
|
/// <returns></returns>
|
[Route("Web/GetProcNoList")]
|
[HttpGet]
|
public object GetProcNoList(int HInterID,string sWhere,string UserID)
|
{
|
List<object> columnNameList = new List<object>();
|
try
|
{
|
ds = oCN.RunProcReturn("exec h_p_Sc_ProcNoList '" + HInterID + "','" + sWhere + "','" + UserID + "'" , "h_p_Sc_ProcNoList");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = e.Message.ToString();
|
objJsonResult.data = null;
|
objJsonResult.list = columnNameList;
|
}
|
return objJsonResult;
|
}
|
|
}
|
|
}
|
