目的: V20201A-排程資料匯入 1> checkbox:互斥 [v]已發工 [ ]未發工 2> 新增CaluField
處理說明: 1> checkbox:互斥
[v]已發工 [ ]未發工
[v]已發工 [ ]未發工
Ext.getCmp("sub_chk_AMMSTS1").on('change', function (me, newValue, oldValue, eOpts) {
if (newValue==true) {
Ext.getCmp("sub_chk_AMMSTS2").setValue(false);
}
}
); // end of cmp_chk_AMMSTS.items[0].on("change"
if (newValue==true) {
Ext.getCmp("sub_chk_AMMSTS2").setValue(false);
}
}
); // end of cmp_chk_AMMSTS.items[0].on("change"
2> CaluField : 發工人員姓名(SAPMAN_)
ds.Tables["T1"].Columns.Add("CREMPLYID_", typeof(object)); //管制人員姓名
int Tmp_cnt1 = ds.Tables["T1"].Rows.Count;
for (int i = 0; i < Tmp_cnt1; i++)
{
DataRow dr1 = ds.Tables["T1"].Rows[i];
Tmp_TYPEAF = dr1["TYPEAF"].ToString();
1>*.js
var cmp_sub_chk_AMMSTS1 = get_cmp_chk1('已發工', 'sub_chk_AMMSTS1', 80, "false", "0 10 0 50");
var cmp_sub_chk_AMMSTS2 = get_cmp_chk1('未發工', 'sub_chk_AMMSTS2', 80, "false", "0 10 0 50");
// [V]已發工[]未未工 : 互斥 true / false 控制
Ext.getCmp("sub_chk_AMMSTS1").on('change', function (me, newValue, oldValue, eOpts) {
if (newValue==true) {
Ext.getCmp("sub_chk_AMMSTS2").setValue(false);
}
}
); // end of cmp_chk_AMMSTS.items[0].on("change"
Ext.getCmp("sub_chk_AMMSTS2").on('change', function (me, newValue, oldValue, eOpts) {
if (newValue==true) {
Ext.getCmp("sub_chk_AMMSTS1").setValue(false);
}
}
); // end of cmp_chk_AMMSTS.items[0].on("change"
Ext.getCmp("sub_chk_AMMSTS1").on('change', function (me, newValue, oldValue, eOpts) {
if (newValue==true) {
Ext.getCmp("sub_chk_AMMSTS2").setValue(false);
}
}
); // end of cmp_chk_AMMSTS.items[0].on("change"
Ext.getCmp("sub_chk_AMMSTS2").on('change', function (me, newValue, oldValue, eOpts) {
if (newValue==true) {
Ext.getCmp("sub_chk_AMMSTS1").setValue(false);
}
}
); // end of cmp_chk_AMMSTS.items[0].on("change"
2>*.cs
ds.Tables["T1"].Columns.Add("PROJDT_", typeof(object)); //約別 TYPEAF_
ds.Tables["T1"].Columns.Add("CREMPLYID_", typeof(object)); //管制人員姓名 ds.Tables["T1"].Columns.Add("SAPMAN_", typeof(object)); //發工人員姓名
string Tmp_CREMPLYID_, Tmp_SAPMAN_;
int Tmp_cnt1 = ds.Tables["T1"].Rows.Count;
for (int i = 0; i < Tmp_cnt1; i++)
{
DataRow dr1 = ds.Tables["T1"].Rows[i];
Tmp_TYPEAF = dr1["TYPEAF"].ToString();
Tmp_CREMPLYID = dr1["CREMPLYID"].ToString();
Tmp_SAPMAN = dr1["SAPMAN"].ToString();
Tmp_Sql = " SELECT EMPLYNM "
+ " FROM HR_EMPLYM "
+ " WHERE EMPLYID=" + myfunc.AA(Tmp_CREMPLYID);
Tmp_CREMPLYID_ = myfunc.SqlValue(Tmp_Sql);
Tmp_Sql = " SELECT EMPLYNM "
+ " FROM HR_EMPLYM "
+ " WHERE EMPLYID=" + myfunc.AA(Tmp_SAPMAN);
Tmp_SAPMAN_ = myfunc.SqlValue(Tmp_Sql);
//case when B.TYPEAF=3 then B.CRNRAF
//when B.TYPEAF = 4 then B.CMNRAF end 'PROJDT'
if (Tmp_TYPEAF=="3")
{
Tmp_PROJDT_= ds.Tables["T1"].Rows[i]["CRNRAF"].ToString();
}
if (Tmp_TYPEAF == "3")
{
Tmp_PROJDT_ = ds.Tables["T1"].Rows[i]["CMNRAF"].ToString();
}
dr1["PROJDT_"] = Tmp_PROJDT_;
dr1["CREMPLYID_"] = Tmp_CREMPLYID_;
dr1["SAPMAN_"] = Tmp_SAPMAN_;
}
