From 259584df9c06ade70f1f351affb35d4922e1263d Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 07 十一月 2025 16:23:13 +0800
Subject: [PATCH] 这个打印送货单，你们给我做两种，做一张打印没得数量的，做一张打印有数量的。送货单格式就是32开，就哎就是A4排一半。你们打了测试，注意，美观。 把那个把它做出来，下一批就用这个自动打。 不是不是打印的要数量都是有数量，要没得数量都没得数量。就是点打印的时候就两个按钮嘛，一个是有数量打印，或者或者或者空白送货单打印。 现在这个现在的送货单都是没有数量噻。现在那个要的，比如你那里再打你那个打印关闭的按钮，要把搞成两个打印嘛，就是打印空白送货单和打印送货单。 好点打印空白送货单的，就是现在这样子。点打印送货单，打印的就是那个跟有有就是有数据的送货单。作业本送货统计查询，状态查询需要修改逻辑
---
CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs | 192 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 192 insertions(+), 0 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs
index 0759fca..ddef49d 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs
@@ -97,6 +97,50 @@
delayTime,
new SqlParameter("@Productionprogress",trueModel.Productionprogress),
new SqlParameter("@PrintPackDeliveryRequir",trueModel.PrintPackDeliveryRequir),
+ new SqlParameter("@printunit",trueModel.printunit),
+ new SqlParameter("@Duiyinghetongbianhao",trueModel.Duiyinghetongbianhao),
+
+ new SqlParameter("@ShejiStatus",trueModel.ShejiStatus.HasValue?trueModel.ShejiStatus.Value:0),
+ new SqlParameter("@Shejirenyuan",trueModel.Shejirenyuan.HasValue?trueModel.Shejirenyuan.Value:0),
+ new SqlParameter("@ShejirenyuanName",string.IsNullOrEmpty(trueModel.ShejirenyuanName)?"":trueModel.ShejirenyuanName),
+ new SqlParameter("@Shejileixing",trueModel.Shejileixing.HasValue?trueModel.Shejileixing.Value:0),
+ new SqlParameter("@ShejileixingName",string.IsNullOrEmpty(trueModel.ShejileixingName)?"":trueModel.ShejileixingName),
+ new SqlParameter("@Danshuangmian",string.IsNullOrEmpty(trueModel.Danshuangmian)?"":trueModel.Danshuangmian),
+ new SqlParameter("@Shejirenyuanneiye",trueModel.Shejirenyuanneiye.HasValue?trueModel.Shejirenyuanneiye.Value:0),
+ new SqlParameter("@ShejirenyuanNameneiye",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye)?"":trueModel.ShejirenyuanNameneiye),
+ new SqlParameter("@Shejileixingneiye",trueModel.Shejileixingneiye.HasValue?trueModel.Shejileixingneiye.Value:0),
+ new SqlParameter("@ShejileixingNameneiye",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye)?"":trueModel.ShejileixingNameneiye),
+ new SqlParameter("@Danshuangmianneiye",string.IsNullOrEmpty(trueModel.Danshuangmianneiye)?"":trueModel.Danshuangmianneiye),
+ new SqlParameter("@Shejiyaoqiu",string.IsNullOrEmpty(trueModel.Shejiyaoqiu)?"":trueModel.Shejiyaoqiu),
+ new SqlParameter("@Shejiyaoqiuneiye",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye)?"":trueModel.Shejiyaoqiuneiye),
+ new SqlParameter("@ShejiUnitPrice",trueModel.ShejiUnitPrice.HasValue?trueModel.ShejiUnitPrice.Value:0),
+ new SqlParameter("@ShejiSumPrice",trueModel.ShejiSumPrice.HasValue?trueModel.ShejiSumPrice.Value:0),
+ new SqlParameter("@ShejiUnitPriceneiye",trueModel.ShejiUnitPriceneiye.HasValue?trueModel.ShejiUnitPriceneiye.Value:0),
+ new SqlParameter("@ShejiSumPriceneiye",trueModel.ShejiSumPriceneiye.HasValue?trueModel.ShejiSumPriceneiye.Value:0),
+ new SqlParameter("@Shejicount",trueModel.Shejicount.HasValue?trueModel.Shejicount.Value:0),
+ new SqlParameter("@Shejicountneiye",trueModel.Shejicountneiye.HasValue?trueModel.Shejicountneiye.Value:0),
+ new SqlParameter("@ShejiUnitPriceneiye1",trueModel.ShejiUnitPriceneiye1.HasValue?trueModel.ShejiUnitPriceneiye1.Value:0),
+ new SqlParameter("@ShejiSumPriceneiye1",trueModel.ShejiSumPriceneiye1.HasValue?trueModel.ShejiSumPriceneiye1.Value:0),
+ new SqlParameter("@Shejicountneiye1",trueModel.Shejicountneiye1.HasValue?trueModel.Shejicountneiye1.Value:0),
+ new SqlParameter("@ShejiUnitPriceneiye2",trueModel.ShejiUnitPriceneiye2.HasValue?trueModel.ShejiUnitPriceneiye2.Value:0),
+ new SqlParameter("@ShejiSumPriceneiye2",trueModel.ShejiSumPriceneiye2.HasValue?trueModel.ShejiSumPriceneiye2.Value:0),
+ new SqlParameter("@Shejicountneiye2",trueModel.Shejicountneiye2.HasValue?trueModel.Shejicountneiye2.Value:0),
+
+ new SqlParameter("@Shejirenyuanneiye1",trueModel.Shejirenyuanneiye1.HasValue?trueModel.Shejirenyuanneiye1.Value:0),
+ new SqlParameter("@ShejirenyuanNameneiye1",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye1)?"":trueModel.ShejirenyuanNameneiye1),
+ new SqlParameter("@Shejileixingneiye1",trueModel.Shejileixingneiye1.HasValue?trueModel.Shejileixingneiye1.Value:0),
+ new SqlParameter("@ShejileixingNameneiye1",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye1)?"":trueModel.ShejileixingNameneiye1),
+ new SqlParameter("@Danshuangmianneiye1",string.IsNullOrEmpty(trueModel.Danshuangmianneiye1)?"":trueModel.Danshuangmianneiye1),
+ new SqlParameter("@Shejiyaoqiuneiye1",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye1)?"":trueModel.Shejiyaoqiuneiye1),
+
+
+
+ new SqlParameter("@Shejirenyuanneiye2",trueModel.Shejirenyuanneiye2.HasValue?trueModel.Shejirenyuanneiye2.Value:0),
+ new SqlParameter("@ShejirenyuanNameneiye2",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye2)?"":trueModel.ShejirenyuanNameneiye2),
+ new SqlParameter("@Shejileixingneiye2",trueModel.Shejileixingneiye2.HasValue?trueModel.Shejileixingneiye2.Value:0),
+ new SqlParameter("@ShejileixingNameneiye2",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye2)?"":trueModel.ShejileixingNameneiye2),
+ new SqlParameter("@Danshuangmianneiye2",string.IsNullOrEmpty(trueModel.Danshuangmianneiye2)?"":trueModel.Danshuangmianneiye2),
+ new SqlParameter("@Shejiyaoqiuneiye2",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye2)?"":trueModel.Shejiyaoqiuneiye2),
};
int i = -1;
@@ -158,6 +202,50 @@
new SqlParameter("@NumPerBag",trueModel.NumPerBag),
new SqlParameter("@BagNum",trueModel.BagNum),
new SqlParameter("@PrintPackDeliveryRequir",trueModel.PrintPackDeliveryRequir),
+ new SqlParameter("@printunit",trueModel.printunit),
+ new SqlParameter("@Duiyinghetongbianhao",trueModel.Duiyinghetongbianhao),
+ new SqlParameter("@ShejiStatus",trueModel.ShejiStatus.HasValue?trueModel.ShejiStatus.Value:0),
+ new SqlParameter("@Shejirenyuan",trueModel.Shejirenyuan.HasValue?trueModel.Shejirenyuan.Value:0),
+ new SqlParameter("@ShejirenyuanName",string.IsNullOrEmpty(trueModel.ShejirenyuanName)?"":trueModel.ShejirenyuanName),
+ new SqlParameter("@Shejileixing",trueModel.Shejileixing.HasValue?trueModel.Shejileixing.Value:0),
+ new SqlParameter("@ShejileixingName",string.IsNullOrEmpty(trueModel.ShejileixingName)?"":trueModel.ShejileixingName),
+ new SqlParameter("@Danshuangmian",string.IsNullOrEmpty(trueModel.Danshuangmian)?"":trueModel.Danshuangmian),
+ new SqlParameter("@Shejirenyuanneiye",trueModel.Shejirenyuanneiye.HasValue?trueModel.Shejirenyuanneiye.Value:0),
+ new SqlParameter("@ShejirenyuanNameneiye",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye)?"":trueModel.ShejirenyuanNameneiye),
+ new SqlParameter("@Shejileixingneiye",trueModel.Shejileixingneiye.HasValue?trueModel.Shejileixingneiye.Value:0),
+ new SqlParameter("@ShejileixingNameneiye",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye)?"":trueModel.ShejileixingNameneiye),
+ new SqlParameter("@Danshuangmianneiye",string.IsNullOrEmpty(trueModel.Danshuangmianneiye)?"":trueModel.Danshuangmianneiye),
+ new SqlParameter("@Shejiyaoqiu",string.IsNullOrEmpty(trueModel.Shejiyaoqiu)?"":trueModel.Shejiyaoqiu),
+ new SqlParameter("@Shejiyaoqiuneiye",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye)?"":trueModel.Shejiyaoqiuneiye),
+ new SqlParameter("@ShejiUnitPrice",trueModel.ShejiUnitPrice.HasValue?trueModel.ShejiUnitPrice.Value:0),
+ new SqlParameter("@ShejiSumPrice",trueModel.ShejiSumPrice.HasValue?trueModel.ShejiSumPrice.Value:0),
+ new SqlParameter("@ShejiUnitPriceneiye",trueModel.ShejiUnitPriceneiye.HasValue?trueModel.ShejiUnitPriceneiye.Value:0),
+ new SqlParameter("@ShejiSumPriceneiye",trueModel.ShejiSumPriceneiye.HasValue?trueModel.ShejiSumPriceneiye.Value:0),
+ new SqlParameter("@Shejicount",trueModel.Shejicount.HasValue?trueModel.Shejicount.Value:0),
+ new SqlParameter("@Shejicountneiye",trueModel.Shejicountneiye.HasValue?trueModel.Shejicountneiye.Value:0),
+ new SqlParameter("@ShejiUnitPriceneiye1",trueModel.ShejiUnitPriceneiye1.HasValue?trueModel.ShejiUnitPriceneiye1.Value:0),
+ new SqlParameter("@ShejiSumPriceneiye1",trueModel.ShejiSumPriceneiye1.HasValue?trueModel.ShejiSumPriceneiye1.Value:0),
+ new SqlParameter("@Shejicountneiye1",trueModel.Shejicountneiye1.HasValue?trueModel.Shejicountneiye1.Value:0),
+ new SqlParameter("@ShejiUnitPriceneiye2",trueModel.ShejiUnitPriceneiye2.HasValue?trueModel.ShejiUnitPriceneiye2.Value:0),
+ new SqlParameter("@ShejiSumPriceneiye2",trueModel.ShejiSumPriceneiye2.HasValue?trueModel.ShejiSumPriceneiye2.Value:0),
+ new SqlParameter("@Shejicountneiye2",trueModel.Shejicountneiye2.HasValue?trueModel.Shejicountneiye2.Value:0),
+
+
+ new SqlParameter("@Shejirenyuanneiye1",trueModel.Shejirenyuanneiye1.HasValue?trueModel.Shejirenyuanneiye1.Value:0),
+ new SqlParameter("@ShejirenyuanNameneiye1",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye1)?"":trueModel.ShejirenyuanNameneiye1),
+ new SqlParameter("@Shejileixingneiye1",trueModel.Shejileixingneiye1.HasValue?trueModel.Shejileixingneiye1.Value:0),
+ new SqlParameter("@ShejileixingNameneiye1",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye1)?"":trueModel.ShejileixingNameneiye1),
+ new SqlParameter("@Danshuangmianneiye1",string.IsNullOrEmpty(trueModel.Danshuangmianneiye1)?"":trueModel.Danshuangmianneiye1),
+ new SqlParameter("@Shejiyaoqiuneiye1",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye1)?"":trueModel.Shejiyaoqiuneiye1),
+
+
+
+ new SqlParameter("@Shejirenyuanneiye2",trueModel.Shejirenyuanneiye2.HasValue?trueModel.Shejirenyuanneiye2.Value:0),
+ new SqlParameter("@ShejirenyuanNameneiye2",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye2)?"":trueModel.ShejirenyuanNameneiye2),
+ new SqlParameter("@Shejileixingneiye2",trueModel.Shejileixingneiye2.HasValue?trueModel.Shejileixingneiye2.Value:0),
+ new SqlParameter("@ShejileixingNameneiye2",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye2)?"":trueModel.ShejileixingNameneiye2),
+ new SqlParameter("@Danshuangmianneiye2",string.IsNullOrEmpty(trueModel.Danshuangmianneiye2)?"":trueModel.Danshuangmianneiye2),
+ new SqlParameter("@Shejiyaoqiuneiye2",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye2)?"":trueModel.Shejiyaoqiuneiye2),
};
try
{
@@ -354,9 +442,113 @@
}
}
+
+ /// <summary>
+ /// 鏇存柊璁㈠崟鎵╁睍琛ㄥ墿浣欏嵃鍒锋暟閲�
+ /// </summary>
+ /// <param name="Keyid"></param>
+ /// <param name="SurplusPrintNum"></param>
+ /// <param name="Operator"></param>
+ /// <returns></returns>
+ public bool UpSurplusPrintNumsql(int? Keyid, int? SurplusPrintNum, string Operator)
+ {
+
+ try
+ {
+ var sqlStr = "UPDATE [EC_OrderExtend] SET [SurplusPrintNum]=[PrintNum] WHERE Keyid=@Keyid ";
+ SqlParameter par = new SqlParameter("@Keyid", Keyid);
+ _dataBase.ExecuteSql(sqlStr, par);
+
+ return true;
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
+
+ /// <summary>
+ /// 鏇存柊璁㈠崟鎵╁睍琛ㄥ墿浣欏嵃鍒锋暟閲�
+ /// </summary>
+ /// <param name="Keyid"></param>
+ /// <param name="SurplusPrintNum"></param>
+ /// <param name="Operator"></param>
+ /// <returns></returns>
+ public bool UpShejiStatus(int Keyid, int ShejiStatus, string Operator, int XiadanKeyid)
+ {
+
+ try
+ {
+ var sqlStr = "UPDATE [EC_OrderExtend] SET [ShejiStatus]="+ ShejiStatus + " ,[XiadanKeyid]=" + XiadanKeyid + " WHERE Keyid=@Keyid ";
+ SqlParameter par = new SqlParameter("@Keyid", Keyid);
+ _dataBase.ExecuteSql(sqlStr, par);
+
+ return true;
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
+
+ /// <summary>
+ /// 鏇存柊璁㈠崟鎵╁睍琛ㄥ墿浣欏嵃鍒锋暟閲�
+ /// </summary>
+ /// <param name="Keyid"></param>
+ /// <param name="SurplusPrintNum"></param>
+ /// <param name="Operator"></param>
+ /// <returns></returns>
+ public bool UpShejijiesuanStatus(int Keyid, int ShejiStatus, string Operator)
+ {
+
+ try
+ {
+ var sqlStr = "UPDATE [EC_OrderExtend] SET [shifoujiesuan]=" + ShejiStatus + " WHERE Keyid=@Keyid ";
+ SqlParameter par = new SqlParameter("@Keyid", Keyid);
+ _dataBase.ExecuteSql(sqlStr, par);
+
+ return true;
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
{
throw new NotImplementedException();
}
+
+
+ /// <summary>
+ /// 鏍规嵁缂栧彿鑾峰緱淇℃伅
+ /// </summary>
+ /// <param name="Keyid">缂栧彿</param>
+ /// <returns></returns>
+ public EC_OrderExtend GetModelByKeyid(int keyid)
+ {
+ try
+ {
+ string condition = " ";
+
+ condition = " Keyid=" + keyid + "";
+
+
+ // return null;//閿欒鏁版嵁杩斾細绌�
+
+ IList<EC_OrderExtend> result = _dataBase.SelectModel<EC_OrderExtend>("*", "EC_OrderExtend", condition) as IList<EC_OrderExtend>;//鎵ц鏌ヨ
+
+ return (null == result || result.Count == 0) ? null : result[0];//杩斿洖缁撴灉
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
}
}
--
Gitblit v1.9.1