public virtual JsonResult GetFormData(QueryMode queryMode)
{
if (queryMode.ProcessCode == "null")
{
queryMode.ProcessCode = null;
}
if (queryMode.SharedUser == "null")
{
queryMode.SharedUser = null;
}
var workMode = this.GetWorkMode(queryMode);
#region formInput
var formInput = new KStarFormInput();
//formInput.UserName = CurrentUser.UserAccount;//Startup
formInput.UserName = !string.IsNullOrEmpty(queryMode.UserAccount) ? queryMode.UserAccount : CurrentUser?.UserAccount;
formInput.ProcessCode = queryMode.ProcessCode;//Startup
formInput.Url = queryMode.Url;
formInput.SN = queryMode.SN;
formInput.WorkItemId = queryMode.WorkId;
formInput.FormId = queryMode.FormId;
formInput.SharedUser = queryMode.SharedUser;
formInput.CcId = queryMode.CcId;
formInput.Token = queryMode.token;
#endregion
var model = kStarFormHandleService.GetFormData(queryMode, formInput, workMode, CurrentUser?.UserAccount);
return(Json(model, JsonRequestBehavior.AllowGet));
}
public Task <int> ExecuteDmlAsync <T>(QueryMode queryMode, Expression expression, CancellationToken cancellationToken)
{
if (Collection != null)
{
throw new NotSupportedException("DML operations are not supported for filters.");
}
if (cancellationToken.IsCancellationRequested)
{
return(Task.FromCanceled <int>(cancellationToken));
}
try
{
var nhLinqExpression = new NhLinqDmlExpression <T>(queryMode, expression, Session.Factory);
var query = Session.CreateQuery(nhLinqExpression);
SetParameters(query, nhLinqExpression.ParameterValuesByName);
_options?.Apply(query);
return(query.ExecuteUpdateAsync(cancellationToken));
}
catch (Exception ex)
{
return(Task.FromException <int>(ex));
}
}
private void QueryControl(NvGpuVmm vmm, GpuMethodCall methCall)
{
WriteRegister(methCall);
long position = MakeInt64From2xInt32(NvGpuEngine3dReg.QueryAddress);
int seq = Registers[(int)NvGpuEngine3dReg.QuerySequence];
int ctrl = Registers[(int)NvGpuEngine3dReg.QueryControl];
QueryMode mode = (QueryMode)(ctrl & 3);
switch (mode)
{
case QueryMode.WriteSeq: vmm.WriteInt32(position, seq); break;
case QueryMode.WriteCounterAndTimestamp:
{
//TODO: Implement counters.
long counter = 1;
long timestamp = PerformanceCounter.ElapsedMilliseconds;
vmm.WriteInt64(position + 0, counter);
vmm.WriteInt64(position + 8, timestamp);
break;
}
}
}
public Query(QueryMode mode)
{
Fields = new List<string>();
WhereStatements = new List<WhereStatement>();
OrderStatements = new List<OrderStatement>();
Mode = mode;
}
public static WorkMode GetWorkMode(this ControllerBase controller, QueryMode queryMode)
{
var workMode = WorkMode.View;
if (queryMode.WorkId > 0)
{
workMode = WorkMode.Approval;
}
else if (queryMode.DraftId > 0)
{
workMode = WorkMode.Draft;
}
else if (!string.IsNullOrEmpty(queryMode.ProcessCode))
{
workMode = WorkMode.Startup;
}
else if (queryMode.FormId > 0)
{
workMode = WorkMode.View;
}
else if (!string.IsNullOrEmpty(queryMode.K2Id))
{
workMode = WorkMode.PreStartup;
}
return(workMode);
}
public WindowPictures(QueryMode mode, MainWindow parent, string primary_key_value = "")
{
InitializeComponent();
this.mode = mode;
this.parent = parent;
this.primary_key_value = primary_key_value;
if (mode == QueryMode.add)
{
Button_reset.Visibility = Visibility.Collapsed;
Button_accept.Content = "Добавить";
}
else
{
Button_accept.Content = "Изменить";
TextBox_name.Text = primary_key_value;
byte[] image_bytes = Shortcuts.get_image("pictures", "name", primary_key_value, connection);
new_image = image_bytes;
Shortcuts.set_image(Image, image_bytes);
TextBox_price.Text = Shortcuts.get_one_string_data_from($"select `price` from `pictures` where `name` = '{primary_key_value}'", connection);
TextBox_price.Text = TextBox_price.Text.Replace(",", ".");
old_values = new object[2] {
primary_key_value,
image_bytes
};
}
}
/// <summary>
/// The default constructor.
/// </summary>
/// <param name="queryMode">The query mode of the expression to pre-transform.</param>
/// <param name="sessionFactory">The session factory used in the pre-transform process.</param>
public PreTransformationParameters(QueryMode queryMode, ISessionFactoryImplementor sessionFactory)
{
QueryMode = queryMode;
SessionFactory = sessionFactory;
// Skip detecting variables for DML queries as HQL does not support reusing parameters for them.
MinimizeParameters = QueryMode == QueryMode.Select;
}
public PreviewPane(string fsId, QueryMode mode, ClassDefinition cls, IFeatureService featSvc, FdoProviderCapabilities caps)
: this()
{
_fsId = fsId;
_mode = mode;
_cls = cls;
_featSvc = featSvc;
IQueryControl ctrl = null;
switch (_mode)
{
case QueryMode.SQL:
ctrl = new SqlQueryCtrl(fsId, featSvc);
_inner = ctrl;
break;
case QueryMode.Standard:
ctrl = new StandardQueryCtrl(fsId, featSvc, cls, caps);
_inner = ctrl;
break;
}
if (ctrl == null)
{
throw new ArgumentException(Strings.UnknownQueryMode);
}
ctrl.Content.Dock = DockStyle.Fill;
queryPane.Controls.Add(ctrl.Content);
}
private void QueryControl(NvGpuVmm Vmm, NvGpuPBEntry PBEntry)
{
WriteRegister(PBEntry);
long Position = MakeInt64From2xInt32(NvGpuEngine3dReg.QueryAddress);
int Seq = Registers[(int)NvGpuEngine3dReg.QuerySequence];
int Ctrl = Registers[(int)NvGpuEngine3dReg.QueryControl];
QueryMode Mode = (QueryMode)(Ctrl & 3);
switch (Mode)
{
case QueryMode.WriteSeq: Vmm.WriteInt32(Position, Seq); break;
case QueryMode.WriteCounterAndTimestamp:
{
//TODO: Implement counters.
long Counter = 1;
long Timestamp = PerformanceCounter.ElapsedMilliseconds;
Timestamp = (long)(Timestamp * 615384.615385);
Vmm.WriteInt64(Position + 0, Counter);
Vmm.WriteInt64(Position + 8, Timestamp);
break;
}
}
}
internal NhLinqExpression(QueryMode queryMode, Expression expression, ISessionFactoryImplementor sessionFactory)
{
QueryMode = queryMode;
var preTransformResult = NhRelinqQueryParser.PreTransform(
expression,
new PreTransformationParameters(queryMode, sessionFactory));
_expression = preTransformResult.Expression;
// We want logging to be as close as possible to the original expression sent from the
// application. But if we log before partial evaluation done in PreTransform, the log won't
// include e.g. sub-query expressions if those are defined by the application in a variable
// referenced from the main query.
LinqLogging.LogExpression("Expression (partially evaluated)", _expression);
_expression = ExpressionParameterVisitor.Visit(preTransformResult, out _constantToParameterMap);
ParameterValuesByName = _constantToParameterMap.Values.Distinct().ToDictionary(p => p.Name,
p => System.Tuple.Create(p.Value, p.Type));
Key = ExpressionKeyVisitor.Visit(_expression, _constantToParameterMap);
Type = _expression.Type;
// Note - re-linq handles return types via the GetOutputDataInfo method, and allows for SingleOrDefault here for the ChoiceResultOperator...
ReturnType = NhLinqExpressionReturnType.Scalar;
if (typeof(IQueryable).IsAssignableFrom(Type))
{
Type = Type.GetGenericArguments()[0];
ReturnType = NhLinqExpressionReturnType.Sequence;
}
}
public IntermediateHqlTree(bool root, QueryMode mode)
{
_isRoot = root;
TreeBuilder = new HqlTreeBuilder();
if (mode == QueryMode.Delete)
{
_root = TreeBuilder.Delete(TreeBuilder.From());
}
else if (mode == QueryMode.Update)
{
_root = TreeBuilder.Update(TreeBuilder.From(), TreeBuilder.Set());
}
else if (mode == QueryMode.UpdateVersioned)
{
_root = TreeBuilder.Update(TreeBuilder.Versioned(), TreeBuilder.From(), TreeBuilder.Set());
}
else if (mode == QueryMode.Insert)
{
_root = TreeBuilder.Query(TreeBuilder.SelectFrom(TreeBuilder.From()));
_insertRoot = TreeBuilder.Insert(TreeBuilder.Into(), _root as HqlQuery);
}
else
{
_root = TreeBuilder.Query(TreeBuilder.SelectFrom(TreeBuilder.From()));
}
}
public FiltersPage(QueryMode mode, Dictionary <string, object> filterParams, ApplyFilterDelegate applyFilterEvent)
{
InitializeComponent();
_mode = mode;
_filterParams = filterParams;
_applyFilterEvent += applyFilterEvent;
SetupFilters();
}
public SqlQuery CreateQuery(QueryMode queryMode)
{
SqlQuery q = new SqlQuery(queryMode);
q.Session = this;
return(q);
}
public SqlQuery CreateQuery(QueryMode queryMode)
{
SqlQuery q = new SqlQuery(queryMode);
q.Session = this;
return q;
}
protected DatabaseReader(string filename, IndexManager indexManager,
IEnumerable<IWhereQueryConstraint> constraints, QueryMode queryMode = QueryMode.Auto)
: base(null, constraints)
{
byteConverter = new ByteConverter();
this.filename = filename;
this.indexManager = indexManager;
this.queryMode = queryMode;
}
public QueryServer(QueryMode mode, int port)
{
_mode = mode;
_port = port;
var queryThread = new Thread(Run);
queryThread.Start();
RunningServers.Add(queryThread);
Logger.WriteInternal("[---] Started a new QueryServer on port " + port);
}
private QueryModelVisitor(VisitorParameters visitorParameters, bool root, QueryModel queryModel,
NhLinqExpressionReturnType?rootReturnType)
{
_queryMode = root ? visitorParameters.RootQueryMode : QueryMode.Select;
VisitorParameters = visitorParameters;
Model = queryModel;
_rootReturnType = root ? rootReturnType : null;
_hqlTree = new IntermediateHqlTree(root, _queryMode);
}
public void AddAnyQuery(EntityQuery any)
{
if (null == any)
{
return;
}
m_AnyQueries.Add(any);
m_Mode |= QueryMode.ContainsAny;
}
public WindowUsers(QueryMode mode, MainWindow parent, string primary_key_value = "")
{
InitializeComponent();
this.mode = mode;
this.parent = parent;
this.primary_key_value = primary_key_value;
ComboBox_role.ItemsSource = Shortcuts.get_full_column_from("roles", "role", connection);
ComboBox_gender.ItemsSource = Shortcuts.get_full_column_from("genders", "gender", connection);
if (mode == QueryMode.add)
{
Button_reset.Visibility = Visibility.Collapsed;
Button_accept.Content = "Добавить";
}
else
{
Button_accept.Content = "Изменить";
byte[] image_bytes = Shortcuts.get_image("users", "mail", primary_key_value, connection);
new_image = image_bytes;
Shortcuts.set_image(Image, image_bytes);
try
{
connection.Open();
MySqlCommand comm = new MySqlCommand($"SELECT * FROM `users` WHERE `mail` = '{primary_key_value}'", connection);
MySqlDataReader data = comm.ExecuteReader();
data.Read();
TextBox_mail.Text = primary_key_value;
TextBox_password.Text = data[1].ToString();
TextBox_surname.Text = data[2].ToString();
TextBox_first_name.Text = data[3].ToString();
TextBox_second_name.Text = data[4].ToString();
TextBox_phone.Text = data[5].ToString();
ComboBox_role.Text = data[6].ToString();
ComboBox_gender.Text = data[7].ToString();
old_values = new object[9] {
primary_key_value,
data[1].ToString(),
data[2].ToString(),
data[3].ToString(),
data[4].ToString(),
data[5].ToString(),
data[6].ToString(),
data[7].ToString(),
image_bytes
};
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}
}
public void AddNoneQuery(EntityQuery none)
{
if (null == none)
{
return;
}
m_NoneQueries.Add(none);
m_Mode |= QueryMode.ContainsNone;
}
public QueryServer(QueryMode mode, int port)
{
this.mode = mode;
this.port = port;
Thread queryThread = new Thread(new ThreadStart(Run));
queryThread.Start();
runningServers.Add(queryThread);
Logger.WriteInternal("[---] Started a new QueryServer on port " + port);
}
/// <summary>
/// Executes query and returns result as cursor
/// </summary>
/// <param name="queryMode">Query mode</param>
public unsafe Cursor <TDocument> Execute(QueryMode queryMode = QueryMode.Normal)
{
Handle.SetHints(Hints);
int count;
var cursorHandle = Handle.Execute(queryMode, out count);
var serializer = Handle.Collection.Serializer;
var cursor = new Cursor <TDocument>(cursorHandle, Handle.Collection.Database.Library.Functions.Query.CursorResult, count, serializer);
return(cursor);
}
public QueryServer(QueryMode mode, int port)
{
_mode = mode;
_port = port;
var queryThread = new Thread(Run);
queryThread.Start();
RunningServers.Add(queryThread);
Logger.WriteInternal("[---] Started a new QueryServer on port " + port);
}
public int ExecuteDml <T>(QueryMode queryMode, Expression expression)
{
var nhLinqExpression = new NhLinqDmlExpression <T>(queryMode, expression, Session.Factory);
var query = Session.CreateQuery(nhLinqExpression);
SetParameters(query, nhLinqExpression.ParameterValuesByName);
return(query.ExecuteUpdate());
}
public T LoadEntity <T>(T entity, IEnumerable <string> includeStrings, QueryMode queryMode) where T : class
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
var keyPredicate = CreateKeyPredicateExpression(entity);
return(LoadEntity(keyPredicate, includeStrings, queryMode));
}
// ----- Constructor -----
public Lucene_SearchParams(DirectoryInfo indexed_directory, string search_dir, string query, QueryMode mode, List <String> exts, Boolean matchwholeword)
{
DirectoryInfo_Indexed = indexed_directory;
Search_Directory = search_dir;
Query_string = query;
Query_Mode = mode;
Exts = exts;
MatchWholeWord = matchwholeword;
Query_Lststring = GetlistString(query);
}
public IEnumerable <BsonDocument> getDocuments(string collectionName, QueryMode mode = QueryMode.AsEnumerableList)
{
if (mode == QueryMode.AsEnumerableCursor)
{
return(db.GetCollection <BsonDocument>(collectionName).Find(new BsonDocument()).ToEnumerable());
}
else
{
return(db.GetCollection <BsonDocument>(collectionName).Find(new BsonDocument()).ToList());
}
}
/// <summary>
/// 设置查询模式
/// </summary>
/// <param name="queryMode">查询模式</param>
public void SetQueryMode(QueryMode queryMode)
{
if (queryMode == QueryMode.FixQueryMode)
{
btnQueryMode.Text = "固定查询";
}
else
{
btnQueryMode.Text = "组合查询";
}
btnQueryMode_Click(null, null);
}
static void WarmUp(QueryMode mode, GrouperAlias gA, SorterAlias sA, string query, int threadCount)
{
Console.WriteLine($"Starting warm ups for {mode} / {gA} / {sA} / {query} / {threadCount}.");
for (int i = 0; i < warmUps; i++)
{
CleanGC();
var q = Query.Create(mode, query, graph, threadCount, PrinterType.Console, FormaterType.Simple, verticesPerThread, null, gA, sA, fixedArraySize, false);
q.Compute();
Console.WriteLine($"Finished warm up no. {i}.");
}
}
internal void GetQueryMode(out QueryMode mode)
{
mode = QueryMode.QUeryByPerson;
int res = 0;
Console.WriteLine("1.班级查询.");
Console.WriteLine("2.个人查询");
while (!int.TryParse(Console.ReadLine(), out res) &&
!(res == 1 || res == 2))
{
;
}
mode = res == 1 ? QueryMode.QueryByClass : QueryMode.QUeryByPerson;
}
public WindowStorage(QueryMode mode, Window parent, string primary_key_value = "")
{
InitializeComponent();
this.mode = mode;
this.parent = parent;
this.primary_key_value = primary_key_value;
ComboBox_product_name.ItemsSource = Shortcuts.get_full_column_from("products", "name", connection);
ComboBox_supplier.ItemsSource = Shortcuts.get_full_column_from("suppliers", "name", connection);
if (mode == QueryMode.add)
{
Button_reset.Visibility = Visibility.Collapsed;
Button_accept.Content = "Добавить";
}
else
{
Button_accept.Content = "Изменить";
try
{
connection.Open();
MySqlCommand comm = new MySqlCommand($"SELECT * FROM `storage` " +
$"WHERE `id` = '{primary_key_value}';", connection);
MySqlDataReader data = comm.ExecuteReader();
data.Read();
ComboBox_product_name.Text = data[1].ToString();
TextBox_product_amount.Text = float.Parse(data[2].ToString()).ToString();
TextBox_product_amount.Text = TextBox_product_amount.Text.Replace(",", ".");
ComboBox_supplier.Text = data[4].ToString();
TextBox_average_purchase_price.Text = float.Parse(data[5].ToString()).ToString();
TextBox_average_purchase_price.Text = TextBox_average_purchase_price.Text.Replace(",", ".");
old_values = new string[4] {
data[1].ToString(),
data[2].ToString(),
data[4].ToString(),
data[5].ToString()
};
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}
}
public WindowClients(QueryMode mode, Window parent, string primary_key_value = "")
{
InitializeComponent();
this.mode = mode;
this.parent = parent;
this.primary_key_value = primary_key_value;
ComboBox_gender.ItemsSource = Shortcuts.get_full_column_from("genders", "gender", connection);
if (mode == QueryMode.add)
{
Button_reset.Visibility = Visibility.Collapsed;
Button_accept.Content = "Добавить";
}
else
{
Button_accept.Content = "Изменить";
try
{
connection.Open();
MySqlCommand comm = new MySqlCommand($"SELECT * FROM `clients` " +
$"WHERE `mail` = '{primary_key_value}';", connection);
MySqlDataReader data = comm.ExecuteReader();
data.Read();
TextBox_mail.Text = primary_key_value;
TextBox_phone.Text = data[1].ToString();
TextBox_surname.Text = data[2].ToString();
TextBox_first_name.Text = data[3].ToString();
TextBox_second_name.Text = data[4].ToString();
ComboBox_gender.Text = data[5].ToString();
old_values = new string[6] {
data[0].ToString(),
data[1].ToString(),
data[2].ToString(),
data[3].ToString(),
data[4].ToString(),
data[5].ToString()
};
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}
}
IEnumerable <T> Select <T>(string TableName, SQLiteParameter[] Conditions, QueryMode Mode = QueryMode.AND) where T : DbEntry, new()
{
DataTable Table = Query(TableName, Conditions, Mode);
int RowCount = Table.Rows.Count;
FieldInfo[] Fields = DALFieldAttribute.GetDALFields <T>();
for (int i = 0; i < RowCount; i++)
{
T Obj = new T();
for (int j = 0; j < Fields.Length; j++)
{
string Name = Fields[j].GetCustomAttribute <DALFieldAttribute>().ColumnName;
object ColVal = Table.Rows[i][Name];
if (ColVal is DBNull)
{
ColVal = null;
}
Type FT = Fields[j].FieldType;
if (ColVal != null && ColVal.GetType() != FT)
{
Type Underlying;
if ((Underlying = Nullable.GetUnderlyingType(FT)) != null)
{
if (ColVal != null)
{
ColVal = Convert.ChangeType(ColVal, Underlying);
ColVal = Activator.CreateInstance(FT, new[] { ColVal });
}
}
else
{
ColVal = Convert.ChangeType(ColVal, FT);
}
}
Fields[j].SetValue(Obj, ColVal);
}
yield return(Obj);
}
yield break;
}
public WindowCars(QueryMode mode, Window parent, string primary_key_value = "")
{
InitializeComponent();
this.mode = mode;
this.parent = parent;
this.primary_key_value = primary_key_value;
List <string> mails = Shortcuts.get_full_column_from("clients", "mail", connection);
ComboBox_owner_mail.ItemsSource = mails;
if (mode == QueryMode.add)
{
Button_reset.Visibility = Visibility.Collapsed;
Button_accept.Content = "Добавить";
}
else
{
Button_accept.Content = "Изменить";
try
{
connection.Open();
MySqlCommand comm = new MySqlCommand($"SELECT * FROM `cars` " +
$"WHERE `vin` = '{primary_key_value}';", connection);
MySqlDataReader data = comm.ExecuteReader();
data.Read();
TextBox_vin.Text = primary_key_value;
TextBox_number.Text = data[1].ToString();
ComboBox_owner_mail.Text = data[2].ToString();
TextBox_color.Text = data[3].ToString();
TextBox_model.Text = data[4].ToString();
old_values = new string[5] {
data[0].ToString(),
data[1].ToString(),
data[2].ToString(),
data[3].ToString(),
data[4].ToString()
};
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}
}
public PracticeDatabaseReader(string filename, IndexManager indexManager,
IEnumerable<IWhereQueryConstraint> constraints, QueryMode queryMode = QueryMode.Auto)
: base(filename, indexManager, constraints, queryMode)
{
recordMetaData = new RecordMetaData();
recordMetaData.AddField("date", ColumnType.Int);
recordMetaData.AddField("id", ColumnType.String, 6);
recordMetaData.AddField("name", ColumnType.String, 40);
recordMetaData.AddField("center_name", ColumnType.String, 40);
recordMetaData.AddField("address", ColumnType.String, 40);
recordMetaData.AddField("city", ColumnType.String, 40);
recordMetaData.AddField("region", ColumnType.String, 40);
recordMetaData.AddField("postal_code", ColumnType.String, 10);
RecordWidth = recordMetaData.RecordWitdh;
}
public VisitorParameters(
ISessionFactoryImplementor sessionFactory,
IDictionary <ConstantExpression, NamedParameter> constantToParameterMap,
List <NamedParameterDescriptor> requiredHqlParameters,
QuerySourceNamer querySourceNamer,
System.Type targetEntityType,
QueryMode rootQueryMode)
{
SessionFactory = sessionFactory;
ConstantToParameterMap = constantToParameterMap;
RequiredHqlParameters = requiredHqlParameters;
QuerySourceNamer = querySourceNamer;
TargetEntityType = targetEntityType;
RootQueryMode = rootQueryMode;
}
public OrderDatabaseReader(string filename, IndexManager indexManager, QueryMode queryMode,
IEnumerable<IWhereQueryConstraint> constraints) : base(filename, indexManager, constraints, queryMode)
{
recordMetaData = new RecordMetaData
{
ColumnDescriptors = new Dictionary<string, ColumnData>
{
{"sha", new ColumnData {Offset = 0, Width = 4, Type = ColumnType.String}},
{"pct", new ColumnData {Offset = 4, Width = 4, Type = ColumnType.String}},
{"practice", new ColumnData {Offset = 8, Width = 6, Type = ColumnType.String}},
{"bnf_code", new ColumnData {Offset = 14, Width = 10, Type = ColumnType.String}},
{"bnf_name", new ColumnData {Offset = 24, Width = 40, Type = ColumnType.String}},
{"items", new ColumnData {Offset = 64, Width = sizeof (int), Type = ColumnType.Int}},
{
"nic", new ColumnData {Offset = 64 + sizeof (int), Width = sizeof (float), Type = ColumnType.Float}
},
{
"cost",
new ColumnData
{
Offset = 64 + sizeof (int) + sizeof (float),
Width = sizeof (float),
Type = ColumnType.Float
}
},
{
"period",
new ColumnData
{
Offset = 64 + sizeof (int) + sizeof (float) + sizeof (int),
Width = sizeof (int),
Type = ColumnType.Int
}
}
}
};
RecordWidth = recordMetaData.RecordWitdh;
}
void OnToolbar_ToggleQueryMode (System.Object obj, EventArgs ea)
{
if (queryMode == QueryMode.Query)
queryMode = QueryMode.NonQuery;
else if (queryMode == QueryMode.NonQuery)
queryMode = QueryMode.Query;
}
public void CreateGui ()
{
win = new Gtk.Window (ApplicationName);
win.DeleteEvent += new Gtk.DeleteEventHandler (OnWindow_Delete);
win.BorderWidth = 4;
win.SetDefaultSize (600, 500);
VBox vbox = new VBox (false, 4);
win.Add (vbox);
// Menu Bar
MenuBar mb = CreateMenuBar ();
vbox.PackStart (mb, false, false, 0);
// Tool Bar
toolbar = CreateToolbar ();
toolbar.ShowAll();
vbox.PackStart (toolbar, false, false, 0);
// Panels
tree = new DataTree (); // meta data tree view (left pane)
tree.View.ButtonReleaseEvent += new Gtk.ButtonReleaseEventHandler (OnDataTreeButtonRelease);
tree.View.RowExpanded += new Gtk.RowExpandedHandler (OnDataTreeRowExpanded);
// SQL Editor amd Results (right pane)
outputResults = OutputResults.DataGrid;
sourceFileNotebook = new Notebook();
sourceFileNotebook.Scrollable = true;
NewEditorTab();
sourceFileNotebook.SwitchPage += new Gtk.SwitchPageHandler(OnEditorTabSwitched);
HPaned hpaned = new HPaned ();
vbox.PackStart (hpaned, true, true, 0);
hpaned.Add1 (tree);
hpaned.Add2 (sourceFileNotebook);
statusBar = new Statusbar ();
statusBar.HasResizeGrip = false;
SetStatusBarText ("Ready!");
vbox.PackEnd (statusBar, false, false, 0);
queryMode = QueryMode.Query;
}
public Query(QueryMode Mode, string Table, Tuple<string, object> WhereCond)
{
this.Mode = Mode;
table = Table;
Where = WhereCond;
}
public Query(QueryMode Mode, string Table)
{
this.Mode = Mode;
table = Table;
}
internal CursorHandle Execute(QueryMode flags, out int count)
{
QueryLogBuffer logsptr = null;
//TODO: check it more elegant way?
if ((flags & QueryMode.Explain) != 0)
{
//static extern IntPtr _tcxstrnew();
logsptr = new QueryLogBuffer(Collection.Database.Library.LibraryHandle); //Create dynamic query execution log buffer
}
CursorHandle cursorHandle = null;
try
{
int resultCount = 0;
//static extern IntPtr _ejdbqryexecute([In] IntPtr jcoll, [In] IntPtr q, out int count, [In] int qflags, [In] IntPtr logxstr);
IntPtr bufferPointer = logsptr == null ? IntPtr.Zero : logsptr.DangerousGetHandle();
cursorHandle = new CursorHandle(() => _execute(Collection.CollectionHandle, this, out resultCount, flags, bufferPointer), pointer => _deleteCursor(pointer));
count = resultCount;
}
finally
{
if (logsptr != null)
{
try
{
if (cursorHandle != null && !cursorHandle.IsInvalid)
{
//static extern IntPtr _tcxstrptr([In] IntPtr strptr);
IntPtr sbptr = logsptr.AsString();
cursorHandle.Log = Native.StringFromNativeUtf8(sbptr); //UnixMarshal.PtrToString(sbptr, Encoding.UTF8);
}
}
finally
{
//static extern IntPtr _tcxstrdel([In] IntPtr strptr);
logsptr.Dispose();
}
}
}
Collection.Database.ThrowOnError();
return cursorHandle;
}
public void RawQuery(string query)
{
this.queryMode = QueryMode.Insert;
this.command.CommandText = query;
this.Query();
}
void AddPreviewPane(ClassDefinition cls, QueryMode mode)
{
if (mode == QueryMode.SQL)
{
if (!hasSql)
{
var pane = new PreviewPane(currentFsId, mode, cls, _fsvc, _caps);
var page = new TabPage();
page.Text = Strings.SQLQuery;
page.Tag = mode;
pane.Dock = DockStyle.Fill;
page.Controls.Add(pane);
tabPreviews.TabPages.Add(page);
tabPreviews.SelectedIndex = tabPreviews.TabPages.IndexOf(page);
hasSql = true;
}
}
else
{
var pane = new PreviewPane(currentFsId, mode, cls, _fsvc, _caps);
var page = new TabPage();
page.Text = Strings.StandardQuery + " - " + cls.QualifiedName; //NOXLATE
page.Tag = mode;
pane.Dock = DockStyle.Fill;
page.Controls.Add(pane);
tabPreviews.TabPages.Add(page);
tabPreviews.SelectedIndex = tabPreviews.TabPages.IndexOf(page);
}
btnClose.Enabled = (tabPreviews.TabPages.Count > 0);
}
public SqlQueryBuilder(QueryMode mode)
: this()
{
SqlMode = mode;
}
/// <summary>
/// 初始化异步任务
/// </summary>
private void initWorker(QueryMode queryMode)
{
worker = new BackgroundWorker();
worker.WorkerSupportsCancellation = true;
worker.WorkerReportsProgress = true;
TaskbarItemInfo.ProgressState = TaskbarItemProgressState.Normal;
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted);
worker.ProgressChanged += new ProgressChangedEventHandler(worker_ProgressChanged);
WorkerArgs args = new WorkerArgs() { Url = baseUrl ,SelectedClassIndex = selectedClass.SelectedIndex};
if (queryMode == QueryMode.SiglePersonSigleClass)
{
if (string.IsNullOrEmpty(stuidTextBox.Text) && string.IsNullOrEmpty(stuNameTextBox.Text))
{
MessageBox.Show("先输入学生id或者姓名");
return;
}
if(!string.IsNullOrEmpty(stuidTextBox.Text))
{
args.StudentId = stuidTextBox.Text;//学生id
}
if (!string.IsNullOrEmpty(stuNameTextBox.Text))
{
args.StudentName = stuNameTextBox.Text;//学生姓名
}
worker.DoWork += new DoWorkEventHandler(worker_DoWork_单人单科);
}
else if (queryMode == QueryMode.SiglePersonMultiClass)
{
if (string.IsNullOrEmpty(stuidTextBox.Text) && string.IsNullOrEmpty(stuNameTextBox.Text))
{
MessageBox.Show("先输入学生id或者姓名");
return;
}
if (!string.IsNullOrEmpty(stuidTextBox.Text))
{
args.StudentId = stuidTextBox.Text;//学生id
}
if (!string.IsNullOrEmpty(stuNameTextBox.Text))
{
args.StudentName = stuNameTextBox.Text;//学生姓名
}
worker.DoWork += new DoWorkEventHandler(worker_DoWork_单人多科);
}
else if (queryMode == QueryMode.MultiPersonSingleClass)
{
if (!string.IsNullOrEmpty(stuNo_start_TextBox.Text) && !string.IsNullOrEmpty(stuNo_end_TextBox.Text))
{
args.StudentStartNo = stuNo_start_TextBox.Text;
args.StudentEndNo = stuNo_end_TextBox.Text;
args.isStudentNoRangeValid = true;
}
else if (!string.IsNullOrEmpty(stuid_start_TextBox.Text) && !string.IsNullOrEmpty(stuid_end_TextBox.Text))
{
args.StudentStartId = stuid_start_TextBox.Text;
args.StudentEndId = stuid_end_TextBox.Text;
args.isStudentNoRangeValid = false;
}
else
{
MessageBox.Show("先输入学号范围或者学生id范围");
return;
}
worker.DoWork += new DoWorkEventHandler(worker_DoWork_多人单科);
}
else if (queryMode == QueryMode.加权平均分)
{
if (!string.IsNullOrEmpty(stuNo_start_TextBox.Text) && !string.IsNullOrEmpty(stuNo_end_TextBox.Text))
{
args.StudentStartNo = stuNo_start_TextBox.Text;
args.StudentEndNo = stuNo_end_TextBox.Text;
args.isStudentNoRangeValid = true;
}
else if (!string.IsNullOrEmpty(stuid_start_TextBox.Text) && !string.IsNullOrEmpty(stuid_end_TextBox.Text))
{
args.StudentStartId = stuid_start_TextBox.Text;
args.StudentEndId = stuid_end_TextBox.Text;
args.isStudentNoRangeValid = false;
}
else
{
MessageBox.Show("先输入学号范围或者学生id范围");
return;
}
worker.DoWork += new DoWorkEventHandler(worker_DoWork_加权平均);
}
args.QueryMode = queryMode;
worker.RunWorkerAsync(args);
QueryBtn.IsEnabled = false;
QueryBtn.Content = "正在查询...";
}
