public ICommandResult <TOutput> Execute <TInput, TOutput>(ISerialization <TInput> input, ISerialization <TOutput> output, TInput data) { var either = CommandResult <TOutput> .Check <Argument <TInput>, TInput>(input, output, data, CreateExampleArgument); if (either.Error != null) { return(either.Error); } try { var table = PopulateTable(input, output, Locator, DomainModel, either.Argument, Permissions); if (either.Argument.UseDataTable) { return(CommandResult <TOutput> .Return(HttpStatusCode.Created, output.Serialize(table), "Data analyzed")); } var result = ConvertTable.Convert(output, table); return(CommandResult <TOutput> .Return(HttpStatusCode.Created, result, "Data analyzed")); } catch (SecurityException ex) { return(CommandResult <TOutput> .Return(HttpStatusCode.Forbidden, default(TOutput), ex.Message)); } catch (ArgumentException ex) { return(CommandResult <TOutput> .Fail( ex.Message, ex.GetDetailedExplanation() + @" Example argument: " + CommandResult <TOutput> .ConvertToString(CreateExampleArgument(output)))); } }
void ImportData(List <SettingItem> list) { if (list == null || list.Count == 0) { return; } ExcelData data = null; for (int i = 0; i < list.Count; i++) { data = ConvertTable.GetTableData(list[i]); ConvertToAsset(list[i], data); //Type type = Type.GetType("Item_" + data.tableName); //var config = ScriptableObject.CreateInstance(type); //config. } }
public void ShowDataInGrid() { DataTable dt; dt = new DataTable(); switch (drpMastertable.SelectedItem.ToString()) { case "Brand Master": Brand_Masters Brand_Masters = new Brand_Masters(); IList <Brand_Master> ilistbrandMaster = Brand_Masters.GetBrand_Masters(txtCode.Text, txtName.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Brand_Master>(ilistbrandMaster); bindBrandMaster(dt); // grdMasterTable.DataSource = Brand_Masters.GetBrand_Masters(txtCode.Text, txtName.Text, drpSelectCompany.SelectedItem.Text); //grdMasterTable.DataBind(); txtCode.Visible = true; txtName.Visible = true; lblName.Visible = true; lblCode.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "Cancellation Reason Code": Cancellation_Reason_Codes Cancellation_Reason_Codes = new Cancellation_Reason_Codes(); //DataTable dt = new DataTable(); IList <Cancellation_Reason_Code> ilistCancelReasonCode = Cancellation_Reason_Codes.GetCancellation_Reason_Codes(txtCode.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Cancellation_Reason_Code>(ilistCancelReasonCode); bindCancellationReasonCode(dt); txtCode.Visible = true; lblCode.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "Customer Master": Customers Customer = new Customers(); IList <Customer> ilistCustomer = Customer.GetCustomers(txtName.Text, txtCity.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Customer>(ilistCustomer); bindCustomerMaster(dt); txtName.Visible = true; txtCity.Visible = true; lblName.Visible = true; lblCity.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "Detention Setup": Detention_Setups DetentionSetup = new Detention_Setups(); IList <Detention_Setup> ilistDetentionSetup = DetentionSetup.GetDetention_Setups(drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Detention_Setup>(ilistDetentionSetup); bindDetentionSetup(dt); break; case "In-Transit Duration": Transit_Durations Transit_Duration = new Transit_Durations(); IList <Transit_Duration> ilistTransitDuration = Transit_Duration.GetTransit_Durations(drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Transit_Duration>(ilistTransitDuration); bindInTransitDuration(dt); break; case "Item Master": Items item = new Items(); IList <Item> ilistItem = item.GetItems(drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Item>(ilistItem); bindItemMaster(dt); break; case "Location Master": Locations location = new Locations(); IList <Location> ilistLocation = location.GetLocations(txtName.Text, txtCode.Text, txtCity.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Location>(ilistLocation); txtName.Visible = true; txtCode.Visible = true; txtCity.Visible = true; lblCity.Visible = true; lblCode.Visible = true; lblName.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "Payment Discount Scheme": Payment_Discount_Schemes paymentDiscountScheme = new Payment_Discount_Schemes(); IList <Payment_Discount_Scheme> ilistPaymentDisScheme = paymentDiscountScheme.GetPayment_Discount_Schemes(txtCode.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Payment_Discount_Scheme>(ilistPaymentDisScheme); bindPaymentDiscountScheme(dt); txtCode.Visible = true; lblCode.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "Penalty Reason Code": Penalty_Reason_Codes penaltyReasonCode = new Penalty_Reason_Codes(); IList <Penalty_Reason_Code> ilistPenaltyreasonCode = penaltyReasonCode.GetPenalty_Reason_Codes(txtCode.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Penalty_Reason_Code>(ilistPenaltyreasonCode); bindPaneltyReasonCode(dt); txtCode.Visible = true; lblCode.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "Placement Setup": Placement_Setups placement = new Placement_Setups(); IList <Placement_Setup> ilistPlacementSetup = placement.GetPlacement_Setups(drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Placement_Setup>(ilistPlacementSetup); bindPlacementSetup(dt); break; case "Rejection Reason Code": Rejection_Reason_Codes rejectionReasonCode = new Rejection_Reason_Codes(); IList <Rejection_Reason_Code> ilistRejectionReasonCode = rejectionReasonCode.GetRejection_Reason_Codes(txtCode.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Rejection_Reason_Code>(ilistRejectionReasonCode); bindRejectionReasonCode(dt); txtCode.Visible = true; lblCode.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "Freight Master": Shipping_Agent_Purch_PriceINs shippingAgent = new Shipping_Agent_Purch_PriceINs(); IList <Shipping_Agent_Purch_PriceIN> ilistShipping_Agent_Purch_PriceIN = shippingAgent.GetShipping_Agent_Purch_PriceINs(drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Shipping_Agent_Purch_PriceIN>(ilistShipping_Agent_Purch_PriceIN); bindFreightMaster(dt); break; case "SKU Master": SKU_Masters skuMaster = new SKU_Masters(); IList <SKU_Master> ilistSKU_Master = skuMaster.GetSKU_Masters(txtName.Text, txtCode.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <SKU_Master>(ilistSKU_Master); bindSKUMaster(dt); txtCode.Visible = true; txtName.Visible = true; lblCode.Visible = true; lblName.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "Transit Loss Charges": Transit_Loss_Chargess transitLossCharge = new Transit_Loss_Chargess(); IList <Transit_Loss_Charges> ilistTransit_Loss_Chargess = transitLossCharge.GetTransit_Loss_Chargess(drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Transit_Loss_Charges>(ilistTransit_Loss_Chargess); bindTransitLossCharge(dt); break; case "Unit of Measure": Unit_of_Measures unitMeasure = new Unit_of_Measures(); IList <Unit_of_Measure> ilistUnit_of_Measure = unitMeasure.GetUnit_of_Measures(txtCode.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Unit_of_Measure>(ilistUnit_of_Measure); bindUnitOfMeasure(dt); txtCode.Visible = true; lblCode.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "User Transporter Mapping": User_Transporter_Mappings userTransporterMapping = new User_Transporter_Mappings(); IList <User_Transporter_Mapping> ilistUser_Transporter_Mapping = userTransporterMapping.GetUser_Transporter_Mappings(drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <User_Transporter_Mapping>(ilistUser_Transporter_Mapping); bindUserTransporterMapping(dt); break; case "Vendor": Vendors Vendor = new Vendors(); IList <Vendor> ilistVendor = Vendor.GetVendors(txtName.Text, txtCity.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Vendor>(ilistVendor); bindVendor(dt); txtName.Visible = true; txtCity.Visible = true; lblName.Visible = true; lblCity.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "Whse Shipping Truck IN": Whse_Shipping_Truck_INs whseShippingTruck = new Whse_Shipping_Truck_INs(); IList <Whse_Shipping_Truck_IN> ilistWhseShippingTruck_IN = whseShippingTruck.GetWhse_Shipping_Truck_INs(txtCode.Text, drpSelectCompany.SelectedItem.Text); dt = ConvertTable.ToDataTable <Whse_Shipping_Truck_IN>(ilistWhseShippingTruck_IN); bindWhseShippingTruckIN(dt); txtCode.Visible = true; lblCode.Visible = true; btnGo.Visible = true; //Added by Jyothi btnExport.Visible = true; break; case "User": Users user = new Users(); IList <User> ilistUsers = user.GetUsers(); dt = ConvertTable.ToDataTable <User>(ilistUsers); bindUser(dt); break; default: break; } }
private void OnGUI() { // 配置目录 EditorGUILayout.BeginHorizontal(); if (GUILayout.Button("刷新目录", GUILayout.Width(90))) { Init(); } EditorGUILayout.EndHorizontal(); bool allToAsset = false; GUILayout.Space(10); EditorGUILayout.BeginHorizontal(); GUILayout.Label("选择", TitleStyle, GUILayout.Width(40)); GUILayout.Label("配表名称", TitleStyle, GUILayout.Width(249)); GUILayout.Label("To Asset", TitleStyle, GUILayout.Width(80)); EditorGUILayout.EndHorizontal(); scrollPos = EditorGUILayout.BeginScrollView(scrollPos); if (settingItemList == null) { Init(); } for (int i = 0; i < settingItemList.Count; i++) { SettingItem item = settingItemList[i]; GUILayout.BeginHorizontal(); item.Selected = GUILayout.Toggle(item.Selected, "", GUILayout.Width(40)); GUILayout.Label(item.Name, GUILayout.Width(249)); item.ToAsset = GUILayout.Toggle(item.ToAsset, "", GUILayout.Width(80)); if (allToAsset) { item.ToAsset = true; } GUILayout.EndHorizontal(); } EditorGUILayout.EndScrollView(); if (GUILayout.Button("保存")) { WriteSetting(); EditorUtility.DisplayDialog("提示", "保存配置成功", "好的"); } EditorGUILayout.BeginHorizontal(); if (GUILayout.Button("转换选中", GUILayout.Height(50))) { var list = new List <SettingItem>(); foreach (var item in settingItemList) { if (item.Selected) { list.Add(item); } } if (list.Count > 0) { ConvertTable.GenCSharp(list); } else { EditorUtility.DisplayDialog("提示", "请至少勾选一项", "好吧"); } } if (GUILayout.Button("转换全部", GUILayout.Height(50))) { if (settingItemList.Count > 0) { ConvertTable.GenCSharp(settingItemList); } WriteSetting(); AssetDatabase.Refresh(); } if (GUILayout.Button("导入选中数据", GUILayout.Height(50))) { var list = new List <SettingItem>(); foreach (var item in settingItemList) { if (item.Selected && item.ToAsset) { list.Add(item); } } if (list.Count > 0) { ImportData(list); } else { EditorUtility.DisplayDialog("提示", "请至少勾选一项", "好吧"); } } if (GUILayout.Button("导入所有数据", GUILayout.Height(50))) { var list = new List <SettingItem>(); foreach (var item in settingItemList) { if (item.ToAsset) { list.Add(item); } } ImportData(list); } EditorGUILayout.EndHorizontal(); if (GUILayout.Button("Build Table AssetBundle")) { ABTool.Singlton.BuildAssetBundleTotal(true, BuildABType.Table); } }