public NuevoInsumo(CommonUtils.Insumo insumoAModificar)
{
InitializeComponent();
insumo = insumoAModificar;
CargarDatosInsumo();
CargarListaInsumos();
}
public PnlNuevaReceta(CommonUtils.Receta recetaAModificar)
{
InitializeComponent();
InitConexionDB();
this.receta = recetaAModificar;
CargarDatosDeReceta();
CargarDataGridControlListaRecetas();
}
public NuevaDosificacion( CommonUtils.Dosificacion dosificacion )
{
InitializeComponent( );
log4net.Config.XmlConfigurator.Configure( );
InitConexionDB( );
isUpdating = true;
DosificacionID = dosificacion.DosificacionID;
txtLlave.Text = dosificacion.Llave;
txtAutorizacion.Text = dosificacion.Autorizacion;
txtFactura.Text = dosificacion.NroFactura;
dateFechaLimite.Text = Convert.ToDateTime( dosificacion.FechaLimite ).ToShortDateString( );
checkBoxActiva.Checked = dosificacion.Activa == 1 ? true : false;
}
public DatosEmpresa( CommonUtils.Empresa empresa )
{
InitializeComponent( );
log4net.Config.XmlConfigurator.Configure( );
InitConexionDB( );
isUpdating = true;
txtDireccion.Text = empresa.Direccion;
txtNIT.Text = empresa.NIT;
txtNomEmpresa.Text = empresa.NombreEmpresa;
txtRazonSocial.Text = empresa.RazonSocial;
spinEdit.Text = empresa.SucursalNro.ToString( );
txtTelefono.Text = empresa.Telefono;
txtRubro.Text = empresa.Rubro;
}
private void EstimatePitch()
{
var gotPitch = false;
double?f0 = null;
while (true)
{
const int pitchWindowLength = 2048;
var rms = 0.0;
var ok = this._sampleBuffer.Read(pitchWindowLength, segment =>
{
foreach (var x in segment)
{
rms += x * x;
}
rms = Math.Sqrt(rms / pitchWindowLength);
f0 = McLeodPitchMethod.EstimateFundamentalFrequency(this._waveIn.WaveFormat.SampleRate, segment);
});
if (!ok)
{
break; // バッファーをすべて読み終わった
}
gotPitch = true;
if (f0.HasValue && this._store.IsKeyEstimationRunning)
{
// クロマベクトルに反映
var m = CommonUtils.ToChromaIndex(CommonUtils.HzToMidiNote(f0.Value));
this._chromaVector[m] += rms;
}
}
if (gotPitch)
{
this._store.EstimatedPitch = f0;
}
if (gotPitch && this._store.IsKeyEstimationRunning)
{
// キー推定
this._store.EstimatedKey = KeyFinding.FindKey(this._chromaVector);
}
if (f0.HasValue && (this._store.IsUpperHarmonyEnabled || this._store.IsLowerHarmonyEnabled))
{
var key = this._store.EstimatedKey;
if (key.HasValue)
{
var baseScale = key.Value.Mode == KeyMode.Major ? s_majorScale : s_minorScale;
var scale = new bool[12];
for (var i = 0; i < scale.Length; i++)
{
scale[i] = baseScale[(key.Value.Tonic + i) % 12];
}
var noteNum = CommonUtils.HzToMidiNote(f0.Value);
var m = CommonUtils.ToChromaIndex(noteNum);
if (scale[m])
{
// スケール内の音なら、ハモる音高を求める
if (this._store.IsUpperHarmonyEnabled)
{
// スケール内で3度上の音を探す
var harmonyNoteNum = noteNum + 1;
for (var i = 0; i < 2; harmonyNoteNum++)
{
if (scale[CommonUtils.ToChromaIndex(harmonyNoteNum)])
{
i++;
}
}
var freq = CommonUtils.MidiNoteToHz(harmonyNoteNum);
this._upperHarmonyPlayer.SetPitchFactor((float)(freq / f0.Value));
}
if (this._store.IsLowerHarmonyEnabled)
{
// スケール内で3度下の音を探す
var harmonyNoteNum = noteNum - 1;
for (var i = 0; i < 2; harmonyNoteNum--)
{
if (scale[CommonUtils.ToChromaIndex(harmonyNoteNum)])
{
i++;
}
}
var freq = CommonUtils.MidiNoteToHz(harmonyNoteNum);
this._upperHarmonyPlayer.SetPitchFactor((float)(freq / f0.Value));
}
}
}
}
}
public SqlServerInsertOrUpdate(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression)
: base(orm, commonUtils, commonExpression)
{
}
/// <summary>
/// Updates the expiration date and time for an existing ticket. If the ticket does not exist in the ticket store, just return (do not throw an exception).
/// </summary>
/// <param name="casAuthenticationTicket">The CasAuthenticationTicket to insert</param>
/// <param name="newExpiration">The new expiration date and time</param>
/// <exception cref="ArgumentNullException">casAuthenticationTicket is null</exception>
public void UpdateTicketExpiration(CasAuthenticationTicket casAuthenticationTicket, DateTime newExpiration)
{
CommonUtils.AssertNotNull(casAuthenticationTicket, "casAuthenticationTicket parameter cannot be null.");
InsertTicket(casAuthenticationTicket, newExpiration);
}
public PostgreSQLSelect(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression, object dywhere) : base(orm, commonUtils, commonExpression, dywhere)
{
}
public async Task <AuthenticateResponse> Authenticate(string token)
{
// Internal auth does not support token auth
if (_appSettings.ExternalAuthUrl == null)
{
return(null);
}
var res = await _loginManager.CheckAccess(token);
if (!res.Success)
{
return(null);
}
// Create user if not exists because login manager has greenlighed us
var user = await _userManager.FindByNameAsync(res.UserName) ??
await CreateUserInternal(new User { UserName = res.UserName }, CommonUtils.RandomString(16));
if (!user.Metadata.IsSameAs(res.Metadata))
{
user.Metadata = res.Metadata;
await _applicationDbContext.SaveChangesAsync();
}
await SyncRoles(user);
// authentication successful so generate jwt token
var tokenDescriptor = await GenerateJwtToken(user);
return(new AuthenticateResponse(user, tokenDescriptor.Token, tokenDescriptor.ExpiresOn));
}
internal static string ToSqlStatic(CommonUtils _commonUtils, CommonExpression _commonExpression, string _select, bool _distinct, string field, StringBuilder _join, StringBuilder _where, string _groupby, string _having, string _orderby, int _skip, int _limit, List <SelectTableInfo> _tables, List <Dictionary <Type, string> > tbUnions, Func <Type, string, string> _aliasRule, string _tosqlAppendContent, List <GlobalFilter.Item> _whereGlobalFilter, IFreeSql _orm)
{
if (_orm.CodeFirst.IsAutoSyncStructure)
{
_orm.CodeFirst.SyncStructure(_tables.Select(a => a.Table.Type).ToArray());
}
if (_whereGlobalFilter.Any())
{
foreach (var tb in _tables.Where(a => a.Type != SelectTableInfoType.Parent))
{
tb.Cascade = _commonExpression.GetWhereCascadeSql(tb, _whereGlobalFilter, true);
}
}
var sb = new StringBuilder();
var tbUnionsGt0 = tbUnions.Count > 1;
for (var tbUnionsIdx = 0; tbUnionsIdx < tbUnions.Count; tbUnionsIdx++)
{
if (tbUnionsIdx > 0)
{
sb.Append("\r\n \r\nUNION ALL\r\n \r\n");
}
if (tbUnionsGt0)
{
sb.Append(_select).Append(" * from (");
}
var tbUnion = tbUnions[tbUnionsIdx];
var sbnav = new StringBuilder();
sb.Append(_select);
if (_distinct)
{
sb.Append("DISTINCT ");
}
sb.Append(field);
if (string.IsNullOrEmpty(_orderby) && _skip > 0)
{
sb.Append(", ROWNUM AS \"__rownum__\"");
}
sb.Append(" \r\nFROM ");
var tbsjoin = _tables.Where(a => a.Type != SelectTableInfoType.From).ToArray();
var tbsfrom = _tables.Where(a => a.Type == SelectTableInfoType.From).ToArray();
for (var a = 0; a < tbsfrom.Length; a++)
{
sb.Append(_commonUtils.QuoteSqlName(tbUnion[tbsfrom[a].Table.Type])).Append(" ").Append(_aliasRule?.Invoke(tbsfrom[a].Table.Type, tbsfrom[a].Alias) ?? tbsfrom[a].Alias);
if (tbsjoin.Length > 0)
{
//如果存在 join 查询，则处理 from t1, t2 改为 from t1 inner join t2 on 1 = 1
for (var b = 1; b < tbsfrom.Length; b++)
{
sb.Append(" \r\nLEFT JOIN ").Append(_commonUtils.QuoteSqlName(tbUnion[tbsfrom[b].Table.Type])).Append(" ").Append(_aliasRule?.Invoke(tbsfrom[b].Table.Type, tbsfrom[b].Alias) ?? tbsfrom[b].Alias);
if (string.IsNullOrEmpty(tbsfrom[b].NavigateCondition) && string.IsNullOrEmpty(tbsfrom[b].On) && string.IsNullOrEmpty(tbsfrom[b].Cascade))
{
sb.Append(" ON 1 = 1");
}
else
{
var onSql = tbsfrom[b].NavigateCondition ?? tbsfrom[b].On;
sb.Append(" ON ").Append(onSql);
if (string.IsNullOrEmpty(tbsfrom[b].Cascade) == false)
{
if (string.IsNullOrEmpty(onSql))
{
sb.Append(tbsfrom[b].Cascade);
}
else
{
sb.Append(" AND ").Append(tbsfrom[b].Cascade);
}
}
}
}
break;
}
else
{
if (!string.IsNullOrEmpty(tbsfrom[a].NavigateCondition))
{
sbnav.Append(" AND (").Append(tbsfrom[a].NavigateCondition).Append(")");
}
if (!string.IsNullOrEmpty(tbsfrom[a].On))
{
sbnav.Append(" AND (").Append(tbsfrom[a].On).Append(")");
}
if (a > 0 && !string.IsNullOrEmpty(tbsfrom[a].Cascade))
{
sbnav.Append(" AND ").Append(tbsfrom[a].Cascade);
}
}
if (a < tbsfrom.Length - 1)
{
sb.Append(", ");
}
}
foreach (var tb in tbsjoin)
{
if (tb.Type == SelectTableInfoType.Parent)
{
continue;
}
switch (tb.Type)
{
case SelectTableInfoType.LeftJoin:
sb.Append(" \r\nLEFT JOIN ");
break;
case SelectTableInfoType.InnerJoin:
sb.Append(" \r\nINNER JOIN ");
break;
case SelectTableInfoType.RightJoin:
sb.Append(" \r\nRIGHT JOIN ");
break;
}
sb.Append(_commonUtils.QuoteSqlName(tbUnion[tb.Table.Type])).Append(" ").Append(_aliasRule?.Invoke(tb.Table.Type, tb.Alias) ?? tb.Alias).Append(" ON ").Append(tb.On ?? tb.NavigateCondition);
if (!string.IsNullOrEmpty(tb.Cascade))
{
sb.Append(" AND ").Append(tb.Cascade);
}
if (!string.IsNullOrEmpty(tb.On) && !string.IsNullOrEmpty(tb.NavigateCondition))
{
sbnav.Append(" AND (").Append(tb.NavigateCondition).Append(")");
}
}
if (_join.Length > 0)
{
sb.Append(_join);
}
sbnav.Append(_where);
if (!string.IsNullOrEmpty(_tables[0].Cascade))
{
sbnav.Append(" AND ").Append(_tables[0].Cascade);
}
if (string.IsNullOrEmpty(_orderby) && (_skip > 0 || _limit > 0))
{
sbnav.Append(" AND ROWNUM < ").Append(_skip + _limit + 1);
}
if (sbnav.Length > 0)
{
sb.Append(" \r\nWHERE ").Append(sbnav.Remove(0, 5));
}
if (string.IsNullOrEmpty(_groupby) == false)
{
sb.Append(_groupby);
if (string.IsNullOrEmpty(_having) == false)
{
sb.Append(" \r\nHAVING ").Append(_having.Substring(5));
}
}
sb.Append(_orderby);
if (string.IsNullOrEmpty(_orderby))
{
if (_skip > 0)
{
sb.Insert(0, $"{_select} t.* FROM (").Append(") t WHERE t.\"__rownum__\" > ").Append(_skip);
}
}
else
{
if (_skip > 0 && _limit > 0)
{
sb.Insert(0, $"{_select} t.* FROM (SELECT rt.*, ROWNUM AS \"__rownum__\" FROM (").Append(") rt WHERE ROWNUM < ").Append(_skip + _limit + 1).Append(") t WHERE t.\"__rownum__\" > ").Append(_skip);
}
else if (_skip > 0)
{
sb.Insert(0, $"{_select} t.* FROM (").Append(") t WHERE ROWNUM > ").Append(_skip);
}
else if (_limit > 0)
{
sb.Insert(0, $"{_select} t.* FROM (").Append(") t WHERE ROWNUM < ").Append(_limit + 1);
}
}
sbnav.Clear();
if (tbUnionsGt0)
{
sb.Append(") ftb");
}
}
return(sb.Append(_tosqlAppendContent).ToString());
}
//categoria 5 es para combo
private bool esPosibleBorrarReceta(CommonUtils.Receta recipe)
{
//string sqlQuery="select RecetaId from Producto where ProductoId in (Select ProductoId from Producto_Producto where ComboId=12) "
string sqlQuery="select RecetaId from Receta where RecetaId="+recipe.idReceta+" and RecetaId in (select RecetaId from Producto where CategoriaId!=5)";
if (CommonUtils.ConexionBD.EjecutarConsulta(sqlQuery).Rows.Count > 0)
{
return false;
}
sqlQuery = "Select RecetaId from Producto where RecetaId="+recipe.idReceta+" and ProductoId in( Select ProductoId from Producto_Producto where ComboId in (Select ProductoId from Producto where CategoriaId=5))";
if (CommonUtils.ConexionBD.EjecutarConsulta(sqlQuery).Rows.Count > 0)
{
return false;
}
return true;
}
public void Test()
{
var expectedMetrics = new List <Assertions.ExpectedMetric>
{
//transactions
new Assertions.ExpectedMetric {
metricName = @"WebTransaction/MVC/Home/Index", callCount = 1
},
new Assertions.ExpectedMetric {
metricName = @"WebTransaction/Custom/MyCustomChangeMetricName", callCount = 1
},
new Assertions.ExpectedMetric {
metricName = @"WebTransaction/Custom/MyCustomRenamedMetricName", callCount = 1
},
// Unscoped
new Assertions.ExpectedMetric {
metricName = @"DotNet/HomeController/Index", callCount = 1
},
new Assertions.ExpectedMetric {
metricName = @"Custom/MyCustomChangeMetricName", callCount = 1
},
new Assertions.ExpectedMetric {
metricName = @"Custom/MyCustomRenamedMetricName", callCount = 1
},
new Assertions.ExpectedMetric {
metricName = @"DotNet/RejitController/GetChangeAttributeValue", callCount = 2
},
// Scoped
new Assertions.ExpectedMetric {
metricName = @"DotNet/HomeController/Index", metricScope = "WebTransaction/MVC/Home/Index", callCount = 1
},
new Assertions.ExpectedMetric {
metricName = @"Custom/MyCustomChangeMetricName", metricScope = "WebTransaction/Custom/MyCustomChangeMetricName", callCount = 1
},
new Assertions.ExpectedMetric {
metricName = @"Custom/MyCustomRenamedMetricName", metricScope = "WebTransaction/Custom/MyCustomRenamedMetricName", callCount = 1
}
};
var notExpectedMetrics = new List <Assertions.ExpectedMetric>
{
//transactions
new Assertions.ExpectedMetric {
metricName = @"WebTransaction/MVC/Rejit/GetChangeAttributeValue"
},
// Scoped
new Assertions.ExpectedMetric {
metricName = @"DotNet/RejitController/GetChangeAttributeValue", metricScope = "WebTransaction/MVC/Rejit/GetChangeAttributeValue"
}
};
var metrics = CommonUtils.GetMetrics(_fixture.AgentLog);
_fixture.TestLogger?.WriteLine(_fixture.AgentLog.GetFullLogAsString());
NrAssert.Multiple(
() => Assertions.MetricsExist(expectedMetrics, metrics),
() => Assertions.MetricsDoNotExist(notExpectedMetrics, metrics)
);
}
// cli argument processor
private static void ProcessArguments()
{
if (IsHelpUsagePatternMode)
{
Console.WriteLine(UsagePatterns.Replace("\t", " "));
}
else if (IsVersionMode)
{
PyRevitCLIAppCmds.PrintVersion(checkUpdates: true);
}
else if (all("wiki"))
{
CommonUtils.OpenUrl(PyRevitLabsConsts.WikiUrl);
}
else if (all("blog"))
{
CommonUtils.OpenUrl(PyRevitLabsConsts.BlogsUrl);
}
else if (all("docs"))
{
CommonUtils.OpenUrl(PyRevitLabsConsts.DocsUrl);
}
else if (all("source"))
{
CommonUtils.OpenUrl(PyRevitLabsConsts.SourceRepoUrl);
}
else if (all("youtube"))
{
CommonUtils.OpenUrl(PyRevitLabsConsts.YoutubeUrl);
}
else if (all("support"))
{
CommonUtils.OpenUrl(PyRevitLabsConsts.SupportUrl);
}
else if (all("env"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Env);
}
else
{
PyRevitCLIAppCmds.MakeEnvReport(json: arguments["--json"].IsTrue);
}
}
else if (all("update") && !any("clones", "extensions"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Update);
}
else
{
PyRevitCLIAppCmds.UpdateRemoteDataSources();
}
}
else if (all("clone"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Clone);
}
else
{
PyRevitCLICloneCmds.CreateClone(
cloneName: TryGetValue("<clone_name>"),
deployName: TryGetValue("<deployment_name>"),
branchName: TryGetValue("--branch"),
repoUrl: TryGetValue("--source"),
imagePath: TryGetValue("--image"),
destPath: TryGetValue("--dest"),
credentials: TryGetCredentials()
);
}
}
else if (all("clones"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Clones);
}
else if (all("info"))
{
PyRevitCLICloneCmds.PrintCloneInfo(TryGetValue("<clone_name>"));
}
else if (all("open"))
{
PyRevitCLICloneCmds.OpenClone(TryGetValue("<clone_name>"));
}
else if (all("add"))
{
if (all("this"))
{
PyRevitCLICloneCmds.RegisterClone(
TryGetValue("<clone_name>"),
Path.GetDirectoryName(CLIPath),
force: arguments["--force"].IsTrue
);
}
else
{
PyRevitCLICloneCmds.RegisterClone(
TryGetValue("<clone_name>"),
TryGetValue("<clone_path>"),
force: arguments["--force"].IsTrue
);
}
}
else if (all("forget"))
{
PyRevitCLICloneCmds.ForgetClone(
allClones: arguments["--all"].IsTrue,
cloneName: TryGetValue("<clone_name>")
);
}
else if (all("rename"))
{
PyRevitCLICloneCmds.RenameClone(
cloneName: TryGetValue("<clone_name>"),
cloneNewName: TryGetValue("<clone_new_name>")
);
}
else if (all("delete"))
{
PyRevitCLICloneCmds.DeleteClone(
allClones: arguments["--all"].IsTrue,
cloneName: TryGetValue("<clone_name>"),
clearConfigs: arguments["--clearconfigs"].IsTrue
);
}
else if (all("branch"))
{
PyRevitCLICloneCmds.GetSetCloneBranch(
cloneName: TryGetValue("<clone_name>"),
branchName: TryGetValue("<branch_name>")
);
}
else if (all("version"))
{
PyRevitCLICloneCmds.GetSetCloneTag(
cloneName: TryGetValue("<clone_name>"),
tagName: TryGetValue("<tag_name>")
);
}
else if (all("commit"))
{
PyRevitCLICloneCmds.GetSetCloneCommit(
cloneName: TryGetValue("<clone_name>"),
commitHash: TryGetValue("<commit_hash>")
);
}
else if (all("origin"))
{
PyRevitCLICloneCmds.GetSetCloneOrigin(
cloneName: TryGetValue("<clone_name>"),
originUrl: TryGetValue("<origin_url>"),
reset: arguments["--reset"].IsTrue
);
}
else if (all("deployments"))
{
PyRevitCLICloneCmds.PrintCloneDeployments(TryGetValue("<clone_name>"));
}
else if (all("engines"))
{
PyRevitCLICloneCmds.PrintCloneEngines(TryGetValue("<clone_name>"));
}
else if (all("update"))
{
PyRevitCLICloneCmds.UpdateClone(
allClones: arguments["--all"].IsTrue,
cloneName: TryGetValue("<clone_name>"),
credentials: TryGetCredentials()
);
}
else
{
PyRevitCLICloneCmds.PrintClones();
}
}
else if (all("attach"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Attach);
}
else
{
// get clone
var clone = PyRevitClones.GetRegisteredClone(TryGetValue("<clone_name>"));
// determine version
var engStrVer = TryGetValue("<engine_version>");
PyRevitEngineVersion engineVersion = null;
if (arguments["default"].IsTrue)
{
engineVersion = PyRevitEngineVersion.Default;
}
else
{
// try parse the engine version as an integer e.g. 277 for 2.7.7
if (int.TryParse(engStrVer, out var engIntVer))
{
engineVersion = (PyRevitEngineVersion)engIntVer;
}
}
if (engineVersion is null)
{
// then engine must be an engine id
PyRevitCLICloneCmds.AttachClone(
clone: clone,
engineId: engStrVer,
revitYear: TryGetValue("<revit_year>"),
installed: arguments["--installed"].IsTrue,
attached: arguments["--attached"].IsTrue,
allUsers: arguments["--allusers"].IsTrue
);
}
else
{
PyRevitCLICloneCmds.AttachClone(
clone: clone,
engineVersion: engineVersion,
revitYear: TryGetValue("<revit_year>"),
installed: arguments["--installed"].IsTrue,
attached: arguments["--attached"].IsTrue,
allUsers: arguments["--allusers"].IsTrue
);
}
}
}
else if (all("detach"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Detach);
}
else
{
PyRevitCLICloneCmds.DetachClone(
revitYear: TryGetValue("<revit_year>"),
all: arguments["--all"].IsTrue,
currentAndAllUsers: true
);
}
}
else if (all("attached"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Attached);
}
else
{
PyRevitCLICloneCmds.ListAttachments(revitYear: TryGetValue("<revit_year>"));
}
}
else if (all("switch"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Switch);
}
else
{
PyRevitCLICloneCmds.SwitchAttachment(
cloneName: TryGetValue("<clone_name>"),
revitYear: TryGetValue("<revit_year>")
);
}
}
else if (all("extend"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Extend);
}
else if (any("ui", "lib"))
{
PyRevitCLIExtensionCmds.Extend(
ui: arguments["ui"].IsTrue,
lib: arguments["lib"].IsTrue,
extName: TryGetValue("<extension_name>"),
destPath: TryGetValue("--dest"),
repoUrl: TryGetValue("<repo_url>"),
branchName: TryGetValue("--branch"),
credentials: TryGetCredentials()
);
}
else
{
PyRevitCLIExtensionCmds.Extend(
extName: TryGetValue("<extension_name>"),
destPath: TryGetValue("--dest"),
branchName: TryGetValue("--branch")
);
}
}
else if (all("extensions"))
{
if (all("search"))
{
PyRevitCLIExtensionCmds.PrintExtensionDefinitions(
searchPattern: TryGetValue("<search_pattern>"),
headerPrefix: "Matched"
);
}
else if (any("info", "help"))
{
PyRevitCLIExtensionCmds.ProcessExtensionInfoCommands(
extName: TryGetValue("<extension_name>"),
info: arguments["info"].IsTrue,
help: arguments["help"].IsTrue
);
}
else if (all("open"))
{
PyRevitCLIExtensionCmds.ProcessExtensionOpenCommand(
cloneName: TryGetValue("<clone_name>"),
extName: TryGetValue("<extension_name>")
);
}
else if (all("delete"))
{
PyRevitCLIExtensionCmds.DeleteExtension(TryGetValue("<extension_name>"));
}
else if (all("origin"))
{
PyRevitCLIExtensionCmds.GetSetExtensionOrigin(
extName: TryGetValue("<extension_name>"),
originUrl: TryGetValue("<origin_url>"),
reset: arguments["--reset"].IsTrue
);
}
else if (all("paths"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.ExtensionsPaths);
}
else if (all("add"))
{
PyRevitCLIExtensionCmds.AddExtensionPath(
searchPath: TryGetValue("<extensions_path>")
);
}
else if (all("forget"))
{
PyRevitCLIExtensionCmds.ForgetAllExtensionPaths(
all: arguments["--all"].IsTrue,
searchPath: TryGetValue("<extensions_path>")
);
}
else
{
PyRevitCLIExtensionCmds.PrintExtensionSearchPaths();
}
}
else if (any("enable", "disable"))
{
PyRevitCLIExtensionCmds.ToggleExtension(
enable: arguments["enable"].IsTrue,
cloneName: TryGetValue("<clone_name>"),
extName: TryGetValue("<extension_name>")
);
}
else if (all("sources"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.ExtensionsSources);
}
else if (all("add"))
{
PyRevitCLIExtensionCmds.AddExtensionLookupSource(
lookupPath: TryGetValue("<source_json_or_url>")
);
}
else if (all("forget"))
{
PyRevitCLIExtensionCmds.ForgetExtensionLookupSources(
all: arguments["--all"].IsTrue,
lookupPath: TryGetValue("<source_json_or_url>")
);
}
else
{
PyRevitCLIExtensionCmds.PrintExtensionLookupSources();
}
}
else if (all("update"))
{
PyRevitCLIExtensionCmds.UpdateExtension(
all: arguments["--all"].IsTrue,
extName: TryGetValue("<extension_name>"),
credentials: TryGetCredentials()
);
}
else if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Extensions);
}
else
{
PyRevitCLIExtensionCmds.PrintExtensions();
}
}
else if (all("releases"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Releases);
}
else if (all("open"))
{
PyRevitCLIReleaseCmds.OpenReleasePage(
searchPattern: TryGetValue("<search_pattern>"),
latest: arguments["latest"].IsTrue,
listPreReleases: arguments["--pre"].IsTrue
);
}
else if (all("download"))
{
PyRevitCLIReleaseCmds.DownloadReleaseAsset(
arguments["archive"].IsTrue ? GithubReleaseAssetType.Archive : GithubReleaseAssetType.Installer,
destPath: TryGetValue("--dest"),
searchPattern: TryGetValue("<search_pattern>"),
latest: arguments["latest"].IsTrue,
listPreReleases: arguments["--pre"].IsTrue
);
}
else
{
PyRevitCLIReleaseCmds.PrintReleases(
searchPattern: TryGetValue("<search_pattern>"),
latest: arguments["latest"].IsTrue,
printReleaseNotes: arguments["--notes"].IsTrue,
listPreReleases: arguments["--pre"].IsTrue
);
}
}
else if (all("revits"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Revits);
}
else if (all("killall"))
{
PyRevitCLIRevitCmds.KillAllRevits(
revitYear: TryGetValue("<revit_year>")
);
}
else if (all("fileinfo"))
{
PyRevitCLIRevitCmds.ProcessFileInfo(
targetPath: TryGetValue("<file_or_dir_path>"),
outputCSV: TryGetValue("--csv"),
IncludeRVT: arguments["--rvt"].IsTrue,
includeRTE: arguments["--rte"].IsTrue,
includeRFA: arguments["--rfa"].IsTrue,
includeRFT: arguments["--rft"].IsTrue
);
}
else if (arguments["--supported"].IsTrue)
{
PyRevitCLIRevitCmds.ProcessBuildInfo(
outputCSV: TryGetValue("--csv")
);
}
else
{
PyRevitCLIRevitCmds.PrintLocalRevits(running: arguments["--installed"].IsFalse);
}
}
else if (all("run"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Run);
}
else if (all("commands"))
{
PyRevitCLIRevitCmds.ListAvailableCommands();
}
else
{
var modelList = TryGetValue("--models");
if (modelList != null)
{
PyRevitCLIRevitCmds.RunExtensionCommand(
commandName: TryGetValue("<script_or_command_name>"),
targetFile: modelList,
revitYear: TryGetValue("--revit"),
runOptions: new PyRevitRunnerOptions()
{
PurgeTempFiles = arguments["--purge"].IsTrue,
ImportPath = TryGetValue("--import", null),
AllowDialogs = arguments["--allowdialogs"].IsTrue
},
targetIsFileList: true
);
}
else
{
PyRevitCLIRevitCmds.RunExtensionCommand(
commandName: TryGetValue("<script_or_command_name>"),
targetFile: TryGetValue("<model_file>"),
revitYear: TryGetValue("--revit"),
runOptions: new PyRevitRunnerOptions()
{
PurgeTempFiles = arguments["--purge"].IsTrue,
ImportPath = TryGetValue("--import", null),
AllowDialogs = arguments["--allowdialogs"].IsTrue
}
);
}
}
}
else if (all("caches"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Caches);
}
else if (all("bim360", "clear"))
{
PyRevitCLIAppCmds.ClearCaches(
allCaches: arguments["--all"].IsTrue,
revitYear: TryGetValue("<revit_year>"),
cachetype: TargetCacheType.BIM360Cache
);
}
else if (all("clear"))
{
PyRevitCLIAppCmds.ClearCaches(
allCaches: arguments["--all"].IsTrue,
revitYear: TryGetValue("<revit_year>"),
cachetype: TargetCacheType.PyRevitCache
);
}
}
else if (all("config"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Config);
}
else
{
PyRevitCLIConfigCmds.SeedConfigs(
templateConfigFilePath: TryGetValue("--from")
);
}
}
else if (all("configs"))
{
if (IsHelpMode)
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Configs);
}
else if (all("bincache"))
{
if (any("enable", "disable"))
{
PyRevitConfigs.SetBinaryCaches(arguments["enable"].IsTrue);
}
else
{
Console.WriteLine(string.Format("Binary cache is {0}",
PyRevitConfigs.GetBinaryCaches() ? "Enabled" : "Disabled"));
}
}
else if (all("checkupdates"))
{
if (any("enable", "disable"))
{
PyRevitConfigs.SetCheckUpdates(arguments["enable"].IsTrue);
}
else
{
Console.WriteLine(string.Format("Check Updates is {0}",
PyRevitConfigs.GetCheckUpdates() ? "Enabled" : "Disabled"));
}
}
else if (all("autoupdate"))
{
if (any("enable", "disable"))
{
PyRevitConfigs.SetAutoUpdate(arguments["enable"].IsTrue);
}
else
{
Console.WriteLine(string.Format("Auto Update is {0}",
PyRevitConfigs.GetAutoUpdate() ? "Enabled" : "Disabled"));
}
}
else if (all("rocketmode"))
{
if (any("enable", "disable"))
{
PyRevitConfigs.SetRocketMode(arguments["enable"].IsTrue);
}
else
{
Console.WriteLine(string.Format("Rocket Mode is {0}",
PyRevitConfigs.GetRocketMode() ? "Enabled" : "Disabled"));
}
}
else if (all("logs"))
{
if (all("none"))
{
PyRevitConfigs.SetLoggingLevel(PyRevitLogLevels.Quiet);
}
else if (all("verbose"))
{
PyRevitConfigs.SetLoggingLevel(PyRevitLogLevels.Verbose);
}
else if (all("debug"))
{
PyRevitConfigs.SetLoggingLevel(PyRevitLogLevels.Debug);
}
else
{
Console.WriteLine(string.Format("Logging Level is {0}", PyRevitConfigs.GetLoggingLevel().ToString()));
}
}
else if (all("filelogging"))
{
if (any("enable", "disable"))
{
PyRevitConfigs.SetFileLogging(arguments["enable"].IsTrue);
}
else
{
Console.WriteLine(string.Format("File Logging is {0}",
PyRevitConfigs.GetFileLogging() ? "Enabled" : "Disabled"));
}
}
else if (all("startuptimeout"))
{
if (arguments["<timeout>"] is null)
{
Console.WriteLine(string.Format("Startup log timeout is set to: {0}",
PyRevitConfigs.GetStartupLogTimeout()));
}
else
{
PyRevitConfigs.SetStartupLogTimeout(int.Parse(TryGetValue("<timeout>")));
}
}
else if (all("loadbeta"))
{
if (any("enable", "disable"))
{
PyRevitConfigs.SetLoadBetaTools(arguments["enable"].IsTrue);
}
else
{
Console.WriteLine(string.Format("Load Beta is {0}",
PyRevitConfigs.GetLoadBetaTools() ? "Enabled" : "Disabled"));
}
}
else if (all("cpyversion"))
{
if (arguments["<cpy_version>"] is null)
{
Console.WriteLine(string.Format("CPython version is set to: {0}",
PyRevitConfigs.GetCpythonEngineVersion()));
}
else
{
PyRevitConfigs.SetCpythonEngineVersion(int.Parse(TryGetValue("<cpy_version>")));
}
}
else if (all("usercanupdate"))
{
if (any("yes", "no"))
{
PyRevitConfigs.SetUserCanUpdate(arguments["yes"].IsTrue);
}
else
{
Console.WriteLine(string.Format("User {0} update",
PyRevitConfigs.GetUserCanUpdate() ? "CAN" : "CAN NOT"));
}
}
else if (all("usercanextend"))
{
if (any("yes", "no"))
{
PyRevitConfigs.SetUserCanExtend(arguments["yes"].IsTrue);
}
else
{
Console.WriteLine(string.Format("User {0} extend",
PyRevitConfigs.GetUserCanExtend() ? "CAN" : "CAN NOT"));
}
}
else if (all("usercanconfig"))
{
if (any("yes", "no"))
{
PyRevitConfigs.SetUserCanConfig(arguments["yes"].IsTrue);
}
else
{
Console.WriteLine(string.Format("User {0} config",
PyRevitConfigs.GetUserCanConfig() ? "CAN" : "CAN NOT"));
}
}
else if (all("colordocs"))
{
if (any("enable", "disable"))
{
PyRevitConfigs.SetColorizeDocs(arguments["enable"].IsTrue);
}
else
{
Console.WriteLine(string.Format("Doc Colorizer is {0}",
PyRevitConfigs.GetColorizeDocs() ? "Enabled" : "Disabled"));
}
}
else if (all("tooltipdebuginfo"))
{
if (any("enable", "disable"))
{
PyRevitConfigs.SetAppendTooltipEx(arguments["enable"].IsTrue);
}
else
{
Console.WriteLine(string.Format("Doc Colorizer is {0}",
PyRevitConfigs.GetAppendTooltipEx() ? "Enabled" : "Disabled"));
}
}
else if (all("routes"))
{
if (all("port"))
{
var portNumber = TryGetValue("<port_number>");
if (portNumber is null)
{
Console.WriteLine(string.Format("Routes Port: {0}", PyRevitConfigs.GetRoutesServerPort()));
}
else
{
PyRevitConfigs.SetRoutesServerPort(int.Parse(portNumber));
}
}
else if (all("coreapi"))
{
if (all("enable"))
{
PyRevitConfigs.SetRoutesLoadCoreAPIStatus(true);
}
else if (all("disable"))
{
PyRevitConfigs.SetRoutesLoadCoreAPIStatus(false);
}
else
{
Console.WriteLine(string.Format("Routes Core API is {0}",
PyRevitConfigs.GetRoutesLoadCoreAPIStatus() ? "Enabled" : "Disabled"));
}
}
else if (all("enable"))
{
PyRevitConfigs.EnableRoutesServer();
}
else if (all("disable"))
{
PyRevitConfigs.DisableRoutesServer();
}
else
{
Console.WriteLine(string.Format("Routes Server is {0}",
PyRevitConfigs.GetRoutesServerStatus() ? "Enabled" : "Disabled"));
}
}
else if (all("telemetry"))
{
if (all("utc"))
{
if (any("yes", "no"))
{
PyRevitConfigs.SetUTCStamps(arguments["yes"].IsTrue);
}
else
{
Console.WriteLine(PyRevitConfigs.GetUTCStamps() ? "Using UTC timestamps" : "Using Local timestamps");
}
}
else if (all("file"))
{
var destPath = TryGetValue("<dest_path>");
if (destPath is null)
{
Console.WriteLine(string.Format("Telemetry File Path: {0}", PyRevitConfigs.GetAppTelemetryFlags()));
}
else
{
PyRevitConfigs.EnableTelemetry(telemetryFileDir: destPath);
}
}
else if (all("server"))
{
var serverUrl = TryGetValue("<dest_path>");
if (serverUrl is null)
{
Console.WriteLine(string.Format("Telemetry Server Url: {0}", PyRevitConfigs.GetAppTelemetryFlags()));
}
else
{
PyRevitConfigs.EnableTelemetry(telemetryServerUrl: serverUrl);
}
}
else if (all("hooks"))
{
if (any("yes", "no"))
{
PyRevitConfigs.SetTelemetryIncludeHooks(arguments["yes"].IsTrue);
}
else
{
Console.WriteLine(PyRevitConfigs.GetTelemetryIncludeHooks() ? "Sending telemetry for hooks" : "Not sending telemetry for hooks");
}
}
else if (all("enable"))
{
PyRevitConfigs.EnableTelemetry();
}
else if (all("disable"))
{
PyRevitConfigs.DisableTelemetry();
}
else
{
Console.WriteLine(string.Format("Telemetry is {0}",
PyRevitConfigs.GetTelemetryStatus() ? "Enabled" : "Disabled"));
Console.WriteLine(string.Format("File Path: {0}", PyRevitConfigs.GetTelemetryFilePath()));
Console.WriteLine(string.Format("Server Url: {0}", PyRevitConfigs.GetTelemetryServerUrl()));
}
}
else if (all("apptelemetry"))
{
if (all("flags"))
{
var flagsValue = TryGetValue("<flags>");
if (flagsValue is null)
{
Console.WriteLine(string.Format("App Telemetry Flags: {0}", PyRevitConfigs.GetAppTelemetryFlags()));
}
else
{
PyRevitConfigs.SetAppTelemetryFlags(flags: flagsValue);
}
}
else if (all("server"))
{
var serverPath = TryGetValue("<server_path>");
if (serverPath is null)
{
Console.WriteLine(string.Format("App Telemetry Server: {0}", PyRevitConfigs.GetAppTelemetryServerUrl()));
}
else
{
PyRevitConfigs.EnableAppTelemetry(apptelemetryServerUrl: serverPath);
}
}
else if (all("enable"))
{
PyRevitConfigs.EnableAppTelemetry();
}
else if (all("disable"))
{
PyRevitConfigs.DisableAppTelemetry();
}
else
{
Console.WriteLine(string.Format("App Telemetry is {0}",
PyRevitConfigs.GetAppTelemetryStatus() ? "Enabled" : "Disabled"));
Console.WriteLine(string.Format("Server Url: {0}", PyRevitConfigs.GetAppTelemetryServerUrl()));
Console.WriteLine(string.Format("App Telemetry flag is {0}",
PyRevitConfigs.GetAppTelemetryFlags()));
}
}
else if (all("outputcss"))
{
if (arguments["<css_path>"] is null)
{
Console.WriteLine(string.Format("Output Style Sheet is set to: {0}",
PyRevitConfigs.GetOutputStyleSheet()));
}
else
{
PyRevitConfigs.SetOutputStyleSheet(TryGetValue("<css_path>"));
}
}
else if (all("seed"))
{
PyRevitConfigs.SeedConfig(makeCurrentUserAsOwner: arguments["--lock"].IsTrue);
}
else if (any("enable", "disable"))
{
if (arguments["<option_path>"] != null)
{
// extract section and option names
string orignalOptionValue = TryGetValue("<option_path>");
if (orignalOptionValue.Split(':').Count() == 2)
{
string configSection = orignalOptionValue.Split(':')[0];
string configOption = orignalOptionValue.Split(':')[1];
var cfg = PyRevitConfigs.GetConfigFile();
cfg.SetValue(configSection, configOption, arguments["enable"].IsTrue);
}
else
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Main);
}
}
}
else
{
if (arguments["<option_path>"] != null)
{
// extract section and option names
string orignalOptionValue = TryGetValue("<option_path>");
if (orignalOptionValue.Split(':').Count() == 2)
{
string configSection = orignalOptionValue.Split(':')[0];
string configOption = orignalOptionValue.Split(':')[1];
var cfg = PyRevitConfigs.GetConfigFile();
// if no value provided, read the value
var optValue = TryGetValue("<option_value>");
if (optValue != null)
{
cfg.SetValue(configSection, configOption, optValue);
}
else if (optValue is null)
{
var existingVal = cfg.GetValue(configSection, configOption);
if (existingVal != null)
{
Console.WriteLine(string.Format("{0} = {1}", configOption, existingVal));
}
else
{
Console.WriteLine(string.Format("Configuration key \"{0}\" is not set", configOption));
}
}
}
else
{
PyRevitCLIAppHelps.PrintHelp(PyRevitCLICommandType.Main);
}
}
}
}
else if (all("doctor"))
{
if (IsHelpMode)
{
PyRevitCLIAppCmds.RunDoctor("--wrappedhelp");
}
else if (TryGetValue("<doctor_command>") is var doctorCommand && doctorCommand != null)
{
PyRevitCLIAppCmds.RunDoctor(doctorCommand, dryRun: arguments["--dryrun"].IsTrue);
}
else if (all("doctor", "--list"))
{
PyRevitCLIAppCmds.RunDoctor("--list");
}
else
{
PyRevitCLIAppCmds.RunDoctor("");
}
}
internal static string ToSqlStatic(CommonUtils _commonUtils, string _select, string field, StringBuilder _join, StringBuilder _where, string _groupby, string _having, string _orderby, int _skip, int _limit, List <SelectTableInfo> _tables, IFreeSql _orm)
{
if (_orm.CodeFirst.IsAutoSyncStructure)
{
_orm.CodeFirst.SyncStructure(_tables.Select(a => a.Table.Type).ToArray());
}
var sb = new StringBuilder();
sb.Append(_select).Append(field).Append(" \r\nFROM ");
var tbsjoin = _tables.Where(a => a.Type != SelectTableInfoType.From).ToArray();
var tbsfrom = _tables.Where(a => a.Type == SelectTableInfoType.From).ToArray();
for (var a = 0; a < tbsfrom.Length; a++)
{
sb.Append(_commonUtils.QuoteSqlName(tbsfrom[a].Table.DbName)).Append(" ").Append(tbsfrom[a].Alias);
if (tbsjoin.Length > 0)
{
//如果存在 join 查询，则处理 from t1, t2 改为 from t1 inner join t2 on 1 = 1
for (var b = 1; b < tbsfrom.Length; b++)
{
sb.Append(" \r\nLEFT JOIN ").Append(_commonUtils.QuoteSqlName(tbsfrom[b].Table.DbName)).Append(" ").Append(tbsfrom[b].Alias).Append(" ON 1 = 1");
}
break;
}
if (a < tbsfrom.Length - 1)
{
sb.Append(", ");
}
}
foreach (var tb in tbsjoin)
{
if (tb.Type == SelectTableInfoType.Parent)
{
continue;
}
switch (tb.Type)
{
case SelectTableInfoType.LeftJoin:
sb.Append(" \r\nLEFT JOIN ");
break;
case SelectTableInfoType.InnerJoin:
sb.Append(" \r\nINNER JOIN ");
break;
case SelectTableInfoType.RightJoin:
sb.Append(" \r\nRIGHT JOIN ");
break;
}
sb.Append(_commonUtils.QuoteSqlName(tb.Table.DbName)).Append(" ").Append(tb.Alias).Append(" ON ").Append(tb.On);
}
if (_join.Length > 0)
{
sb.Append(_join);
}
var sbqf = new StringBuilder();
foreach (var tb in _tables)
{
if (tb.Type == SelectTableInfoType.Parent)
{
continue;
}
if (string.IsNullOrEmpty(tb.Table.SelectFilter) == false)
{
sbqf.Append(" AND (").Append(tb.Table.SelectFilter.Replace("a.", $"{tb.Alias}.")).Append(")");
}
}
if (_where.Length > 0)
{
sb.Append(" \r\nWHERE ").Append(_where.ToString().Substring(5));
if (sbqf.Length > 0)
{
sb.Append(sbqf.ToString());
}
}
else
{
if (sbqf.Length > 0)
{
sb.Append(" \r\nWHERE ").Append(sbqf.Remove(0, 5));
}
}
if (string.IsNullOrEmpty(_groupby) == false)
{
sb.Append(_groupby);
if (string.IsNullOrEmpty(_having) == false)
{
sb.Append(" \r\nHAVING ").Append(_having.Substring(5));
}
}
sb.Append(_orderby);
if (_limit > 0)
{
sb.Append(" \r\nlimit ").Append(_limit);
}
if (_skip > 0)
{
sb.Append(" \r\noffset ").Append(_skip);
}
return(sb.ToString());
}
private void manageClient(CommonUtils.Cliente newCliente)
{
//string sql = "SELECT ClienteId from Cliente where NIT='" + cliente.NIT + "'";
Int64 clienteNitTemp = 0;
Int64.TryParse(newCliente.NIT, out clienteNitTemp);
if (clienteNitTemp == 0)
{
newCliente.IdCliente = -1;
newCliente.NIT = clienteNitTemp.ToString();
return;
}
string sql = "SELECT ClienteId from Cliente where NIT='" + newCliente.NIT + "'";
CommonUtils.ConexionBD.AbrirConexion();
SqlDataReader reader = CommonUtils.ConexionBD.EjecutarConsultaReader(sql);
int numberOfElements = 0;
int idClient = 0;
while (reader.Read())
{
numberOfElements++;
idClient = (int)reader.GetDecimal(0);
}
CommonUtils.ConexionBD.CerrarConexion();
if (numberOfElements == 0)
{
sql = "INSERT INTO Cliente (Nombre,NIT,Telefono,Direccion) VALUES (N'" +
newCliente.Nombre + "','" + newCliente.NIT + "','" + CommonUtils.StringUtils.EscapeSQL(newCliente.Telefono) + "','" + CommonUtils.StringUtils.EscapeSQL(newCliente.Direccion) + "')";
// CommonUtils.ConexionBD.Actualizar(sql);
decimal value = CommonUtils.ConexionBD.ActualizarRetornandoId(sql);
newCliente.IdCliente = (int)value;
}
else//there is a client with that nit,
{
sql = "UPDATE Cliente set Nombre='" + newCliente.Nombre + "' where clienteId='" + idClient + "'";
CommonUtils.ConexionBD.Actualizar(sql);
newCliente.IdCliente = idClient;
}
}
public override bool Execute()
{
var psi = new ProcessStartInfo();
psi.UseShellExecute = false;
if (TargetTypeExecutable.Equals(TargetType, StringComparison.InvariantCultureIgnoreCase))
{
psi.FileName = Target;
psi.Arguments = Arguments;
}
else
{
// We need the active environment to run these commands.
var resolver = new ResolveEnvironment(ProjectPath, BuildEngine);
if (!resolver.Execute())
{
return(false);
}
psi.FileName = resolver.InterpreterPath;
if (TargetTypeModule.Equals(TargetType, StringComparison.InvariantCultureIgnoreCase))
{
psi.Arguments = string.Format("-m {0} {1}", Target, Arguments);
}
else if (TargetTypeScript.Equals(TargetType, StringComparison.InvariantCultureIgnoreCase))
{
psi.Arguments = string.Format("\"{0}\" {1}", Target, Arguments);
}
else if (TargetTypeCode.Equals(TargetType, StringComparison.InvariantCultureIgnoreCase))
{
psi.Arguments = string.Format("-c \"{0}\"", Target);
}
// If no search paths are read, this is set to an empty string
// to mask any global setting.
psi.EnvironmentVariables[resolver.PathEnvironmentVariable] = string.Join(";", resolver.SearchPaths);
}
psi.WorkingDirectory = WorkingDirectory;
if (!string.IsNullOrEmpty(Environment))
{
foreach (var line in Environment.Split('\r', '\n'))
{
int equals = line.IndexOf('=');
if (equals > 0)
{
psi.EnvironmentVariables[line.Substring(0, equals)] = line.Substring(equals + 1);
}
}
}
if (ExecuteInNone.Equals(ExecuteIn, StringComparison.InvariantCultureIgnoreCase))
{
psi.CreateNoWindow = true;
psi.WindowStyle = ProcessWindowStyle.Hidden;
}
else if (ExecuteInConsolePause.Equals(ExecuteIn, StringComparison.InvariantCultureIgnoreCase))
{
psi.Arguments = string.Format(
"/C \"\"{0}\" {1}\" & pause",
psi.FileName,
psi.Arguments
);
psi.FileName = CommonUtils.GetAbsoluteFilePath(System.Environment.SystemDirectory, "cmd.exe");
}
psi.RedirectStandardOutput = true;
psi.RedirectStandardError = true;
using (var process = Process.Start(psi)) {
process.OutputDataReceived += Process_OutputDataReceived;
process.ErrorDataReceived += Process_ErrorDataReceived;
process.BeginOutputReadLine();
process.BeginErrorReadLine();
process.WaitForExit();
return(process.ExitCode == 0);
}
}
public OdbcDamengDbFirst(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression)
{
_orm = orm;
_commonUtils = commonUtils;
_commonExpression = commonExpression;
}
public Select1Provider(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression, object dywhere) : base(orm, commonUtils, commonExpression, dywhere)
{
}
private void registrarReserva(CommonUtils.Cliente cliente1)
{
string entregado = "False";
string tipoPedido = "Reserva";
string pagado = "False";
string fechaEntrega = dateEditFechaEntrega.DateTime.ToString();
double total = double.Parse(columnTotal.SummaryItem.SummaryValue.ToString());
this.manageClient(cliente1);
string sqlQuery = "Insert into Pedido(FechaPedidoText,FechaEntregaText,Descuento,TipoPedido,Pagado,FechaEntrega,Entregado,ClienteId,TotalVenta,FechaPedido,NombreCliente,Direccion,Telefono,NIT,NumeroPedido) values('" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss.fff") + "','" + dateEditFechaEntrega.DateTime.ToString("yyyy-MM-dd H:mm:ss.fff") + "','" + 0 + "','" + tipoPedido + "','" + pagado + "','" + fechaEntrega + "','" + entregado + "','" + cliente1.IdCliente + "','" + total + "','" + DateTime.Now + "','" + cliente1.Nombre + "','" + cliente1.Direccion + "','" + cliente1.Telefono + "','" + cliente1.NIT + "','" + cliente1.NumeroPedido + "')";
decimal idPedido = CommonUtils.ConexionBD.ActualizarRetornandoId(sqlQuery);
List<DataRow> listaPedidos = dataTable.AsEnumerable().ToList();
foreach (DataRow item in listaPedidos)
{
string costoReceta = CalculadoraVentas.obtenerCostoReceta(item);//this.obtenerCostoReceta(item);
sqlQuery = "insert into Pedido_Producto(PedidoId,ProductoId,Cantidad,Total,CostoReceta,PrecioProducto,Descripcion) values('" + idPedido + "','" + item["Id"] + "','" + item["Cantidad"] + "','" + item["Subtotal"] + "','" + costoReceta + "','" + item["Precio"] + "','" + item["Descripcion"] + "')";
CommonUtils.ConexionBD.Actualizar(sqlQuery);
}
}
public JsonResult ExportAdd(EditViewModel model)
{
CustomJsonResult r = new CustomJsonResult();
r.ContentType = "text/html";
try
{
HttpPostedFileBase file_upload = Request.Files[0];
if (file_upload == null)
{
return(Json("text/html", ResultType.Failure, "找不到上传的对象"));
}
if (file_upload.ContentLength == 0)
{
return(Json("text/html", ResultType.Failure, "文件内容为空,请重新选择"));
}
System.IO.FileInfo file = new System.IO.FileInfo(file_upload.FileName);
string ext = file.Extension.ToLower();
if (ext != ".xls")
{
return(Json("text/html", ResultType.Failure, "上传的文件不是excel格式(xls)"));
}
HSSFWorkbook workbook = new HSSFWorkbook(file_upload.InputStream);
ISheet sheet = workbook.GetSheetAt(0);
ExportCheckErrorPoint exportCheckErrorPoint = new ExportCheckErrorPoint();
IRow rowTitle = sheet.GetRow(0);
exportCheckErrorPoint.CheckCellTitle(rowTitle.GetCell(0), "设备ID");
exportCheckErrorPoint.CheckCellTitle(rowTitle.GetCell(1), "机身号");
exportCheckErrorPoint.CheckCellTitle(rowTitle.GetCell(2), "终端号");
exportCheckErrorPoint.CheckCellTitle(rowTitle.GetCell(3), "版本号");
exportCheckErrorPoint.CheckCellTitle(rowTitle.GetCell(4), "押金");
exportCheckErrorPoint.CheckCellTitle(rowTitle.GetCell(5), "租金");
if (exportCheckErrorPoint.TitleHasError)
{
return(Json("text/html", ResultType.Failure, "上传的文件模板错误，请点击下载的文件模板"));
}
int rowCount = sheet.LastRowNum + 1;
if (rowCount == 1)
{
return(Json("text/html", ResultType.Failure, "上传的文件数据为空，请检查后再次上传"));
}
List <PosMachine> posMachines = new List <PosMachine>();
for (int i = 1; i < rowCount; i++)
{
IRow row = sheet.GetRow(i);
string deviceId = row.GetCell(0).ToString();
string fuselageNumber = row.GetCell(1) == null ? "" : row.GetCell(1).ToString();
string terminalNumber = row.GetCell(2) == null ? "" : row.GetCell(2).ToString();
string version = row.GetCell(3) == null ? "" : row.GetCell(3).ToString();
string deposit = row.GetCell(4) == null ? "" : row.GetCell(4).ToString();
string rent = row.GetCell(5) == null ? "" : row.GetCell(5).ToString();
if (string.IsNullOrEmpty(deviceId))
{
return(Json("text/html", ResultType.Failure, "检查到有为空的设备ID，请完善后再次上传"));
}
if (string.IsNullOrEmpty(deviceId) || deviceId.Length > 100)
{
exportCheckErrorPoint.AddPoint(deviceId, "设备ID不能为空，且不能超过100个字符");
}
if (string.IsNullOrEmpty(fuselageNumber) || fuselageNumber.Length > 100)
{
exportCheckErrorPoint.AddPoint(deviceId, "机身号不能为空，且不能超过100个字符");
}
if (string.IsNullOrEmpty(terminalNumber) || terminalNumber.Length > 100)
{
exportCheckErrorPoint.AddPoint(deviceId, "终端号不能为空，且不能超过100个字符");
}
if (string.IsNullOrEmpty(version) || version.Length > 100)
{
exportCheckErrorPoint.AddPoint(deviceId, "版本号不能为空，且不能超过100个字符");
}
if (CommonUtils.IsDecimal(deposit))
{
exportCheckErrorPoint.AddPoint(deviceId, "押金必须数字格式,且整数位最多16位,小数位最多2位");
}
if (CommonUtils.IsDecimal(rent))
{
exportCheckErrorPoint.AddPoint(deviceId, "租金必须数字格式,且整数位最多16位,小数位最多2位");
}
PosMachine posMachine = new PosMachine();
posMachine.DeviceId = deviceId;
posMachine.FuselageNumber = fuselageNumber;
posMachine.TerminalNumber = terminalNumber;
posMachine.Version = version;
posMachines.Add(posMachine);
}
if (exportCheckErrorPoint.ErrorPoint.Count > 0)
{
return(Json("text/html", ResultType.Failure, exportCheckErrorPoint.ErrorPoint, "更新数据失败，检查到无效的数据"));
}
using (TransactionScope ts = new TransactionScope())
{
foreach (var posMachine in posMachines)
{
var old = CurrentDb.PosMachine.Where(m => m.DeviceId == posMachine.DeviceId).FirstOrDefault();
if (old != null)
{
exportCheckErrorPoint.AddPoint(old.DeviceId, "设备ID号:" + posMachine.DeviceId + "，已经存在");
}
}
if (exportCheckErrorPoint.ErrorPoint.Count > 0)
{
return(Json("text/html", ResultType.Failure, exportCheckErrorPoint.ErrorPoint, "更新数据失败，检查到无效的数据"));
}
DateTime dateNow = DateTime.Now;
foreach (var posMachine in posMachines)
{
posMachine.CreateTime = dateNow;
posMachine.Creator = this.CurrentUserId;
CurrentDb.PosMachine.Add(posMachine);
}
CurrentDb.SaveChanges();
ts.Complete();
}
return(Json("text/html", ResultType.Success, "上传成功"));
}
catch (Exception ex)
{
Log.Error("导入POS机信息", ex);
return(Json("text/html", ResultType.Exception, "上传失败，系统出现异常"));
}
}
public DamengSelect(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression, object dywhere) : base(orm, commonUtils, commonExpression, dywhere)
{
}
public OracleInsertOrUpdate(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression)
: base(orm, commonUtils, commonExpression)
{
}
internal static string ToSqlStatic(CommonUtils _commonUtils, CommonExpression _commonExpression, string _select, bool _distinct, string field, StringBuilder _join, StringBuilder _where, string _groupby, string _having, string _orderby, int _skip, int _limit, List <SelectTableInfo> _tables, Func <Type, string, string> tableRuleInvoke, List <LambdaExpression> _whereCascadeExpression, IFreeSql _orm)
{
if (_orm.CodeFirst.IsAutoSyncStructure)
{
_orm.CodeFirst.SyncStructure(_tables.Select(a => a.Table.Type).ToArray());
}
if (_whereCascadeExpression.Any())
{
foreach (var tb in _tables.Where(a => a.Type != SelectTableInfoType.Parent))
{
tb.Cascade = _commonExpression.GetWhereCascadeSql(tb, _whereCascadeExpression);
}
}
var sb = new StringBuilder();
var sbnav = new StringBuilder();
sb.Append(_select);
if (_distinct)
{
sb.Append("DISTINCT ");
}
sb.Append(field).Append(" \r\nFROM ");
var tbsjoin = _tables.Where(a => a.Type != SelectTableInfoType.From).ToArray();
var tbsfrom = _tables.Where(a => a.Type == SelectTableInfoType.From).ToArray();
for (var a = 0; a < tbsfrom.Length; a++)
{
sb.Append(_commonUtils.QuoteSqlName(tableRuleInvoke(tbsfrom[a].Table.Type, tbsfrom[a].Table.DbName))).Append(" ").Append(tbsfrom[a].Alias);
if (tbsjoin.Length > 0)
{
//如果存在 join 查询，则处理 from t1, t2 改为 from t1 inner join t2 on 1 = 1
for (var b = 1; b < tbsfrom.Length; b++)
{
sb.Append(" \r\nLEFT JOIN ").Append(_commonUtils.QuoteSqlName(tableRuleInvoke(tbsfrom[b].Table.Type, tbsfrom[b].Table.DbName))).Append(" ").Append(tbsfrom[b].Alias);
if (string.IsNullOrEmpty(tbsfrom[b].NavigateCondition) && string.IsNullOrEmpty(tbsfrom[b].On) && string.IsNullOrEmpty(tbsfrom[b].Cascade))
{
sb.Append(" ON 1 = 1");
}
else
{
sb.Append(" ON ").Append(tbsfrom[b].NavigateCondition ?? tbsfrom[b].On);
if (string.IsNullOrEmpty(tbsfrom[b].Cascade) == false)
{
sb.Append(" AND (").Append(tbsfrom[b].Cascade).Append(")");
}
}
}
break;
}
else
{
if (!string.IsNullOrEmpty(tbsfrom[a].NavigateCondition))
{
sbnav.Append(" AND (").Append(tbsfrom[a].NavigateCondition).Append(")");
}
if (!string.IsNullOrEmpty(tbsfrom[a].On))
{
sbnav.Append(" AND (").Append(tbsfrom[a].On).Append(")");
}
if (a > 0 && !string.IsNullOrEmpty(tbsfrom[a].Cascade))
{
sbnav.Append(" AND (").Append(tbsfrom[a].Cascade).Append(")");
}
}
if (a < tbsfrom.Length - 1)
{
sb.Append(", ");
}
}
foreach (var tb in tbsjoin)
{
if (tb.Type == SelectTableInfoType.Parent)
{
continue;
}
switch (tb.Type)
{
case SelectTableInfoType.LeftJoin:
sb.Append(" \r\nLEFT JOIN ");
break;
case SelectTableInfoType.InnerJoin:
sb.Append(" \r\nINNER JOIN ");
break;
case SelectTableInfoType.RightJoin:
sb.Append(" \r\nRIGHT JOIN ");
break;
}
sb.Append(_commonUtils.QuoteSqlName(tableRuleInvoke(tb.Table.Type, tb.Table.DbName))).Append(" ").Append(tb.Alias).Append(" ON ").Append(tb.On ?? tb.NavigateCondition);
if (!string.IsNullOrEmpty(tb.Cascade))
{
sb.Append(" AND (").Append(tb.Cascade).Append(")");
}
if (!string.IsNullOrEmpty(tb.On) && !string.IsNullOrEmpty(tb.NavigateCondition))
{
sbnav.Append(" AND (").Append(tb.NavigateCondition).Append(")");
}
}
if (_join.Length > 0)
{
sb.Append(_join);
}
sbnav.Append(_where);
if (!string.IsNullOrEmpty(_tables[0].Cascade))
{
sbnav.Append(" AND (").Append(_tables[0].Cascade).Append(")");
}
foreach (var tb in _tables)
{
if (tb.Type == SelectTableInfoType.Parent)
{
continue;
}
if (string.IsNullOrEmpty(tb.Table.SelectFilter) == false)
{
sbnav.Append(" AND (").Append(tb.Table.SelectFilter.Replace("a.", $"{tb.Alias}.")).Append(")");
}
}
if (sbnav.Length > 0)
{
sb.Append(" \r\nWHERE ").Append(sbnav.Remove(0, 5));
}
if (string.IsNullOrEmpty(_groupby) == false)
{
sb.Append(_groupby);
if (string.IsNullOrEmpty(_having) == false)
{
sb.Append(" \r\nHAVING ").Append(_having.Substring(5));
}
}
sb.Append(_orderby);
if (_limit > 0)
{
sb.Append(" \r\nlimit ").Append(_limit);
}
if (_skip > 0)
{
sb.Append(" \r\noffset ").Append(_skip);
}
sbnav.Clear();
return(sb.ToString());
}
public OdbcSqlServerExpression(CommonUtils common) : base(common)
{
}
public MySqlCodeFirst(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression) : base(orm, commonUtils, commonExpression)
{
}
/// <summary>
/// Saves or Save As the file
/// </summary>
/// <param name="isCalledFromSaveAs">Flag determining which Save method called , the SaveAs or the Save.</param>
/// <param name="fileName">The name of the project file.</param>
private void DoSave(bool isCalledFromSaveAs, string fileName)
{
Utilities.ArgumentNotNull("fileName", fileName);
CheckProjectIsValid();
using (AutomationScope scope = new AutomationScope(this.Node.ProjectMgr.Site)) {
Node.ProjectMgr.Site.GetUIThread().Invoke(() => {
IntPtr docData = IntPtr.Zero;
try {
IVsRunningDocumentTable rdt = this.Node.ProjectMgr.Site.GetService(typeof(SVsRunningDocumentTable)) as IVsRunningDocumentTable;
if (rdt == null)
{
throw new InvalidOperationException("Could not get running document table from the services exposed by this project");
}
// First we see if someone else has opened the requested view of the file.
uint itemid;
IVsHierarchy ivsHierarchy;
uint docCookie;
int canceled;
string url = this.Node.Url;
ErrorHandler.ThrowOnFailure(rdt.FindAndLockDocument((uint)_VSRDTFLAGS.RDT_NoLock, url, out ivsHierarchy, out itemid, out docData, out docCookie));
// If an empty file name is passed in for Save then make the file name the project name.
if (!isCalledFromSaveAs && fileName.Length == 0)
{
ErrorHandler.ThrowOnFailure(this.Node.ProjectMgr.SaveItem(VSSAVEFLAGS.VSSAVE_SilentSave, url, this.Node.ID, docData, out canceled));
}
else
{
Utilities.ValidateFileName(this.Node.ProjectMgr.Site, fileName);
// Compute the fullpath from the directory of the existing Url.
string fullPath = CommonUtils.GetAbsoluteFilePath(Path.GetDirectoryName(url), fileName);
if (!isCalledFromSaveAs)
{
if (!CommonUtils.IsSamePath(this.Node.Url, fullPath))
{
throw new InvalidOperationException();
}
ErrorHandler.ThrowOnFailure(this.Node.ProjectMgr.SaveItem(VSSAVEFLAGS.VSSAVE_SilentSave, fullPath, this.Node.ID, docData, out canceled));
}
else
{
ErrorHandler.ThrowOnFailure(this.Node.ProjectMgr.SaveItem(VSSAVEFLAGS.VSSAVE_SilentSave, fullPath, this.Node.ID, docData, out canceled));
}
}
if (canceled == 1)
{
throw new InvalidOperationException();
}
} catch (COMException e) {
throw new InvalidOperationException(e.Message);
} finally {
if (docData != IntPtr.Zero)
{
Marshal.Release(docData);
}
}
});
}
}
/// <summary>
/// Converts a CAS Service Ticket to its corresponding key in the
/// ticket manager store (cache provider).
/// </summary>
/// <param name="serviceTicket">
/// The CAS Service ticket to convert.
/// </param>
/// <returns>
/// The cache key associated with the corresponding
/// service ticket
/// </returns>
/// <exception cref="ArgumentNullException">serviceTicket is null</exception>
/// <exception cref="ArgumentException">serviceTicket is empty</exception>
private static string GetTicketKey(string serviceTicket)
{
CommonUtils.AssertNotNullOrEmpty(serviceTicket, "serviceTicket parameter cannot be null or empty.");
return(CACHE_TICKET_KEY_PREFIX + serviceTicket);
}
public OdbcKingbaseESDelete(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression, object dywhere)
: base(orm, commonUtils, commonExpression, dywhere)
{
}
// Updates the if then machine based on received message
public string UpdateIfThenMachine(CanData can, string cartype)
{
// setups the can information for string comparison to the XML
string stringid = String.Format("{0:X}", can.id);
string stringmsg = CommonUtils.ConvertMsgtoString(can.msg, can.dlc);
// Cycles through the dictionary of ifthens
foreach (KeyValuePair <string, State> pair in IfThenPackets)
{
// if in the if state then proceed with message matching
if (pair.Value == State.If)
{
// MainWindow.ErrorDisplayString("In Update IfThen: dictionary -- " + pair.Key);
// compares can message in xml to received can message
try
{
XElement carElement = XElement.Load(ConfigFiles.Settings1.Default.filterURI);
// Error Checking -- very clunky; needs revisions
if (carElement.Descendants("CarType").Where(e2 => e2.Element("CarName").Value.Equals(cartype)).FirstOrDefault() == null)
{
return(null);
}
var cartypeElement = carElement.Descendants("CarType").Where(e2 => e2.Element("CarName").Value.Equals(cartype)).FirstOrDefault();
//MainWindow.ErrorDisplayString("1:" + cartypeElement.ToString());
// ************************
// Needs to cycle through all of the If thens so that the if and thens can be properly synced together
// ************************
// Error Checking -- very clunky; needs revisions
if (cartypeElement.Elements("IFTHEN").Where(e2 => e2.Element("Name").Value.Equals(pair.Key, StringComparison.OrdinalIgnoreCase)).FirstOrDefault() == null)
{
return(null);
}
var ifthenElement = cartypeElement.Elements("IFTHEN").Where(e2 => e2.Element("Name").Value.Equals(pair.Key, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
//MainWindow.ErrorDisplayString("2:" + ifthenElement.ToString());
if (ifthenElement.Elements("If") == null)
{
return(null);
}
var packetElement = ifthenElement.Elements("If");
//MainWindow.ErrorDisplayString("3:" + packetElement.ToString());
if (packetElement.Elements("Packet").Where(e3 => e3.Element("Message").Value.Equals(stringmsg, StringComparison.OrdinalIgnoreCase) &&
e3.Element("ID").Value.Equals(stringid, StringComparison.OrdinalIgnoreCase)).FirstOrDefault() != null)
{
var msgElement = packetElement.Elements("Packet").Where(e3 => e3.Element("Message").Value.Equals(stringmsg, StringComparison.OrdinalIgnoreCase) &&
e3.Element("ID").Value.Equals(stringid, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (ifthenElement.Elements("Then") == null)
{
return(null);
}
var responseElement = ifthenElement.Elements("Then");
if (responseElement.Elements("Packet") == null)
{
return(null);
}
//var responsePacketElement = responseElement.Descendants("Packet");
var responsePacketElement = responseElement.Elements("Packet").FirstOrDefault();
return((string)responsePacketElement.Element("ID") + ";"
+ (string)responsePacketElement.Element("DLC") + ";"
+ (string)responsePacketElement.Element("Flag") + ";"
+ (string)responsePacketElement.Element("Message"));
}
return(null);
}
//catch (FileNotFoundException)
catch (Exception)
{
ErrorLog.NewLogEntry("Filter", "URI filename not found");
return(null);
}
}
}
return(null);
}
public SqliteUpdate(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression, object dywhere)
: base(orm, commonUtils, commonExpression, dywhere)
{
}
private DataSet GetQueryCondition()
{
Hashtable htParams = new Hashtable();
if (!(teOUTBANDNO.Text == ""))
{
htParams.Add("OUTBANDNO", teOUTBANDNO.Text);
}
if (!(teVBELN.Text == ""))
{
htParams.Add("VBELN", teVBELN.Text);
}
if (!(teCREATED_BY.Text == ""))
{
htParams.Add("CREATED_BY", teCREATED_BY.Text);
}
if (!(teSALESTO.Text == ""))
{
htParams.Add("SALESTO", teSALESTO.Text);
}
if (!(teXHGG.Text == ""))
{
htParams.Add("XHGG", teXHGG.Text);
}
if (!(lookUpPLANT.Text == ""))//if (!(lookUpPLANT.Text == ""))
{
htParams.Add("PLANT", lookUpPLANT.EditValue.ToString());
}
if (!(comboBoxSTATUS.Text == ""))
{
htParams.Add("STATUS", comboBoxSTATUS.Text);
}
if (!(teBATCHNO.Text == ""))
{
htParams.Add("BATCHNO", teBATCHNO.Text);
}
if (!(teCabinet_NO.Text == ""))
{
htParams.Add("Cabinet_NO", teCabinet_NO.Text);
}
if (!(teCI.Text == ""))
{
htParams.Add("CI", teCI.Text);
}
if (!(teShipmentNo.Text == ""))
{
htParams.Add("ShipmentNo", teShipmentNo.Text);
}
if (!(dateLFDAT1.Text == ""))
{
htParams.Add("LFDAT1", dateLFDAT1.Text);
}
if (!(dateLFDAT2.Text == ""))
{
htParams.Add("LFDAT2", dateLFDAT2.Text);
}
if (!(dateQCDAT1.Text == ""))
{
htParams.Add("QCDAT1", dateQCDAT1.Text);
}
if (!(dateQCDAT2.Text == ""))
{
htParams.Add("QCDAT2", dateQCDAT2.Text);
}
DataTable dtParams = CommonUtils.ParseToDataTable(htParams);
DataSet dsParams = new DataSet();
dtParams.TableName = TRANS_TABLES.TABLE_MAIN_DATA;
dsParams.Tables.Add(dtParams);
return(dsParams);
}
public override string ToString()
{
return(string.Format("ICS: Conversation={0}, {1}", this.Conversation, CommonUtils.ConcatEntries <int>(this.CoveringPropertyTags, (int ptag) => ptag.ToString("X"))));
}
public SqlServerDelete(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression, object dywhere)
: base(orm, commonUtils, commonExpression, dywhere)
{
}
public MySqlExpression(CommonUtils common) : base(common)
{
}
public SqliteExpression(CommonUtils common) : base(common)
{
}
public MySqlCodeFirst(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression)
{
_orm = orm;
_commonUtils = commonUtils;
_commonExpression = commonExpression;
}
public CalculadoraVentas(CommonUtils.ActualizarGrids IUpdateGrids,DataTable table,Form parentForm,double totalDinero,bool reserva,bool sePago,CommonUtils.Cliente _client)
{
InitializeComponent();
InitializePrintSettings( );
dbLog = new CommonUtils.DataBaseLog();
log4net.Config.XmlConfigurator.Configure( );
dataTable = table;
total = totalDinero;
txtCuenta.Text = total.ToString();
txtTotal.Text = total.ToString();
pagado = sePago;
esReserva = reserva;
cliente = _client;
// ventasPanel = ventasPnl;
UpdateGrids = IUpdateGrids;
InitConexionDB();
if (parentForm != null)
{
Left = parentForm.Left + (parentForm.Width - Width) / 2;
Top = parentForm.Top + (parentForm.Height - Height) / 2;
}
}
/// <summary>
/// Pastes SyncItem into the database.
///
/// </summary>
/// <param name="syncItem">The sync item.</param>
/// <param name="ignoreMissingTemplateFields">Whether to ignore fields in the serialized item that do not exist on the Sitecore template</param>
/// <returns>
/// The pasted item.
/// </returns>
/// <exception cref="T:Sitecore.Data.Serialization.Exceptions.ParentItemNotFoundException"><c>ParentItemNotFoundException</c>.</exception><exception cref="T:System.Exception"><c>Exception</c>.</exception><exception cref="T:Sitecore.Data.Serialization.Exceptions.ParentForMovedItemNotFoundException"><c>ParentForMovedItemNotFoundException</c>.</exception>
public override ISourceItem Deserialize(ISerializedItem serializedItem, bool ignoreMissingTemplateFields)
{
Assert.ArgumentNotNull(serializedItem, "serializedItem");
var typed = serializedItem as SitecoreSerializedItem;
if (typed == null)
{
throw new ArgumentException("Serialized item must be a SitecoreSerializedItem", "serializedItem");
}
var syncItem = typed.InnerItem;
Database database = Factory.GetDatabase(syncItem.DatabaseName);
Item destinationParentItem = database.GetItem(syncItem.ParentID);
ID itemId = ID.Parse(syncItem.ID);
Item targetItem = database.GetItem(itemId);
bool newItemWasCreated = false;
// the target item did not yet exist, so we need to start by creating it
if (targetItem == null)
{
targetItem = CreateTargetItem(syncItem, destinationParentItem);
_logger.CreatedNewItem(targetItem);
newItemWasCreated = true;
}
else
{
// check if the parent of the serialized item does not exist
// which, since the target item is known to exist, means that
// the serialized item was moved but its new parent item does
// not exist to paste it under
if (destinationParentItem == null)
{
throw new ParentForMovedItemNotFoundException
{
ParentID = syncItem.ParentID,
Item = targetItem
};
}
// if the parent IDs mismatch that means we need to move the existing
// target item to its new parent from the serialized item
if (destinationParentItem.ID != targetItem.ParentID)
{
var oldParent = targetItem.Parent;
targetItem.MoveTo(destinationParentItem);
_logger.MovedItemToNewParent(destinationParentItem, oldParent, targetItem);
}
}
try
{
ChangeTemplateIfNeeded(syncItem, targetItem);
RenameIfNeeded(syncItem, targetItem);
ResetTemplateEngineIfItemIsTemplate(targetItem);
using (new EditContext(targetItem))
{
targetItem.RuntimeSettings.ReadOnlyStatistics = true;
targetItem.RuntimeSettings.SaveAll = true;
foreach (Field field in targetItem.Fields)
{
if (field.Shared && syncItem.SharedFields.All(x => x.FieldID != field.ID.ToString()))
{
_logger.ResetFieldThatDidNotExistInSerialized(field);
field.Reset();
}
}
foreach (SyncField field in syncItem.SharedFields)
{
PasteSyncField(targetItem, field, ignoreMissingTemplateFields, newItemWasCreated);
}
}
ClearCaches(database, itemId);
targetItem.Reload();
ResetTemplateEngineIfItemIsTemplate(targetItem);
Hashtable versionTable = CommonUtils.CreateCIHashtable();
// this version table allows us to detect and remove orphaned versions that are not in the
// serialized version, but are in the database version
foreach (Item version in targetItem.Versions.GetVersions(true))
{
versionTable[version.Uri] = null;
}
foreach (SyncVersion syncVersion in syncItem.Versions)
{
var version = PasteSyncVersion(targetItem, syncVersion, ignoreMissingTemplateFields, newItemWasCreated);
if (versionTable.ContainsKey(version.Uri))
{
versionTable.Remove(version.Uri);
}
}
foreach (ItemUri uri in versionTable.Keys)
{
var versionToRemove = Database.GetItem(uri);
_logger.RemovingOrphanedVersion(versionToRemove);
versionToRemove.Versions.RemoveVersion();
}
ClearCaches(targetItem.Database, targetItem.ID);
return(new SitecoreSourceItem(targetItem));
}
catch (ParentForMovedItemNotFoundException)
{
throw;
}
catch (ParentItemNotFoundException)
{
throw;
}
#if SITECORE_7
catch (FieldIsMissingFromTemplateException)
{
throw;
}
#endif
catch (Exception ex)
{
if (newItemWasCreated)
{
targetItem.Delete();
ClearCaches(database, itemId);
}
throw new Exception("Failed to paste item: " + syncItem.ItemPath, ex);
}
}
