From f7661ec17f87c4185bbe906fe98e114435a4da5a Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 19 十月 2023 12:21:25 +0800
Subject: [PATCH] 1.更改菜单接口排序问题，模具待维修接口过滤问题、增加APP菜单图标 2.更改模具维修申请单、维修单据流水号反写问题 3.增加模具查询功能接口
---
VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs | 478 ++++++++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 439 insertions(+), 39 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs b/VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs
index e65c2b4..a7085be 100644
--- a/VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs
@@ -9,6 +9,7 @@
using System.Linq;
using System.Threading.Tasks;
using VueWebCoreApi.Models;
+using VueWebCoreApi.Models.MouldSearch;
using VueWebCoreApi.Tools;
namespace VueWebCoreApi.DLL.DAL
@@ -72,19 +73,20 @@
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
var sql = @"select A.status,A.usestatus,A.code,A.name,A.spec,A.warehousecode,S.name as warehousename,
- A.surp_life,'0' as serlife,A.resi_life,(case when isnull(M.mouldcode,'')='' then 'N' else 'Y' end) as is_part,
- STUFF((SELECT ',' + B.partcode
- from TMouldInfoPart B
- where A.code = B.mouldcode
- FOR XML PATH('')), 1, 1, '') AS partcode,
- A.lm_user as usercode,U.username,A.lm_date
- from TMouldInfo A
- left join TSecStck S on A.warehousecode=S.code
- left join (
- select distinct mouldcode from TMouldInfoPart
- ) M on A.code=M.mouldcode
- left join TUser U on A.lm_user=U.usercode
- where 1=1 " + search;
+ A.surp_life,(select isnull(sum(usecount_life),0) from TMould_UpDownReord R where R.mould_code=A.code) as serlife,
+ A.resi_life,(case when isnull(M.mouldcode,'')='' then 'N' else 'Y' end) as is_part,
+ STUFF((SELECT ',' + B.partcode
+ from TMouldInfoPart B
+ where A.code = B.mouldcode
+ FOR XML PATH('')), 1, 1, '') AS partcode,
+ A.lm_user as usercode,U.username,A.lm_date
+ from TMouldInfo A
+ left join TSecStck S on A.warehousecode=S.code
+ left join (
+ select distinct mouldcode from TMouldInfoPart
+ ) M on A.code=M.mouldcode
+ left join TUser U on A.lm_user=U.usercode
+ where 1=1 " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
@@ -103,7 +105,7 @@
#endregion
#region[妯″叿娓呭崟鏂板缂栬緫]
- public static ToMessage AddUpdateMouldManger(string mouldcode, string mouldname, string mouldspec, string warehousecode, string surplife, string resilife, string status, string mouldpart, string opertype, User us)
+ public static ToMessage AddUpdateMouldManger(string mouldcode, string mouldname, string mouldspec, string surplife, string resilife, string status, string mouldpart, string opertype, User us)
{
var sql = "";
var dynamicParams = new DynamicParameters();
@@ -113,8 +115,8 @@
if (opertype == "Add")
{
//鍐欏叆妯″叿娓呭崟琛�
- sql = @"insert into TMouldInfo(code,name,spec,status,usestatus,warehousecode,surp_life,resi_life,lm_user,lm_date)
- values(@code,@name,@spec,@status,@usestatus,@warehousecode,@surp_life,@resi_life,@lm_user,@lm_date)";
+ sql = @"insert into TMouldInfo(code,name,spec,status,surp_life,resi_life,lm_user,lm_date)
+ values(@code,@name,@spec,@status,@surp_life,@resi_life,@lm_user,@lm_date)";
list.Add(new
{
str = sql,
@@ -124,8 +126,6 @@
name = mouldname,
spec = mouldspec,
status = status,
- usestatus = "0",//浣跨敤鐘舵�侊細鍦ㄥ簱/鍑哄簱/涓婃満/涓嬫満/缁翠慨/澶栧��(0,1,2,3,4,5)
- warehousecode = warehousecode,
surp_life = surplife,
resi_life = resilife,
lm_user = us.usercode,
@@ -171,7 +171,7 @@
if (opertype == "Update")
{
//淇敼妯″叿娓呭崟琛�
- sql = @"update TMouldInfo set name=@name,spec=@spec,status=@status,warehousecode=@warehousecode,
+ sql = @"update TMouldInfo set name=@name,spec=@spec,status=@status,
surp_life=@surp_life,resi_life=@resi_life,lm_user=@lm_user,lm_date=@lm_date where code=@code";
list.Add(new
{
@@ -182,7 +182,6 @@
name = mouldname,
spec = mouldspec,
status = status,
- warehousecode = warehousecode,
surp_life = surplife,
resi_life = resilife,
lm_user = us.usercode,
@@ -1814,7 +1813,7 @@
//鍐欏叆淇濆吇璁板綍涓昏〃
sql = @"insert into TMouldmaint_Proc_Main(bywo,mould_code,mouldmaint_code,maint_result,maint_user,maint_date)
- values(@bywo,@mould_code,@mouldmaint_code,@maint_result,@lm_user,@lm_date)";
+ values(@bywo,@mould_code,@mouldmaint_code,@maint_result,@maint_user,@maint_date)";
list.Add(new
{
str = sql,
@@ -1823,15 +1822,15 @@
bywo = bywo,
mould_code = json.code,
mouldmaint_code = json.standcode,
- lm_user = us.usercode,
- lm_date = DateTime.Now.ToString(),
+ maint_user = us.usercode,
+ maint_date = DateTime.Now.ToString(),
maint_result = json.result
}
});
//寰幆鍐欏叆淇濆吇璁板綍瀛愯〃
for (int i = 0; i < json.children.Count; i++)
{
- sql = @"insert into TEqpmaint_Proc_Deta(seq,m_id,mouldmaideta_code,result,maint_value,lm_user,lm_date)
+ sql = @"insert into TMouldmaint_Proc_Deta(seq,m_id,mouldmaideta_code,result,maint_value,lm_user,lm_date)
values(@seq,CONVERT(INT,IDENT_CURRENT('TMouldmaint_Proc_Main')),@mouldmaideta_code,@result,@maint_value,@lm_user,@lm_date)";
list.Add(new
{
@@ -1866,6 +1865,136 @@
mes.count = 0;
mes.Message = "淇濆吇澶辫触!";
mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+
+ #region[妯″叿淇℃伅鏌ヨ,鎵弿妯″叿浜岀淮鐮乚
+ public static ToMessage ScanMouldQrCodeMessageData(string mouldcode)
+ {
+ string sql = "", search = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ if (mouldcode != "" && mouldcode != null)
+ {
+ search += " where code=@mouldcode ";
+ dynamicParams.Add("@mouldcode", mouldcode);
+ }
+ //鏌ユ壘妯″叿淇℃伅
+ sql = @"select code,name,spec
+ from TMouldInfo"+search;
+ dynamicParams.Add("@mouldcode", mouldcode);
+ var dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = dt;
+ return mes;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "鏆傛棤鏁版嵁鎴栨棤鏁堢殑妯″叿浜岀淮鐮佷俊鎭�!";
+ mes.data = null;
+ return mes;
+ }
+
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[妯″叿淇℃伅鏌ヨ鏄庣粏]
+ public static ToMessage ScanMouldQrCodeMessageSubData(string mouldcode)
+ {
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ List<MouldMessage> list = new List<MouldMessage>();
+ try
+ {
+ //鏌ユ壘妯″叿淇℃伅
+ MouldMessage moud = new MouldMessage();
+ sql = @"select code,name,spec,surp_life,resi_life,status,usestatus
+ from TMouldInfo where code=@mouldcode";
+ dynamicParams.Add("@mouldcode", mouldcode);
+ var dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+
+ moud.mouldcode = dt.Rows[0]["code"].ToString();
+ moud.mouldname = dt.Rows[0]["name"].ToString();
+ moud.mouldspec = dt.Rows[0]["spec"].ToString();
+ moud.surp_life = dt.Rows[0]["surp_life"].ToString();
+ moud.resi_life = dt.Rows[0]["resi_life"].ToString();
+ moud.status = dt.Rows[0]["status"].ToString();
+ moud.usestatus = dt.Rows[0]["usestatus"].ToString();
+ //鏌ヨ鏈�杩戜竴娆＄偣妫�璁板綍
+ sql = @"select top 1 chk_date from TMouldchk_Proc_Main where mould_code=@mouldcode order by chk_date desc";
+ dynamicParams.Add("@mouldcode", mouldcode);
+ var dt0 = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt0.Rows.Count > 0)
+ {
+ moud.checkdate = dt0.Rows[0]["chk_date"].ToString();
+ }
+ //鏌ヨ鏈�杩戜竴娆′繚鍏昏褰�
+ sql = @"select top 1 maint_date from TMouldmaint_Proc_Main where mould_code=@mouldcode order by maint_date desc";
+ dynamicParams.Add("@mouldcode", mouldcode);
+ var dt1 = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt1.Rows.Count > 0)
+ {
+ moud.maintdate = dt1.Rows[0]["maint_date"].ToString();
+ }
+
+ //鏌ヨ鍏宠仈浜у搧
+ moud.children = new List<RelatedProduct>();
+ sql = @"select P.partcode,M.partname,M.partspec
+ from TMouldInfoPart P
+ left join TMateriel_Info M on P.partcode=M.partcode
+ where P.mouldcode=@mouldcode";
+ dynamicParams.Add("@mouldcode", mouldcode);
+ var dt2 = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt2.Rows.Count > 0)
+ {
+ for (int i = 0; i < dt2.Rows.Count; i++)
+ {
+ RelatedProduct mousb = new RelatedProduct();
+ mousb.partcode = dt2.Rows[i]["partcode"].ToString();
+ mousb.partname = dt2.Rows[i]["partname"].ToString();
+ mousb.partspec = dt2.Rows[i]["partspec"].ToString();
+ moud.children.Add(mousb);
+ }
+ }
+ list.Add(moud);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = list;
+ return mes;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "鏆傛棤鏁版嵁鎴栨棤鏁堢殑妯″叿浜岀淮鐮佷俊鎭�!";
+ mes.data = null;
+ return mes;
}
}
catch (Exception e)
@@ -1976,8 +2105,8 @@
}
#endregion
- #region[璁惧缁翠慨鐢宠,鎻愪氦淇濆瓨]
- public static ToMessage MaintainScanMouldApplySave(string menucode, string mouldcode, string faultsourcecode, string faultdescr, User us, List<IFormFile> files)
+ #region[妯″叿缁翠慨鐢宠,鎻愪氦淇濆瓨]
+ public static ToMessage MaintainScanMouldApplySave(string menucode, string mouldcode, string faultsourcecode, string faultdescr, User us, IFormFileCollection files)
{
var sql = "";
string sqwo = "", numvalue = "";
@@ -2001,16 +2130,20 @@
{
for (int i = 0; i < files.Count; i++)
{
+ IFormFile file = files[i];
+ string imgName = "SQ" + DateTime.Now.ToString("yyyyMMddhhmmss") + i.ToString();
+ string filePath = "wwwroot/MouldRecordImage/" + imgName + file.FileName; //閫氳繃姝ゅ璞¤幏鍙栨枃浠跺悕
+
// 鐢熸垚鏂囦欢鍚�
- var fileName = "SQ" + DateTime.Now.ToString("yyyyMMddhhmmss") + i.ToString() + Path.GetExtension(files[i].FileName);
+ //var fileName = "SQ" + DateTime.Now.ToString("yyyyMMddhhmmss") + i.ToString() + Path.GetExtension(files[i].FileName);
// 鎷兼帴鏂囦欢淇濆瓨璺緞
- var filePath = Path.Combine("wwwroot/MouldRecordImage", fileName);
+ //var filePath = Path.Combine("wwwroot/MouldRecordImage", fileName);
- // 淇濆瓨鏂囦欢
+ // 淇濆瓨鏂囦欢var stream = new FileStream(filePath, FileMode.Create)
using (var stream = new FileStream(filePath, FileMode.Create))
{
- files[i].CopyToAsync(stream);
+ files[i].CopyTo(stream);
}
//寰幆鍐欑淮淇褰曞搴斿浘鐗囪〃
sql = @"insert into TMould_RepairImage(source_wo,wo_type,img1url)
@@ -2048,6 +2181,9 @@
//鍥炲啓妯″叿娓呭崟,妯″叿鐘舵��(鏁呴殰)銆佷娇鐢ㄧ姸鎬�(寰呯淮淇�)
sql = @"update TMouldInfo set status='N',usestatus='4' where code=@mouldcode";
list.Add(new { str = sql, parm = new { mouldcode = mouldcode } });
+ //鏇存柊鍗曟嵁娴佹按鍙�
+ List<object> list1 = SeachEncodeJob.StrEncodingUpdate(menucode, numvalue);
+ list.Add(list1[0]);
bool aa = DapperHelper.DoTransaction(list);
if (aa)
{
@@ -2085,18 +2221,19 @@
var dynamicParams = new DynamicParameters();
try
{
- if (mouldcode == "" || mouldcode == null)
+ if (mouldcode != "" && mouldcode != null)
{
search += "and B.code=@mouldcode ";
dynamicParams.Add("@mouldcode", mouldcode);
}
//鑾峰彇妯″叿缁翠慨鍒楄〃宸茬敵璇锋湭缁翠慨鐨勬暟鎹�
sql = @"select A.docu_code,B.code as mouldcode,B.name as mouldname,B.spec as mouldspec,B.surp_life,B.resi_life,
- A.request_person,A.request_date,
+ A.request_person,U.username as request_name,A.request_date,
(case when A.source='A' then '鐐规' when A.source='B' then '淇濆吇' when A.source='D' then '鎵嬪伐' end) as source,
A.failure_descript
from TMould_RepairRequest A
inner join TMouldInfo B on A.mould_code=B.code
+ left join TUser U on A.request_person=U.usercode
where A.status='REPA' " + search;
var data = DapperHelper.selectdata(sql, dynamicParams);
if (data.Rows.Count > 0)
@@ -2124,7 +2261,7 @@
#endregion
#region[妯″叿缁翠慨鎻愪氦]
- public static ToMessage RepairScanMouldSave(string menucode, string docu_code, string mouldcode, string faultdescr, string is_stoprepair, string repaircontent, User us, List<IFormFile> files)
+ public static ToMessage RepairScanMouldSave(string menucode, string docu_code, string mouldcode, string faultdescr, string is_stoprepair, string repaircontent, User us, IFormFileCollection files)
{
var sql = "";
string wxwo = "", numvalue = "";
@@ -2148,16 +2285,20 @@
{
for (int i = 0; i < files.Count; i++)
{
+ IFormFile file = files[i];
+ string imgName = "WX" + DateTime.Now.ToString("yyyyMMddhhmmss") + i.ToString();
+ string filePath = "wwwroot/MouldRecordImage/" + imgName + file.FileName; //閫氳繃姝ゅ璞¤幏鍙栨枃浠跺悕
+
// 鐢熸垚鏂囦欢鍚�
- var fileName = "WX" + DateTime.Now.ToString("yyyyMMddhhmmss") + i.ToString() + Path.GetExtension(files[i].FileName);
+ //var fileName = "WX" + DateTime.Now.ToString("yyyyMMddhhmmss") + i.ToString() + Path.GetExtension(files[i].FileName);
// 鎷兼帴鏂囦欢淇濆瓨璺緞
- var filePath = Path.Combine("wwwroot/MouldRecordImage", fileName);
+ //var filePath = Path.Combine("wwwroot/MouldRecordImage", fileName);
- // 淇濆瓨鏂囦欢
+ // 淇濆瓨鏂囦欢var stream = new FileStream(filePath, FileMode.Create)
using (var stream = new FileStream(filePath, FileMode.Create))
{
- files[i].CopyToAsync(stream);
+ files[i].CopyTo(stream);
}
//寰幆鍐欑淮淇褰曞搴斿浘鐗囪〃
sql = @"insert into TMould_RepairImage(source_wo,wo_type,img1url)
@@ -2200,6 +2341,9 @@
//鍥炲啓妯″叿娓呭崟,浣跨敤鐘舵��(宸茬淮淇�)
sql = @"update TMouldInfo set usestatus='5' where code=@mouldcode";
list.Add(new { str = sql, parm = new { mouldcode = mouldcode } });
+ //鏇存柊鍗曟嵁娴佹按鍙�
+ List<object> list1 = SeachEncodeJob.StrEncodingUpdate(menucode, numvalue);
+ list.Add(list1[0]);
bool aa = DapperHelper.DoTransaction(list);
if (aa)
{
@@ -2244,10 +2388,11 @@
}
//鑾峰彇妯″叿缁翠慨鍒楄〃宸茬淮淇殑鏁版嵁
sql = @"select A.repair_code,B.code as mouldcode,B.name as mouldname,B.spec as mouldspec,B.surp_life,B.resi_life,
- A.repair_person,A.repair_date,A.is_shutdown,
+ A.repair_person,U.username as repair_name,A.repair_date,A.is_shutdown,
A.failure_descript
from TMould_Repair A
inner join TMouldInfo B on A.mould_code=B.code
+ left join TUser U on A.repair_person=U.usercode
where A.status='COMP' " + search;
var data = DapperHelper.selectdata(sql, dynamicParams);
if (data.Rows.Count > 0)
@@ -2413,7 +2558,6 @@
return mes;
}
#endregion
-
#region[妯″叿涓婃満,鎵弿妯″叿缂栫爜]
@@ -2942,5 +3086,261 @@
return mes;
}
#endregion
+
+
+ #region[妯″叿鍏ュ簱,鎵弿妯″叿缂栫爜]
+ public static ToMessage MouldInWareHouseQrCodeData(string mouldcode)
+ {
+ string sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鍒ゆ柇褰撳墠妯″叿褰撳墠浣跨敤鐘舵��
+ sql = @"select code,name,spec,status,usestatus,surp_life,resi_life
+ from TMouldInfo where code=@mouldcode";
+ dynamicParams.Add("@mouldcode", mouldcode);
+ var dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ if (dt.Rows[0]["status"].ToString() == "Y")
+ {
+ switch (dt.Rows[0]["usestatus"].ToString())
+ {
+ case "0": //鍦ㄥ簱
+ mes.code = "300";
+ mes.Message = "褰撳墠妯″叿鍦ㄥ簱鐘舵��,涓嶇鍚堝叆搴撴搷浣�!";
+ mes.data = null;
+ return mes;
+ case "2": //涓婃満
+ mes.code = "300";
+ mes.Message = "褰撳墠妯″叿涓婃満鐘舵��,涓嶇鍚堝叆搴撴搷浣�!";
+ mes.data = null;
+ return mes;
+ case "7": //澶栧��
+ mes.code = "300";
+ mes.Message = "褰撳墠妯″叿澶栧�熺姸鎬�,涓嶇鍚堝叆搴撴搷浣�!";
+ mes.data = null;
+ return mes;
+ default:
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = dt;
+ break;
+ }
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "妯″叿鏁呴殰鎴栫淮淇腑,涓嶅厑璁稿叆搴撴搷浣�!";
+ mes.data = null;
+ return mes;
+ }
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "鏃犳晥鐨勬ā鍏蜂簩缁寸爜淇℃伅!";
+ mes.data = null;
+ return mes;
+ }
+
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[妯″叿鍏ュ簱鎻愪氦]
+ public static ToMessage MouldInWareHouseSave(string mouldcode, string warehousecode, string description, User us)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ list.Clear();
+ //鍐欏叆妯″叿鍑哄叆搴撹褰曡〃(鍏ュ簱鎿嶄綔)
+ sql = @"insert into TMould_InOutReord(mould_code,type,warehouse_code,description,lm_user,lm_date)
+ values(@mould_code,@type,@warehouse_code,@description,@lm_user,@lm_date)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ mould_code = mouldcode,
+ type = "IN",
+ warehouse_code = warehousecode,
+ description = description,
+ lm_user = us.usercode,
+ lm_date = DateTime.Now.ToString()
+ }
+ });
+
+ //鍥炲啓妯″叿娓呭崟,浣跨敤鐘舵��(鍏ュ簱),浠撳簱缂栫爜
+ sql = @"update TMouldInfo set usestatus='0',warehousecode=@warehousecode where code=@mouldcode";
+ list.Add(new { str = sql, parm = new { mouldcode = mouldcode, warehousecode = warehousecode } });
+
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ //鍐欏叆鎿嶄綔璁板綍琛�
+ LogHelper.DbOperateLog(us.usercode, "妯″叿鍏ュ簱", "妯″叿:" + mouldcode, us.usertype);
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "妯″叿鍏ュ簱鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "妯″叿鍏ュ簱澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+
+ #region[妯″叿鍑哄簱,鎵弿妯″叿缂栫爜]
+ public static ToMessage MouldOutWareHouseQrCodeData(string mouldcode)
+ {
+ string sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鍒ゆ柇褰撳墠妯″叿褰撳墠浣跨敤鐘舵��
+ sql = @"select * from TMouldInfo where code=@mouldcode ";
+ dynamicParams.Add("@mouldcode", mouldcode);
+ var dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ if (dt.Rows[0]["status"].ToString() == "Y")
+ {
+ //鍒ゆ柇褰撳墠妯″叿鏄惁鍦ㄥ鍊熺姸鎬�
+ sql = @"select M.code as mould_code,M.name as mould_name,M.spec as mould_spec,
+ M.surp_life,M.resi_life,M.warehousecode,C.name as warehousename
+ from TMouldInfo M
+ left join TSecStck C on M.warehousecode=C.code
+ where M.code=@mouldcode and M.usestatus='0'";
+ dynamicParams.Add("@mouldcode", mouldcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ return mes;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "褰撳墠妯″叿鏈湪搴�,涓嶇鍚堝嚭搴撴搷浣�!";
+ mes.data = null;
+ return mes;
+ }
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "妯″叿鏁呴殰鎴栫淮淇腑,涓嶇鍚堝嚭搴撴搷浣�!";
+ mes.data = null;
+ return mes;
+ }
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "鏃犳晥鐨勬ā鍏蜂簩缁寸爜淇℃伅!";
+ mes.data = null;
+ return mes;
+ }
+
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[妯″叿鍑哄簱鎻愪氦]
+ public static ToMessage MouldOutWareHouseSave(string mouldcode, string warehousecode, string description, User us)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ list.Clear();
+ //鍐欏叆妯″叿鍑哄叆搴撹褰曡〃(鍑哄簱鎿嶄綔)
+ sql = @"insert into TMould_InOutReord(mould_code,type,warehouse_code,description,lm_user,lm_date)
+ values(@mould_code,@type,@warehouse_code,@description,@lm_user,@lm_date)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ mould_code = mouldcode,
+ type = "OUT",
+ warehouse_code = warehousecode,
+ description = description,
+ lm_user = us.usercode,
+ lm_date = DateTime.Now.ToString()
+ }
+ });
+
+ //鍥炲啓妯″叿娓呭崟,浣跨敤鐘舵��(鍑哄簱),娓呴櫎浠撳簱缂栫爜
+ sql = @"update TMouldInfo set usestatus='1',warehousecode=@warehousecode where code=@mouldcode";
+ list.Add(new { str = sql, parm = new { mouldcode = mouldcode, warehousecode ="" } });
+
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ //鍐欏叆鎿嶄綔璁板綍琛�
+ LogHelper.DbOperateLog(us.usercode, "妯″叿鍑哄簱", "妯″叿:" + mouldcode, us.usertype);
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "妯″叿鍑哄簱鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "妯″叿鍑哄簱澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
}
}
--
Gitblit v1.9.3