public override string ToString()
{
if (PageCount == 1)
return "";
var sb = new StringBuilder(512);
sb.Append(@"<div class=""");
sb.Append(CssClass);
sb.Append(@""">");
foreach (int pageSize in PageSizes)
{
sb.Append(@"<a href=""");
sb.Append(HRef.Replace("pagesize=-1", "pagesize=" + pageSize));
sb.Append(@""" title=""");
sb.Append("show ");
sb.Append(pageSize);
sb.Append(@" items per page""");
if (pageSize == CurrentPageSize)
sb.Append(@" class=""current page-numbers""");
else
sb.Append(@" class=""page-numbers""");
sb.Append(">");
sb.Append(pageSize);
sb.AppendLine("</a>");
}
sb.AppendLine(@"<span class=""page-numbers desc"">per page</span>");
sb.Append("</div>");
return sb.ToString();
}
public static string FormatResults(BrowseResult res)
{
var sb = new StringBuilder();
sb.Append(res.NumHits);
sb.Append(" hits out of ");
sb.Append(res.TotalDocs);
sb.Append(" docs\n");
BrowseHit[] hits = res.Hits;
var map = res.FacetMap;
var keys = map.Keys;
foreach (string key in keys)
{
var fa = map[key];
sb.AppendLine(key);
var lf = fa.GetFacets();
foreach (var bf in lf)
{
sb.AppendLine("\t" + bf);
}
}
foreach (BrowseHit hit in hits)
{
sb.AppendLine("------------");
sb.Append(FormatHit(hit));
sb.AppendLine();
}
sb.Append("*****************************\n");
return sb.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
ContentNavigation content = new ContentNavigation();
DataSet data = new DataSet();
string[] Vector = new string[6 + 1];
System.Text.StringBuilder sb = new System.Text.StringBuilder();
data = content.getAllContent(Convert.ToInt32(Session["siteId"]));
foreach (DataTable table in data.Tables)
{
foreach (DataRow row in table.Rows)
{
string link = "<a href= CMS_MainSite.aspx?GroupId=" + Convert.ToInt32(row["ContId"]) + ">" + Convert.ToString(row["ContTitle"]) + "</a>";
Vector[Convert.ToInt32(row["ContOrdPos"])] = link;
}
}
for (int i = 1; i < Vector.Length; i++)
{
sb.AppendLine(Convert.ToString(Vector[i]));
}
sb.AppendLine("<hr /> <br/>");
div_Group_Selector.InnerHtml = sb.ToString();
}
protected override void DebugIsValid(StringBuilder sb)
{
if (this.Items == null) return;
sb.AppendLine($"# Invalid Bulk items:");
foreach(var i in Items.Select((item, i) => new { item, i}).Where(i=>!i.item.IsValid))
sb.AppendLine($" operation[{i.i}]: {i.item}");
}
public void WriteRSAParamsToFile(string file)
{
using (var sw = new StreamWriter(new FileStream(file, FileMode.Append, FileAccess.Write)))
{
var sb = new StringBuilder();
sb.AppendLine("class RsaStore");
sb.AppendLine("{");
// Write all private & public rsa parameters.
WritePublicByteArray(ref sb, "D", RsaParams.D);
WritePublicByteArray(ref sb, "DP", RsaParams.DP);
WritePublicByteArray(ref sb, "DQ", RsaParams.DQ);
WritePublicByteArray(ref sb, "Exponent", RsaParams.Exponent);
WritePublicByteArray(ref sb, "InverseQ", RsaParams.InverseQ);
WritePublicByteArray(ref sb, "Modulus", RsaParams.Modulus);
WritePublicByteArray(ref sb, "P", RsaParams.P);
WritePublicByteArray(ref sb, "Q", RsaParams.Q);
sb.AppendLine("}");
sw.WriteLine(sb.ToString());
}
// Reset all values
RsaParams = new RSAParameters();
}
public static Dictionary<string, string> Parse(string dataSource)
{
SortedList<string, SortedSet<string>> allCounters = PdhUtils.Parse(dataSource);
var generated = new Dictionary<string, string>();
foreach (string counterSet in allCounters.Keys)
{
string setName = NameUtils.CreateIdentifier(counterSet);
var sb = new StringBuilder("// This code was generated by EtwEventTypeGen");
sb.AppendLine(setName);
sb.Append("namespace Tx.Windows.Counters.");
sb.AppendLine(setName);
sb.AppendLine();
sb.AppendLine("{");
foreach (string counter in allCounters[counterSet])
{
EmitCounter(counterSet, counter, ref sb);
}
sb.AppendLine("}");
generated.Add(setName, sb.ToString());
}
return generated;
}
public override void GenerateClass(StringBuilder b, int pad)
{
b.Append(' ', pad); b.AppendLine("public class " + Name);
b.Append(' ', pad); b.AppendLine("{");
GenerateFieldsAndFunctions(b, pad + 4);
b.Append(' ', pad); b.AppendLine("}");
}
public string GetDetails()
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("This demo shows several fixtures,");
sb.AppendLine("with varying restitution.");
return sb.ToString();
}
/// <summary>
/// Load the text to display
/// </summary>
protected override string LoadText(ISpyContext settings)
{
var sb = new StringBuilder();
sb.AppendLine("TypeSpec.ID : " + spec.Id.ToString());
sb.AppendLine("TypeSpec.Name : " + spec.Name);
return sb.ToString();
}
public override string ToString()
{
StringBuilder sb = new StringBuilder();
foreach (PingReply pingReply in PingReplyList)
{
if (pingReply != null)
{
switch (pingReply.Status)
{
case IPStatus.Success:
sb.AppendLine(string.Format("Reply from {0}: bytes={1} time={2}ms TTL={3}", pingReply.Address, pingReply.Buffer.Length, pingReply.RoundtripTime, pingReply.Options.Ttl));
break;
case IPStatus.TimedOut:
sb.AppendLine("Request timed out.");
break;
default:
sb.AppendLine(string.Format("Ping failed: {0}", pingReply.Status.ToString()));
break;
}
}
}
if (PingReplyList.Any(x => x.Status == IPStatus.Success))
{
sb.AppendLine(string.Format("Minimum = {0}ms, Maximum = {1}ms, Average = {2}ms", Min, Max, Average));
}
return sb.ToString().Trim();
}
public static IHtmlString Render(string identifier)
{
string shortname = Config.GetValue("disqus/shortname");
var builder = new StringBuilder();
if (string.IsNullOrWhiteSpace(identifier))
{
builder.AppendLine("<script type=\"text/javascript\">");
builder.AppendLine(string.Format("var disqus_shortname = '{0}'; ", shortname));
builder.AppendLine("</script>");
builder.AppendLine(
string.Format("<script type=\"text/javascript\" src=\"//{0}.disqus.com/count.js\"></script>",
shortname));
}
else
{
builder.AppendLine("<script type=\"text/javascript\">");
builder.AppendLine(string.Format("var disqus_shortname = '{0}'; ", shortname));
builder.AppendLine(string.Format("var disqus_identifier = '{0}';", identifier));
builder.AppendLine("</script>");
builder.AppendLine(
string.Format("<script type=\"text/javascript\" src=\"//{0}.disqus.com/embed.js\"></script>",
shortname));
builder.AppendLine(
string.Format("<script type=\"text/javascript\" src=\"//{0}.disqus.com/count.js\"></script>",
shortname));
}
string script = builder.ToString();
return new NonEncodedHtmlString(script);
}
internal override string Introduce()
{
StringBuilder info = new StringBuilder();
info.AppendLine("Boy: ");
info.AppendLine(base.Introduce());
return info.ToString();
}
public static string GenerateSrcFiles(string text, List<FileInfo> srcFiles, DirectoryInfo projectPath, string dirPrefix)
{
const string begin = "#BEGIN_AUTO_GENERATE_SRC_FILES";
const string end = "#END_AUTO_GENERATE_SRC_FILES";
int beginIndex = text.IndexOf(begin) + begin.Length;
int endIndex = text.IndexOf(end);
text = text.Remove(beginIndex, endIndex - beginIndex);
StringBuilder result = new StringBuilder();
result.AppendLine();
result.AppendLine(@"LOCAL_SRC_FILES :=\");
int i = srcFiles.Count;
foreach (var fileInfo in srcFiles)
{
--i;
string fileName = dirPrefix + fileInfo.FullName.Replace(projectPath.FullName, string.Empty).Remove(0, 1);
fileName = fileName.Replace('\\', '/');
if (i!=0)
{
fileName += " \\";
}
result.AppendLine(fileName);
}
text = text.Insert(beginIndex, result.ToString());
return text;
}
public override void CreateFiles(string schemaName)
{
var objectTypeUpper = ObjectType.ToUpperInvariant();
var packages = DbContext.DBA_PROCEDURES
.Where(
p =>
(schemaName == null || p.OWNER == schemaName) &&
(p.OBJECT_TYPE == objectTypeUpper && p.SUBPROGRAM_ID == 0))
.OrderBy(p => p.OBJECT_TYPE)
.ThenBy(p => p.OWNER)
.ThenBy(p => p.OBJECT_NAME)
.ToList();
foreach (var package in packages)
{
var dbObject = DependencyMatrix.GetDbObject(objectTypeUpper, package.OWNER, package.OBJECT_NAME);
var fileName = package.OBJECT_NAME.ToLowerInvariant() + SqlFileExtension;
dbObject.FilePath = FileSystemHelper.GetOutputPath(SubFolderName, package.OWNER) + fileName;
var sqlStringBuilder = new StringBuilder();
sqlStringBuilder.AppendLine(new CommonHeaderFragmentCreator(DbContext, fileName,ObjectType,package.OBJECT_NAME).GetSqlString());
sqlStringBuilder.AppendLine(new DependenciesSqlGenerator(DbContext, package, DependencyMatrix).GetSqlString());
sqlStringBuilder.AppendLine(new PackageSqlGenerator(DbContext, package).GetSqlString());
sqlStringBuilder.AppendLine(new CommonFileFooterFragmentCreator(DbContext, fileName).GetSqlString());
FileSystemHelper.SaveContentToFile(dbObject.FilePath, sqlStringBuilder.ToString());
}
}
/// <summary>
/// Appends "Exit after stopping" or "Stopping"
/// </summary>
/// <param name="customInfo">The autopilot block's custom info</param>
public override void AppendCustomInfo(StringBuilder customInfo)
{
if (m_exitAfter)
customInfo.AppendLine("Exit after stopping");
else
customInfo.AppendLine("Stopping");
}
protected override string CreateInjectingCode(IDictionary<string, string> arguments)
{
string filename;
StringBuilder sb = new StringBuilder();
//When the Solution first opens, templateFile is null.
//I wonder if that is a Bug!
if (this.templateFile != null)
{
//Arguments are passed with the Key in lowercase.
if (!arguments.TryGetValue("filename", out filename))
throw new DirectiveProcessorException("Required argument 'FileName' not specified.");
if (string.IsNullOrEmpty(filename))
throw new DirectiveProcessorException("argument 'FileName' is null or empty.");
string fullPath = Path.Combine(Path.GetDirectoryName(templateFile), filename);
sb.AppendLine("private VsProjectFile _projectFile;");
sb.AppendLine("private VsProjectFile ProjectFile");
sb.AppendLine("{");
sb.AppendLine(" get");
sb.AppendLine(" {");
sb.AppendLine(" if (_projectFile == null)");
sb.AppendLine(" _projectFile = new VsProjectFile(@\"" + fullPath + "\");");
sb.AppendLine(" return _projectFile;");
sb.AppendLine(" }");
sb.AppendLine("}");
}
return sb.ToString();
}
/// <summary>
/// Formats the SQL in a SQL-Server friendly way, with DECLARE statements for the parameters up top.
/// </summary>
public string FormatSql(string commandText, List<SqlTimingParameter> parameters, IDbCommand command = null)
{
StringBuilder buffer = new StringBuilder();
if (command != null && IncludeMetaData)
{
buffer.AppendLine("-- Command Type: " + command.CommandType);
buffer.AppendLine("-- Database: " + command.Connection.Database);
if (command.Transaction != null)
{
buffer.AppendLine("-- Command Transaction Iso Level: " + command.Transaction.IsolationLevel);
}
if (Transaction.Current != null)
{
// transactions issued by TransactionScope are not bound to the database command but exists globally
buffer.AppendLine("-- Transaction Scope Iso Level: " + Transaction.Current.IsolationLevel);
}
buffer.AppendLine();
}
string baseOutput = base.FormatSql(commandText, parameters, command);
buffer.Append(baseOutput);
return buffer.ToString();
}
public override void ToString(StringBuilder builder)
{
builder.AppendFormatLine("{0} ({0:D}) loot contains {1} and {2} items",
this.Type, this.Gold, this.Items.Count);
builder.AppendLine("Object: " + this.Guid);
builder.AppendLine();
builder.AppendLine("Items: " + this.Items.Count);
foreach (Item item in this.Items)
{
builder.AppendFormat(CultureInfo.InvariantCulture, " [{0}] (Permission: {1}) {2} x {3} (DisplayId: {4})",
item.Index, item.Perm, item.Count, item.Entry, item.DisplayId);
if (item.RandomPropertyId != 0 || item.RandomSuffix != 0)
builder.AppendFormatLine(" (Random: Suffix {0}, PropertyId {1})",
item.RandomSuffix, item.RandomPropertyId);
else
builder.AppendLine();
}
builder.AppendLine();
builder.AppendLine("Currencies: " + this.Currencies.Count);
foreach (Currency currency in this.Currencies)
builder.AppendFormat(CultureInfo.InvariantCulture, " [{0}] {1} x {2}",
currency.Index, currency.Count, currency.Entry);
}
/// <summary>
/// The build html.
/// </summary>
private string BuildHtml()
{
var text = this.Context.Request.QueryString["q"] != null
? HttpUtility.HtmlEncode(this.Context.Request.QueryString["q"])
: BlogSettings.Instance.SearchDefaultText;
var sb = new StringBuilder();
sb.AppendLine("<div id=\"searchbox\">");
sb.Append("<label for=\"searchfield\" style=\"display:none\">Search</label>");
sb.AppendFormat(
"<input type=\"text\" value=\"{0}\" id=\"searchfield\" onkeypress=\"if(event.keyCode==13) return BlogEngine.search('{1}')\" onfocus=\"BlogEngine.searchClear('{2}')\" onblur=\"BlogEngine.searchClear('{2}')\" />",
text,
Utils.RelativeWebRoot,
text.Replace("'", "\\'"));
sb.AppendFormat(
"<input type=\"button\" value=\"{0}\" id=\"searchbutton\" onclick=\"BlogEngine.search('{1}');\" onkeypress=\"BlogEngine.search('{1}');\" />",
BlogSettings.Instance.SearchButtonText,
Utils.RelativeWebRoot);
if (BlogSettings.Instance.EnableCommentSearch && BlogSettings.Instance.ShowIncludeCommentsOption)
{
var check = this.Context.Request.QueryString["comment"] != null ? "checked=\"checked\"" : string.Empty;
sb.AppendFormat("<div id=\"search-include-comments\"><input type=\"checkbox\" id=\"searchcomments\" {0} />", check);
if (!string.IsNullOrEmpty(BlogSettings.Instance.SearchCommentLabelText))
{
sb.AppendFormat(
"<label for=\"searchcomments\">{0}</label></div>", BlogSettings.Instance.SearchCommentLabelText);
}
}
sb.AppendLine("</div>");
return sb.ToString();
}
public string Execute()
{
const int firstMultiple = 3;
const int secondMultiple = 5;
const int multiple = firstMultiple*secondMultiple;
var resultBuilder = new StringBuilder();
for (var currentNumber = 1; currentNumber <= 15; currentNumber++)
{
if (currentNumber%multiple == 0)
{
resultBuilder.AppendLine("FizzBuzz");
continue;
}
if (currentNumber%3 == 0)
{
resultBuilder.AppendLine("Fizz");
continue;
}
if (currentNumber%5 == 0)
{
resultBuilder.AppendLine("Buzz");
continue;
}
resultBuilder.AppendLine($"{currentNumber}");
}
return resultBuilder.ToString();
}
public string Dump()
{
if (Results.Count == 0)
{
return "Overload resolution failed because there were no candidate operators.";
}
var sb = new StringBuilder();
if (this.Best.HasValue)
{
sb.AppendLine("Overload resolution succeeded and chose " + this.Best.Signature.ToString());
}
else if (CountKind(OperatorAnalysisResultKind.Applicable) > 1)
{
sb.AppendLine("Overload resolution failed because of ambiguous possible best operators.");
}
else
{
sb.AppendLine("Overload resolution failed because no operator was applicable.");
}
sb.AppendLine("Detailed results:");
foreach (var result in Results)
{
sb.AppendFormat("operator: {0} reason: {1}\n", result.Signature.ToString(), result.Kind.ToString());
}
return sb.ToString();
}
//Create an archive of PackedFile
public static void CreateArchive(PackedFile[] packedFiles, string outputFile)
{
if(packedFiles == null || packedFiles.Length == 0)
{
EditorApplication.Beep();
Debug.LogError("[TCP2 PackFile] No file to pack!");
return;
}
System.Text.StringBuilder sbIndex = new System.Text.StringBuilder();
System.Text.StringBuilder sbContent = new System.Text.StringBuilder();
sbIndex.AppendLine("# TCP2 PACKED SHADERS");
int cursor = 0;
foreach(PackedFile pf in packedFiles)
{
sbContent.Append(pf.content);
sbIndex.AppendLine( pf.path + ";" + cursor.ToString() + ";" + pf.content.Length ); // PATH ; START ; LENGTH
cursor += pf.content.Length;
}
string archiveContent = sbIndex.ToString() + "###\n" + sbContent.ToString();
string fullPath = Application.dataPath + "/" + outputFile;
string directory = Path.GetDirectoryName(fullPath);
if(!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
File.WriteAllText(fullPath, archiveContent);
AssetDatabase.Refresh();
Debug.Log("[TCP2 CreateArchive] Created archive:\n" + fullPath);
}
public static string ToCharacterSeparatedValues(this DataTable table, string delimiter, bool includeHeader)
{
var result = new StringBuilder();
if (includeHeader)
{
foreach (DataColumn column in table.Columns)
{
result.Append(column.ColumnName);
result.Append(delimiter);
}
result.Remove(result.Length, 0);
result.AppendLine();
}
foreach (DataRow row in table.Rows)
{
for (var x = 0; x < table.Columns.Count; x++)
{
if (x != 0)
result.Append(delimiter);
result.Append(row[table.Columns[x]]);
}
result.AppendLine();
}
result.Remove(result.Length, 0);
result.AppendLine();
return result.ToString();
}
public override string ToString()
{
var stringBuilder = new StringBuilder();
stringBuilder.AppendLine(this.Name);
stringBuilder.AppendLine(string.Join(", ", this.Ingredients));
return stringBuilder.ToString();
}
protected override void BuildViewResult(StringBuilder viewResult)
{
var bookings = this.Model as IEnumerable<Booking>;
if (!bookings.Any())
{
viewResult.AppendLine("There are no bookings for this room.");
}
else
{
viewResult.AppendLine("Room bookings:");
}
foreach (var booking in bookings)
{
viewResult.AppendFormat(
"* {0:dd.MM.yyyy} - {1:dd.MM.yyyy} (${2:F2})",
booking.StartBookDate,
booking.EndBookDate,
booking.TotalPrice).AppendLine();
viewResult.AppendFormat(
"Total booking price: ${0:F2}",
bookings.Sum(b => b.TotalPrice)).AppendLine();
}
}
public override void ToString(StringBuilder builder)
{
builder.AppendFormatLine("Items: {0} (displayed: {1})", TotalItemCount, Items.Length);
builder.AppendLine();
foreach (var item in Items)
{
builder.AppendFormatLine("Auction Id: {0} Item Entry: {1}", item.AuctionId, item.ItemEntry);
for (uint i = 0; i < item.Enchantments.Length; ++i)
{
var ench = item.Enchantments[i];
if (ench.Id != 0)
builder.AppendFormatLine(" Enchantment {0}: {1}", i, ench);
}
builder.AppendFormatLine("Property: {0} RandomSuffix: {1} Unknown: {2}",
item.PropertyId, item.SuffixFactor, item.Unknown);
builder.AppendFormatLine("Stack Count: {0} Charges: {1}", item.Count, item.SpellCharges);
builder.AppendLine("Owner: " + item.Owner);
builder.AppendFormatLine("Start Bid: {0} Minimum Bid: {1} BuyOut: {2}",
item.StartBid, item.MinimumBid, item.BuyOut);
builder.AppendLine("Time Left: " + item.TimeLeftMs);
builder.AppendFormatLine("Current Bid: {0} Bidder: {1}", item.CurrentBid, item.CurrentBidder);
builder.AppendLine();
}
builder.AppendLine("Delay: " + NextSearchDelayMs);
}
public static void Send(float ram, float cpu, List<DriveInfo> diskSummary, string subject, List<EventLogEntry> lastLogs)
{
MailAddress to = new MailAddress(Properties.Settings.Default.MailTo);
MailAddress from = new MailAddress(Properties.Settings.Default.MailFrom);
MailMessage mail = new MailMessage(Properties.Settings.Default.MailFrom, Properties.Settings.Default.MailTo);
mail.Subject = subject;
StringBuilder builder = new StringBuilder();
builder.Append("Your CPU Usage: " +cpu+ "\n\nYour RAM Usage: " +ram+ "\n\n");
foreach (DriveInfo disksToWrite in diskSummary)
{
builder.AppendLine(string.Format("{0} {1} GB Free Space of {2} GB Total Size;\n", disksToWrite.Name, ByteConverter.GetGigaBytesFromBytes(disksToWrite.TotalFreeSpace), ByteConverter.GetGigaBytesFromBytes(disksToWrite.TotalSize)));
}
foreach (EventLogEntry logsToWrite in lastLogs)
{
builder.AppendLine(string.Format("{0}; Event ID: {1}; {2}; {3};", logsToWrite.TimeGenerated, logsToWrite.InstanceId, logsToWrite.EntryType,
logsToWrite.Message));
}
builder.AppendLine("\n\n" + subject);
mail.Body = builder.ToString();
SmtpClient smtp = new SmtpClient();
smtp.Host = Properties.Settings.Default.MailSmtpServer;
smtp.Port = Properties.Settings.Default.MailSmtpPort;
smtp.Credentials = new NetworkCredential(
Properties.Settings.Default.MailFrom, Properties.Settings.Default.MailPassword);
smtp.EnableSsl = true;
smtp.Send(mail);
}
internal static void AssertValid(this DbDatabaseMapping databaseMapping, bool shouldThrow)
{
var storageItemMappingCollection = databaseMapping.ToStorageMappingItemCollection();
var errors = new List<EdmSchemaError>();
storageItemMappingCollection.GenerateViews(errors);
if (errors.Any())
{
var errorMessage = new StringBuilder();
errorMessage.AppendLine();
foreach (var error in errors)
{
errorMessage.AppendLine(error.ToString());
}
if (shouldThrow)
{
throw new MappingException(errorMessage.ToString());
}
Assert.True(false, errorMessage.ToString());
}
}
public string GetUsage()
{
var usage = new StringBuilder();
usage.AppendLine("HostCommander v0.1");
usage.AppendLine("Usage: HostCommander -m mode -h host -i ip");
return usage.ToString();
}
public override string GetInfo()
{
var builder = new StringBuilder();
builder.AppendLine("Auto balancing landing Leg");
builder.AppendLine("By KerboKatz");
return builder.ToString();
}
public static string DaubleTableToString(this double[] d)
{
var sb = new Text.StringBuilder();
foreach (var r in d)
{
sb.AppendFormat("El: {0}", r);
sb.AppendLine();
}
return(sb.ToString());
}
/// <summary>
/// 返回异常所有信息
/// </summary>
/// <param name="webHuanHang">是否为web换行</param>
/// <param name="style">样式: color:red; </param>
/// <returns></returns>
public string GetAllExceptionMessage(bool webHuanHang = false, string style = "")
{
System.Text.StringBuilder message = new Text.StringBuilder("");
if (_HasException)
{
int index = 0;
_ExceptionCollection.Reverse().Distinct().ToList().ForEach(x => {
if (webHuanHang)
{
message.AppendFormat(@"<p style='{2}'>【{0}】:{1}</p>", index, x.Message, style);
}
else
{
message.AppendLine(x.Message);
}
index++;
});
}
return(message.ToString());
}
/// <summary>
/// 返回异常所有信息
/// </summary>
/// <param name="webHuanHang">是否为web换行</param>
/// <param name="style">样式: color:red; </param>
/// <returns></returns>
public static string GetAllExceptionMessage(this Exception ex, bool webHuanHang = false, string style = "")
{
var exceptionList = new List <Exception>();
bool hasInnerException = false;
var tmpException = ex;
if (ex != null)
{
exceptionList.Add(tmpException);
hasInnerException = tmpException.InnerException != null;
}
while (hasInnerException)
{
tmpException = tmpException.InnerException;
exceptionList.Add(tmpException);
hasInnerException = tmpException.InnerException != null;
}
StringBuilder message = new Text.StringBuilder("");
int index = 0;
exceptionList.Reverse();
exceptionList.Distinct().ToList().ForEach(x =>
{
if (webHuanHang)
{
message.AppendFormat(@"<p style='{2}'>【{0}】:{1}</p>", index, x.Message, style);
}
else
{
message.AppendLine(x.Message);
}
index++;
});
return(message.ToString());
}
public void CreateTable(SQLiteTable table)
{
StringBuilder sb = new System.Text.StringBuilder();
sb.Append("create table if not exists `");
sb.Append(table.TableName);
sb.AppendLine("`(");
bool firstRecord = true;
foreach (SQLiteColumn col in table.Columns)
{
if (col.ColumnName.Trim().Length == 0)
{
throw new Exception("Column name cannot be blank.");
}
if (firstRecord)
{
firstRecord = false;
}
else
{
sb.AppendLine(",");
}
sb.Append(col.ColumnName);
sb.Append(" ");
if (col.AutoIncrement)
{
sb.Append("integer primary key autoincrement");
continue;
}
switch (col.ColDataType)
{
case ColType.Text:
sb.Append("text"); break;
case ColType.Integer:
sb.Append("integer"); break;
case ColType.Decimal:
sb.Append("decimal"); break;
case ColType.DateTime:
sb.Append("datetime"); break;
case ColType.BLOB:
sb.Append("blob"); break;
}
if (col.PrimaryKey)
{
sb.Append(" primary key");
}
else if (col.NotNull)
{
sb.Append(" not null");
}
else if (col.DefaultValue.Length > 0)
{
sb.Append(" default ");
if (col.DefaultValue.Contains(" ") || col.ColDataType == ColType.Text || col.ColDataType == ColType.DateTime)
{
sb.Append("'");
sb.Append(col.DefaultValue);
sb.Append("'");
}
else
{
sb.Append(col.DefaultValue);
}
}
}
sb.AppendLine(");");
_cmd.CommandText = sb.ToString();
_cmd.ExecuteNonQuery();
}
private void btnProductGoods_Click(object sender, System.EventArgs e)
{
string text = "";
if (!string.IsNullOrEmpty(base.Request["CheckBoxGroup"]))
{
text = base.Request["CheckBoxGroup"];
}
if (text.Length <= 0)
{
this.ShowMsg("请选要下载配货表的订单", false);
return;
}
System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>();
string[] array = text.Split(new char[]
{
','
});
for (int i = 0; i < array.Length; i++)
{
string str = array[i];
list.Add("'" + str + "'");
}
System.Data.DataSet productGoods = OrderHelper.GetProductGoods(string.Join(",", list.ToArray()));
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.AppendLine("<html><head><meta http-equiv=Content-Type content=\"text/html; charset=gb2312\"></head><body>");
stringBuilder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
stringBuilder.AppendLine("<caption style='text-align:center;'>配货单(仓库拣货表)</caption>");
stringBuilder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
stringBuilder.AppendLine("<td>商品名称</td>");
stringBuilder.AppendLine("<td>货号</td>");
stringBuilder.AppendLine("<td>规格</td>");
stringBuilder.AppendLine("<td>拣货数量</td>");
stringBuilder.AppendLine("<td>现库存数</td>");
stringBuilder.AppendLine("</tr>");
foreach (System.Data.DataRow dataRow in productGoods.Tables[0].Rows)
{
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td>" + dataRow["ProductName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat:@\">" + dataRow["SKU"] + "</td>");
stringBuilder.AppendLine("<td>" + dataRow["SKUContent"] + "</td>");
stringBuilder.AppendLine("<td>" + dataRow["ShipmentQuantity"] + "</td>");
stringBuilder.AppendLine("<td>" + dataRow["Stock"] + "</td>");
stringBuilder.AppendLine("</tr>");
}
stringBuilder.AppendLine("</table>");
stringBuilder.AppendLine("</body></html>");
base.Response.Clear();
base.Response.Buffer = false;
base.Response.Charset = "GB2312";
base.Response.AppendHeader("Content-Disposition", "attachment;filename=productgoods_" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
base.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
base.Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
base.Response.Write(stringBuilder.ToString());
base.Response.End();
}
public static void Write(string file, string section, string key, string value, string comment)
{
bool isModified = false;
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
string content = GetText(file);
System.Text.StringBuilder newValueContent = new System.Text.StringBuilder();
#region 写入了节点
if (!string.IsNullOrEmpty(section))
{
string pattern = string.Format(@"\[\s*{0}\s*\](?'valueContent'[^\[\]]*)", section);
MatchCollection matches = new Regex(pattern).Matches(content);
if (matches.Count <= 0)
{
stringBuilder.AppendLine(string.Format("[{0}]", section)); //检查节点是否存在
stringBuilder.AppendLine(string.Format("{0}={1}{2}", key, value, !string.IsNullOrEmpty(comment) ? (";" + comment) : ""));
stringBuilder.AppendLine(content);
isModified = true;
}
else
{
Match match = matches[0];
string valueContent = match.Groups["valueContent"].Value;
string[] lines = valueContent.Split(new string[] { "\r\n" }, System.StringSplitOptions.None);
newValueContent.AppendLine(string.Format("[{0}]", section));
foreach (string line in lines)
{
if (string.IsNullOrEmpty(line) || line == "\r\n" || line.Contains("["))
{
continue;
}
string valueLine = line;
string comments = "";
if (line.Contains(";"))
{
string[] seqPairs = line.Split(';');
if (seqPairs.Length > 1)
{
comments = seqPairs[1].Trim();
}
valueLine = seqPairs[0];
}
string[] keyValuePairs = valueLine.Split('=');
string line_key = keyValuePairs[0];
string line_value = "";
if (keyValuePairs.Length > 1)
{
line_value = keyValuePairs[1];
}
if (key.ToLower().Trim() == line_key.ToLower().Trim())
{
isModified = true;
newValueContent.AppendLine(string.Format("{0}={1}{2}", key, value, !string.IsNullOrEmpty(comment) ? (";" + comment) : ""));
}
else
{
newValueContent.AppendLine(line);
}
}
if (!isModified)
{
newValueContent.AppendLine(string.Format("{0}={1}{2}", key, value, !string.IsNullOrEmpty(comment) ? (";" + comment) : ""));
}
string newVal = newValueContent.ToString();
content = content.Replace(match.Value, newVal);
stringBuilder.Append(content);
}
}
#endregion
#region 没有指明节点
else
{
string valueText = "";
//如果节点为空
MatchCollection matches = new Regex(@"\[\s*(?'section'[^\[\]\s]+)\s*\](?'valueContent'[^\[\]]*)").Matches(content);
if (matches.Count > 0)
{
valueText = matches[0].Index > 0 ? content.Substring(0, matches[0].Index) : "";
string[] lines = valueText.Split(new string[] { "\r\n" }, System.StringSplitOptions.None);
foreach (string line in lines)
{
if (string.IsNullOrEmpty(line) || line == "\r\n" || line.Contains("["))
{
continue;
}
string valueLine = line;
string comments = "";
if (line.Contains(";"))
{
string[] seqPairs = line.Split(';');
if (seqPairs.Length > 1)
{
comments = seqPairs[1].Trim();
}
valueLine = seqPairs[0];
}
string[] keyValuePairs = valueLine.Split('=');
string line_key = keyValuePairs[0];
string line_value = "";
if (keyValuePairs.Length > 1)
{
line_value = keyValuePairs[1];
}
if (key.ToLower().Trim() == line_key.ToLower().Trim())
{
isModified = true;
newValueContent.AppendLine(string.Format("{0}={1}{2}", key, value, !string.IsNullOrEmpty(comment) ? (";" + comment) : ""));
}
else
{
newValueContent.AppendLine(line);
}
}
if (!isModified)
{
newValueContent.AppendLine(string.Format("{0}={1}{2}", key, value, !string.IsNullOrEmpty(comment) ? (";" + comment) : ""));
}
string newVal = newValueContent.ToString();
content = content.Replace(valueText, newVal);
stringBuilder.Append(content);
}
else
{
stringBuilder.AppendLine(string.Format("{0}={1}{2}", key, value, !string.IsNullOrEmpty(comment) ? (";" + comment) : ""));
}
}
#endregion
System.IO.File.WriteAllText(file, stringBuilder.ToString(), Encoding);
}
private void GetClipboardData()
{
if (blnFirstTimeThrough)
{
blnFirstTimeThrough = false;
return;
}
//
// Data on the clipboard uses the
// IDataObject interface
//
strClipboardText = "";
string sText;
IDataObject iData = new DataObject();
string strText = "clipmon";
IntPtr hData;
try
{
iData = Clipboard.GetDataObject();
//if ( ((string)iData.GetData(DataFormats.Text)).StartsWith("?") )
//{
// if (iData.GetDataPresent(DataFormats.UnicodeText))
// {
// //ctlClipboardText.Rtf = (string)iData.GetData(DataFormats.Rtf);
// string ss = (string)iData.GetData(DataFormats.UnicodeText);
// }
// //hData = GetClipboardData(CF_UNICODETEXT);
// //if (hData.ToInt32() == 0)
// //{
// // return;
// //}
// //sText = ConvertToString(hData);
//}
//Clipboard.GetDataObject();
}
catch (System.Runtime.InteropServices.ExternalException externEx)
{
// Copying a field definition in Access 2002 causes this sometimes?
Debug.WriteLine("InteropServices.ExternalException: {0}", externEx.Message);
return;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return;
}
//
// Get RTF if it is present
//
if (iData.GetDataPresent(DataFormats.Text))
{
//ctlClipboardText.Rtf = (string)iData.GetData(DataFormats.Rtf);
//if(iData.GetDataPresent(DataFormats.Text))
//{
// strText = "RTF";
//}
}
else
{
//
// Get Text if it is present
//
if (iData.GetDataPresent(DataFormats.UnicodeText))
{
//ctlClipboardText.Text = (string)iData.GetData(DataFormats.Text);
//strText = "Text";
//Debug.WriteLine((string)iData.GetData(DataFormats.Text));
}
else
{
//
// Only show RTF or TEXT
//
txtTrans.Text = "(cannot display this format)";
return;
}
}
// notAreaIcon.Tooltip = strText;
if (ClipboardSearch(iData))
{
//
// New word go look up.
//
System.Text.StringBuilder strBalloon = new System.Text.StringBuilder(100);
//foreach (string objLink in _lookup)
//{
// strBalloon.Append(objLink.ToString() + "\n");
//}
// WordDef wd = (WordDef)_lookup.Dequeue();
WordDef wd = (WordDef)wdColl.Current;
string t = wd.Tibetan;
strBalloon.Append(wd.Wylie);
strBalloon.Append(" - ");
strBalloon.AppendLine(wd.Trans);
wd = null;
//FormatMenuBuild(iData);
//SupportedMenuBuild(iData);
//ContextMenuBuild();
//if (_lookup.Count > 0)
//{
txtTibetan.Text = t;
txtTrans.Text = strBalloon.ToString();
// notAreaIcon.BalloonDisplay(NotificationAreaIcon.NOTIFYICONdwInfoFlags.NIIF_INFO, "Links", strBalloon.ToString());
//}
}
else
{
txtTibetan.Text = strClipboardText;
txtTrans.Text = "Not Found";
}
}
public void Parse_gfx_should_yield_results()
{
DISetup.SetupContainer();
var sb = new StringBuilder();
sb.AppendLine(@"bitmapfonts = {");
sb.AppendLine(@"");
sb.AppendLine(@" ### ship size icons ###");
sb.AppendLine(@"");
sb.AppendLine(@" bitmapfont = {");
sb.AppendLine(@" name = ""GFX_text_military_size_1""");
sb.AppendLine(@" texturefile = ""gfx/interface/icons/text_icons/icon_text_military_size_1.dds""");
sb.AppendLine(@" }");
sb.AppendLine(@" ");
sb.AppendLine(@" bitmapfont = {");
sb.AppendLine(@" name = ""GFX_text_military_size_2""");
sb.AppendLine(@" texturefile = ""gfx/interface/icons/text_icons/icon_text_military_size_2.dds""");
sb.AppendLine(@" }");
sb.AppendLine(@"}");
var sb2 = new StringBuilder();
sb2.AppendLine(@"bitmapfonts = {");
sb2.AppendLine(@" bitmapfont = {");
sb2.AppendLine(@" name = ""GFX_text_military_size_1""");
sb2.AppendLine(@" texturefile = ""gfx/interface/icons/text_icons/icon_text_military_size_1.dds""");
sb2.AppendLine(@" }");
sb2.AppendLine(@"}");
var sb3 = new System.Text.StringBuilder();
sb3.AppendLine(@"bitmapfonts = {");
sb3.AppendLine(@" bitmapfont = {");
sb3.AppendLine(@" name = ""GFX_text_military_size_2""");
sb3.AppendLine(@" texturefile = ""gfx/interface/icons/text_icons/icon_text_military_size_2.dds""");
sb3.AppendLine(@" }");
sb3.AppendLine(@"}");
var args = new ParserArgs()
{
ContentSHA = "sha",
ModDependencies = new List <string> {
"1"
},
File = "gfx\\gfx.gfx",
Lines = sb.ToString().Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries),
ModName = "fake"
};
var parser = new GraphicsParser(new CodeParser(new Logger()), null);
var result = parser.Parse(args).ToList();
result.Should().NotBeNullOrEmpty();
result.Count().Should().Be(2);
for (int i = 0; i < 2; i++)
{
result[i].ContentSHA.Should().Be("sha");
result[i].Dependencies.First().Should().Be("1");
result[i].File.Should().Be("gfx\\gfx.gfx");
switch (i)
{
case 0:
result[i].Id.Should().Be("GFX_text_military_size_1");
result[i].Code.Should().Be(sb2.ToString().Trim().ReplaceTabs());
result[i].ValueType.Should().Be(Common.ValueType.Object);
break;
case 1:
result[i].Id.Should().Be("GFX_text_military_size_2");
result[i].Code.Should().Be(sb3.ToString().Trim().ReplaceTabs());
result[i].ValueType.Should().Be(Common.ValueType.Object);
break;
default:
break;
}
result[i].ModName.Should().Be("fake");
result[i].Type.Should().Be("gfx\\gfx");
}
}
public void Arg()
{
var file = System.IO.File.ReadAllLines(@"C:\Users\root\Documents\Downloads\A-large.in");
// var file2 = @"3
//11001001
//cats
//zig";
// var file = file2.Replace("\r", "").Split('\n');
int line = 0;
int cases = int.Parse(file[line++]);
var sb = new System.Text.StringBuilder();
for (int c = 1; c <= cases; c++)
{
var ln = file[line++];
var ch = ln.ToCharArray();
var distCh = ch.Distinct().ToArray();
int realNum = distCh.Length;
int baseNum = Math.Max(distCh.Length, 2);
Dictionary <char, int> lookup = new Dictionary <char, int>();
lookup.Add(ch[0], 1);
if (realNum == 1)
{
}
else
{
int num = 0;
for (int i = 1; i < ch.Length; i++)
{
char cc = ch[i];
if (!lookup.ContainsKey(cc))
{
lookup.Add(cc, num);
num++;
}
if (num == 1)
{
num = 2;
}
}
}
long rtn = 0;
for (int i = 0; i < ch.Length; i++)
{
long val = lookup[ch[i]];
long newBase = baseNum;
rtn *= newBase;
rtn += val;
}
sb.AppendFormat("Case #{0}: {1}", c, rtn.ToString());
sb.AppendLine();
}
System.IO.File.WriteAllText(@"C:\Pub\a2.txt", sb.ToString());
}
/// <summary>
/// 信息询问
/// </summary>
/// <param name="msg">信息内容</param>
/// <param name="urla">确定后跳页面</param>
/// <param name="urlb">取消后跳页面</param>
/// <param name="target">页面跳转框架</param>
protected static void JboxShowConfirm(string msg, string urla, string urlb, string target)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.AppendLine("<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">");
sb.AppendLine("<html xmlns=\"http://www.w3.org/1999/xhtml\"><head>");
sb.AppendLine(str_jboxres);
sb.AppendLine("<script type=\"text/javascript\">");
sb.AppendLine("var fun_submit = function (v, h, f) {");
if (urla != "")
{
sb.AppendLine("" + target + ".location.href='" + urla + "';");
}
sb.AppendLine("return true;");
sb.AppendLine("};");
sb.AppendLine("var fun_cancel = function () {");
if (urlb != "")
{
sb.AppendLine("" + target + ".location.href='" + urlb + "';");
}
sb.AppendLine("return true;");
sb.AppendLine("};");
sb.AppendLine("function jboxMsg(msg) {");
sb.AppendLine(" $.jBox.confirm(msg , \"信息提示\", { submit : fun_submit ,cancel : fun_cancel , top: '30%' });");
sb.AppendLine("}");
sb.AppendLine("</script>");
sb.AppendLine("<script language='javascript'>$(document).ready(function () {jboxMsg('" + msg + "');});</script>");
sb.AppendLine("</head><body>");
sb.AppendLine("</body></html>");
System.Web.HttpContext.Current.Response.Write(sb.ToString());
System.Web.HttpContext.Current.Response.End();
}
protected void btnExportButton_Click(object sender, System.EventArgs e)
{
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ActitivyTitle"]))
{
this.ActitivyTitle = this.Page.Request.QueryString["ActitivyTitle"];
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["AddrReggion"]))
{
this.AddrReggion = base.Server.UrlDecode(this.Page.Request.QueryString["AddrReggion"]);
this.SelReggion.SetSelectedRegionId(new int?(int.Parse(this.AddrReggion)));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ShowTabNum"]))
{
this.ShowTabNum = base.Server.UrlDecode(this.Page.Request.QueryString["ShowTabNum"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["Receiver"]))
{
this.Receiver = base.Server.UrlDecode(this.Page.Request.QueryString["Receiver"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ProductName"]))
{
this.ProductName = base.Server.UrlDecode(this.Page.Request.QueryString["ProductName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["StartDate"]))
{
this.StartDate = base.Server.UrlDecode(this.Page.Request.QueryString["StartDate"]);
this.calendarStartDate.SelectedDate = new System.DateTime?(System.DateTime.Parse(this.StartDate));
}
else
{
this.StartDate = "";
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["EndDate"]))
{
this.EndDate = base.Server.UrlDecode(this.Page.Request.QueryString["EndDate"]);
this.calendarEndDate.SelectedDate = new System.DateTime?(System.DateTime.Parse(this.EndDate));
}
else
{
this.EndDate = "";
}
PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery();
prizesDeliveQuery.Status = int.Parse(this.ShowTabNum) - 1;
prizesDeliveQuery.StartDate = this.StartDate;
prizesDeliveQuery.EndDate = this.EndDate;
prizesDeliveQuery.SortBy = "WinTime";
prizesDeliveQuery.PrizeType = 2;
prizesDeliveQuery.SortOrder = SortAction.Desc;
prizesDeliveQuery.PageIndex = this.pager.PageIndex;
prizesDeliveQuery.PageSize = this.pager.PageSize;
prizesDeliveQuery.ProductName = this.ProductName;
prizesDeliveQuery.Receiver = this.Receiver;
prizesDeliveQuery.ReggionId = this.AddrReggion;
prizesDeliveQuery.ActivityTitle = this.ActitivyTitle;
Globals.EntityCoding(prizesDeliveQuery, true);
DbQueryResult allPrizesDeliveryList = GameHelper.GetAllPrizesDeliveryList(prizesDeliveQuery, "", "*");
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
stringBuilder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >活动名称</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >商品名称</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >奖品等级</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >中奖时间</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >收货人</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >联系电话</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >详细地址</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递公司</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递编号</td>");
stringBuilder.AppendLine("</tr>");
System.Data.DataTable dataTable = (System.Data.DataTable)allPrizesDeliveryList.Data;
string text = string.Empty;
string text2 = string.Empty;
new System.Collections.Generic.List <int>();
if (!string.IsNullOrEmpty(this.hidLogId.Value) || !string.IsNullOrEmpty(this.hidPid.Value))
{
text = this.hidLogId.Value;
text2 = this.hidPid.Value;
string[] collection = text.Split(new char[]
{
','
});
string[] collection2 = text2.Split(new char[]
{
','
});
System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>(collection);
System.Collections.Generic.List <string> list2 = new System.Collections.Generic.List <string>(collection2);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
string item = dataTable.Rows[i]["LogId"].ToString();
string item2 = dataTable.Rows[i]["Pid"].ToString();
if (list.Contains(item) || list2.Contains(item2))
{
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Title"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["ProductName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(dataTable.Rows[i]["PrizeGrade"].ToString()) + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["WinTime"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Receiver"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Tel"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Address"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["ExpressName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["CourierNumber"] + "</td>");
stringBuilder.AppendLine("</tr>");
}
}
}
else
{
for (int j = 0; j < dataTable.Rows.Count; j++)
{
dataTable.Rows[j]["LogId"].ToString();
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Title"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["ProductName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(dataTable.Rows[j]["PrizeGrade"].ToString()) + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["WinTime"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Receiver"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Tel"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Address"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["ExpressName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["CourierNumber"] + "</td>");
stringBuilder.AppendLine("</tr>");
}
}
if (dataTable.Rows.Count == 0)
{
stringBuilder.AppendLine("<tr><td></td></tr>");
}
stringBuilder.AppendLine("</table>");
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "UTF-8";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=PrizeLists_" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
this.Page.Response.ContentType = "application/ms-excel";
this.Page.EnableViewState = false;
this.Page.Response.Write(stringBuilder.ToString());
this.Page.Response.End();
}
public virtual void BuildTreeString(System.Text.StringBuilder builder, int indentLevel)
{
builder.Append(' ', indentLevel * 2);
builder.AppendFormat(ToString());
builder.AppendLine();
}
public static bool DoCommandLine(string[] args)
{
if (args.Length <= 1)
{
return(true);
}
patchList.Clear();
System.Text.StringBuilder errorOutput = new System.Text.StringBuilder();
errorOutput.AppendLine("-- ERROR LOG --");
for (int i = 0; i < args.Length; i++)
{
if (args[i].Equals(CMD_HELP, StringComparison.OrdinalIgnoreCase))
{
bHelp = true;
break;
}
else if ((!bEnablelog) && args[i].Equals(CMD_LOG, StringComparison.OrdinalIgnoreCase))
{
bEnablelog = true;
}
else if ((!bInputfile) && args[i].Equals(CMD_INPUT, StringComparison.OrdinalIgnoreCase))
{
if ((i + 1) < args.Length)
{
sInputpath = args[i + 1];
sInputpath = sInputpath.Trim();
if (sInputpath.Length > 0)
{
bInputfile = true;
}
}
else
{
errorOutput.AppendLine(CMD_INPUT + " switch without argument");
}
}
else if ((!bOutputfile) && args[i].Equals(CMD_OUTPUT, StringComparison.OrdinalIgnoreCase))
{
if ((i + 1) < args.Length)
{
sOutputpath = args[i + 1];
sOutputpath = sOutputpath.Trim();
if (sOutputpath.Length > 0)
{
bOutputfile = true;
}
}
else
{
errorOutput.AppendLine(CMD_OUTPUT + " switch without argument");
}
}
else if ((!bUnpack) && args[i].Equals(CMD_UNPACK, StringComparison.OrdinalIgnoreCase))
{
bUnpack = true;
}
else if ((!bDontfix) && args[i].Equals(CMD_DONTFIX, StringComparison.OrdinalIgnoreCase))
{
bDontfix = true;
}
else if (args[i].Equals(CMD_PATCH, StringComparison.OrdinalIgnoreCase))
{
if ((i + 1) < args.Length)
{
try
{
string[] patchParams = args[i + 1].Split(new char[] { ',' }, 4);
PatchFiles pfTemp = new PatchFiles();
pfTemp.file = patchParams[0];
pfTemp.index = Int32.Parse(patchParams[1]);
pfTemp.subindex = Int32.Parse(patchParams[2]);
pfTemp.compress = Int32.Parse(patchParams[3]);
patchList.Push(pfTemp);
bPatch = true;
}
catch
{
errorOutput.AppendLine(CMD_PATCH + " switch with incorrect argument (\"" + args[i + 1] + "\")");
}
}
else
{
errorOutput.AppendLine(CMD_PATCH + " switch without argument");
}
}
else if ((!bFullpatch) && args[i].Equals(CMD_FULLPATCH, StringComparison.OrdinalIgnoreCase))
{
if ((i + 1) < args.Length)
{
sFullpatchPath = args[i + 1];
sFullpatchPath = sFullpatchPath.Trim();
if (sFullpatchPath.Length > 0)
{
bFullpatch = true;
}
}
else
{
errorOutput.AppendLine(CMD_FULLPATCH + " switch without argument");
}
}
}
if (bHelp)
{
MessageBox.Show(MESSAGEBOX_HELP, "UO:KR Uop Dumper - Patch Help", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (bInputfile)
{
if (UopManager.getIstance().Load(sInputpath))
{
if (bUnpack)
{
string thePath = Application.StartupPath + StaticData.UNPACK_DIR;;
if (!Directory.Exists(thePath))
{
Directory.CreateDirectory(thePath);
}
if (!UopManager.getIstance().UnPack(thePath))
{
errorOutput.AppendLine("Error while unpacking the uop file to (\"" + thePath + "\")");
}
}
else if (bFullpatch)
{
UopManager.UopPatchError upeError = UopManager.UopPatchError.Okay;
if (Directory.Exists(sFullpatchPath))
{
try
{
string uopName = Path.GetFileNameWithoutExtension(UopManager.getIstance().UopPath);
string[] filesFound = Directory.GetFiles(sFullpatchPath, uopName + "*.*", SearchOption.TopDirectoryOnly);
foreach (string currentFile in filesFound)
{
string strippedName = Path.GetFileName(currentFile);
if (!strippedName.StartsWith(uopName + "-", StringComparison.OrdinalIgnoreCase))
{
errorOutput.AppendLine("Error while patching \"" + strippedName + "\".");
continue;
}
string parseName = strippedName.Substring(uopName.Length + 1);
if (parseName.IndexOf('_') == -1)
{
errorOutput.AppendLine("Error while patching \"" + strippedName + "\".");
continue;
}
int indexA = -1, indexB = -1;
if (!Int32.TryParse(parseName.Substring(0, parseName.IndexOf('_')), out indexA))
{
errorOutput.AppendLine("Error while patching \"" + strippedName + "\".");
continue;
}
parseName = parseName.Substring(parseName.IndexOf('_') + 1);
if (!Int32.TryParse(parseName.Substring(0, parseName.IndexOf('.')), out indexB))
{
errorOutput.AppendLine("Error while patching \"" + strippedName + "\".");
continue;
}
if ((indexA == -1) || (indexB == -1))
{
errorOutput.AppendLine("Error while patching \"" + strippedName + "\".");
continue;
}
if (parseName.EndsWith("." + StaticData.UNPACK_EXT_COMP))
{
upeError = UopManager.getIstance().Replace(currentFile, indexA, indexB, false);
}
else if (parseName.EndsWith("." + StaticData.UNPACK_EXT_UCOMP))
{
upeError = UopManager.getIstance().Replace(currentFile, indexA, indexB, true);
}
else
{
errorOutput.AppendLine("Error while patching \"" + strippedName + "\".");
continue;
}
if (upeError != UopManager.UopPatchError.Okay)
{
errorOutput.AppendLine("Error while patching \"" + strippedName + "\" (" + upeError.ToString() + ").");
continue;
}
}
if (!bOutputfile)
{
sOutputpath = Utility.GetPathForSave(UopManager.getIstance().UopPath);
}
if (!bDontfix)
{
UopManager.getIstance().FixOffsets(0, 0);
}
if (!UopManager.getIstance().Write(sOutputpath))
{
errorOutput.AppendLine("Error while writing the new uop file (\"" + sOutputpath + "\")");
}
}
catch
{
errorOutput.AppendLine("Error while full-patching \"" + UopManager.getIstance().UopPath + "\" from \"" + sFullpatchPath + "\".");
}
}
else
{
errorOutput.AppendLine("Error while opening non-accessible directory \"" + sFullpatchPath + "\"");
}
}
else if (bPatch)
{
UopManager.UopPatchError upeError = UopManager.UopPatchError.Okay;
int iMinIndex = Int32.MaxValue, iMinSubindex = Int32.MaxValue;
foreach (PatchFiles pfCurrent in patchList)
{
iMinIndex = Math.Min(iMinIndex, pfCurrent.index);
iMinSubindex = Math.Min(iMinSubindex, pfCurrent.subindex);
upeError = UopManager.getIstance().Replace(pfCurrent.file, pfCurrent.index, pfCurrent.subindex, pfCurrent.compress > 0);
if (upeError != UopManager.UopPatchError.Okay)
{
errorOutput.AppendLine("Error (" + upeError.ToString() + ") while patching file \"" + pfCurrent.file + "\" to " + pfCurrent.index.ToString() + "," + pfCurrent.subindex.ToString() + " (" + ((pfCurrent.compress > 0) ? "UN" : "") + "compressed)");
break;
}
}
if (upeError == UopManager.UopPatchError.Okay)
{
if (!bOutputfile)
{
sOutputpath = Utility.GetPathForSave(UopManager.getIstance().UopPath);
}
if (bDontfix)
{
UopManager.getIstance().FixOffsets(iMinIndex, iMinSubindex);
}
if (!UopManager.getIstance().Write(sOutputpath))
{
errorOutput.AppendLine("Error while writing the new uop file (\"" + sOutputpath + "\")");
}
}
}
}
else
{
errorOutput.AppendLine("Error while opening the uop file (\"" + UopManager.getIstance().UopPath + "\")");
}
}
else
{
errorOutput.AppendLine("ERROR: No action defined.");
}
if (bEnablelog)
{
try
{
File.WriteAllText(Application.StartupPath + @"\error.log", errorOutput.ToString());
}
catch { }
}
return(false);
}
public ActionResult PrintReport(string reportPath)
{
var model = this.GetReportViewerModel(Request);
model.ViewMode = ReportViewModes.Print;
model.ReportPath = reportPath;
var contentData = ReportServiceHelpers.ExportReportToFormat(model, ReportFormats.Html4_0);
var content = System.Text.Encoding.ASCII.GetString(contentData.ReportData);
content = ReportServiceHelpers.ReplaceImageUrls(model, content);
var sb = new System.Text.StringBuilder();
sb.AppendLine("<html>");
sb.AppendLine(" <body>");
//sb.AppendLine($" <img src='data:image/tiff;base64,{Convert.ToBase64String(contentData.ReportData)}' />");
sb.AppendLine($" {content}");
sb.AppendLine(" <script type='text/javascript'>");
sb.AppendLine(" (function() {");
/*
* sb.AppendLine(" var beforePrint = function() {");
* sb.AppendLine(" console.log('Functionality to run before printing.');");
* sb.AppendLine(" };");
*/
sb.AppendLine(" var afterPrint = function() {");
sb.AppendLine(" window.onfocus = function() { window.close(); };");
sb.AppendLine(" window.onmousemove = function() { window.close(); };");
sb.AppendLine(" };");
sb.AppendLine(" if (window.matchMedia) {");
sb.AppendLine(" var mediaQueryList = window.matchMedia('print');");
sb.AppendLine(" mediaQueryList.addListener(function(mql) {");
sb.AppendLine(" if (mql.matches) {");
//sb.AppendLine(" beforePrint();");
sb.AppendLine(" } else {");
sb.AppendLine(" afterPrint();");
sb.AppendLine(" }");
sb.AppendLine(" });");
sb.AppendLine(" }");
//sb.AppendLine(" window.onbeforeprint = beforePrint;");
sb.AppendLine(" window.onafterprint = afterPrint;");
sb.AppendLine(" }());");
sb.AppendLine(" window.print();");
sb.AppendLine(" </script>");
sb.AppendLine(" </body>");
sb.AppendLine("<html>");
return(Content(sb.ToString(), "text/html"));
}
public string GenerateHtmlTemplate(bool isLivePreview)
{
string value = string.Empty;
if (System.IO.File.Exists(this.CssFilePath))
{
this._logger.Trace("Loading CSS file: " + this.CssFilePath);
try
{
value = System.IO.File.ReadAllText(this.CssFilePath);
}
catch (System.Exception exception)
{
MessageBoxHelper.ShowErrorMessageBox(LocalizationProvider.GetLocalizedString("Error_OpeningCssFileMessage", true, "MarkdownPadStrings") + this.CssFilePath, LocalizationProvider.GetLocalizedString("Error_OpeningCssFileTitle", false, "MarkdownPadStrings"), exception, "");
}
}
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
string str = string.IsNullOrEmpty(this.Filename) ? "MarkdownPad Document" : System.IO.Path.GetFileNameWithoutExtension(this.Filename);
if (!isLivePreview)
{
stringBuilder.AppendLine("<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">");
}
stringBuilder.AppendLine("<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">");
stringBuilder.AppendLine("<head>");
stringBuilder.AppendLine("<title>" + str + "</title>");
stringBuilder.AppendLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />");
stringBuilder.AppendLine("<style type=\"text/css\">");
stringBuilder.AppendLine(value);
stringBuilder.AppendLine("</style>");
if (this.MarkdownProcessor == MarkdownProcessorType.GithubFlavoredMarkdown)
{
stringBuilder.AppendLine("<style type=\"text/css\">");
stringBuilder.AppendLine(WebResources.PygmentsCss);
stringBuilder.AppendLine("</style>");
}
if (isLivePreview)
{
stringBuilder.AppendLine("<script type='text/javascript'>function loadMarkdown(input) { document.body.innerHTML = input; var links = document.getElementsByTagName('a');var len = links.length;for(var i=0; i<len; i++){links[i].target = '_blank';} } </script>");
}
if (this.UseBaseRelativeImageWorkaround && !string.IsNullOrEmpty(this.Filename))
{
try
{
stringBuilder.AppendLine("<base href='file:\\\\\\" + System.IO.Path.GetDirectoryName(this.Filename) + "\\'/>");
}
catch (System.Exception exception2)
{
this._logger.ErrorException("Error setting relative base URL in HTML template", exception2);
}
}
if (!string.IsNullOrEmpty(this.CustomHeadContent))
{
stringBuilder.AppendLine(this.CustomHeadContent);
}
stringBuilder.AppendLine("</head>");
stringBuilder.AppendLine("<body>");
stringBuilder.AppendLine(this.BodyContent);
stringBuilder.AppendLine("</body>");
stringBuilder.AppendLine("</html>");
stringBuilder.AppendLine("<!-- This document was created with MarkdownPad, the Markdown editor for Windows (http://markdownpad.com) -->");
return(stringBuilder.ToString());
}
public FlowToken Execute(EntityToken entityToken, ActionToken actionToken, FlowControllerServicesContainer flowControllerServicesContainer)
{
DataEntityToken token = (DataEntityToken)entityToken;
IPublishControlled publishControlled = (IPublishControlled)DataFacade.GetDataFromDataSourceId(token.DataSourceId);
ValidationResults validationResults = ValidationFacade.Validate((IData)publishControlled);
if (validationResults.IsValid)
{
UpdateTreeRefresher treeRefresher = new UpdateTreeRefresher(token.Data.GetDataEntityToken(), flowControllerServicesContainer);
if (actionToken is PublishActionToken)
{
publishControlled.PublicationStatus = Published;
}
else if (actionToken is DraftActionToken)
{
publishControlled.PublicationStatus = Draft;
}
else if (actionToken is AwaitingApprovalActionToken)
{
publishControlled.PublicationStatus = AwaitingApproval;
}
else if (actionToken is AwaitingPublicationActionToken)
{
publishControlled.PublicationStatus = AwaitingPublication;
}
else if (actionToken is UnpublishActionToken)
{
publishControlled.PublicationStatus = Draft;
using (TransactionScope transactionScope = TransactionsFacade.CreateNewScope())
{
IData data = DataFacade.GetDataFromOtherScope(token.Data, DataScopeIdentifier.Public).SingleOrDefault();
if (data != null)
{
IPage page = data as IPage;
if (page != null)
{
IEnumerable <IData> referees;
using (new DataScope(DataScopeIdentifier.Public))
{
referees = page.GetMetaData();
}
DataFacade.Delete(referees, CascadeDeleteType.Disable);
}
DataFacade.Delete(data, CascadeDeleteType.Disable);
}
transactionScope.Complete();
}
}
else if (actionToken is UndoPublishedChangesActionToken)
{
using (TransactionScope transactionScope = TransactionsFacade.CreateNewScope())
{
using (ProcessControllerFacade.NoProcessControllers)
{
var administrativeData = (IPublishControlled)token.Data;
IData publishedData = DataFacade.GetDataFromOtherScope(token.Data, DataScopeIdentifier.Public).Single();
publishedData.FullCopyChangedTo(administrativeData);
administrativeData.PublicationStatus = Draft;
DataFacade.Update(administrativeData);
}
transactionScope.Complete();
}
}
else
{
throw new ArgumentException("Unknown action token", "actionToken");
}
DataFacade.Update(publishControlled);
treeRefresher.PostRefreshMesseges(publishControlled.GetDataEntityToken());
}
else
{
var managementConsoleMessageService = flowControllerServicesContainer.GetService <IManagementConsoleMessageService>();
StringBuilder sb = new System.Text.StringBuilder();
sb.AppendLine(StringResourceSystemFacade.GetString("Composite.Plugins.GenericPublishProcessController", "ValidationErrorMessage"));
foreach (ValidationResult result in validationResults)
{
sb.AppendLine(result.Message);
}
managementConsoleMessageService.ShowMessage(DialogType.Error, StringResourceSystemFacade.GetString("Composite.Plugins.GenericPublishProcessController", "ValidationErrorTitle"), sb.ToString());
}
return(null);
}
/// <summary>
/// データ書き出し
/// </summary>
/// <param name="configurationFolder"></param>
public override void Export(string directoryName, string savePath, List <ConfigurationFile> cnfigurationFile)
{
//ファイル名
string cfgFilename = Common.File.CombinePath(savePath, directoryName + "_Departments" + ".cfg");
//格納用
var exportData = new System.Text.StringBuilder();
//パーツ用書き出し用データ作成
foreach (ConfigurationFile cfgFile in cnfigurationFile)
{
foreach (Text.TextData textData in cfgFile.TextDataList)
{
if (textData.DataType == DataType.Departments)
{
var tData = (Text.TextDataDepartments)textData;
if (tData.TranslateTextList.Count >= 1)
{
//スペースが含まれている場合は、?に変換
string name = tData.Name;
name = name.Replace(" ", "?");
if (directoryName.Equals(VanillaDirectoryName, StringComparison.CurrentCultureIgnoreCase))
{
//(Vanilla
exportData.AppendLine(String.Format("@STRATEGY_DEPARTMENT:HAS[#name[{0}]]", name));
}
else
{
//MOD
exportData.AppendLine(String.Format("@STRATEGY_DEPARTMENT:HAS[#name[{0}]]:NEEDS[{1}]:FINAL", name, directoryName));
}
exportData.AppendLine("{");
exportData.AppendLine("\t//English Text");
exportData.AppendLine("\t//\t" + String.Format(@"@desc = {0}", tData.TranslateTextList[0].SourceText));
exportData.AppendLine("\t//Japanese Text");
if (tData.TranslateTextList[0].JapaneseText.Equals("") || tData.TranslateTextList[0].JapaneseText.Equals(tData.TranslateTextList[0].SourceText))
{
exportData.AppendLine("\t//\t" + @"@desc = ");
}
else
{
if (!tData.TranslateTextList[0].Comment.Equals(""))
{
exportData.AppendLine("\t//\t" + tData.TranslateTextList[0].Comment);
}
exportData.AppendLine("\t\t" + String.Format(@"@desc = {0}", tData.TranslateTextList[0].JapaneseText));
}
exportData.AppendLine("}");
exportData.AppendLine("");
}
}
}
}
//データがあればファイル書き出し
this.DataWrite(cfgFilename, exportData);
}
public string _SaveSchemePages(DataTable dt, string[] column, int pageRow, int pageIndex, ref string returnHtml)
{
if (dt == null)
{
returnHtml = "<tr align=\"center\"><td colspan=\"6\">没有您的投注记录</td></tr>";
return("");
}
if (dt.Rows.Count < 1)
{
returnHtml = "<tr align=\"center\"><td colspan=\"6\">没有您的投注记录</td></tr>";
return("");
}
if (column == null)
{
returnHtml = "<tr align=\"center\"><td colspan=\"6\">没有您的投注记录</td></tr>";
return("");
}
if (column.Length < 1)
{
returnHtml = "<tr align=\"center\"><td colspan=\"6\">没有您的投注记录</td></tr>";
return("");
}
if (pageRow < 1)
{
pageRow = 10;
}
returnHtml = "<tr align=\"center\"><td colspan=\"6\">没有您的投注记录</td></tr>"; //
int SumPageCount = 0; // 总页数
// 总行
SumPageCount = dt.Rows.Count;
int xRows = 0;
// 一行多少页
if (pageIndex * pageRow > SumPageCount)
{
xRows = pageRow - (pageRow - SumPageCount % pageRow);
}
else
{
xRows = pageRow;
}
// 拼接Html
System.Text.StringBuilder sb = new System.Text.StringBuilder();
for (int row = (pageIndex - 1) * pageRow; row < (pageIndex - 1) * pageRow + xRows; row++)
{
sb.AppendLine("<tr align=\"center\">");
for (int cols = 0; cols < column.Length; cols++)
{
if (column.Length - 1 == cols)
{
DateTime time = Shove._Convert.StrToDateTime(dt.Rows[row]["EndTime"].ToString(), "2011-08-14 10:00:00");
if (DateTime.Compare(time, DateTime.Now) > 0)
{
sb.AppendLine("<td height=\"30px\"><a href=\"BuyConfirm.aspx?id=" + dt.Rows[row][column[cols]] + "&type=2\"><img src=\"/Home/Room/Images/bet.png\" /></a></td>");
}
else
{
sb.AppendLine("<td height=\"30px\">----</td>");
}
}
else
{
sb.AppendLine("<td height=\"30px\">" + dt.Rows[row][column[cols]] + "</td>");
}
}
sb.AppendLine("</tr>");
}
// 一共有多少页
int SumPageNumber = SumPageCount % pageRow == 0 ? SumPageCount / pageRow : SumPageCount / pageRow + 1;
// 制作 选也按钮
sb.AppendLine("<tr style=\"height:20px;\">");
sb.AppendLine("<td colspan=\"" + (column.Length) + "\" align=\"center\" style=\"border:0px;\">");
// 显示分页的索引
int index = pageIndex < 2 ? 1 : pageIndex - 1;
//Top
if (pageIndex > 1)
{ // 当前页大于1
sb.AppendLine("<a style=\"\" href=\"javascript:SaveSchemes(1)\"><<</a>");
sb.AppendLine("<a style=\"\" href=\"javascript:SaveSchemes(" + (pageIndex - 1).ToString() + ")\">上一页</a>");
}
else
{
sb.AppendLine("<span style=\"color:Gray\"><<</span>");
sb.AppendLine("<span style=\"color:Gray\">上一页</span>");
}
for (int i = 0; i < 6; i++)
{
if (SumPageNumber < index)
{
break;
}
if (index < 1)
{
index = 1;
}
if (SumPageCount - index > 1 && i == 5)
{
sb.AppendLine("<span class=\"currentPage\" style=\"margin-right:5px;\"><a href=\"javascript:Changepage(" + index + ")\" style=\"cursor:pointer;\">" + index + "</a> ..</span>");
}
else if (index > 1 && i == 0)
{
sb.AppendLine("<span class=\"currentPage\" style=\"margin-right:5px;\">.. <a href=\"javascript:Changepage(" + index + ")\" style=\"cursor:pointer;\">" + index + "</a></span>");
}
else if (SumPageNumber == 1)
{
sb.AppendLine("<span class=\"currentPage\" style=\"margin-right:5px;\">1</span>");
}
else
{
if (pageIndex == index)
{
sb.AppendLine("<span class=\"currentPage\" style=\"margin-right:5px;color:Gray;\">" + index + "</span>");
}
else
{
sb.AppendLine("<span class=\"currentPage\" style=\"margin-right:5px;\"><a href=\"javascript:Changepage(" + index + ")\" style=\"cursor:pointer;\">" + index + "</a></span>");
}
}
index++;
}
// Down
if (pageIndex == SumPageNumber)
{
sb.AppendLine("<span style=\"color:Gray\">下一页</span>");
sb.AppendLine("<span style=\"color:Gray\">>></span>");
}
else
{
sb.AppendLine("<a href=\"javascript:SaveSchemes(" + (pageIndex + 1).ToString() + ")\">下一页</a>");
sb.AppendLine("<a href=\"javascript:SaveSchemes(" + SumPageNumber + ")\">>></a>");
}
sb.AppendLine("</td></tr>");
// 返回的Html代码
returnHtml = sb.ToString();
return(returnHtml);
}
/// <summary>
/// 信息询问
/// </summary>
/// <param name="page">页面page对象</param>
/// <param name="msg">信息内容</param>
/// <param name="urla">确定后跳页面</param>
/// <param name="urlb">取消后跳页面</param>
/// <param name="target">页面跳转框架</param>
protected static void JboxShowConfirm(System.Web.UI.Page page, string msg, string urla, string urlb, string target)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.AppendLine("");
bool isjquey = false;
//是否存在 jquery ，不需要重复导入
for (int i = 0; i < page.Header.Controls.Count; i++)
{
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter html_write = new HtmlTextWriter(sw);
page.Header.Controls[i].RenderControl(html_write);
if (sw.ToString().ToLower().Contains("jquery"))
{
isjquey = true;
}
}
//加载需要的库
string adminpath = "/";
string str_res = "<link rel=\"stylesheet\" href=\"" + adminpath + "/tool/JBox/Skins/Blue/jbox.css\" />\n";
if (!isjquey)
{
str_res += "<script type=\"text/javascript\" src=\"" + adminpath + "/js/jquery1.4.js\"></script>\n";
}
str_res += "<script type=\"text/javascript\" src=\"" + adminpath + "/tool/JBox/jquery.jBox-2.3.min.js\"></script>\n";
sb.AppendLine(str_res);
sb.AppendLine("<script type=\"text/javascript\">");
sb.AppendLine("var fun_submit = function (v, h, f) {");
if (urla != "")
{
sb.AppendLine("" + target + ".location.href='" + urla + "';");
}
sb.AppendLine("return true;");
sb.AppendLine("};");
sb.AppendLine("var fun_cancel = function () {");
if (urlb != "")
{
sb.AppendLine("" + target + ".location.href='" + urlb + "';");
}
sb.AppendLine("return true;");
sb.AppendLine("};");
sb.AppendLine("function jboxMsg(msg) {");
sb.AppendLine(" $.jBox.confirm(msg , \"信息提示\", { submit : fun_submit ,cancel : fun_cancel , top: '30%' });");
sb.AppendLine("}");
sb.AppendLine("</script>");
sb.AppendLine("<script language='javascript'>$(document).ready(function () {jboxMsg('" + msg + "');});</script>");
sb.AppendLine("");
page.Header.Controls.AddAt(0, new LiteralControl(sb.ToString()));
//page.ClientScript.RegisterClientScriptBlock(page.GetType(), "jbox", sb.ToString());
}
static string TicksInfo()
{
System.Text.StringBuilder ticksInfoBuilder = new System.Text.StringBuilder("\r\n\r\n");
ticksInfoBuilder.AppendLine("Ticks Info");
ticksInfoBuilder.AppendLine("--------------------------------------------------------------");
const string numberFmt = "{0,-22}{1,18:N0}";
const string timeFmt = "{0,-22}{1,26}";
ticksInfoBuilder.AppendLine(System.String.Format(numberFmt, "Field", "Value"));
ticksInfoBuilder.AppendLine(System.String.Format(numberFmt, "-----", "-----"));
// Display the maximum, minimum, and zero TimeSpan values.
ticksInfoBuilder.AppendLine(System.String.Format(timeFmt, "Maximum TimeSpan", Align(System.TimeSpan.MaxValue)));
ticksInfoBuilder.AppendLine(System.String.Format(timeFmt, "Minimum TimeSpan", Align(System.TimeSpan.MinValue)));
ticksInfoBuilder.AppendLine(System.String.Format(timeFmt, "Zero TimeSpan", Align(System.TimeSpan.Zero)));
ticksInfoBuilder.AppendLine();
// Display the ticks-per-time-unit fields.
ticksInfoBuilder.AppendLine(System.String.Format(numberFmt, "Ticks per day", System.TimeSpan.TicksPerDay));
ticksInfoBuilder.AppendLine(System.String.Format(numberFmt, "Ticks per hour", System.TimeSpan.TicksPerHour));
ticksInfoBuilder.AppendLine(System.String.Format(numberFmt, "Ticks per minute", System.TimeSpan.TicksPerMinute));
ticksInfoBuilder.AppendLine(System.String.Format(numberFmt, "Ticks per second", System.TimeSpan.TicksPerSecond));
ticksInfoBuilder.AppendLine(System.String.Format(numberFmt, "Ticks per millisecond", System.TimeSpan.TicksPerMillisecond));
ticksInfoBuilder.AppendLine("--------------------------------------------------------------");
return(ticksInfoBuilder.ToString());
}
/// <summary>
/// 输出jbox效果
/// </summary>
/// <param name="msg">信息提示</param>
/// <param name="url">跳转地址</param>
/// <param name="target">页面跳转框架</param>
protected static void JboxShow(string msg, string url, string target)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.AppendLine("<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">");
sb.AppendLine("<html xmlns=\"http://www.w3.org/1999/xhtml\"><head>");
sb.AppendLine(str_jboxres);
sb.AppendLine("<script type=\"text/javascript\">");
sb.AppendLine("var fun_submit = function (v, h, f) {");
if (url != "")
{
sb.AppendLine("" + target + ".location.href='" + url + "';");
}
sb.AppendLine("return true;");
sb.AppendLine("};");
sb.AppendLine("var fun_close = function () {");
if (url != "")
{
sb.AppendLine("" + target + ".location.href='" + url + "';");
}
sb.AppendLine("return true;");
sb.AppendLine("};");
sb.AppendLine("function jboxMsg(msg) {");
sb.AppendLine(" $.jBox.info(msg , \"信息提示\", { submit : fun_submit ,closed : fun_close , top: '30%'});");
/*
* sb.AppendLine("$.jBox(msg, {");
* sb.AppendLine(" title: \"信息提示\",");
* sb.AppendLine(" width: 500,");
* sb.AppendLine(" height: 350,");
* sb.AppendLine(" buttons: { '关闭': true }");
* sb.AppendLine("});");*/
sb.AppendLine("}");
sb.AppendLine("</script>");
sb.AppendLine("<script language='javascript'>$(document).ready(function () {jboxMsg('" + msg + "');});</script>");
sb.AppendLine("</head><body>");
sb.AppendLine("</body></html>");
System.Web.HttpContext.Current.Response.Write(sb.ToString());
System.Web.HttpContext.Current.Response.End();
}
public static bool InsertFlowInfo(FlowModel model, string StepNo, string StepName, string StepActor)
{
ArrayList listADD = new ArrayList();
bool result = false;
try
{
#region 增加SQL语句
StringBuilder sqlflow = new StringBuilder();
sqlflow.AppendLine("INSERT INTO officedba.Flow");
sqlflow.AppendLine(" (CompanyCD ");
sqlflow.AppendLine(" ,DeptID ");
sqlflow.AppendLine(" ,FlowNo ");
sqlflow.AppendLine(" ,FlowName ");
sqlflow.AppendLine(" ,BillTypeFlag ");
sqlflow.AppendLine(" ,BillTypeCode ");
sqlflow.AppendLine(" ,UsedStatus ");
sqlflow.AppendLine(" ,IsMobileNotice ");
sqlflow.AppendLine(" ,ModifiedDate ");
sqlflow.AppendLine(" ,ModifiedUserID) ");
sqlflow.AppendLine("VALUES ");
sqlflow.AppendLine(" (@CompanyCD, ");
sqlflow.AppendLine(" @DeptID , ");
sqlflow.AppendLine(" @FlowNo , ");
sqlflow.AppendLine(" @FlowName , ");
sqlflow.AppendLine(" @BillTypeFlag, ");
sqlflow.AppendLine(" @BillTypeCode, ");
sqlflow.AppendLine(" @UsedStatus, ");
sqlflow.AppendLine(" @IsMobileNotice ");
sqlflow.AppendLine(" ,@ModifiedDate ");
sqlflow.AppendLine(" ,@ModifiedUserID) ");
SqlCommand comm = new SqlCommand();
comm.CommandText = sqlflow.ToString();
comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
comm.Parameters.Add(SqlHelper.GetParameter("@DeptID", model.DeptID));
comm.Parameters.Add(SqlHelper.GetParameter("@FlowNo", model.FlowNo));
comm.Parameters.Add(SqlHelper.GetParameter("@FlowName", model.FlowName));
comm.Parameters.Add(SqlHelper.GetParameter("@BillTypeFlag", model.BillTypeFlag));
comm.Parameters.Add(SqlHelper.GetParameter("@BillTypeCode", model.BillTypeCode));
comm.Parameters.Add(SqlHelper.GetParameter("@UsedStatus", model.UsedStatus));
comm.Parameters.Add(SqlHelper.GetParameter("@IsMobileNotice", model.IsMobileNotice));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
listADD.Add(comm);
#endregion
#region 流程步骤添加SQL语句
if (!String.IsNullOrEmpty(StepNo) && !String.IsNullOrEmpty(StepName) && !String.IsNullOrEmpty(StepActor))
{
string[] dStepNo = StepNo.Split(',');
string[] dStepName = StepName.Split(',');
string[] dStepActor = StepActor.Split(',');
//页面上这些字段都是必填，数组的长度必须是相同的
if (dStepNo.Length >= 1)
{
for (int i = 0; i < dStepNo.Length; i++)
{
System.Text.StringBuilder cmdsql = new System.Text.StringBuilder();
cmdsql.AppendLine("INSERT INTO officedba.FlowStepActor");
cmdsql.AppendLine(" (CompanyCD");
cmdsql.AppendLine(" ,FlowNo");
cmdsql.AppendLine(" ,StepNo");
cmdsql.AppendLine(" ,StepName");
cmdsql.AppendLine(" ,Actor");
cmdsql.AppendLine(" ,ModifiedDate");
cmdsql.AppendLine(" ,ModifiedUserID)");
cmdsql.AppendLine(" VALUES");
cmdsql.AppendLine(" (@CompanyCD");
cmdsql.AppendLine(" ,@FlowNo");
cmdsql.AppendLine(" ,@StepNo");
cmdsql.AppendLine(" ,@StepName");
cmdsql.AppendLine(" ,@Actor");
cmdsql.AppendLine(" ,@ModifiedDate");
cmdsql.AppendLine(" ,@ModifiedUserID)");
SqlCommand comms = new SqlCommand();
comms.CommandText = cmdsql.ToString();
comms.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
comms.Parameters.Add(SqlHelper.GetParameter("@FlowNo", model.FlowNo));
if (dStepNo[i].ToString().Length > 0)
{
if (!string.IsNullOrEmpty(dStepNo[i].ToString().Trim()))
{
comms.Parameters.Add(SqlHelper.GetParameter("@StepNo", dStepNo[i].ToString()));
}
}
if (dStepName[i].ToString().Length > 0)
{
if (!string.IsNullOrEmpty(dStepName[i].ToString().Trim()))
{
comms.Parameters.Add(SqlHelper.GetParameter("@StepName", dStepName[i].ToString()));
}
}
if (dStepActor[i].ToString().Length > 0)
{
if (!string.IsNullOrEmpty(dStepActor[i].ToString().Trim()))
{
comms.Parameters.Add(SqlHelper.GetParameter("@Actor", dStepActor[i].ToString()));
}
}
comms.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
comms.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
listADD.Add(comms);
}
}
}
#endregion
if (SqlHelper.ExecuteTransWithArrayList(listADD))
{
result = true;
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 收款单取消确认
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCancelConfirm_Click(object sender, RoutedEventArgs e)
{
var selectedEntites = GetSelectedSOIncomeList();
if (selectedEntites.Count <= 0)
{
Window.Alert(ResCommon.Message_AtLeastChooseOneRecord);
return;
}
var sysNoList = new List <int>();
var cancelSysNoList = new List <int>();
selectedEntites.ForEach(w =>
{
bool isCanceled = true; //是否取消选择
bool isConfirmed = false;
DateTime confirmDate = DateTime.MinValue;
if (w.IncomeStatus == SOIncomeStatus.Confirmed)
{
isConfirmed = w.ConfirmTime.HasValue;
confirmDate = w.ConfirmTime ?? DateTime.MinValue;
}
#region 判断权限，如果不满足收款单确认的条件，则不向服务端提交
if (isConfirmed && AuthMgr.HasFunctionPoint(AuthKeyConst.Invoice_SaleIncomeQuery_CancelConfirm_InConfirmDay))
{
if (DateTime.Now.Subtract(confirmDate).Days == 0)
{
isCanceled = false;
}
}
if (isConfirmed && AuthMgr.HasFunctionPoint(AuthKeyConst.Invoice_SaleIncomeQuery_CancelConfirm_AfterConfirmDay))
{
if (DateTime.Now.Subtract(confirmDate).Days > 0)
{
isCanceled = false;
}
}
#endregion 判断权限，如果不满足收款单确认的条件，则不向服务端提交
if (!isCanceled)
{
sysNoList.Add(w.SysNo.Value);
}
else
{
cancelSysNoList.Add(w.SysNo.Value);
}
});
soIncomeFacade.BatchCancelConfirm(sysNoList, msg =>
{
if (cancelSysNoList.Count > 0)
{
//fixbug:修正提示信息
int matchIndex = 0;
msg = System.Text.RegularExpressions.Regex.Replace(msg, "(\\d+)", match =>
{
matchIndex++;
if (matchIndex == 1 || matchIndex == 3)
{
return((int.Parse(match.Value) + cancelSysNoList.Count).ToString());
}
return(match.Value);
});
System.Text.StringBuilder cancelMsg = new System.Text.StringBuilder();
cancelMsg.AppendLine(ResSaleIncomeQuery.Message_RecordsNotSubmit);
cancelSysNoList.ForEach(w =>
{
cancelMsg.AppendLine(string.Format(ResSaleIncomeQuery.Message_NoOperatePermissionFormat, w));
});
msg += cancelMsg.ToString();
}
Window.Alert(msg, () => this.dgSaleIncomeQueryResult.Bind());
});
}
public static Nullable <Guid> GetCodeMasterID(string Value, string CodeType, bool CreateIfNotExists = false)
{
if (Value == "PreMSC (Application)" && CodeType == "AccountManagerType")
{
return(new Guid("4063B324-60DE-4315-AC3B-711176AD823E"));
}
if (Value == "Business Analyst" && CodeType == "AccountManagerType")
{
return(new Guid("842D6F72-612D-4A21-9D01-FD11B9A407BE"));
}
if (Value == "Financial Analyst" && CodeType == "AccountManagerType")
{
return(new Guid("31F905A0-A4D9-421D-9534-690DF0ECA752"));
}
if (Value == "PostMSC (Application)" && CodeType == "AccountManagerType")
{
return(new Guid("F3538447-717D-4FBC-B32A-65C06D3AD294"));
}
SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["CRM"].ToString());
SqlCommand com = new SqlCommand();
SqlDataAdapter ad = new SqlDataAdapter(com);
System.Text.StringBuilder sql = new System.Text.StringBuilder();
sql.AppendLine("SELECT CodeMasterID");
sql.AppendLine("FROM CodeMaster");
sql.AppendLine("WHERE CodeType = @CodeType");
sql.AppendLine("AND CodeName = @Value");
com.CommandText = sql.ToString();
com.CommandType = CommandType.Text;
com.Connection = con;
//con.Open()
try
{
com.Parameters.Add(new SqlParameter("@CodeType", CodeType));
com.Parameters.Add(new SqlParameter("@Value", Value));
DataTable dt = new DataTable();
ad.Fill(dt);
if (dt.Rows.Count > 0)
{
return(new Guid(dt.Rows[0][0].ToString()));
}
else
{
if (CreateIfNotExists)
{
return(CreateCodeMaster(Value, CodeType));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
throw;
}
finally
{
con.Close();
}
}
private string FormatCondensedJson(string str)
{
str = (str ?? "").Replace("{}", @"\{\}").Replace("[]", @"\[\]");
var inserts = new List <int[]>();
bool quoted = false, escape = false;
int depth = 0 /*-1*/;
char prev = '-';
for (int i = 0, N = str.Length; i < N; i++)
{
var chr = str[i];
if (!escape && !quoted)
{
switch (chr)
{
//case '{':
case '[':
inserts.Add(new[] { i, +1, 0, INDENT_SIZE * ++depth });
//int n = (i == 0 || "{[,".Contains(str[i - 1])) ? 0 : -1;
//inserts.Add(new[] { i, n, INDENT_SIZE * ++depth * -n, INDENT_SIZE - 1 });
break;
case ',':
if (prev == '}' || prev == ']')
{
inserts.Add(new[] { i, +1, 0, INDENT_SIZE * depth });
}
else
{
inserts.Add(new[] { i, 0, 1, 1 });
}
//inserts.Add(new[] { i, -1, INDENT_SIZE * depth, INDENT_SIZE - 1 });
break;
//case '}':
case ']':
inserts.Add(new[] { i, -1, INDENT_SIZE * --depth, 0 });
//inserts.Add(new[] { i, -1, INDENT_SIZE * depth--, 0 });
break;
case ':':
inserts.Add(new[] { i, 0, 1, 1 });
break;
}
}
quoted = (chr == '"') ? !quoted : quoted;
escape = (chr == '\\') && !escape;
prev = chr;
}
if (inserts.Count > 0)
{
var sb = new System.Text.StringBuilder(str.Length * 2);
int lastIndex = 0;
foreach (var insert in inserts)
{
int index = insert[0], before = insert[2], after = insert[3];
bool nlBefore = (insert[1] == -1), nlAfter = (insert[1] == +1);
sb.Append(str.Substring(lastIndex, index - lastIndex));
if (nlBefore)
{
sb.AppendLine();
}
if (before > 0)
{
sb.Append(new String(' ', before));
}
sb.Append(str[index]);
if (nlAfter)
{
sb.AppendLine();
}
if (after > 0)
{
sb.Append(new String(' ', after));
}
lastIndex = index + 1;
}
str = sb.ToString();
}
return(str.Replace(@"\{\}", "{}").Replace(@"\[\]", "[]"));
}
protected override CompanyProfileResult ConvertResult(Base.ConnectionInfo connInfo, System.IO.Stream stream, Base.SettingsBase settings)
{
CompanyProfileData res = null;
System.Globalization.CultureInfo convCulture = new System.Globalization.CultureInfo("en-US");
if (stream != null)
{
XParseDocument doc = MyHelper.ParseXmlDocument(stream);
XParseElement resultNode = XPath.GetElement("//table[@id=\"yfncsumtab\"]/tr[2]", doc);
if (resultNode != null)
{
res = new CompanyProfileData();
res.SetID(FinanceHelper.CleanIndexID(((CompanyProfileDownloadSettings)settings).ID.ToUpper()));
XParseElement nameNode = XPath.GetElement("td[1]/b[1]", resultNode);
if (nameNode != null)
{
res.CompanyName = nameNode.Value;
}
XParseElement addressNode = XPath.GetElement("td[1]", resultNode);
if (addressNode != null)
{
System.Text.StringBuilder formattedAddress = new System.Text.StringBuilder();
try
{
string addNodeStr = addressNode.ToString();
if (addNodeStr != string.Empty)
{
addNodeStr = addNodeStr.Substring(addNodeStr.IndexOf("/>") + 2);
string[] rawAddress = addNodeStr.Substring(0, addNodeStr.IndexOf("Website")).Split(new string[] { "<b>", "<br />", "</b>", "\r", "\n", " - ", "</a>" }, StringSplitOptions.RemoveEmptyEntries);
if (rawAddress.Length >= 7)
{
foreach (string line in rawAddress)
{
string l = line.Trim();
if (l != string.Empty && !l.StartsWith("<a") && l != "Map")
{
formattedAddress.AppendLine(l);
}
}
}
}
}
catch (Exception ex)
{
}
res.Address = formattedAddress.ToString().TrimEnd();
}
XParseElement indicesNode = XPath.GetElement("td[1]/table[2]/tr/td/table/tr/td[2]", resultNode);
if (indicesNode != null)
{
List <KeyValuePair <string, string> > lstIndices = new List <KeyValuePair <string, string> >();
foreach (XParseElement indexLink in indicesNode.Elements())
{
if (indexLink.Name.LocalName == "a")
{
string indexID = Uri.UnescapeDataString(MyHelper.GetXmlAttributeValue(indexLink, "href").ToUpper().Replace("HTTP://FINANCE.YAHOO.COM/Q?S=", "").Replace("&D=T", ""));
string name = string.Empty;
foreach (string p in indexLink.Value.Split(new string[] { "\r\n" }, StringSplitOptions.None))
{
name += p.Trim() + " ";
}
lstIndices.Add(new KeyValuePair <string, string>(indexID, name.TrimEnd()));
}
}
res.Details.IndexMembership = lstIndices.ToArray();
}
XParseElement sectorsNode = XPath.GetElement("td[1]/table[2]/tr/td/table/tr[2]/td[2]", resultNode);
if (sectorsNode != null)
{
foreach (XParseElement sectorLink in sectorsNode.Elements())
{
if (sectorLink.Name.LocalName == "a")
{
foreach (Sector sect in Enum.GetValues(typeof(Sector)))
{
string name = string.Empty;
foreach (string p in sectorLink.Value.Split(new string[] { "\r\n" }, StringSplitOptions.None))
{
name += p.Trim() + " ";
}
name = name.TrimEnd();
if (sect.ToString().Replace("_", " ") == name)
{
res.Details.Sector = sect;
break;
}
}
}
}
}
XParseElement industryNode = XPath.GetElement("td[1]/table[2]/tr/td/table/tr[3]/td[2]", resultNode);
if (industryNode != null)
{
foreach (XParseElement industryLink in industryNode.Elements())
{
if (industryLink.Name.LocalName == "a")
{
int indIndex = 0;
if (int.TryParse(MyHelper.GetXmlAttributeValue(industryLink, "href").Replace("http://biz.yahoo.com/ic/", "").Replace(".html", ""), out indIndex))
{
res.Details.Industry = (Industry)indIndex;
}
}
}
}
XParseElement employeesNode = XPath.GetElement("td[1]/table[2]/tr/td/table/tr[4]/td[2]", resultNode);
if (employeesNode != null)
{
int fte;
if (int.TryParse(employeesNode.Value.Trim(), System.Globalization.NumberStyles.Any, convCulture, out fte))
{
res.Details.FullTimeEmployees = fte;
}
}
XParseElement summaryNode = XPath.GetElement("td[1]/p[1]", resultNode);
if (summaryNode != null)
{
System.Text.StringBuilder summaryText = new System.Text.StringBuilder();
foreach (string line in summaryNode.Value.Split(new string[] { "\r\n" }, StringSplitOptions.None))
{
summaryText.Append(line.Trim() + " ");
}
res.BusinessSummary = summaryText.ToString().TrimEnd();
}
XParseElement websitesNodes = XPath.GetElement("td[1]/table[5]/tr/td", resultNode);
if (websitesNodes != null)
{
List <Uri> lstWebsites = new List <Uri>();
foreach (XParseElement linkNode in websitesNodes.Elements())
{
if (linkNode.Name.LocalName == "a")
{
lstWebsites.Add(new Uri(MyHelper.GetXmlAttributeValue(linkNode, "href")));
}
}
res.CompanyWebsites = lstWebsites.ToArray();
}
XParseElement governanceNode = null;
XParseElement governanceHeader = XPath.GetElement("td[3]/table[1]/tr/th/span", resultNode);
if (governanceHeader != null && governanceHeader.Value.Contains("Governance"))
{
governanceNode = XPath.GetElement("td[3]/table[2]/tr/td", resultNode);
}
if (governanceNode != null)
{
System.Text.StringBuilder governanceText = new System.Text.StringBuilder();
foreach (string line in governanceNode.Value.Split(new string[] { "\r\n" }, StringSplitOptions.None))
{
governanceText.Append(line.Trim() + " ");
}
res.CorporateGovernance = governanceText.ToString().TrimEnd();
}
XParseElement executivesNode = null;
XParseElement executivesHeader = XPath.GetElement("td[3]/table[3]/tr/th/span", resultNode);
if (executivesHeader != null && executivesHeader.Value.Contains("Executives"))
{
executivesNode = XPath.GetElement("td[3]/table[4]/tr/td/table", resultNode);
}
else
{
executivesNode = XPath.GetElement("td[3]/table[2]/tr/td/table", resultNode);
}
if (executivesNode != null)
{
List <ExecutivePersonInfo> lst = new List <ExecutivePersonInfo>();
bool isFirst = true;
foreach (XParseElement row in executivesNode.Elements())
{
if (!isFirst)
{
if (row.Name.LocalName == "tr")
{
XParseElement[] enm = MyHelper.EnumToArray(row.Elements());
if (enm.Length >= 3)
{
ExecutivePersonInfo exec = new ExecutivePersonInfo();
string name = string.Empty;
foreach (string l in MyHelper.EnumToArray(enm[0].Elements())[0].Value.Split(new string[] { "\r\n" }, StringSplitOptions.None))
{
name += l.Trim() + " ";
}
exec.Name = name.TrimEnd();
string position = string.Empty;
var enm2 = MyHelper.EnumToArray(enm[0].Elements());
foreach (string l in enm2[enm2.Length - 1].Value.Split(new string[] { "\r\n" }, StringSplitOptions.None))
{
position += l.Trim() + " ";
}
exec.Position = position.Trim();
string payStr = enm[1].Value.Replace("\r\n", "").Trim();
if (!payStr.Contains("N/A"))
{
exec.Pay = FinanceHelper.GetMillionValue(payStr) * 1000000;
}
string exercisedStr = enm[2].Value.Replace("\r\n", "").Trim();
if (!exercisedStr.Contains("N/A"))
{
double d = FinanceHelper.GetMillionValue(exercisedStr);
exec.Exercised = (int)(d * 1000000);
}
lst.Add(exec);
}
}
}
else
{
isFirst = false;
}
}
res.KeyExecutives = lst.ToArray();
}
if (res.BusinessSummary.StartsWith("There is no "))
{
res = null;
}
}
}
return(new CompanyProfileResult(res));
}
/// <summary>
///
/// </summary>
/// <param name="sbWork">StringBuilder to append method</param>
/// <param name="classNamespace">class name</param>
/// <param name="methodName">method name</param>
/// <param name="method">Ajax method</param>
/// <param name="parameters">List of parameters</param>
/// <param name="ajaxClass"> </param>
/// <param name="useTraditionalParameterForm"> Use traditional parameters, like function(parm1,parm2,parm3) instead function(options), calling myFunc({data:'data'});</param>
/// <returns></returns>
public virtual void CreateMethodBody(ref System.Text.StringBuilder sbWork, string classNamespace, string methodName, AjaxMethodItem method, IList <Entities.Parameter> parameters, AjaxClassItem ajaxClass, bool useTraditionalParameterForm = false)
{
var functionBody = new StringBuilder("function(");
if (useTraditionalParameterForm)
{
for (var index = 0; index < parameters.Count; index++)
{
if (index != 0)
{
functionBody.Append(",");
}
var parameter = parameters[index];
functionBody.Append(parameter.Name);
}
functionBody.Append((parameters.Count > 0 ? "," : "") + "callbackSuccess,callbackError,callbackComplete,uploadProgress");
}
else
{
functionBody.Append("options");
}
functionBody.Append("){" + GetNewLineTab(1));
functionBody.Append(GetNewLineTab(1));
functionBody.Append("var mtnOptions = (typeof options === 'undefined' || options == null)?{}:options;");
functionBody.Append(GetNewLineTab(1));
functionBody.Append("mtnOptions.data = mtnOptions.data || {};");
functionBody.Append(GetNewLineTab(1));
if (useTraditionalParameterForm)
{
functionBody.Append(GetNewLineTab(1));
functionBody.
Append("mtnOptions.callbackSuccess = callbackSuccess;").Append(GetNewLineTab(1)).
Append("mtnOptions.callbackError = callbackError;").Append(GetNewLineTab(1)).
Append("mtnOptions.callbackComplete = callbackComplete;").Append(GetNewLineTab(1)).
Append("mtnOptions.uploadProgress = uploadProgress;");
functionBody.Append(GetNewLineTab(1));
if (parameters.Count > 0)
{
functionBody.Append("mtnOptions.data = {");
for (var index = 0; index < parameters.Count; index++)
{
var parameter = parameters[index];
functionBody.Append(GetNewLineTab(2));
functionBody.Append((index != 0 ? "," : ""))
.Append(parameter.Name).Append(":").Append(parameter.Name);
}
functionBody.Append(GetNewLineTab(1));
functionBody.Append("};");
}
functionBody.Append(GetNewLineTab(1));
}
for (var index = 0; index < parameters.Count; index++)
{
var parameter = parameters[index];
if (parameter.Type.IsPrimitiveMtn() || parameter.Type.FullName.ToLower().Contains("httppostedfile"))
{
continue;
}
functionBody.Append(GetNewLineTab(1));
functionBody.AppendFormat("mtnOptions.data.{0} = JSON.stringify(mtnOptions.data.{0});", parameter.Name);
functionBody.Append(GetNewLineTab(1));
}
functionBody.AppendFormat("mtnOptions.data.__MtnClassHash = '{0}';", ajaxClass.Key);
functionBody.Append(GetNewLineTab(1));
functionBody.AppendFormat("mtnOptions.data.__MtnMethodHash = '{0}';", method.Key);
functionBody.Append(GetNewLineTab(1));
switch (Mode)
{
case WebModeType.AjaxHandler:
functionBody.Append("mtnOptions.url='")
.Append(HostUrl).Append("/")
.Append(classNamespace.ToLowerInvariant()).Append(".").Append(methodName)
.Append(".").Append(Utils.Parameter.AjaxExtension)
.Append("';");
break;
case WebModeType.MvcController:
functionBody.Append("mtnOptions.url='")
.Append(HostUrl).Append("/{MtnMvcRoute}")
.Append(classNamespace.Replace(".", Web.Utils.Parameter.SeoCharacter).ToLowerInvariant()).Append("/").Append(methodName.ToLowerInvariant())
.Append("/';");
break;
default:
functionBody.Append("mtnOptions.url='")
.Append(HostUrl).Append("/{MtnMvcRoute}")
.Append(classNamespace.Replace(".", Web.Utils.Parameter.SeoCharacter).ToLowerInvariant()).Append("/").Append(methodName.ToLowerInvariant())
.Append("/';");
break;
}
functionBody.Append(GetNewLineTab(1));
functionBody.AppendFormat("mtnOptions.responseType = '{0}';", method.AjaxMethod.ResponseType.ToString().ToLowerInvariant());
functionBody.Append(GetNewLineTab(1));
string ajaxTmpl = "";
switch (method.AjaxMethod.RequestType)
{
case RequestType.Post:
ajaxTmpl = AjaxPostFunctionTemplate;
break;
case RequestType.Get:
ajaxTmpl = AjaxGetFunctionTemplate;
break;
}
ajaxTmpl = String.Format(ajaxTmpl, HasFileUpload(parameters).ToString().ToLower());
functionBody.AppendLine(ajaxTmpl);
functionBody.AppendLine("};");
if (RootNamespace.IsNullOrWhiteSpaceMtn())
{
sbWork.AppendFormat("{0}.{1} = {2}", classNamespace, methodName, functionBody.ToString());
}
else
{
sbWork.AppendFormat("{0}.{1}.{2} = {3}", RootNamespace, classNamespace, methodName, functionBody.ToString());
}
sbWork.AppendLine();
}
void Init()
{
DynamicLayout p1, p2;
StackLayout t1;
p1 = UI.Shared.Common.GetDefaultContainer();
p2 = UI.Shared.Common.GetDefaultContainer();
p1.Width = 380;
p2.Width = 470;
t1 = new StackLayout();
t1.Items.Add(new StackLayoutItem(p1));
t1.Items.Add(new StackLayoutItem(p2));
t1.Orientation = Orientation.Horizontal;
Padding = new Padding(10);
if (flowsheet.SensAnalysisCollection.Count == 0)
{
flowsheet.SensAnalysisCollection.Add(new DWSIM.SharedClasses.Flowsheet.Optimization.SensitivityAnalysisCase());
}
mycase = flowsheet.SensAnalysisCollection.First();
var su = flowsheet.FlowsheetOptions.SelectedUnitSystem;
var nf = flowsheet.FlowsheetOptions.NumberFormat;
s.CreateAndAddLabelRow2(this, "Use the Sensitivity Analysis tool to study/analyze the influence of a process variable on other variables in the flowsheet.");
this.Add(t1);
s.CreateAndAddLabelRow(p1, "Case ID");
s.CreateAndAddFullTextBoxRow(p1, mycase.name, (arg3, arg2) => { mycase.name = arg3.Text; });
s.CreateAndAddLabelRow(p1, "Case Description");
s.CreateAndAddFullTextBoxRow(p1, mycase.description, (arg3, arg2) => { mycase.description = arg3.Text; });
s.CreateAndAddLabelRow(p1, "Independent Variable");
var objlist = flowsheet.SimulationObjects.Values.Select((x2) => x2.GraphicObject.Tag).ToList();
objlist.Insert(0, "");
var spinner = s.CreateAndAddDropDownRow(p1, "Object", objlist, 0, null);
var spinner2 = s.CreateAndAddDropDownRow(p1, "Property", new List <string>(), 0, null);
List <string> proplist = new List <string>();
spinner.SelectedIndexChanged += (sender, e) =>
{
if (spinner.SelectedIndex > 0)
{
mycase.iv1.objectID = flowsheet.GetFlowsheetSimulationObject(objlist[spinner.SelectedIndex]).Name;
mycase.iv1.objectTAG = objlist[spinner.SelectedIndex];
proplist = flowsheet.GetFlowsheetSimulationObject(objlist[spinner.SelectedIndex]).GetProperties(PropertyType.WR).ToList();
proplist.Insert(0, "");
spinner2.Items.Clear();
spinner2.Items.AddRange(proplist.Select(x => new ListItem {
Key = x, Text = flowsheet.GetTranslatedString(x)
}).ToList());
spinner2.SelectedIndex = (proplist.IndexOf(mycase.iv1.propID));
}
else
{
spinner2.Items.Clear();
}
};
if (flowsheet.SimulationObjects.ContainsKey(mycase.iv1.objectID))
{
spinner.SelectedIndex = (objlist.IndexOf(flowsheet.SimulationObjects[mycase.iv1.objectID].GraphicObject.Tag));
}
var txtLowerLimit = s.CreateAndAddTextBoxRow(p1, nf, "Initial Value", 0, null);
var txtUpperLimit = s.CreateAndAddTextBoxRow(p1, nf, "Final Value", 0, null);
var txtSteps = s.CreateAndAddTextBoxRow(p1, "0", "Number of Steps", 0, null);
txtLowerLimit.Text = mycase.iv1.lowerlimit.GetValueOrDefault().ToString(nf);
txtUpperLimit.Text = mycase.iv1.upperlimit.GetValueOrDefault().ToString(nf);
txtSteps.Text = mycase.iv1.points.ToString();
var labelUnits = s.CreateAndAddTwoLabelsRow(p1, "Property Units", "");
spinner2.SelectedIndexChanged += (sender, e) =>
{
if (spinner2.SelectedIndex > 0)
{
mycase.iv1.propID = proplist[spinner2.SelectedIndex];
mycase.iv1.unit = flowsheet.GetFlowsheetSimulationObject(objlist[spinner.SelectedIndex]).GetPropertyUnit(proplist[spinner2.SelectedIndex], su);
labelUnits.Text = mycase.iv1.unit;
}
};
double dummy = 0.0f;
txtLowerLimit.TextChanged += (sender2, e2) =>
{
if (double.TryParse(txtLowerLimit.Text.ToString(), out dummy))
{
mycase.iv1.lowerlimit = Double.Parse(txtLowerLimit.Text);
}
};
txtUpperLimit.TextChanged += (sender2, e2) =>
{
if (double.TryParse(txtUpperLimit.Text.ToString(), out dummy))
{
mycase.iv1.upperlimit = Double.Parse(txtUpperLimit.Text);
}
};
txtSteps.TextChanged += (sender2, e2) =>
{
if (double.TryParse(txtSteps.Text.ToString(), out dummy))
{
mycase.iv1.points = Int32.Parse(txtSteps.Text);
}
};
s.CreateAndAddEmptySpace(p1);
s.CreateAndAddEmptySpace(p1);
s.CreateAndAddEmptySpace(p1);
s.CreateAndAddEmptySpace(p1);
s.CreateAndAddEmptySpace(p1);
s.CreateAndAddEmptySpace(p1);
var btnAddDepVar = s.CreateAndAddBoldLabelAndButtonRow(p2, "Dependent Variables", "Add New", null, null);
var ll = new StackLayout {
Orientation = Orientation.Vertical, Padding = new Eto.Drawing.Padding(2), Spacing = 10
};
ll.RemoveAll();
var sc = new Scrollable {
Border = BorderType.None, Content = ll
};
s.CreateAndAddControlRow(p2, sc);
t1.SizeChanged += (sender, e) => {
if (p1.ParentWindow != null)
{
p1.Width = (int)(p1.ParentWindow.Width / 2 - 10);
p2.Width = (int)(p2.ParentWindow.Width / 2 - 10);
p1.Height = p1.ParentWindow.Height - 170;
p2.Height = p1.Height;
sc.Height = p2.Height - btnAddDepVar.Height - 30;
//foreach (var item in ll.Items)
//{
// item.Control.Width = sc.Width - 25;
//}
}
};
foreach (var dvar in mycase.depvariables.Values)
{
AddDepVar(ll, dvar, objlist);
}
btnAddDepVar.Click += (sender2, e2) =>
{
var depvar = new DWSIM.SharedClasses.Flowsheet.Optimization.SAVariable();
depvar.id = Guid.NewGuid().ToString();
mycase.depvariables.Add(depvar.id, depvar);
AddDepVar(ll, depvar, objlist);
};
var btnRun = s.CreateAndAddButtonRow(this, "Run Analysis", null, null);
var btnAbort = s.CreateAndAddButtonRow(this, "Abort Run", null, null);
btnAbort.Enabled = false;
resulttextbox = new TextArea {
Height = 400, Text = "", Font = Fonts.Monospace(GlobalSettings.Settings.ResultsReportFontSize), ReadOnly = true
};
s.CreateAndAddLabelRow(this, "Results");
var btnrt = s.CreateAndAddLabelAndButtonRow(this, "View Results Report", "View Report", null, (sender, e) =>
{
var form = s.GetDefaultEditorForm("Sensitivity Analysis Report", 500, 500, resulttextbox, true);
form.Show();
});
btnrt.Enabled = false;
resultschart = new Eto.OxyPlot.Plot {
Height = 400
};
var btnrc = s.CreateAndAddLabelAndButtonRow(this, "View Results Chart", "View Chart", null, (sender, e) =>
{
var form = s.GetDefaultEditorForm("Sensitivity Analysis Result", 500, 500, resultschart, true);
form.Show();
});
btnrc.Enabled = false;
s.CreateAndAddEmptySpace(this);
s.CreateAndAddEmptySpace(this);
btnRun.Click += (sender2, e2) =>
{
int iv1np, i;
double iv1ll, iv1ul, iv1val, iv1val0;
string iv1id, iv1prop;
List <List <double> > results = new List <List <double> >();
iv1ll = Converter.ConvertToSI(mycase.iv1.unit, mycase.iv1.lowerlimit.GetValueOrDefault());
iv1ul = Converter.ConvertToSI(mycase.iv1.unit, mycase.iv1.upperlimit.GetValueOrDefault());
iv1np = mycase.iv1.points - 1;
iv1id = mycase.iv1.objectID;
iv1prop = mycase.iv1.propID;
flowsheet.SupressMessages = true;
Application.Instance.Invoke(() =>
{
btnAbort.Enabled = true;
btnrt.Enabled = false;
btnrc.Enabled = false;
flowsheet.ShowMessage("Starting Sensitivity Analysis, please wait...", IFlowsheet.MessageType.Information);
});
var task = new Task(() =>
{
flowsheet.SolveFlowsheet(true);
iv1val0 = Convert.ToDouble(flowsheet.SimulationObjects[iv1id].GetPropertyValue(iv1prop));
for (i = 0; i <= iv1np; i++)
{
iv1val = iv1ll + i * (iv1ul - iv1ll) / iv1np;
flowsheet.SimulationObjects[iv1id].SetPropertyValue(iv1prop, iv1val);
flowsheet.SolveFlowsheet(true);
List <double> depvarvals = new List <double>();
foreach (var depvar in mycase.depvariables.Values)
{
depvar.currentvalue = Convert.ToDouble(flowsheet.SimulationObjects[depvar.objectID].GetPropertyValue(depvar.propID));
depvarvals.Add(depvar.currentvalue);
}
results.Add(depvarvals);
}
mycase.results = new System.Collections.ArrayList();
foreach (var res in results)
{
mycase.results.Add(res.ToArray());
}
flowsheet.SimulationObjects[iv1id].SetPropertyValue(iv1prop, iv1val0);
flowsheet.SolveFlowsheet(true);
}, GlobalSettings.Settings.TaskCancellationTokenSource.Token);
task.ContinueWith((t) =>
{
flowsheet.SupressMessages = false;
if (t.Exception != null)
{
Application.Instance.Invoke(() =>
{
btnAbort.Enabled = false;
btnrt.Enabled = false;
btnrc.Enabled = false;
flowsheet.ShowMessage("Error: " + t.Exception.Message, IFlowsheet.MessageType.GeneralError);
});
}
else
{
Application.Instance.Invoke(() =>
{
btnAbort.Enabled = false;
btnrt.Enabled = true;
btnrc.Enabled = true;
flowsheet.ShowMessage("Sensitivity Analysis finished successfully.", IFlowsheet.MessageType.Information);
if (t.Status == TaskStatus.RanToCompletion)
{
var str = new System.Text.StringBuilder();
str.AppendLine("Sensitivity Analysis Run Results");
str.AppendLine();
str.AppendLine("Independent Variable: " + flowsheet.SimulationObjects[iv1id].GraphicObject.Tag + " / " + flowsheet.GetTranslatedString(mycase.iv1.propID));
str.AppendLine();
str.AppendLine("Range: " + mycase.iv1.lowerlimit.GetValueOrDefault() + " to " + mycase.iv1.upperlimit.GetValueOrDefault() + " " + mycase.iv1.unit + ", " + mycase.iv1.points + " steps");
str.AppendLine();
str.AppendLine("Dependent Variables:");
int count = 1;
str.AppendLine();
foreach (var dvar in mycase.depvariables.Values)
{
str.AppendLine(count + " - " + flowsheet.SimulationObjects[dvar.objectID].GraphicObject.Tag + " / " + flowsheet.GetTranslatedString(dvar.propID) + " (" + dvar.unit + ")");
count += 1;
}
str.AppendLine();
str.AppendLine("Ind var\t\tDep. vars");
int cnt = 0;
List <double> px = new List <double>();
List <List <double> > py = new List <List <double> >();
foreach (var dvar in mycase.depvariables.Values)
{
py.Add(new List <double>());
}
foreach (double[] res in mycase.results)
{
var dv = Converter.ConvertFromSI(mycase.iv1.unit, iv1ll + cnt * (iv1ul - iv1ll) / iv1np);
px.Add(dv);
string line = dv.ToString(nf) + "\t\t";
int j = 0;
foreach (var d in res)
{
py[j].Add(Converter.ConvertFromSI(mycase.depvariables.Values.ElementAt(j).unit, d));
line += Converter.ConvertFromSI(mycase.depvariables.Values.ElementAt(j).unit, d).ToString(nf) + "\t\t";
j += 1;
}
str.AppendLine(line);
cnt += 1;
}
Application.Instance.Invoke(() => resulttextbox.Text = str.ToString());
var model = new PlotModel()
{
Subtitle = "Sensitivity Analysis Run Results", Title = flowsheet.FlowsheetOptions.SimulationName
};
model.TitleFontSize = 14;
model.SubtitleFontSize = 11;
model.Axes.Add(new LinearAxis()
{
MajorGridlineStyle = LineStyle.Dash,
MinorGridlineStyle = LineStyle.Dot,
Position = AxisPosition.Bottom,
FontSize = 12,
Title = mycase.iv1.objectTAG + " / " + flowsheet.GetTranslatedString(mycase.iv1.propID) + " (" + mycase.iv1.unit + ")"
});
int cnt2 = 0;
foreach (var dvar in mycase.depvariables.Values)
{
model.Axes.Add(new LinearAxis()
{
MajorGridlineStyle = LineStyle.Dash,
MinorGridlineStyle = LineStyle.Dot,
FontSize = 12,
Title = dvar.objectTAG + " / " + flowsheet.GetTranslatedString(dvar.propID) + " (" + dvar.unit + ")"
});
model.Axes[cnt2 + 1].Key = cnt2.ToString();
model.Axes[cnt2 + 1].PositionTier = cnt2;
model.Axes[cnt2 + 1].AxislineStyle = LineStyle.Solid;
model.AddLineSeries(px, py[cnt2]);
model.Series[cnt2].Title = dvar.objectTAG + " / " + flowsheet.GetTranslatedString(dvar.propID);
((OxyPlot.Series.LineSeries)(model.Series[cnt2])).YAxisKey = cnt2.ToString();
cnt2 += 1;
}
model.LegendFontSize = 11;
model.LegendPlacement = LegendPlacement.Outside;
model.LegendOrientation = LegendOrientation.Vertical;
model.LegendPosition = LegendPosition.BottomCenter;
model.TitleHorizontalAlignment = TitleHorizontalAlignment.CenteredWithinView;
Application.Instance.Invoke(() => { resultschart.Model = model; resultschart.Invalidate(); });
}
});
}
});
btnAbort.Click += (sender, e) =>
{
GlobalSettings.Settings.TaskCancellationTokenSource.Cancel();
};
task.Start();
};
}
public void SetPieceToggleText(Enums.Piece piece)
{
System.Text.StringBuilder tooltip = new System.Text.StringBuilder();
switch (piece)
{
case Enums.Piece.Pawn:
//ToggleDisable();
_isPawn = true;
tooltip.Append("Pawn");
tooltip.AppendLine("No bonuses");
//PieceToggle.image.sprite = ImgPawn;
break;
case Enums.Piece.Bishop:
tooltip.Append("Bishop");
tooltip.AppendLine("OFF: Start battle with 100% mana");
tooltip.AppendLine("ON: Get 2X mana");
//PieceToggle.image.sprite = ImgBishop;
break;
case Enums.Piece.Knight:
tooltip.Append("Knight");
tooltip.AppendLine("Passive: get bonus attack speed");
tooltip.AppendLine("OFF: Transcend grand distances quickly");
tooltip.AppendLine("ON: Double the Range");
//PieceToggle.image.sprite = ImgKnight;
break;
case Enums.Piece.Rook:
tooltip.Append("Rook");
tooltip.AppendLine("Passive: get bonus attack damage");
tooltip.AppendLine("OFF: Bonus armor, magic resist and attack damage");
tooltip.AppendLine("ON: Higher bonuses but unable to cast abilities");
//PieceToggle.image.sprite = ImgRook;
break;
case Enums.Piece.Queen:
tooltip.Append("Queen");
tooltip.AppendLine("OFF: Bonus on all stats");
tooltip.AppendLine("ON: On start of the battle get shield equal to 100% of HP");
//PieceToggle.image.sprite = ImgQueen;
break;
}
//PieceToggle.GetComponent<FigureTooltip>().SetTooltip(tooltip.ToString());
}
private static void InsertIntoMOFMaklumatSyarikat()
{
using (SqlConnection Connection = SQLHelper.GetConnectionMOF())
{
try
{
SqlCommand com = new SqlCommand();
System.Text.StringBuilder sql = new System.Text.StringBuilder();
sql.AppendLine("INSERT INTO AccountCluster ");
sql.AppendLine("(");
sql.AppendLine("[CompanyName],[MSCFileID],[CoreActivities],[ROCNumber],[URL],[ACMeetingDate],[ApprovalLetterDate]");
sql.AppendLine(",[YearOfApproval],[DateofIncorporation],[OperationalStatus] ,[FinancialIncentive] ,[Cluster],[BusinessPhone]");
sql.AppendLine(",[Fax],[TaxRevenueLoss],[Tier],[SubmitDate],[MSCCertNo],[BA],[SubmitType],[SyncDate]");
sql.AppendLine(")");
sql.AppendLine("VALUES(");
sql.AppendLine("@CompanyName, @MSCFileID, @CoreActivities, @ROCNumber,@URL,@ACMeetingDate,@ApprovalLetterDate");
sql.AppendLine("@YearOfApproval, @DateofIncorporation, @OperationalStatus, @FinancialIncentive, @Cluster, @BusinessPhone");
sql.AppendLine("@Fax, @TaxRevenueLoss, @Tier, @SubmitDate, @MSCCertNo, @BA,@SubmitType,@SyncDate");
sql.AppendLine(")");
com.Parameters.Add(new SqlParameter("@CompanyName", ""));
com.Parameters.Add(new SqlParameter("@MSCFileID", ""));
com.Parameters.Add(new SqlParameter("@CoreActivities", ""));
com.Parameters.Add(new SqlParameter("@ROCNumber", ""));
com.Parameters.Add(new SqlParameter("@URL", ""));
com.Parameters.Add(new SqlParameter("@ACMeetingDate", ""));
com.Parameters.Add(new SqlParameter("@ApprovalLetterDate", ""));
com.Parameters.Add(new SqlParameter("@DateofIncorporation", ""));
com.Parameters.Add(new SqlParameter("@OperationalStatus", ""));
com.Parameters.Add(new SqlParameter("@FinancialIncentive", ""));
com.Parameters.Add(new SqlParameter("@Cluster", ""));
com.Parameters.Add(new SqlParameter("@BusinessPhone", ""));
com.Parameters.Add(new SqlParameter("@Fax", ""));
com.Parameters.Add(new SqlParameter("@TaxRevenueLoss", ""));
com.Parameters.Add(new SqlParameter("@Tier", ""));
com.Parameters.Add(new SqlParameter("@SubmitDate", ""));
com.Parameters.Add(new SqlParameter("@MSCCertNo", ""));
com.Parameters.Add(new SqlParameter("@BA", ""));
com.Parameters.Add(new SqlParameter("@SubmitType", ""));
com.Parameters.Add(new SqlParameter("@SyncDate", ""));
com.CommandText = sql.ToString();
com.CommandType = CommandType.Text;
com.Connection = Connection;
com.CommandTimeout = int.MaxValue;
com.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
