From 374ce108d737c1e4d6608989090195a7346d10ad Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 26 二月 2026 08:47:21 +0800
Subject: [PATCH] 优化格式美观度。 完成 （1）“印刷、打包、送货要求”放在右边的格子里面；右边格子拉通 （2）“单价”和“总价”的格子比例要调整适中 （3）把“印件名称”放在第一格 （1）操作中增加“问题处理”，进行处理操作 完成 （2）问题反馈除了生成在这个列表中，还要自动推送给对应订单的下单人或者送货安排（发起工作安排）的安排人，显示在他们的“工作提醒”中，处理完了就在列表中变成已完成问题处理，显示“√”，点“√”进去就显示谁处理的、什么时候处理的。 完成 生产施工单中，选“轮转印刷机”的，删除“纸张数量（张）”和“开料规格” 完成
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs | 41 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 40 insertions(+), 1 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs
index e1fd6f9..f9b9415 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs
@@ -67,6 +67,9 @@
new SqlParameter("@OrderNum",trueModel.OrderNum) ,
new SqlParameter("@Bank",string.IsNullOrEmpty(trueModel.Bank)?"":trueModel.Bank) ,
new SqlParameter("@AccountID",string.IsNullOrEmpty(trueModel.AccountID)?"":trueModel.AccountID) ,
+
+ new SqlParameter("@Huming",string.IsNullOrEmpty(trueModel.Huming)?"":trueModel.Huming) ,
+ new SqlParameter("@CreateTime",trueModel.CreateTime),
};
try
{
@@ -126,6 +129,7 @@
new SqlParameter("@OrderNum",trueModel.OrderNum) ,
new SqlParameter("@Bank",string.IsNullOrEmpty(trueModel.Bank)?"":trueModel.Bank) ,
new SqlParameter("@AccountID",string.IsNullOrEmpty(trueModel.AccountID)?"":trueModel.AccountID) ,
+ new SqlParameter("@Huming",string.IsNullOrEmpty(trueModel.Huming)?"":trueModel.Huming) ,
};
try
{
@@ -231,7 +235,7 @@
- return _dataBase.SelectModelPage<Model.OA_Suppliers>(pa, selectTarget, fromSource, "a.OrderNum ");
+ return _dataBase.SelectModelPage<Model.OA_Suppliers>(pa, selectTarget, fromSource, "a.CreateTime desc ");
}
/// <summary>
@@ -249,6 +253,41 @@
/// <summary>
+ /// 杩斿洖table绫诲瀷鐨勬墍鏈夊垪琛�
+ /// </summary>
+ /// <param name="FirmId"></param>
+ /// <returns></returns>
+ public IEnumerable<Model.OA_Suppliers> getSupplierByFirmId(Guid FirmId, string Name)
+ {
+ try
+ {
+ if (FirmId == null || FirmId == Guid.Empty)
+ return null;//閿欒鏁版嵁杩斾細绌�
+
+ string condition = " FirmId='" + FirmId + "' ";
+
+ if (!string.IsNullOrEmpty(Name))
+ {
+ condition += " and [Name]='" + Name + "' ";
+ }
+
+
+ IList<Model.OA_Suppliers> result = _dataBase.SelectModel<Model.OA_Suppliers>("*", "OA_Suppliers", condition) as IList<Model.OA_Suppliers>;//鎵ц鏌ヨ
+
+ return result;//杩斿洖缁撴灉
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+
+ }
+
+
+
+
+
+ /// <summary>
/// 鑾峰彇鍗曚釜渚涘簲鍟�
/// </summary>
/// <param name="Keyid"></param>
--
Gitblit v1.9.1