目的: V120401 - 日期區間 – 過濾條件 – 2021/08/02 ~ 2021/08/02
處理說明: 1>前端 : 日期區間 – 2021/08/02 ~ 2021/08/02
--> 應該要包含 日期: 2021/08/02
--> 應該要包含 日期: 2021/08/02
2>後端: AND MKDT>='2021/08/02'
AND MKDT<'2021/08/03
3>後端: 日期+1
DateTime.Parse(nvc["s_MKDT2"]).AddDays(1));
1>*.js
//建檔日期
var cmp_MKDT = get_cmp_dt1('建檔日期', 's_MKDT1', 80, 100);
var cmp_MKDT_lbl = get_cmp_lbl0(" ~ ", 20);
var cmp_MKDT2 = get_cmp_dt0('s_MKDT2', 100);
cmp_MKDT.items.push(cmp_MKDT_lbl, cmp_MKDT2);
var Query = new Ext.FormPanel({
id: 's_form',
height:120,
layout: { type: 'hbox', align: 'stretch' },
fieldDefaults: { labelAlign: 'right' },
defaults: { margin: { top: 3 } },
items: [
{
xtype: 'panel', id: 'panel1', layout: { type: 'hbox', align: 'stretch' }, flex: 14, border: 0,
items: [
{
xtype: 'panel', id: 'panel11', layout: { type: 'vbox', align: 'stretch' }, flex: 25, border: 0,
items: [cmp_TMNOXX, cmp_DOCNO, cmp_TMNO],
}, // end of panel11
{
xtype: 'panel', id: 'panel12', layout: { type: 'vbox', align: 'stretch' }, flex: 30, border: 0,
items: [cmp_VOL, cmp_STLCT, cmp_MKDT],
}, // end of panel12 , flex:16
2>*.cs
//建檔日期 - 起 - 迄
string Tmp_MKDT1 = ""; //建檔日期 - 起迄
string Tmp_MKDT2 = ""; //建檔日期 - 起迄
if (!myfunc.checkisnull(nvc["s_MKDT1"]))
{
Tmp_MKDT1 = string.Format("{0:yyyy/MM/dd}", DateTime.Parse(nvc["s_MKDT1"]));
};
if (!myfunc.checkisnull(nvc["s_MKDT2"]))
{
Tmp_MKDT2 = string.Format("{0:yyyy/MM/dd}", DateTime.Parse(nvc["s_MKDT2"]).AddDays(1));
};
string Tmp_Sql1 = "";
if ((!myfunc.checkisnull(Tmp_MKDT1)) || (!myfunc.checkisnull(Tmp_MKDT2)))
{
if (!myfunc.checkisnull(Tmp_MKDT1))
{
Tmp_Sql1 = Tmp_Sql1 + " AND MKDT>=" + myfunc.AA(Tmp_MKDT1);
};
if (!myfunc.checkisnull(Tmp_MKDT2))
{
Tmp_Sql1 = Tmp_Sql1 + " AND MKDT<" + myfunc.AA(Tmp_MKDT2);
}
Tmp_Sql = Tmp_Sql + Tmp_Sql1;
};
