//更新数据功能
public String update()
{
String ans = "OK";
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
DBTrans = conn.BeginTransaction();
da.UpdateCommand.Transaction = DBTrans;
try
{
da.Update(dt.GetChanges());
dt.AcceptChanges();
DBTrans.Commit();
ans = "OK";
}
catch (Exception e)
{
DBTrans.Rollback();
Console.WriteLine(e.ToString());
AlertUtil.Show("DataUpdateError", e.ToString());
ans = "FAILED";
}
finally
{
conn.Close();
}
return(ans);
}
//带参数的初始化
public void controlInit(SpreadsheetControl spreadsheetMain, Dictionary <String, SimpleButton> buttons, Dictionary <String, Label> labels, String path, Dictionary <String, PopupMenu> menus, BarManager barmanager, XtraForm form, AlertControl alert, XSheetUser user)
{
this.buttons = buttons;
this.labels = labels;
this.spreadsheetMain = spreadsheetMain;
this.menus = menus;
this.rightClickBarManager = barmanager;
AlertUtil.setAlert(alert, form);
this.user = user;
this.form = form;
this.alert = alert;
//CELLCHANGE
executer = new CommandExecuter(user);
executer.Attach(this);
executeState = "OK";
/*加载文档，后续根据不同设置配置，待修改TODO*/
try
{
DateTime date = new DateTime();
StreamWriter sw = new StreamWriter(@"ConsoleOutput.txt", true);
date = DateTime.Now;
sw.WriteLine("beforeLoadDoc:" + date.ToString());
if (path.Length > 0)
{
spreadsheetMain.Document.LoadDocument(path);
}
sw.Flush();
sw.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
spreadsheetMain.Dispose();
}
}
//如果执行存储过程（执行存储过程不修改本地数据对象，可用来执行任意SQL语句）
public String Execute(List <String> sqls)
{
String ans = "OK";
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
DBTrans = conn.BeginTransaction();
DbCommand cmd = DBUtil.getCommand(sqls[0], ServerName, conn);
cmd.Transaction = DBTrans;
try
{
foreach (String sql in sqls)
{
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
DBTrans.Commit();
}
catch (Exception e)
{
AlertUtil.Show("error", e.ToString());
ans = "FAILED";
DBTrans.Rollback();
}
finally
{
conn.Close();
}
return(ans);
}
//查询功能，通过查询SQL可判定该对象具有的功能权限
public String search(String Sql)
{
avaliableList.Clear();//清空功能列表
try
{
conn = DBUtil.getConnection(ServerName);
conn.Open();
DBTrans = conn.BeginTransaction();
conn.Close();
da = DBUtil.getDbDataAdapter(ServerName, Sql, "", conn);//根据查询语句，初始化适配器
DataSet ds = new DataSet();
da.Fill(ds);
dt = ds.Tables[0];
avaliableList.Add("R");//根据适配器设定可用功能列表
if (da.UpdateCommand != null)
{
avaliableList.Add("U");
}
if (da.InsertCommand != null)
{
avaliableList.Add("C");
}
if (da.DeleteCommand != null)
{
avaliableList.Add("D");
}
}
catch (Exception e)
{
AlertUtil.Show("err", e.ToString());
}
return("OK");
}
public void LoginFailed(LoginGameResult result)
{
string tips = "";
switch (result)
{
case LoginGameResult.NoneAccount:
tips = StringUtil.Get("Login failed, account not found!");
break;
case LoginGameResult.WrongPassword:
tips = StringUtil.Get("Login failed, wrong password!");
break;
case LoginGameResult.Unkonw:
tips = StringUtil.Get("Login failed, server error!");
break;
default:
LogUtil.W("Unknow LoginGameResult type {0}", result);
break;
}
AlertUtil.ShowSimpleTipsPanel(tips);
}
//初始化接口
public virtual void init(ActionCfg cfg, XApp app)
{
this.cfg = cfg;
this.ActionName = cfg.ActionName;
try
{
this.actionSeq = int.Parse(cfg.ActSeq);
}
catch
{
AlertUtil.Show("error", String.Format("Action {0} Seq设置异常，设置值为{1}", ActionName, cfg.ActSeq));
}
try
{
if (cfg.SRange.Length > 0)
{
sRange = app.getRangeByName(cfg.SRange);
}
if (cfg.DRange.Length > 0)
{
dRange = app.getRangeByName(cfg.DRange);
}
}
catch (Exception)
{
MessageBox.Show("Action：" + ActionName + "的sRange、dRange配置错误！");
return;
}
}
//读取Data配置
public static List <DataCfg> readData(Table dataCfgTable)
{
List <DataCfg> datas = new List <DataCfg>();
for (int i = 1; i < dataCfgTable.Range.RowCount; i++)
{
if (dataCfgTable.Range[i, 0].DisplayText.Length == 0)
{
break;
}
DataCfg data = new DataCfg();
//DataName ObjectName ObjectType DBName ServerName BaseSQLStatement RangeName CRUDP SVK InitStatement
data.TableTitle = dataCfgTable.Range[i, 0].DisplayText;
data.TableDesc = dataCfgTable.Range[i, 1].DisplayText;
data.CRUDP = dataCfgTable.Range[i, 2].DisplayText;
data.SVK = dataCfgTable.Range[i, 3].DisplayText;
data.RangeName = dataCfgTable.Range[i, 4].DisplayText;
data.DBName = dataCfgTable.Range[i, 5].DisplayText;
data.ServerName = dataCfgTable.Range[i, 6].DisplayText;
data.DefalutStatement = dataCfgTable.Range[i, 7].GetReferenceA1();
if ((data.ServerName == null || data.ServerName.Length < 2) && data.RangeName.Split('_')[0] == "TB")
{
Console.WriteLine("区域:" + data.TableTitle + "服务器类型配置错误，当前配置为：" + data.ServerName);
return(null);
}
if (data.RangeName.Length == 0)
{
AlertUtil.Show("error", String.Format("Data:{0} 未配置Range,此Data将不被系统使用！", data.TableTitle));
continue;
}
datas.Add(data);
}
return(datas);
}
void GetServerList()
{
var worldMgr = WorldManager.Instance;
var uiMgr = worldMgr.UIMgr;
uiMgr.ShowPanel(PanelType.AsyncPanel);
HttpUtil.GetAsync("http://127.0.0.1:8001/serverInfo", delegate(WebRequestResultType resultType, string serverInfoStr)
{
uiMgr.HidePanel(PanelType.AsyncPanel);
if (resultType == WebRequestResultType.Success)
{
var serverInfoResult = JsonUtility.FromJson <GetServerInfoResult>(serverInfoStr);
var serverData = worldMgr.GameServer.GetData <Data.ServerData>();
var result = serverInfoResult.result;
if (result == 0)
{
serverData.serverInfoList.Clear();
serverData.serverInfoList.AddRange(serverInfoResult.serverInfoList);
}
}
else
{
AlertUtil.ShowYesNoPanel(StringUtil.Get("Get server list failed, click ok retry!"), delegate()
{
GetServerList();
});
}
});
}
protected override string doOwnAction()
{
List <String> statements = getRealStatement();
if (statements[0] == "")
{
try
{
dRange.doInsert();
return("OK");
}
catch (Exception)
{
return("FAILED");
}
}
else
{
try
{
dRange.ExecuteSql(statements);
}
catch (Exception e)
{
AlertUtil.Show("error", e.ToString());
}
}
dRange.Refresh();
return("OK");
}
public override void fill(DataTable dt)
{
selectedRows = new Dictionary <int, int>();
drawRows = new Dictionary <int, int>();
Range range = getRange();
if (dt == null)
{
AlertUtil.Show("error", "查询结果为空，请确认查询语句");
return;
}
Cell data1stcell = range[0, 0];
string[,] arrtmp = new string[range.RowCount, dt.Columns.Count];
range.Worksheet.Import(arrtmp, data1stcell.RowIndex, data1stcell.ColumnIndex);
range.FillColor = Color.White;
range.Worksheet.Import(dt, false, data1stcell.RowIndex, data1stcell.ColumnIndex);
this.data.setData(dt);
range.Borders.SetAllBorders(Color.Black, BorderLineStyle.None);
/*for (int i = 0; i < range.RowCount; i++)
* {
* setRowBorderNone(i);
* }*/
this.isFilled = true;
doResize(dt.Rows.Count + 1);
getRange().FillColor = Color.White;
}
//初始化RANGE
private void initRange()
{
foreach (DataCfg cfg in cfgdata.datas) //遍历RANGE配置
{
XRange range = XRangeFactory.getXRange(cfg); //工厂模式，根据配置生成实际FORM/RANGE/TABLE 对象
try
{
range.init(cfg, book); //range 初始化
ranges.Add(range.Name, range); //将 range 放入集合，后续可根据range名获取range
if (range.getRange() == null) //如果对应的工作表中range区域 不存在，则报错，并将系统状态设置为Designer状态
{
AlertUtil.Show("error", "Range对应命名区域不存在或配置异常，RangeId：" + cfg.RangeName + " 即将进入Designer模式");
statu = SysStatu.Designer;
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
MessageBox.Show("Range对应命名区域不存在或配置异异常，RangeId：" + cfg.RangeName + "\n" + e.ToString());
this.statu = SysStatu.RangeError;
return;
}
}
if (ranges.Count == 0)
{
this.statu = SysStatu.Designer;
AlertUtil.Show("info", "未查询到有效DATA，进入设计模式！");
}
}
private void OnDalshboardItemClick(object sender, EventArgs e)
{
DXMenuItem item = (DXMenuItem)sender;
int i = int.Parse(item.Tag.ToString());
AlertUtil.StartWait();
XDashBoardForm dashboardFrom = new XDashBoardForm(cfgData.dashboards[i - 1]);
dashboardFrom.Show();
AlertUtil.StopWait();
}
//状态变化
private void ChangeToStatu(SysStatu newstatu)
{
//labels["lbl_User"].Text = app.statu.ToString();
if (currentXRange != null && newstatu != app.statu)
{
currentXRange.ResetSelected();
}
app.statu = newstatu;
AlertUtil.Show("状态变更", "状态变更为" + newstatu);
ChangeButtonsStatu();
}
public void OnResult(SHARE_MEDIA media)
{
if (media == SHARE_MEDIA.WeixinFavorite)
{
AlertUtil.ToastShort(context, "Êղسɹ¦");
}
else
{
AlertUtil.ToastShort(context, "·ÖÏí³É¹¦");
}
}
public static UserObject GetNextAlert(string processorId, string alertQueueFileName)
{
Mutex mutex = new Mutex(false, _mobiusAlertQueue);
mutex.WaitOne(); // get exclusive access
int alertId;
try
{
StreamReader sr = new StreamReader(alertQueueFileName);
string content = sr.ReadToEnd();
sr.Close();
if (Lex.IsNullOrEmpty(content)) // all done if nothing left in queue
{
//AlertCount = 0;
return(null);
}
int i1 = content.IndexOf(",");
if (i1 >= 0)
{
alertId = Int32.Parse(content.Substring(0, i1));
content = content.Substring(i1 + 1);
}
else
{
alertId = Int32.Parse(content);
content = "";
}
StreamWriter sw = new StreamWriter(alertQueueFileName);
sw.Write(content);
sw.Close();
//_remainingingAlertCount--;
}
catch (Exception ex)
{
AlertUtil.LogAlertMessage("Error accessing alert queue: " + ex.Message + processorId);
return(null);
}
finally { mutex.ReleaseMutex(); }
UserObject uo = UserObjectDao.Read(alertId); // read the alert
if (uo == null)
{
AlertUtil.LogAlertMessage("Error reading alert " + alertId + processorId);
}
return(uo);
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
try
{
Int32.TryParse(textBox1.Text, out value);
}
catch (Exception ex)
{
textBox1.Text = "";
value = 0;
Console.WriteLine(ex.ToString());
AlertUtil.AlertIntegerParseErr();
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.layout1);
toolbar = FindViewById <Toolbar>(Resource.Id.toolbar);
btn_tabStatus = toolbar.FindViewById <Button>(Resource.Id.btn_tabStatus);
//btn_test =toolbar.FindViewById<Button>(Resource.Id.btn_test);
btn_tabStatus.Click += (s, e) =>
{
AlertUtil.ToastShort(this, "123");
};
}
public override void doResize(int rowcount)
{
if (rowcount == 1)
{
rowcount = 2;
}
if (!isFilled)
{
AlertUtil.Show("错误！", "Table" + Name + "需先查询才能Update");
return;
}
Range range = this.table.Range;
Range newrange = RangeUtil.rangeResize(range, rowcount);
changeDefinedRange(newrange);
}
public String executeCmd(XCommand cmd)
{
this.executeState = "Executing...";
String ans = "OK";
AlertUtil.StartWait();
Notify();
if (cmd != null)
{
CommandTask task = new CommandTask(cmd, user);
ans = task.doTask();
}
this.executeState = "OK";
Notify();
AlertUtil.StopWait();
return(ans);
}
//读取配置文件中的配置表格
private Table getCfgTable(String tableName)
{
Table table = null;
try
{
table = cfgtables[tableName];
if (table.Range == null)
{
AlertUtil.Show("error", "名称为" + tableName + "的EXCEL Table区域配置异常，请确认配置");
return(null);
}
}
catch (Exception)
{
AlertUtil.Show("warning", "未找到名称为" + tableName + "的EXCEL Table区域，请确认配置");
}
return(table);
}
public String execute(XSheetUser user)
{
StartNotify();
String ans = "OK";
foreach (char item in cfg.CRUDP)
{
/*if (!user.getPrivilege(rsheet).Contains(item))
* {
* ans = "No privilege!";
* return ans;
* }*/
}
if (actions.Count <= 0)
{
AlertUtil.Show("error", String.Format("Command :{0} 中未找到对应的Action，Command无法执行", this.CommandName));
}
else
{
actions = actions.OrderBy(o => o.Key).ToDictionary(o => o.Key, p => p.Value);
int i = 0;
while (i <= actions.Keys.Max())
{
if (actions.Keys.Contains(i))
{
actions[i].dRange.getRange().Worksheet.Calculate();
ans = actions[i].doAction();
i = actions[i].getNextIndex(ans, i);
}
else
{
i++;
}
}
}
/*foreach (KeyValuePair<int, XAction> kv in actions)
* {
* kv.Value.dRange.getRange().Worksheet.Calculate();
* }*/
FinishNotify();
return(ans);
}
//文档加载事件，用于初始化
public void spreadsheetMain_DocumentLoaded(object sender, EventArgs e)
{
AlertUtil.StartWait();
init();
setdashboardButton();
AlertUtil.StopWait();
if ((int)app.statu > 0)
{
String right = GetUserPrivilege();
if (right == null || right == "")
{
MessageBox.Show("你没有访问该应用初始Sheet的权利");
spreadsheetMain.Document.CreateNewDocument();
}
else
{
executer.executeCmd(currentSheet, SysEvent.Sheet_Init);
}
}
spreadsheetMain.Document.Calculate();
}
//根据名称获取SHEET
public XRSheet getRSheetByName(String name)
{
XRSheet rsheet = null;
try
{
rsheet = rsheets[name];
}
catch (Exception)
{
rsheet = new XRSheet(book.Worksheets.ActiveWorksheet);
AlertUtil.Show("error", "Sheet：" + name + "未注册!请检查配置！");
statu = SysStatu.Designer;
if (rsheet.sheetName != name)
{
return(null);
}
rsheets.Add(rsheet.sheet.Name, rsheet);
}
return(rsheet);
}
/// <summary>
/// Start new process to check queued alerts
/// </summary>
public void StartQueueProcessor(
string args)
{
_numberOfCurrentProcessors++;
string msg = "Starting queue processor " + NumberOfCurrentProcessors;
AlertUtil.LogAlertMessage(msg);
Progress.Show(msg);
if (Lex.Contains(args, "singleProcessor")) // use single queue processor within this process (for debug)
{
CheckQueuedAlerts(args);
}
else // start separate process to check the queued alerts
{
try
{ CommandLine.StartForegroundSession("Check Queued Alerts " + args, null); }
catch (Exception ex)
{ AlertUtil.LogAlertMessage("Couldn't start new queue processor:\r\n" + ex.Message); }
}
}
//IShareBoardListener
public void Onclick(SnsPlatform snsPlatform, SHARE_MEDIA media)
{
if (snsPlatform.MShowWord.Equals("ä¯ÀÀÆ÷´ò¿ª"))
{
try
{
Intent intent = new Intent(Intent.ActionView);
intent.SetData(Android.Net.Uri.Parse(umWeb.ToUrl()));
context.StartActivity(intent);
}
catch (System.Exception e)
{
AlertUtil.ToastShort(context, "ä¯ÀÀÆ÷´ò¿ªÊ§°Ü");
}
}
else
{
new ShareAction(context).WithMedia(umWeb)
.SetPlatform(media)
.SetCallback(this)
.Share();
}
}
private Range getRowRangeByIndex(int rowNum)
{
int rowindex = -1;
Range rangetmp = getRange();
for (int i = 0; i < rangetmp.RowCount; i++)
{
int tmp;
try
{
if (rangetmp[i, 0].Tag != null && int.TryParse(rangetmp[i, 0].Tag.ToString(), out tmp))
{
if (tmp == rowNum)
{
rowindex = i;
break;
}
}
}
catch (Exception e)
{
AlertUtil.Show("error", e.ToString());
}
}
if (rowindex >= 0)
{
int factindex = getRange().TopRowIndex + rowindex;
int lcolindex = getRange().LeftColumnIndex;
int rcolindex = getRange().RightColumnIndex;
Range range = getRange().Worksheet.Range.FromLTRB(lcolindex, factindex, rcolindex, factindex);
return(range);
}
else
{
return(null);
}
}
public override void fill(DataTable dt)
{
Range range = getRange();
Cell data1stcell = get1stDataCell(range);
string[,] arrtmp = new string[range.RowCount, range.ColumnCount];
try
{
range.Worksheet.Import(arrtmp, data1stcell.RowIndex, data1stcell.ColumnIndex);
range.Worksheet.Import(dt, false, data1stcell.RowIndex, data1stcell.ColumnIndex);
data.setData(dt);
//range.Borders.SetAllBorders(Color.Black, BorderLineStyle.None);
/*for (int i = 0; i < range.RowCount; i++)
* {
* setRowBorderNone(i);
* }*/
doResize(dt.Rows.Count);
}
catch (Exception e)
{
AlertUtil.Show("error", e.ToString());
}
}
public override String ExecuteSql(List <String> Sqls)
{
AlertUtil.Show("XRangeRG Warning!", "Range区域不允许单独执行SQL");
return("OK");
}
public override void onUpdateSelect()
{
AlertUtil.Show("XRangeRG Warning!", "Range区域不允许onUpdateSelect");
return;
}
/// <summary>
/// Method to run query in background and save the results for later retrieval
/// </summary>
/// <param name="q"></param>
/// <param name="emailSubject">Send email if defined</param>
/// <param name="templateName"></param>
/// <returns></returns>
public static string RunBackgroundQuery(
Query q,
string emailSubject,
string templateName)
{
ResultsFormat rf;
QueryManager qm;
DataTableManager dtm;
string msg = "", html = "", resultsFileName;
string viewCmd = "View Background Query Results";
bool notifyUserByEmail = !Lex.IsNullOrEmpty(emailSubject);
try // execute the query & read in all results
{
QbUtil.AddQueryAndRender(q, false); // add it to the query builder
q.BrowseSavedResultsUponOpen = false; // be sure query is run rather than using existing results
msg = QueryExec.RunQuery(q, OutputDest.WinForms);
qm = q.QueryManager as QueryManager;
dtm = qm.DataTableManager;
DialogResult dr = dtm.CompleteRetrieval();
}
catch (Exception ex) // some exceptions are normal, e.g. no criteria, others may be bugs
{
msg = "RunQueryInBackground could not complete due to an unexpected exception: " + DebugLog.FormatExceptionMessage(ex);
ServicesLog.Message(msg);
if (notifyUserByEmail)
{
Email.Send(null, SS.I.UserInfo.EmailAddress, emailSubject, msg);
}
return(msg);
}
if (dtm.KeyCount == 0)
{
msg = "Query " + Lex.Dq(q.UserObject.Name) + " returned no results.";
if (notifyUserByEmail)
{
Email.Send(null, SS.I.UserInfo.EmailAddress, emailSubject, msg);
}
return(msg);
}
try
{
resultsFileName = q.ResultsDataTableFileName; // see if name supplied in query
if (Lex.IsNullOrEmpty(resultsFileName))
{
resultsFileName = "Query_" + q.UserObject.Id + "_Results.bin";
}
resultsFileName = ServicesIniFile.Read("BackgroundExportDirectory") + @"\" + resultsFileName;
dtm.WriteBinaryResultsFile(resultsFileName); // write the file
UserObject cidListUo = SaveBackgroundQueryResultsReferenceObject(qm, "BkgrndQry", resultsFileName);
if (!Lex.IsNullOrEmpty(templateName))
{
html = ReadTemplateFile(templateName);
}
if (notifyUserByEmail)
{
AlertUtil.MailResultsAvailableMessage( // send the mail
q,
dtm.KeyCount,
SS.I.UserInfo.EmailAddress,
emailSubject,
viewCmd,
cidListUo.Id,
null,
html);
}
else
{
html = SubstituteBackgroundExportParameters(html, "", "", dtm.RowCount, dtm.KeyCount, false, "");
return(html); // return the html
}
}
catch (Exception ex)
{
msg = "Error sending background query results: " + DebugLog.FormatExceptionMessage(ex);
ServicesLog.Message(msg);
}
return(msg);
}
