From f8eaad3fa2ffcae47ff149cd7a826c8983a69b00 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期四, 31 十二月 2020 17:33:55 +0800
Subject: [PATCH] color 更改
---
src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs | 52 +++++++++++++++-----------
src/BLL/Demo.Report/PRD/prd_ExtractionPlanDetail.cs | 22 ++++++++--
2 files changed, 47 insertions(+), 27 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs b/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs
index 06bd552..106122c 100644
--- a/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs
+++ b/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs
@@ -23,6 +23,7 @@
if (this.View.OpenParameter.GetCustomParameter("FHMainICMOInterID") == null)
{
SearchList();
+ ChangeColor();
}
else
{
@@ -55,35 +56,35 @@
this.Model.SetValue("FOwnerId", dt.Rows[i]["FOwnerId"], i);//璐т富
}
}
- did = true;
+
+ ChangeColor();
+ did = true;
}
}
- public override void AfterBindData(EventArgs e)
- {
- base.AfterBindData(e);
- //鑾峰彇鍗曟嵁浣撲俊鎭�
- //Entity entity = this.View.BillBusinessInfo.GetEntity("FEntity");
- ////鍗曟嵁浣撲俊鎭浆鎹负鍒楄〃闆嗗悎
- //DynamicObjectCollection entityDataObjoct = this.View.Model.GetEntityDataObject(entity);
- //EntryGrid grid = this.View.GetControl<EntryGrid>("FEntity");
- //int i = 0;
- //foreach (DynamicObject current in entityDataObjoct)
- //{
- // if (Convert.ToString(current["FCompleteDetailStatus"]) == "鏈綈濂�")
- // {
- // grid.SetBackcolor("FEntity", "#FF0000", i);
- // }
- // i++;
- //}
- //this.View.UpdateView();
- }
+ private void ChangeColor() {
+ Entity entity = this.View.BillBusinessInfo.GetEntity("FEntity");
+ //鍗曟嵁浣撲俊鎭浆鎹负鍒楄〃闆嗗悎
+ DynamicObjectCollection entityDataObjoct = this.View.Model.GetEntityDataObject(entity);
+ EntryGrid grid = this.View.GetControl<EntryGrid>("FEntity");
+ int _i = 0;
+ foreach (DynamicObject current in entityDataObjoct)
+ {
+ if (Convert.ToString(current["FCompleteDetailStatus"]) == "鏈綈濂�")
+ {
+ grid.SetRowBackcolor("#FF0000", _i);
+ }
+ _i++;
+ }
+ }
+
public override void BarItemClick(BarItemClickEventArgs e)
{
base.BarItemClick(e);
if (e.BarItemKey.ToUpper() == "TBFILTER")
{
SearchList();
+ ChangeColor();
}
}
/// <summary>
@@ -137,7 +138,13 @@
sql += sqlwhere;
sql += "order by FPlanDate, FHStockQty desc ,FHMaterID";
DataTable dt = DBServiceHelper.ExecuteDataSet(this.Context, sql).Tables[0];
- this.Model.DeleteEntryData("FEntity");
+ //this.Model.DeleteEntryData("FEntity");
+ while (this.Model.GetEntryRowCount("FEntity") > 0)
+ {
+ this.Model.DeleteEntryRow("FEntity", 0);
+ }
+ //this.View.Refresh();
+
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
@@ -159,7 +166,8 @@
this.Model.SetValue("FOwnerId", dt.Rows[i]["FOwnerId"], i);//璐т富
}
}
- this.View.UpdateView();
+
+ //this.View.UpdateView();
did = true;
}
}
diff --git a/src/BLL/Demo.Report/PRD/prd_ExtractionPlanDetail.cs b/src/BLL/Demo.Report/PRD/prd_ExtractionPlanDetail.cs
index c22efe3..c0f1621 100644
--- a/src/BLL/Demo.Report/PRD/prd_ExtractionPlanDetail.cs
+++ b/src/BLL/Demo.Report/PRD/prd_ExtractionPlanDetail.cs
@@ -23,6 +23,7 @@
/// </summary>
public class prd_ExtractionPlanDetail : SysReportBaseService
{
+ string date = "";
//鍒濆鍖�
public override void Initialize()
{
@@ -108,17 +109,27 @@
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
- ReportHeader headerch = new ReportHeader();
header.AddChild("FRogNUMBER", new LocaleValue("渚涘簲鍟嗕俊鎭�&閲囪喘缁勭粐", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
header.AddChild("FNAME", new LocaleValue("渚涘簲鍟嗕俊鎭�&渚涘簲鍟�", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
- header.AddChild("FNUMBER", new LocaleValue("渚涘簲鍟嗕俊鎭�&鐗╂枡", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
- DataSet ds = DBServiceHelper.ExecuteDataSet(Context, "/*dialect*/select distinct convert(nvarchar(50),FHDATE,111) FHDATE from Cg_PODemandPlanBillMain ");
+
+ header.AddChild("FNUMBER", new LocaleValue("鐗╂枡淇℃伅&鐗╂枡", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
+ header.AddChild("FMATERIALNAME", new LocaleValue("鐗╂枡淇℃伅&鐗╂枡鍚嶇О", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
+ header.AddChild("FSPECIFICATION", new LocaleValue("鐗╂枡淇℃伅&鐗╂枡瑙勬牸", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
+ header.AddChild("FBASEUNIT", new LocaleValue("鐗╂枡淇℃伅&鍗曚綅", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
+ header.AddChild("FPROUNIT", new LocaleValue("鐗╂枡淇℃伅&璁￠噺鍗曚綅", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
+ header.AddChild("FQTY", new LocaleValue("鐗╂枡淇℃伅&搴撳瓨鏁伴噺", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
+ header.AddChild("FTRANSITQTY", new LocaleValue("鐗╂枡淇℃伅&鍦ㄩ�旀暟閲�", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
+
+ //header.AddChild("FNUMBER", new LocaleValue("鎷栨湡鏄庣粏&鎷栨湡鏁伴噺", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
+
+ //header.AddChild("FNUMBER", new LocaleValue("璁″垝鏄庣粏&鍚堣", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
+ DataSet ds = DBServiceHelper.ExecuteDataSet(Context, "/*dialect*/select distinct convert(nvarchar(50),FHDATE,111) FHDATE from Cg_PODemandPlanBillMain");
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
- header.AddChild(dr[0].ToString(), new LocaleValue("鏃ユ湡&" + dr[0].ToString() + "", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
+ header.AddChild(dr[0].ToString(), new LocaleValue("璁″垝鏄庣粏&" + dr[0].ToString() + "", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
}
}
return header;
@@ -149,6 +160,7 @@
string startValue = (customFilter["FBeginConveyDate"] == null) ? string.Empty : Convert.ToDateTime(customFilter["FBeginConveyDate"]).ToString("yyyy/MM/d");
string endValue = (customFilter["FEndConveyDate"] == null) ? string.Empty : Convert.ToDateTime(customFilter["FEndConveyDate"]).ToString("yyyy/MM/d");
strwhere.AppendLine(string.Format(" AND FHDate>=''{0}'' and FHDate<=''{1}'' ", startValue, endValue));
+ date = string.Format(" FHDate>=''{0}'' and FHDate<=''{1}'' ", startValue, endValue);
//鐗╂枡
var baseDataNameValue = customFilter["FMATERIALID"];
string MaterailName = baseDataNameValue == null
@@ -161,7 +173,7 @@
//渚涘簲鍟�
var baseSuppName = customFilter["FSUPPLIERID"];
string SuppName = baseSuppName == null
- ? " " : string.Format(" AND a.FSUPPLIERID IN ({0}) ", (customFilter["FSUPPLIERID"] as DynamicObject)["Id"].ToString());
+ ? " " : string.Format(" AND a.FSUPPLIERID IN ({0}) ", (customFilter["FSUPPLIERID"] as DynamicObject)["Id"].ToString());
strwhere.AppendLine(SuppName);
string text2 = string.IsNullOrWhiteSpace(filter.FilterParameter.FilterString) ? " " : " AND " + filter.FilterParameter.FilterString.Replace("{ts", "").Replace("}", "");
strwhere.AppendLine(text2);
--
Gitblit v1.9.1