目的: V120202 – [全部選取] [全部取消] – 允許分頁選取保留 -checkbox
處理說明: 1>[全部選取]鈕
1>將目前 store.CHECK 欄位均設為 true
1>將目前 store.CHECK 欄位均設為 true
2>cbxAry : 將所有的 PK(APNO) 存入 cbxAry
1>*. js
//全部選取 , 將所有資料 PK 加入 cbxArr
function SelAllBtn_click() {
var Tmp_PKStr = ""; //所有資料 PK 字串, 以 , 分隔
var Tmp_url = "../../api/V120202API/getALLPKStr";
var np = grid.store.getProxy().extraParams;
var rtn = getUrlStr(Tmp_url, np, "全部選取鈕");
if (checkRtnOK(rtn)) {
set_PgAll();
var Tmp_PKStr = rtn;
setCbxArr(Tmp_PKStr);
} // end of SelAllBtn_click
//全部取消 , 將所有資料 PK 加入 cbxArr
function unSelAllBtn_click() {
var Tmp_PKStr = ""; //所有資料 PK 字串, 以 , 分隔
var Tmp_url = "../../api/V120202API/getALLPKStr";
var np = grid.store.getProxy().extraParams;
var rtn = getUrlStr(Tmp_url, np, "全部取消鈕");
if (checkRtnOK(rtn)) {
//set_AllUn();
set_PgUn();
resetCbxArr();
} // end of chkRtnOk(rtn)
} // end of unSelAllBtn_click
2>*.cs
//取所有資料.PKStr , 並以 , 分隔
[HttpPost]
public dynamic getALLPKStr()
{
var c = HttpContext.Current;
NameValueCollection nvc = c.Request.Form;
//DataSet ds = getGridDataPage();
//return ds;
string Tmp_LCAA = nvc["s_LCAA"];
string Tmp_ASN = nvc["s_ASN"];
string Tmp_MATNR = nvc["s_MATNR"];
string Tmp_APNO = nvc["s_APNO"];
string Tmp_APER = nvc["s_APER"];
string Tmp_APDT1 = ""; //申請日期 - 起迄
string Tmp_APDT2 = ""; //申請日期 - 起迄
if (!myfunc.checkisnull(nvc["s_APDT1"]))
{
Tmp_APDT1 = string.Format("{0:yyyy/MM/dd}", DateTime.Parse(nvc["s_APDT1"]));
};
if (!myfunc.checkisnull(nvc["s_APDT2"]))
{
Tmp_APDT2 = string.Format("{0:yyyy/MM/dd}", DateTime.Parse(nvc["s_APDT2"]));
};
//單況(A/B/C/D/Z)
string Tmp_STAT = nvc["s_STAT"];
OracleCommand cmd = new OracleCommand();
string Tmp_Sql = " SELECT RNK, "
+ " APNO,LCAA,ASN,SAPNO,PN,MATNR,RPN,QTY,UNIT,"
+ " APER,APDT,STAT,MPKUPP,MPKUPDT,COMPER,COMPDT,DELTP,DELTDT "
+ " FROM ( "
+ " select dense_rank() over(order by APNO) as RNK,"
+ " APNO,LCAA,ASN,SAPNO,PN,MATNR,RPN,QTY,UNIT, "
+ " APER,APDT,STAT,MPKUPP,MPKUPDT,COMPER,COMPDT,DELTP,DELTDT "
+ " FROM AMM_COMQ "
+ " Where 1=1 ";
//機位
if (!myfunc.checkisnull(Tmp_LCAA))
{
Tmp_Sql = Tmp_Sql + " AND LCAA = " + myfunc.AA(Tmp_LCAA);
};
//機號
if (!myfunc.checkisnull(Tmp_ASN))
{
Tmp_Sql = Tmp_Sql + " AND ASN= " + myfunc.AA(Tmp_ASN);
};
//物料編號
if (!myfunc.checkisnull(Tmp_MATNR))
{
Tmp_Sql = Tmp_Sql + " AND ( (MATNR LIKE " + myfunc.AA("%" + Tmp_MATNR + "%") + ")"
+ " OR (MATNR IN ( SELECT SPN "
+ " FROM AMM_SPN "
+ " WHERE PN LIKE " + myfunc.AA("%" + Tmp_MATNR + "%")
+ " AND STATUS='A' ) )"
+ ")";
};
//申請單號
if (!myfunc.checkisnull(Tmp_APNO))
{
Tmp_Sql = Tmp_Sql + " AND APNO = " + myfunc.AA(Tmp_APNO);
};
//申請人
if (!myfunc.checkisnull(Tmp_APER))
{
Tmp_Sql = Tmp_Sql + " AND APER= " + myfunc.AA(Tmp_APER);
};
string Tmp_Sql1 = "";
//申請日期 - 起 - 迄
if ((!myfunc.checkisnull(Tmp_APDT1)) || (!myfunc.checkisnull(Tmp_APDT2)))
{
if (!myfunc.checkisnull(Tmp_APDT1))
{
Tmp_Sql1 = Tmp_Sql1 + " AND APDT>=" + myfunc.AA(Tmp_APDT1);
};
if (!myfunc.checkisnull(Tmp_APDT2))
{
Tmp_Sql1 = Tmp_Sql1 + " AND APDT<=" + myfunc.AA(Tmp_APDT2);
}
Tmp_Sql = Tmp_Sql + Tmp_Sql1;
};
//單況 : 待撥料/撿料中/撿料完成/已領用/已撤銷(A/B/C/D/Z) 全部: ALL - radioboxgroup
if (!myfunc.checkisnull(Tmp_STAT))
{
switch (Tmp_STAT)
{
case "ALL": //全部
Tmp_Sql = Tmp_Sql;
break;
default:
Tmp_Sql = Tmp_Sql + " AND STAT=" + myfunc.AA(Tmp_STAT);
break;
}
};
Tmp_Sql = Tmp_Sql + " ) ";
cmd.CommandText = Tmp_Sql;
string countSql = " SELECT COUNT(*) as total FROM (" + Tmp_Sql + ")";
//匯出時 ,取全部資料, par_paging =false , 取全部資料
DataSet ds = getDataTable(cmd, countSql, false);
int Tmp_Cnt = ds.Tables["T1"].Rows.Count;
var Tmp_PKStr = "";
for (var i=0; i<Tmp_Cnt;i++)
{
DataRow dr = ds.Tables["T1"].Rows[i];
Tmp_APNO = dr["APNO"].ToString();
Tmp_PKStr = Tmp_PKStr + Tmp_APNO + ",";
}
if (Tmp_PKStr != "")
{
Tmp_PKStr = Tmp_PKStr.TrimEnd(',');
}
return Tmp_PKStr;
}
