// Simple method with Assert (send text, verify data and click)
public void SignInWithAssert(String userName, String password, String database)
{
Field1.SendKeys(userName);
Field2.SendKeys(password);
Assert.AreEqual(DropDown.Text, database);
Button.Click();
}
// Simple method (send text and click)
public void SignIn(String userName, String password, String database)
{
Field1.SendKeys(userName);
Field2.SendKeys(password);
DropDown.SendKeys(database);
Button.Click();
}
//Update Photo in DB
private void insertPicture()
{
if (fileName != "")
{
//code from http://stackoverflow.com/questions/779211/programmatically-managing-microsoft-access-attachment-typed-field-with-net
DBEngine dbe = new DBEngine();
Database db = dbe.OpenDatabase("PineSpringsPottery.accdb", false, false, "");
Recordset rs = db.OpenRecordset("SELECT * FROM PATTERN WHERE PATTERN.PatternNo = " + currentPattern.patternNo, RecordsetTypeEnum.dbOpenDynaset, 0, LockTypeEnum.dbOptimistic);
rs.MoveFirst();
rs.Edit();
Recordset2 rs2 = (Recordset2)rs.Fields["PatternPicture"].Value;
//delete previous pics
if (rs2.RecordCount != 0)
{
rs2.Delete();
}
//if not just deleting previous, add new
if (fileName != "delete")
{
rs2.AddNew();
Field2 f2 = (Field2)rs2.Fields["FileData"];
f2.LoadFromFile(fileName);
rs2._30_Update();
}
rs2.Close();
rs._30_Update();
rs.Close();
}
}
private void buttonInit_Click(object sender, EventArgs e)
{
// make bitmap
Size size = pictureBox1.ClientSize;
// init field
//try
//{
this.field = new Field2(GlobalConfig.NrThings);
//}
//catch ( Exception ex )
//{
// MessageBox.Show( this, ex.Message );
// return;
//}
// draw field
RepaintField();
//UpdateSlider();
// debug
DebugPrintLine("size=" + pictureBox1.ClientSize);
DebugPrintLine("Nr of things: " + this.field.things.Count);
// set status
SetStatus("initialized");
SetStatus2("initialized");
}
public void AddListViewItems()
{
try
{
Recordset recordset = daoDB.OpenRecordset(selDataTable.TableName);
if (recordset.RecordCount > 0)
{
foreach (Field field in recordset.Fields)
{
Field2 field2 = field as Field2;
if (field2.Expression != string.Empty && !calculatedFields.Contains(field.Name))
{
if (paramIdMap.ContainsKey(field.Name))
{
string paramName = paramIdMap[field.Name];
ListViewItem item = new ListViewItem(paramName);
item.Name = field.Name;
listViewFields.Items.Add(item);
}
else
{
ListViewItem item = new ListViewItem(field.Name);
item.Name = field.Name;
listViewFields.Items.Add(item);
}
}
}
}
recordset.Close();
}
catch (Exception ex)
{
MessageBox.Show("Failed to collect calculated fields.\n" + ex.Message, "DeleteCalculated Error:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public string ToLine()
{
return("H1"
+ $"{Field1.ToFixedString(10)}"
+ $"{Field2.ToFixedString(10)}"
+ $"{Field3.ToFixedString(10)}"
+ "");
}
//Simple method with ExpectedConditions (send text, wait for element and click)
public void SignInWithEC(String userName, String password, String database)
{
Field1.SendKeys(userName);
this._wait.Until(ExpectedConditions.ElementToBeClickable(Field2));
Field2.SendKeys(password);
DropDown.SendKeys(database);
Button.Click();
}
public string ToLine()
{
return("D1"
+ $"{Field1.ToFixedString(10)}"
+ $"{Field2.ToFixedString(10)}"
+ $"{Field3.ToFixedString(10)}"
+ $"{Field4.ToFixedString(10)}"
+ $"{Field5.ToFixedStringRight(10, '0')}"
+ "");
}
protected override void Execute(CodeActivityContext context)
{
//Channel Details
var writeKey = Write_API_Key.Get(context);
//Field Values
var f1 = Field1.Get(context) != null ? "&field1=" + Field1.Get(context) : "";
var f2 = Field2.Get(context) != null ? "&field2=" + Field2.Get(context) : "";
var f3 = Field3.Get(context) != null ? "&field3=" + Field3.Get(context) : "";
var f4 = Field4.Get(context) != null ? "&field4=" + Field4.Get(context) : "";
var f5 = Field5.Get(context) != null ? "&field5=" + Field5.Get(context) : "";
var f6 = Field6.Get(context) != null ? "&field6=" + Field6.Get(context) : "";
var f7 = Field7.Get(context) != null ? "&field7=" + Field7.Get(context) : "";
var f8 = Field8.Get(context) != null ? "&field8=" + Field8.Get(context) : "";
var chosenFormat = Format.GetHashCode() == 0 ? "" : "." + Format.ToString();
//Optional Parameters
var lat = Lat.Get(context) == 0 ? "" : "&lat=" + Lat.Get(context).ToString();
var lon = Long.Get(context) == 0 ? "" : "&long=" + Long.Get(context).ToString();
var elevation = Elevation.Get(context) == 0 ? "" : "&elevation=" + Elevation.Get(context).ToString();
var status = Status.Get(context) == null ? "" : "&status=" + Status.Get(context);
var twitter = Twitter.Get(context) == null ? "" : "&twitter=" + Twitter.Get(context);
var tweet = Tweet.Get(context) == null ? "" : "&tweet=" + Tweet.Get(context);
var created_at = Created_at.Get(context) == null ? "" : "&created_at=" + Created_at.Get(context);
//Http Request URL
string URL = "https://api.thingspeak.com/update" + chosenFormat + "?api_key=" + writeKey;
URL = URL + f1 + f2 + f3 + f4 + f5 + f6 + f7 + f8 + lat + lon + elevation + status + twitter + tweet + created_at;
//Creating GET Http Request
WebRequest wrGETURL = WebRequest.Create(URL);
Stream objStream = wrGETURL.GetResponse().GetResponseStream();
StreamReader objReader = new StreamReader(objStream);
//Capturing the response
string sLine = "";
string httpResponse = "";
while (sLine != null)
{
sLine = objReader.ReadLine();
if (sLine != null)
{
httpResponse = httpResponse + sLine + "\n";
}
}
objStream.Close();
//objReader.Close();
Response.Set(context, httpResponse);
}
private void TextBox_PreviewKeyDown(object sender, KeyEventArgs e)
{
bool isNumPadNumeric = (e.Key >= Key.NumPad0 && e.Key <= Key.NumPad9);
bool isNumeric = (e.Key >= Key.D0 && e.Key <= Key.D9);
Key[] keysToFilter = { Key.Delete, Key.Back, Key.Left, Key.Right, Key.Tab };
if (!isNumeric && !isNumPadNumeric && !keysToFilter.Contains(e.Key))
{
e.Handled = true;
return;
}
if ((e.Key == Key.Right && (sender as TextBox).CaretIndex == (sender as TextBox).Text.Length))
{
if (sender == Field1)
{
Field2.Focus();
}
else if (sender == Field2)
{
Field3.Focus();
}
else if (sender == Field3)
{
Field4.Focus();
}
e.Handled = true;
}
else if (e.Key == Key.Left && (sender as TextBox).CaretIndex == 0)
{
if (sender == Field4)
{
Field3.Focus();
}
else if (sender == Field3)
{
Field2.Focus();
}
else if (sender == Field2)
{
Field1.Focus();
}
e.Handled = true;
}
else if (e.Key == Key.OemMinus)
{
e.Handled = true;
}
}
private List <string> ExportFilesFromRecordset(Recordset2 rstAttach)
{
var result = new List <string>();
while (!rstAttach.EOF)
{
var fileName = $"{tempFolder}\\{rstAttach.Fields["FileName"].Value}";
Field2 fld = (Field2)rstAttach.Fields["FileData"];
fld.SaveToFile(fileName);
result.Add(fileName);
rstAttach.MoveNext();
}
return(result);
}
/// <summary>
/// Update species fact fields with latest red list values.
/// </summary>
protected override void SetReadListValues()
{
if (AllowAutomaticUpdate)
{
Factor factor;
if (RedListCalculator.IsEvaluationStatusSet)
{
factor = FactorManager.GetFactor((Int32)FactorId.RedListCategoryAutomatic);
foreach (FactorFieldEnumValue enumValue in factor.FactorDataType.Fields[0].FactorFieldEnum.Values)
{
if (enumValue.KeyInt == ((Int32)Category))
{
Field1.SetValueAutomatic(enumValue);
break;
}
}
Field2.SetValueAutomatic(RedListCalculator.IsGraded);
if (RedListCalculator.IsGraded &&
((Category == RedListCategory.CR) ||
(Category == RedListCategory.EN) ||
(Category == RedListCategory.VU) ||
(Category == RedListCategory.NT) ||
(Category == RedListCategory.LC)) &&
!(((RedListCalculator.CategoryProbableNoGrading == RedListCategory.NT) ||
(RedListCalculator.CategoryProbableNoGrading == RedListCategory.LC)) &&
(RedListCalculator.CategoryProbableGraded == RedListCategory.LC) &&
(Category == RedListCategory.NT) &&
RedListCalculator.IsConservationDependent))
{
Field4.SetValueAutomatic(Category.ToString() + "°");
}
else
{
Field4.SetValueAutomatic(Category.ToString());
}
}
else
{
// Reset values to nothing.
Field1.SetValueAutomatic(null);
Field2.SetValueAutomatic(null);
Field4.SetValueAutomatic(null);
}
}
}
private bool ValidateExpression(TableDef tableDef, string expression)
{
try
{
Field2 field2 = tableDef.CreateField("temp", DataTypeEnum.dbText) as Field2;
field2.Expression = expression;
field2.AllowZeroLength = true;
tableDef.Fields.Append(field2);
}
catch (Exception ex)
{
MessageBox.Show("The expression you entered contains invalid syntax.\n" + ex.Message, "Expression Builder Error:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
tableDef.Fields.Delete("temp");
return(true);
}
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
var tbx = sender as TextBox;
byte value = 0;
if (!string.IsNullOrEmpty(tbx.Text) && !Byte.TryParse(tbx.Text, out value))
{
tbx.Text = "255";
if (sender == Field1)
{
Field2.Focus();
}
else if (sender == Field2)
{
Field3.Focus();
}
else if (sender == Field3)
{
Field4.Focus();
}
}
else if (tbx.Text.Length == 3)
{
if (sender == Field1)
{
Field2.Focus();
}
else if (sender == Field2)
{
Field3.Focus();
}
else if (sender == Field3)
{
Field4.Focus();
}
}
SetValue(ValueProperty, string.Format("{0}.{1}.{2}.{3}", Field1.Text, Field2.Text, Field3.Text, Field4.Text));
}
private void Form1_Load(object sender, EventArgs e)
{
DBEngine dbe = new DBEngine();
Database db = dbe.OpenDatabase(@"C:\Users\Public\AttachmentsDB.accdb");
Recordset rsMain = db.OpenRecordset(
"select solution from tab2 where id = 1",
RecordsetTypeEnum.dbOpenSnapshot);
Recordset2 rsAttach = rsMain.Fields["solution"].Value;
Field2 fldAttach = (Field2)rsAttach.Fields["FileData"];
tempFileName = System.IO.Path.GetTempPath() + "\\" + rsAttach.Fields["FileName"].Value;
try
{
System.IO.File.Delete(tempFileName);
}
catch { }
fldAttach.SaveToFile(tempFileName);
rsAttach.Close();
rsMain.Close();
db.Close();
img = Image.FromFile(tempFileName);
pictureBox1.Image = img;
}
public override string ToString()
{
return(Field1.ToLower() + Field2.ToString() + Field3.ToString());
}
public override int GetHashCode()
{
int result = string.IsNullOrEmpty(Field1) ? 0 : Field1.GetHashCode() + Field2.GetHashCode();
return(result);
}
public GameState Clone()
{
var gameState = new GameState();
gameState.VictoryPoints = VictoryPoints;
gameState.Money = Money;
gameState.NumberOfRounds = NumberOfRounds;
gameState.ResidualMoney = ResidualMoney;
gameState.RemainingBonusActions = RemainingBonusActions;
gameState.Round = Round;
gameState.Hand = Hand.Clone() as Hand;
gameState.VineDeck = VineDeck.Clone();
gameState.OrderDeck = OrderDeck.Clone();
gameState.AutomaDeck = AutomaDeck.Clone();
gameState.SummerVisitorDeck = SummerVisitorDeck.Clone();
gameState.WinterVisitorDeck = WinterVisitorDeck.Clone();
gameState.Yoke = Yoke.Clone() as Yoke;
gameState.Trellis = Trellis.Clone() as Trellis;
gameState.Cottage = Cottage.Clone() as Cottage;
gameState.Windmill = Windmill.Clone() as Windmill;
gameState.Irigation = Irigation.Clone() as Irigation;
gameState.LargeCellar = LargeCellar.Clone() as LargeCellar;
gameState.TastingRoom = TastingRoom.Clone() as TastingRoom;
gameState.MediumCellar = MediumCellar.Clone() as MediumCellar;
gameState.Field1 = Field1.Clone() as Field;
gameState.Field2 = Field2.Clone() as Field;
gameState.Field3 = Field3.Clone() as Field;
gameState.Grande = Grande.Clone() as Grande;
gameState.NeutralWorker = NeutralWorker.Clone() as Worker;
gameState._workers = new List <Worker>();
for (var i = 0; i < 5; i++)
{
gameState._workers.Add(_workers[i].Clone() as Worker);
}
gameState._redGrapes = new List <Grape>();
foreach (var redGrape in _redGrapes)
{
gameState._redGrapes.Add(redGrape.Clone() as Grape);
}
gameState._whiteGrapes = new List <Grape>();
foreach (var whiteGrape in _whiteGrapes)
{
gameState._whiteGrapes.Add(whiteGrape.Clone() as Grape);
}
gameState._redWines = new List <Wine>();
foreach (var redWine in _redWines)
{
gameState._redWines.Add(redWine.Clone() as Wine);
}
gameState._whiteWines = new List <Wine>();
foreach (var whiteWine in _whiteWines)
{
gameState._whiteWines.Add(whiteWine.Clone() as Wine);
}
gameState._blushWines = new List <Wine>();
foreach (var blushWine in _blushWines)
{
gameState._blushWines.Add(blushWine.Clone() as Wine);
}
gameState._sparklingWines = new List <Wine>();
foreach (var sparklingWine in _sparklingWines)
{
gameState._sparklingWines.Add(sparklingWine.Clone() as Wine);
}
return(gameState);
}
public string ToOldString()
{
string content = "当前状态 : " + FaultTitle + "\r\n太阳能电压 : " + Field1.ToString("0.00") + " V\r\n超容电压 : " + Field2.ToString("0.00") + " V\r\n超容电流 : " + Field3.ToString("0.00") + " A\r\n功率 : " + Field4.ToString("0.00") + " W\r\n温度 : " + Field5.ToString("0.00") + " ℃";
content += "\r\n更新时间 : " + CreateTime;
return(content);
}
static void Main(string[] args)
{
//'C:\Users\niraj\Documents\Civictrack\XML_Reader\XML_Reader\bin\Debug\EdmontonManning.xml
//XmlDataDocument xmldoc = new XmlDataDocument();
//XmlNodeList xmlnode;
//int i = 0;
//string str = null;
//FileStream fs = new FileStream("EdmontonManning.xml", FileMode.Open, FileAccess.Read);
//xmldoc.Load(fs);
//xmlnode = xmldoc.GetElement;sByTagName("Table1");
//for (i = 0; i <= xmlnode.Count - 1; i++)
//{
// xmlnode[i].ChildNodes.Item(0).InnerText.Trim();
// str = xmlnode[i].ChildNodes.Item(0).InnerText.Trim() + " " + xmlnode[i].ChildNodes.Item(1).InnerText.Trim() + " " + xmlnode[i].ChildNodes.Item(2).InnerText.Trim();
// Console.WriteLine(str);
// Console.ReadLine();
//}
var dbe = new DBEngine();
Database db = dbe.OpenDatabase(@"ACCESDATA_BASE_PDF");
Recordset rstMain = db.OpenRecordset(
"SELECT Document FROM Table1 WHERE ID=1017",
RecordsetTypeEnum.dbOpenSnapshot);
Recordset2 rstAttach = rstMain.Fields["Document"].Value;
Field2 fld = (Field2)rstAttach.Fields["FileData"];
fld.SaveToFile(@"filename_full_path.pdf");
//while ((!"Document1.pdf".Equals(rstAttach.Fields["FileName"].Value)) && (!rstAttach.EOF))
//{
// rstAttach.MoveNext();
//}
//if (rstAttach.EOF)
//{
// Console.WriteLine("Not found.");
//}
//else
//{
// Field2 fld = (Field2)rstAttach.Fields["FileData"];
// fld.SaveToFile(@"C:\Users\Gord\Desktop\FromSaveToFile.pdf");
//}
db.Close();
//XmlDocument docu = new XmlDocument();
//docu.Load("Test.xml");
//XmlNodeList nodeList = docu.GetElementsByTagName("FileData");
//string filedata = string.Empty;
//foreach (XmlNode node in nodeList)
//{
// filedata = node.InnerText;
// byte[] binaryData = Encoding.UTF8.GetBytes(filedata);
// //File.WriteAllBytes(@"C:\textxml.pdf", binaryData);
// BinaryWriter writer = new BinaryWriter(File.Open(@"C:\Users\niraj\Documents\Civictrack\textxml1.pdf", FileMode.Create));
// writer.Write(filedata);
// //string s = Encoding.UTF8.GetString(binaryData);
// Console.WriteLine(filedata);
// break;
//}
Console.ReadLine();
}
public override string ToString()
{
string content = "当前状态 : " + FaultTitle + "\r\n太阳能电压 : " + Field1.ToString("0.00") + " V\r\n超容电压 : " + Field2.ToString("0.00") + " V\r\n超容电流 : " + Field3.ToString("0.00") + " A\r\n功率 : " + Field4.ToString("0.00") + " W\r\n温度 : " + Field5.ToString("0.00") + " ℃";
if (Field6 > 100)
{
content += "\r\n更新时间 : " + CreateTime;
}
else
{
content += "\r\n超容余量 : " + Field6.ToString("0.00") + " %\r\n更新时间 : " + CreateTime;
}
return(content);
}
void ReleaseDesignerOutlets()
{
if (Field0 != null)
{
Field0.Dispose();
Field0 = null;
}
if (Field1 != null)
{
Field1.Dispose();
Field1 = null;
}
if (Field2 != null)
{
Field2.Dispose();
Field2 = null;
}
if (Field3 != null)
{
Field3.Dispose();
Field3 = null;
}
if (Field4 != null)
{
Field4.Dispose();
Field4 = null;
}
if (Label0 != null)
{
Label0.Dispose();
Label0 = null;
}
if (Label1 != null)
{
Label1.Dispose();
Label1 = null;
}
if (Label2 != null)
{
Label2.Dispose();
Label2 = null;
}
if (Label3 != null)
{
Label3.Dispose();
Label3 = null;
}
if (Label4 != null)
{
Label4.Dispose();
Label4 = null;
}
}
public void SetFromClone(GameState clone)
{
VictoryPoints = clone.VictoryPoints;
Money = clone.Money;
NumberOfRounds = clone.NumberOfRounds;
ResidualMoney = clone.ResidualMoney;
RemainingBonusActions = clone.RemainingBonusActions;
Round = clone.Round;
Hand.SetFromClone(clone.Hand, Entities);
VineDeck.SetFromClone(clone.VineDeck, Entities);
OrderDeck.SetFromClone(clone.OrderDeck, Entities);
AutomaDeck.SetFromClone(clone.AutomaDeck, Entities);
SummerVisitorDeck.SetFromClone(clone.SummerVisitorDeck, Entities);
WinterVisitorDeck.SetFromClone(clone.WinterVisitorDeck, Entities);
Yoke.SetFromClone(clone.Yoke, Entities);
Trellis.SetFromClone(clone.Trellis, Entities);
Cottage.SetFromClone(clone.Cottage, Entities);
Windmill.SetFromClone(clone.Windmill, Entities);
Irigation.SetFromClone(clone.Irigation, Entities);
LargeCellar.SetFromClone(clone.LargeCellar, Entities);
TastingRoom.SetFromClone(clone.TastingRoom, Entities);
MediumCellar.SetFromClone(clone.MediumCellar, Entities);
Field1.SetFromClone(clone.Field1, Entities);
Field2.SetFromClone(clone.Field2, Entities);
Field3.SetFromClone(clone.Field3, Entities);
Grande.SetFromClone(clone.Grande, Entities);
NeutralWorker.SetFromClone(clone.NeutralWorker, Entities);
for (var i = 0; i < 5; i++)
{
_workers[i].SetFromClone(clone.Workers.ElementAt(i), Entities);
}
for (int i = 0; i < 9; i++)
{
_redGrapes[i].SetFromClone(clone._redGrapes[i], Entities);
}
for (int i = 0; i < 9; i++)
{
_whiteGrapes[i].SetFromClone(clone._whiteGrapes[i], Entities);
}
for (int i = 0; i < 9; i++)
{
_redWines[i].SetFromClone(clone._redWines[i], Entities);
}
for (int i = 0; i < 9; i++)
{
_whiteWines[i].SetFromClone(clone._whiteWines[i], Entities);
}
for (int i = 0; i < 6; i++)
{
_blushWines[i].SetFromClone(clone._blushWines[i], Entities);
}
for (int i = 0; i < 3; i++)
{
_sparklingWines[i].SetFromClone(clone._sparklingWines[i], Entities);
}
}
public static Bitmap Draw(this Field2 field, Size display)
{
if (display.Width <= 0 || display.Height <= 0)
{
return(null);
}
Bitmap bitmap = new Bitmap(display.Width, display.Height);
Graphics g = Graphics.FromImage(bitmap);
CoordinatesConverter conv = new CoordinatesConverter(display, field.Viewport);
// draw border
int width = display.Width;
int height = display.Height;
g.DrawLine(Pens.Aqua, 0, 0, width - 1, 0);
g.DrawLine(Pens.Aqua, width - 1, 0, width - 1, height - 1);
g.DrawLine(Pens.Aqua, width - 1, height - 1, 0, height - 1);
g.DrawLine(Pens.Aqua, 0, height - 1, 0, 0);
// paint all things
foreach (Thing2 t in field.things)
{
// Draw a disc with center at its location, and radius its size, and color its color
PointF p1 = new PointF();
PointF p2 = new PointF();
float w, h;
p1.X = (float)(t.location.x - t.size);
p1.Y = (float)(t.location.y - t.size);
w = (float)(t.size * 2);
h = (float)(t.size * 2);
PointF p1s = conv.ConvertPoint(p1);
float ws = conv.ConvertDistanceHorizontal(w);
float hs = conv.ConvertDistanceVertical(h);
Brush b = new SolidBrush(t.color);
g.FillEllipse(b, p1s.X, p1s.Y, ws, hs);
// draw gravity vector
if (t.forceNet != null)
{
p1 = new PointF();
p2 = new PointF();
p1 = conv.ConvertPoint((float)t.location.x, (float)t.location.y);
p2 = conv.ConvertPoint(t.location.x + t.forceNet.i, t.location.y + t.forceNet.j);
g.DrawLine(Pens.White, p1, p2);
}
// draw gravity component vectors
if (t.forceComponents != null)
{
foreach (Vector2d v in t.forceComponents)
{
p1 = new PointF();
p2 = new PointF();
p1 = conv.ConvertPoint((float)t.location.x, (float)t.location.y);
p2 = conv.ConvertPoint(t.location.x + v.i, t.location.y + v.j);
g.DrawLine(Pens.Aquamarine, p1, p2);
}
}
//// draw velocity vector
//if ( a.velocity != null )
//{
// x = (float)(a.location.x);
// y = (float)(a.location.y);
// g.DrawLine( Pens.Yellow, x, y, x + (float)a.velocity.i, y + (float)a.velocity.j );
//}
}
// paint all rezinochki
foreach (Rezinochka r in field.rezinochki)
{
PointF p1 = new PointF();
PointF p2 = new PointF();
p1.X = (float)(r.a.location.x);
p1.X = (float)(r.a.location.y);
p2.X = (float)(r.b.location.x);
p2.X = (float)(r.b.location.y);
PointF p1s = conv.ConvertPoint(p1);
PointF p2s = conv.ConvertPoint(p2);
SolidBrush brush = new SolidBrush(r.color);
PointF[] points = new PointF[]
{
new PointF(p1s.X + 2, p1s.Y + 2),
new PointF(p1s.X - 2, p1s.Y - 2),
new PointF(p2s.X + 2, p2s.Y + 2),
new PointF(p2s.X - 2, p2s.Y - 2)
};
g.FillPolygon(brush, points);
}
return(bitmap);
}
private void CreateField(bool exist, TableDef tableDef, string strExpression)
{
try
{
if (exist)
{
string paramId = fieldDictionary[selField].ParamId;
tableDef.Fields.Delete(paramId);
if (calType == CalculationType.String)
{
Field2 field2 = tableDef.CreateField(paramId, DataTypeEnum.dbText) as Field2;
field2.Expression = strExpression;
field2.AllowZeroLength = true;
tableDef.Fields.Append(field2);
}
else if (calType == CalculationType.Math)
{
Field2 field2 = tableDef.CreateField(paramId, DataTypeEnum.dbDouble) as Field2;
field2.Expression = strExpression;
tableDef.Fields.Append(field2);
if (setDecimal)
{
Property property = field2.CreateProperty("DecimalPlaces", DataTypeEnum.dbByte, decimalPlace);
field2.Properties.Append(property);
property = field2.CreateProperty("Format", DataTypeEnum.dbText, "Fixed");
field2.Properties.Append(property);
field2.Properties.Refresh();
}
}
}
else// not exist in the database
{
if (calType == CalculationType.String)
{
Field2 field2 = tableDef.CreateField(selField, DataTypeEnum.dbText) as Field2;
field2.Expression = strExpression;
field2.AllowZeroLength = true;
tableDef.Fields.Append(field2);
}
else if (calType == CalculationType.Math)
{
Field2 field2 = tableDef.CreateField(selField, DataTypeEnum.dbDouble) as Field2;
if (roundUp)
{
string oldExpression = strExpression;
strExpression = string.Format("IIf({0}>Int({0}),Int({0})+1,Int({0}))", oldExpression);
}
else if (roundDown)
{
strExpression = "Int(" + strExpression + ")";
}
field2.Expression = strExpression;
tableDef.Fields.Append(field2);
if (setDecimal)
{
Property property = field2.CreateProperty("DecimalPlaces", DataTypeEnum.dbByte, decimalPlace);
field2.Properties.Append(property);
property = field2.CreateProperty("Format", DataTypeEnum.dbText, "Fixed");
field2.Properties.Append(property);
field2.Properties.Refresh();
}
}
DataColumn column = new DataColumn();
column.DataType = System.Type.GetType(strDataType);
column.ColumnName = selField;
selDataTable.Columns.Add(column);
}
}
catch (Exception ex)
{
MessageBox.Show("Failed to create a calculated field.\n" + ex.Message, "Expression Builder Error:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
