void Update()
{
if (!this.m_IsLoadSceneFromDisk)
{
Hashtable map = MapReader.Instance.LoadMap();
if (map != null)
{
FindRivalResponseParameter param = DataConvertor.ConvertJSONToParameter(map);
foreach (var building in param.Buildings)
{
EditorFactory.Instance.ConstructBuilding(building.BuildingType, building.Level,
new TilePosition(building.PositionColumn, building.PositionRow));
}
foreach (var removableObject in param.Objects)
{
EditorFactory.Instance.ConstructRemovableObject(removableObject.ObjectType,
new TilePosition(removableObject.PositionColumn, removableObject.PositionRow));
}
foreach (var achievementBuilding in param.AchievementBuildings)
{
EditorFactory.Instance.ConstructAchievementBuilding(achievementBuilding.AchievementBuildingType,
new TilePosition(achievementBuilding.PositionColumn, achievementBuilding.PositionRow));
}
foreach (var defenseObject in param.DefenseObjects)
{
EditorFactory.Instance.ConstructDefenseObject(defenseObject.PropsType,
new TilePosition(defenseObject.PositionColumn, defenseObject.PositionRow));
}
}
this.m_IsLoadSceneFromDisk = true;
}
}
public List <VendorPaymentsViewModel> getVendorPayments()
{
QueryExecutor _q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <VendorPaymentsViewModel>
(_q.NonTransaction("select * from view_vendor_payments")));
}
public void TestConvertToDataParameter()
{
CategoryTableMetadata ctm = new CategoryTableMetadata();
IDataParameter[] iparams = DataConvertor.ConvertToDataParameter(DatabaseServer.SqlServer, ctm);
Assert.IsTrue(iparams.Length > 0);
}
private void btnCSVExport_Click(object sender, EventArgs e)
{
SaveFileDialog dlg = new SaveFileDialog();
List <Tool> ls = logic.Records;
DataTable dt = DataConvertor.ToDataTable(ls);
//DataSet ds = bal_DataConvertor.dtToDataSet(dt);
dlg.Filter = "csv files (*.csv)|*.csv|All files (*.*)|*.*";
dlg.Title = "Export in CSV format";
//decide whether we need to check file exists
//dlg.CheckFileExists = true;
//this is the default behaviour
dlg.CheckPathExists = true;
//If InitialDirectory is not specified, the default path is My Documents
//dlg.InitialDirectory = Application.StartupPath;
dlg.ShowDialog();
// If the file name is not an empty string open it for saving.
if (dlg.FileName != "")
//alternative if you prefer this
//if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK
//&& dlg.FileName.Length > 0)
{
string saveAs_file_path = dlg.FileName;
//First Approach
// Specify the column list to export
int[] iColumns = { 0, 1, 2, 3, 4, 5, 6 };
// Export the details of specified columns to CSV
RKLib.ExportData.Export objExport = new Export("Win");
objExport.ExportDetails(dt, iColumns, Export.ExportFormat.CSV, saveAs_file_path);
//Second Approach
/*
* StreamWriter streamWriter = new StreamWriter(saveAs_file_path);
* streamWriter.Write("User Accounts Record. File created on: " + DateTime.Now.ToString());
* //Note streamWriter.NewLine is same as "\r\n"
* streamWriter.Write(streamWriter.NewLine);
* streamWriter.Write("\r\n");
* //streamWriter.Write("Date, Title, Memo\r\n"); //Header
* streamWriter.Write(bal_DataConvertor.ListToCSVFile(ls)); //Content
* streamWriter.Close();
*/
MessageBox.Show("CSV file created successfully.", Utilities.MsgBoxHead, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Please select save location", Utilities.MsgBoxHead, MessageBoxButtons.RetryCancel, MessageBoxIcon.Hand);
}
}
public void TestConversion()
{
long a = 99111234;
var ans = DataConvertor.ToBaseN(a);
var b = DataConvertor.ToLongN(ans);
Assert.AreEqual(a, b);
}
public T GetUrlParameterValue <T>(string parameterName)
{
object v;
if (RouteHelper.TryGetRouteValueOfCurrentRoute(parameterName, out v) && v != null)
{
return(DataConvertor.GetValue <T>(v, parameterName, null));
}
return(default(T));
}
public void TestConvertToDataTableOverload2()
{
CategoryTableMetadata c = new CategoryTableMetadata();
CategoryPersistentObject cto = new CategoryPersistentObject(DatabaseServer.SqlServer, SharedData.sqlserver, c);
CategoryTableMetadata[] categs = (CategoryTableMetadata[])cto.GetTableMetadata();
DataTable dt = DataConvertor.ConvertToDataTable(categs, categs[0].GetField(1), categs[0].GetField(2));
Assert.IsTrue(categs.Length > 0);
}
public void TestConvertToHashtable()
{
CategoryTableMetadata c = new CategoryTableMetadata();
CategoryPersistentObject cto = new CategoryPersistentObject(DatabaseServer.SqlServer, SharedData.sqlserver, c);
CategoryTableMetadata[] categs = (CategoryTableMetadata[])cto.GetTableMetadata();
Hashtable dt = DataConvertor.ConvertToHashtable(categs, categs[0].GetField(0), categs[0].GetField(1));
Assert.IsTrue(dt.Count > 0);
}
public IEnumerable <DrawingDataModel> ConvertData(Dictionary <string, List <Dictionary <string, string> > > data)
{
List <Dictionary <string, string> > formatData = null;
var result = new List <DrawingDataModel>();
data.TryGetValue(nameof(DrawingDataModel), out formatData);
if (formatData != null && formatData.Any())
{
result = DataConvertor.ConvertData <DrawingDataModel>(formatData);
}
return(result);
}
public IEnumerable <CustomerModel> ConvertCustomerData(Dictionary <string, List <Dictionary <string, string> > > data)
{
List <Dictionary <string, string> > formatData = null;
var result = new List <CustomerModel>();
data.TryGetValue("Customer", out formatData);
if (formatData != null && formatData.Any())
{
result = DataConvertor.ConvertData <CustomerModel>(formatData);
}
return(result);
}
/// <summary>
/// 解析View的非强类型Model上的属性
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="model"></param>
/// <param name="propertyName"></param>
/// <returns></returns>
public T ParseModel <T>(object model, string propertyName)
{
object v = null;
try
{
v = DataBinder.Eval(model, propertyName);
}
catch
{
return(default(T));
}
return(DataConvertor.GetValue <T>(v, propertyName, null));
}
public static T GetPropertyValue <T>(object obj, string propertyName)
{
object v = null;
try
{
v = DataBinder.Eval(obj, propertyName);
}
catch
{
return(default(T));
}
return(DataConvertor.GetValue <T>(v, propertyName, null));
}
public C ExecuteFirstColumn <T, C>()
where C : ICollection <T>, new()
{
C list = new C();
using (DbDataReader reader = ExecuteDataReader())
{
while (reader.Read())
{
list.Add(DataConvertor.GetValue <T>(DataMapper.ConvertIfEnum(reader[0], typeof(T)), null, null));
}
reader.Close();
}
return(list);
}
public ObjectInfo(UInt16 index, string name, string description,
bool readOnly, bool sdoCanRead, bool visible, string displayedName,
string measureUnit, Category category, DataConvertor convertor,
UInt32 defaultValue)
{
Index = index;
Name = name;
Description = description;
ReadOnly = readOnly;
SdoCanRead = sdoCanRead;
Visible = visible;
DisplayedName = displayedName;
MeasureUnit = measureUnit;
Category = category;
DataType = convertor;
DefaultValue = defaultValue;
}
public void StartListening()
{
listeningCondition = true;
guessNumberService = new GuessNumberService();
tcpListener = new TcpListener(address, portNumber);
tcpListener.Start();
listeningProcess = Task.Run(() =>
{
byte[] bytes = new byte[256];
string data = null;
try
{
while (listeningCondition)
{
TcpClient client = tcpListener.AcceptTcpClient();
data = null;
NetworkStream stream = client.GetStream();
int i;
while ((i = stream.Read(bytes, 0, bytes.Length)) != 0)
{
data = Encoding.ASCII.GetString(bytes, 0, i);
GuessNumberRequestData requestData = DataConvertor.FromString <GuessNumberRequestData>(data);
GuessNumberResponseData responseData = guessNumberService.ProcessRequest(requestData);
data = DataConvertor.ToString <GuessNumberResponseData>(responseData);
byte[] msg = Encoding.ASCII.GetBytes(data);
stream.Write(msg, 0, msg.Length);
}
client.Close();
}
}
finally
{
tcpListener.Stop();
}
});
}
public ActionResult <UrlEntity> Get(string shortUrl)
{
if (string.IsNullOrEmpty(shortUrl))
{
return(BadRequest());
}
var mongoUrlEntity = _tinyUrlRepository.GetLongUrl(DataConvertor.ToLongN(shortUrl));
if (mongoUrlEntity == null)
{
return(NotFound());
}
return(new ObjectResult(new UrlEntity()
{
ShortUrl = shortUrl,
LongUrl = mongoUrlEntity.LongUrl
}));
}
static void Main(string[] args)
{
ClientModel client = ClientModel.Connect("127.0.0.1", 13000);
Console.WriteLine("press any key to continue...");
Console.ReadKey();
bool playAgain = true;
while (playAgain)
{
GuessNumberRequestData requestData = new GuessNumberRequestData();
requestData.NewGame = true;
client.SendData(DataConvertor.ToString <GuessNumberRequestData>(requestData));
GuessNumberResponseData responseData = null;
do
{
if (requestData.NewGame)
{
requestData.NewGame = false;
}
else
{
Console.WriteLine("Wrong guess.");
}
int number;
Console.WriteLine("Guess number [0-9]:");
if (!int.TryParse(Console.ReadLine(), out number))
{
Console.WriteLine("Wrong input!");
continue;
}
requestData.GuessedNumber = number;
responseData = DataConvertor.FromString <GuessNumberResponseData>(client.SendData(DataConvertor.ToString <GuessNumberRequestData>(requestData)));
} while (!responseData.RightNumber);
Console.WriteLine("You did it! Wanna play again (press r to play again).");
if (Console.ReadKey().Key != ConsoleKey.R)
{
playAgain = false;
}
}
Console.WriteLine("press any key to exit...");
Console.ReadKey();
}
public ActionResult <UrlEntity> Post([FromBody] string longUrl)
{
var shortIdCounter = Global.GetCounter();
var shortId = long.Parse(Global.Prefix + "" + shortIdCounter);
var shortUrl = DataConvertor.ToBaseN(shortId);
var mongoUrlEntity = _tinyUrlRepository.PostLongUrl(new MongoUrlEntity()
{
LongUrl = longUrl,
ShortUrlId = new BsonInt64(shortId),
ServerPrefix = Global.Prefix
});
var urlEntity = new UrlEntity()
{
LongUrl = longUrl,
ShortUrl = shortUrl
};
return(urlEntity);
}
void Start()
{
Hashtable map = MapReader.Instance.LoadMap();
BattleSceneHelper.Instance.ClearObject();
int battleRandomSeed = 0;
BattleRandomer.Instance.SetSeed(battleRandomSeed);
if (map != null)
{
this.m_Factory.ConstructBuilding(DataConvertor.ConvertJSONToParameter(map));
this.m_Map.SetMap(this.CurrentRivalAge);
BattleMapData.Instance.ConstructGridArray();
this.m_GridFactory.ConstructGird();
}
//AudioController.PlayMusic("BattleStart");
BattleSceneHelper.Instance.EnableBuildingAI();
BattleRecorder.Instance.BattleStartTime = TimeTickRecorder.Instance.CurrentTimeTick;
}
/// <summary>
/// 通过QueryString的key获取相应的value，并转换成所需的类型
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="key"></param>
/// <returns></returns>
public static T ParseQueryStringVal <T>(string key)
{
if (string.IsNullOrWhiteSpace(key))
{
return(default(T));
}
string val = HttpContext.Current.Request.QueryString.Get(key);
if (string.IsNullOrWhiteSpace(val))
{
return(default(T));
}
try
{
return(DataConvertor.GetValue <T>(val, key, null));
}
catch (Exception)
{
return(default(T));
}
}
public MatchLogResponseParameter GetReplayData()
{
MatchLogResponseParameter result = new MatchLogResponseParameter();
result.RandomSeed = 0;
result.RivalInformation = DataConvertor.ConvertJSONToParameter((Hashtable)(JSONHelper.jsonDecode(this.GetMapInformation())));
Hashtable battleInfo = (Hashtable)JSONHelper.jsonDecode(this.GetBattleInformation());
result.TotalTime = Convert.ToInt32(battleInfo[EditorConfigInterface.Instance.BattleTimeKey]);
result.DropArmyCommands = new List <DropArmyResponseParameter>();
result.DropMercenaryCommands = new List <DropMercenaryResponseParameter>();
result.UsePropsCommands = new List <UsePropsResponseParameter>();
if (battleInfo.ContainsKey(EditorConfigInterface.Instance.BattleArmyKey))
{
ArrayList dropArmies = (ArrayList)battleInfo[EditorConfigInterface.Instance.BattleArmyKey];
foreach (var army in dropArmies)
{
DropArmyResponseParameter param = new DropArmyResponseParameter();
Hashtable a = (Hashtable)army;
param.ArmyType = (ArmyType)(Convert.ToInt32(a[EditorConfigInterface.Instance.DropTypeKey]));
param.Level = Convert.ToInt32(a[EditorConfigInterface.Instance.ArmyLevelKey]);
param.PositionX = float.Parse(a[EditorConfigInterface.Instance.DropPositionXKey].ToString());
param.PositionY = float.Parse(a[EditorConfigInterface.Instance.DropPositionYKey].ToString());
param.OperateTime = Convert.ToInt32(a[EditorConfigInterface.Instance.DropTimeKey]);
result.DropArmyCommands.Add(param);
}
}
if (battleInfo.ContainsKey(EditorConfigInterface.Instance.BattleMercenaryKey))
{
ArrayList dropMercenaries = (ArrayList)battleInfo[EditorConfigInterface.Instance.BattleMercenaryKey];
foreach (var mercenary in dropMercenaries)
{
DropMercenaryResponseParameter param = new DropMercenaryResponseParameter();
Hashtable a = (Hashtable)mercenary;
param.MercenaryType = (MercenaryType)(Convert.ToInt32(a[EditorConfigInterface.Instance.DropTypeKey]));
param.PositionX = float.Parse(a[EditorConfigInterface.Instance.DropPositionXKey].ToString());
param.PositionY = float.Parse(a[EditorConfigInterface.Instance.DropPositionYKey].ToString());
param.OperateTime = Convert.ToInt32(a[EditorConfigInterface.Instance.DropTimeKey]);
result.DropMercenaryCommands.Add(param);
}
}
if (battleInfo.ContainsKey(EditorConfigInterface.Instance.BattlePropsKey))
{
ArrayList useProps = (ArrayList)battleInfo[EditorConfigInterface.Instance.BattlePropsKey];
foreach (var props in useProps)
{
UsePropsResponseParameter param = new UsePropsResponseParameter();
Hashtable p = (Hashtable)props;
param.PropsType = (PropsType)(Convert.ToInt32(p[EditorConfigInterface.Instance.DropTypeKey]));
param.PositionX = float.Parse(p[EditorConfigInterface.Instance.DropPositionXKey].ToString());
param.PositionY = float.Parse(p[EditorConfigInterface.Instance.DropPositionYKey].ToString());
param.OperateTime = Convert.ToInt32(p[EditorConfigInterface.Instance.DropTimeKey]);
result.UsePropsCommands.Add(param);
}
}
return(result);
}
/// <summary>
/// 执行返回第一行第一列的值，并自动转换为对应的类型，如果是泛型值且为空则会返回null
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public T ExecuteScalar <T>()
{
object v = DataMapperHelper.ConvertIfEnum(ExecuteScalar(), typeof(T));
return(DataConvertor.GetValue <T>(v, null, null));
}
private int AddColPurchase(Cell cell, ref Purchase sr, int c)
{
Logs.LogMe("cell(" + cell.ColumnIndex + ")=" + cell.Text);
switch (cell.ColumnIndex)
{
case 0:
sr.GRNNo = cell.Text;
c++;
break;
case 1:
sr.GRNDate = DataConvertor.DateFromExcelFormat(cell.Text);
c++;
break;
case 2:
sr.InvoiceNo = cell.Text;
c++;
break;
case 3:
sr.InvoiceDate = DataConvertor.DateFromExcelFormat(cell.Text);
c++;
break;
case 4:
sr.SupplierName = cell.Text;
c++;
break;
case 5:
sr.Barcode = cell.Text;
c++;
break;
case 6:
sr.ProductName = cell.Text;
c++;
break;
case 7:
sr.StyleCode = cell.Text;
c++;
break;
case 8:
sr.ItemDesc = cell.Text;
c++;
break;
case 9:
sr.Quantity = cell.Amount;
c++;
break;
case 10:
sr.MRP = cell.Amount;
c++;
break;
case 11:
sr.MRPValue = cell.Amount;
c++;
break;
case 12:
sr.Cost = cell.Amount;
c++;
break;
case 13:
sr.CostValue = cell.Amount;
c++;
break;
case 14:
sr.TaxAmt = cell.Amount;
c++;
break;
}
return(c);
}
private int AddColSale(Cell cell, ref SaleItemWise sr, int c)
{
Logs.LogMe("cell(" + cell.ColumnIndex + ")=" + cell.Text);
switch (cell.ColumnIndex)
{
case 0:
sr.InvoiceNo = cell.Text;
c++;
break;
case 1:
sr.InvDate = DataConvertor.DateFromExcelFormatString(cell.Text);
c++;
break;
case 2:
sr.InvType = cell.Text;
c++;
break;
case 3:
sr.BrandName = cell.Text;
c++;
break;
case 4:
sr.ProductName = cell.Text;
c++;
break;
case 5:
sr.ItemDesc = cell.Text;
c++;
break;
case 6:
sr.Barcode = cell.Text;
c++;
break;
case 7:
sr.StyleCode = cell.Text;
c++;
break;
case 8:
sr.QTY = (int)cell.Amount;
c++;
break;
case 9:
sr.MRP = cell.Amount;
c++;
break;
case 10:
sr.BasicRate = cell.Amount;
c++;
break;
case 11:
sr.Discount = cell.Amount;
c++;
break;
case 12:
sr.Tax = cell.Amount;
c++;
break;
case 14:
sr.RoundOff = cell.Amount;
c++;
break;
case 13:
sr.LineTotal = cell.Amount;
c++;
break;
case 15:
sr.BillAmnt = cell.Amount;
c++;
break;
case 16:
sr.Saleman = cell.Text;
c++;
break;
case 17:
sr.PaymentType = cell.Text;
c++;
break;
}
return(c);
}
private int AddCol(Cell cell, ref SaleRegister sr, int c)
{
Logs.LogMe("cell(" + cell.ColumnIndex + ")=" + cell.Text);
switch (cell.ColumnIndex)
{
case 0:
sr.InvoiceNo = cell.Text;
c++;
break;
case 1:
sr.InvDate = DataConvertor.DateFromExcelFormatString(cell.Text);
c++;
break;
case 2:
sr.InvType = cell.Text;
c++;
break;
case 3:
sr.QTY = (int)cell.Amount;
c++;
break;
case 4:
sr.MRP = cell.Amount;
c++;
break;
case 6:
sr.BasicRate = cell.Amount;
c++;
break;
case 5:
sr.Discount = cell.Amount;
c++;
break;
case 7:
sr.Tax = cell.Amount;
c++;
break;
case 8:
sr.RoundOff = cell.Amount;
c++;
break;
case 9:
sr.BillAmnt = cell.Amount;
c++;
break;
case 10:
sr.paymentType = cell.Text;
c++;
break;
// case 11: sr.coupon = cell.Text; c++; break; case 12: sr.couponAmt = cell.Text;
// c++; break; case 13: sr.LP = cell.Value; c++; break; case 14: sr.instaorder =
// cell.Text; c++; break; case 15: sr.Tailoring = cell.Text; c++; break;
}
return(c);
}
