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(); }