protected override void New_WSC_DLL_Form_Load(object sender, EventArgs e)
{
base.New_WSC_DLL_Form_Load(sender, e);
panel_IKnow.Size = new Size(844, 639);
panel_IKnow.Location = new Point(61, 38);
//取得此表單的LoaderFormInfo
fFormInfo = XSC.ClientLoader.FormInfo(this);
//透過LoginUserId取得sqlClientAccess
sca = XSC.ClientAccess.UserAccess.sqlUserAccess(fFormInfo.LoginUserId);
#region 帳號權限判斷
Boolean IsCorrectUser = false, IsPXWMS_N = false, IsPXWMS_S = false, IsPXWMS_C = false;
//取得工號
string cmdstring = "Select EMPID From XSC_Menu_Userlist where XSC_UserID=@userid";
object[] objParam = { "@userid", SqlDbType.NVarChar.ToString(), fFormInfo.LoginUserId };
DataTable dt_87 = sca.GetDataTable("EEPDC", cmdstring, objParam, 0);
if (dt_87.Rows.Count > 0)
{
IsCorrectUser = true;
UserWorkNum = dt_87.Rows[0][0].ToString();
}
if (UserWorkNum != "")
{
//取得兩倉權限
//觀音
cmdstring = "select top 1 0 from employee_data where S_empd_id=@userid";
object[] objParam1 = { "@userid", SqlDbType.NVarChar.ToString(), UserWorkNum };
DataTable dt_PXWMS_N = sca.GetDataTable("PXWMS_N", cmdstring, objParam1, 0);
if (dt_PXWMS_N.Rows.Count > 0)
{
IsPXWMS_N = true;
}
//岡山
DataTable dt_PXWMS_S = sca.GetDataTable("PXWMS_S", cmdstring, objParam1, 0);
if (dt_PXWMS_S.Rows.Count > 0)
{
IsPXWMS_S = true;
}
//梧棲
DataTable dt_PXWMS_C = sca.GetDataTable("PXWMS_C_Plus2", cmdstring, objParam1, 0);
if (dt_PXWMS_C.Rows.Count > 0)
{
IsPXWMS_C = true;
}
}
if (IsPXWMS_N == false && IsPXWMS_S == false && IsPXWMS_C == false)
{
IsCorrectUser = false;
}
#endregion
if (!IsCorrectUser)
{
MessageBox.Show("帳號無法對應三倉權限，請洽資訊部人員", ":<");
SetMasterBindingNavigator(null);
SetButtonEnable("L");
return;
}
txb_ItemNo.Text = txb_Merdid.Text;
SetMasterBindingNavigator(BS_Repl);
SetButtonEnable("FL");
if (IsPXWMS_N)
{
comboBox1.Items.Add(new Item("觀音", "PXWMS_N"));
}
if (IsPXWMS_S)
{
comboBox1.Items.Add(new Item("岡山", "PXWMS_S"));
}
if (IsPXWMS_C)
{
comboBox1.Items.Add(new Item("梧棲", "PXWMS_C_Plus2"));
}
comboBox1.Items.Add(new Item("測試", "PXWMS_200"));
comboBox1.SelectedIndex = 0;
cB_SFCkind.Items.Add(new Item("SFCXX01", "SFC%01"));
cB_SFCkind.Items.Add(new Item("SFCXX02", "SFC%02"));
cB_SFCkind.Items.Add(new Item("出貨暫存", "%%"));
cB_SFCkind.Items.Add(new Item("任意儲位", "%%"));
cB_SFCkind.SelectedIndex = 0;
ResizeForm.ResizeForm.WSC_Resize(this, 1);
gridControl1.DataSource = BS_Repl;
DevExpressGridFunctions.GridviewSetup(gridView1);
DevExpressGridFunctions.GridviewSetup(gridView2);
}
protected override void New_WSC_DLL_Form_Load(object sender, EventArgs e)
{
base.New_WSC_DLL_Form_Load(sender, e);
//批次的解說文
toolTip1.SetToolTip(txb_SupdId, "輸入完供應商代號, 按下Tab");
cmb_BatchID.SelectedIndex = 0;
//取得此表單的LoaderFormInfo
fFormInfo = XSC.ClientLoader.FormInfo(this);
//透過LoginUserId取得sqlClientAccess
sca = XSC.ClientAccess.UserAccess.sqlUserAccess(fFormInfo.LoginUserId);
#region 帳號權限判斷
Boolean IsCorrectUser = false;
bool IsPXWMS_N = false, IsPXWMS_S = false, IsPXWMS_C = false;
//取得工號
string cmdstring = "Select EMPID From XSC_Menu_Userlist where XSC_UserID=@userid";
object[] objParam = { "@userid", SqlDbType.NVarChar.ToString(), fFormInfo.LoginUserId };
DataTable dt_87 = sca.GetDataTable("EEPDC", cmdstring, objParam, 0);
if (dt_87.Rows.Count > 0)
{
IsCorrectUser = true;
UserWorkNum = dt_87.Rows[0][0].ToString();
}
if (UserWorkNum != "")
{
//取得兩倉權限
//觀音
cmdstring = "select top 1 0 from employee_data where S_empd_id=@userid";
object[] objParam1 = { "@userid", SqlDbType.NVarChar.ToString(), UserWorkNum };
DataTable dt_PXWMS_N = sca.GetDataTable("PXWMS_N", cmdstring, objParam1, 0);
if (dt_PXWMS_N.Rows.Count > 0)
{
IsPXWMS_N = true;
}
//岡山
DataTable dt_PXWMS_S = sca.GetDataTable("PXWMS_S", cmdstring, objParam1, 0);
if (dt_PXWMS_S.Rows.Count > 0)
{
IsPXWMS_S = true;
}
//梧棲
DataTable dt_PXWMS_C = sca.GetDataTable("PXWMS_C_Plus2", cmdstring, objParam1, 0);
if (dt_PXWMS_C.Rows.Count > 0)
{
IsPXWMS_C = true;
}
}
if (IsPXWMS_N == false && IsPXWMS_S == false && IsPXWMS_C == false)
{
IsCorrectUser = false;
}
#endregion
if (!IsCorrectUser)
{
MessageBox.Show("帳號無法對應三倉權限，請洽資訊部人員", ":<");
SetMasterBindingNavigator(null);
SetButtonEnable("L");
return;
}
#region 設定新刪修會用到的物件
List <object> Enable_objlist = new List <object>();
Enable_objlist.Add(gridControl1);
this.MasterObj = Enable_objlist;
#endregion
SetMasterBindingNavigator(BS_Repl);
SetButtonEnable("FL EX help");
#region 限對應三倉
bindingNavigatorEditButton.Text = "重新產生資料(&E)";
if (IsPXWMS_N)
{
cmb_SiteNo.Items.Add(new Item("觀音", "PXWMS_N"));
}
if (IsPXWMS_S)
{
cmb_SiteNo.Items.Add(new Item("岡山", "PXWMS_S"));
}
if (IsPXWMS_C)
{
cmb_SiteNo.Items.Add(new Item("梧棲", "PXWMS_C_Plus2"));
}
cmb_SiteNo.SelectedIndex = 0;
#endregion
ResizeForm.ResizeForm.WSC_Resize(this, 1);
//gridControl1.DataSource = BS_Repl;
dateTimePicker1.Value = DateTime.Now.AddDays(3);
DevExpressGridFunctions.GridviewSetup(gridView1);
DevExpressGridFunctions.GridviewSetup(gridView2);
DevExpressGridFunctions.GridviewSetup(gridView3);
btn_Close_panel1.ForeColor = Color.White;
btn_Close_panel1.BackColor = Color.Red;
Lbl_UserId.Text = fFormInfo.LoginUserId;
Lbl_WorkNum.Text = UserWorkNum;
Lbl_Version.Text = "版本：" + FileVersionInfo.GetVersionInfo(Assembly.GetExecutingAssembly().Location).FileVersion.ToString();
#region 獲取廠商清單
DataTable dt_VendorList = GetSupdId();
foreach (DataRow dr in dt_VendorList.Rows)
{
cmb_VendorNo.Items.Add(new Item(dr["NewAlias"].ToString(), dr["NewAlias"].ToString()));
}
#endregion
}
