void OcrHelper_Complete(OcrResult result)
{
try
{
if (InvokeRequired)
{
Invoke((MethodInvoker) delegate { OcrHelper_Complete(result); });
return;
}
}
catch
{
return;
}
originalRichTextBox.Parent.BackColor = System.Drawing.SystemColors.ControlDark;
originalRichTextBox.Text = result.Text;
if (result.Succes && !string.IsNullOrWhiteSpace(result.Text))
{
if (Program.Settings.Clipboard.SaveOriginalTextToClipboard)
{
Clipboard.SetText(result.Text);
}
if (Program.Settings.Translate.AutoTranslate)
{
TranslateHelper.Translate(result.Text);
}
}
}
/// <summary>
/// 批量插入数据
/// </summary>
/// <param name="tableName">目标数据库表名</param>
/// <param name="sourceTable">源数据表</param>
/// <param name="excludeColumnName">需排除字段</param>
/// <returns>返回受影响的行数</returns>
public int Insert(string tableName, DataTable sourceTable, string[] excludeColumnName)
{
int result;
string[] columns = TranslateHelper.GetDataTableColumnName(sourceTable, excludeColumnName, "Insert");
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
SqlTransaction transaction = conn.BeginTransaction();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandTimeout = Config_SqlServerDataFactory.CommandTimeout;
cmd.Transaction = transaction;
try
{
foreach (DataRow dr in sourceTable.Rows)
{
List <SqlParameter> parameters = new List <SqlParameter>();
string insertStr = DataTableTranslateHelper.DataRowToInsert(tableName, dr, columns, parameters);
ExecuteSQLForTransaction(cmd, insertStr, parameters.ToArray());
}
transaction.Commit();
result = sourceTable.Rows.Count;
}
catch (Exception ex)
{
transaction.Rollback();
result = -1;
throw new Exception(ex.Source + ":" + ex.Message);
}
}
return(result);
}
/// <summary>
/// 生成Update语句
/// </summary>
/// <param name="updateObject"></param>
/// <param name="command"></param>
public static void TranslateIntoUpdate <T>(Update <T> update, SqlCommand command)
{
StringBuilder sqlUpdate = new StringBuilder();
sqlUpdate.Append(baseUpdate);
sqlUpdate.Append(update.TableName + " SET ");
//删除字段
foreach (var item in update.ExcludeField)
{
if (update.Values.ContainsKey(item.Name))
{
update.Values.Remove(item.Name);
}
}
//条件列也可能跟新
//foreach (var item in update.Criterions)
//{
// if (update.Vaules.ContainsKey(item.FieldName))
// {
// update.Vaules.Remove(item.FieldName);
// }
//}
foreach (var item in update.Values)
{
sqlUpdate.Append(item.Key + "=@U_" + item.Key + ",");
command.Parameters.Add(ParameterDataNullHelper.ChangeNull("@U_" + item.Key, item.Value));
}
sqlUpdate.Remove(sqlUpdate.Length - 1, 1);
TranslateHelper.GetCriterionString(sqlUpdate, update.Criterions, command, update.SqlOperator);
command.CommandText = sqlUpdate.ToString();
}
//开始翻译
void StartTranslate()
{
// 获取参数
q = InputTxt.Text;
appId = APPID.Text;
secretKey = SecrateTxt.Text;
url = APIAddress.Text;
times = int.Parse(TranslateTimes.Text);
gaptime = int.Parse(gapTime.Text);
//设置进度条最大范围
progress.Maximum = times;
//新建线程以实现接口访问
Thread th = new Thread(new ThreadStart(() =>
{
for (int i = 1; i <= times; i++)
{
progress.Invoke(new Action(() => {
progress.Value = i;
}));
q = TranslateHelper.BDrequest(q, "zh", "en", appId, secretKey, url);
Thread.Sleep(gaptime);
q = TranslateHelper.BDrequest(q, "en", "zh", appId, secretKey, url);
Thread.Sleep(gaptime);
}
//进度完毕后重置
progress.Invoke(new Action(() => {
progress.Value = 0;
}));
OutPutTxt.Invoke(new Action(() => {
OutPutTxt.Text = q;
}));
}));
th.Start();
}
private void translateToolStripButton_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(originalRichTextBox.Text))
{
TranslateHelper.Translate(originalRichTextBox.Text);
}
}
public IEnumerable <ChildEntityPermissionListItem> List(int contentId, int?groupId, int?userId, ListCommand cmd, out int totalRecords)
{
using (var scope = new QPConnectionScope())
{
var titleField = FieldRepository.GetTitleField(contentId);
var titleFieldName = titleField == null ? FieldName.ContentItemId : titleField.Name;
cmd.SortExpression = TranslateHelper.TranslateSortExpression(cmd.SortExpression);
IEnumerable <DataRow> rows;
totalRecords = 0;
if (userId.HasValue)
{
rows = Common.GetChildArticlePermissionsForUser(scope.DbConnection, contentId, userId.Value, titleFieldName, cmd.SortExpression, cmd.StartRecord, cmd.PageSize, out totalRecords);
}
else if (groupId.HasValue)
{
rows = Common.GetChildArticlePermissionsForGroup(scope.DbConnection, contentId, groupId.Value, titleFieldName, cmd.SortExpression, cmd.StartRecord, cmd.PageSize, out totalRecords);
}
else
{
throw new ArgumentNullException(nameof(groupId));
}
return(MapperFacade.ChildEntityPermissionListItemRowMapper.GetBizList(rows.ToList()));
}
}
private void originalRichTextBox_TextChanged(object sender, EventArgs e)
{
if (Program.Settings.Translate.AutoTranslate && Program.ActiveTranslator != null)
{
TranslateHelper.Translate(originalRichTextBox.Text);
//Program.ActiveTranslator.Translate(originalRichTextBox.Text, Program.ActiveLanguageFrom, Program.ActiveLanguageTo);
}
}
public string TranslateSortExpression(string sortExpression)
{
var replaces = new Dictionary <string, string> {
{ "TypeName", "TypeCode" }
};
return(TranslateHelper.TranslateSortExpression(sortExpression, replaces));
}
public IEnumerable <EntityPermissionListItem> List(ListCommand cmd, int parentId, out int totalRecords)
{
using (var scope = new QPConnectionScope())
{
cmd.SortExpression = TranslateHelper.TranslateSortExpression(cmd.SortExpression);
var rows = Common.GetContentPermissionPage(scope.DbConnection, parentId, cmd.SortExpression, cmd.FilterExpression, cmd.StartRecord, cmd.PageSize, out totalRecords);
return(MapperFacade.PermissionListItemRowMapper.GetBizList(rows.ToList()));
}
}
internal static string TranslateSortExpression(string sortExpression)
{
var replaces = new Dictionary <string, string>
{
{ "ByUser", "ByUser.LogOn" }
};
return(TranslateHelper.TranslateSortExpression(sortExpression, replaces));
}
public override string ToString()
{
if (Way == 0)
{
return(TranslateHelper.Translate("ZeroBrightness"));
}
return(TranslateHelper.Translate("TurnOffMonitor"));
}
/// <summary>
/// Траслирует SortExpression из Presentation в BLL
/// </summary>
/// <param name="sortExpression">SortExpression</param>
/// <returns>SortExpression</returns>
public new static string TranslateSortExpression(string sortExpression)
{
var result = EntityObject.TranslateSortExpression(sortExpression);
var replaces = new Dictionary <string, string>
{
{ "Name", "Id" }
};
return(TranslateHelper.TranslateSortExpression(result, replaces));
}
/// <summary>
/// 生成Delete语句
/// </summary>
/// <param name="deleteObject"></param>
/// <param name="command"></param>
public static void TranslateIntoDelete(Delete delete, SqlCommand command)
{
StringBuilder deleteString = new StringBuilder();
deleteString.Append(baseDelete);
deleteString.Append(delete.TableName);
TranslateHelper.GetCriterionString(deleteString, delete.Criterions, command, delete.SqlOperator);
command.CommandText = deleteString.ToString();
}
/// <summary>
/// 翻译任务
/// </summary>
/// <returns></returns>
public static bool Translation(string text)
{
//获取数据
//翻译
//TranslateText(text);
TranslateHelper.TranslateTextSample(text, ProjectId);
//保存数据
return(true);
}
public override string ToString()
{
if (Time == 0)
{
return(TranslateHelper.Translate("Never"));
}
if (Time <= 3600000)
{
return(Time / 60000 + " " + TranslateHelper.Translate("Minute"));
}
return(Time / 3600000 + " " + TranslateHelper.Translate("Hour"));
}
/// <summary>
/// 获取英文文本
/// </summary>
/// <param name="text"></param>
/// <returns></returns>
public static string GetEnglishText(string text)
{
string[] result = null;
object obj = TranslateHelper.TranslatorString(new[] { text });
if (obj != null)
{
result = (string[])obj;
}
return((result != null && result.Length > 0) ? result[3] : "");
}
public string Login(LoginViewModel loginViewModel)
{
Throw.IfNullOrEmptyString(loginViewModel.UserName, nameof(loginViewModel.UserName));
Throw.IfNullOrEmptyString(loginViewModel.Password, nameof(loginViewModel.Password));
if (!_accountsProvider.UserExists(loginViewModel.UserName))
{
return(TranslateHelper.TranslateMessage(DictionaryKeys.Messages.UserNotExists));
}
return(_accountsProvider.Login(loginViewModel.UserName, loginViewModel.Password, loginViewModel.StillLoggedIn)
? string.Empty
: TranslateHelper.TranslateMessage(DictionaryKeys.Messages.IncorrectPassword));
}
/// <summary>
/// Checking if user have permission for different services (example: Camera or Location)
/// </summary>
/// <param name="permission">Type of permission to check</param>
/// <param name="showSettings">Boolean if prompting dialog to go into settings</param>
/// <returns>Returns true or false depend on if permission is granted</returns>
public async Task <bool> CheckPermissionAsync(Permission permission, bool showSettings = true)
{
try
{
// Check if permission is already done
var status = await CrossPermissions.Current.CheckPermissionStatusAsync(permission);
// If permission is not granted we prompt a dialog to ask for permission
if (status != PermissionStatus.Granted)
{
var results = await CrossPermissions.Current.RequestPermissionsAsync(permission);
status = results[permission];
}
// If permission is not granted here we could prompt a "Open settings?" dialog
if (status != PermissionStatus.Granted)
{
if (showSettings)
{
var res = await Application.Current.MainPage.DisplayAlert(
title : TranslateHelper.Translate("Permission_Title") + " " + permission.ToString(),
message : TranslateHelper.Translate("Permission_Message") + " " + permission.ToString() + ". " + TranslateHelper.Translate("Permission_Settings"),
accept : TranslateHelper.Translate("Gen_Yes"),
cancel : TranslateHelper.Translate("Gen_No"));
if (res)
{
try
{
CrossPermissions.Current.OpenAppSettings();
}
catch (Exception ex)
{
ex.Print();
}
}
}
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Траслирует SortExpression
/// </summary>
private static string TranslateSortExpression(string sortExpression)
{
var replaces = new Dictionary <string, string>
{
{ "Text", "data.[rank]" },
{ "Id", "data.content_item_id" },
{ "Created", "ci.created" },
{ "Modified", "ci.modified" },
{ "LastModifiedByUser", "usr.[LOGIN]" },
{ "ParentName", "c.CONTENT_NAME" },
{ "StatusName", "st.STATUS_TYPE_NAME" }
};
return(TranslateHelper.TranslateSortExpression(sortExpression, replaces, "data.[rank] desc"));
}
public static string TranslateSortExpression(string sortExpression)
{
var replaces = new Dictionary <string, string>
{
{ "LastModifiedByUserId", FieldName.LastModifiedBy },
{ "LastModifiedByUser", "LAST_MODIFIED_BY_LOGIN" },
{ "FirstName", "FIRST_NAME" },
{ "LastName", "LAST_NAME" },
{ "LanguageId", "LANGUAGE_ID" },
{ "Language", "LANGUAGE_NAME" },
{ "LastLogOn", "LAST_LOGIN" }
};
return(TranslateHelper.TranslateSortExpression(sortExpression, replaces));
}
public string TranslateSortExpression(string sortExpression, DatabaseType dbType)
{
if (string.IsNullOrEmpty(sortExpression))
{
sortExpression = $"{SqlQuerySyntaxHelper.EscapeEntityName(dbType, "ORDER")} ASC";
}
var replaces = new Dictionary <string, string>
{
{ "LastModifiedByUser", "LOGIN" },
{ "ActionTypeName", "ACTION_TYPE_NAME" },
{ "EntityTypeName", "ENTITY_TYPE_NAME" }
};
return(TranslateHelper.TranslateSortExpression(sortExpression, replaces));
}
/// <summary>
/// 生成查询语句
/// </summary>
/// <param name="query"></param>
/// <param name="command"></param>
public static void TranslateIntoSelect(Query query, SqlCommand command)
{
StringBuilder selectString = new StringBuilder();
selectString.Append(baseSelect);
selectString.Append(query.TableName);
TranslateHelper.GetCriterionString(selectString, query.Criterions, command, query.SqlOperator);
if (query.OrderByClauses.Count() > 0)
{
selectString.Append(TranslateHelper.GetStringFromOrderByClause(query.OrderByClauses));
}
command.CommandText = selectString.ToString();
}
private void OnBrightnessChanged(object sender, EventArgs e)
{
if (_taskbarIcon != null)
{
var backlightService = ServiceManager.GetService <IBacklightService>();
var brightness = backlightService.Brightness;
var displayText = $"{TranslateHelper.Translate("CurrentBrightness")}: {brightness}";
Dispatcher.Invoke(DispatcherPriority.Normal, new Action(() =>
{
if (((Border)_taskbarIcon.TrayToolTip)?.Child is TextBlock textBlock)
{
textBlock.Text = displayText;
}
}));
}
}
public string TranslateSortExpression(string sortExpression)
{
if (string.IsNullOrEmpty(sortExpression))
{
sortExpression = "[ORDER] ASC";
}
var replaces = new Dictionary <string, string>
{
{ "LastModifiedByUser", "LOGIN" },
{ "ActionTypeName", "ACTION_TYPE_NAME" },
{ "EntityTypeName", "ENTITY_TYPE_NAME" }
};
return(TranslateHelper.TranslateSortExpression(sortExpression, replaces));
}
public IEnumerator CardAdded(GameObject card, int currentPlayerIndex, Text StartPos, Vector3 endPos)
{
card.transform.GetChild(1).gameObject.SetActive(true);
card.transform.position = StartPos.transform.position;
float elapsedTime = 0;
float waitTime = 1.5f;
endPos.Set(gameObject.GetComponent <HandArranger>().GetX(currentPlayerIndex), gameObject.GetComponent <HandArranger>().GetY(currentPlayerIndex), 10f);
while (elapsedTime < waitTime)
{
float fraction = TranslateHelper.GetFraction(elapsedTime, waitTime, "CubicOutBack");
card.transform.position = card.transform.position * (1 - fraction) + (endPos * fraction);
elapsedTime += Time.deltaTime;
yield return(null);
}
card.transform.GetChild(1).gameObject.SetActive(false);
yield break;
}
//Handle auto start.
private void HandleAutoStart()
{
var appName = TranslateHelper.Translate("AppName");
var auto = SettingManager.AutoStart ? 1 : 0;
var helper = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "AutoStart.exe");
if (File.Exists(helper))
{
var process = Process.Start(new ProcessStartInfo(helper)
{
Arguments = $"/name=\"{appName}\" /file=\"{_currentExeFilePath}\" /auto=\"{auto}\"",
CreateNoWindow = false,
Verb = "runas",
UseShellExecute = true,
WindowStyle = ProcessWindowStyle.Hidden,
});
process?.WaitForExit();
}
}
/// <summary>
/// 生成创建视图SQL语句
/// </summary>
/// <param name="viewName"></param>
/// <param name="command"></param>
private void GetBulidViewString(string viewName, SqlCommand command)
{
string baseString = "CREATE VIEW ";
StringBuilder result = new StringBuilder();
result.Append(baseString);
result.Append(viewName);
result.Append(" AS SELECT ");
foreach (var item in _needFields)
{
result.Append(TranslateHelper.GetFieldString(item));
}
result.Remove(result.Length - 1, 1);
result.Append(" FROM ");
result.Append(TranslateHelper.GetJoinConditionString(_needFields, _joinCriterion));
command.Parameters.Clear();
command.CommandText = result.ToString();
}
/// <summary>
/// Траслирует SortExpression
/// </summary>
private static string TranslateSortExpression(string sortExpression)
{
var dbType = QPContext.DatabaseType;
if (dbType == DatabaseType.Postgres)
{
if (String.IsNullOrEmpty(sortExpression))
{
return($@"""Rank"" desc");
}
var parts = sortExpression.Split(' ');
parts[0] = $@"""{parts[0]}""";
return(string.Join(" ", parts));
}
var replaces = new Dictionary <string, string>()
{
{ "Text", "Rank" }
};
return(TranslateHelper.TranslateSortExpression(sortExpression, replaces, $"Rank desc"));
}
public virtual ActionResult MainMenu()
{
var menuViewModel = new MenuViewModel();
menuViewModel.UserName = this.CurrentUsername ?? string.Empty;
//Admin menu
var adminSubMenu = new List <MenuItem>();
adminSubMenu.Add(new MenuItem()
{
Action = "Index", Controller = "AdminInstitution", Text = TranslateHelper.Translate("Institutions")
});
adminSubMenu.Add(new MenuItem()
{
Action = "Index", Controller = "AdminUser", Text = TranslateHelper.Translate("Users")
});
menuViewModel.MenuItems.Add(new MenuItem()
{
Text = TranslateHelper.Translate("Admin"), SubItems = adminSubMenu
});
return(View(MVC.Menu.Views.MainMenu, menuViewModel));
}
public static void TranslateIntoComplexQuery(ComplexQuery complexQuery, SqlCommand command)
{
string baseString = "SELECT ";
StringBuilder result = new StringBuilder();
result.Append(baseString);
if (complexQuery.IsDictinct == true)
{
result.Append("DISTINCT ");
}
if (complexQuery.TopNumber != 0)
{
result.Append(TranslateHelper.GetTopNumber(complexQuery.TopNumber));
}
foreach (var item in complexQuery.NeedFields)
{
result.Append(TranslateHelper.GetFieldString(item));
}
result.Remove(result.Length - 1, 1);
result.Append(TranslateHelper.GetJoinConditionString(complexQuery.NeedFields, complexQuery.JoinCriterion));
if (complexQuery.Criterions.Count() > 0)
{
TranslateHelper.GetCriterionString(result, complexQuery.Criterions, command, complexQuery.SqlOperator);
}
if (complexQuery.OrderByClauses.Count > 0)
{
result.Append(TranslateHelper.GetStringFromOrderByClause(complexQuery.OrderByClauses));
}
command.CommandText = result.ToString();
}
