/// <summary>
/// GPS DOP and active satellites and parses an NMEA sentence
/// </summary>
/// <param name="NMEAsentence"></param>
public GPGSA(string NMEAsentence)
{
_pRNInSolution = new List<string>();
try
{
if (NMEAsentence.IndexOf('*') > 0)
NMEAsentence = NMEAsentence.Substring(0, NMEAsentence.IndexOf('*'));
//Split into an array of strings.
string[] split = NMEAsentence.Split(new Char[] { ',' });
if (split[1].Length > 0)
_mode = split[1][0];
else
_mode = ' ';
if (split[2].Length > 0)
{
switch (split[2])
{
case "2": _fixMode = GSAFixModeEnum._2D; break;
case "3": _fixMode = GSAFixModeEnum._3D; break;
default: _fixMode = GSAFixModeEnum.FixNotAvailable; break;
}
}
_pRNInSolution.Clear();
for (int i = 0; i <= 11; i++)
if(split[i + 3]!="")
_pRNInSolution.Add(split[i + 3]);
GPSHandler.dblTryParse(split[15], out _pdop);
GPSHandler.dblTryParse(split[16], out _hdop);
GPSHandler.dblTryParse(split[17], out _vdop);
}
catch { }
}
public static void ImportPods(string directory, string pubsuburl)
{
if (string.IsNullOrEmpty(directory) || string.IsNullOrEmpty(pubsuburl))
{
throw new Exception("Arguments cannot be null");
}
System.Collections.Generic.List <ProofOfDelivery> pods = new System.Collections.Generic.List <ProofOfDelivery>();
bool skipheaders = true;
string[] entries = null;
System.Collections.Generic.List <char> delim = new System.Collections.Generic.List <char>();
delim.Add('\r');
delim.Add('\n');
string[] files = System.IO.Directory.GetFiles(directory);
foreach (var file in files)
{
if (!file.Contains("OrdersExported"))
{
continue;
}
skipheaders = true;
foreach (var row in System.IO.File.ReadAllText(file, System.Text.Encoding.GetEncoding(1253)).Split(delim.ToArray()) ?? Enumerable.Empty <string>())
{
if (((((row == null || row == "")) == false) && (((row == null || row.Trim() == "")) == false)))
{
entries = row?.Split(';');
if ((skipheaders))
{
skipheaders = false;
continue;
}
if ((entries.Length > 0 && (entries[0] == null || entries[0] == "") == false))
{
ProofOfDelivery proof = new ProofOfDelivery();
try
{
proof.DateIssued = DateTime.Parse(entries[0]);
}
catch (System.Exception e)
{
Console.WriteLine(e.Message);
}
proof.PODNumber = entries[1].Trim();
proof.DeliveryStatus = entries[3];
pods?.Add(proof);
}
}
}
string message = ConvertToPubSubMessage(pods);
PostMessage(message, "");
pods?.Clear();
}
}
public void PrepareWriteData(int v)
{
if (v > variables)
{
checkcom = null;
}
variables = v;
coms.Clear();
System.Random r = new Random();
StringBuilder con = new StringBuilder();
con.Append("insert /*+ AUTO */ into mydata\n\t");
VerticaCommand command;
for (int i = 1; i <= variables; i++)
{
if (i >= 1000 && (i % 1000 == 0))
{
command = client.CreateCommand();
command.CommandText = con.ToString();
coms.Add(command);
con.Clear();
con.Append("insert /*+ AUTO */ into mydata\n\t");
}
DateTime ts = DateTime.UtcNow;
int upVal = r.Next(1, 1000000);
if (i == max_var)
{
ts_max = ts;
}
con.Append(" select 'testinstance_" + i + "','OK', TIMESTAMP '" + ts.ToString("yyyy-MM-dd hh:mm:ss.ffffff", dtfi) + "', " + upVal.ToString());
if (i != variables && ((i + 1) % 1000 != 0))
{
con.Append(" UNION ");
}
}
command = client.CreateCommand();
command.CommandText = con.ToString();
command.Prepare();
coms.Add(command);
}
static public int Clear(IntPtr l)
{
try {
System.Collections.Generic.List <WWWRequest> self = (System.Collections.Generic.List <WWWRequest>)checkSelf(l);
self.Clear();
pushValue(l, true);
return(1);
}
catch (Exception e) {
return(error(l, e));
}
}
// Update is called once per frame
void Update()
{
if (counter % 60 == 0)
{
print(average + "fps");
framerates.Clear();
counter = 0;
}
framerates.Add(Mathf.RoundToInt(1 / Time.deltaTime));
average = Mean(framerates);
counter++;
}
// inherit javadocs
public override bool Next()
{
if (firstTime)
{
firstTime = false;
for (int i = 0; i < subSpans.Length; i++)
{
if (!subSpans[i].Next())
{
more = false;
return(false);
}
}
more = true;
}
if (collectPayloads)
{
matchPayload.Clear();
}
return(AdvanceAfterOrdered());
}
private void ChessBoard_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
{
if (e.Button == System.Windows.Forms.MouseButtons.Left)
{
if (!Playing)
{
Queens.Clear();
ResetCells();
Playing = true;
DrawBoard();
}
mUserPlay = true;
byte colIndex = (e.Location.X - this.Left) / 80;
byte rowIndex = (e.Location.Y - this.Top) / 80;
Int16 index = Exists(ref new Queen(rowIndex, colIndex));
if (Queens.Count < 8)
{
if (index > -1)
{
mCells[rowIndex, colIndex] = false;
Queens.RemoveAt(index);
}
else
{
mCells[rowIndex, colIndex] = true;
Queens.Add(new Queen(rowIndex, colIndex));
}
}
else
{
if (index > -1)
{
mCells[rowIndex, colIndex] = false;
Queens.RemoveAt(index);
}
}
DrawBoard();
}
}
private List <string> GetItemsValueList(CheckBoxList cblItems)
{
System.Collections.Generic.List <string> lsItems = new System.Collections.Generic.List <string>();
try
{
for (int list = 0; list < cblItems.Items.Count; list++)
{
lsItems.Add(cblItems.Items[list].Value);
}
}
catch { lsItems.Clear(); }
return(lsItems);
}
double writeandread(Tick[] data, int date, bool printperf, bool clearreadbuffer)
{
// clear out the read buffer
if (clearreadbuffer)
{
readdata.Clear();
}
// keep track of time
double elapms;
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
// write new file from data
TikWriter tw = new TikWriter(PATH, data[0].symbol, date == 0 ? data[0].date: date);
string FILE = tw.Filepath;
sw.Start();
foreach (Tick k in data)
{
tw.newTick(k);
}
sw.Stop();
tw.Close();
elapms = (double)sw.ElapsedMilliseconds;
if (printperf)
{
Console.WriteLine("write speed (ticks/sec): " + (data.Length / (elapms / 1000)).ToString("n0"));
}
// read file back in from file
TikReader tr = new TikReader(FILE);
tr.gotTick += new TickDelegate(tr_gotTick);
sw.Reset();
sw.Start();
while (tr.NextTick())
{
;
}
sw.Stop();
tr.Close();
elapms = (double)sw.ElapsedMilliseconds;
if (printperf)
{
Console.WriteLine("read speed (ticks/sec): " + (data.Length / (elapms / 1000)).ToString("n0"));
}
// remove file
removefile(FILE);
return(elapms);
}
/// <summary>
/// Destroys all registered external data, full cleanup for internal data.
/// </summary>
public void Dispose()
{
#if DEBUG
if (_isDisposed)
{
throw new Exception("EcsSystems instance already disposed");
}
if (!_inited)
{
throw new Exception("EcsSystems instance was not initialized");
}
_isDisposed = true;
for (var i = _debugListeners.Count - 1; i >= 0; i--)
{
_debugListeners[i].OnSystemsDestroyed();
}
_debugListeners.Clear();
DisabledInDebugSystems.Clear();
_inited = false;
#endif
for (var i = _initSystemsCount - 1; i >= 0; i--)
{
_initSystems[i].Destroy();
_initSystems[i] = null;
_supervisor.ProcessDelayedUpdates();
}
_initSystemsCount = 0;
for (var i = _preInitSystemsCount - 1; i >= 0; i--)
{
_preInitSystems[i].PreDestroy();
_preInitSystems[i] = null;
_supervisor.ProcessDelayedUpdates();
}
_preInitSystemsCount = 0;
for (var i = _runSystemsCount - 1; i >= 0; i--)
{
_runSystems[i] = null;
}
_runSystemsCount = 0;
#if !ECP_DISABLE_INJECT
for (var i = _injectSystemsCount - 1; i >= 0; i--)
{
_injectSystems[i] = null;
}
_injectSystemsCount = 0;
_injections.Clear();
#endif
}
/// <summary>
/// 參與率次數比例
/// </summary>
public DataTable getScanRate(string event_no, string counter, out string total, out THC_Library.Error error)
{
error = null;
total = "";
//select EUR005,count(EUR005) as cc from event_user_records
//where EUR002=1033
//group by EUR005
//having count(EUR005) > 2
error = null;
DataTable resultTable = null;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "select EUR005 as acc,count(EUR005) as cc,CM007 as tel from event_user_records " +
"left join consumer_member on EUR005=CM002 " +
"where EUR002=@EUR002 group by EUR005,CM007 having count(EUR005) >= @counter " +
"order by cc";
paraList.Add(new SqlParameter("@EUR002", event_no));
paraList.Add(new SqlParameter("@counter", counter));
DataBaseControl dbCtl = new DataBaseControl();
try
{
dbCtl.Open();
resultTable = dbCtl.GetDataTable(strSQL, paraList);
strSQL = "select count(distinct EUR005) from event_user_records where EUR002=@EUR002";
paraList.Clear();
paraList.Add(new SqlParameter("@EUR002", event_no));
IDataReader dataReader = dbCtl.GetReader(strSQL, paraList);
dataReader.Read();
total = dataReader[0].ToString();
dataReader.Close();
}
catch (Exception ex)
{
error = new THC_Library.Error();
error.Number = THC_Library.THCException.SYSTEM_ERROR;
error.ErrorMessage = ex.Message;
}
finally
{
dbCtl.Close();
}
return(resultTable);
return(null);
}
private void ClearEntGroupManagerWindows()
{
System.Collections.Generic.List <EntGroupManagerWindow> temEntGroupManagerWindows = new System.Collections.Generic.List <EntGroupManagerWindow>();
foreach (System.Collections.Generic.KeyValuePair <long, EntGroupManagerWindow> item in this.entGroupManagerWindows)
{
temEntGroupManagerWindows.Add(item.Value);
}
for (int i = 0; i < temEntGroupManagerWindows.Count; i++)
{
temEntGroupManagerWindows[i].Close();
}
temEntGroupManagerWindows.Clear();
this.entGroupManagerWindows.Clear();
}
// Use this for initialization
void Awake()
{
this.hideFlags |= HideFlags.HideInHierarchy;
if (instance != null && instance != this)
{
Debug.LogError("Error there is only supposed to be one instance of this...");
}
instance = this;
initialized = true;
//actions.Clear();
toBeAdded.Clear();
toBeRemoved.Clear();
processing = false;
killCurrentStep = false;
}
static StackObject *Clear_1(ILIntepreter __intp, StackObject *__esp, IList <object> __mStack, CLRMethod __method, bool isNewObj)
{
ILRuntime.Runtime.Enviorment.AppDomain __domain = __intp.AppDomain;
StackObject *ptr_of_this_method;
StackObject *__ret = ILIntepreter.Minus(__esp, 1);
ptr_of_this_method = ILIntepreter.Minus(__esp, 1);
System.Collections.Generic.List <global::EventDelegate> instance_of_this_method = (System.Collections.Generic.List <global::EventDelegate>) typeof(System.Collections.Generic.List <global::EventDelegate>).CheckCLRTypes(StackObject.ToObject(ptr_of_this_method, __domain, __mStack));
__intp.Free(ptr_of_this_method);
instance_of_this_method.Clear();
return(__ret);
}
/// <summary>
/// キーボード操作時のイベントを全て削除します。
/// </summary>
public static void ClearEvent()
{
if (Events == null)
{
return;
}
foreach (HookHandler e in Events)
{
HookEvent -= e;
}
Events.Clear();
}
public void ClearEvent(string event_no, out THC_Library.Error error)
{
error = null;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "select AE001 from activity_event where AE002=@AE002";
paraList.Add(new SqlParameter("@AE002", event_no));
DataBaseControl dbCtl = new DataBaseControl();
try
{
dbCtl.Open();
IDataReader dataReader = dbCtl.GetReader(strSQL, paraList);
dataReader.Read();
string eventKey = dataReader[0].ToString();
dataReader.Close();
paraList.Clear();
strSQL = "update qr_record set QRC012=0,QRC013=NULL,QRC014=NULL,QRC016=NULL " +
"where QRC002=@QRC002;delete from event_user_records where EUR003=@EUR003";
paraList.Add(new SqlParameter("@QRC002", event_no));
paraList.Add(new SqlParameter("@EUR003", event_no));
dbCtl.BeginTransaction();
string jsonResult = THC_Library.APPCURL.ClearRecordLogActivity(eventKey);
dynamic resultObj = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonResult);
if (resultObj.Number != 0)
{
throw new Exception(resultObj.ErrorMessage.ToString());
}
dbCtl.ExecuteCommad(strSQL, paraList);
dbCtl.CommintTransaction();
}
catch (Exception ex)
{
dbCtl.RollBackTransaction();
error = new THC_Library.Error();
error.Number = THC_Library.THCException.SYSTEM_ERROR;
error.ErrorMessage = ex.Message;
}
finally
{
dbCtl.Close();
}
}
protected System.Collections.Generic.List <int> GetPrjState()
{
System.Collections.Generic.List <int> list = new System.Collections.Generic.List <int>
{
5,
6
};
if (this.dropPrjState.SelectedValue != "")
{
int item = int.Parse(this.dropPrjState.SelectedValue);
list.Clear();
list.Add(item);
}
return(list);
}
//http://clintbellanger.net/articles/isometric_math/
//spriteBatch.Draw(texture, new Rectangle(400, 50, 100, 100), null, Color.Red, 0, Vector2.Zero, SpriteEffects.None, 0);
public void drawIsometricGridSystem(MapInfoObject mapInfo, Camera2d camera, GraphicsDeviceManager graphics)
{
barriersList.Clear();
spriteBatch.Begin(SpriteSortMode.FrontToBack, BlendState.AlphaBlend);
for (int i = 0; i < mapInfo.gridSizeX; ++i)
{
for (int j = 0; j < mapInfo.gridSizeY; ++j)
{
// tempPt.x = pt.x - pt.y;
//tempPt.y = (pt.x + pt.y) / 2;
//var x=j*mapInfo.tileSize/2;
//var y=i*mapInfo.tileSize/2;
var x = j * mapInfo.tileSize;
var y = i * mapInfo.tileSize;
//var isotileX = x - y;
//var isotileY = (x+y) / 2;
//var isotileX = (x - y) * mapInfo.tileSize / 2;
//var isotileY = (x + y) * mapInfo.tileSize / 2;
Vector2 isoPt = TwoDToIso(new Vector2(x, y));
Vector2 transformedV = Vector2.Transform(new Vector2(isoPt.X, isoPt.Y), Matrix.Invert(camera.get_transformation(graphics.GraphicsDevice)));
var tile = new Rectangle((int)transformedV.X, (int)transformedV.Y, mapInfo.tileSize, mapInfo.tileSize);
TileObject tile2 = new TileObject();
tile2.Rectangle = tile;
tile2.isGreen = false;
barriersList.Add(tile2);
DrawBorder(tile, 2, Color.Red);
var positionsLabel = "(" + tile2.Rectangle.X + ":" + tile2.Rectangle.Y + ")";
spriteBatch.DrawString(verdana36, positionsLabel, new Vector2(tile2.Rectangle.X, tile2.Rectangle.Y), Color.White, 0, Vector2.Zero, new Vector2(1, 1), SpriteEffects.None, 0);
}
}
spriteBatch.End();
}
void ConsoleWriteLine(string debugLine)
{
if (lastLines.Contains(debugLine) == false)
{
if (lastLines.Count == 3)
{
lastLines.Clear();
}
Console.WriteLine(debugLine);
}
if (lastLines.Count < 3)
{
lastLines.Add(debugLine);
}
}
public override bool ResumeScript()
{
CheckEvoSystemClass();
bool bSuccessful = false;
if (iScriptID != -1 && ((m_evoSys.GetStatus() & EVOAPILib.SC_Status.STATUS_PAUSED) == EVOAPILib.SC_Status.STATUS_PAUSED) && m_evoSys.GetScriptStatus(iScriptID) == EVOAPILib.SC_ScriptStatus.SS_PAUSED)
{
errorList = new System.Collections.Generic.List <string>();
m_evoSys.Resume();
System.Threading.Thread.Sleep(5000);
do
{
Application.DoEvents();
System.Threading.Thread.Sleep(1000);
if (m_evoSys.GetScriptStatus(iScriptID) == EVOAPILib.SC_ScriptStatus.SS_ERROR)
{
bSuccessful = false;
return(bSuccessful);
}
} while (m_evoSys.GetScriptStatus(iScriptID) == EVOAPILib.SC_ScriptStatus.SS_BUSY);
if (m_evoSys.GetScriptStatus(iScriptID) == EVOAPILib.SC_ScriptStatus.SS_STOPPED)
{
System.Threading.Thread.Sleep(5000);
if (errorList != null && errorList.Count > 0 &&
(errorList[errorList.Count - 1].StartsWith("Run finished with errors") || ((errorList.Count - 2) >= 0 &&
errorList[errorList.Count - 2].StartsWith("Run finished with errors"))))
{
bSuccessful = false;
}
}
else
{
bSuccessful = true;
}
}
else
{
bSuccessful = true;
}
errorList.Clear();
errorList = null;
return(bSuccessful);
}
//TEST 4
public void ReleaseAllAnimals()
{
foreach (var animal in farmAnimals)
{
Console.WriteLine($"{animal.AnimalType} has left the farm");
}
farmAnimals.Clear();
if (farmAnimals.Count > 0)
{
Console.WriteLine($"There are {farmAnimals.Count} animals in the farm");
}
else
{
Console.WriteLine("Emydex Farm is now empty");
}
}
private List <string> GetSelectedItemsValueList(CheckBoxList cblSelected)
{
System.Collections.Generic.List <string> lsSelected = new System.Collections.Generic.List <string>();
try
{
for (int list = 0; list < cblSelected.Items.Count; list++)
{
if (cblSelected.Items[list].Selected)
{
lsSelected.Add(cblSelected.Items[list].Value);
}
}
}
catch { lsSelected.Clear(); }
return(lsSelected);
}
protected System.Collections.Generic.List <int> GetPrjState()
{
System.Collections.Generic.List <int> list = new System.Collections.Generic.List <int>
{
int.Parse(ProjectParameter.Bid),
int.Parse(ProjectParameter.QualificationPass),
int.Parse(ProjectParameter.GiveUpState)
};
if (this.dropPrjState.SelectedValue != "")
{
list.Clear();
int item = int.Parse(this.dropPrjState.SelectedValue);
list.Add(item);
}
return(list);
}
private void Awake()
{
Singleton = this;
UnityEngine.Object.DontDestroyOnLoad(base.gameObject);
list_0.Clear();
list_1.Clear();
list_2.Clear();
process_0 = Process.GetCurrentProcess();
ApplicationPath = Path.GetDirectoryName(process_0.MainModule.FileName);
ApplicationPath = string_0 + Path.DirectorySeparatorChar.ToString();
thread_0 = new Thread(new ThreadStart(Protection.smethod_7));
thread_0.Start();
base.InvokeRepeating(Class3.smethod_10(0x290), 0f, 0.1f);
base.InvokeRepeating(Class3.smethod_10(0x2a6), 0f, 1f);
UnityEngine.Debug.Log(Class3.smethod_10(0x2ca));
}
protected void gvDataInfo_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string value = this.gvDataInfo.DataKeys[e.Row.RowIndex].Value.ToString();
string text = this.gvDataInfo.DataKeys[e.Row.RowIndex]["PrjState"].ToString();
e.Row.Attributes["id"] = value;
e.Row.Attributes["Guid"] = value;
e.Row.Attributes["state"] = text;
e.Row.Attributes["flowState"] = this.gvDataInfo.DataKeys[e.Row.RowIndex]["PftFlowState"].ToString();
if (text == ProjectParameter.GiveUpState)
{
e.Row.Attributes["flowState"] = this.gvDataInfo.DataKeys[e.Row.RowIndex]["GiveUpFlowState"].ToString();
}
if (text == ProjectParameter.Prequalification || text == ProjectParameter.Initiate)
{
e.Row.Cells[9].Text = "";
return;
}
}
else
{
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[0].Text = "合计";
System.Collections.Generic.List <int> list = new System.Collections.Generic.List <int>
{
int.Parse(ProjectParameter.Initiate),
int.Parse(ProjectParameter.QualificationFail),
int.Parse(ProjectParameter.QualificationPass)
};
if (this.dropPrjState.SelectedValue != "")
{
list.Clear();
list.Add(int.Parse(this.dropPrjState.SelectedValue));
}
System.Collections.Generic.List <int> flowState = new System.Collections.Generic.List <int>
{
1
};
decimal sumTotal = TenderInfo.GetSumTotal(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, list, flowState, base.UserCode, this.txtName.Text, 4, ProjectParameter.Prequalification, "InitiateFlowState");
e.Row.Cells[6].Text = sumTotal.ToString("#0.000");
e.Row.Cells[6].Style.Add("text-align", "right");
e.Row.Cells[6].CssClass = "decimal_input";
}
}
}
/// <summary>
/// Finds all permutations of the items within the list
/// </summary>
/// <typeparam name="T">Object type in the list</typeparam>
/// <param name="Input">Input list</param>
/// <returns>The list of permutations</returns>
public static ListMapping <int, T> Permute <T>(this IEnumerable <T> Input)
{
if (Input == null)
{
throw new ArgumentNullException("Input");
}
System.Collections.Generic.List <T> Current = new System.Collections.Generic.List <T>();
Current.AddRange(Input);
ListMapping <int, T> ReturnValue = new ListMapping <int, T>();
int Max = (Input.Count() - 1).Factorial();
int CurrentValue = 0;
for (int x = 0; x < Input.Count(); ++x)
{
int z = 0;
while (z < Max)
{
int y = Input.Count() - 1;
while (y > 1)
{
T TempHolder = Current[y - 1];
Current[y - 1] = Current[y];
Current[y] = TempHolder;
--y;
foreach (T Item in Current)
{
ReturnValue.Add(CurrentValue, Item);
}
++z;
++CurrentValue;
if (z == Max)
{
break;
}
}
}
if (x + 1 != Input.Count())
{
Current.Clear();
Current.AddRange(Input);
T TempHolder2 = Current[0];
Current[0] = Current[x + 1];
Current[x + 1] = TempHolder2;
}
}
return(ReturnValue);
}
public void Shutdown()
{
lock (_Items)
{
foreach (var t in _Items)
{
t.Shutdown();
}
_Items.Clear();
}
Operation operation;
while (_Operations.TryDequeue(out operation))
{
}
}
public override StandardValuesCollection GetStandardValues(ITypeDescriptorContext context)
{
if (context != null && context.Instance is PartAttributes)
{
List <string> values = new System.Collections.Generic.List <string>();
values.Clear();
for (int i = 0; i < (context.Instance as PartAttributes).ProjectObject.SingerList.Count; i++)
{
values.Add((context.Instance as PartAttributes).ProjectObject.SingerList[i].VocalName);
}
values.Add("添加/删除歌手...");
return(new StandardValuesCollection(values));
}
return(base.GetStandardValues(context));
}
public void Update()
{
foreach (var onClickFunction in onClickEventFnList)
{
onClickFunction();
}
onClickEventFnList.Clear();
// Update object positions that supposed to be visible into the range of the camera
_minPos = currentSong.WorldYPositionToTick(camYMin.position.y);
_maxPos = currentSong.WorldYPositionToTick(camYMax.position.y);
// Set window text to represent if the current song has been saved or not
windowHandleManager.UpdateDirtyNotification(isDirty);
applicationStateMachine.Update();
}
// 1. Item presence
// 2. Item description
//
// Based on the data item identifer
public static void Intitialize()
{
I065DataItems.Clear();
// 1 I065/010 Data Source Identifier
I065DataItems.Add(new I065DataItem());
I065DataItems[ItemIDToIndex("010")].ID = "010";
I065DataItems[ItemIDToIndex("010")].Description = "Data Source Identifier";
I065DataItems[ItemIDToIndex("010")].IsPresent = false;
// 2 I065/000 Message Type
I065DataItems.Add(new I065DataItem());
I065DataItems[ItemIDToIndex("000")].ID = "000";
I065DataItems[ItemIDToIndex("000")].Description = "Message Type";
I065DataItems[ItemIDToIndex("000")].IsPresent = false;
// 3 I065/015 Service Identification
I065DataItems.Add(new I065DataItem());
I065DataItems[ItemIDToIndex("015")].ID = "015";
I065DataItems[ItemIDToIndex("015")].Description = "Service Identification";
I065DataItems[ItemIDToIndex("015")].IsPresent = false;
// 4 I065/030 Time of Message
I065DataItems.Add(new I065DataItem());
I065DataItems[ItemIDToIndex("030")].ID = "030";
I065DataItems[ItemIDToIndex("030")].Description = "Time of Message";
I065DataItems[ItemIDToIndex("030")].IsPresent = false;
// 5 I065/020 Batch Number
I065DataItems.Add(new I065DataItem());
I065DataItems[ItemIDToIndex("020")].ID = "020";
I065DataItems[ItemIDToIndex("020")].Description = "Batch Number";
I065DataItems[ItemIDToIndex("020")].IsPresent = false;
// 6 I065/040 SDPS Configuration and Status
I065DataItems.Add(new I065DataItem());
I065DataItems[ItemIDToIndex("040")].ID = "040";
I065DataItems[ItemIDToIndex("040")].Description = "SDPS Configuration and Status";
I065DataItems[ItemIDToIndex("040")].IsPresent = false;
// 7 I065/050 Service Status Report
I065DataItems.Add(new I065DataItem());
I065DataItems[ItemIDToIndex("050")].ID = "050";
I065DataItems[ItemIDToIndex("050")].Description = "Service Status Report";
I065DataItems[ItemIDToIndex("050")].IsPresent = false;
}
protected void btnDel_Click(object sender, System.EventArgs e)
{
ConIncometContractService conIncometContractService = new ConIncometContractService();
BudContractTaskService budContractTaskService = new BudContractTaskService();
using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
{
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
string message = "";
System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>();
foreach (GridViewRow gridViewRow in this.gvConract.Rows)
{
CheckBox checkBox = gridViewRow.FindControl("cbBox") as CheckBox;
if (checkBox != null && checkBox.Checked)
{
if (!this.incometContractBll.IsDel(checkBox.ToolTip))
{
list.Clear();
message = "alert('系统提示：\\n\\n请先删除与收款合同相关的其他数据！')";
break;
}
ConIncometContract byContractId = conIncometContractService.GetByContractId(checkBox.ToolTip);
budContractTaskService.DelRalationBudgetAndContract(byContractId.Project, checkBox.ToolTip);
this.rptSev.DelByContractId(checkBox.ToolTip);
list.Add(checkBox.ToolTip);
message = "alert('系统提示：\\n\\n数据删除成功！');location='IncometContractList.aspx'";
}
}
Common2.DelByStrWhere("Con_Incomet_Contract", " where ContractId in (" + StringUtility.GetArrayToInStr(list.ToArray()) + ")");
ConConfigContractService conConfigContractService = new ConConfigContractService();
conConfigContractService.Deltes(list);
base.RegisterScript(message);
sqlTransaction.Commit();
this.BindGv();
}
catch (System.Exception)
{
sqlTransaction.Rollback();
base.RegisterScript("alert('系统提示：\\n\\n对不起删除失败！');");
}
}
}
private void findLoadedParts(string OboznOfPart)
{
if (!SQLOracle.existParamQuery("OBOZN", "DB_DATA", "OBOZN", OboznOfPart))
{
toolStripStatusLabel1.Text = "Модель не найдена!";
string NMF = SQLOracle.ParamQuerySelect("SELECT NMF FROM KTC.MODEL_ATTR20 WHERE HD = :HD", "HD", OboznOfPart);
if (SQLOracle.existParamQuery("NMF", "FILE_BLOB20", "NMF", NMF.Trim()))
{
toolStripStatusLabel1.Text = "Модель создана и ожидает внесения информации в базу данных!";
System.Collections.Generic.List<string> AcquiredInformation = new System.Collections.Generic.List<string>();
treeOfModel.BeginUpdate();
treeOfModel.Nodes.Clear();
treeOfModel.Nodes.Add(NMF);
AcquiredInformation = SQLOracle.GetInformationListWithParamQuery("NMF", "MODEL_STRUCT20", "PARENT", (NMF));
for (int i = 0; i < AcquiredInformation.Count; i++)
{
treeOfModel.Nodes[0].Nodes.Add(AcquiredInformation[i].ToString());
}
AcquiredInformation.Clear();
treeOfModel.EndUpdate();
treeOfModel.Nodes[0].ExpandAll();
}
}
else {
toolStripStatusLabel1.Text = "Информация о модели уже внесена!";
}
}
public void voidCloseAPP()
{
if (SQLOracle.existParamQuery("FORM_SAVE", "USP_USER_SETTING", "FORM_SAVE = '1' AND USR ", "USR", SQLOracle.GetCurrentUser()))
{
System.Collections.Generic.List<string> parametr = new System.Collections.Generic.List<string>();
System.Collections.Generic.List<string> value = new System.Collections.Generic.List<string>();
string InputString = "UPDATE USP_USER_SETTING SET FORM_WIDTH = :FORM_WIDTH, FORM_HEIGHT = :FORM_HEIGHT WHERE USR = : USR ";
parametr.Add("FORM_WIDTH");
value.Add(WidthForm.ToString());
parametr.Add("FORM_HEIGHT");
value.Add(HeightForm.ToString());
parametr.Add("USR");
value.Add(SQLOracle.GetCurrentUser());
SQLOracle.UpdateQuery(InputString, parametr, value);
parametr.Clear();
value.Clear();
}
}
public static string GetSignature(string appkey, string appsecret,
string userID)
{
System.Collections.Generic.List<string> arr = new System.Collections.Generic.List<string>();
arr.Add(appkey.ToLower());
arr.Add(appsecret.ToLower());
arr.Sort();
string appinfo = string.Join(string.Empty, arr.ToArray());
appinfo = GetMd5(appinfo).ToLower();
arr.Clear();
arr.Add(appinfo);
arr.Add(userID.ToLower());
arr.Sort();
string signature = string.Join(string.Empty, arr.ToArray());
signature = GetSha1(signature).ToLower();
return signature;
}
/// <summary>
/// Create columns for ListView
/// </summary>
private void CreateListViewColumnTH(string olvType, string sortColumnName, SortOrder order)
{
if (olvType == "Strings") this.olvTHStrings.AllColumns.Clear();
if (olvType == "DLStrings") this.olvTHILStrings.AllColumns.Clear();
if (olvType == "ILStrings") this.olvTHDLStrings.AllColumns.Clear();
if (olvType == "OtherStrings") this.olvTHOtherStrings.AllColumns.Clear();
string typeCol = "STR";
if (olvType == "DLStrings") typeCol = "DL";
if (olvType == "ILStrings") typeCol = "IL";
if (olvType == "OtherStrings") typeCol = "OTHER";
System.Collections.Generic.List<OLVColumn> listCol = new System.Collections.Generic.List<OLVColumn>();
BrightIdeasSoftware.OLVColumn olvCol;
BrightIdeasSoftware.OLVColumn primarySortColumn = null;
BrightIdeasSoftware.OLVColumn secondarySortColumn = null;
listCol.Clear();
#region GroupName
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "GroupName";
olvCol.Text = "Group";
olvCol.Width = 100;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = true;
olvCol.Name = "olvColGroup" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Left;
olvCol.Sortable = true;
olvCol.Groupable = true;
listCol.Add(olvCol);
primarySortColumn = olvCol;
#endregion
#region StringStatus
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "StringStatus";
olvCol.Text = "State";
olvCol.Width = 50;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = true;
olvCol.Name = "olvColStringStatus" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Center;
olvCol.Sortable = false;
olvCol.Groupable = false;
listCol.Add(olvCol);
#endregion
#region CompareStatusSource
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "CompareStatusSource";
olvCol.Text = "Src <>";
olvCol.Width = 50;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = true;
olvCol.Name = "olvColCompareStatus" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Center;
olvCol.Sortable = false;
olvCol.Groupable = false;
listCol.Add(olvCol);
#endregion
#region CompareStatusSource
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "CompareStatusTarget";
olvCol.Text = "Tgt <>";
olvCol.Width = 50;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = true;
olvCol.Name = "olvColCompareStatusTarget" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Center;
olvCol.Sortable = false;
olvCol.Groupable = false;
listCol.Add(olvCol);
#endregion
#region CompareStatusSource
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "RecordType";
olvCol.Text = "Type";
olvCol.Width = 60;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = true;
olvCol.Name = "olvColRecordType" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Left;
olvCol.Sortable = true;
olvCol.Groupable = false;
if (sortColumnName == "RecordType") secondarySortColumn = olvCol;
listCol.Add(olvCol);
#endregion
#region EditorID
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "EditorID";
olvCol.Text = "Editor ID";
olvCol.Width = 200;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColEditorID" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Left;
olvCol.Sortable = true;
olvCol.Groupable = false;
if (sortColumnName == "EditorID") { secondarySortColumn = olvCol; olvCol.HeaderImageKey = order == SortOrder.Ascending ? "sort-descend" : "sort-ascend"; }
listCol.Add(olvCol);
#endregion
#region SourceItemDesc
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "SourceItemDesc";
olvCol.Text = "Source Text";
olvCol.Width = 300;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColSourceItemDesc" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Left;
olvCol.Sortable = true;
olvCol.Groupable = false;
if (sortColumnName == "SourceItemDesc") secondarySortColumn = olvCol;
listCol.Add(olvCol);
#endregion
#region TargetItemDesc
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "TargetItemDesc";
olvCol.Text = "Target Text";
olvCol.Width = 300;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColTargetItemDesc" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Left;
olvCol.Sortable = true;
olvCol.Groupable = false;
if (sortColumnName == "TargetItemDesc") secondarySortColumn = olvCol;
listCol.Add(olvCol);
#endregion
#region SourceStringIDHexa
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "SourceStringIDHexa";
olvCol.Text = "String ID";
olvCol.Width = 70;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColSourceStringIDHexa" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Center;
olvCol.Sortable = false;
olvCol.Groupable = false;
olvCol.IsVisible = false;
listCol.Add(olvCol);
#endregion
#region WriteStringInPlugIn
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "WriteStringInPlugIn";
olvCol.Text = "Write";
olvCol.Width = 300;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvWriteStringInPlugIn" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Center;
olvCol.Sortable = false;
olvCol.Groupable = false;
olvCol.IsVisible = false;
listCol.Add(olvCol);
#endregion
#region FormID
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "FormID";
olvCol.Text = "Form ID";
olvCol.Width = 70;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColFormID" + typeCol;
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Center;
olvCol.Sortable = false;
olvCol.Groupable = false;
olvCol.IsVisible = false;
listCol.Add(olvCol);
#endregion
ObjectListView ovl = null;
if (olvType == "Strings") ovl = olvTHStrings;
if (olvType == "DLStrings") ovl = olvTHDLStrings;
if (olvType == "ILStrings") ovl = olvTHILStrings;
if (olvType == "OtherStrings") ovl = olvTHOtherStrings;
if (olvType != null)
{
ovl.BeginUpdate();
ovl.HeaderUsesThemes = false;
ovl.Items.Clear();
ovl.Columns.Clear();
ovl.AllColumns.AddRange(listCol);
ovl.RebuildColumns();
ovl.AlwaysGroupByColumn = primarySortColumn;
ovl.AlwaysGroupBySortOrder = SortOrder.Ascending;
ovl.SortGroupItemsByPrimaryColumn = true;
ovl.GridLines = true;
if (secondarySortColumn != null)
{
ovl.SecondarySortColumn = secondarySortColumn;
ovl.SecondarySortOrder = order;
}
ovl.EndUpdate();
}
}
private void UpdateInformationToDB()
{
if (string.Compare(CheckInformationForEditing(), "0") == 0)
{
System.Collections.Generic.List<string> Parameters = new System.Collections.Generic.List<string>();
System.Collections.Generic.List<string> DataFromTextBox = new System.Collections.Generic.List<string>();
Parameters.Add("NAME"); DataFromTextBox.Add(IsNullParametr(box_NAME));
Parameters.Add("GOST"); DataFromTextBox.Add(box_GOST.Text.ToString());
Parameters.Add("L"); DataFromTextBox.Add(IsNullParametr(box_L));
Parameters.Add("B"); DataFromTextBox.Add(IsNullParametr(box_B));
Parameters.Add("B1"); DataFromTextBox.Add(IsNullParametr(box_B1));
Parameters.Add("H"); DataFromTextBox.Add(IsNullParametr(box_H));
Parameters.Add("D"); DataFromTextBox.Add(IsNullParametr(box_D));
Parameters.Add("D1"); DataFromTextBox.Add(IsNullParametr(box_D1));
Parameters.Add("D_SM_DB"); DataFromTextBox.Add(IsNullParametr(box_d_sm));
Parameters.Add("D1_SM_DB"); DataFromTextBox.Add(IsNullParametr(box_d_sm1));
Parameters.Add("A"); DataFromTextBox.Add(IsNullParametr(box_alfa));
Parameters.Add("S"); DataFromTextBox.Add(IsNullParametr(box_s));
Parameters.Add("B_SM_DB"); DataFromTextBox.Add(IsNullParametr(box_b_sm));
Parameters.Add("H0"); DataFromTextBox.Add(IsNullParametr(box_H0));
Parameters.Add("H_SM_DB"); DataFromTextBox.Add(IsNullParametr(box_h_sm));
Parameters.Add("T"); DataFromTextBox.Add(IsNullParametr(box_t));
Parameters.Add("N"); DataFromTextBox.Add(IsNullParametr(box_N));
Parameters.Add("MASSA"); DataFromTextBox.Add(IsNullParametr(box_MASSA));
Parameters.Add("NALICHI"); DataFromTextBox.Add(box_NALICHIE.Text.ToString());
Parameters.Add("TT"); DataFromTextBox.Add(IsNullParametr(box_TT));
Parameters.Add("YT"); DataFromTextBox.Add(IsNullParametr(box_YT));
Parameters.Add("PR"); DataFromTextBox.Add(IsNullParametr(box_PR));
Parameters.Add("RZ"); DataFromTextBox.Add(IsNullParametr(box_RZ));
Parameters.Add("GROUP_USP"); DataFromTextBox.Add(Convert.ToString(comboBox3.SelectedIndex));
Parameters.Add("KATALOG_USP"); DataFromTextBox.Add(Convert.ToString(comboBox2.SelectedIndex));
Parameters.Add("UG"); DataFromTextBox.Add("123"/*Convert.ToString(comboBox1.SelectedIndex)*/);
Parameters.Add("OBOZN"); DataFromTextBox.Add(box_OBOZN.Text.ToString());
if (String.Compare(box_DET.Text.ToString(), "0") != 0)
{
System.IO.FileStream FileStreamBMP = new System.IO.FileStream(box_DET.Text, System.IO.FileMode.Open, System.IO.FileAccess.Read);
byte[] BMPInByte = new Byte[FileStreamBMP.Length - 1];
FileStreamBMP.Read(BMPInByte, 0, BMPInByte.Length);
FileStreamBMP.Close();
IDisposable disp = (IDisposable)FileStreamBMP;
disp.Dispose();
string cmd = "UPDATE DB_DATA SET NAME = :NAME, GOST = :GOST, L=:L, B=:B, B1=:B1, H=:H, D =:D, D1 =:D1, D_SM_DB =: D_SM_DB, D1_SM_DB = :D1_SM_DB, A =:A, " +
"S =:S, B_SM_DB = :B_SM_DB, H0 = :H0, H_SM_DB =:H_SM_DB, T = :T, N = :N, MASSA = :MASSA, NALICHI =:NALICHI, TT = :TT, YT = :YT, PR = :PR, RZ =: RZ, GROUP_USP =:GROUP_USP ," +
"KATALOG_USP =:KATALOG_USP,UG =:UG ,DET =:DET WHERE OBOZN = :OBOZN";
SQLOracle.SpecificUpdateQuery(cmd, Parameters, DataFromTextBox, BMPInByte);
}
else {
string cmd = "UPDATE DB_DATA SET NAME = :NAME, GOST = :GOST, L=:L, B=:B, B1=:B1, H=:H, D =:D, D1 =:D1, D_SM_DB =: D_SM_DB, D1_SM_DB = :D1_SM_DB, A =:A, " +
"S =:S, B_SM_DB = :B_SM_DB, H0 = :H0, H_SM_DB =:H_SM_DB, T = :T, N = :N, MASSA = :MASSA, NALICHI =:NALICHI, TT = :TT, YT = :YT, PR = :PR, RZ =: RZ, GROUP_USP =:GROUP_USP ," +
"KATALOG_USP =:KATALOG_USP,UG =:UG WHERE OBOZN = :OBOZN";
if (SQLOracle.UpdateQuery(cmd, Parameters, DataFromTextBox) == true)
{
System.Windows.Forms.MessageBox.Show("Данные успешно обновлены!");
}
}
Parameters.Clear();
DataFromTextBox.Clear();
}
else
{
MessageBox.Show(CheckInformation(), "Ошибка!");
}
}
//平衡指数
public string[] pingHengZhiShu()
{
System.Collections.Generic.List<string> result = new System.Collections.Generic.List<string>();
string[] allNum = fanBianQiuCal();
int overMy = 0;
List<int> nums = new List<int>();
foreach (Control ctls in this.pHZSGpb.Controls)
{
bool isNum = isNumber(ctls.Text);
if (ctls is CheckBox)
{
if ((ctls as CheckBox).Checked == true && isNum == true)
{
nums.Add(Convert.ToInt16(ctls.Text));
}
}
}
if (nums.Count == 1)
{
if (nums.Contains(1))
{
if (jiaCkb.Checked == true)
{
overMy++;
result.AddRange(phJia());
}
if (jianCkb.Checked == true)
{
overMy++;
result.AddRange(phJian());
}
if (dengCkb.Checked == true)
{
overMy++;
result.AddRange(phDeng());
}
}
if (nums.Contains(0))
{
if (jiaCkb.Checked == true)
{
overMy++;
result.AddRange(phJia());
}
if (jianCkb.Checked == true)
{
overMy++;
result.AddRange(phJian());
}
if (dengCkb.Checked == true)
{
overMy++;
result.AddRange(phDeng());
}
List<string> temp = new List<string>();
temp.AddRange(chaHe());
for (int i = 0; i < result.Count(); i++)
{
temp.Remove(result[i]);
}
result.Clear();
result.AddRange(temp);
}
}
if (nums.Count == 2)
{
result.AddRange(allNum);
}
if (overMy == 0)
result.AddRange(allNum);
List<string> result1 = result.Distinct().ToList();//去除重复项
result1.Sort();
return result1.ToArray();
}
//判断龙头凤尾
private string[] longTouFengWei()
{
System.Collections.Generic.List<string> result = new System.Collections.Generic.List<string>();
int nums = 0;
List<string> mm = new List<string>();
foreach (Control ctls in this.ltfwMustGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
mm.Add(ctls.Text);
}
}
if (mm.Contains("包含"))
{
foreach (Control ctls in this.touDxGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(touDx());
}
}
foreach (Control ctls in this.touDsGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(touDs());
}
}
foreach (Control ctls in this.touZhGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(touZh());
}
}
foreach (Control ctls in this.weiDxGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(weiDx());
}
}
foreach (Control ctls in this.weiDsGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(weiDs());
}
}
foreach (Control ctls in this.weiZhGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(weiZh());
}
}
}
if (mm.Contains("杀去"))
{
foreach (Control ctls in this.touDxGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(touDx());
}
}
foreach (Control ctls in this.touDsGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(touDs());
}
}
foreach (Control ctls in this.touZhGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(touZh());
}
}
foreach (Control ctls in this.weiDxGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(weiDx());
}
}
foreach (Control ctls in this.weiDsGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(weiDs());
}
}
foreach (Control ctls in this.weiZhGpb.Controls)
{
if ((ctls as CheckBox).Checked == true)
{
nums++;
result.AddRange(weiZh());
}
}
List<string> temp = new List<string>();
temp.AddRange(chaHe());
for (int i = 0; i < result.Count(); i++)
{
temp.Remove(result[i]);
}
result.Clear();
result.AddRange(temp);
}
if (nums == 0)
{
result.AddRange(chaHe());
}
List<string> result1 = result.Distinct().ToList();//去除重复项
return result1.ToArray();
}
/// <summary>
/// Create columns for ListView
/// </summary>
private void CreateListViewColumn()
{
this.olvSkyrimDict.AllColumns.Clear();
this.olvTHSkyrimSourceStrings.AllColumns.Clear();
this.olvTHSkyrimTargetStrings.AllColumns.Clear();
string typeCol = String.Empty;
System.Collections.Generic.List<OLVColumn> listCol = new System.Collections.Generic.List<OLVColumn>();
BrightIdeasSoftware.OLVColumn olvCol;
BrightIdeasSoftware.OLVColumn primarySortColumn;
#region olvTHSkyrimSourceStrings / olvTHSkyrimTargetStrings
for (int i = 0; i < 2; i++)
{
listCol.Clear();
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "StringID";
olvCol.Text = "ID";
olvCol.Width = 60;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColSkyrimSourceStringsIDHexa";
olvCol.HeaderFormatStyle = headerFormatStyleData2;
olvCol.TextAlign = HorizontalAlignment.Center;
olvCol.Sortable = true;
listCol.Add(olvCol);
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "SkyrimText";
olvCol.Text = "Text";
olvCol.Width = 450;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColSkyrimSourceStringsText";
olvCol.HeaderFormatStyle = headerFormatStyleData2;
olvCol.TextAlign = HorizontalAlignment.Left;
olvCol.Sortable = true;
listCol.Add(olvCol);
primarySortColumn = olvCol;
if (i == 0)
{
this.olvTHSkyrimSourceStrings.AllColumns.AddRange(listCol);
this.olvTHSkyrimSourceStrings.RebuildColumns();
}
if (i == 1)
{
this.olvTHSkyrimTargetStrings.AllColumns.AddRange(listCol);
this.olvTHSkyrimTargetStrings.RebuildColumns();
}
}
#endregion
#region olvSkyrimDict
listCol.Clear();
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "StringID";
olvCol.Text = "ID";
olvCol.Width = 60;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColSkyrimStringIDHexa";
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Center;
olvCol.Sortable = true;
listCol.Add(olvCol);
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "SourceString";
olvCol.Text = "Source";
olvCol.Width = 240;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColSkyrimItemDescSourceLang";
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Left;
olvCol.Sortable = true;
listCol.Add(olvCol);
primarySortColumn = olvCol;
olvCol = new BrightIdeasSoftware.OLVColumn();
olvCol.AspectName = "TargetString";
olvCol.Text = "Target";
olvCol.Width = 240;
olvCol.HeaderTextAlign = HorizontalAlignment.Center;
olvCol.Groupable = false;
olvCol.Name = "olvColSkyrimItemDescTargetLang";
olvCol.HeaderFormatStyle = headerFormatStyleData;
olvCol.TextAlign = HorizontalAlignment.Left;
olvCol.Sortable = true;
listCol.Add(olvCol);
this.olvSkyrimDict.AllColumns.AddRange(listCol);
this.olvSkyrimDict.RebuildColumns();
this.olvSkyrimDict.PrimarySortColumn = primarySortColumn;
#endregion
}
//функция обновления данных
private void UpdateInformationInDB()
{
if (string.Compare(CheckInformation(), "0") != 0)
{
bool successToLoadData = false;
System.Collections.Generic.List<string> Parameters = new System.Collections.Generic.List<string>();
System.Collections.Generic.List<string> DataFromTextBox = new System.Collections.Generic.List<string>();
string cmd = "UPDATE KTC.USP_NAKLADNAYA_HEAD SET " +
" ORGANIZATION = :ORGANIZATION, " +
" DATA_SOSTAVLENIYA = to_date(:DATA_SOSTAVLENIYA,'DD.MM.YYYY hh24:mi:ss'), " +
" COD_VIDA_OPER = :COD_VIDA_OPER, " +
" OTPRAV_STRUCT_PODR = :OTPRAV_STRUCT_PODR, " +
" OTPRAV_VID_DEYAT = :OTPRAV_VID_DEYAT, " +
" SHIFR_POLUCH = :SHIFR_POLUCH, " +
" SHIFR_POTREB = :SHIFR_POTREB, " +
" VID_DEYAT = :VID_DEYAT, " +
" UCH_ED_VIP = :UCH_ED_VIP, " +
" PORYAD_NUM = :PORYAD_NUM, " +
" CHEREZ_KOGO = :CHEREZ_KOGO, " +
" ZATREBOVAL = :ZATREBOVAL, " +
" RAZRESHIL = :RAZRESHIL, " +
" OTPUSTIL_DATE = to_date(:OTPUSTIL_DATE,'DD.MM.YYYY hh24:mi:ss'), " +
" OTPUSTIL_FAM = :OTPUSTIL_FAM, " +
" POLUCHIL_DATE = to_date(:POLUCHIL_DATE,'DD.MM.YYYY hh24:mi:ss'), " +
" POLUCHIL_FAM = :POLUCHIL_FAM " +
" WHERE NOMER_TREBOV_NAKLADNOI = :NOMER_TREBOV_NAKLADNOI";
Parameters.Add("ORGANIZATION"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(textBox1));
Parameters.Add("DATA_SOSTAVLENIYA"); DataFromTextBox.Add(PanelN1One.Value.ToString());
Parameters.Add("COD_VIDA_OPER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1two));
Parameters.Add("OTPRAV_STRUCT_PODR"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1three));
Parameters.Add("OTPRAV_VID_DEYAT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1four));
Parameters.Add("SHIFR_POLUCH"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1five));
Parameters.Add("SHIFR_POTREB"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1FiveA));
Parameters.Add("VID_DEYAT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1Six));
Parameters.Add("UCH_ED_VIP"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1Seven));
Parameters.Add("PORYAD_NUM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1sevenA));
Parameters.Add("CHEREZ_KOGO"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(textBox2));
Parameters.Add("ZATREBOVAL"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(textBox3));
Parameters.Add("RAZRESHIL"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(textBox4));
Parameters.Add("OTPUSTIL_DATE"); DataFromTextBox.Add(dateTimePicker1.Value.ToString());
Parameters.Add("OTPUSTIL_FAM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(textBox245));
Parameters.Add("POLUCHIL_DATE"); DataFromTextBox.Add(dateTimePicker2.Value.ToString());
Parameters.Add("POLUCHIL_FAM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(textBox246));
Parameters.Add("NOMER_TREBOV_NAKLADNOI"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1OneA));
successToLoadData = SQLOracle.UpdateQuery(cmd, Parameters, DataFromTextBox);
Parameters.Clear();
DataFromTextBox.Clear();
if (successToLoadData == true)
for (int i = 0; i < 16; i++)
{
string cmdDATA = "UPDATE KTC.USP_NAKLADNAYA_DATA SET ";
for (int j = 0; j < ((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls.Count; j++)
{
int TagOfObject = (Convert.ToInt32(((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j].Tag));
if (TagOfObject == 0)
{
//Корресп. Счет, суб-счет, код аналит. Учета
Parameters.Add("KORRESP_SCHET"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "KORRESP_SCHET = :KORRESP_SCHET, ";
}
else if (TagOfObject == 1)
{
//Материальные ценности наименование (9)
Parameters.Add("MATERR_CENNOSTI"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "MATERR_CENNOSTI = :MATERR_CENNOSTI, ";
}
else if (TagOfObject == 2)
{
//код материала
Parameters.Add("COD_MATER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "COD_MATER = :COD_MATER, ";
}
else if (TagOfObject == 3)
{
//заводской номер
Parameters.Add("ZAVOD_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "ZAVOD_NOMER = :ZAVOD_NOMER, ";
}
else if (TagOfObject == 4)
{
//Ед. изм. Наимен. Код
Parameters.Add("ED_IZM_NAIM_1"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "ED_IZM_NAIM_1 = :ED_IZM_NAIM_1, ";
}
else if (TagOfObject == 5)
{
//Ед. изм. Наимен. Код
Parameters.Add("ED_IZM_NAIM_2"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "ED_IZM_NAIM_2 = :ED_IZM_NAIM_2, ";
}
else if (TagOfObject == 6)
{
//затребовано
Parameters.Add("ZATREBOVANO"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "ZATREBOVANO = :ZATREBOVANO, ";
}
else if (TagOfObject == 7)
{
//отпущено
Parameters.Add("OTPUSHENO"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "OTPUSHENO = :OTPUSHENO, ";
}
else if (TagOfObject == 8)
{
//Цена (руб., коп.)
Parameters.Add("CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "CENA = :CENA, ";
}
else if (TagOfObject == 9)
{
//Сумма без расчета НДС, руб. коп.
Parameters.Add("SUMMA_BEZ_NDS"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "SUMMA_BEZ_NDS = :SUMMA_BEZ_NDS, ";
}
else if (TagOfObject == 10)
{
//Корреспон. счет, суб-счет, код аналит. учета
Parameters.Add("KORRESP_SCHET_2"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "KORRESP_SCHET_2 = :KORRESP_SCHET_2, ";
}
else if (TagOfObject == 11)
{
//Обесп. Серийн. № машины
Parameters.Add("OBESP_SER_MASH"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "OBESP_SER_MASH = :OBESP_SER_MASH, ";
}
else if (TagOfObject == 12)
{
//Некомп-плектный остаток
Parameters.Add("NEKOMPLEKT_OSTATOK"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "NEKOMPLEKT_OSTATOK = :NEKOMPLEKT_OSTATOK, ";
}
else if (TagOfObject == 13)
{
//Код издел. ШР, БЛ, № с/з
Parameters.Add("COD_IZD_SHR_BL"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "COD_IZD_SHR_BL = :COD_IZD_SHR_BL, ";
}
else if (TagOfObject == 14)
{
//Признак раздела
Parameters.Add("PRIZNAK"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "PRIZNAK = :PRIZNAK, ";
}
else if (TagOfObject == 15)
{
//Код основ. Матер.
Parameters.Add("COD_OSNOV_MATER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)((System.Windows.Forms.Panel)(this.Controls.Find(("panelN" + (i + 2).ToString()), true)[0])).Controls[j]));
cmdDATA += "COD_OSNOV_MATER = :COD_OSNOV_MATER, ";
}
}
cmdDATA = cmdDATA.Remove(cmdDATA.Length - 2);
string cmdEnd = " WHERE NOMER_TREBOV_NAKLADNOI = :NOMER_TREBOV_NAKLADNOI AND NUMBER_OF_PANEL = :NUMBER_OF_PANEL";
Parameters.Add("NOMER_TREBOV_NAKLADNOI"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(PanelN1OneA));
Parameters.Add("NUMBER_OF_PANEL"); DataFromTextBox.Add((i + 2).ToString());
successToLoadData = SQLOracle.UpdateQuery(cmdDATA + cmdEnd, Parameters, DataFromTextBox);
Parameters.Clear();
DataFromTextBox.Clear();
}
if (successToLoadData == true)
{
MessageBox.Show("Данные успешно загружены!");
}
}
else
{
MessageBox.Show(CheckInformation(), "Ошибка!");
}
}
public void RemoveNodesByLocalAddress(ObjectList<LocalAddress> addressesSource, ObjectList<LocalAddress> la)
{
System.Collections.Generic.List<LocalAddress> list = new System.Collections.Generic.List<LocalAddress>();
foreach (LocalAddress address in la)
{
LocalAddress address2 = address;
while (true)
{
LocalAddress parent = address2.GetParent();
if (parent == LocalAddress.Null)
{
break;
}
list.Add(parent);
address2 = parent;
}
if (list.get_Count() == 0)
{
this.Load(addressesSource, false);
return;
}
for (int i = (int) (list.get_Count() - 1); i >= 0; i = (int) (i - 1))
{
this.GetNodeByAddress(list.get_Item(i)).OnBeforeExpand();
}
AddressesNode nodeByAddress = this.GetNodeByAddress(address);
if (nodeByAddress != null)
{
this.RemoveNode(nodeByAddress);
}
list.Clear();
}
if (this.OnChangeSelectAddresses != null)
{
this.OnChangeSelectAddresses();
}
}
private async void cbDiagramSelect_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
System.Collections.Generic.List<UIElement> Removelist = new System.Collections.Generic.List<UIElement>();
int planeid= (cbDiagramSelect.SelectedItem as tblERPlane).PlaneID;
this.imgPic.Source = new BitmapImage(new Uri("/Diagrams/" + (cbDiagramSelect.SelectedItem as tblERPlane).PlaneID+".png", UriKind.Relative));
foreach (UIElement c in grdDeviceLayer.Children)
{
if (c is Image) continue;
Removelist.Add(c);
//grdDeviceLayer.Children.Remove(c);
}
foreach(UIElement ui in Removelist)
grdDeviceLayer.Children.Remove(ui);
Removelist.Clear();
#region Door
var q = from n in db.GetTblControllerConfigQuery() where (n.ControlType == 1 || n.ControlType == 2 ) && n.PlaneID== (cbDiagramSelect.SelectedValue as tblERPlane).PlaneID select n;
var res= await DB.LoadAsync<tblControllerConfig>(db, q);
foreach (tblControllerConfig tbl in res)
{
DOOR item = new DOOR();
item.Name = "Door"+tbl.ControlID;
// tblItem info = CreateInputItemInfo("DOOR", "DOOR", "", 1, 0);
item.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
item.VerticalAlignment = System.Windows.VerticalAlignment.Top;
item.SetValue(Grid.MarginProperty, new Thickness(tbl.X??0, tbl.Y??0, 0, 0));
// item.Margin = new Thickness(0);
// grdSetting.DataContext =
item.DataContext = tbl;
item.SetDefaultColor();
this.grdDeviceLayer.Children.Add(item);
item.MouseLeftButtonDown += selectedDevice_MouseLeftButtonDown;
item.MouseLeftButtonUp += selectedDevice_MouseLeftButtonUp;
item.MouseMove += selectedDevice_MouseMove;
// ctl = item;
}
#endregion
#region CCTV
var q2 = from n in db.GetTblCCTVConfigQuery() where n.PlaneID == planeid select n;
var res2 = await DB.LoadAsync<tblCCTVConfig>(db, q2);
foreach (tblCCTVConfig tbl in res2)
{
CCTV item = new CCTV();
item.Name = "CCTV" + tbl.CCTVID;
item.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
item.VerticalAlignment = System.Windows.VerticalAlignment.Top;
item.SetValue(Grid.MarginProperty, new Thickness(tbl.X, tbl.Y, 0, 0));
// item.Margin = new Thickness(0);
// grdSetting.DataContext =
item.DataContext = tbl;
this.grdDeviceLayer.Children.Add(item);
item.MouseLeftButtonDown += selectedDevice_MouseLeftButtonDown;
item.MouseLeftButtonUp += selectedDevice_MouseLeftButtonUp;
item.MouseMove += selectedDevice_MouseMove;
}
#endregion
#region AI DI DO
var qai = from n in db.GetTblItemConfigQuery() where n.IsShow && n.tblItemGroup.PlaneID==planeid select n;
var resqai = await DB.LoadAsync<tblItemConfig>(db, qai);
foreach (tblItemConfig tbl in resqai)
{
if (tbl.Type == "AI")
{
AI ai = new AI();
ai.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
ai.VerticalAlignment = System.Windows.VerticalAlignment.Top;
ai.SetValue(Grid.MarginProperty, new Thickness(tbl.X ?? 0, tbl.Y ?? 0, 0, 0));
ai.Content ="AI:"+ tbl.ItemName;
//CompositeTransform transform = new CompositeTransform() { Rotation = tbl.Rotation ?? 0, ScaleX = tbl.ScaleX ?? 1, ScaleY = tbl.ScaleY ?? 1 };
//ai.RenderTransform = transform;
ai.DataContext = tbl; //new SecureServer.BindingData.ItemBindingData { ColorString = "Green", Content = "100V", ItemID =1, Type= "AI" };
this.grdDeviceLayer.Children.Add(ai);
ai.MouseLeftButtonDown += selectedDevice_MouseLeftButtonDown;
ai.MouseLeftButtonUp += selectedDevice_MouseLeftButtonUp;
ai.MouseMove += selectedDevice_MouseMove;
}
else if (tbl.Type == "DI")
{
DI di = new DI();
di.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
di.VerticalAlignment = System.Windows.VerticalAlignment.Top;
di.SetValue(Grid.MarginProperty, new Thickness(tbl.X ?? 0, tbl.Y ?? 0, 0, 0));
di.Content ="DI:"+ tbl.ItemName;
//CompositeTransform transform = new CompositeTransform() { Rotation = tbl.Rotation ?? 0, ScaleX = tbl.ScaleX ?? 1, ScaleY = tbl.ScaleY ?? 1 };
//ai.RenderTransform = transform;
di.DataContext = tbl; //new SecureServer.BindingData.ItemBindingData { ColorString = "Green", Content = "100V", ItemID =1, Type= "AI" };
this.grdDeviceLayer.Children.Add(di);
di.MouseLeftButtonDown += selectedDevice_MouseLeftButtonDown;
di.MouseLeftButtonUp += selectedDevice_MouseLeftButtonUp;
di.MouseMove += selectedDevice_MouseMove;
}
else if (tbl.Type == "DO")
{
DO di = new DO();
di.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
di.VerticalAlignment = System.Windows.VerticalAlignment.Top;
di.SetValue(Grid.MarginProperty, new Thickness(tbl.X ?? 0, tbl.Y ?? 0, 0, 0));
di.Content ="DO:"+ tbl.ItemName;
//CompositeTransform transform = new CompositeTransform() { Rotation = tbl.Rotation ?? 0, ScaleX = tbl.ScaleX ?? 1, ScaleY = tbl.ScaleY ?? 1 };
//ai.RenderTransform = transform;
di.DataContext = tbl; //new SecureServer.BindingData.ItemBindingData { ColorString = "Green", Content = "100V", ItemID =1, Type= "AI" };
this.grdDeviceLayer.Children.Add(di);
di.Width = 52;
di.Height = 40;
di.MouseLeftButtonDown += selectedDevice_MouseLeftButtonDown;
di.MouseLeftButtonUp += selectedDevice_MouseLeftButtonUp;
di.MouseMove += selectedDevice_MouseMove;
}
}
#endregion
#region ItemGroup
var qgrouo = from n in db.GetTblItemGroupQuery() where n.IsShow && n.PlaneID == planeid select n;
var resgroup = await DB.LoadAsync<tblItemGroup>(db, qgrouo);
foreach (tblItemGroup tbl in resgroup)
{
ItemGroup grp = new ItemGroup();
grp.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
grp.VerticalAlignment = System.Windows.VerticalAlignment.Top;
grp.SetValue(Grid.MarginProperty, new Thickness(tbl.X , tbl.Y , 0, 0));
grp.Content ="Group:"+ tbl.GroupName;
grp.DataContext = tbl;
this.grdDeviceLayer.Children.Add(grp);
grp.MouseLeftButtonDown += selectedDevice_MouseLeftButtonDown;
grp.MouseLeftButtonUp += selectedDevice_MouseLeftButtonUp;
grp.MouseMove += selectedDevice_MouseMove;
}
#endregion
}
/// <summary>
/// Загрузка данных в БД (запускается на статусе добавления данныз)
/// </summary>
/// <returns></returns>
private void LoadInformationToDB()
{
if (string.Compare(CheckInformation(), "0") == 0)
{
bool successToLoadData = false;
System.Collections.Generic.List<string> Parameters = new System.Collections.Generic.List<string>();
System.Collections.Generic.List<string> DataFromTextBox = new System.Collections.Generic.List<string>();
//Основные данные
Parameters.Add("N_ACT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J8));
Parameters.Add("OKUD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(Z10));
Parameters.Add("UTV_DOLZNOST"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(U4));
Parameters.Add("UTV_RAS_PODP"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(U6));
Parameters.Add("ORAGANIZATION_HEAD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(D12));
Parameters.Add("STRUCT_PODR_HEAD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(F14));
Parameters.Add("DATA_SOST"); DataFromTextBox.Add(H22.Value.ToString());
Parameters.Add("COD_VIDA_OPER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(K22));
Parameters.Add("STRUCT_PODR"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(M22));
Parameters.Add("NOMER_CEHA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(P22));
Parameters.Add("VID_DEYAT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(R22));
Parameters.Add("CORRESP_SCHET"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(U22));
Parameters.Add("COD_ZATRAT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(Y22));
Parameters.Add("PRICAZ_OT"); DataFromTextBox.Add(J26.Value.ToString());
Parameters.Add("PRICAZ_YEAR"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(S26));
Parameters.Add("KOL_PREDETOV"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(F86));
Parameters.Add("NOM_ACT_VIB"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(F89));
Parameters.Add("UTIL"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(F112));
//Итог 1
Parameters.Add("ITOG_KOL"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J83));
Parameters.Add("ITOG_DATA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(L83));
Parameters.Add("ITOG_CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(N83));
Parameters.Add("ITOG_SUM_CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(P83));
Parameters.Add("ITOG_SUM_AMOR"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(R83));
Parameters.Add("ITOG_SROK_SLUZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(T83));
Parameters.Add("ITOG_PRIHINA_NAIMENOV"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(V83));
Parameters.Add("ITOG_PRICH_COD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(X83));
Parameters.Add("ITOG_SROK"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(Z83));
//Итог 2
Parameters.Add("ITOGTWO_KOL"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(S103));
Parameters.Add("ITOGTWO_CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(U103));
Parameters.Add("ITOGTWO_SUMMA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(X103));
Parameters.Add("ITOGTWO_PORYAD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(Z103));
string cmd = "INSERT INTO USP_ACTNASPISANIE_HEAD" +
"(N_ACT, OKUD, UTV_DOLZNOST, UTV_RAS_PODP, ORAGANIZATION_HEAD, STRUCT_PODR_HEAD, "+
"DATA_SOST, COD_VIDA_OPER, STRUCT_PODR, NOMER_CEHA, VID_DEYAT, CORRESP_SCHET, COD_ZATRAT, "+
"PRICAZ_OT, PRICAZ_YEAR, KOL_PREDETOV, NOM_ACT_VIB, UTIL, ITOG_KOL, ITOG_DATA, ITOG_CENA, ITOG_SUM_CENA, "+
"ITOG_SUM_AMOR, ITOG_SROK_SLUZ, ITOG_PRIHINA_NAIMENOV, ITOG_PRICH_COD, ITOG_SROK, ITOGTWO_KOL, ITOGTWO_CENA, ITOGTWO_SUMMA, ITOGTWO_PORYAD)"+
" VALUES (:N_ACT, :OKUD, :UTV_DOLZNOST, :UTV_RAS_PODP, :ORAGANIZATION_HEAD, :STRUCT_PODR_HEAD,"+
" to_date(:DATA_SOST,'DD.MM.YYYY hh24:mi:ss'), :COD_VIDA_OPER, :STRUCT_PODR, :NOMER_CEHA, :VID_DEYAT, :CORRESP_SCHET, :COD_ZATRAT, "+
"to_date(:PRICAZ_OT,'DD.MM.YYYY hh24:mi:ss'), :PRICAZ_YEAR, :KOL_PREDETOV, :NOM_ACT_VIB, :UTIL, :ITOG_KOL, :ITOG_DATA, :ITOG_CENA, :ITOG_SUM_CENA, "+
":ITOG_SUM_AMOR, :ITOG_SROK_SLUZ, :ITOG_PRIHINA_NAIMENOV, :ITOG_PRICH_COD, :ITOG_SROK, :ITOGTWO_KOL, :ITOGTWO_CENA, :ITOGTWO_SUMMA, :ITOGTWO_PORYAD)";
successToLoadData = SQLOracle.InsertQuery(cmd, Parameters, DataFromTextBox);
//MessageBox.Show("1");
Parameters.Clear();
DataFromTextBox.Clear();
if (successToLoadData == true)
for (int i = 1; i < 6; i++)
{
if (successToLoadData == true)
{
string cmdDATA = "INSERT INTO USP_ACTNASPISANIE_DATA_ONE(ACT_NOMER,NUMBER_OF_PANEL," +
" PREDMET_NAIM, PREDMET_NOMEN_NOMER, PREDMET_INVENT_NOMER, ED_IZM_NAIM, ED_IZM_KOD, KOL_VO, DATA_POSTUPLENIYA, "+
"CENA, SUMMA_CENA_RUB, SUMMA_AMORTIZ, SROK_SLUZ, PRICH_SPIS_NAIM, PRICH_SPIS_KOD, NOMER_PASPORTA)" +
" VALUES(:ACT_NOMER,:NUMBER_OF_PANEL," +
" :PREDMET_NAIM, :PREDMET_NOMEN_NOMER, :PREDMET_INVENT_NOMER, :ED_IZM_NAIM, :ED_IZM_KOD, :KOL_VO,to_date(:DATA_POSTUPLENIYA,'DD.MM.YYYY hh24:mi:ss')," +
" :CENA, :SUMMA_CENA_RUB, :SUMMA_AMORTIZ, :SROK_SLUZ, :PRICH_SPIS_NAIM, :PRICH_SPIS_KOD, :NOMER_PASPORTA)";
Parameters.Add("ACT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J8));
Parameters.Add("NUMBER_OF_PANEL"); DataFromTextBox.Add((i).ToString());
Parameters.Add("PREDMET_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("A" + ((4 * (i - 1))+36).ToString()), true)[0])));
Parameters.Add("PREDMET_NOMEN_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("A" + ((4 * (i - 1))+38).ToString()), true)[0])));
Parameters.Add("PREDMET_INVENT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("F" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("ED_IZM_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("H" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("ED_IZM_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("H" + ((4 * (i - 1)) + 38).ToString()), true)[0])));
Parameters.Add("KOL_VO"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("J" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("DATA_POSTUPLENIYA"); DataFromTextBox.Add(((System.Windows.Forms.DateTimePicker)(this.tabPage1.Controls.Find(("L" + ((4 * (i - 1)) + 36).ToString()), true)[0])).Value.ToString());
Parameters.Add("CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("N" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("SUMMA_CENA_RUB"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("P" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("SUMMA_AMORTIZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("R" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("SROK_SLUZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("T" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("PRICH_SPIS_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("V" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("PRICH_SPIS_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("X" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("NOMER_PASPORTA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("Z" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
successToLoadData = SQLOracle.InsertQuery(cmdDATA, Parameters, DataFromTextBox);
Parameters.Clear();
DataFromTextBox.Clear();
}
}
if (successToLoadData == true)
for (int i = 7; i < 12; i++)
{
if (successToLoadData == true)
{
string cmdDATA = "INSERT INTO USP_ACTNASPISANIE_DATA_ONE(ACT_NOMER,NUMBER_OF_PANEL," +
" PREDMET_NAIM, PREDMET_NOMEN_NOMER, PREDMET_INVENT_NOMER, ED_IZM_NAIM, ED_IZM_KOD, KOL_VO, DATA_POSTUPLENIYA, " +
"CENA, SUMMA_CENA_RUB, SUMMA_AMORTIZ, SROK_SLUZ, PRICH_SPIS_NAIM, PRICH_SPIS_KOD,NOMER_PASPORTA)" +
" VALUES(:ACT_NOMER,:NUMBER_OF_PANEL," +
" :PREDMET_NAIM, :PREDMET_NOMEN_NOMER, :PREDMET_INVENT_NOMER, :ED_IZM_NAIM, :ED_IZM_KOD, :KOL_VO, to_date(:DATA_POSTUPLENIYA,'DD.MM.YYYY hh24:mi:ss')," +
" :CENA, :SUMMA_CENA_RUB, :SUMMA_AMORTIZ, :SROK_SLUZ, :PRICH_SPIS_NAIM, :PRICH_SPIS_KOD, :NOMER_PASPORTA)";
Parameters.Add("ACT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J8));
Parameters.Add("NUMBER_OF_PANEL"); DataFromTextBox.Add((i).ToString());
Parameters.Add("PREDMET_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("A" + ((4 * (i - 1)) + 39 ).ToString()), true)[0])));
Parameters.Add("PREDMET_NOMEN_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("A" + ((4 * (i - 1)) +41).ToString()), true)[0])));
Parameters.Add("PREDMET_INVENT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("F" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("ED_IZM_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("H" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("ED_IZM_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("H" + ((4 * (i - 1)) + 41).ToString()), true)[0])));
Parameters.Add("KOL_VO"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("J" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("DATA_POSTUPLENIYA"); DataFromTextBox.Add(((System.Windows.Forms.DateTimePicker)(this.tabPage2.Controls.Find(("L" + ((4 * (i - 1)) + 39).ToString()), true)[0])).Value.ToString());
Parameters.Add("CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("N" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("SUMMA_CENA_RUB"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("P" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("SUMMA_AMORTIZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("R" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("SROK_SLUZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("T" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("PRICH_SPIS_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("V" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("PRICH_SPIS_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("X" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("NOMER_PASPORTA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("Z" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
successToLoadData = SQLOracle.InsertQuery(cmdDATA, Parameters, DataFromTextBox);
Parameters.Clear();
DataFromTextBox.Clear();
}
}
if (successToLoadData == true)
for (int i = 1; i <=2; i++)
{
if (successToLoadData == true)
{
string cmdDATA = "INSERT INTO USP_ACTNASPISANIE_DATA_TWO(ACT_NOMER,NUMBER_OF_PANEL,KOD_VIDA_OPER, VID_DEYAT, STRUCT_PODR, UTIL_NAIM, UTIL_NOMEN_NOMER, ED_IZM_NAIM, ED_IZM_KOD, KOL_VO, CENA, SUMMA_RUB, PORYADKOV_NUM)" +
" VALUES(:ACT_NOMER,:NUMBER_OF_PANEL, :KOD_VIDA_OPER, :VID_DEYAT, :STRUCT_PODR, :UTIL_NAIM, :UTIL_NOMEN_NOMER, :ED_IZM_NAIM, :ED_IZM_KOD, :KOL_VO, :CENA, :SUMMA_RUB,:PORYADKOV_NUM)";
Parameters.Add("ACT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J8));
Parameters.Add("NUMBER_OF_PANEL"); DataFromTextBox.Add((i).ToString());
Parameters.Add("KOD_VIDA_OPER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("A" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("VID_DEYAT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("C" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("STRUCT_PODR"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("F" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("UTIL_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("I" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("UTIL_NOMEN_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("L" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("ED_IZM_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("O" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("ED_IZM_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("Q" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("KOL_VO"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("S" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("U" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("SUMMA_RUB"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("X" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("PORYADKOV_NUM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("Z" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
successToLoadData = SQLOracle.InsertQuery(cmdDATA, Parameters, DataFromTextBox);
Parameters.Clear();
DataFromTextBox.Clear();
}
}
if (successToLoadData == true)
{
MessageBox.Show("Данные успешно загружены!");
}
}
else
{
MessageBox.Show(CheckInformation(), "Ошибка!");
}
}
// Update is called once per frame
private void Update()
{
if (_Instance == null)
Init();
var notification = PopNotification();
if (!string.IsNullOrEmpty(notification))
{
Debug.Log(notification);
ShowNotification(new GUIContent(notification));
}
if (!string.IsNullOrEmpty(UpdateMessage))
{
Debug.Log(UpdateMessage);
UpdateMessage = string.Empty;
}
if ((DateTime.Now - LastEllipses).Milliseconds > 500)
{
LastEllipses = DateTime.Now;
EllipsesCount += 1;
if (EllipsesCount > 5)
EllipsesCount = 2;
Ellipses = string.Empty;
for (var i = 0; i < EllipsesCount; ++i)
Ellipses += ".";
Repaint();
}
// Detect Skin Changes
var oldUseDarkSkin = UseDarkSkin;
if (EditorGUIUtility.isProSkin)
{
UseDarkSkin = true;
if(oldUseDarkSkin != UseDarkSkin)
LoadStyles();
}
if (IsDirty)
{
Google2uGUIUtil.Save();
IsDirty = false;
}
// Prevent Google2u from doing anything while in play mode
if (EditorApplication.isPlayingOrWillChangePlaymode || EditorApplication.isCompiling)
return;
if ((DateTime.Now - LastCheckedRSS).Hours > 0)
{
LastCheckedRSS = DateTime.Now;
var t = new Thread(CheckForService);
t.Start();
}
if (InstanceData.Commands.Contains(GFCommand.DoLogout))
{
InstanceData.Commands.Remove(GFCommand.DoLogout);
var t = new Thread(DoLogout) { Name = "DoLogout" };
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.RetrieveWorkbooks))
{
InstanceData.Commands.Remove(GFCommand.RetrieveWorkbooks);
InstanceData.Commands.Add(GFCommand.WaitForRetrievingWorkbooks);
InstanceData.AccountWorkbooks.Clear();
var t = new Thread(DoWorkbookQuery) { Name = "RetrieveWorkbooks" };
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.RetrieveManualWorkbooks))
{
InstanceData.Commands.Remove(GFCommand.RetrieveManualWorkbooks);
InstanceData.Commands.Add(GFCommand.WaitForRetrievingManualWorkbooks);
var t = new Thread(DoManualWorkbookRetrieval) { Name = "ManualWorkbookRetrieval" };
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.ManualWorkbooksRetrievalComplete))
{
InstanceData.Commands.Remove(GFCommand.ManualWorkbooksRetrievalComplete);
var manualWorkbooksString = InstanceData.ManualWorkbooks.Aggregate(string.Empty, (in_current, in_wb) => in_current + (in_wb.WorkbookUrl + "|"));
Google2uGUIUtil.SetString(InstanceData.ProjectPath + "_ManualWorkbookCache", manualWorkbooksString);
}
if (InstanceData.Commands.Contains(GFCommand.DoUpload))
{
InstanceData.Commands.Remove(GFCommand.DoUpload);
InstanceData.Commands.Add(GFCommand.WaitingForUpload);
var t = new Thread(DoWorkbookUpload) {Name = "WorkbookUpload"};
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.UploadComplete))
{
InstanceData.Commands.Remove(GFCommand.UploadComplete);
InstanceData.WorkbookUploadProgress = 0;
InstanceData.AccountWorkbooks.Clear();
InstanceData.Commands.Add(GFCommand.RetrieveWorkbooks);
}
foreach (var Google2uSpreadsheet in InstanceData.AccountWorkbooksDisplay)
{
Google2uSpreadsheet.Update();
}
foreach (var Google2uSpreadsheet in InstanceData.ManualWorkbooksDisplay)
{
Google2uSpreadsheet.Update();
}
if (_ObjDbExport != null && _ObjDbExport.Count > 0)
{
var dbInfo = _ObjDbExport[0];
if (dbInfo == null)
{
_ObjDbExport.RemoveAt(0);
return;
}
if ((DateTime.Now - dbInfo.LastAttempt).TotalSeconds < 2)
return;
if (dbInfo.ReloadedAssets == false)
{
AssetDatabase.Refresh(ImportAssetOptions.ForceUpdate);
dbInfo.ReloadedAssets = true;
return;
}
dbInfo.LastAttempt = DateTime.Now;
Component comp = null;
var myAssetPath = string.Empty;
Debug.Log("Looking for Database Script: " + dbInfo.ScriptName);
var findAssetArray = AssetDatabase.FindAssets(dbInfo.ScriptName);
if (findAssetArray.Length > 0)
{
foreach (var s in findAssetArray)
{
var mypath = AssetDatabase.GUIDToAssetPath(s);
if (mypath.EndsWith(".cs"))
{
myAssetPath = mypath;
Debug.Log("Found Database Script at: " + mypath);
}
}
var myType = GetAssemblyType("Google2u." + dbInfo.ScriptName);
Debug.Log(dbInfo.ScriptName + ": GetAssemblyType returns " + myType);
if (myType != null)
{
var go = GameObject.Find(dbInfo.ObjectName) ?? new GameObject(dbInfo.ObjectName);
var toDestroy = go.GetComponent(dbInfo.ScriptName);
if (toDestroy != null)
DestroyImmediate(toDestroy);
#if UNITY_5
comp = go.AddComponent(myType);
#else
comp = go.AddComponent(dbInfo.ScriptName);
#endif
}
}
if (comp == null)
{
if (!string.IsNullOrEmpty(myAssetPath))
{
Debug.Log("Attempting to compile: " + myAssetPath);
AssetDatabase.ImportAsset(myAssetPath,
ImportAssetOptions.ForceSynchronousImport |
ImportAssetOptions.ForceUpdate);
}
if (_ImportTryCount < 5)
{
_ImportTryCount++;
return;
}
Debug.LogError("Could not add Google2u component base " + dbInfo.ScriptName);
_ObjDbExport.Clear();
_ImportTryCount = 0;
return;
}
_ImportTryCount = 0;
Debug.Log("Database Script Attached!");
_ObjDbExport.Remove(dbInfo);
var rowInputs = new System.Collections.Generic.List<string>();
var currow = 0;
foreach (var row in dbInfo.Data.Rows)
{
if (currow == 0)
{
currow++;
continue;
}
// if types in first row
if(dbInfo.Data.UseTypeRow && currow == 1)
{
currow++;
continue;
}
var rowType = row[0].GetTypeFromValue();
var rowHeader = row[0].CellValueString;
if (string.IsNullOrEmpty(rowHeader))
// if this header is empty
{
if (dbInfo.CullEmptyRows)
break;
currow++;
continue;
}
if (rowType == SupportedType.Void ||
rowHeader.Equals("void", StringComparison.InvariantCultureIgnoreCase))
// if this cell is void, then skip the row completely
{
currow++;
continue;
}
foreach (var cell in row.Cells)
{
if (cell.MyType == SupportedType.Void)
continue;
rowInputs.Add(cell.CellValueString);
}
(comp as Google2uComponentBase).AddRowGeneric(rowInputs);
rowInputs.Clear();
currow++;
}
}
}
bool ButtonCommitClicked ()
{
// In case we have local unsaved files with changes, throw a dialog for the user.
System.Collections.Generic.List<Document> docList = new System.Collections.Generic.List<Document> ();
foreach (var item in IdeApp.Workbench.Documents) {
if (!item.IsDirty || !selected.Contains (item.FileName))
continue;
docList.Add (item);
}
if (docList.Count != 0) {
AlertButton response = MessageService.GenericAlert (
MonoDevelop.Ide.Gui.Stock.Question,
GettextCatalog.GetString ("You are trying to commit files which have unsaved changes."),
GettextCatalog.GetString ("Do you want to save the changes before committing?"),
new AlertButton[] {
AlertButton.Cancel,
new AlertButton ("Don't Save"),
AlertButton.Save
}
);
if (response == AlertButton.Cancel)
return false;
if (response == AlertButton.Save) {
// Go through all the items and save them.
foreach (var item in docList)
item.Save ();
// Check if save failed on any item and abort.
foreach (var item in docList)
if (item.IsDirty) {
MessageService.ShowMessage (GettextCatalog.GetString (
"Some files could not be saved. Commit operation aborted"));
return false;
}
}
docList.Clear ();
}
// Update the change set
List<FilePath> todel = new List<FilePath> ();
foreach (ChangeSetItem it in changeSet.Items) {
if (!selected.Contains (it.LocalPath))
todel.Add (it.LocalPath);
}
foreach (string file in todel)
changeSet.RemoveFile (file);
changeSet.GlobalComment = Message;
// Perform the commit
int n;
for (n=0; n<extensions.Count; n++) {
CommitDialogExtension ext = extensions [n];
bool res;
try {
res = ext.OnBeginCommit (changeSet);
} catch (Exception ex) {
LoggingService.LogInternalError (ex);
res = false;
}
if (!res) {
// Commit failed. Rollback the previous extensions
for (int m=0; m<n; m++) {
ext = extensions [m];
try {
ext.OnEndCommit (changeSet, false);
} catch {}
}
return false;
}
}
return true;
}
// modified to take first argument as a preprocessed buffer, instead of filename
public void ProcessFile(string ncFile, List<clsMotionRecord> gfxRecs)
{
mGfxRecs = gfxRecs;
mCodefile = ncFile;
{
mMotion.SubCall.Label = mCurMachine.Subcall[0];
mMotion.SubCall.Value = int.Parse(mCurMachine.Subcall.Substring(1));
mMotion.SubReturn.Label = mCurMachine.SubReturn[0];
mMotion.SubReturn.Value = int.Parse(mCurMachine.SubReturn.Substring(1));
mMotion.Abs.Label = mCurMachine.Absolute[0];
mMotion.Abs.Value = int.Parse(mCurMachine.Absolute.Substring(1));
mMotion.CCArc.Label = mCurMachine.CCArc[0];
mMotion.CCArc.Value = int.Parse(mCurMachine.CCArc.Substring(1));
mMotion.CWArc.Label = mCurMachine.CWArc[0];
mMotion.CWArc.Value = int.Parse(mCurMachine.CWArc.Substring(1));
mMotion.Inc.Label = mCurMachine.Incremental[0];
mMotion.Inc.Value = int.Parse(mCurMachine.Incremental.Substring(1));
mMotion.Linear.Label = mCurMachine.Linear[0];
mMotion.Linear.Value = int.Parse(mCurMachine.Linear.Substring(1));
mMotion.Rapid.Label = mCurMachine.Rapid[0];
mMotion.Rapid.Value = int.Parse(mCurMachine.Rapid.Substring(1));
mMotion.Rotary.Label = mCurMachine.Rotary[0];
mMotion.Rotary.Value = 0;
mMotion.DrillRapid.Label = mCurMachine.DrillRapid[0];
mMotion.DrillRapid.Value = 0;
mMotion.Plane[0].Label = mCurMachine.XYplane[0];
mMotion.Plane[0].Value = int.Parse(mCurMachine.XYplane.Substring(1));
mMotion.Plane[1].Label = mCurMachine.XZplane[0];
mMotion.Plane[1].Value = int.Parse(mCurMachine.XZplane.Substring(1));
mMotion.Plane[2].Label = mCurMachine.YZplane[0];
mMotion.Plane[2].Value = int.Parse(mCurMachine.YZplane.Substring(1));
mMotion.ReturnLevel[0].Label = mCurMachine.ReturnLevel[0][0];
mMotion.ReturnLevel[0].Value = int.Parse(mCurMachine.ReturnLevel[0].Substring(1));
mMotion.ReturnLevel[1].Label = mCurMachine.ReturnLevel[1][0];
mMotion.ReturnLevel[1].Value = int.Parse(mCurMachine.ReturnLevel[1].Substring(1));
for (int r = 0; r <= mMotion.Drills.Length - 1; r++)
{
if (mCurMachine.Drills[r].Length > 2)
{
mMotion.Drills[r].Label = mCurMachine.Drills[r][0];
mMotion.Drills[r].Value = int.Parse(mCurMachine.Drills[r].Substring(1));
}
}
}
//Reset all positions.
mGfxRecs.Clear();
mCurrentColor = 0;
mPrevTool = -1;
mXpos = 0;
mYpos = 0;
mZpos = 0;
mPrevX = 0;
mPrevY = 0;
mPrevZ = 0;
mPrevABC = 0;
mABC = 0;
mRpoint = 0;
mSpeed = 0;
mFeed = 0;
mDrillClear = 0;
mInitialZBeforeDrill = 0;
mRotDir = 1;
mAbsolute = true;
mMode = Motion.RAPID;
mDrillReturnMode = Motion.I_PLN;
if (mCurMachine.MachineType == MachineType.MILL)
{
mPlane = Motion.XY_PLN; //Mill
}
else
{
mPlane = Motion.XZ_PLN;//Lathe
}
mEndmain = mCurMachine.Endmain.Trim();
mSubcall = mCurMachine.Subcall.Trim();
mSubRepeats = mCurMachine.SubRepeats.Trim();
string sFileContents = null;
sFileContents = FilterJunk(ncFile);
mNcProgs.Clear();
int lastIndex = -1;
int thisIndex = -1;
clsProg p = default(clsProg);
foreach (Match m in this.mRegSubs.Matches(sFileContents))
{
if (mCurMachine.ProgramId.Contains(m.Value[0].ToString()))
{
thisIndex = m.Index;
//Each program
if (lastIndex > -1)
{
mNcProgs[mNcProgs.Count - 1].Contents = sFileContents.Substring(lastIndex, thisIndex - lastIndex).TrimEnd();
if (mNcProgs[mNcProgs.Count - 1].Contents.Contains(mCurMachine.Endmain))
{
mNcProgs[mNcProgs.Count - 1].Main = true;
}
}
p = new clsProg();
p.Main = false;
p.Index = thisIndex;
p.Label = Char.ToUpper(m.Value[0]).ToString();
p.Value = int.Parse(m.Groups[1].Value);
mNcProgs.Add(p);
lastIndex = m.Index;
}
}
mTotalLines = 1;
if (mNcProgs.Count == 0)
{
//Just add all the text we found in the file
p = new clsProg();
p.Main = true;
p.Index = 0;
p.Label = "MAIN";
p.Value = 0;
p.Contents = sFileContents;
mNcProgs.Add(p);
mTotalBites = sFileContents.Length;
ProcessSubWords(p);
}
else
{
mNcProgs[mNcProgs.Count - 1].Contents = sFileContents.Substring(lastIndex).TrimEnd();
if (mNcProgs[mNcProgs.Count - 1].Contents.Contains(mCurMachine.Endmain))
{
mNcProgs[mNcProgs.Count - 1].Main = true;
}
foreach (clsProg pr in mNcProgs)
{
mTotalBites = pr.Contents.Length;
ProcessSubWords(pr);
}
}
}
private void UpdateActivityPreferences()
{
Ektron.Cms.Activity.ActivityTypeCriteria activityCollListCriteria = new Ektron.Cms.Activity.ActivityTypeCriteria();
Ektron.Cms.Activity.ActivityTypeCriteria activityGroupListCriteria = new Ektron.Cms.Activity.ActivityTypeCriteria();
long uId = 0;
if ((!(Request.QueryString["id"] == null)) && Information.IsNumeric(Request.QueryString["id"]))
{
long.TryParse(Request.QueryString["id"], out uId);
}
activityCollListCriteria.AddFilter(Ektron.Cms.Activity.ActivityTypeProperty.Scope, CriteriaFilterOperator.EqualTo, EkEnumeration.ActivityActionSource.Colleague);
activityGroupListCriteria.AddFilter(Ektron.Cms.Activity.ActivityTypeProperty.Scope, CriteriaFilterOperator.EqualTo, EkEnumeration.ActivityActionSource.CommunityGroup);
collActivityTypeList = _activityListApi.GetList(activityCollListCriteria);
groupActivityTypeList = _activityListApi.GetList(activityGroupListCriteria);
if (uId > 0)
{
//Colleague Preferences
preferenceList = new System.Collections.Generic.List<NotificationPreferenceData>();
preferenceList.Clear();
for (int i = 0; i <= collActivityTypeList.Count - 1; i++)
{
if ((Page.Request.Form["email" + collActivityTypeList[i].Id] != null) && Page.Request.Form["email" + collActivityTypeList[i].Id] == "on")
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = collActivityTypeList[i].Id;
prefData.AgentId = 1;
prefData.UserId = uId;
preferenceList.Add(prefData);
}
else
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = collActivityTypeList[i].Id;
prefData.DataState = Ektron.Cms.Common.EkEnumeration.DataState.Deleted;
prefData.AgentId = 1;
prefData.UserId = uId;
preferenceList.Add(prefData);
}
if ((Page.Request.Form["sms" + collActivityTypeList[i].Id] != null) && Page.Request.Form["sms" + collActivityTypeList[i].Id] == "on")
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = collActivityTypeList[i].Id;
prefData.AgentId = 3;
prefData.UserId = uId;
preferenceList.Add(prefData);
}
else
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = collActivityTypeList[i].Id;
prefData.DataState = Ektron.Cms.Common.EkEnumeration.DataState.Deleted;
prefData.AgentId = 3;
prefData.UserId = uId;
preferenceList.Add(prefData);
}
if ((Page.Request.Form["feed" + collActivityTypeList[i].Id] != null) && Page.Request.Form["feed" + collActivityTypeList[i].Id] == "on")
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = collActivityTypeList[i].Id;
prefData.AgentId = 2;
prefData.UserId = uId;
preferenceList.Add(prefData);
}
else
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = collActivityTypeList[i].Id;
prefData.DataState = Ektron.Cms.Common.EkEnumeration.DataState.Deleted;
prefData.AgentId = 2;
prefData.UserId = uId;
preferenceList.Add(prefData);
}
}
//Group Preferences
for (int i = 0; i <= groupActivityTypeList.Count - 1; i++)
{
if ((Page.Request.Form["email" + groupActivityTypeList[i].Id] != null) && Page.Request.Form["email" + groupActivityTypeList[i].Id] == "on")
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = groupActivityTypeList[i].Id;
prefData.AgentId = 1;
prefData.UserId = uId;
prefData.ActionSourceId = -1;
preferenceList.Add(prefData);
}
else
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = groupActivityTypeList[i].Id;
prefData.DataState = Ektron.Cms.Common.EkEnumeration.DataState.Deleted;
prefData.AgentId = 1;
prefData.UserId = uId;
prefData.ActionSourceId = -1;
preferenceList.Add(prefData);
}
if ((Page.Request.Form["feed" + groupActivityTypeList[i].Id] != null) && Page.Request.Form["feed" + groupActivityTypeList[i].Id] == "on")
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = groupActivityTypeList[i].Id;
prefData.AgentId = 2;
prefData.UserId = uId;
prefData.ActionSourceId = -1;
preferenceList.Add(prefData);
}
else
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = groupActivityTypeList[i].Id;
prefData.DataState = Ektron.Cms.Common.EkEnumeration.DataState.Deleted;
prefData.AgentId = 2;
prefData.UserId = uId;
prefData.ActionSourceId = -1;
preferenceList.Add(prefData);
}
if ((Page.Request.Form["sms" + groupActivityTypeList[i].Id] != null) && Page.Request.Form["sms" + groupActivityTypeList[i].Id] == "on")
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = groupActivityTypeList[i].Id;
prefData.AgentId = 3;
prefData.UserId = uId;
prefData.ActionSourceId = -1;
preferenceList.Add(prefData);
}
else
{
prefData = new NotificationPreferenceData();
prefData.ActivityTypeId = groupActivityTypeList[i].Id;
prefData.DataState = Ektron.Cms.Common.EkEnumeration.DataState.Deleted;
prefData.AgentId = 3;
prefData.UserId = uId;
prefData.ActionSourceId = -1;
preferenceList.Add(prefData);
}
}
_notificationPreferenceApi.SaveUserPreferences(preferenceList);
}
}
public void controller(string[] args)
{
if (args.Length >= 2 && args[0].ToUpper().Equals("-FTDNA"))
{
FamilyTreeDNA.FamilyTreeDNA ftd = new FamilyTreeDNA.FamilyTreeDNA();
if (args.Length >= 3)
ftd.Login(args[1], args[2]);
else
ftd.Login("169551", "D3742");
}
if (args.Length >= 2 && args[0].ToUpper().Equals("-23"))
{
MeAnd23.MeAnd23 m23 = new MeAnd23.MeAnd23();
if (args.Length >= 3)
m23.Login(args[1], args[2]);
else
m23.Login("*****@*****.**", "nurse1");
}
if (args.Length >= 2 && args[0].ToUpper().Equals("-CSV"))
{
}
if (args.Length >= 2 && args[0].Equals("-compare"))
{
GedcomDatabase gd1 = new GedcomDatabase();
GedcomIndividualRecord record = new GedcomIndividualRecord(gd1, "Robert Warthen");
record.Sex = GedcomSex.Male;
//record.Birth = new GedcomIndividualEvent().Date.;
GedcomParser.GedcomRecordWriter grw = new GedcomParser.GedcomRecordWriter();
grw.WriteGedcom(gd1, "C:\\Temp\\Rob.ged");
}
if (args.Length >= 2 && args[0].Equals("-surlist"))
{
swsn = new StreamWriter(args[1] + "\\surname.csv", false);
string[] files = Directory.GetFiles(args[1], "*.*", SearchOption.TopDirectoryOnly);
string[] files2 = Directory.GetFiles(args[1], "*.*", SearchOption.TopDirectoryOnly);
if (args.Length >= 3 && args[2].Equals("-file"))
{
files = new string[1];
files[0] = args[3];
}
if (args.Length >= 3 && args[2].Equals("-dir"))
{
files2 = Directory.GetFiles(args[3], "*.*", SearchOption.TopDirectoryOnly);
}
foreach (string gdf1 in files)
{
string gedcomFile1 = gdf1.ToUpper();
if (!gedcomFile1.EndsWith(".GED"))
continue;
swFile1 = Path.GetFileName(gedcomFile1);
//Console.WriteLine("Loading " + );
GedcomParser.GedcomRecordReader grr1 = new GedcomParser.GedcomRecordReader();
grr1.GedcomFile = gedcomFile1;
try { grr1.ReadGedcom(); }
catch { Console.WriteLine("Couldn't read file " + gedcomFile1); continue; }
GedcomDatabase gd1 = grr1.Database;
System.Collections.Generic.List<string> sv = new System.Collections.Generic.List<string>();
sv.Clear();
foreach (GedcomIndividualRecord rec in gd1.Individuals)
{
try
{
foreach (GedcomName sname in rec.Names)
{
string sn = sname.Surname.ToUpper();
if (sn.Length == 0)
continue;
if (!sv.Contains(sname.Surname.ToUpper()))
{
sv.Add(sname.Surname.ToUpper());
swsn.WriteLine(gedcomFile1 + ",\"" + sname.Surname.ToUpper().Replace("\"", "_") + "\"");
}
}
}
catch
{
Console.WriteLine("Can't read");
}
}
}
swsn.Close();
}
if (args.Length >= 2 && args[0].Equals("-compdir"))
{
sw = new StreamWriter(args[1] + "\\match.csv");
sw.WriteLine("File1,File2,Exact Match,Given1,Surname1,Birth Date1,Birth Place1,Death Date1,Death Place1,Given2,Surname2,Birth Date2,Birth Place2,Death Date2,Death Place2");
swsn = new StreamWriter(args[1] + "\\surname.csv",false);
string[] files = Directory.GetFiles(args[1], "*.*", SearchOption.TopDirectoryOnly);
string[] files2 = Directory.GetFiles(args[1], "*.*", SearchOption.TopDirectoryOnly);
if (args.Length >= 3 && args[2].Equals("-file"))
{
files = new string[1];
files[0] = args[3];
}
if (args.Length >= 3 && args[2].Equals("-dir"))
{
files2 = Directory.GetFiles(args[3], "*.*", SearchOption.TopDirectoryOnly);
}
foreach (string gdf1 in files)
{
string gedcomFile1 = gdf1.ToUpper();
if (!gedcomFile1.EndsWith(".GED"))
continue;
swFile1 = Path.GetFileName(gedcomFile1);
//Console.WriteLine("Loading " + );
GedcomParser.GedcomRecordReader grr1 = new GedcomParser.GedcomRecordReader();
grr1.GedcomFile = gedcomFile1;
try { grr1.ReadGedcom(); }
catch { continue; }
GedcomDatabase gd1 = grr1.Database;
System.Collections.Generic.List<string> sv = new System.Collections.Generic.List<string>();
foreach (GedcomIndividualRecord rec in gd1.Individuals)
{
try
{
foreach (GedcomName sname in rec.Names)
{
if (!sv.Contains(sname.Surname.ToUpper()))
{
sv.Add(sname.Surname.ToUpper());
swsn.WriteLine(gedcomFile1 + ",\"" + sname.Surname.ToUpper().Replace("\"","_") + "\"");
}
}
}
catch
{
Console.WriteLine("Can't read");
}
}
foreach (string gdf2 in files2)
{
string gedcomFile2 = gdf2.ToUpper();
if (!gedcomFile2.EndsWith(".GED"))
continue;
if (gedcomFile2.Equals(gedcomFile1))
continue;
swFile2 = Path.GetFileName(gedcomFile2);
//Console.WriteLine("Comparing " + gedcomFile1 + " and " + gedcomFile2);
GedcomParser.GedcomRecordReader grr2 = new GedcomParser.GedcomRecordReader();
grr2.GedcomFile = gedcomFile2;
try { grr2.ReadGedcom(); }
catch { continue; }
GedcomDatabase gd2 = grr2.Database;
GedcomDuplicate.DuplicateFoundFunc found = new GedcomDuplicate.DuplicateFoundFunc(FoundDuplicate);
float matchThreshold = 95;
GedcomDuplicate.FindDuplicates(gd1, gd2, matchThreshold, found);
}
sw.Flush();
swsn.Flush();
}
sw.Close();
swsn.Close();
}
if (args.Length >= 2 && args[0].Equals("-surname"))
{
string[] files = Directory.GetFiles(args[1], "*.*", SearchOption.AllDirectories);
string surname = args[2].ToUpper();
foreach (string gedcomFile1 in files)
{
if (!gedcomFile1.ToUpper().EndsWith(".GED"))
continue;
//Console.WriteLine("Comparing " + gedcomFile1 + " for surname " + surname);
GedcomParser.GedcomRecordReader grr1 = new GedcomParser.GedcomRecordReader();
try
{
grr1.GedcomFile = gedcomFile1;
grr1.ReadGedcom();
GedcomDatabase gd1 = grr1.Database;
bool foundfile = false;
foreach (GedcomIndividualRecord rec in gd1.Individuals)
{
try
{
if (rec.Names.Count > 0 && rec.Names[0].Surname.ToUpper().Equals(surname))
{
if (!foundfile)
{
Console.WriteLine("File " + gedcomFile1);
foundfile = true;
}
Console.Write(" Found " + rec.Names[0].Given + " " + rec.Names[0].Surname);
try { Console.Write(" Born: " + rec.Birth.Date.DateString); }
catch { }
try { Console.Write(" in " + rec.Birth.Place.Name); }
catch { }
try { Console.Write(" Died: " + rec.Death.Date.DateString); }
catch { }
try { Console.Write(" at " + rec.Death.Place.Name); }
catch { }
Console.WriteLine();
}
}
catch
{
Console.WriteLine("Can't read");
}
}
}
catch { }
}
}
if (args.Length >= 2 && args[0].Equals("-surfile"))
{
List<string> lstSurname = new List<string>();
string[] files = Directory.GetFiles(args[1], "*.*", SearchOption.TopDirectoryOnly);
//string surname = args[2].ToUpper();
foreach (string gedcomFile1 in files)
{
if (!gedcomFile1.ToUpper().EndsWith(".GED"))
continue;
//Console.WriteLine("Comparing " + gedcomFile1 + " for surname " + surname);
GedcomParser.GedcomRecordReader grr1 = new GedcomParser.GedcomRecordReader();
try
{
grr1.GedcomFile = gedcomFile1;
grr1.ReadGedcom();
GedcomDatabase gd1 = grr1.Database;
bool foundfile = false;
if (!Directory.Exists(args[1] + "\\Surname"))
Directory.CreateDirectory(args[1] + "\\Surname");
foreach (GedcomIndividualRecord rec in gd1.Individuals)
{
try
{
StreamWriter sw;
if (rec.Names.Count > 0)
{
string surname = rec.Names[0].Surname.Replace("(", "").Replace(")", "").Replace("_", "").Replace("?", "").Replace("[", "").Replace("]", "").Replace("\'", "").Replace("\\", "").Replace("/", "");
if (!lstSurname.Contains(surname))
{
sw = new StreamWriter(args[1] + "\\Surname\\Surname_" + surname + ".csv", false);
sw.WriteLine("File,Given,Surname,Birth Date,Birth Place,Death Date,Death Place");
lstSurname.Add(surname);
}
else
sw = new StreamWriter(args[1] + "\\Surname\\Surname_" + surname + ".csv", true);
sw.Write("\"" + gedcomFile1 + "\"," + "\"" + rec.Names[0].Given + "\"," + "\"" + rec.Names[0].Surname + "\",");
try { sw.Write("\"" + rec.Birth.Date.DateString + "\"," + "\"" + rec.Birth.Place.Name + "\","); }
catch { sw.Write(",,"); }
try { sw.WriteLine( "\"" + rec.Death.Date.DateString + "\"," + "\"" + rec.Death.Place.Name + "\"");}
catch { sw.WriteLine(","); }
sw.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("Can't read: " + ex.Message + "-" + ex.StackTrace);
}
finally
{
if (sw != null)
sw.Close();
}
}
}
catch { }
}
}
if (args.Length >= 2 && args[0].Equals("-birth"))
{
string[] files = Directory.GetFiles(args[1], "*.*", SearchOption.AllDirectories);
string surname = args[2].ToUpper();
foreach (string gedcomFile1 in files)
{
if (!gedcomFile1.ToUpper().EndsWith(".GED"))
continue;
//Console.WriteLine("Comparing " + gedcomFile1 + " for surname " + surname);
GedcomParser.GedcomRecordReader grr1 = new GedcomParser.GedcomRecordReader();
grr1.GedcomFile = gedcomFile1;
grr1.ReadGedcom();
GedcomDatabase gd1 = grr1.Database;
bool foundfile = false;
foreach (GedcomIndividualRecord rec in gd1.Individuals)
{
try
{
if (rec.Birth != null && rec.Birth.Place != null && rec.Birth.Place.Name != null && rec.Birth.Place.Name.ToUpper().Contains(surname))
{
if (!foundfile)
{
Console.WriteLine("File " + gedcomFile1);
foundfile = true;
}
Console.Write(" Found " + rec.Names[0].Given + " " + rec.Names[0].Surname);
try { Console.Write(" Born: " + rec.Birth.Date.DateString); }
catch { }
try { Console.Write(" in " + rec.Birth.Place.Name); }
catch { }
try { Console.Write(" Died: " + rec.Death.Date.DateString); }
catch { }
try { Console.Write(" at " + rec.Death.Place.Name); }
catch { }
Console.WriteLine();
}
}
catch (Exception ex)
{
Console.WriteLine("Can't read:" + ex.Message + " : " + ex.StackTrace);
}
}
}
}
if (args.Length >= 2 && args[0].Equals("-soundex"))
{
string[] files = Directory.GetFiles(args[1], "*.*", SearchOption.AllDirectories);
string surname = args[2].ToUpper();
string sunameSoundex = Util.GenerateSoundex(surname);
foreach (string gedcomFile1 in files)
{
if (!gedcomFile1.ToUpper().EndsWith(".GED"))
continue;
//Console.WriteLine("Comparing " + gedcomFile1 + " for surname " + surname);
GedcomParser.GedcomRecordReader grr1 = new GedcomParser.GedcomRecordReader();
grr1.GedcomFile = gedcomFile1;
grr1.ReadGedcom();
GedcomDatabase gd1 = grr1.Database;
bool foundfile = false;
foreach (GedcomIndividualRecord rec in gd1.Individuals)
{
if (rec.Names[0].SurnameSoundex.Equals(sunameSoundex))
{
if (!foundfile)
{
Console.WriteLine("File " + gedcomFile1);
foundfile = true;
}
Console.Write(" Found " + rec.Names[0].Given + " " + rec.Names[0].Surname);
try { Console.Write(" Born: " + rec.Birth.Date.DateString); }
catch { }
try { Console.Write(" in " + rec.Birth.Place.Name); }
catch { }
try { Console.Write(" Died: " + rec.Death.Date.DateString); }
catch { }
try { Console.Write(" at " + rec.Death.Place.Name); }
catch { }
Console.WriteLine();
}
}
}
}
if (args.Length >= 2 && args[0].Equals("-loaddir"))
{
string[] files = Directory.GetFiles(args[1], "*.*", SearchOption.AllDirectories);
foreach (string gedcomFile1 in files)
{
Console.WriteLine("Loading " + gedcomFile1);
GedcomParser.GedcomRecordReader grr1 = new GedcomParser.GedcomRecordReader();
grr1.GedcomFile = gedcomFile1;
grr1.ReadGedcom();
GedcomDatabase gd1 = grr1.Database;
foreach (GedcomIndividualRecord matchIndi in gd1.Individuals)
{
SaveDatabase(matchIndi);
}
}
}
if (args.Length >= 2 && args[0].ToUpper().Equals("-GEDMATCH"))
{
GedMatch.GedMatch gm = new GedMatch.GedMatch();
gm.WorkDir = args[1];
gm.DoMatch = true;
gm.DoGed = true;
gm.loadGedMatch(args[2],true);
}
if (args.Length >= 2 && args[0].ToUpper().Equals("-GETGEDMATCH"))
{
GedMatch.GedMatch gm = new GedMatch.GedMatch();
gm.WorkDir = args[1];
gm.DoGed = true;
gm.loadGedMatch(args[2], true);
}
}
/// <summary>
/// �̾�CMS���������o��ܤ��e
/// </summary>
/// <param name="blockType">���O����</param>
/// <param name="message">�T��</param>
/// <param name="isIcon">���O�ϧ����(0:�����q,1:�q��D�ϥ�,2:�q�ƬG�ϥ�,3:�q�C��)</param>
/// <param name="mode">�Ҧ�</param>
/// <returns></returns>
private RemoteInterface.HC.CMSOutputData SetCMSDislay(string blockType, string message, int isIcon,int mode,string Location,int Show_icon)
{
this.mode = mode;
List<string> changeTexts = new List<string>();
string str = "";
if (CMSDevName == "CMS-N3-S-196.7")
{
message = "�x���a�k";
}
else if (CMSDevName == "CMS-N3-S-196.8")
{
message = "�x���a�k";
}
foreach (char word in message)
{
if (word == '[') str = "";
str += word;
if (word == ']')
{
changeTexts.Add(str);
}
}
System.Collections.Generic.List<RSPMegColor> rspMegColors = new System.Collections.Generic.List<RSPMegColor>();
try
{
foreach (string text in changeTexts)
{
int no = Convert.ToInt32(text.Substring(text.IndexOf('[') + 1, text.IndexOf(']') - 1));
string mag = setMessage(no,Location);
message = message.Replace(text,'\b' + mag + '\f');
MessColor messColor = (MessColor)messColorsHT[no];
//if (blockType == "2X8(���m)")
//{
// rspMegColors.Add(new RSPMegColor(mag, messColor.Forecolor, messColor.BackColor));
//}
//else
//{
rspMegColors.Add(new RSPMegColor(mag, getCMSWordColor(messColor.Forecolor, messColor.BackColor)));
//}
}
}
catch (OBSLastDeviceException)
{
message = "���h�p�߾r�p";
rspMegColors.Clear();
}
string newMeg = message.Replace("\r", "");
List<byte> colors = new List<byte>();
//byte[] colors = new byte[message.Replace("\r", "").Length];
for (int i = 0; i < newMeg.Length; i++)
{
colors.Add(32);
}
foreach (RSPMegColor de in rspMegColors)
{
for (int i = newMeg.IndexOf(de.Message); i <= newMeg.IndexOf(de.Message) + de.Message.Length - 1; i++)
{
if (i == -1) continue;
colors[i] = Convert.ToByte(de.Color);
if (newMeg[i] == '��')
colors.Insert(i, colors[i]);
}
}
RemoteInterface.HC.CMSOutputData outputData;
if (Show_icon == 1)
{
byte[] vspaces = new byte[colors.Count];
outputData = new RemoteInterface.HC.CMSOutputData(4, 0, 0, 0, message.Replace("��", "�@�@"), colors.ToArray(), vspaces);
outputData.AlarmClass = (int)ht["INC_NAME"];
}
else
{
outputData = new RemoteInterface.HC.CMSOutputData(0, 0, 0, message.Replace("��", "�@�@"), colors.ToArray());
outputData.AlarmClass = (int)ht["INC_NAME"];
}
switch (blockType)
{
case "1X4"://�]�w1x4���O��ܤ��e
return getDisplay(outputData, 1, 4);
case "2X6"://�]�w2X6���O��ܤ��e
return getDisplay(outputData, 2, 6);
case "2X8(�T��)"://�]�w2x8�T�⭱�O��ܤ��e
return getDisplay(outputData, 2, 8);
case "2X8(���m)":
return get2x8Display(outputData, isIcon);
case "3X6"://�]�w3X6���O��ܤ��e
return getDisplay(outputData, 3, 6);
case "5X2"://�]�w5X2���O��ܤ��e
return getDisplay(outputData, 2, 5);
case "8X1"://�]�w8X1���O��ܤ��e
return getDisplay(outputData, 1, 8);
default:
throw new Exception("�ʤ�CMS���O�w�q!!");
}
}
/// <summary>
/// Loads the thumbnail of the loaded image file, if any.
/// </summary>
/// <param name="binReader">A BinaryReader that points the loaded file byte stream.</param>
/// <param name="pfPixelFormat">A PixelFormat value indicating what pixel format to use when loading the thumbnail.</param>
private void LoadThumbnail(BinaryReader binReader, PixelFormat pfPixelFormat)
{
// read the Thumbnail image data into a byte array
// take into account stride has to be a multiple of 4
// use padding to make sure multiple of 4
byte[] data = null;
if (binReader != null && binReader.BaseStream != null && binReader.BaseStream.Length > 0 && binReader.BaseStream.CanSeek == true)
{
if (this.ExtensionArea.PostageStampOffset > 0)
{
// seek to the beginning of the image data using the ImageDataOffset value
binReader.BaseStream.Seek(this.ExtensionArea.PostageStampOffset, SeekOrigin.Begin);
int iWidth = (int)binReader.ReadByte();
int iHeight = (int)binReader.ReadByte();
int iStride = ((iWidth * (int)this.objTargaHeader.PixelDepth + 31) & ~31) >> 3; // width in bytes
int iPadding = iStride - (((iWidth * (int)this.objTargaHeader.PixelDepth) + 7) / 8);
System.Collections.Generic.List<System.Collections.Generic.List<byte>> rows = new System.Collections.Generic.List<System.Collections.Generic.List<byte>>();
System.Collections.Generic.List<byte> row = new System.Collections.Generic.List<byte>();
byte[] padding = new byte[iPadding];
MemoryStream msData = null;
bool blnEachRowReverse = false;
bool blnRowsReverse = false;
using (msData = new MemoryStream())
{
// get the size in bytes of each row in the image
int intImageRowByteSize = iWidth * ((int)this.objTargaHeader.PixelDepth / 8);
// get the size in bytes of the whole image
int intImageByteSize = intImageRowByteSize * iHeight;
// thumbnails are never compressed
for (int i = 0; i < iHeight; i++)
{
for (int j = 0; j < intImageRowByteSize; j++)
{
row.Add(binReader.ReadByte());
}
rows.Add(row);
row = null;
row = new System.Collections.Generic.List<byte>();
}
switch (this.objTargaHeader.FirstPixelDestination)
{
case FirstPixelDestination.TOP_LEFT:
break;
case FirstPixelDestination.TOP_RIGHT:
blnRowsReverse = false;
blnEachRowReverse = false;
break;
case FirstPixelDestination.BOTTOM_LEFT:
break;
case FirstPixelDestination.BOTTOM_RIGHT:
case FirstPixelDestination.UNKNOWN:
blnRowsReverse = true;
blnEachRowReverse = false;
break;
}
if (blnRowsReverse == true)
rows.Reverse();
for (int i = 0; i < rows.Count; i++)
{
if (blnEachRowReverse == true)
rows[i].Reverse();
byte[] brow = rows[i].ToArray();
msData.Write(brow, 0, brow.Length);
msData.Write(padding, 0, padding.Length);
}
data = msData.ToArray();
}
if (data != null && data.Length > 0)
{
this.ThumbnailByteHandle = GCHandle.Alloc(data, GCHandleType.Pinned);
this.bmpImageThumbnail = new Bitmap(iWidth, iHeight, iStride, pfPixelFormat,
this.ThumbnailByteHandle.AddrOfPinnedObject());
if (this.ThumbnailByteHandle != null && this.ThumbnailByteHandle.IsAllocated)
this.ThumbnailByteHandle.Free();
}
// clear our row arrays
if (rows != null)
{
for (int i = 0; i < rows.Count; i++)
{
rows[i].Clear();
rows[i] = null;
}
rows.Clear();
rows = null;
}
if (rows != null)
{
row.Clear();
row = null;
}
}
else
{
if (this.bmpImageThumbnail != null)
{
this.bmpImageThumbnail.Dispose();
this.bmpImageThumbnail = null;
}
}
}
else
{
if (this.bmpImageThumbnail != null)
{
this.bmpImageThumbnail.Dispose();
this.bmpImageThumbnail = null;
}
}
}
private void ClearEntGroupManagerWindows()
{
System.Collections.Generic.List<EntGroupManagerWindow> temEntGroupManagerWindows = new System.Collections.Generic.List<EntGroupManagerWindow>();
foreach (System.Collections.Generic.KeyValuePair<long, EntGroupManagerWindow> item in this.entGroupManagerWindows)
{
temEntGroupManagerWindows.Add(item.Value);
}
for (int i = 0; i < temEntGroupManagerWindows.Count; i++)
{
temEntGroupManagerWindows[i].Close();
}
temEntGroupManagerWindows.Clear();
this.entGroupManagerWindows.Clear();
}
/// <summary>
/// Загрузка данных в БД (запускается на статусе добавления данныз)
/// </summary>
/// <returns></returns>
private void UpdateInformationInDB()
{
//проверяем есть ли такой номер в БД (на случай если кто-то удалит его в процессе работы)
if (string.Compare(CheckInformation(), "0") != 0)
{
bool successToLoadData = false;
System.Collections.Generic.List<string> Parameters = new System.Collections.Generic.List<string>();
System.Collections.Generic.List<string> DataFromTextBox = new System.Collections.Generic.List<string>();
//Основные данные
Parameters.Add("OKUD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(Z10));
Parameters.Add("UTV_DOLZNOST"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(U4));
Parameters.Add("UTV_RAS_PODP"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(U6));
Parameters.Add("ORAGANIZATION_HEAD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(D12));
Parameters.Add("STRUCT_PODR_HEAD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(F14));
Parameters.Add("DATA_SOST"); DataFromTextBox.Add(H22.Value.ToString());
Parameters.Add("COD_VIDA_OPER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(K22));
Parameters.Add("STRUCT_PODR"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(M22));
Parameters.Add("NOMER_CEHA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(P22));
Parameters.Add("VID_DEYAT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(R22));
Parameters.Add("CORRESP_SCHET"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(U22));
Parameters.Add("COD_ZATRAT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(Y22));
Parameters.Add("PRICAZ_OT"); DataFromTextBox.Add(J26.Value.ToString());
Parameters.Add("PRICAZ_YEAR"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(S26));
Parameters.Add("KOL_PREDETOV"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(F86));
Parameters.Add("NOM_ACT_VIB"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(F89));
Parameters.Add("UTIL"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(F112));
//Итог 1
Parameters.Add("ITOG_KOL"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J83));
Parameters.Add("ITOG_DATA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(L83));
Parameters.Add("ITOG_CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(N83));
Parameters.Add("ITOG_SUM_CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(P83));
Parameters.Add("ITOG_SUM_AMOR"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(R83));
Parameters.Add("ITOG_SROK_SLUZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(T83));
Parameters.Add("ITOG_PRIHINA_NAIMENOV"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(V83));
Parameters.Add("ITOG_PRICH_COD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(X83));
Parameters.Add("ITOG_SROK"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(Z83));
//Итог 2
Parameters.Add("ITOGTWO_KOL"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(S103));
Parameters.Add("ITOGTWO_CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(U103));
Parameters.Add("ITOGTWO_SUMMA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(X103));
Parameters.Add("ITOGTWO_PORYAD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(Z103));
//Номер акта
Parameters.Add("N_ACT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J8));
string cmd = "UPDATE USP_ACTNASPISANIE_HEAD SET" +
" OKUD = :OKUD, "+
" UTV_DOLZNOST = :UTV_DOLZNOST, "+
" UTV_RAS_PODP = :UTV_RAS_PODP, "+
" ORAGANIZATION_HEAD = :ORAGANIZATION_HEAD, "+
" STRUCT_PODR_HEAD = :STRUCT_PODR_HEAD, " +
" DATA_SOST = to_date(:DATA_SOST,'DD.MM.YYYY hh24:mi:ss'), "+
" COD_VIDA_OPER = :COD_VIDA_OPER, "+
" STRUCT_PODR = :STRUCT_PODR, "+
" NOMER_CEHA = :NOMER_CEHA, "+
" VID_DEYAT = :VID_DEYAT, "+
" CORRESP_SCHET = :CORRESP_SCHET, "+
" COD_ZATRAT = :COD_ZATRAT, " +
" PRICAZ_OT = to_date(:PRICAZ_OT,'DD.MM.YYYY hh24:mi:ss'), "+
" PRICAZ_YEAR = :PRICAZ_YEAR, "+
" KOL_PREDETOV = :KOL_PREDETOV, "+
" NOM_ACT_VIB = :NOM_ACT_VIB, "+
" UTIL = :UTIL, "+
" ITOG_KOL = :ITOG_KOL, "+
" ITOG_DATA = :ITOG_DATA, "+
" ITOG_CENA = :ITOG_CENA, "+
" ITOG_SUM_CENA = :ITOG_SUM_CENA, " +
" ITOG_SUM_AMOR = :ITOG_SUM_AMOR, " +
" ITOG_SROK_SLUZ = :ITOG_SROK_SLUZ, "+
" ITOG_PRIHINA_NAIMENOV = :ITOG_PRIHINA_NAIMENOV, "+
" ITOG_PRICH_COD = :ITOG_PRICH_COD, "+
" ITOG_SROK = :ITOG_SROK, "+
" ITOGTWO_KOL = :ITOGTWO_KOL, "+
" ITOGTWO_CENA = :ITOGTWO_CENA, "+
" ITOGTWO_SUMMA = :ITOGTWO_SUMMA, "+
" ITOGTWO_PORYAD = :ITOGTWO_PORYAD " +
"WHERE N_ACT = :N_ACT";
successToLoadData = SQLOracle.UpdateQuery(cmd, Parameters, DataFromTextBox);
Parameters.Clear();
DataFromTextBox.Clear();
if (successToLoadData == true)
for (int i = 1; i < 6; i++)
{
if (successToLoadData == true)
{
string cmdDATA = "UPDATE USP_ACTNASPISANIE_DATA_ONE SET " +
" PREDMET_NAIM = :PREDMET_NAIM, " +
" PREDMET_NOMEN_NOMER = :PREDMET_NOMEN_NOMER, " +
" PREDMET_INVENT_NOMER = :PREDMET_INVENT_NOMER, " +
" ED_IZM_NAIM = :ED_IZM_NAIM, " +
" ED_IZM_KOD = :ED_IZM_KOD, "+
" KOL_VO =: KOL_VO, " +
" DATA_POSTUPLENIYA = to_date(:DATA_POSTUPLENIYA,'DD.MM.YYYY hh24:mi:ss'), " +
" CENA = :CENA, " +
" SUMMA_CENA_RUB = :SUMMA_CENA_RUB, " +
" SUMMA_AMORTIZ = :SUMMA_AMORTIZ, " +
" SROK_SLUZ = :SROK_SLUZ, " +
" PRICH_SPIS_NAIM =:PRICH_SPIS_NAIM, " +
" PRICH_SPIS_KOD = :PRICH_SPIS_KOD, " +
" NOMER_PASPORTA = :NOMER_PASPORTA WHERE " +
" ACT_NOMER = :ACT_NOMER AND" +
" NUMBER_OF_PANEL = :NUMBER_OF_PANEL " ;
Parameters.Add("PREDMET_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("A" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("PREDMET_NOMEN_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("A" + ((4 * (i - 1)) + 38).ToString()), true)[0])));
Parameters.Add("PREDMET_INVENT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("F" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("ED_IZM_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("H" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("ED_IZM_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("H" + ((4 * (i - 1)) + 38).ToString()), true)[0])));
Parameters.Add("KOL_VO"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("J" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("DATA_POSTUPLENIYA"); DataFromTextBox.Add(((System.Windows.Forms.DateTimePicker)(this.tabPage1.Controls.Find(("L" + ((4 * (i - 1)) + 36).ToString()), true)[0])).Value.ToString());
Parameters.Add("CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("N" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("SUMMA_CENA_RUB"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("P" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("SUMMA_AMORTIZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("R" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("SROK_SLUZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("T" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("PRICH_SPIS_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("V" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("PRICH_SPIS_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("X" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("NOMER_PASPORTA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage1.Controls.Find(("Z" + ((4 * (i - 1)) + 36).ToString()), true)[0])));
Parameters.Add("ACT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J8));
Parameters.Add("NUMBER_OF_PANEL"); DataFromTextBox.Add((i).ToString());
successToLoadData = SQLOracle.UpdateQuery(cmdDATA, Parameters, DataFromTextBox);
Parameters.Clear();
DataFromTextBox.Clear();
}
}
if (successToLoadData == true)
for (int i = 7; i < 12; i++)
{
if (successToLoadData == true)
{
string cmdDATA = "UPDATE USP_ACTNASPISANIE_DATA_ONE SET " +
" PREDMET_NAIM = :PREDMET_NAIM, " +
" PREDMET_NOMEN_NOMER = :PREDMET_NOMEN_NOMER, " +
" PREDMET_INVENT_NOMER = :PREDMET_INVENT_NOMER, " +
" ED_IZM_NAIM = :ED_IZM_NAIM, " +
" ED_IZM_KOD = :ED_IZM_KOD, " +
" KOL_VO =: KOL_VO, " +
" DATA_POSTUPLENIYA = to_date(:DATA_POSTUPLENIYA,'DD.MM.YYYY hh24:mi:ss'), " +
" CENA = :CENA, " +
" SUMMA_CENA_RUB = :SUMMA_CENA_RUB, " +
" SUMMA_AMORTIZ = :SUMMA_AMORTIZ, " +
" SROK_SLUZ = :SROK_SLUZ, " +
" PRICH_SPIS_NAIM =:PRICH_SPIS_NAIM, " +
" PRICH_SPIS_KOD = :PRICH_SPIS_KOD, " +
" NOMER_PASPORTA = :NOMER_PASPORTA WHERE " +
" ACT_NOMER = :ACT_NOMER AND " +
" NUMBER_OF_PANEL = :NUMBER_OF_PANEL " ;
Parameters.Add("PREDMET_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("A" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("PREDMET_NOMEN_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("A" + ((4 * (i - 1)) + 41).ToString()), true)[0])));
Parameters.Add("PREDMET_INVENT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("F" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("ED_IZM_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("H" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("ED_IZM_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("H" + ((4 * (i - 1)) + 41).ToString()), true)[0])));
Parameters.Add("KOL_VO"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("J" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("DATA_POSTUPLENIYA"); DataFromTextBox.Add(((System.Windows.Forms.DateTimePicker)(this.tabPage2.Controls.Find(("L" + ((4 * (i - 1)) + 39).ToString()), true)[0])).Value.ToString());
Parameters.Add("CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("N" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("SUMMA_CENA_RUB"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("P" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("SUMMA_AMORTIZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("R" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("SROK_SLUZ"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("T" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("PRICH_SPIS_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("V" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("PRICH_SPIS_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("X" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("NOMER_PASPORTA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("Z" + ((4 * (i - 1)) + 39).ToString()), true)[0])));
Parameters.Add("ACT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J8));
Parameters.Add("NUMBER_OF_PANEL"); DataFromTextBox.Add((i).ToString());
successToLoadData = SQLOracle.UpdateQuery(cmdDATA, Parameters, DataFromTextBox);
Parameters.Clear();
DataFromTextBox.Clear();
}
}
if (successToLoadData == true)
for (int i = 1; i <= 2; i++)
{
if (successToLoadData == true)
{
string cmdDATA = "UPDATE USP_ACTNASPISANIE_DATA_TWO SET " +
" KOD_VIDA_OPER =: KOD_VIDA_OPER, " +
" VID_DEYAT =: VID_DEYAT, " +
" STRUCT_PODR =: STRUCT_PODR, " +
" UTIL_NAIM = :UTIL_NAIM, " +
" UTIL_NOMEN_NOMER = :UTIL_NOMEN_NOMER, " +
" ED_IZM_NAIM =:ED_IZM_NAIM, " +
" ED_IZM_KOD =:ED_IZM_KOD, " +
" KOL_VO =:KOL_VO, " +
" CENA = :CENA, " +
" SUMMA_RUB =:SUMMA_RUB, " +
" PORYADKOV_NUM =:PORYADKOV_NUM" +
" WHERE ACT_NOMER = :ACT_NOMER AND " +
" NUMBER_OF_PANEL = :NUMBER_OF_PANEL ";
Parameters.Add("KOD_VIDA_OPER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("A" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("VID_DEYAT"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("C" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("STRUCT_PODR"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("F" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("UTIL_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("I" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("UTIL_NOMEN_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("L" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("ED_IZM_NAIM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("O" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("ED_IZM_KOD"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("Q" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("KOL_VO"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("S" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("CENA"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("U" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("SUMMA_RUB"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("X" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("PORYADKOV_NUM"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr((System.Windows.Forms.TextBox)(this.tabPage2.Controls.Find(("Z" + ((2 * (i - 1)) + 99).ToString()), true)[0])));
Parameters.Add("ACT_NOMER"); DataFromTextBox.Add(PriemSpisanie.IsNullParametr(J8));
Parameters.Add("NUMBER_OF_PANEL"); DataFromTextBox.Add((i).ToString());
successToLoadData = SQLOracle.UpdateQuery(cmdDATA, Parameters, DataFromTextBox);
Parameters.Clear();
DataFromTextBox.Clear();
}
}
if (successToLoadData == true)
{
MessageBox.Show("Данные успешно обновлены!");
}
}
else
{
MessageBox.Show(CheckInformation(), "Ошибка!");
}
}
/// <summary>
/// Takes an ISF Stream and populates the StrokeCollection
/// attached to this StrokeCollectionSerializer.
/// </summary>
/// <param name="inputStream">a Stream the raw isf to decode</param>
#endif
private void DecodeRawISF(Stream inputStream)
{
Debug.Assert(inputStream != null);
KnownTagCache.KnownTagIndex isfTag;
uint remainingBytesInStream;
uint bytesDecodedInCurrentTag = 0;
bool strokeDescriptorBlockDecoded = false;
bool drawingAttributesBlockDecoded = false;
bool metricBlockDecoded = false;
bool transformDecoded = false;
uint strokeDescriptorTableIndex = 0;
uint oldStrokeDescriptorTableIndex = 0xFFFFFFFF;
uint drawingAttributesTableIndex = 0;
uint oldDrawingAttributesTableIndex = 0xFFFFFFFF;
uint metricDescriptorTableIndex = 0;
uint oldMetricDescriptorTableIndex = 0xFFFFFFFF;
uint transformTableIndex = 0;
uint oldTransformTableIndex = 0xFFFFFFFF;
GuidList guidList = new GuidList();
int strokeIndex = 0;
StylusPointDescription currentStylusPointDescription = null;
Matrix currentTabletToInkTransform = Matrix.Identity;
_strokeDescriptorTable = new System.Collections.Generic.List<StrokeDescriptor>();
_drawingAttributesTable = new System.Collections.Generic.List<DrawingAttributes>();
_transformTable = new System.Collections.Generic.List<TransformDescriptor>();
_metricTable = new System.Collections.Generic.List<MetricBlock>();
// First make sure this ink is empty
if (0 != _coreStrokes.Count || _coreStrokes.ExtendedProperties.Count != 0)
{
throw new InvalidOperationException(ISFDebugMessage("ISF decoder cannot operate on non-empty ink container"));
}
#if OLD_ISF
//
// store a compressor reference at this scope, if it is needed (if there is a compresson header) and
// therefore instanced during this routine, we will dispose of it
// in the finally block
//
Compressor compressor = null;
try
{
#endif
// First read the isfTag
uint uiTag;
uint localBytesDecoded = SerializationHelper.Decode(inputStream, out uiTag);
if (0x00 != uiTag)
throw new ArgumentException(SR.Get(SRID.InvalidStream));
// Now read the size of the stream
localBytesDecoded = SerializationHelper.Decode(inputStream, out remainingBytesInStream);
ISFDebugTrace("Decoded Stream Size in Bytes: " + remainingBytesInStream.ToString());
if (0 == remainingBytesInStream)
return;
while (0 < remainingBytesInStream)
{
bytesDecodedInCurrentTag = 0;
// First read the isfTag
localBytesDecoded = SerializationHelper.Decode(inputStream, out uiTag);
isfTag = (KnownTagCache.KnownTagIndex)uiTag;
if (remainingBytesInStream >= localBytesDecoded)
remainingBytesInStream -= localBytesDecoded;
else
{
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
}
ISFDebugTrace("Decoding Tag: " + ((KnownTagCache.KnownTagIndex)isfTag).ToString());
switch (isfTag)
{
case KnownTagCache.KnownTagIndex.GuidTable:
case KnownTagCache.KnownTagIndex.DrawingAttributesTable:
case KnownTagCache.KnownTagIndex.DrawingAttributesBlock:
case KnownTagCache.KnownTagIndex.StrokeDescriptorTable:
case KnownTagCache.KnownTagIndex.StrokeDescriptorBlock:
case KnownTagCache.KnownTagIndex.MetricTable:
case KnownTagCache.KnownTagIndex.MetricBlock:
case KnownTagCache.KnownTagIndex.TransformTable:
case KnownTagCache.KnownTagIndex.ExtendedTransformTable:
case KnownTagCache.KnownTagIndex.Stroke:
case KnownTagCache.KnownTagIndex.CompressionHeader:
case KnownTagCache.KnownTagIndex.PersistenceFormat:
case KnownTagCache.KnownTagIndex.HimetricSize:
case KnownTagCache.KnownTagIndex.StrokeIds:
{
localBytesDecoded = SerializationHelper.Decode(inputStream, out bytesDecodedInCurrentTag);
if (remainingBytesInStream < (localBytesDecoded + bytesDecodedInCurrentTag))
{
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"), "inputStream");
}
remainingBytesInStream -= localBytesDecoded;
// Based on the isfTag figure out what information we're loading
switch (isfTag)
{
case KnownTagCache.KnownTagIndex.GuidTable:
{
// Load guid Table
localBytesDecoded = guidList.Load(inputStream, bytesDecodedInCurrentTag);
break;
}
case KnownTagCache.KnownTagIndex.DrawingAttributesTable:
{
// Load drawing attributes table
localBytesDecoded = LoadDrawAttrsTable(inputStream, guidList, bytesDecodedInCurrentTag);
drawingAttributesBlockDecoded = true;
break;
}
case KnownTagCache.KnownTagIndex.DrawingAttributesBlock:
{
//initialize to V1 defaults, we do it this way as opposed
//to dr.DrawingFlags = 0 because this was a perf hot spot
//and instancing the epc first mitigates it
ExtendedPropertyCollection epc = new ExtendedPropertyCollection();
epc.Add(KnownIds.DrawingFlags, DrawingFlags.Polyline);
DrawingAttributes dr = new DrawingAttributes(epc);
localBytesDecoded = DrawingAttributeSerializer.DecodeAsISF(inputStream, guidList, bytesDecodedInCurrentTag, dr);
_drawingAttributesTable.Add(dr);
drawingAttributesBlockDecoded = true;
break;
}
case KnownTagCache.KnownTagIndex.StrokeDescriptorTable:
{
// Load stroke descriptor table
localBytesDecoded = DecodeStrokeDescriptorTable(inputStream, bytesDecodedInCurrentTag);
strokeDescriptorBlockDecoded = true;
break;
}
case KnownTagCache.KnownTagIndex.StrokeDescriptorBlock:
{
// Load a single stroke descriptor
localBytesDecoded = DecodeStrokeDescriptorBlock(inputStream, bytesDecodedInCurrentTag);
strokeDescriptorBlockDecoded = true;
break;
}
case KnownTagCache.KnownTagIndex.MetricTable:
{
// Load Metric Table
localBytesDecoded = DecodeMetricTable(inputStream, bytesDecodedInCurrentTag);
metricBlockDecoded = true;
break;
}
case KnownTagCache.KnownTagIndex.MetricBlock:
{
// Load a single Metric Block
MetricBlock blk;
localBytesDecoded = DecodeMetricBlock(inputStream, bytesDecodedInCurrentTag, out blk);
_metricTable.Clear();
_metricTable.Add(blk);
metricBlockDecoded = true;
break;
}
case KnownTagCache.KnownTagIndex.TransformTable:
{
// Load Transform Table
localBytesDecoded = DecodeTransformTable(inputStream, bytesDecodedInCurrentTag, false);
transformDecoded = true;
break;
}
case KnownTagCache.KnownTagIndex.ExtendedTransformTable:
{
// non-double transform table should have already been loaded
if (!transformDecoded)
{
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
}
// Load double-sized Transform Table
localBytesDecoded = DecodeTransformTable(inputStream, bytesDecodedInCurrentTag, true);
break;
}
case KnownTagCache.KnownTagIndex.PersistenceFormat:
{
uint fmt;
localBytesDecoded = SerializationHelper.Decode(inputStream, out fmt);
// Set the appropriate persistence information
if (0 == fmt)
{
CurrentPersistenceFormat = PersistenceFormat.InkSerializedFormat;
}
else if (0x00000001 == fmt)
{
CurrentPersistenceFormat = PersistenceFormat.Gif;
}
break;
}
case KnownTagCache.KnownTagIndex.HimetricSize:
{
// Loads the Hi Metric Size for Fortified GIFs
int sz;
localBytesDecoded = SerializationHelper.SignDecode(inputStream, out sz);
if (localBytesDecoded > remainingBytesInStream)
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
_himetricSize.X = (double)sz;
localBytesDecoded += SerializationHelper.SignDecode(inputStream, out sz);
_himetricSize.Y = (double)sz;
break;
}
case KnownTagCache.KnownTagIndex.CompressionHeader:
{
#if OLD_ISF
byte[] data = new byte[bytesDecodedInCurrentTag];
// read the header from the stream
uint bytesRead = StrokeCollectionSerializer.ReliableRead(inputStream, data, bytesDecodedInCurrentTag);
if (bytesDecodedInCurrentTag != bytesRead)
{
throw new ArgumentException(StrokeCollectionSerializer.ISFDebugMessage("Read different size from stream then expected"), "isfStream");
}
uint size = bytesDecodedInCurrentTag;
compressor = new Compressor(data, ref size);
// in case the actual number of bytes read by the compressor
// is less than the encoder had expected (e.g. compression
// header was encoded as 10 bytes, but only 7 bytes were read)
// then we don't want to adjust the stream position because
// there are likely other following tags that are encoded
// after the compression tag. This should never happen,
// so just fail if the compressor is broken or the ISF is
// corrupted.
if (size != bytesDecodedInCurrentTag)
{
throw new InvalidOperationException(ISFDebugMessage("Compressor intialization reported inconsistent size"));
}
#else
//just advance the inputstream position, we don't need
//no compression header in the new isf decoding
inputStream.Seek(bytesDecodedInCurrentTag, SeekOrigin.Current);
#endif
localBytesDecoded = bytesDecodedInCurrentTag;
break;
}
case KnownTagCache.KnownTagIndex.StrokeIds:
{
localBytesDecoded = LoadStrokeIds(inputStream, bytesDecodedInCurrentTag);
break;
}
case KnownTagCache.KnownTagIndex.Stroke:
{
ISFDebugTrace(" Decoding Stroke Id#(" + (strokeIndex + 1).ToString() + ")");
StrokeDescriptor strokeDescriptor = null;
// Load the stroke descriptor based on the index from the list of unique
// stroke descriptors
if (strokeDescriptorBlockDecoded)
{
if (oldStrokeDescriptorTableIndex != strokeDescriptorTableIndex)
{
if (_strokeDescriptorTable.Count <= strokeDescriptorTableIndex)
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
}
strokeDescriptor = _strokeDescriptorTable[(int)strokeDescriptorTableIndex];
}
// use new transform if the last transform is uninit'd or has changed
if (oldTransformTableIndex != transformTableIndex)
{
// if transform was specified in the ISF stream
if (transformDecoded)
{
if (_transformTable.Count <= transformTableIndex)
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
// Load the transform descriptor based on the index from the list of unique
// transforn descriptors
currentTabletToInkTransform = LoadTransform(_transformTable[(int)transformTableIndex]);
}
oldTransformTableIndex = transformTableIndex; // cache the transform by remembering the index
// since ISF is stored in HIMETRIC, and we want to expose packet data
// as Avalon units, we'll update the convert the transform before loading the stroke
currentTabletToInkTransform.Scale(StrokeCollectionSerializer.HimetricToAvalonMultiplier, StrokeCollectionSerializer.HimetricToAvalonMultiplier);
}
MetricBlock metricBlock = null;
// Load the metric block based on the index from the list of unique metric blocks
if (metricBlockDecoded)
{
if (oldMetricDescriptorTableIndex != metricDescriptorTableIndex)
{
if (_metricTable.Count <= metricDescriptorTableIndex)
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
}
metricBlock = _metricTable[(int)metricDescriptorTableIndex];
}
DrawingAttributes activeDrawingAttributes = null;
// Load the drawing attributes based on the index from the list of unique drawing attributes
if (drawingAttributesBlockDecoded)
{
if (oldDrawingAttributesTableIndex != drawingAttributesTableIndex)
{
if (_drawingAttributesTable.Count <= drawingAttributesTableIndex)
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
oldDrawingAttributesTableIndex = drawingAttributesTableIndex;
}
DrawingAttributes currDA = (DrawingAttributes)_drawingAttributesTable[(int)drawingAttributesTableIndex];
//we always clone so we don't get strokes that share DAs, which can lead
//to all sorts of unpredictable behavior (ex: see Windows OS Bugs 1450047)
activeDrawingAttributes = currDA.Clone();
}
// if we didn't find an existing da to use, instance a new one
if (activeDrawingAttributes == null)
{
activeDrawingAttributes = new DrawingAttributes();
}
// Now create the StylusPacketDescription from the stroke descriptor and metric block
if (oldMetricDescriptorTableIndex != metricDescriptorTableIndex || oldStrokeDescriptorTableIndex != strokeDescriptorTableIndex)
{
currentStylusPointDescription = BuildStylusPointDescription(strokeDescriptor, metricBlock, guidList);
oldStrokeDescriptorTableIndex = strokeDescriptorTableIndex;
oldMetricDescriptorTableIndex = metricDescriptorTableIndex;
}
// Load the stroke
Stroke localStroke;
#if OLD_ISF
localBytesDecoded = StrokeSerializer.DecodeStroke(inputStream, bytesDecodedInCurrentTag, guidList, strokeDescriptor, currentStylusPointDescription, activeDrawingAttributes, currentTabletToInkTransform, compressor, out localStroke);
#else
localBytesDecoded = StrokeSerializer.DecodeStroke(inputStream, bytesDecodedInCurrentTag, guidList, strokeDescriptor, currentStylusPointDescription, activeDrawingAttributes, currentTabletToInkTransform, out localStroke);
#endif
if (localStroke != null)
{
_coreStrokes.AddWithoutEvent(localStroke);
strokeIndex++;
}
break;
}
default:
{
throw new InvalidOperationException(ISFDebugMessage("Invalid ISF tag logic"));
}
}
// if this isfTag's decoded size != expected size, then error out
if (localBytesDecoded != bytesDecodedInCurrentTag)
{
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
}
break;
}
case KnownTagCache.KnownTagIndex.Transform:
case KnownTagCache.KnownTagIndex.TransformIsotropicScale:
case KnownTagCache.KnownTagIndex.TransformAnisotropicScale:
case KnownTagCache.KnownTagIndex.TransformRotate:
case KnownTagCache.KnownTagIndex.TransformTranslate:
case KnownTagCache.KnownTagIndex.TransformScaleAndTranslate:
{
// Load a single Transform Block
TransformDescriptor xform;
bytesDecodedInCurrentTag = DecodeTransformBlock(inputStream, isfTag, remainingBytesInStream, false, out xform);
transformDecoded = true;
_transformTable.Clear();
_transformTable.Add(xform);
break;
}
case KnownTagCache.KnownTagIndex.TransformTableIndex:
{
// Load the Index into the Transform Table which will be used by the stroke following this till
// a next different Index is found
bytesDecodedInCurrentTag = SerializationHelper.Decode(inputStream, out transformTableIndex);
break;
}
case KnownTagCache.KnownTagIndex.MetricTableIndex:
{
// Load the Index into the Metric Table which will be used by the stroke following this till
// a next different Index is found
bytesDecodedInCurrentTag = SerializationHelper.Decode(inputStream, out metricDescriptorTableIndex);
break;
}
case KnownTagCache.KnownTagIndex.DrawingAttributesTableIndex:
{
// Load the Index into the Drawing Attributes Table which will be used by the stroke following this till
// a next different Index is found
bytesDecodedInCurrentTag = SerializationHelper.Decode(inputStream, out drawingAttributesTableIndex);
break;
}
case KnownTagCache.KnownTagIndex.InkSpaceRectangle:
{
// Loads the Ink Space Rectangle information
bytesDecodedInCurrentTag = DecodeInkSpaceRectangle(inputStream, remainingBytesInStream);
break;
}
case KnownTagCache.KnownTagIndex.StrokeDescriptorTableIndex:
{
// Load the Index into the Stroke Descriptor Table which will be used by the stroke following this till
// a next different Index is found
bytesDecodedInCurrentTag = SerializationHelper.Decode(inputStream, out strokeDescriptorTableIndex);
break;
}
default:
{
if ((uint)isfTag >= KnownIdCache.CustomGuidBaseIndex || ((uint)isfTag >= KnownTagCache.KnownTagCount && ((uint)isfTag < (KnownTagCache.KnownTagCount + KnownIdCache.OriginalISFIdTable.Length))))
{
ISFDebugTrace(" CUSTOM_GUID=" + guidList.FindGuid(isfTag).ToString());
// Loads any custom property data
bytesDecodedInCurrentTag = remainingBytesInStream;
Guid guid = guidList.FindGuid(isfTag);
if (guid == Guid.Empty)
{
throw new ArgumentException(StrokeCollectionSerializer.ISFDebugMessage("Global Custom Attribute tag embedded in ISF stream does not match guid table"), "inkdata");
}
object data;
// load the custom property data from the stream (and decode the type)
localBytesDecoded = ExtendedPropertySerializer.DecodeAsISF(inputStream, bytesDecodedInCurrentTag, guidList, isfTag, ref guid, out data);
if (localBytesDecoded > bytesDecodedInCurrentTag)
{
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"), "inkdata");
}
// add the guid/data pair into the property collection (don't redecode the type)
_coreStrokes.ExtendedProperties[guid] = data;
}
else
{
// Skip objects that this library doesn't know about
// First read the size associated with this unknown isfTag
localBytesDecoded = SerializationHelper.Decode(inputStream, out bytesDecodedInCurrentTag);
if (remainingBytesInStream < (localBytesDecoded + bytesDecodedInCurrentTag))
{
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
}
else
{
inputStream.Seek(bytesDecodedInCurrentTag + localBytesDecoded, SeekOrigin.Current);
}
}
bytesDecodedInCurrentTag = localBytesDecoded;
break;
}
}
ISFDebugTrace(" Size = " + bytesDecodedInCurrentTag.ToString());
if (bytesDecodedInCurrentTag > remainingBytesInStream)
{
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"));
}
// update remaining ISF buffer length with decoded so far
remainingBytesInStream -= bytesDecodedInCurrentTag;
}
#if OLD_ISF
}
finally
{
if (null != compressor)
{
compressor.Dispose();
compressor = null;
}
}
#endif
if (0 != remainingBytesInStream)
throw new ArgumentException(ISFDebugMessage("Invalid ISF data"), "inkdata");
}
static void Main(string[] args)
{
const int maxItems = 1000000;
const int maxLoopTest = 1000;
var itemList = new System.Collections.Generic.List<Item>();
itemList.Capacity = maxLoopTest;
for (int X = 0; X < maxLoopTest; ++X)
{
for (int i = 0; i < maxItems / 2; ++i)
{
if (i % 2 == 0)
itemList.Add(new Sword("Excalibur"));
else
itemList.Add(new Axe("Horned Axe"));
}
for (int i = 0; i < maxItems / 2; ++i)
{
if (i % 2 == 0)
itemList.Add(new HealthPotion("Elixir"));
else
itemList.Add(new ManaPotion("Ether"));
}
useAllItems(itemList);
itemList.Clear();
}
}
public static void DeleteElementFromDB(System.Windows.Forms.DataGridView dgv)
{
using (WinForms.Common.InputBox InputnumberOfElements = new UchetUSP.WinForms.Common.InputBox("Удаление элементов", "Удалить", "Количество удаляемых элементов"))
{
if (InputnumberOfElements.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (string.Compare(InputnumberOfElements.textBox1.Text, "") != 0)
{
if (Convert.ToInt32(dgv[19, dgv.SelectedCells[0].RowIndex].Value.ToString()) >= Convert.ToInt32(InputnumberOfElements.textBox1.Text))
{
System.Collections.Generic.List<string> Parameters = new System.Collections.Generic.List<string>();
System.Collections.Generic.List<string> DataFromTextBox = new System.Collections.Generic.List<string>();
int NalichieParam = 0;
NalichieParam = (Convert.ToInt32(dgv[19, dgv.SelectedCells[0].RowIndex].Value.ToString()) - Convert.ToInt32(InputnumberOfElements.textBox1.Text));
Parameters.Add("NALICHI"); DataFromTextBox.Add(NalichieParam.ToString());
Parameters.Add("OBOZN"); DataFromTextBox.Add(dgv[1, dgv.SelectedCells[0].RowIndex].Value.ToString());
string cmd = "UPDATE DB_DATA SET NALICHI =:NALICHI WHERE OBOZN = :OBOZN";
if (SQLOracle.UpdateQuery(cmd, Parameters, DataFromTextBox) == true)
{
System.Windows.Forms.MessageBox.Show("ОБновление данных прошло успешно!");
}
Parameters.Clear();
DataFromTextBox.Clear();
}
}
}
}
}
