protected void LinBtnPrint_Click(object sender, EventArgs e)
{
GetPrintMargin();
if (hidtype.Text.ToUpper() == "INVOICE")
{
//Invoice预览是否强制显示抬头
hidInvDraft.Text = "0";
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Invoice_SP", new List <IFields>()
{
dal.CreateIFields().
Append("Option", "CheckInvoiceNo").
Append("inv_seed", hidID.Text)
.Append("inv_IsPrinted", "1")
}).GetList();
if (ds.Tables[0].Rows[0][0].ToString() == "Y")
{
ReportHelper.SetReportDoc(Convert.ToDouble(hidtop.Text), Convert.ToDouble(hidbottom.Text), Convert.ToDouble(hidleft.Text), Convert.ToDouble(hidright.Text), int.Parse(cmbPrintCount.SelectedItem.Value), GetNums("Y"));
Session["Tishi"] = hidID.Text;
lbltishi.Text = "Printed on " + DateTime.Now.ToString("dd/MM/yyyy HH:mm").Replace("-", "/");
ControlBinder.PrintLog(FSecurityHelper.CurrentUserDataGET()[0], FSecurityHelper.CurrentUserDataGET()[12], "OI", hidtype.Text + "(ID:" + hidID.Text + ")", CmbPrint.SelectedItem.Value);
}
else
{
X.Msg.Confirm("Print confirm", "Are you sure to print?", "if (buttonId == 'yes') { CompanyX.PrintConfirm(); }").Show();
}
}
else
{
ReportHelper.SetReportDoc(Convert.ToDouble(hidtop.Text), Convert.ToDouble(hidbottom.Text), Convert.ToDouble(hidleft.Text), Convert.ToDouble(hidright.Text), int.Parse(cmbPrintCount.SelectedItem.Value), GetNums("Y"));
Session["Tishi"] = hidID.Text;
lbltishi.Text = "Printed on " + DateTime.Now.ToString("dd/MM/yyyy HH:mm").Replace("-", "/");
ControlBinder.PrintLog(FSecurityHelper.CurrentUserDataGET()[0], FSecurityHelper.CurrentUserDataGET()[12], "OI", hidtype.Text + "(ID:" + hidID.Text + ")", CmbPrint.SelectedItem.Value);
}
}
public string stationSys; //当前用户所在系统（总站Y或者分站N）
protected void Page_Load(object sender, EventArgs e)
{
this.sys = Request["sys"];
if (sys == "D" || sys == "B" || sys == "T")
{
sys = "O";
}
if (!X.IsAjaxRequest)
{
ControlBinder.CmbBinder(StoreCompany, "CompanyList", sys);
ControlBinder.CmbBinder(storeCountry, "CountryList", sys);
ControlBinder.CmbBinder(storeCurrency, "CurrencysList", sys);
Code.Text = Request["code"];
dep = FSecurityHelper.CurrentUserDataGET()[28].ToUpper();
stationSys = FSecurityHelper.CurrentUserDataGET()[29].ToUpper();
div_bottom.Html = "<p>Status: New location record .</p>";
if (dep == "OP" || dep == "ACCOUNT" || stationSys == "N")
{
DisabledControl();
}
else
{
UseControl();
}
}
ControlBinder.ChkGroupBind(this.tblChkGroup); //绑定CheckBoxGroup ( 2014-10-12 )
}
/// <summary>
/// 绑定ComboBox
/// </summary>
#region ComboBoxBinder() Author ：Micro (2011-09-06)
void ComboBoxBinder()
{
ControlBinder.CmbBinder(StoreAgentLocal, "PPCC", "A");
DataSet dsLocation = GetList("LocationList");
StoreLocation.DataSource = dsLocation;
StoreLocation.DataBind();
DataSet dsUnit = GetList("UnitBinding");
StoreUnit.DataSource = dsUnit;
StoreUnit.DataBind();
DataSet dsGetItem = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_GetItem_SP", new List <IFields> {
dal.CreateIFields()
.Append("Option", "GetItem").Append("STAT", FSecurityHelper.CurrentUserDataGET()[12]).Append("SYS", "A")
}).GetList();
StoreGetItem.DataSource = dsGetItem;
StoreGetItem.DataBind();
DataSet dsKind = GetList("QtyKindBinding");
StoreKind.DataSource = dsKind;
StoreKind.DataBind();
StoreCurrInvoice.DataSource = GetList("CurrencysInvoice");
StoreCurrInvoice.DataBind();
StoreSalesman.DataSource = GetList("SalesList");
StoreSalesman.DataBind();
}
public void BindVoyag(string id)
{
if (id != "")
{
StoreVoyage.RemoveAll();
DataTable dt1 = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "VoyageList").
Append("sys", FSecurityHelper.CurrentUserDataGET()[12]).
Append("STAT", cmbVesselCode.Text)
}).GetTable();
StoreVoyage.DataSource = dt1;
StoreVoyage.DataBind();
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "VoyageByID").
Append("STAT", id)
}).GetTable();
cmbVesselText.SelectedItem.Value = id;
CmbDeparture.setValue(dt.Rows[0][4].ToString());
CmbDest.setValue(dt.Rows[0][5].ToString());
txtDepartDate.Text = dt.Rows[0][2].ToString();
txtArrivalDate.Text = dt.Rows[0][3].ToString();
X.AddScript("$('#txtDepL').val(StoreLocation.getById($('#CmbDeparture').val()).data.text);$('#txtDesL').val(StoreLocation.getById($('#CmbDest').val()).data.text);");
}
}
protected void Page_PreRender(object sender, EventArgs e) //修改Grace，先进入load事件绑定好CheckBoxGroup ( 2014-10-15 )
{
if (!X.IsAjaxRequest)
{
if (!IsPostBack)
{
string userStat = FSecurityHelper.CurrentUserDataGET()[12];
string userApart = FSecurityHelper.CurrentUserDataGET()[28];
station = userStat.ToUpper();
userDept = FSecurityHelper.CurrentUserDataGET()[28].ToUpper();
stationSys = FSecurityHelper.CurrentUserDataGET()[29].ToUpper();
if ((userDept == "OP" || userDept == "ACCOUNT" || stationSys == "N") && userStat.ToUpper() != "CON/HKG")
{
DisabledControl();
}
else
{
UseControl();
}
DataBinder();
}
}
}
void ComList()
{
StoreVoyage.RemoveAll();
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "VoyageList").
Append("sys", FSecurityHelper.CurrentUserDataGET()[12]).
Append("STAT", cmbVesselCode.Text)
}).GetTable();
StoreVoyage.DataSource = dt;
StoreVoyage.DataBind();
if (dt != null && dt.Rows.Count > 0)
{
cmbVesselText.SelectedItem.Value = dt.Rows[0][1].ToString();
CmbDeparture.setValue(BaseCheckCode.locationCheckCode(dt.Rows[0][4].ToString()));
CmbDest.setValue(BaseCheckCode.locationCheckCode(dt.Rows[0][5].ToString()));
txtDepartDate.Text = dt.Rows[0][2].ToString();
txtArrivalDate.Text = dt.Rows[0][3].ToString();
X.AddScript("$('#txtDepL').val(StoreLocation.getById($('#CmbDeparture').val()).data.text);$('#txtDesL').val(StoreLocation.getById($('#CmbDest').val()).data.text);");
}
else
{
CmbDeparture.setValue("");
CmbDest.setValue("");
txtArrivalDate.Text = "";
txtDepartDate.Text = "";
txtDepL.Text = "";
txtDesL.Text = "";
}
}
public void btnCancel_click()
{
if (string.IsNullOrEmpty(txtRowID.Text))
{
X.Msg.Alert("status", " Please choose to delete lines", new JFunction()
{
Fn = "textResult"
}).Show();
}
else
{
bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Report_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "Delete")
.Append("rp_ROWID", txtRowID.Text)
.Append("rp_Modifier", FSecurityHelper.CurrentUserDataGET()[0])
}).Update();
if (b)
{
cmbStat.Text = "";
txtRowID.Text = "";
GridBind("");
RowSelectionModel row = this.GridPanel.GetSelectionModel() as RowSelectionModel;
row.SelectFirstRow();
}
else
{
X.Msg.Alert("status", " Delete failed ", new JFunction()
{
Fn = "textResult"
}).Show();
}
}
}
protected void btnOIToOE_Click(object sender, DirectEventArgs e)
{
string RowData = e.ExtraParams["RowData"];
if (RowData == "[]")
{
X.Msg.Alert("Information", "Please select rows!").Show();
}
else if (cmbSys.Text == "")
{
X.Msg.Alert("Information", "Please select system!").Show();
}
else
{
var RowList = JSON.Deserialize <List <HBLRowData> >(e.ExtraParams["RowData"]);
//string SeedList = "";
for (int i = 0; i < RowList.Count; ++i)
{
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_SysTranshipment_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "IsTransfer")
.Append("HBLSeed", RowList[i].Seed)
}).GetTable();
if (dt == null)
{
X.Msg.Alert("Information", "Sorry,please try later again!").Show();
return;
}
else
{
if (dt.Rows[0][0].ToString() != "0")
{
X.Msg.Alert("Information", "This row is transferred!").Show();
return;
}
}
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_SysTranshipment_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "COPY")
.Append("HBLSeed", RowList[i].Seed)
.Append("User", FSecurityHelper.CurrentUserDataGET()[2])
.Append("stat", FSecurityHelper.CurrentUserDataGET()[12])
.Append("code", FSecurityHelper.CurrentUserDataGET()[4] + "OEBK")
.Append("toSys", cmbSys.Text)
}).GetList();
string newSeed = ds.Tables[0].Rows[0]["cs_toseed"].ToString();
// X.AddScript("window.open('../../OceanExport/OEShipment/List.aspx?MBL=0&Seed=" + newSeed + "','_blank');");
X.AddScript("if(window.parent.winHblList != null && window.parent.winHblList != undefined){window.parent.winHblList.reload();} if(window.parent.$('#ifmContent').attr('src') == '/OceanExport/OEShipmentList/List.aspx'){window.parent.document.getElementById('ifmContent').contentWindow.location.reload();}if(window.parent.top.WinView == null ||window.parent.top.WinView == undefined){if(window.parent.Window10 !=null ||window.parent.Window10 !=undefined){window.parent.Window10.reload();}}else{window.parent.top.WinView.reload();}");
X.AddScript("openwin('../../OceanExport/OEShipment/List.aspx?MBL=0&Seed=" + newSeed + "','openOE');");
}
}
}
private void BindData()
{
Code.Focus(true);
var store = this.GridPanel1.GetStore();
DataFactory dal = new DataFactory();
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Sales_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "List")
.Append("STAT", FSecurityHelper.CurrentUserDataGET()[12])
.Append("dept", userDept)
.Append("SYS", sys)
}).GetTable();
if (dt != null && dt.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(Request["code"]))
{
var list = (from p in dt.AsEnumerable() where p.Field <string>("Code").Equals(Code.Text) select p).AsDataView();
if (list.Count > 0)
{
Code.Text = list[0]["Code"].ToString();
Name.Text = list[0]["Name"].ToString();
chkUSGroup.Checked = list[0]["USGroup"].ToString() == "1" ? true : false;
chkActive.Checked = list[0]["Active"].ToString() == "1" ? true : false;
//chkActive.Checked = list[0]["Active"].ToString().Substring(list[0]["Active"].ToString().Length - 5, 1) == "Y" ? true : false;
hidRowID.Text = list[0]["RowID"].ToString();
Company.setValue(list[0]["Company"].ToString());
string[] statlist = string.IsNullOrEmpty(list[0]["StatList"].ToString()) ? new string[] { } : list[0]["StatList"].ToString().Split(',');
CheckGroupClear();
foreach (string str in statlist)
{
for (int i = 0; i < tblChkGroup.Items.Count(); ++i)
{
if (tblChkGroup.Items[i].Tag.ToString().Trim().ToUpper() == str.Trim().ToUpper())
{
tblChkGroup.Items[i].Checked = true;
break;
}
}
}
}
}
if (Code.Text != "")
{
Code.Disabled = true;
div_bottom.Html = "<p>Status : Edit the record of <span>" + Code.Text + "</span> .</p>";
}
store.DataSource = dt;
store.DataBind();
}
else
{
div_bottom.Html = "<p>Status: New Salesman record .</p>";
}
}
/// <summary>
/// 绑定ComboBox
/// </summary>
#region ComboBoxBinder() Author ：Micro (2011-09-06)
void ComboBoxBinder()
{
//StoreCmb.DataSource = GetList("CompanyList");
//StoreCmb.DataBind();
//StoreCmbName.DataSource = GetList("CompanyListByName");
//StoreCmbName.DataBind();
//StoreCurrLocal.DataSource = GetList("CurrencysListLocal");
//StoreCurrLocal.DataBind();
ControlBinder.CmbBinder(StoreAgentLocal, "PPCC", "A");
DataSet dsLocation = GetList("LocationList");
StoreLocation.DataSource = dsLocation;
StoreLocation.DataBind();
DataSet dsUnit = GetList("UnitBinding");
StoreUnit.DataSource = dsUnit;
StoreUnit.DataBind();
DataSet dsCurrency = GetList("CurrencysList");
StoreCurrency.DataSource = dsCurrency;
StoreCurrency.DataBind();
DataSet dsSales = GetList("SalesList");
StoreSalesman.DataSource = dsSales;
StoreSalesman.DataBind();
//DataSet dsItem = GetList("ItemBinding");
//StoreItem.DataSource = dsItem;
//StoreItem.DataBind();
//l_item.Template.Html = Template.Html;
DataSet dsGetItem = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_GetItem_SP", new List <IFields> {
dal.CreateIFields()
.Append("Option", "GetItem").Append("STAT", FSecurityHelper.CurrentUserDataGET()[12]).Append("SYS", "A")
}).GetList();
StoreGetItem.DataSource = dsGetItem;
StoreGetItem.DataBind();
DataSet dsKind = GetList("QtyKindBinding");
StoreKind.DataSource = dsKind;
StoreKind.DataBind();
StoreCurrInvoice.DataSource = GetList("CurrencysInvoice");
StoreCurrInvoice.DataBind();
//CmbFromRight.Template.Html = Template.Html;
//CmbToRight.Template.Html = Template.Html;
//CmbUnit.Template.Html = Template.Html;
//l_unit.Template.Html = Template.Html;
}
//重新插入数据
public void btnOK_Click(object sender, DirectEventArgs e)
{
//if (FSecurityHelper.CurrentUserDataGET()[8] != "G01")
// return;
//if (FSecurityHelper.CurrentUserDataGET()[29] == "Y" && JSON.Deserialize(e.ExtraParams["IsLockStat"]).ToString() == "1")
if (((FSecurityHelper.CurrentUserDataGET()[29].ToUpper() == "Y" && JSON.Deserialize(e.ExtraParams["IsLockStat"]).ToString() == "1") || (FSecurityHelper.CurrentUserDataGET()[29].ToUpper() == "N" && JSON.Deserialize(e.ExtraParams["CompanyID"]).ToString().ToUpper() != FSecurityHelper.CurrentUserDataGET()[32].ToUpper())) && FSecurityHelper.CurrentUserDataGET()[28].ToUpper() != "IT")
{
//对不起，登录失败！当前分站系统用户已经锁定，无法登录到总站系统，请核对后重新登录！
//Sorry, logon failure! The current station system users have locked and unable to log on to the terminal system, please check log in again!
Ext.Net.X.MessageBox.Alert("Status", "Sorry, the operation failed.", new JFunction {
Handler = "location.reload();"
}).Show();
return;
}
this.ReturnValue = FSecurityHelper.CurrentUserDataSET(new string[] {
FSecurityHelper.CurrentUserDataGET()[0] // 0
, FSecurityHelper.CurrentUserDataGET()[1] // 1
, FSecurityHelper.CurrentUserDataGET()[2] // 2
, FSecurityHelper.CurrentUserDataGET()[3] // 3
, JSON.Deserialize(e.ExtraParams["CompanyID"]).ToString() // 4
, JSON.Deserialize(e.ExtraParams["NameCHS"]).ToString() // 5
, JSON.Deserialize(e.ExtraParams["NAMEENG"]).ToString() // 6
, JSON.Deserialize(e.ExtraParams["District"]).ToString() // 7
, FSecurityHelper.CurrentUserDataGET()[8] // 8
, FSecurityHelper.CurrentUserDataGET()[9] // 9
, FSecurityHelper.CurrentUserDataGET()[10] // 10
, FSecurityHelper.CurrentUserDataGET()[11] // 11
, JSON.Deserialize(e.ExtraParams["Stat"]).ToString() // 12
, FSecurityHelper.CurrentUserDataGET()[13] // 13
, "" //FSecurityHelper.CurrentUserDataGET()[14] // 14
, FSecurityHelper.CurrentUserDataGET()[15] //15
, JSON.Deserialize(e.ExtraParams["Tel"]).ToString() //16
, JSON.Deserialize(e.ExtraParams["Fax"]).ToString() //17
, JSON.Deserialize(e.ExtraParams["Email"]).ToString() //18
, JSON.Deserialize(e.ExtraParams["DIMUnit"]).ToString() //19 ----AE
, JSON.Deserialize(e.ExtraParams["DIMFloat"]).ToString() //20 ----AE
, JSON.Deserialize(e.ExtraParams["AddressCHS"]).ToString() //21
, JSON.Deserialize(e.ExtraParams["AddressENG"]).ToString() //22
, JSON.Deserialize(e.ExtraParams["DIMRate"]).ToString() //23 ----AE
, JSON.Deserialize(e.ExtraParams["AWBArrange"]).ToString() //24 ----AE 用 默认值
, JSON.Deserialize(e.ExtraParams["ChinaMode"]).ToString() //25 是否中国大陆使用
, JSON.Deserialize(e.ExtraParams["ChineseInvoice"]).ToString() //26 Chinese Invoice
, FSecurityHelper.CurrentUserDataGET()[27] //27
, FSecurityHelper.CurrentUserDataGET()[28] //28
, FSecurityHelper.CurrentUserDataGET()[29] //29
, JSON.Deserialize(e.ExtraParams["IsServer"]).ToString() //30
, JSON.Deserialize(e.ExtraParams["IsLockStat"]).ToString() //31
, FSecurityHelper.CurrentUserDataGET()[32] //32
});
FSecurityHelper.SignIn(true, FSecurityHelper.CurrentUserDataGET()[0], 720, false, this.ReturnValue);
}
void ComList(ComboBox combox)
{
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "VoyageList").
Append("sys", FSecurityHelper.CurrentUserDataGET()[12]).
Append("STAT", combox.Text)
}).GetTable();
if (combox.ID == "cmbpreVessel")
{
StorePreVoyage.RemoveAll();
StorePreVoyage.DataSource = dt;
StorePreVoyage.DataBind();
if (dt != null && dt.Rows.Count > 0)
{
cmbpreVoyage.SelectedItem.Value = dt.Rows[0][1].ToString();
txtpreonboard.Text = dt.Rows[0][9].ToString();
}
else
{
txtpreonboard.Text = "";
}
}
else
{
StoreVoyage.RemoveAll();
StoreVoyage.DataSource = dt;
StoreVoyage.DataBind();
if (dt != null && dt.Rows.Count > 0)
{
cmbVesselText.SelectedItem.Value = dt.Rows[0][1].ToString();
txtCFSClosing.Text = dt.Rows[0][7].ToString();
txtCYClosing.Text = dt.Rows[0][8].ToString();
txtOnBoard.Text = dt.Rows[0][9].ToString();
txtETD.Text = dt.Rows[0][2].ToString();
txtETADischarge.Text = dt.Rows[0][3].ToString();
cmbLoading.setValue(BaseCheckCode.locationCheckCode(dt.Rows[0][4].ToString()));
cmbPort.setValue(BaseCheckCode.locationCheckCode(dt.Rows[0][5].ToString()));
cmbFinalDest.setValue(BaseCheckCode.locationCheckCode(dt.Rows[0][5].ToString()));
}
else
{
txtCFSClosing.Text = "";
txtCYClosing.Text = "";
txtOnBoard.Text = "";
txtETD.Text = "";
txtETADischarge.Text = "";
cmbLoading.setValue("");
cmbPort.setValue("");
cmbFinalDest.setValue("");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string email = FSecurityHelper.CurrentUserDataGET()[3];
if (string.IsNullOrEmpty(email))
{
btnPdf.Disabled = true;
}
}
protected void btnInvDraft_Click(object sender, EventArgs e)
{
GetPrintMargin();
hidInvDraft.Text = "1";
ReportHelper.SetReportDoc(Convert.ToDouble(hidtop.Text), Convert.ToDouble(hidbottom.Text), Convert.ToDouble(hidleft.Text), Convert.ToDouble(hidright.Text), int.Parse(cmbPrintCount.SelectedItem.Value), GetNums("Y"));
Session["Tishi"] = hidID.Text;
lbltishi.Text = "Printed on " + DateTime.Now.ToString("dd/MM/yyyy HH:mm").Replace("-", "/");
ControlBinder.PrintLog(FSecurityHelper.CurrentUserDataGET()[0], FSecurityHelper.CurrentUserDataGET()[12], hidsys.Text, hidtype.Text + "(ID:" + hidID.Text + ")", CmbPrint.SelectedItem.Value);
}
protected void btnSave_Click(object sender, DirectEventArgs e)
{
DataFactory dal = new DataFactory();
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_ComplexCost_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "Update")
.Append("cxh_ROWID", hidID.Text)
.Append("cxh_Company", cmbShipperCode.Value)
.Append("cxh_Date", ControlBinder.getDate(txtDate.RawText.StartsWith("0001")?DBNull.Value:(object)txtDate.RawText))
.Append("cxh_Amount", string.IsNullOrEmpty(txtAmount.Text)?DBNull.Value:(object)txtAmount.Text)
.Append("cxh_InvoiceNo", txtInv.Text.Trim().ToUpper())
.Append("cxh_User", FSecurityHelper.CurrentUserDataGET()[0])
.Append("stat", FSecurityHelper.CurrentUserDataGET()[12])
}).GetList();
hidHeadSeed.Text = ds.Tables[0].Rows[0][0].ToString();
var CostList = JSON.Deserialize <List <Cost> >(e.ExtraParams["gridList"]);
string RowID = "";
List <IFields> listCosting = new List <IFields>();
for (int i = 0; i < CostList.Count; ++i)
{
listCosting.Add(dal.CreateIFields().Append("Option", "UpdateDetail").
Append("cxd_Seed", hidHeadSeed.Text).
Append("cxd_LotSeed", CostList[i].cxd_LotSeed).
Append("cxd_Sys", CostList[i].cxd_Sys).
Append("cxd_LotNo", CostList[i].cxd_LotNo.Trim().ToUpper()).
Append("cxd_Master", CostList[i].cxd_Master.Trim().ToUpper()).
Append("cxd_House", CostList[i].cxd_House.Trim().ToUpper())
.Append("cxd_ROWID", CostList[i].cxd_ROWID)
.Append("cxd_User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
.Append("stat", FSecurityHelper.CurrentUserDataGET()[12])
);
RowID += "," + CostList[i].cxd_ROWID;
}
if (RowID.Length > 1)
{
RowID = RowID.Substring(1, RowID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_ComplexCost_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "DeleteDetail").Append("cxd_Seed", hidHeadSeed.Text).Append("str", RowID)
}).Update();
bool resultCost = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_ComplexCost_SP", listCosting).Update();
if (hidID.Text == "0")
{
//this.parent.winCombineCostDetail.close();
X.AddScript("this.parent.window.loadCost();this.parent.winCombineCostDetail.close();");
}
else
{
DataBinder();
}
}
/// <summary>
/// 查询数据绑定
/// </summary>
void DataBinder()
{
int voy_vessel = -1;
try
{
voy_vessel = Convert.ToInt32(cmbVessel.SelectedItem.Value);
}
catch
{
cmbVessel.Value = "";
cmbVessel.Text = "";
}
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanImport_Voyage_SP", new List <IFields>()
{
dal.CreateIFields().
Append("Option", "list").
Append("voy_Stat", FSecurityHelper.CurrentUserDataGET()[12]).
Append("voy_Vessel", voy_vessel)
}).GetList();
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
txtVoyageID.Text = "0";
//labCarrierCode.Text = "";
txtVoyage.Text = "";
txtCFS.RawText = "";
txtCY.RawText = "";
txtETA.RawText = "";
txtETD.RawText = "";
txtOnboard.RawText = "";
cmbPOD.setValue("");
cmbPOL.setValue("");
gridVoyageRoute.GetStore().RemoveAll();
}
if (ds != null && ds.Tables[1].Rows.Count > 0)
{
labCarrierCode.Text = ds.Tables[1].Rows[0]["Carrier"].ToString();
}
storeVoyage.DataSource = ds;
storeVoyage.DataBind();
if ((string.IsNullOrEmpty(Request["vessel"]) && Request["vesselID"] == null) && refresh)
{
RowSelectionModel sm = gridVoyage.GetSelectionModel() as RowSelectionModel;
sm.SelectRow(0);
sm.SelectedRows.Add(new SelectedRow(0));
}
else if (Request["vesselID"] != null && cmbVessel.SelectedItem.Value != Request["vesselID"].ToString() && refresh)
{
RowSelectionModel sm = gridVoyage.GetSelectionModel() as RowSelectionModel;
sm.SelectRow(0);
sm.SelectedRows.Add(new SelectedRow(0));
}
}
public void btnSave_Click()
{
if (string.IsNullOrEmpty(txtId.Text))
{
txtId.Text = "";
txtId.Focus();
return;
}
bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_FW_Company_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "Update")
.Append("RowID", txtRowID.Text)
.Append("CompanyID", txtId.Text.ToUpper())
.Append("District", txtDistrict.Text)
.Append("Creator", FSecurityHelper.CurrentUserDataGET()[0])
.Append("Modifier", FSecurityHelper.CurrentUserDataGET()[0])
.Append("IsDelete", chkActive.Checked?"N":"Y")
.Append("Tel", txtTel.Text)
.Append("Fax", txtFax.Text)
.Append("Email", txtEmail.Text)
.Append("DIMUnit", txtDimensionUnit.Text == "" || txtDimensionUnit.Text == null?"M":txtDimensionUnit.Text)
.Append("DIMFloat", txtDimensionFloat.Text == "" || txtDimensionFloat.Text == null?"3":txtDimensionFloat.Text)
.Append("AddressCHS", txtAddressLocal.Text.ToUpper())
.Append("AddressENG", txtAddressEn.Text.ToUpper())
.Append("DIMRate", txtDimensionRate.Text == "" || txtDimensionRate.Text == null?"6000":txtDimensionRate.Text)
.Append("AWBArrange", txtArrangedText.Text == "" || txtArrangedText.Text == null?"AS ARRANGED":txtArrangedText.Text)
.Append("Stat", txtCode.Text.ToUpper())
.Append("NameCHS", txtNameLocal.Text.ToUpper())
.Append("NAMEENG", txtNameEn.Text.ToUpper())
.Append("ChinaMode", chkChinaMode.Checked?1:0)
.Append("ChineseInvoice", chkChinaInvoice.Checked?1:0)
.Append("comSign", conSign.Checked?1:0)
.Append("shipSign", shipSign.Checked?1:0)
.Append("FCurrency", FCurrency.Text.Trim().ToUpper())
.Append("LCurrency", LCurrency.Text.Trim().ToUpper())
}).Update();
if (b)
{
DataTable getMax = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_FW_Company_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "GetMax")
}).GetTable();
if (getMax != null && getMax.Rows.Count > 0 && txtRowID.Text == "")
{
txtRowID.Text = getMax.Rows[0][0].ToString().Trim();
}
}
else
{
X.Msg.Alert("status", " Save failed ").Show();
}
GridBind();
}
void DataBinder()
{
DataFactory dal = new DataFactory();
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ServiceMode_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "List")
.Append("sm_STAT", FSecurityHelper.CurrentUserDataGET()[12])
.Append("dept", userDept)
}).GetList();
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (!string.IsNullOrEmpty(Request["Code"]))
{
var list = (from p in ds.Tables[0].AsEnumerable() where p.Field <string>("sm_CODE").Equals(txtCode.Text) select p).AsDataView();
if (list.Count > 0)
{
txtCode.Text = list[0][1].ToString();
CmbCalc.Text = list[0][3].ToString();
CmbGroup.Text = list[0][6].ToString();
txtLine.Text = list[0][4].ToString();
txtDes.Text = list[0][2].ToString();
txtRowID.Text = list[0][0].ToString();
ChbActive.Checked = Convert.ToBoolean(list[0][5].ToString());
string[] statlist = string.IsNullOrEmpty(list[0]["StatList"].ToString()) ? new string[] { } : list[0]["StatList"].ToString().Split(',');
CheckGroupClear();
foreach (string str in statlist)
{
for (int i = 0; i < tblChkGroup.Items.Count(); ++i)
{
if (tblChkGroup.Items[i].Tag.ToString().Trim().ToUpper() == str.Trim().ToUpper())
{
tblChkGroup.Items[i].Checked = true;
break;
}
}
}
}
}
if (txtCode.Text != "")
{
div_bottom.Html = "<p class=''>Status : Edit the record of <span>" + txtCode.Text + "</span>.</p>";
txtCode.Disabled = true;
}
GridPanel1.GetStore().DataSource = ds;
GridPanel1.GetStore().DataBind();
}
else
{
div_bottom.Html = "<p class=''>Status: New Service Mode record .</p>";
}
}
public void addSave()
{
bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Report_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "Update")
.Append("rp_RowID", txtRowID.Text)
.Append("rp_Stat", cmbStat.Text.ToUpper())
.Append("rp_Sys", cmbSys.Text.ToUpper())
.Append("rp_ReportCode", txtReport.Text.ToUpper())
.Append("rp_ReportName", txtName.Text.ToUpper())
.Append("rp_Title", txtTitle.Text)
.Append("rp_ReportHeader", txtRptHeader.Text)
.Append("rp_ReportFooter", txtRptFooter.Text)
.Append("rp_PageHeader", txtPageHeader.Text)
.Append("rp_PageFooter", txtPageFooter.Text)
.Append("rp_CompanyNameEn", txtCompanyEN.Text)
.Append("rp_CompanyNameCN", txtCompanyLocal.Text)
.Append("rp_CompanyAddressEn", txtAddressEN.Text)
.Append("rp_CompanyAddressCN", txtAddressLocal.Text)
.Append("rp_CompanyTelFax", txtTelFax.Text)
.Append("rp_MarginTop", txtTop.Text == "" || txtTop.Text == null?null:txtTop.Text)
.Append("rp_MarginBottom", txtBottom.Text == "" || txtBottom.Text == null?null:txtBottom.Text)
.Append("rp_MarginLeft", txtLeft.Text == "" || txtLeft.Text == null?null:txtLeft.Text)
.Append("rp_MarginRight", txtRight.Text == "" || txtRight.Text == null?null:txtRight.Text)
.Append("rp_Creator", FSecurityHelper.CurrentUserDataGET()[0])
.Append("rp_UseCompanyNameEN", chkCompnayEN.Checked?1:0)
.Append("rp_UseCompanyNameCN", chkCompanyLocal.Checked?1:0)
.Append("rp_UseCompanyAddressEN", chkAddressEN.Checked?1:0)
.Append("rp_UseCompanyAddressCN", chkAddressLocal.Checked?1:0)
.Append("rp_UseCompanyTelFax", chkTelFax.Checked?1:0)
.Append("rp_Modifier", FSecurityHelper.CurrentUserDataGET()[0])
}).Update();
if (b)
{
DataTable getMax = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Report_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "GetMax")
}).GetTable();
if (getMax != null && getMax.Rows.Count > 0 && txtRowID.Text == "")
{
txtRowID.Text = getMax.Rows[0][0].ToString().Trim();
}
GridBind(cmbStat.Text);
}
else
{
X.Msg.Alert("status", " Save failed ", new JFunction()
{
Fn = "textResult"
}).Show();
}
txtReport.Focus();
}
private string[] GetNums(string flag)
{
string[] nums = null;
if (hidtype.Text == "Invoice")
{
if (hidsys.Text == "AT")
{
nums = new string[7];
//nums[0] = Server.MapPath("~/Report/TRReportFile/" + hidtype.Text + "A.rpt");
nums[0] = Server.MapPath("~/Report/CommonReportFile/A" + hidtype.Text + ".rpt");
nums[1] = flag;
nums[2] = CmbPrint.SelectedItem.Value;
nums[3] = hidID.Text;
nums[4] = "A_Invoice";
nums[5] = FSecurityHelper.CurrentUserDataGET()[12].ToUpper();
nums[6] = hidInvDraft.Text;
}
else if (hidsys.Text == "OT")
{
nums = new string[7];
//nums[0] = Server.MapPath("~/Report/TRReportFile/" + hidtype.Text + "O.rpt");
nums[0] = Server.MapPath("~/Report/CommonReportFile/O" + hidtype.Text + ".rpt");
nums[1] = flag;
nums[2] = CmbPrint.SelectedItem.Value;
nums[3] = hidID.Text;
nums[4] = "O_Invoice";
nums[5] = FSecurityHelper.CurrentUserDataGET()[12].ToUpper();
nums[6] = hidInvDraft.Text;
}
}
else if (hidtype.Text == "PaymentRequest")
{
nums = new string[9];
nums[0] = Server.MapPath("~/Report/CommonReportFile/" + hidtype.Text + ".rpt");
nums[1] = flag;
nums[2] = CmbPrint.SelectedItem.Value;
nums[3] = hidID.Text;
nums[4] = FSecurityHelper.CurrentUserDataGET()[12].ToString();
nums[5] = hidsys.Text;
nums[6] = FSecurityHelper.CurrentUserDataGET()[0].ToString();
nums[7] = Request["Company"].ToString();
nums[8] = Request["Currency"].ToString();
}
else if (hidtype.Text == "ProfitLoss")
{
nums = new string[7];
nums[0] = Server.MapPath("~/Report/CommonReportFile/ProfitAndLoss.rpt");
nums[1] = flag;
nums[2] = CmbPrint.SelectedItem.Value;
nums[3] = hidID.Text;
nums[4] = FSecurityHelper.CurrentUserDataGET()[12].ToString();
nums[5] = hidsys.Text;
nums[6] = FSecurityHelper.CurrentUserDataGET()[0].ToString();
}
return(nums);
}
public void StoreItem_OnRefreshData(object sender, StoreRefreshDataEventArgs e)
{
DataSet dsGetItem = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_GetItem_SP", new List <IFields> {
dal.CreateIFields()
.Append("Option", "GetItem").Append("STAT", FSecurityHelper.CurrentUserDataGET()[12]).Append("SYS", "A")
}).GetList();
StoreGetItem.DataSource = dsGetItem;
StoreGetItem.DataBind();
}
public DataSet GetHander()
{
return(dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AllSystem_Reference_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "Header")
.Append("Stat", FSecurityHelper.CurrentUserDataGET()[12])
.Append("SYS", hidsys.Text)
}).GetList());
}
public void btnInvDraft_Click()
{
GetPrintMargin();
hidInvDraft.Text = "1";
ReportHelper.SetReportDoc(Convert.ToDouble(hidtop.Text), Convert.ToDouble(hidbottom.Text), Convert.ToDouble(hidleft.Text), Convert.ToDouble(hidright.Text), int.Parse(cmbPrintCount1.Text), GetNums("Y"));
Session["Tishi"] = hidID.Text;
lbltishi.Text = "Printed on " + DateTime.Now.ToString("dd/MM/yyyy HH:mm").Replace("-", "/");
ControlBinder.PrintLog(FSecurityHelper.CurrentUserDataGET()[0], FSecurityHelper.CurrentUserDataGET()[12], "OE", hidtype.Text + "(ID:" + hidID.Text + ")", CmbPrint1.Text);
X.AddScript("$('#btnInvDraft').removeAttr('disabled')");
}
public void btnSave_Click()
{
if (CheckNullOrEmpty(txtUser))
{
return;
}
if (CheckNullOrEmpty(txtPwd))
{
return;
}
if (txtPwdAgain.Text.Trim() != txtPwd.Text.Trim())
{
txtPwdAgain.Text = "";
txtPwdAgain.Focus();
return;
}
bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_USER_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "UpdateUser")
.Append("UserName", txtUser.Text)
.Append("RowID", txtRowID.Text)
.Append("UserPWD", PageHelper.MD5(txtPwd.Text.Trim()))
.Append("NameCHS", txtNameLocal.Text)
.Append("NameENG", txtNameEn.Text)
.Append("CompanyID", cmbCompany.SelectedItem.Text == ""?null:cmbCompany.SelectedItem.Text)
.Append("Email", txtEmail.Text)
.Append("IsActivation", chkActive.Checked?"Y":"N")
.Append("Remark", txtRemark.Text)
.Append("Tel", txtTel.Text)
.Append("STAT", CmbStat.SelectedItem.Text)
.Append("Fax", txtFax.Text)
.Append("Modifier", FSecurityHelper.CurrentUserDataGET()[0])
.Append("Creator", FSecurityHelper.CurrentUserDataGET()[0])
}).Update();
if (b)
{
DataTable getMax = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_USER_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "GetMax")
}).GetTable();
if (getMax != null && getMax.Rows.Count > 0 && txtRowID.Text == "")
{
txtRowID.Text = getMax.Rows[0][0].ToString().Trim();
}
GridBind("");
}
else
{
X.Msg.Alert("status", " Save failed ").Show();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
txtRate.Text = FSecurityHelper.CurrentUserDataGET()[23];
//txtRate.Number = Convert.ToDouble(FSecurityHelper.CurrentUserDataGET()[23]);
hidSeed.Text = Request["seed"] == null ? "" : Request["seed"];
DataBindList();
txtRate.Focus(true);
}
}
private void ComboBoxBinding()
{
DataSet dsSalesman = GetComboxDs("SalesList");
DataSet dsLocation = GetComboxDs("LocationList");
DataSet dsUnit = GetComboxDs("UnitBinding");
DataSet dsItem = GetComboxDs("ItemBinding");
DataSet dsKind = GetComboxDs("QtyKindBinding");
DataSet dsCurrencysList = GetComboxDs("CurrencysInvoice");
DataSet dsCurrencysListForeign = GetComboxDs("CurrencysInvoiceForeign");
DataSet dsShowIn = GetComboxDs("GetShowIn");
DataSet dsGetItem = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_GetItem_SP", new List <IFields> {
dal.CreateIFields()
.Append("Option", "GetItem").Append("STAT", FSecurityHelper.CurrentUserDataGET()[12]).Append("SYS", "A")
}).GetList();
StoreGetItem.DataSource = dsGetItem;
StoreGetItem.DataBind();
StoreSalesman.DataSource = dsSalesman;
StoreSalesman.DataBind();
StoreCurrInvoice.DataSource = dsCurrencysList;
StoreCurrInvoice.DataBind();
StoreCurrInvoiceForeign.DataSource = dsCurrencysListForeign;
StoreCurrInvoiceForeign.DataBind();
StoreLocation.DataSource = dsLocation;
StoreLocation.DataBind();
StoreUnit.DataSource = dsUnit;
StoreUnit.DataBind();
StoreKind.DataSource = dsKind;
StoreKind.DataBind();
ControlBinder.CmbBinder(StoreAgentLocal, "PPCC", "A");
DataSet dsCur = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_CoLoaderIn_SP", new List <IFields> {
dal.CreateIFields()
.Append("Option", "GetCurrency").Append("air_STAT", FSecurityHelper.CurrentUserDataGET()[12])
}).GetList();
StoreCurrForeign.DataSource = dsCur.Tables[0];
StoreCurrForeign.DataBind();
StoreCurrLocal.DataSource = dsCur.Tables[1];
StoreCurrLocal.DataBind();
StoreShowIn.DataSource = dsShowIn;
StoreShowIn.DataBind();
}
void DataBinder(string id)
{
if (id.Length > 0)
{
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_CallShipmentForOE_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "GetDetailList")
.Append("ChinaMode", FSecurityHelper.CurrentUserDataGET()[25])
.Append("id", id).Append("sys", "OE")
.Append("stat", FSecurityHelper.CurrentUserDataGET()[12])
.Append("ShowVoid", hidShowVoid.Text)
}
).GetList();
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
if (hidShowInv.Text == "0")
{
ds.Tables[0].DefaultView.RowFilter = "oe_Type<>'LINV' and oe_Type<>'CTNR' and oe_Type<>'FINV'";
}
else
{
ds.Tables[0].DefaultView.RowFilter = "oe_Type<>'CTNR'";
}
dt1 = ds.Tables[0].DefaultView.ToTable();
dt2 = ds.Tables[1].DefaultView.ToTable();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
txtLotNo.InnerHtml = "<font color='red'>" + ds.Tables[0].Rows[0]["oe_lotno"].ToString() + "</font>";
txtMawb.InnerHtml = "<font color='red'>" + ds.Tables[0].Rows[0]["oe_mbl"].ToString() + "</font>";
labTransfer.InnerHtml = ds.Tables[0].Rows[0]["Exported"].ToString();
}
string[] header = { "Status", "Date", "Type", "No.#", "POL/POD", "WT/Piece", "Amount", "Remark", "Action", "<div class='div_all_print'>Print</div>" };
string[] field = { "void", "oe_date", "oe_Type", "oe_KeyValue", "oe_POL", "WT", "oe_Currency|oe_Total", "remark", "Detail", "Print" };
string msg = "No data";
string[] header_ctnr = { "", "Status / S.Mode / Main", "Container No / S.No", "WT", "CBM", "PCS", "Remark", "Print" };
string[] field_r_ctnr_ = { "isvoid", "oe_serMode", "oe_KeyValue", "GWT", "CBM", "PIECE", "remark", "Print" };
string msg_ctnr = "No data";
txtcontent.InnerHtml = ControlBinder.gridHtml(dt1, header, field, msg);
txtcontainer.InnerHtml = ControlBinder.gridHtml(dt2, header_ctnr, field_r_ctnr_, msg_ctnr);
}
}
public void JobDataBinding()
{
//DataFactory dal = new DataFactory();
//DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AllSystem_Reference_SP", new List<IFields>() {
// dal.CreateIFields()
// .Append("Option", "DataBinder")
// .Append("Stat",FSecurityHelper.CurrentUserDataGET()[12])
// .Append("SYS",hidsys.Text)
// .Append("Shipper",cmbShipperCode.Value)
// .Append("Consignee",cmbConsigneeCode.Value)
// .Append("DateFrom",ControlBinder.getDate(txtETDFrom.RawText.StartsWith("0001")?DBNull.Value:(object)txtETDFrom.RawText))
// .Append("DateTo",ControlBinder.getDate(txtETDTo.RawText.StartsWith("0001")?DBNull.Value:(object)txtETDTo.RawText))
// .Append("Dest",cmbDest.Value)
// .Append("Sales",cmbSalesman.Value)
// .Append("JobNo",txtJobNo.Text.Trim())
// .Append("Master",txtMBL.Text)
// .Append("House",txtHBL.Text)
// .Append("Vessel",txtVessel.Text.Trim())
// .Append("Voyage",txtVoyage.Text.Trim())
// .Append("Container",txtContainer.Text.Trim())
// .Append("Coloader",CmbColoader.Value)
//}).GetList();
string[] nums = new string[18] {
"Option", "Stat", "SYS", "Shipper", "Consignee", "DateFrom", "DateTo", "Dest", "Sales", "JobNo", "Master", "House", "Vessel", "Voyage", "Container", "Coloader", "active", "VerifyNo"
};
object[] values = new object[18];
values[0] = "GetJobData"; // DataBinder
values[1] = FSecurityHelper.CurrentUserDataGET()[12];
values[2] = hidsys.Text;
values[3] = cmbShipperCode.Value;
values[4] = cmbConsigneeCode.Value;
values[5] = ControlBinder.getDate(txtETDFrom.RawText.StartsWith("0001")?DBNull.Value:(object)txtETDFrom.RawText);
values[6] = ControlBinder.getDate(txtETDTo.RawText.StartsWith("0001")?DBNull.Value:(object)txtETDTo.RawText);
values[7] = cmbDest.Value == null?"":cmbDest.Value;
values[8] = cmbSalesman.Value == null?"":cmbSalesman.Value;
values[9] = txtJobNo.Text.Trim();
values[10] = txtMBL.Text.Trim();
values[11] = txtHBL.Text.Trim();
values[12] = txtVessel.Text.Trim();
values[13] = txtVoyage.Text.Trim();
values[14] = txtContainer.Text.Trim();
values[15] = CmbColoader.Value;
values[16] = chkVoid.Checked ? 0 : 1;
values[17] = txtVerifyNo.Text.Trim();
//txtMBL.Text = DateTime.Now.ToString("HH:mm:ss.fff");
DataSet ds = PageHelper.GetDs("FW_AllSystem_Reference_SP", nums, values);
//txtHBL.Text = DateTime.Now.ToString("HH:mm:ss.fff");
gridReference.GetStore().DataSource = ds;
gridReference.GetStore().DataBind();
}
public string GetMenuList(string key)
{
string strContent = string.Empty;
string strContent1 = string.Empty;
string str = string.Empty;
string div = string.Empty;
var linq = GetMenu().Tables[0].AsEnumerable().Count(p => p.Field<string>("MenuID") == "MBD");
if (linq == 1)
{
var list3 = (from lq in GetMenu().Tables[1].AsEnumerable() where lq.Field<string>("ParentID") == "MBD" && (lq.Field<string>("Remark") == "" || lq.Field<string>("Remark").Contains(string.IsNullOrEmpty(key) ? "NULL" : key)) select lq).ToList();
if (list3.Count > 0)
{
str += "<div id='div_content' style='position:absolute;top:40px;right:8px;z-index:99'><table border='0'>\r\n<tr algin='center'>\r\n";
div = "<div id='div' align='left' class='menu_bg_01' style= 'display:none;position:absolute;right:-5px; z-index:99 '><table border='0' align='center'>";
foreach (DataRow row in list3)
{
string dep = FSecurityHelper.CurrentUserDataGET()[28];
if (!(dep.ToUpper() == "IT" || dep.ToUpper() == "ADMIN") && (row["NameENG"].ToString().ToUpper() == "LOCATION" || row["NameENG"].ToString().ToUpper() == "USER"))
{ continue; }
if (!Convert.ToBoolean(FSecurityHelper.CurrentUserDataGET()[25]) && row["NameENG"].ToString() == "核 销 单")
{
continue;
}
if (row["flag"].ToString() == "1")
{
if (row["NameENG"].ToString().ToUpper() == "COMBINE COST")
{
str += @"<td align='center'><span class='menu_btn_02' align='center'>" + "<a href=\"javascript:void(0)\" onclick='CompanyX.UserControlTop1.ShowLink(\"" + row["NameENG"] + "\",\"" + row["Hyperlink"] + "?sys=" + sys + "\")'>" + row["NameENG"] + "</a></span></td>\r\n";
}
else if (row["NameENG"].ToString() == "核 销 单")
{
str += @"<td align='center'><span class='menu_btn' align='center'>" + "<a style='font-family:微软雅黑; font-size: 10px !important;' href=\"javascript:void(0)\" onclick='CompanyX.UserControlTop1.ShowLink(\"" + row["NameENG"] + "\",\"" + row["Hyperlink"] + "?sys=" + sys + "\")'>" + row["NameENG"] + "</a></span></td>\r\n";
}
else
{
str += @"<td align='center'><span class='menu_btn' align='center'>" + "<a href=\"javascript:void(0)\" onclick='CompanyX.UserControlTop1.ShowLink(\"" + row["NameENG"] + "\",\"" + row["Hyperlink"] + "?sys=" + sys + "\")'>" + row["NameENG"] + "</a></span></td>\r\n";
}
}
else
{
div += @"<tr><td><span class='menu_btn_02' align='center'>" + "<a href=\"javascript:void(0)\" onclick='CompanyX.UserControlTop1.ShowLink(\"" + row["NameENG"] + "\",\"" + row["Hyperlink"] + "?sys=" + sys + "\")'>" + row["NameENG"] + "</a></span></td></tr>";
}
}
div += "</table></div>";
str += "\r\n<td> <div id='outer' style='position:absolute;top:2px; z-index:99;text-align:right;'><img src='/images/menu/down_01.png' id='img' style='width:18px;'/>" + div + "</div></td></tr>\r\n</table></div>";
}
}
return str;
}
private void ComboBoxBinding()
{
DataSet dsLocation = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().
Append("Option", "LocationList").
Append("STAT", FSecurityHelper.CurrentUserDataGET()[12]).
Append("SYS", sys[0])
}).GetList();
StoreLocation.DataSource = dsLocation;
StoreLocation.DataBind();
}
