From c05f1964fc49bebb9ea64e189400337f8d4f0c42 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期四, 12 九月 2024 10:04:25 +0800
Subject: [PATCH] 批量修改ClsCN；添康科技生成条码时设置为批次码；
---
WebAPI/Controllers/WebAPIController.cs | 24 ++++++++++++------------
1 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index 30eead2..48f1ae6 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -52,7 +52,7 @@
string ComputerName;
IPAddress = DBUtility.ClsPub.IPAddress;
ComputerName = DBUtility.ClsPub.ComputerName;
- ClsCNSRM oCnLoc = new ClsCNSRM();
+ ClsCN oCnLoc = new ClsCN();
try
{
oCnLoc.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " +
@@ -85,7 +85,7 @@
{
string VsWhere = "";
string PcWhere = "";
- SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
DataSet ds;
//鍏朵粬杩囨护
if (msg.Trim() == "")
@@ -183,7 +183,7 @@
try
{
DataSet ds = null;
- ClsCNSRM oCnLoc = new ClsCNSRM();
+ ClsCN oCnLoc = new ClsCN();
DAL.ClsUser oUser = new DAL.ClsUser();
Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
//LogService.Write("娴嬭瘯1锛�"+ DBUtility.ClsPub.sExeReturnInfo);
@@ -229,7 +229,7 @@
DataSet DS;
try
{
- SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
DS = oCn.RunProcReturn("select * from Gy_Czygl where Czybm='" + MainID + "' and Czmm='" + sPsd + "' ", "Gy_Czygl");
if (DS.Tables[0].Rows.Count == 0)
return null;
@@ -245,7 +245,7 @@
}
public DataSet CheckCzymc(string sUser, string sPsd)
{
- SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
SqlParameter[] prams ={oCn.MakeInParam("@Czymc",SqlDbType.VarChar,100,sUser ),
oCn.MakeInParam("@Czmm",SqlDbType.VarChar ,100,sPsd ),
};
@@ -264,7 +264,7 @@
{
try
{
- ClsCNSRM oCn = new ClsCNSRM();
+ ClsCN oCn = new ClsCN();
DataSet oDs = new DataSet();
//==========
if (PassWord.Trim() != Repassword.Trim())
@@ -408,7 +408,7 @@
[HttpGet]
public object SaveOpenTmp(string HNumber, string HName)
{
- ClsCNSRM oCn = new ClsCNSRM();
+ ClsCN oCn = new ClsCN();
try
{
@@ -445,7 +445,7 @@
[HttpGet]
public object DelOpenTmp(string HItemID)
{
- ClsCNSRM oCn = new ClsCNSRM();
+ ClsCN oCn = new ClsCN();
try
{
//oCn.BeginTran();
@@ -792,7 +792,7 @@
[HttpPost]
public object MsgCount()
{
- ClsCNSRM oCn = new ClsCNSRM();
+ ClsCN oCn = new ClsCN();
DataSet oDs = new DataSet();
oDs = oCn.RunProcReturn("select * from Gy_Message", "Gy_Message");
objJsonResult.code = "0";
@@ -808,7 +808,7 @@
[HttpGet]
public object MsgData(string sWhere)
{
- ClsCNSRM oCn = new ClsCNSRM();
+ ClsCN oCn = new ClsCN();
DataSet oDs = new DataSet();
var sql = "select A.HInterID,b.HEntryID,A.HContext,A.HDeptID,D.HName HDeptName, A.HSendMan, B.HReceiveMan,A.HLevel,A.HDescription,case when B.HReadFlag=0 then '鏈槄' when B.HReadFlag=1 then '宸查槄' end HReadFlag,A.HDate" +
" from OA_InformBillMain A inner join OA_InformBillSub B on A.HInterID=B.HInterID left join Gy_Department D on A.HDeptID=D.HItemID where 1=1 " + sWhere;
@@ -836,7 +836,7 @@
[HttpGet]
public object UpdateMessage(string UserName, string HInterID, string HEntryID)
{
- ClsCNSRM oCn = new ClsCNSRM();
+ ClsCN oCn = new ClsCN();
oCn.BeginTran();
oCn.RunProc("Update OA_InformBillSub set HReadFlag=1 HUpDater='" + UserName + "',HUpDateDate=getdate() where HInterID='" + HInterID + "' and HEntryID='" + HEntryID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
oCn.Commit();
@@ -857,7 +857,7 @@
var postMesseege = _linterid + ";" + _huserName;
//HttpHelper.PostData("http://localhost:8082/ZYMES/layuiAdmin.std-v1.2.1/src/views/SRM/Api/SRM_Web_PoBarCodeBillApi.ashx", postMesseege);
HttpHelper.PostData("http://60.191.21.115:9090/layuiAdmin.std-v1.2.1/src/views/SRM/Api/SRM_Web_PoBarCodeBillApi.ashx", postMesseege);
- SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
string sql = $"Update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0) + 1 where HItemID in ({_linterid})";
oCn.RunProc(sql);
objJsonResult.code = "0";
--
Gitblit v1.9.1