Cells(1, 1).Interior.ColorIndex = 1
jsonToString:
function jsonToString(obj){ var THIS = this; switch(typeof(obj)){ case 'string': return '"' + obj.replace(/(["\\])/g, '\\$1') + '"'; case 'array': return '[' + obj.map(THIS.jsonToString).join(',') + ']'; case 'object': if(obj instanceof Array){ var strArr = []; var len = obj.length; for(var i=0; i<len; i++){ strArr.push(THIS.jsonToString(obj[i])); } return '[' + strArr.join(',') + ']'; }else if(obj==null){ return 'null'; }else{ var string = []; for (var property in obj) string.push(THIS.jsonToString(property) + ':' + THIS.jsonToString(obj[property])); return '{' + string.join(',') + '}'; } case 'number': return obj; case false: return obj; } }
dataContext.Connection.Open();
using (datacontext.Transaction = dataContext.Connection.BeginTransaction())
{
dataContext.SubmitChanges();
if (allOK)
{
datacontext.Transaction.Commit();
}
else
{
datacontext.Transaction.RollBack();
}
}try
{
using (TransactionScope scope = new TransactionScope())
{
//Do some stuff
//Submit changes, use ConflictMode to specify what to do
context.SubmitChanges(ConflictMode.ContinueOnConflict);
scope.Complete();
}
}
catch (ChangeConflictException cce)
{
//Exception, as the scope was not completed it will rollback
}取得目前執行的函數名稱using System.Diagnostics;// get call stackStackTrace stackTrace = new System.Diagnostics.StackTrace(); // get calling method name Debug.WriteLine(stackTrace.GetFrame(1).GetMethod().Name); Debug.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name); Debug.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name);
//複製資料 Excel.Range srcRange = wsSrc.Rows[target.Row] as Excel.Range; Excel.Range destRange = wsDest.Rows[dest.Row] as Excel.Range; destRange.Value2 = srcRange.Value2;
//複製有formulas Object template = Settings.Default.TemplatePath; Excel.Workbook wb = Globals.ThisAddIn.Application.Workbooks.Add(template) as Excel.Workbook; Excel.Range r = (Excel.Range)wb.Application.ActiveCell[1, "A"]; Excel.Range oRow = r.EntireRow; oRow.Select(); oRow.Copy(); Excel.Range rg = (Excel.Range)rg[2, "A"]; rg.Select(); rg.PasteSpecial(Excel.XlPasteType.xlPasteAll, Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone, Type.Missing, Type.Missing); wb.Application.CutCopyMode = Excel.XlCutCopyMode.xlCopy;