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