public IResponse Execute(ICruiseRequest request)
{
Hashtable velocityContext = new Hashtable();
ArrayList links = new ArrayList();
links.Add(new ServerLink(urlBuilder, request.ServerSpecifier, "Server Log", ActionName));
ProjectStatusListAndExceptions projects = farmService.GetProjectStatusListAndCaptureExceptions(request.ServerSpecifier,
request.RetrieveSessionToken());
foreach (ProjectStatusOnServer projectStatusOnServer in projects.StatusAndServerList)
{
DefaultProjectSpecifier projectSpecifier = new DefaultProjectSpecifier(projectStatusOnServer.ServerSpecifier, projectStatusOnServer.ProjectStatus.Name);
links.Add(new ProjectLink(urlBuilder, projectSpecifier, projectSpecifier.ProjectName, ServerLogProjectPlugin.ActionName));
}
velocityContext["projectLinks"] = links;
if (string.IsNullOrEmpty(request.ProjectName))
{
velocityContext["log"] = HttpUtility.HtmlEncode(farmService.GetServerLog(request.ServerSpecifier, request.RetrieveSessionToken()));
}
else
{
velocityContext["currentProject"] = request.ProjectSpecifier.ProjectName;
velocityContext["log"] = HttpUtility.HtmlEncode(farmService.GetServerLog(request.ProjectSpecifier, request.RetrieveSessionToken()));
}
return viewGenerator.GenerateView(@"ServerLog.vm", velocityContext);
}
/// <summary>
/// Creates a NDataReader from a <see cref="IDataReader" />
/// </summary>
/// <param name="reader">The <see cref="IDataReader" /> to get the records from the Database.</param>
/// <param name="isMidstream"><see langword="true" /> if we are loading the <see cref="IDataReader" /> in the middle of reading it.</param>
/// <remarks>
/// NHibernate attempts to not have to read the contents of an <see cref="IDataReader"/> into memory until it absolutely
/// has to. What that means is that it might have processed some records from the <see cref="IDataReader"/> and will
/// pick up the <see cref="IDataReader"/> midstream so that the underlying <see cref="IDataReader"/> can be closed
/// so a new one can be opened.
/// </remarks>
public NDataReader(IDataReader reader, bool isMidstream)
{
ArrayList resultList = new ArrayList(2);
try
{
// if we are in midstream of processing a DataReader then we are already
// positioned on the first row (index=0)
if (isMidstream)
{
currentRowIndex = 0;
}
// there will be atleast one result
resultList.Add(new NResult(reader, isMidstream));
while (reader.NextResult())
{
// the second, third, nth result is not processed midstream
resultList.Add(new NResult(reader, false));
}
results = (NResult[]) resultList.ToArray(typeof(NResult));
}
catch (Exception e)
{
throw new ADOException("There was a problem converting an IDataReader to NDataReader", e);
}
finally
{
reader.Close();
}
}
public DataSet PRC_PersonasListasDePrecios()
{
ArrayList Parameters=new ArrayList(0);
SqlParameter MODOParameter=new SqlParameter("@MODO",SqlDbType.Int);
MODOParameter.Size=0;
MODOParameter.Value=MODO;
Parameters.Add(MODOParameter);
SqlParameter PersonasListasDePrecios_IDParameter=new SqlParameter("@PersonasListasDePrecios_ID",SqlDbType.Int);
PersonasListasDePrecios_IDParameter.Size=0;
PersonasListasDePrecios_IDParameter.Value=PersonasListasDePrecios_ID;
Parameters.Add(PersonasListasDePrecios_IDParameter);
SqlParameter Personas_IDParameter=new SqlParameter("@Personas_ID",SqlDbType.Int);
Personas_IDParameter.Size=0;
Personas_IDParameter.Value=Personas_ID;
Parameters.Add(Personas_IDParameter);
SqlParameter ListasDePrecios_IDParameter=new SqlParameter("@ListasDePrecios_ID",SqlDbType.Int);
ListasDePrecios_IDParameter.Size=0;
ListasDePrecios_IDParameter.Value=ListasDePrecios_ID;
Parameters.Add(ListasDePrecios_IDParameter);
SqlParameter PersonasDirecciones_IDParameter=new SqlParameter("@PersonasDirecciones_ID",SqlDbType.Int);
PersonasDirecciones_IDParameter.Size=0;
PersonasDirecciones_IDParameter.Value=PersonasDirecciones_ID;
Parameters.Add(PersonasDirecciones_IDParameter);
DataSet dsResult=ExecuteStoredProcedure("[Grifo].[PRC_PersonasListasDePrecios]",ref Parameters);
return dsResult;
}
/// <summary>
/// Action
/// </summary>
/// <param name="living"></param>
public override void Execute(GameLiving living)
{
if (CheckPreconditions(living, DEAD | SITTING | MEZZED | STUNNED)) return;
GamePlayer player = living as GamePlayer;
if (player != null)
{
ArrayList targets = new ArrayList();
if (player.Group == null)
targets.Add(player);
else
{
foreach (GamePlayer grpplayer in player.Group.GetPlayersInTheGroup())
{
if (player.IsWithinRadius(grpplayer, SpellRadius) && grpplayer.IsAlive)
targets.Add(grpplayer);
}
}
foreach (GamePlayer target in targets)
{
//send spelleffect
if (!target.IsAlive) continue;
ValhallasBlessingEffect ValhallasBlessing = target.EffectList.GetOfType<ValhallasBlessingEffect>();
if (ValhallasBlessing != null)
ValhallasBlessing.Cancel(false);
new ValhallasBlessingEffect().Start(target);
}
}
DisableSkill(living);
}
public IList aListOfPoint()
{
IList list = new ArrayList();
list.Add(new System.Drawing.Point(0,0));
list.Add(new System.Drawing.Point(5,5));
return list;
}
public Listener( int port )
{
m_ThisPort = port;
m_Disposed = false;
m_Accepted = new Queue();
m_OnAccept = new AsyncCallback( OnAccept );
m_Listener = Bind( IPAddress.Any, port );
try
{
IPHostEntry iphe = Dns.Resolve( Dns.GetHostName() );
ArrayList list = new ArrayList();
list.Add( IPAddress.Loopback );
Console.WriteLine( "Address: {0}:{1}", IPAddress.Loopback, port );
IPAddress[] ips = iphe.AddressList;
for ( int i = 0; i < ips.Length; ++i )
{
if ( !list.Contains( ips[i] ) )
{
list.Add( ips[i] );
Console.WriteLine( "Address: {0}:{1}", ips[i], port );
}
}
}
catch
{
}
}
public void DrainLife()
{
ArrayList list = new ArrayList();
foreach ( Mobile m in this.GetMobilesInRange( 2 ) )
{
if ( m == this || !CanBeHarmful( m ) )
continue;
if ( m is BaseCreature && (((BaseCreature)m).Controlled || ((BaseCreature)m).Summoned || ((BaseCreature)m).Team != this.Team) )
list.Add( m );
else if ( m.Player )
list.Add( m );
}
foreach ( Mobile m in list )
{
DoHarmful( m );
m.FixedParticles( 0x374A, 10, 15, 5013, 0x496, 0, EffectLayer.Waist );
m.PlaySound( 0x231 );
m.SendMessage( "You feel the life drain out of you!" );
int toDrain = Utility.RandomMinMax( 10, 40 );
Hits += toDrain;
m.Damage( toDrain, this );
}
}
/// <summary>
/// Gets/Sets the specified value
/// </summary>
public dynamic this[string key]
{
get
{
if (!Values.ContainsKey(key))
return null;
object result = Values[key];
if (result is IDictionary<string, object>)
result = new JsonDataObject(result as IDictionary<string, object>);
else if (result is ArrayList)
{
ArrayList resultList = result as ArrayList;
ArrayList dataList = new ArrayList();
foreach (object current in resultList)
{
if (current is IDictionary<string, object>)
dataList.Add(new JsonDataObject(current as IDictionary<string, object>));
else
dataList.Add(current);
}
result = dataList;
}
return result;
}
set
{
if (Values.ContainsKey(key))
Values[key] = value;
else
Values.Add(key, value);
}
}
public AssemblerMethod(Method method, AssemblerLine[] lines)
{
this.method = method;
this.lines = lines;
addresses = new ArrayList ();
ArrayList contents = new ArrayList ();
foreach (AssemblerLine line in lines) {
if (line.Label != null) {
if (end_row > 0) {
contents.Add ("");
end_row++;
} else
start_row++;
contents.Add (String.Format ("{0}:", line.Label));
end_row++;
}
addresses.Add (new LineEntry (line.Address, 0, ++end_row));
contents.Add (String.Format (" {0:x} {1}", line.Address, line.Text));
}
string[] text = new string [contents.Count];
contents.CopyTo (text);
buffer = new SourceBuffer (method.Name, text);
}
public bool UpdateTjcy(ActionEnum action, Xm_Ysxx ysxx, List<Item_File> fileInfos)
{
ArrayList sqls = new ArrayList();
string tmpSql;
switch (action)
{
case ActionEnum.Insert:
sqls.Add(SqlBuilder.BuildInsertSql(ysxx));
break;
case ActionEnum.Update:
sqls.Add(SqlBuilder.BuildUpdateSql(ysxx));
break;
}
//清空项目所有的文件。
tmpSql = "delete from item_file where itemcode = '{0}' and nodeid = '{1}' and filecode not in ('24','25','26')";
tmpSql = string.Format(tmpSql, ysxx.ITEMCODE, (int)WorkFlowNode.JunGong);
sqls.Add(tmpSql);
//插入基本信息的文件。
foreach (Item_File fileInfo in fileInfos)
{
sqls.Add(SqlBuilder.BuildInsertSql(fileInfo));
}
return OracleHelper.ExecuteCommand(sqls);
}
public DataTable GetByCriteria(IEntityBase value)
{
EClienteBandeja objE = (EClienteBandeja)value;
try
{
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, objE.IdEmpresa));
arrPrm.Add(DataHelper.CreateParameter("@pidCliente", SqlDbType.Char, 7, objE.IdCliente));
arrPrm.Add(DataHelper.CreateParameter("@pnuNif", SqlDbType.VarChar, 20, objE.NuNif));
arrPrm.Add(DataHelper.CreateParameter("@pdsRazSocial", SqlDbType.VarChar, 150, objE.DsRazSocial));
DataTable dt = this.ExecuteDatatable("PD_Clientes_qry01", arrPrm);
return dt;
}
catch (Exception ex)
{
ServerObjectException objEx = (ServerObjectException)this.GetException(MethodBase.GetCurrentMethod(), ex);
throw objEx;
}
}
static void Main(string[] args)
{
ArrayList arrayList = new ArrayList();
arrayList.Add("agnaldo");
arrayList.Add(1);
arrayList.Add(10.1205);
Console.WriteLine(arrayList.Count);
foreach (var item in arrayList)
Console.WriteLine(item);
Console.WriteLine();
List<int> list = new List<int>();
list.Add(1);
list.Add(11);
list.Add(11);
list.Add(11);
list.Add(11);
list.Add(111);
//list.Add(11.11);
Console.WriteLine(list.Count);
foreach (var item in list)
Console.WriteLine(item);
Console.ReadKey();
}
public ArrayList GetDataByDealer(int id)
{
SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=egas;Integrated Security=True;Pooling=False");
SqlDataAdapter da = new SqlDataAdapter("select * from customer", con);
DataSet ds = new DataSet();
da.Fill(ds, "customer");
ArrayList arr = new ArrayList();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if ((int.Parse(dr[10].ToString()) != id)||(dr[13].ToString() == "PENDING" ))
{
dr.Delete();
continue;
}
}
arr.Add(da);
arr.Add(ds);
return arr;
}
public DataTable GetByCriteria(IEntityBase value)
{
EConcepRemu objE = (EConcepRemu)value;
try
{
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, objE.IdEmpresa));
arrPrm.Add(DataHelper.CreateParameter("@pidConRemu", SqlDbType.Char, 3, objE.IdConRemu));
arrPrm.Add(DataHelper.CreateParameter("@pdsConRemu", SqlDbType.VarChar, 50, objE.DsConRemu));
arrPrm.Add(DataHelper.CreateParameter("@pidTipConcep", SqlDbType.Char, 3, objE.IdTipConcep));
arrPrm.Add(DataHelper.CreateParameter("@pstCtaCte", SqlDbType.Char, 1, objE.StCtaCte));
DataTable dt = this.ExecuteDatatable("RH_ConcepRemu_qry01", arrPrm);
return dt;
}
catch (Exception ex)
{
ServerObjectException objEx = (ServerObjectException)this.GetException(MethodBase.GetCurrentMethod(), ex);
throw objEx;
}
}
public string GenNewCode(IEntityBase value)
{
ETablaCorre objE = (ETablaCorre)value;
try
{
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DataHelper.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, objE.IdPeriodo));
arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, objE.IdEmpresa));
arrPrm.Add(DataHelper.CreateParameter("@pidTabla", SqlDbType.VarChar, 25, objE.IdTabla));
DataTable dt = this.ExecuteDatatable("SY_TablaCorre_mnt10", arrPrm);
int intCode = 0;
string strFmt = "";
foreach (DataRow dr in dt.Rows)
{
intCode = Convert.ToInt32(dr[0]);
strFmt = dr[1].ToString();
}
return intCode.ToString(strFmt);
}
catch (Exception ex)
{
ServerObjectException objEx = (ServerObjectException)this.GetException(MethodBase.GetCurrentMethod(), ex);
throw objEx;
}
}
public int Delete(IEntityBase value)
{
ETablaCorre objE = (ETablaCorre)value;
try
{
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DataHelper.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, objE.IdPeriodo));
arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, objE.IdEmpresa));
arrPrm.Add(DataHelper.CreateParameter("@pidTabla", SqlDbType.VarChar, 10, objE.IdTabla));
int intRes = this.ExecuteNonQuery("SY_TablaCorre_mnt03", arrPrm);
return intRes;
}
catch (Exception ex)
{
ServerObjectException objEx = (ServerObjectException)this.GetException(MethodBase.GetCurrentMethod(), ex);
throw objEx;
}
}
public void Call()
{
AbstractMachineState state = new AbstractMachineState(new AMFactory());
ArrayList prog = new ArrayList();
prog.Add(new PutConstantInstruction());
prog.Add(new HaltInstruction());
state.Initialize(prog);
AMProgram program = (AMProgram)state.Program;
ProgramClause clause = new ProgramClause("male", 2);
program.AddLabel("male/2", clause);
CallInstruction i = new CallInstruction();
object[] args = { "male", "2" };
i.Process(args);
i.Execute(state);
Assert.AreEqual("call", i.Name());
Assert.AreEqual(2, i.NumberOfArguments());
Assert.AreSame(clause, program.P);
Assert.AreEqual("halt", program.CP.Instruction.Name());
}
public DataSet PRC_DocumentosCabeceraPersonasDirecciones()
{
ArrayList Parameters=new ArrayList(0);
SqlParameter MODOParameter=new SqlParameter("@MODO",SqlDbType.Int);
MODOParameter.Size=0;
MODOParameter.Value=MODO;
Parameters.Add(MODOParameter);
SqlParameter DocumentosCabeceraPersonasDirecciones_IDParameter=new SqlParameter("@DocumentosCabeceraPersonasDirecciones_ID",SqlDbType.Int);
DocumentosCabeceraPersonasDirecciones_IDParameter.Size=0;
DocumentosCabeceraPersonasDirecciones_IDParameter.Value=DocumentosCabeceraPersonasDirecciones_ID;
Parameters.Add(DocumentosCabeceraPersonasDirecciones_IDParameter);
SqlParameter FechaParameter=new SqlParameter("@Fecha",SqlDbType.DateTime);
FechaParameter.Size=0;
FechaParameter.Value=Fecha;
Parameters.Add(FechaParameter);
SqlParameter DocumentosCabecera_IDParameter=new SqlParameter("@DocumentosCabecera_ID",SqlDbType.Int);
DocumentosCabecera_IDParameter.Size=0;
DocumentosCabecera_IDParameter.Value=DocumentosCabecera_ID;
Parameters.Add(DocumentosCabecera_IDParameter);
SqlParameter PersonasDirecciones_IDParameter=new SqlParameter("@PersonasDirecciones_ID",SqlDbType.Int);
PersonasDirecciones_IDParameter.Size=0;
PersonasDirecciones_IDParameter.Value=PersonasDirecciones_ID;
Parameters.Add(PersonasDirecciones_IDParameter);
DataSet dsResult=ExecuteStoredProcedure("[Grifo].[PRC_DocumentosCabeceraPersonasDirecciones]",ref Parameters);
return dsResult;
}
public void MaxSize()
{
IKernel kernel = new DefaultKernel();
kernel.AddComponent("a", typeof(PoolableComponent1));
ArrayList instances = new ArrayList();
instances.Add(kernel["a"] as PoolableComponent1);
instances.Add(kernel["a"] as PoolableComponent1);
instances.Add(kernel["a"] as PoolableComponent1);
instances.Add(kernel["a"] as PoolableComponent1);
instances.Add(kernel["a"] as PoolableComponent1);
PoolableComponent1 other1 = kernel["a"] as PoolableComponent1;
Assert.IsNotNull(other1);
Assert.IsTrue(!instances.Contains(other1));
foreach(object inst in instances)
{
kernel.ReleaseComponent(inst);
}
kernel.ReleaseComponent(other1);
PoolableComponent1 other2 = kernel["a"] as PoolableComponent1;
Assert.IsNotNull(other2);
Assert.IsTrue(other1 != other2);
Assert.IsTrue(instances.Contains(other2));
kernel.ReleaseComponent(other2);
}
/// <summary>
/// Crea Horas Para Subsidio
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public int CrearHorasSubsidio(IEntityBase value)
{
EProcPlaCalc objE = (EProcPlaCalc)value;
try
{
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DataHelper.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, objE.IdPeriodo));
arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, objE.IdEmpresa));
arrPrm.Add(DataHelper.CreateParameter("@pidPlanilla", SqlDbType.Char, 3, objE.IdPlanilla));
arrPrm.Add(DataHelper.CreateParameter("@pidForPago", SqlDbType.Char, 3, objE.IdForPago));
arrPrm.Add(DataHelper.CreateParameter("@pnuProcAnual", SqlDbType.SmallInt, objE.NuProcAnual));
int intRes = this.ExecuteNonQuery("RH_ProcPlaCalc_ope08", arrPrm);
return intRes;
}
catch (Exception ex)
{
ServerObjectException objEx = (ServerObjectException)this.GetException(MethodBase.GetCurrentMethod(), ex);
throw objEx;
}
}
public DataTable GetByCriteria(IEntityBase value)
{
EEmpPeriodo objE = (EEmpPeriodo) value;
try
{
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char,3, objE.IdEmpresa));
arrPrm.Add(DataHelper.CreateParameter("@pidPeriodo", SqlDbType.Char,4, objE.IdPeriodo));
DataTable dt = this.ExecuteDatatable("SY_EmpPeriodo_qry01", arrPrm);
return dt;
}
catch(Exception ex)
{
ServerObjectException objEx = (ServerObjectException) this.GetException(MethodBase.GetCurrentMethod(), ex);
throw objEx;
}
}
public bool isPHPReady()
{
if (!File.Exists(var.strPHPTemplateConfigFilePath))
{
MessageBox.Show("The PHP template file, " + var.strPHPTemplateConfigFilePath + " cannot be found");
return false;
}
/*if (!File.Exists(var.strPHPTSConfigFilePath))
{
MessageBox.Show("The PHP configuration file, " + var.strPHPTSConfigFilePath + " cannot be found");
return false;
}
if (!File.Exists(var.strPHPNTSConfigFilePath))
{
MessageBox.Show("The PHP configuration file, " + var.strPHPNTSConfigFilePath + " cannot be found");
return false;
}*/
// Thread-safe PHP config
ArrayList alReplace = new ArrayList();
alReplace.Add(new string[]{";%INCLUDE_PATH%", "include_path=\".;"+var.strPHPTSFolderPath+"\\pear\""});
alReplace.Add(new string[]{"%EXTDIR%", Path.Combine(var.strPHPTSFolderPath, "ext")});
File.WriteAllText(var.strPHPTSConfigFilePath, var.replaceText(File.ReadAllText(var.strPHPTemplateConfigFilePath),alReplace));
// Non thread-safe PHP config
alReplace.Clear();
alReplace.Add(new string[]{";%INCLUDE_PATH%", "include_path=\".;"+var.strPHPNTSFolderPath+"\\pear\""});
alReplace.Add(new string[]{"%EXTDIR%", Path.Combine(var.strPHPNTSFolderPath, "ext")});
File.WriteAllText(var.strPHPNTSConfigFilePath, var.replaceText(File.ReadAllText(var.strPHPTemplateConfigFilePath),alReplace));
Environment.SetEnvironmentVariable("PHP_FCGI_MAX_REQUESTS",var.getString("PHP","numPHPRequests"));
return true;
}
public DataSet PRC_ProcesosCategrias()
{
ArrayList Parameters=new ArrayList(0);
SqlParameter MODOParameter=new SqlParameter("@MODO",SqlDbType.Int);
MODOParameter.Size=0;
MODOParameter.Value=MODO;
Parameters.Add(MODOParameter);
SqlParameter ProcesosCategrias_IDParameter=new SqlParameter("@ProcesosCategrias_ID",SqlDbType.Int);
ProcesosCategrias_IDParameter.Size=0;
ProcesosCategrias_IDParameter.Value=ProcesosCategrias_ID;
Parameters.Add(ProcesosCategrias_IDParameter);
SqlParameter Procesos_IDParameter=new SqlParameter("@Procesos_ID",SqlDbType.Int);
Procesos_IDParameter.Size=0;
Procesos_IDParameter.Value=Procesos_ID;
Parameters.Add(Procesos_IDParameter);
SqlParameter Categorias_IDParameter=new SqlParameter("@Categorias_ID",SqlDbType.Int);
Categorias_IDParameter.Size=0;
Categorias_IDParameter.Value=Categorias_ID;
Parameters.Add(Categorias_IDParameter);
DataSet dsResult=ExecuteStoredProcedure("[Grifo].[PRC_ProcesosCategrias]",ref Parameters);
return dsResult;
}
public DataTable GetByCriteria(IEntityBase value)
{
EPrestaCuota objE = (EPrestaCuota)value;
try
{
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, objE.IdEmpresa));
arrPrm.Add(DataHelper.CreateParameter("@pidPersonal", SqlDbType.Char, 7, objE.IdPersonal));
arrPrm.Add(DataHelper.CreateParameter("@pidPrestamo", SqlDbType.Char, 4, objE.IdPrestamo));
arrPrm.Add(DataHelper.CreateParameter("@pnuCuota", SqlDbType.SmallInt, objE.NuCuota));
DataTable dt = this.ExecuteDatatable("RH_PrestaCuota_qry01", arrPrm);
return dt;
}
catch (Exception ex)
{
ServerObjectException objEx = (ServerObjectException)this.GetException(MethodBase.GetCurrentMethod(), ex);
throw objEx;
}
}
public static string[] Split( string src, char delimiter, params char[] quotedelims )
{
ArrayList strings = new ArrayList();
StringBuilder sb = new StringBuilder();
ArrayList ar = new ArrayList(quotedelims);
char quote_open = Char.MinValue;
foreach (char c in src)
{
if (c == delimiter && quote_open == Char.MinValue)
{
strings.Add( sb.ToString() );
sb.Remove( 0, sb.Length );
}
else if (ar.Contains(c))
{
if (quote_open == Char.MinValue)
quote_open = c;
else if (quote_open == c)
quote_open = Char.MinValue;
sb.Append(c);
}
else
sb.Append( c );
}
if (sb.Length > 0)
strings.Add( sb.ToString());
return (string[])strings.ToArray(typeof(string));
}
static void Main(string[] args)
{
IList list1 = new ArrayList();
list1.Add("Hello, ");
list1.Add("my ");
list1.Add("dear ");
list1.Add("old ");
list1.Add("friend! ");
IList list2 = new ArrayList();
list2.Add("my ");
list2.Add("dear ");
list2.Add("old ");
foreach (var value in list2)
{
while (list1.Contains(value))
{
list1.Remove(value);
}
}
foreach (var v in list1)
{
Console.Write(v);
}
}
public DataSet PRC_ArticulosMarcas()
{
ArrayList Parameters=new ArrayList(0);
SqlParameter MODOParameter=new SqlParameter("@MODO",SqlDbType.Int);
MODOParameter.Size=0;
MODOParameter.Value=MODO;
Parameters.Add(MODOParameter);
SqlParameter ArticulosMarcas_IDParameter=new SqlParameter("@ArticulosMarcas_ID",SqlDbType.Int);
ArticulosMarcas_IDParameter.Size=0;
ArticulosMarcas_IDParameter.Value=ArticulosMarcas_ID;
Parameters.Add(ArticulosMarcas_IDParameter);
SqlParameter Articulos_IDParameter=new SqlParameter("@Articulos_ID",SqlDbType.Int);
Articulos_IDParameter.Size=0;
Articulos_IDParameter.Value=Articulos_ID;
Parameters.Add(Articulos_IDParameter);
SqlParameter Marcas_IDParameter=new SqlParameter("@Marcas_ID",SqlDbType.Int);
Marcas_IDParameter.Size=0;
Marcas_IDParameter.Value=Marcas_ID;
Parameters.Add(Marcas_IDParameter);
DataSet dsResult=ExecuteStoredProcedure("[Grifo].[PRC_ArticulosMarcas]",ref Parameters);
return dsResult;
}
//rewritten by Corillian so if it doesn't work you know who to yell at ;)
public void HandlePacket(GameClient client, GSPacketIn packet)
{
byte grouped = (byte)packet.ReadByte();
ArrayList list = new ArrayList();
if (grouped != 0x00)
{
ArrayList groups = GroupMgr.ListGroupByStatus(0x00);
if (groups != null)
{
foreach (Group group in groups)
if (GameServer.ServerRules.IsAllowedToGroup(group.Leader, client.Player, true))
{
list.Add(group.Leader);
}
}
}
ArrayList Lfg = GroupMgr.LookingForGroupPlayers();
if (Lfg != null)
{
foreach (GamePlayer player in Lfg)
{
if (player != client.Player && GameServer.ServerRules.IsAllowedToGroup(client.Player, player, true))
{
list.Add(player);
}
}
}
client.Out.SendFindGroupWindowUpdate((GamePlayer[])list.ToArray(typeof(GamePlayer)));
}
private static ArrayList CreateSeparatedSite(String site)
{
if (site == null || site.Length == 0)
{
throw new ArgumentException( Environment.GetResourceString("Argument_InvalidSite" ));
}
Contract.EndContractBlock();
ArrayList list = new ArrayList();
int braIndex = -1;
int ketIndex = -1;
braIndex = site.IndexOf('[');
if (braIndex == 0)
ketIndex = site.IndexOf(']', braIndex+1);
if (ketIndex != -1)
{
// Found an IPv6 address. Special case that
String ipv6Addr = site.Substring(braIndex+1, ketIndex-braIndex-1);
list.Add(ipv6Addr);
return list;
}
// Regular hostnames or IPv4 addresses
// We dont need to do this for IPv4 addresses, but it's easier to do it anyway
String[] separatedArray = site.Split( m_separators );
for (int index = separatedArray.Length-1; index > -1; --index)
{
if (separatedArray[index] == null)
{
throw new ArgumentException( Environment.GetResourceString("Argument_InvalidSite" ));
}
else if (separatedArray[index].Equals( "" ))
{
if (index != separatedArray.Length-1)
{
throw new ArgumentException( Environment.GetResourceString("Argument_InvalidSite" ));
}
}
else if (separatedArray[index].Equals( "*" ))
{
if (index != 0)
{
throw new ArgumentException( Environment.GetResourceString("Argument_InvalidSite" ));
}
list.Add( separatedArray[index] );
}
else if (!AllLegalCharacters( separatedArray[index] ))
{
throw new ArgumentException( Environment.GetResourceString("Argument_InvalidSite" ));
}
else
{
list.Add( separatedArray[index] );
}
}
return list;
}
static void Main(string[] args)
{
//ArrayList
ArrayList arrayList = new ArrayList();
arrayList.Add("First item");
arrayList.Add(5);
arrayList.Add('c');
foreach (var item in arrayList) {
Console.WriteLine("Element of arrayList: {0}", item);
}
//HashTable
Hashtable hashtable = new Hashtable();
hashtable.Add(0, "Zero item");
hashtable[1] = "First item";
hashtable["2"] = "Second item";
hashtable[Guid.NewGuid()] = "Third item";
ICollection keys = hashtable.Keys;
foreach (var key in keys)
{
Console.WriteLine("Key: {0}, Value: {1}", key, hashtable[key]);
}
//SortedList
SortedList sl = new SortedList();
sl.Add("007", "Ritesh Saikia");
sl.Add("001", "Zara Ali");
sl.Add("002", "Abida Rehman");
sl.Add("003", "Joe Holzner");
sl.Add("004", "Mausam Benazir Nur");
sl.Add("006", "M. Amlan");
sl.Add("005", "M. Arif");
ICollection slValues = sl.Values;
foreach (var s in slValues) {
Console.WriteLine("SortedList value: {0}", s);
}
//Queue is FIFO: First in First out
Queue que = new Queue();
que.Enqueue("Student_1");
que.Enqueue(5);
que.Enqueue("Student_2");
que.Enqueue("Student_3");
Console.WriteLine(que.Dequeue().ToString());
Console.WriteLine(que.Dequeue().ToString());
// Stack is FILO: First in Last out
Stack StackPop = new Stack();
StackPop.Push("Student_1");
StackPop.Push("Student_2");
StackPop.Push("Student_3");
Console.WriteLine(StackPop.Pop().ToString());
Console.WriteLine(StackPop.Pop().ToString());
Console.ReadLine();
}
private void buttonTSSave_Click(object sender, EventArgs e)
{
var res = MessageBox.Show(I18N.GetValue("Make sure you have read the help before clicking OK!"), "Warning!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (res != DialogResult.OK)
{
return;
}
JavaScriptSerializer js = new JavaScriptSerializer();
//mux
currentProfile.muxSettings["enabled"] = checkBoxMuxEnable.Checked;
currentProfile.muxSettings["concurrency"] = Program.strToInt(textBoxMuxCc.Text, 8);
//proxy
//currentProfile.proxyOutboundJson = checkBoxProxy.Checked ? textBoxOutProxyJson.Text : "";
//streamSettings
currentProfile.streamSettings["security"] = checkBoxTLSEnable.Checked ? "tls" : "none";
//tls
currentProfile.streamSettings["tlsSettings"] = new Dictionary <string, object> {
{ "serverName", textBoxTLSSn.Text },
{ "allowInsecure", checkBoxTLSAI.Checked },
};
currentProfile.streamSettings["kcpSettings"] = new Dictionary <string, object> {
{ "mtu", Program.strToInt(textBoxKcpMtu.Text, 1350) },
{ "tti", Program.strToInt(textBoxKcpTti.Text, 20) },
{ "uplinkCapacity", Program.strToInt(textBoxKcpUc.Text, 5) },
{ "downlinkCapacity", Program.strToInt(textBoxKcpDc.Text, 20) },
{ "congestion", comboBoxKcpCon.SelectedIndex == 1 },
{ "readBufferSize", Program.strToInt(textBoxKcpRb.Text, 1) },
{ "writeBufferSize", Program.strToInt(textBoxKcpWb.Text, 1) },
{ "header", new Dictionary <string, object> {
{ "type", comboBoxKcpHt.SelectedItem.ToString() }
} }
};
currentProfile.streamSettings["tcpSettings"] = new Dictionary <string, object> {
{ "header", checkBoxTcpHeader.Checked ?
js.Deserialize <object>(textBoxTcpHeader.Text)
: new Dictionary <string, string> {
{ "type", "none" }
} }
};
currentProfile.streamSettings["wsSettings"] = new Dictionary <string, object> {
{ "path", textBoxWsPath.Text },
{ "headers", js.Deserialize <object>(textBoxWsHeader.Text) }
};
var hosts = textBoxHttp2Hosts.Text.Split(',');
var hosts_filtered = new System.Collections.ArrayList();
foreach (var h in hosts)
{
var h_trimed = h.Trim();
if (h_trimed.Length > 0)
{
hosts_filtered.Add(h_trimed);
}
}
currentProfile.streamSettings["httpSettings"] = new Dictionary <string, object> {
{ "host", hosts_filtered },
{ "path", textBoxHttp2Path.Text.Trim() }
};
this.Close();
}
protected void EditFullDayBookings()
{
DateTime? old_date = UrlEditFullDay_OldDate;
DateTime? new_date = UrlEditFullDay_NewDate;
Organisation old_org = UrlEditFullDay_OldOrg;
Organisation new_org = UrlEditFullDay_NewOrg;
Staff old_prov = UrlEditFullDay_OldProvider;
Staff new_prov = UrlEditFullDay_NewProvider;
if (old_date == null)
{
throw new Exception("Invalid url field editfullday_old_date");
}
if (new_date == null)
{
throw new Exception("Invalid url field editfullday_new_date");
}
if (old_org == null)
{
throw new Exception("Invalid url field editfullday_old_org");
}
if (new_org == null)
{
throw new Exception("Invalid url field editfullday_new_org");
}
if (old_prov == null)
{
throw new Exception("Invalid url field editfullday_old_provider");
}
if (new_prov == null)
{
throw new Exception("Invalid url field editfullday_new_provider");
}
// get all bookings from that day/staff/org
// check each for clash
bool hasClash = false;
System.Collections.ArrayList clashes = new System.Collections.ArrayList();
Booking[] daysBookingList = BookingDB.GetBetween(old_date.Value, old_date.Value.AddDays(1), new Staff[] { old_prov }, new Organisation[] { old_org }, null, null, false, "0", false);
// remove any 34 types not for this org
System.Collections.ArrayList tmp = new System.Collections.ArrayList();
foreach (Booking booking in daysBookingList)
{
if (booking.BookingTypeID != 34 || (booking.Organisation.OrganisationID == old_org.OrganisationID && booking.Provider.StaffID == old_prov.StaffID))
{
tmp.Add(booking);
}
}
daysBookingList = (Booking[])tmp.ToArray(typeof(Booking));
foreach (Booking booking in daysBookingList)
{
DateTime newDateStart = new_date.Value.AddHours(booking.DateStart.Hour).AddMinutes(booking.DateStart.Minute).AddSeconds(booking.DateStart.Second);
DateTime newDateEnd = new_date.Value.AddHours(booking.DateEnd.Hour).AddMinutes(booking.DateEnd.Minute).AddSeconds(booking.DateEnd.Second);
Booking[] bookings = BookingDB.GetToCheckOverlap_OneTime(newDateStart, newDateEnd, new_prov, null, true, true, true, new Booking[] { booking });
// remove any non 34 types (unavailabilities) for other orgs
tmp = new System.Collections.ArrayList();
foreach (Booking bk in bookings)
{
if (bk.Organisation.OrganisationID == old_org.OrganisationID || bk.BookingTypeID == 34)
{
tmp.Add(bk);
}
}
bookings = (Booking[])tmp.ToArray(typeof(Booking));
if (Booking.HasOverlap(bookings, newDateStart, newDateEnd, booking))
{
hasClash = true;
clashes.Add(booking.DateStart.ToString("yyyy-MM-dd HH:mm") + (booking.Patient == null ? "" : " " + booking.Patient.Person.FullnameWithoutMiddlename));
//break;
}
}
if (hasClash)
{
string clashesString = string.Empty;
foreach (string s in clashes)
{
clashesString += (clashesString.Length == 0 ? "" : "\r\n") + s;
}
throw new CustomMessageException("There are clashes that need to be moved first:\r\n\r\nThese are unable to be moved:\r\n" + clashesString);
}
foreach (Booking booking in daysBookingList)
{
if (booking.BookingTypeID != 34)
{
continue;
}
DateTime newDateStart = new_date.Value.AddHours(booking.DateStart.Hour).AddMinutes(booking.DateStart.Minute).AddSeconds(booking.DateStart.Second);
DateTime newDateEnd = new_date.Value.AddHours(booking.DateEnd.Hour).AddMinutes(booking.DateEnd.Minute).AddSeconds(booking.DateEnd.Second);
int bookingChangeHistoryReason = 276; // 276 = Admininstration reschedule needs
BookingChangeHistoryDB.Insert(booking.BookingID, GetStaffID(), bookingChangeHistoryReason, booking.DateStart);
BookingDB.Update(booking.BookingID, newDateStart, newDateEnd, new_org.OrganisationID, new_prov.StaffID, booking.Patient == null ? -1 : booking.Patient.PatientID, booking.Offering == null ? -1 : booking.Offering.OfferingID,
booking.BookingTypeID, booking.BookingStatus.ID, -1, booking.AddedBy.StaffID, booking.BookingConfirmedByType == null ? -1 : booking.BookingConfirmedByType.ID, booking.ConfirmedBy == null ? -1 : booking.ConfirmedBy.StaffID, booking.DateConfirmed,
booking.DeletedBy == null ? -1 : booking.DeletedBy.StaffID, booking.DateDeleted,
booking.CancelledBy == null ? -1 : booking.CancelledBy.StaffID, booking.DateCancelled,
booking.IsPatientMissedAppt, booking.IsProviderMissedAppt, booking.IsEmergency, booking.IsRecurring, booking.RecurringDayOfWeek, booking.RecurringStartTime, booking.RecurringEndTime);
}
}
public static string MiCalculo(double inversion, double[] FNE, int[] Anio, double VdS, double TMAR, int Select, int n)
{
int negativos, Periodo = n;
double num;
System.Collections.ArrayList ListaFinal = new System.Collections.ArrayList();
System.Collections.ArrayList ResultadoVPNArray = new System.Collections.ArrayList();
System.Collections.ArrayList ResultadoVAN = new System.Collections.ArrayList();
System.Collections.ArrayList ResultadoTIR = new System.Collections.ArrayList();
System.Collections.ArrayList ListaX = new System.Collections.ArrayList();
System.Collections.ArrayList ListaY = new System.Collections.ArrayList();
System.Collections.ArrayList PeriodoSelect = new System.Collections.ArrayList();
double ResultadoVPN, RCalcuTIR;
double [] valores = new double[Anio.Length];
for (int a = 1; a <= Anio.Length; a++)
{
for (int b = 0; b < Anio.Length; b++)
{
if (a == Anio[b])
{
valores[a - 1] = FNE[b];
break;
}
}
}
FNE = valores;
/* System.Diagnostics.Debug.WriteLine(PeriodoSelect); Linea de codigo para ver en consola las cosas */
ResultadoVPN = CalcularVPN(inversion, FNE, VdS, TMAR / 100, n);
ResultadoVPNArray.Add(ResultadoVPN);
ListaFinal.Add(ResultadoVPNArray);
ResultadoVAN.Add("$" + ResultadoVPN.ToString("0,0.0000"));
List <double> resultados = CalcularTIR(inversion, FNE, VdS, n);
RCalcuTIR = resultados[0];
ResultadoTIR.Add((RCalcuTIR).ToString("0,0.00000000") + " %");
ListaFinal.Add(ResultadoVAN);
ListaFinal.Add(ResultadoTIR);
TMAR = RCalcuTIR / 20;
double TMAR2 = Math.Round(RCalcuTIR, 4);
int contador = 0;
int pos = 0;
do
{
ListaX.Add(Math.Round(TMAR, 4));
ListaY.Add(Math.Round(CalcularVPN(inversion, FNE, VdS, TMAR / 100, n), 4));
negativos = 0;
foreach (var item in ListaY)
{
num = Convert.ToDouble(item);
if (num < 0)
{
negativos++;
}
}
if (TMAR2 == Math.Round(TMAR, 4))
{
pos = contador;
}
TMAR = TMAR + (RCalcuTIR / 20); // Cantidad de saltos de los puntos en el eje X
contador++;
} while (negativos < 5); // Solo 5 numeros negativos despues del cruce con 0 en el eje x
ListaFinal.Add(ListaX);
ListaFinal.Add(ListaY);
if (1 == Select)
{
PeriodoSelect.Add("Mes");
}
else
{
PeriodoSelect.Add("Año");
}
ListaFinal.Add(PeriodoSelect);
ListaFinal.Add(pos);
ListaFinal.Add(RCalcuTIR);
if (resultados[1] == 0)
{
ListaFinal.Add("$ " + resultados[1]);
}
else
{
string formattedString = "$" + String.Format("{0:N35}", resultados[1]);
ListaFinal.Add(formattedString);
}
String json = JsonConvert.SerializeObject(ListaFinal);
return(json);
}
/// <summary>
/// Creates a <see cref="CommandLineArguments"/> object to parse
/// command lines.
/// </summary>
/// <param name="args">The command line to parse.</param>
internal CommandLineArguments(string[] args)
{
Regex splitter = new Regex(@"^-{1,2}|^/|=|:",
RegexOptions.IgnoreCase | RegexOptions.Compiled);
Regex remover = new Regex(@"^['""]?(.*?)['""]?$",
RegexOptions.IgnoreCase | RegexOptions.Compiled);
string parameter = null;
string[] parts;
// Valid parameters forms:
// {-,/,--}param{ ,=,:}((",')value(",'))
// Examples: -param1 value1 --param2 /param3:"Test-:-work"
// /param4=happy -param5 '--=nice=--'
foreach (string str in args)
{
// Do we have a parameter (starting with -, /, or --)?
if (str.StartsWith("-") || str.StartsWith("/"))
{
// Look for new parameters (-,/ or --) and a possible
// enclosed value (=,:)
parts = splitter.Split(str, 3);
switch (parts.Length)
{
// Found a value (for the last parameter found
// (space separator))
case 1:
if (parameter != null)
{
if (!namedParameters.ContainsKey(parameter))
{
parts[0] =
remover.Replace(parts[0], "$1");
namedParameters.Add(
parameter, parts[0]);
}
parameter = null;
}
// else Error: no parameter waiting for a value
// (skipped)
break;
// Found just a parameter
case 2:
// The last parameter is still waiting. With no
// value, set it to true.
if (parameter != null)
{
if (!namedParameters.ContainsKey(parameter))
{
namedParameters.Add(parameter, "true");
}
}
parameter = parts[1];
break;
// parameter with enclosed value
case 3:
// The last parameter is still waiting. With no
// value, set it to true.
if (parameter != null)
{
if (!namedParameters.ContainsKey(parameter))
{
namedParameters.Add(parameter, "true");
}
}
parameter = parts[1];
// Remove possible enclosing characters (",')
if (!namedParameters.ContainsKey(parameter))
{
parts[2] = remover.Replace(parts[2], "$1");
namedParameters.Add(parameter, parts[2]);
}
parameter = null;
break;
}
}
else
{
unnamedParameters.Add(str);
}
}
// In case a parameter is still waiting
if (parameter != null)
{
if (!namedParameters.ContainsKey(parameter))
{
namedParameters.Add(parameter, "true");
}
}
}
public static double GetEstimatedNumOfLeaveDays(DatabaseConnection dbConn, int EmpID, DateTime DateFrom, DateTime DateTo, int LeaveCodeID, out DateTime[] DateSkipArray)
{
System.Collections.ArrayList dateSkipArrayList = new System.Collections.ArrayList();
EEmpPositionInfo empPos = null;
double totalDays = 0;
ELeaveType leaveType = new ELeaveType();
leaveType.LeaveTypeIsUseWorkHourPattern = true;
ELeaveCode leaveCode = new ELeaveCode();
leaveCode.LeaveCodeID = LeaveCodeID;
if (ELeaveCode.db.select(dbConn, leaveCode))
{
leaveType.LeaveTypeID = leaveCode.LeaveTypeID;
ELeaveType.db.select(dbConn, leaveType);
}
for (DateTime currentDate = DateFrom; currentDate <= DateTo; currentDate = currentDate.AddDays(1))
{
// default every date count = 1
double dateCount = 1;
if (EStatutoryHoliday.IsHoliday(dbConn, currentDate))
{
if (!leaveType.LeaveTypeIsSkipStatutoryHolidayChecking)
{
dateCount = 0;
}
}
else if (EPublicHoliday.IsHoliday(dbConn, currentDate))
{
if (!leaveType.LeaveTypeIsSkipPublicHolidayChecking)
{
dateCount = 0;
}
}
if (empPos == null)
{
empPos = AppUtils.GetLastPositionInfo(dbConn, currentDate, EmpID);
}
else
if (!empPos.EmpPosEffTo.Ticks.Equals(0) && empPos.EmpPosEffTo <= currentDate)
{
empPos = AppUtils.GetLastPositionInfo(dbConn, currentDate, EmpID);
}
if (empPos != null)
{
EWorkHourPattern workPattern = new EWorkHourPattern();
workPattern.WorkHourPatternID = empPos.WorkHourPatternID;
if (EWorkHourPattern.db.select(dbConn, workPattern))
{
if (leaveType.LeaveTypeIsUseWorkHourPattern)
{
dateCount = workPattern.GetDefaultDayUnit(dbConn, currentDate, leaveType.LeaveTypeIsSkipStatutoryHolidayChecking, leaveType.LeaveTypeIsSkipPublicHolidayChecking);
}
}
}
totalDays += dateCount;
if (dateCount <= 0)
{
dateSkipArrayList.Add(currentDate);
}
}
DateSkipArray = (DateTime[])dateSkipArrayList.ToArray(typeof(DateTime));
return(totalDays);
}
/// <summary>
/// 當查詢SQL以參數方式提供時，接著透過呼叫putQueryParameter設定各個參數值，最後再呼叫 prepareStatement()，完成查詢設定。
/// [Nick Young@20160825]
/// </summary>
public void putQueryParameter(string key, string value)
{
QueryParameterList.Add(new String[] { key, value });
}
protected void CheckClashOneTimeBooking()
{
UserView userView = UserView.GetInstance();
string org_id = Request.QueryString["org"];
string all_orgs = Request.QueryString["all_orgs"];
string staff_id = Request.QueryString["staff"];
string booking_id = Request.QueryString["edit_booking_id"];
string booking_type_id = Request.QueryString["booking_type_id"];
string start_datetime = Request.QueryString["start_datetime"];
string end_datetime = Request.QueryString["end_datetime"];
if (start_datetime == null || !Regex.IsMatch(start_datetime, @"^\d{4}_\d{2}_\d{2}_\d{4}$") ||
end_datetime == null || !Regex.IsMatch(end_datetime, @"^\d{4}_\d{2}_\d{2}_\d{4}$") ||
org_id == null || !Regex.IsMatch(org_id, @"^\-?\d+$") ||
staff_id == null || !Regex.IsMatch(staff_id, @"^\-?\d+$") ||
booking_id == null || !Regex.IsMatch(booking_id, @"^\-?\d+$"))
{
throw new CustomMessageException();
}
Organisation org = OrganisationDB.GetByID(Convert.ToInt32(org_id));
Staff staff = StaffDB.GetByID(Convert.ToInt32(staff_id));
Booking booking = booking_id == "-1" ? null : BookingDB.GetByID(Convert.ToInt32(booking_id));
if (booking != null && booking_type_id == "-1")
{
booking_type_id = booking.BookingTypeID.ToString();
}
if ((org_id != "0" && org == null) ||
(staff_id != "-1" && staff == null) ||
(booking_id != "-1" && booking == null) ||
(booking_type_id == null || (booking_type_id != "34" && booking_type_id != "340" && booking_type_id != "341" && booking_type_id != "342")))
{
throw new CustomMessageException();
}
DateTime startDateTime = ConvertStringToDateTime(start_datetime);
DateTime endDateTime = ConvertStringToDateTime(end_datetime);
// if pt logged in, disallow booking over unavailabilities, otherwise allow it and ignore the check
bool checkUnavailableDays = userView.IsPatient;
Booking[] bookings = (all_orgs != null && all_orgs == "1") ?
BookingDB.GetToCheckOverlap_OneTime(startDateTime, endDateTime, staff, null, booking_type_id == "342", true, checkUnavailableDays) :
BookingDB.GetToCheckOverlap_OneTime(startDateTime, endDateTime, staff, org, booking_type_id == "342", true, checkUnavailableDays);
if (bookings.Length > 0)
{
System.Collections.ArrayList list = new System.Collections.ArrayList();
for (int i = 0; i < bookings.Length; i++)
{
if ((bookings[i].Organisation == null || (org != null && bookings[i].Organisation.OrganisationID == org.OrganisationID)) &&
(bookings[i].Provider == null || bookings[i].Provider.StaffID == staff.StaffID))
{
list.Add(bookings[i]);
}
}
bookings = (Booking[])list.ToArray(typeof(Booking));
}
// for patient, disallow booking over start/end times when clinic unavailable
if (userView.IsPatient)
{
if (org == null)
{
org = booking.Organisation;
}
StartEndTime startEndTime = org.GetStartEndTime(startDateTime.DayOfWeek);
StartEndTime startEndLunchTime = org.GetStartEndLunchTime(startDateTime.DayOfWeek);
if ((startEndTime.StartTime < startEndTime.EndTime && startDateTime.TimeOfDay < endDateTime.TimeOfDay && !(startDateTime.TimeOfDay >= startEndTime.StartTime && endDateTime.TimeOfDay <= startEndTime.EndTime)) ||
(startEndLunchTime.StartTime < startEndLunchTime.EndTime && startDateTime.TimeOfDay < endDateTime.TimeOfDay && Booking.TimeIntersects(startEndLunchTime.StartTime, startEndLunchTime.EndTime, startDateTime.TimeOfDay, endDateTime.TimeOfDay)))
{
Response.Write("1");
return;
}
}
Response.Write(Booking.HasOverlap(bookings, startDateTime, endDateTime, booking) ? "1" : "0");
}
protected void CheckClashFullDayBookings()
{
string old_edit_date = Request.QueryString["editfullday_old_date"];
string old_edit_org_id = Request.QueryString["editfullday_old_org"];
string old_edit_provider_id = Request.QueryString["editfullday_old_provider"];
string new_edit_date = Request.QueryString["editfullday_new_date"];
string new_edit_org_id = Request.QueryString["editfullday_new_org"];
string new_edit_provider_id = Request.QueryString["editfullday_new_provider"];
if (old_edit_date == null || !Regex.IsMatch(old_edit_date, @"^\d{4}_\d{2}_\d{2}$") ||
new_edit_date == null || !Regex.IsMatch(new_edit_date, @"^\d{4}_\d{2}_\d{2}$") ||
old_edit_org_id == null || !Regex.IsMatch(old_edit_org_id, @"^\d+$") ||
new_edit_org_id == null || !Regex.IsMatch(new_edit_org_id, @"^\d+$") ||
old_edit_provider_id == null || !Regex.IsMatch(old_edit_provider_id, @"^\d+$") ||
new_edit_provider_id == null || !Regex.IsMatch(new_edit_provider_id, @"^\d+$"))
{
throw new CustomMessageException();
}
DateTime oldEditDateTime = ConvertStringToDateTime(old_edit_date + "_0000");
DateTime newEditDateTime = ConvertStringToDateTime(new_edit_date + "_0000");
Organisation oldOrg = OrganisationDB.GetByID(Convert.ToInt32(old_edit_org_id));
Organisation newOrg = OrganisationDB.GetByID(Convert.ToInt32(new_edit_org_id));
Staff oldStaff = StaffDB.GetByID(Convert.ToInt32(old_edit_provider_id));
Staff newStaff = StaffDB.GetByID(Convert.ToInt32(new_edit_provider_id));
if (oldOrg == null ||
newOrg == null ||
oldStaff == null ||
newStaff == null)
{
throw new CustomMessageException();
}
// get all bookings from that day/staff/org
// check each for clash
bool hasClash = false;
Booking[] daysBookingList = BookingDB.GetBetween(oldEditDateTime, oldEditDateTime.AddDays(1), new Staff[] { oldStaff }, new Organisation[] { oldOrg }, null, null, false, "0", false);
// remove any 34 types not for this org
System.Collections.ArrayList tmp = new System.Collections.ArrayList();
foreach (Booking booking in daysBookingList)
{
if (booking.BookingTypeID != 34 || (booking.Organisation.OrganisationID == oldOrg.OrganisationID && booking.Provider.StaffID == oldStaff.StaffID))
{
tmp.Add(booking);
}
}
daysBookingList = (Booking[])tmp.ToArray(typeof(Booking));
foreach (Booking booking in daysBookingList)
{
DateTime newDateStart = newEditDateTime.AddHours(booking.DateStart.Hour).AddMinutes(booking.DateStart.Minute).AddSeconds(booking.DateStart.Second);
DateTime newDateEnd = newEditDateTime.AddHours(booking.DateEnd.Hour).AddMinutes(booking.DateEnd.Minute).AddSeconds(booking.DateEnd.Second);
Booking[] bookings = BookingDB.GetToCheckOverlap_OneTime(newDateStart, newDateEnd, newStaff, null, true, true, true, new Booking[] { booking });
// remove any non 34 types (unavailabilities) for other orgs
tmp = new System.Collections.ArrayList();
foreach (Booking bk in bookings)
{
if (bk.Organisation.OrganisationID == oldOrg.OrganisationID || bk.BookingTypeID == 34)
{
tmp.Add(bk);
}
}
bookings = (Booking[])tmp.ToArray(typeof(Booking));
if (Booking.HasOverlap(bookings, newDateStart, newDateEnd, booking))
{
hasClash = true;
break;
}
}
Response.Write(hasClash ? "1" : "0");
}
public bool OpenProject(string strProject, string strUser, string strPassword,
out string strErrDiag)
{
strErrDiag = "";
bool bRet = false;
try
{
if (state != eState.stDisc)
{
CloseProject();
}
cb.ShowProgressOpenProject("Opening " + strProject);
rpxProject = (ReqPro40.Project___v7)rpxApplication.OpenProject(strProject,
ReqPro40.enumOpenProjectOptions.eOpenProjOpt_RQSFile,
strUser,
strPassword,
ReqPro40.enumProjectFlags.eProjFlag_Normal,
ReqPro40.enumRelatedProjectOptions.eRelatedProjOption_ConnectAll);
state = eState.stConn;
bRet = true;
ReqProRequirementPrx.HomePrjPrefix = rpxProject.Prefix;
int nCountRelPrj = rpxProject.RelatedProjectContexts.Count;
bool bLoadRelPrj;
string strRelPrjPassword;
string strRelPrjUser;
cb.ShowProgressOpenProject("Related Projects to be opened: " + nCountRelPrj);
ReqPro40.RelatedProjectContext rpxRelPrjCtx;
ReqPro40.Project___v7 rpxRelPrj;
for (int i = 0; i < nCountRelPrj; i++)
{
rpxRelPrjCtx = rpxProject.RelatedProjectContexts[i + 1, ReqPro40.enumRelatedProjectLookups.eRelProjLookup_Index];
bLoadRelPrj = true;
strRelPrjPassword = strPassword;
strRelPrjUser = strUser;
rpxRelPrj = null;
if (!rpxRelPrjCtx.IsOpen)
{
while (bLoadRelPrj)
{
try
{
cb.ShowProgressOpenProject("Opening: " + rpxRelPrjCtx.get_Name());
rpxRelPrj = (ReqPro40.Project___v7)rpxRelPrjCtx.OpenProject(strRelPrjUser, strRelPrjPassword);
cb.ShowProgressOpenProject("Opened: " + rpxRelPrj.Name);
}
catch (System.Runtime.InteropServices.COMException e)
{
bool bPasswordError;
unchecked
{
bPasswordError = (e.ErrorCode == (int)0x8004088b);
}
if (bPasswordError)
{
bLoadRelPrj = cb.RequestCredentials(rpxRelPrjCtx.get_Name(),
ref strRelPrjUser, out strRelPrjPassword);
}
else
{
bLoadRelPrj = false;
}
}
}
}
else
{
rpxRelPrj = (ReqPro40.Project___v7)rpxRelPrjCtx.ThisProject;
cb.ShowProgressOpenProject("Already opened: " + rpxRelPrj.Name);
}
if (rpxRelPrj != null)
{
arpxRelProjects.Add(rpxRelPrj);
}
}
}
catch (System.Runtime.InteropServices.COMException e)
{
strErrDiag = e.Message;
}
return(bRet);
}
public static int MainImpl(string[] args)
{
// Load defaults from app.config.
settings = new Settings();
// Were any command line args specified?
if (args.Length > 0)
{
// Override default settings with command line args.
CommandLine.Parse(args, settings);
}
else
{
// Obtain arguments from UI.
PromptForArgs dlg = new PromptForArgs(settings);
if (dlg.ShowDialog() != DialogResult.OK)
{
return(1);
}
}
// Validate arguments.
if (settings.FilePattern == null ||
settings.RegexPattern == null)
{
throw new ApplicationException("Please specify at least a pathspec and regex pattern.");
}
// Default basedir to cwd.
if (settings.BaseDirectory == null ||
settings.BaseDirectory == string.Empty)
{
settings.BaseDirectory = System.Environment.CurrentDirectory;
}
// Echo command line options.
Console.Write(@"Searching directory ""{0}"", files ""{1}"", for pattern ""{2}"" (options: ", settings.BaseDirectory, settings.FilePattern, settings.RegexPattern);
System.Collections.ArrayList optionstrings = new System.Collections.ArrayList();
if (settings.RegexIgnoreCase)
{
optionstrings.Add("IgnoreCase");
}
if (settings.RegexSingleline)
{
optionstrings.Add("Singleline");
}
if (settings.RegexMimicVS)
{
optionstrings.Add("RegexMimicVS");
}
if (settings.ActiveReplace)
{
optionstrings.Add("ActiveReplace");
}
if (settings.ReplacementText != null)
{
optionstrings.Add(String.Format("Replacement pattern: {0}", settings.ReplacementText));
}
if (optionstrings.Count == 0)
{
optionstrings.Add("none");
}
Console.Write(String.Join(", ", (string[])optionstrings.ToArray(typeof(string))));
Console.WriteLine(")");
Console.WriteLine();
// Reimplement VS7's helper patterns for things like C identifiers, numbers, string literals, etc.
if (settings.RegexMimicVS)
{
settings.RegexPattern = settings.RegexPattern.Replace("::", "\x3A");
settings.RegexPattern = settings.RegexPattern.Replace(":i", @"([_a-zA-Z][_a-zA-Z0-9]*)");
settings.RegexPattern = settings.RegexPattern.Replace(":n", @"(\b[-]?[0-9]+(\.[0-9]+([Ee](\+|-)?[0-9]+)?)?\b)");
settings.RegexPattern = settings.RegexPattern.Replace(":q", @"((@""(""""|[^""])*"")|(""(\\.|[^""\\])*""))");
}
// Create the regex, and populate the visitor callback with it.
RegexOptions ro = RegexOptions.Compiled | RegexOptions.Multiline;
if (settings.RegexIgnoreCase)
{
ro |= RegexOptions.IgnoreCase;
}
if (settings.RegexSingleline)
{
ro |= RegexOptions.Singleline;
}
FileVisitor visitor = new FileVisitor();
visitor.UserRegex = new Regex(settings.RegexPattern, ro);
visitor.ActiveReplace = settings.ActiveReplace;
visitor.ReplacementText = settings.ReplacementText;
visitor.BackupDirectory = settings.BackupDirectory;
visitor.OutputWidth = settings.OutputWidth;
// configure colours
visitor.DefaultColor = settings.DefaultColor;
visitor.FileDirectoryColor = settings.FileDirectoryColor;
visitor.FileNameColor = settings.FileNameColor;
visitor.LineNumberColor = settings.LineNumberColor;
visitor.SurroundingTextColor = settings.SurroundingTextColor;
visitor.MatchedTextColor = settings.MatchedTextColor;
visitor.ErrorColor = settings.ErrorColor;
visitor.SuppressError = settings.SuppressError;
// Do the dew!
Jitsu.IO.DirectoryTraverser.FileVisitor onFile =
new Jitsu.IO.DirectoryTraverser.FileVisitor(visitor.VisitFile);
Jitsu.IO.DirectoryTraverser spider =
new Jitsu.IO.DirectoryTraverser(null, onFile, settings.FileExclusions, settings.DirectoryExclusions, settings.IgnoreHiddenFiles, settings.IgnoreHiddenDirectories);
string directoryPattern = (settings.DontRecurse) ? "" : "*";
spider.TraverseBreadthFirst(settings.BaseDirectory, settings.FilePattern, directoryPattern);
// Report the results, in standard VS7 format.
Win32.TrySetConsoleColor(settings.DefaultColor);
// Console.WriteLine( "Total found: {0} Matching files: {1} Total files searched: {2}",
// visitor.MatchesFound, visitor.FilesFound, visitor.FilesSearched);
Console.WriteLine(
//"Total of {0} file{1} processed. Skipped {2} file{3}. Searched {4} file{5}. {6} match{7} found in {8} file{9}.",
"{6:#,###;;No} match{7} in {8:#,###;;zero} file{9}. " +
"Processed {0:#,###;;none}. Skipped {2:#,###;;none}. Searched {4:#,###;;none}.",
visitor.FilesProcessed,
visitor.FilesProcessed == 1 ? "" : "s",
visitor.FilesSkipped,
visitor.FilesSkipped == 1 ? "" : "s",
visitor.FilesSearched,
visitor.FilesSearched == 1 ? "" : "s",
visitor.MatchesFound,
visitor.MatchesFound == 1 ? "" : "es",
visitor.FilesFound,
visitor.FilesFound == 1 ? "" : "s"
);
// Done.
return(0);
}
public static string optimizacionFNE(double inversion, double[] FNE, double VS, int periodo, double tir, double porcentajeextraganancia)
{
System.Collections.ArrayList ListaFinal = new System.Collections.ArrayList();
int poblacionNumero = 1200;
List <double> FNEList = FNE.ToList();
double FNEMax = FNEList.Max();
double FNEMin = FNEList.Min();
double porcentajeFNEMax = FNEMax / 100;
double porcentajeFNEMin = FNEMin / 100;
FNEMax = FNEMax + (porcentajeFNEMax * porcentajeextraganancia);
FNEMin = FNEMin - (porcentajeFNEMin * porcentajeextraganancia);
List <List <double> > poblacion2 = new List <List <double> >();
Random random = new Random();
while (poblacion2.Count < poblacionNumero)
{
List <double> poblaciontem = new List <double>();
while (poblaciontem.Count < periodo)
{
double numeroAleatorio = random.NextDouble() * ((FNEMax + 1) - (FNEMin - 1)) + (FNEMin - 1);
if (!poblaciontem.Contains(numeroAleatorio))
{
poblaciontem.Add(numeroAleatorio);
}
}
poblacion2.Add(poblaciontem);
}
int j = 1;
double porcentajeconvergencia2 = 0;
double porcentaje2 = (((double)100) / poblacionNumero);
List <double> ResultadosFX2;
Random random2b = new Random();
do
{
ResultadosFX2 = fxFNE(inversion, poblacion2, VS, tir, periodo);
List <int> torneo1b = posTorneo(0, poblacion2.Count / 2);
List <int> torneo2b = posTorneo(poblacion2.Count / 2, poblacion2.Count);
List <List <double> > padre2 = SeleccionFNE(torneo1b, torneo2b, ResultadosFX2, poblacion2, FNEMax);
List <int> cruce1b = posTorneo(0, padre2.Count / 2);
List <int> cruce2b = posTorneo(padre2.Count / 2, padre2.Count);
List <List <double> > hijos_Generadosb = new List <List <double> >();
double probCruzb = random2b.NextDouble();
if (probCruzb < 0.9)
{
hijos_Generadosb = CruceTotal2(padre2, cruce1b, cruce2b, j);
}
else
{
hijos_Generadosb = padre2;
}
poblacion2.Clear();
poblacion2 = padre2.Concat(hijos_Generadosb).ToList();
poblacion2 = DesordenarLista(poblacion2);
//List<List<double>> poblacionanalisis = new List<List<double>>(poblacion2); permite pasar en otra lista
List <double> convergencia = medir_convergencia2(poblacion2);
var agrupacion = convergencia.OrderByDescending(o => o).ToList();
var agrupacion2 = agrupacion.GroupBy(x => x).Select(g => new { Text = g.Key, Count = g.Count() }).ToList();
var valormax = agrupacion.Max();
foreach (var el in agrupacion2)
{
if (el.Text == valormax && el.Count == 1)
{
double valor = Convert.ToDouble(el.Text);
porcentajeconvergencia2 = porcentaje2 * valor;
}
break;
}
if (porcentajeconvergencia2 < (double)99.9)
{
j = j + 1;
}
} while (porcentajeconvergencia2 < (double)99.9);
ListaFinal.Add(poblacion2[0]);
ListaFinal.Add(FNEList);
ListaFinal.Add(ResultadosFX2[0]);
ListaFinal.Add(tir);
String json = JsonConvert.SerializeObject(ListaFinal);
Thread.Sleep(450);
return(json);
}
public static string CreacionTabla(decimal inversion, decimal[] Costos, decimal[] Ingresos, decimal[] FNE, int[] AnioV, decimal VdS, decimal TMAR, int Select, int n)
{
System.Collections.ArrayList ListaFinal = new System.Collections.ArrayList();
System.Collections.ArrayList PeridoRec = new System.Collections.ArrayList();
System.Collections.ArrayList PeridoRecP2 = new System.Collections.ArrayList();
System.Collections.ArrayList BenCosto = new System.Collections.ArrayList();
decimal[] valores = new decimal[AnioV.Length];
decimal[] valores1 = new decimal[AnioV.Length];
decimal[] valores2 = new decimal[AnioV.Length];
for (int a = 1; a <= AnioV.Length; a++)
{
for (int b = 0; b < AnioV.Length; b++)
{
if (a == AnioV[b])
{
valores[a - 1] = Costos[b];
valores1[a - 1] = Ingresos[b];
valores2[a - 1] = FNE[b];
break;
}
}
}
Costos = valores;
Ingresos = valores1;
FNE = valores2;
String PeriodoSelect;
String PeridoRec2 = "";
String PeridoRec3 = "";
if (1 == Select)
{
PeriodoSelect = "Mes";
}
else
{
PeriodoSelect = "Año";
}
TMAR = TMAR / 100;
int Periodo = n;
String[,] ArregloDatos = new String[Periodo + 1, 8];
ArregloDatos[0, 3] = ArregloDatos[0, 4] = ArregloDatos[0, 5] = "";
ArregloDatos[0, 2] = "-" + inversion.ToString();
ArregloDatos[0, 7] = "-" + inversion.ToString();
for (int j = 0; j <= Periodo; j++)
{
ArregloDatos[j, 0] = Convert.ToString(j + 1);
}
for (int j = 0; j <= Periodo; j++)
{
ArregloDatos[j, 1] = PeriodoSelect + " " + Convert.ToString(j);
}
for (int j = 1; j <= Periodo; j++)
{
ArregloDatos[j, 2] = Convert.ToString(Costos[j - 1]);
}
for (int j = 1; j <= Periodo; j++)
{
ArregloDatos[j, 3] = Convert.ToString(Ingresos[j - 1]);
}
for (int j = 1; j <= Periodo; j++)
{
ArregloDatos[j, 4] = FNE[j - 1].ToString();
}
for (int j = 1; j <= Periodo; j++)
{
decimal IngresoActual = (Convert.ToDecimal(ArregloDatos[j, 3])) / Convert.ToDecimal(Math.Pow((double)(1 + TMAR), j));
ArregloDatos[j, 5] = Convert.ToString(Math.Round(IngresoActual, 3));
}
/*Calculo de periodo de recuperacion en funcion del ingreso actualizado en tabla*/
for (int i = 1; i <= Periodo; i++)
{
decimal x = Convert.ToDecimal(ArregloDatos[i - 1, 7]);
decimal ingresactualiza = Convert.ToDecimal(ArregloDatos[i, 5]);
ArregloDatos[i, 7] = Convert.ToString(x + ingresactualiza);
}
/*Calculo de periodo de recuperacion en funcion del ingreso actualizado en tabla*/
/*Calculo de periodo de recuperacion en tabla*/
ArregloDatos[0, 6] = ArregloDatos[0, 2];
for (int i = 1; i <= Periodo; i++)
{
decimal x = Convert.ToDecimal(ArregloDatos[i - 1, 6]);
decimal Flujoneto = Convert.ToDecimal(ArregloDatos[i, 4]);
ArregloDatos[i, 6] = Convert.ToString(x + Flujoneto);
}
ListaFinal.Add(ArregloDatos);
/*Calculo de periodo de recuperacion en tabla*/
/*Calculo de periodo de recuperacion*/
decimal P = inversion;
for (int i = 1; i <= Periodo; i++)
{
decimal x1 = Convert.ToDecimal(ArregloDatos[i, 6]);
if (x1 >= 0)
{
decimal x2 = Convert.ToDecimal(ArregloDatos[i - 1, 6]);
if (x2 < 0)
{
decimal Anio = Convert.ToDecimal(ArregloDatos[i - 1, 0]);
if (PeriodoSelect == "Mes")
{
decimal T1 = Math.Round(((P / ((x2 * -1M) + x1)) + (Anio - 1)), 3);
if (T1 > 1)
{
double valorConDecimal = (double)T1;
long valorSinDecimal = (long)valorConDecimal;
double decimales = Math.Round((valorConDecimal - (double)valorSinDecimal) * 12, 1);
PeridoRec2 = Convert.ToString(valorSinDecimal) + " " + PeriodoSelect + "es con " + decimales + " dia(s)";
}
else
{
double valorConDecimal = (double)T1;
long valorSinDecimal = (long)valorConDecimal;
double decimales = Math.Round((valorConDecimal - (double)valorSinDecimal) * 12, 1);
PeridoRec2 = Convert.ToString(valorSinDecimal) + " " + PeriodoSelect + " " + decimales + " dia(s)";
}
}
else
{
decimal T2 = Math.Round(((P / ((x2 * -1) + x1)) + (Anio - 1)), 3);
if (T2 > 1)
{
double valorConDecimal = (double)T2;
long valorSinDecimal = (long)valorConDecimal;
double decimales = Math.Round((valorConDecimal - (double)valorSinDecimal) * 12, 1);
PeridoRec2 = Convert.ToString(valorSinDecimal) + " " + PeriodoSelect + "s con " + decimales + " mes(es)";
}
else
{
double valorConDecimal = (double)T2;
long valorSinDecimal = (long)valorConDecimal;
double decimales = Math.Round((valorConDecimal - (double)valorSinDecimal) * 12, 1);
PeridoRec2 = Convert.ToString(valorSinDecimal) + " " + PeriodoSelect + " " + decimales + " mes(es)";
}
}
break;
}
}
else
{
PeridoRec2 = "No es posible calcular";
}
}
PeridoRec.Add(PeridoRec2);
ListaFinal.Add(PeridoRec);
for (int i = 1; i <= Periodo; i++)
{
decimal x1 = Convert.ToDecimal(ArregloDatos[i, 7]);
if (x1 >= 0)
{
decimal x2 = Convert.ToDecimal(ArregloDatos[i - 1, 7]);
if (x2 < 0)
{
decimal Anio = Convert.ToDecimal(ArregloDatos[i - 1, 0]);
if (PeriodoSelect == "Mes")
{
decimal T1 = Math.Round(((P / ((x2 * -1M) + x1)) + (Anio - 1)), 3);
if (T1 > 1)
{
double valorConDecimal = (double)T1;
long valorSinDecimal = (long)valorConDecimal;
double decimales = Math.Round((valorConDecimal - (double)valorSinDecimal) * 12, 1);
PeridoRec3 = Convert.ToString(valorSinDecimal) + " " + PeriodoSelect + "es con " + decimales + " dia(s)";
}
else
{
double valorConDecimal = (double)T1;
long valorSinDecimal = (long)valorConDecimal;
double decimales = Math.Round((valorConDecimal - (double)valorSinDecimal) * 12, 1);
PeridoRec3 = Convert.ToString(valorSinDecimal) + " " + PeriodoSelect + " " + decimales + " dia(s)";
}
}
else
{
decimal T2 = Math.Round(((P / ((x2 * -1) + x1)) + (Anio - 1)), 3);
if (T2 > 1)
{
double valorConDecimal = (double)T2;
long valorSinDecimal = (long)valorConDecimal;
double decimales = Math.Round((valorConDecimal - (double)valorSinDecimal) * 12, 1);
PeridoRec3 = Convert.ToString(valorSinDecimal) + " " + PeriodoSelect + "s con " + decimales + " mes(es)";
}
else
{
double valorConDecimal = (double)T2;
long valorSinDecimal = (long)valorConDecimal;
double decimales = Math.Round((valorConDecimal - (double)valorSinDecimal) * 12, 1);
PeridoRec3 = Convert.ToString(valorSinDecimal) + " " + PeriodoSelect + " " + decimales + " mes(es)";
}
}
break;
}
}
else
{
PeridoRec3 = "No es posible calcular";
}
}
PeridoRecP2.Add(PeridoRec3);
ListaFinal.Add(PeridoRecP2);
/*Calculo de periodo de recuperacion*/
/*Calculo de beneficio-costo*/
decimal SumIngresos_actualizados = 0;
for (int i = 1; i <= Periodo; i++)
{
SumIngresos_actualizados = SumIngresos_actualizados + Convert.ToDecimal(ArregloDatos[i, 5]);
}
decimal Sum_costos = 0;
for (int i = 1; i <= Periodo; i++)
{
Sum_costos = Sum_costos + Convert.ToDecimal(ArregloDatos[i, 2]);
}
Sum_costos = Sum_costos + inversion;
decimal CRBC = SumIngresos_actualizados / Sum_costos;
BenCosto.Add("Por cada peso invertido usted obtendra una ganancia de: $" + Convert.ToString(Math.Round(CRBC, 3)));
ListaFinal.Add(BenCosto);
/*Calculo de beneficio-costo*/
String json = JsonConvert.SerializeObject(ListaFinal);
return(json);
}
public void RunMixingMachineProduceNotice(string id)
{
SqlHelper helper = new SqlHelper();
StringBuilder sql = new StringBuilder();
sql.Append(" select pk.sort, pnt.id,p.pnid,p.pmid,pn.name,pm.model,pnt.planQuantity,Convert(varchar ");
sql.Append(" (10),pnt.startDate,120) as startDate,ei.no,pnt.assessor,pnt.checkupMan,pnt.notifyMan,Convert ");
sql.Append(" (varchar(10),pnt.notifyDate,120) as notifyDate,psp.ppid,tsp.tpid,ptId,psp.eiid from ");
sql.Append(" produceNotice pnt,produceSendProportionDetail psp,produceProportion ");
sql.Append(" pp,product p,productName pn,productModel pm,productKind pk,targetSendProportionDetail ");
sql.Append(" tsp,equipmentInformation ei where ei.id=psp.eiid and pnt.spId=psp.spId and psp.ppid=pp.id and pp.pid=p.id and ");
sql.Append(" p.pnid=pn.id and p.pmid=pm.id and pn.pkid=pk.id and pnt.spid=tsp.spid ");
sql.Append(" and pnt.id=" + id);
sql.Append(" order by notifyDate desc ");
System.Collections.ArrayList oArrayList = new System.Collections.ArrayList();
oArrayList.Add(sql.ToString());
DataSet ds = helper.QueryForDateSet(oArrayList);
//if (ds.Tables[0].Rows.Count > 0)
//{
// string sendProportionId = ds.Tables[0].Rows[0]["id"];
// ArrayList sqlStr = new ArrayList();
// sqlStr.Add("");
// ProduceDataSet.生产配合比信息DataTable o生产配合比信息DataTable = new ProduceDataSet.生产配合比信息DataTable();
// ProduceDataSet.生产配合比信息Row o生产配合比信息Row = (ProduceDataSet.生产配合比信息Row)o生产配合比信息DataTable.NewRow();
// o生产配合比信息Row.Proportion1 = "生产配合比编号001";
// o生产配合比信息Row.Proportion2 = "沥青1";
// o生产配合比信息Row.Proportion3 = "石粉1";
// o生产配合比信息Row.Proportion4 = "4_热料仓1";
// o生产配合比信息Row.Proportion5 = "5_热料仓1";
// o生产配合比信息Row.Proportion6 = "生产配合比编号001";
// o生产配合比信息Row.Proportion7 = "沥青1";
// o生产配合比信息Row.Proportion8 = "石粉1";
// o生产配合比信息Row.ProportionValue1 = "生产配合比编号001";
// o生产配合比信息Row.ProportionValue2 = "沥青1";
// o生产配合比信息Row.ProportionValue3 = "石粉1";
// o生产配合比信息Row.ProportionValue4 = "4_热料仓1";
// o生产配合比信息Row.ProportionValue5 = "5_热料仓1";
// o生产配合比信息Row.ProportionValue6 = "生产配合比编号001";
// o生产配合比信息Row.ProportionValue7 = "沥青1";
// o生产配合比信息Row.ProportionValue8 = "石粉1";
// o生产配合比信息DataTable.Add生产配合比信息Row(o生产配合比信息Row);
// ds.Tables.Add(o生产配合比信息DataTable);
// ProduceDataSet.目标配合比信息DataTable o目标配合比信息DataTable = new ProduceDataSet.目标配合比信息DataTable();
// ProduceDataSet.目标配合比信息Row o目标配合比信息Row1 = (ProduceDataSet.目标配合比信息Row)o目标配合比信息DataTable.NewRow();
// ProduceDataSet.目标配合比信息Row o目标配合比信息Row2 = (ProduceDataSet.目标配合比信息Row)o目标配合比信息DataTable.NewRow();
// o目标配合比信息Row1.目标配合比编号 = "目标配合比编号001";
// o目标配合比信息Row1.序号 = "序号1";
// o目标配合比信息Row1.材料种类 = "材料种类1";
// o目标配合比信息Row1.材料名称 = "材料名称1";
// o目标配合比信息Row1.规格型号 = "规格型号1";
// o目标配合比信息Row1.油石比 = "油石比1";
// o目标配合比信息Row1.产地 = "产地1";
// o目标配合比信息Row1.生产厂家 = "生产厂家1";
// o目标配合比信息Row2.目标配合比编号 = "目标配合比编号001";
// o目标配合比信息Row2.序号 = "序号2";
// o目标配合比信息Row2.材料种类 = "材料种类2";
// o目标配合比信息Row2.材料名称 = "材料名称2";
// o目标配合比信息Row2.规格型号 = "规格型号2";
// o目标配合比信息Row2.油石比 = "油石比2";
// o目标配合比信息Row2.产地 = "产地2";
// o目标配合比信息Row2.生产厂家 = "生产厂家2";
// o目标配合比信息DataTable.Add目标配合比信息Row(o目标配合比信息Row1);
// o目标配合比信息DataTable.Add目标配合比信息Row(o目标配合比信息Row2);
// ds.Tables.Add(o目标配合比信息DataTable);
//}
MixingMachineProduceNotice oMixingMachineProduceNotice = new MixingMachineProduceNotice();
oMixingMachineProduceNotice.Source = ds;
//公司名称
oMixingMachineProduceNotice.CoName = "中百";
//编号
oMixingMachineProduceNotice.Number = "20090101";
//制表
oMixingMachineProduceNotice.Tabler = "张三";
// 部门主管
oMixingMachineProduceNotice.Manager = "李四";
//制表日期
oMixingMachineProduceNotice.CDate = "2009年13月36日";
oMixingMachineProduceNotice.备注 = "备注";
// 显示报表
oMixingMachineProduceNotice.ShowReport();
}
/// <summary>
/// This function converts a polygon shapefile to grid. It implements the line-scan algorithm.
/// <param name="PolySf">The polygon shapefile</param>
/// <param name="FldID">The field index</param>
/// <param name="Newgrd">File name of the new grid</param>
/// <param name="header">Header object of the new grid</param>
/// <param name="grType">Grid data type</param>
/// <param name="cback">can be used to report progress (optional)</param>
/// <returns>true if successful</returns>
/// </summary>
//
// AUTHOR NAME: Enrico A. Chiaradia
// FROM: University of Milan (Italy)
// e.mail: [email protected]
//
// For details about the line-scan algorithm,
// please refer to http://www.profc.udec.cl/~gabriel/tutoriales/giswb/vol1/cp3/cp3-6.htm
//
// for each shape in PolySf
// 0) get the shape value (in the shapefile table)
// 1) load all the borders in a matrix composed by x(startpoint), x(endpoint), slope and share
// 2) define x of first scan line
// for each scan lines
// 3) calculate intersections with polygon border
// 4) sort intersections from lower Y to the higther
// 5) convert line space between two consecutive intersection to raster
public bool Poly2Grid(MapWinGIS.Shapefile PolySf, int FldID, MapWinGIS.Grid Newgrd,
MapWinGIS.GridHeader header, MapWinGIS.GridDataType grType,
MapWinGIS.ICallback cback)
{
double xMin, xMax;
double x0, x1, x2, y0, y1, y2, m, q;
int nShps, nVs, s, nP, p, tempn, v, b;
object val;
bool flg;
bord brd; //struct to keep a border
System.Collections.ArrayList bordi2; //list of borders
int perc = 1; //percent shapes done
int shpsPerc;
MapWinGIS.Shape PolyShp; //the polygon shape
//count the number of shapes
nShps = PolySf.NumShapes;
shpsPerc = NumPercentShapes(perc, nShps); //percent of progress
for (s = 0; s < nShps; ++s)
{
//for each shape, determine the extent and the number of parts
PolyShp = PolySf.get_Shape(s);
nP = PolyShp.NumParts;
xMin = PolyShp.Extents.xMin;
//yMin = PolyShp.Extents.yMin;
xMax = PolyShp.Extents.xMax;
//yMax = PolyShp.Extents.yMax;
//exclude shapes which are completely outside of the grid extents
if (!IsGridContainsShape(PolyShp, header))
{
continue;
}
//return the shape's value
val = GetCellValue(PolySf, FldID, s, header.NodataValue);
//load polygon borders
nVs = PolyShp.numPoints - 1;
bordi2 = new System.Collections.ArrayList(nVs + 1);
b = -1;
tempn = 0;
for (p = 0; p < nP; ++p)
{
x0 = PolyShp.get_Point(tempn).x;
y0 = PolyShp.get_Point(tempn).y;
for (v = tempn; v < nVs; ++v)
{
x1 = PolyShp.get_Point(v).x;
x2 = PolyShp.get_Point(v + 1).x;
y1 = PolyShp.get_Point(v).y;
y2 = PolyShp.get_Point(v + 1).y;
if (x1 != x2) // no vertical lines
{
m = (y2 - y1) / (x2 - x1);
q = y1 - (m * x1);
//add border to the list
b = b + 1;
brd = new bord();
brd.x1 = x1;
brd.x2 = x2;
brd.m = m;
brd.q = q;
bordi2.Add(brd);
}
//in case of multi-parts polygon
if ((x2 == x0) && (y2 == y0))
{
tempn = v + 2;
break;
}
} //Next v
} // next p
//define the first line-scan
double xstart;
// 20 nov 07 added by Enrico A. Chiaradia
//necessary if grid extentions differ from shapefile extentions
if (xMin >= header.XllCenter)
{
xstart = FirstLineXY(xMin, header.XllCenter, header.dX, 1);
}
else
{
xstart = FirstLineXY(xMin, header.XllCenter, header.dX, -1);
}
// the list of intersection y-values
System.Collections.ArrayList y_int = new System.Collections.ArrayList();
System.Collections.ArrayList pixels = new System.Collections.ArrayList();
do
{
flg = Interseca(bordi2, y_int, xstart);
flg = SortArray(y_int);
flg = ScanLine(y_int, xstart, pixels, header, val, cback);
xstart = xstart + header.dX;
}while (xstart <= xMax);
writePxList(Newgrd, grType, pixels, val, cback);
//report the progress
if (s >= shpsPerc)
{
reportProgress(shpsPerc, nShps, "shapefile to grid", cback);
perc = (int)((s * 100) / nShps);
shpsPerc = NumPercentShapes(perc + 1, nShps);
}
} // next shape
reportProgress(100, 100, "shapefile to grid", cback); //100 % shapes done
return(true);
}
public void RunYearMaterialRequirementsPlanning(string ppid)
{
SqlHelper helper = new SqlHelper();
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append(" select tpd.mid,mn.name,mm.model,mk.sort ");
sqlstr.Append(",cast(produceQuantity*Proportion as decimal(38, 2))quantity ");
sqlstr.Append(",cast(january*Proportion as decimal(38, 2))january");
sqlstr.Append(",cast(february*Proportion as decimal(38, 2)) february");
sqlstr.Append(",cast(march*Proportion as decimal(38, 2)) march");
sqlstr.Append(",cast(april*Proportion as decimal(38, 2)) april");
sqlstr.Append(",cast(may*Proportion as decimal(38, 2)) may");
sqlstr.Append(",cast(june*Proportion as decimal(38, 2)) june");
sqlstr.Append(",cast(july*Proportion as decimal(38, 2))july");
sqlstr.Append(",cast(august*Proportion as decimal(38, 2)) august");
sqlstr.Append(",cast(september*Proportion as decimal(38, 2))september");
sqlstr.Append(",cast(october*Proportion as decimal(38, 2))october");
sqlstr.Append(",cast(november*Proportion as decimal(38, 2))november");
sqlstr.Append(",cast(december*Proportion as decimal(38, 2))december");
//sqlstr.Append(",getdate() ");
sqlstr.Append(" from productionPlanDetail ppd");
sqlstr.Append(",(");
sqlstr.Append(" select tpd.tpId,mId,targetProportionValue value,'1' type from targetProportionDetail tpd");
sqlstr.Append(" union all");
sqlstr.Append(" select pd.pid tpid,mid,proportionValue value,'2' type from proportionDetail pd");
sqlstr.Append(") as tpd");
sqlstr.Append(",(");
sqlstr.Append(" select tpd.mid,tpd.tpid,tpd.targetProportionValue/(select sum(targetProportionValue) from targetProportionDetail where tpId=tpd.tpid) Proportion,'1' type from targetProportionDetail tpd");
sqlstr.Append(" union all");
sqlstr.Append(" select pd.mid,pd.pid as tpid,pd.proportionValue/(select sum(proportionValue) from proportionDetail where pId=pd.pid) Proportion,'2' type from proportionDetail pd");
sqlstr.Append(") as Proportion");
sqlstr.Append(",(");
sqlstr.Append(" select p.id,sort from product p,productName pn,productKind pk where p.pnid=pn.id and pn.pkid=pk.id");
sqlstr.Append(") as p ,material m,materialName mn,materialModel mm, materialKind mk ");
sqlstr.Append("where ppd.tpid=tpd.tpid and ppd.tpid=Proportion.tpid and tpd.mid=Proportion.mid and ppd.pid=p.id ");
sqlstr.Append(" and tpd.mid=m.id and m.mnid=mn.id and m.mmid=mm.id and mn.mkId=mk.id ");
sqlstr.Append("and Proportion.type=(select case when p.sort='混合料' then 1 else 2 end) ");
sqlstr.Append("and tpd.type=(select case when p.sort='混合料' then 1 else 2 end) ");
sqlstr.Append("and ppid=" + ppid);
System.Collections.ArrayList oArrayList = new System.Collections.ArrayList();
oArrayList.Add(sqlstr.ToString());
DataSet ds = helper.QueryForDateSet(oArrayList);
YearMaterialRequirementsPlanning oYearMaterialRequirementsPlanning = new YearMaterialRequirementsPlanning();
oYearMaterialRequirementsPlanning.Source = ds;
//年度
oYearMaterialRequirementsPlanning.Year = "2009";
//公司名称
oYearMaterialRequirementsPlanning.CoName = "中百";
//文档编号
oYearMaterialRequirementsPlanning.Number = "20090101";
//制表
oYearMaterialRequirementsPlanning.Tabler = "张三";
//审核
oYearMaterialRequirementsPlanning.Auditer = "李四";
//审批
oYearMaterialRequirementsPlanning.Approvaler = "王五";
// 显示报表
oYearMaterialRequirementsPlanning.ShowReport();
}
/* Методы для ввода, редактирования и удаления записей*/
public void addTableItem(TableItem t)
{
table.Add(t);
}
public void AddItem(string name, string value)
{
arrData.Add("\"" + name + "\":" + "\"" + value + "\"");
}
} // public void CloseDataConn( ref SqlConnection dataConnection )
/// <summary>
/// private method to parse the cdr
/// </summary>
/// <param name="fileName"></param>
/// <returns></returns>
private ArrayList ParseTheCdr(string fileName)
{
// make the array size (number of cdrs per file ) configurable
System.Collections.ArrayList theControls = new System.Collections.ArrayList(1000);
// example file formats
//146148451ce6120071008204847.1711-070000,,Start
//146158451ce6120071008204858.8531-070000,Javelin_sp,Normal,+14256051047,,Originating,+14256051047,Public,2142498,20071008204858.853,1-070000,Yes,20071008204910.746,20071008205017.699,016,VoIP,,2142498,,,14252142498,,remote,172.27.58.50:5060,[email protected],G729/8000,,,,,,Pacific_Financial_Advisors_gp,,,,,,,,,,y,,,66330:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[email protected],,,,,,,,,,,,,,,,,,,,,,,,,,,,20071008205001.004,Success,66330:1,Transfer Consult,,,,,16.157,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
char[] sep = new char[] { ',' };
char[] trim = new char[] { '"' };
int lineNumber = 1;
try
{
using (StreamReader sr = new StreamReader(fileName))
{
String line;
while ((line = sr.ReadLine()) != null)
{
try
{
// new record
BworksCdr aRec = new BworksCdr();
// parse the line
string[] controls = line.Split(sep);
if (controls.GetLength(0) < 100)
{
// we have a non-data line -- header or footer... so skip it
continue;
}
aRec.recordId = controls[0].Trim(trim);
aRec.serviceProvider = controls[1].Trim(trim);
aRec.type = controls[2].Trim(trim);
aRec.userNumber = controls[3].Trim(trim);
aRec.groupNumber = controls[4].Trim(trim);
aRec.direction = controls[5].Trim(trim);
aRec.callingNumber = controls[6].Trim(trim);
aRec.callingPresentationIndicator = controls[7].Trim(trim);
aRec.calledNumber = controls[8].Trim(trim);
aRec.startTime = controls[9].Trim(trim);
aRec.userTimeZone = controls[10].Trim(trim);
aRec.answerIndicator = controls[11].Trim(trim);
aRec.answerTime = controls[12].Trim(trim);
aRec.releaseTime = controls[13].Trim(trim);
aRec.terminationCause = controls[14].Trim(trim);
aRec.networkType = controls[15].Trim(trim);
aRec.carrierIdentificationCode = controls[16].Trim(trim);
aRec.dialedDigits = controls[17].Trim(trim);
aRec.callCategory = controls[18].Trim(trim);
aRec.networkCallType = controls[19].Trim(trim);
aRec.networkTranslatedNumber = controls[20].Trim(trim);
aRec.networkTranslatedGroup = controls[21].Trim(trim);
aRec.releasingParty = controls[22].Trim(trim);
aRec.route = controls[23].Trim(trim);
aRec.networkCallId = controls[24].Trim(trim);
aRec.codec = controls[25].Trim(trim);
aRec.group = controls[31].Trim(trim);
aRec.chargeIndicator = controls[41].Trim(trim);
aRec.conferenceId = controls[51].Trim(trim);
aRec.userId = controls[120].Trim(trim);
// cache the record
theControls.Add(aRec);
lineNumber++;
}
catch (System.Exception ex)
{
string errorMsg = "Error in File>" + fileName + " Line>" + lineNumber;
if (line != null)
{// add the line information if available
errorMsg += "Line>" + line;
}
LogFileError(errorMsg + "\r\n" + ex.Message + "\r\n" + ex.StackTrace);
}
}
}
}// try
catch (Exception e)
{
EventLog.WriteEntry(m_eventLogName, "Error in ParseJobControlFile-- error is " + e.ToString(), EventLogEntryType.Error, 3012);
}// catch
return(theControls);
}// private void ParseJobControlFile()
public void ParseUl(XmlNodeList items, Node monoTreeNode)
{
Node latestNodeAddition = monoTreeNode;
for (int i = 0; i < items.Count; i++)
{
if (items[i].LocalName == "li")
{
string[] attribs = ParseLi(items[i]);
string filename = attribs[1];
if (i + 1 == items.Count || items[i + 1].LocalName == "ul")
{
monoTreeNode.tree.HelpSource.Message(TraceLevel.Info,
spaces + "+" + attribs[0] + ": " + filename);
// Put the node in the monodoc toc.
// FIXME: Change this to include the help-source ID?
// Not really sure what's going on here.....
// An empty node with subnodes
if (filename == "html/en/empty.html")
{
// emptysub.html indicates, that a subpage should be generated...
// For later use.
string exportstr = "<html><head><title>Monodoc</title></head><body><i>Currently Navigation is recommended through the treeview.</i><br />This chapter contains the following entries:<br /><br />";
if (items.Count > i + 1 && items[i + 1].HasChildNodes)
{
foreach (XmlNode node in items[i + 1].ChildNodes)
{
if (node.LocalName == "li")
{
string[] list = ParseLi(node);
if (list[1] == "html/en/empty.html")
{
exportstr += list[0] + "<br />";
}
else
{
exportstr += "<a href=\"/" + list[1] + "\">" + list[0] + "</a><br />";
}
}
}
}
exportstr += "</body></html>";
Random R = new Random();
string rf = "mgrand_" + R.Next() + ".html";
using (FileStream fs = new FileStream(rf, FileMode.OpenOrCreate, FileAccess.Write))
{
StreamWriter streamWriter = new StreamWriter(fs);
streamWriter.WriteLine(exportstr);
streamWriter.Close();
}
filename = rf; //"html/en/emptysub.html";
tempfiles.Add(rf);
}
nodeToAddChildrenTo = latestNodeAddition.CreateNode(attribs[0].Trim(), "xhtml:" + filename);
}
else
{
monoTreeNode.tree.HelpSource.Message(TraceLevel.Info,
spaces + attribs[0] + ": " + filename);
// Put the node in the monodoc toc.
latestNodeAddition.CreateNode(attribs[0].Trim(), "xhtml:" + filename);
}
// Put the file in the archive.
if (File.Exists(filename))
{
if (packed_files [filename] == null)
{
packed_files [filename] = filename;
nodeToAddChildrenTo.tree.HelpSource.PackFile(filename, filename);
}
}
string fullpath = Path.Combine(Environment.CurrentDirectory, attribs[1]);
if (File.Exists(fullpath))
{
try
{
XmlDocument newdoc = new XmlDocument();
newdoc.Load(fullpath);
IncludeAttribLinks(newdoc.GetElementsByTagName("a"), "href", filename);
IncludeAttribLinks(newdoc.GetElementsByTagName("img"), "src", filename);
IncludeAttribLinks(newdoc.GetElementsByTagName("link"), "href", filename);
}
catch
{
monoTreeNode.tree.HelpSource.Error(spaces + "-- PARSE ERROR --");
throw;
}
}
}
if (items[i].LocalName == "ul")
{
spaces += " ";
ParseUl(items[i].ChildNodes, nodeToAddChildrenTo);
nodeToAddChildrenTo = latestNodeAddition;
spaces = spaces.Substring(6);
}
}
}
private void WriteAttribute(StreamWriter writer, ref int indent, object o, FieldInfo f, HashSet <object> saved, Dictionary <object, long> idmap, Queue <object> queue, ref int nextID)
{
object v = f.GetValue(o);
if (v == null)
{
return;
}
this.WriteStartElementAttribute(writer, ref indent, f.Name.TrimStart('_'));
Type ft = f.FieldType;
DocXsdFormatEnum?format = GetXsdFormat(f);
if (format == null || format != DocXsdFormatEnum.Attribute || f.Name.Equals("InnerCoordIndices")) //hackhack -- need to resolve...
{
this.WriteOpenElement(writer);
}
if (typeof(System.Collections.IEnumerable).IsAssignableFrom(ft))
{
System.Collections.IEnumerable list = (System.Collections.IEnumerable)v;
// for nested lists, flatten; e.g. IfcBSplineSurfaceWithKnots.ControlPointList
if (typeof(System.Collections.IEnumerable).IsAssignableFrom(ft.GetGenericArguments()[0]))
{
// special case
if (f.Name.Equals("InnerCoordIndices")) //hack
{
foreach (System.Collections.IEnumerable innerlist in list)
{
string entname = "Seq-IfcPositiveInteger-wrapper"; // hack
this.WriteStartElementEntity(writer, ref indent, entname);
this.WriteOpenElement(writer);
foreach (object e in innerlist)
{
object ev = e.GetType().GetField("Value").GetValue(e);
writer.Write(ev.ToString());
writer.Write(" ");
}
writer.WriteLine();
this.WriteEndElementEntity(writer, ref indent, entname);
}
WriteEndElementAttribute(writer, ref indent, f.Name.TrimStart('_'));
return;
}
System.Collections.ArrayList flatlist = new System.Collections.ArrayList();
foreach (System.Collections.ICollection innerlist in list)
{
foreach (object e in innerlist)
{
flatlist.Add(e);
}
}
list = flatlist;
}
foreach (object e in list)
{
// if collection is non-zero and contains entity instances
if (!e.GetType().IsValueType&& !(e is string) && !(e is System.Collections.IEnumerable))
{
this.WriteCollectionStart(writer, ref indent);
}
break;
}
bool needdelim = false;
foreach (object e in list)
{
if (e != null) // could be null if buggy file -- not matching schema
{
if (e is System.Collections.IList)
{
System.Collections.IList listInner = (System.Collections.IList)e;
for (int j = 0; j < listInner.Count; j++)
{
object oi = listInner[j];
Type et = oi.GetType();
while (et.IsValueType && !et.IsPrimitive)
{
FieldInfo fieldValue = et.GetField("Value");
if (fieldValue != null)
{
oi = fieldValue.GetValue(oi);
et = fieldValue.FieldType;
}
else
{
break;
}
}
// write each value in sequence with spaces delimiting
string sval = oi.ToString();
writer.Write(sval);
writer.Write(" ");
}
}
else if (!e.GetType().IsValueType&& !(e is string)) // presumes an entity
{
if (needdelim)
{
this.WriteCollectionDelimiter(writer, indent);
}
if (format != null && format == DocXsdFormatEnum.Attribute)
{
// only one item, e.g. StyledByItem\IfcStyledItem
this.WriteEntityStart(writer, ref indent);
bool closeelem = this.WriteEntityAttributes(writer, ref indent, e, saved, idmap, queue, ref nextID);
if (!closeelem)
{
this.WriteCloseElementAttribute(writer, ref indent);
return;
}
this.WriteEntityEnd(writer, ref indent);
}
else
{
this.WriteEntity(writer, ref indent, e, saved, idmap, queue, ref nextID);
}
needdelim = true;
}
else
{
// if flat-list (e.g. structural load Locations) or list of strings (e.g. IfcPostalAddress.AddressLines), must wrap
this.WriteValueWrapper(writer, ref indent, e);
}
}
}
foreach (object e in list)
{
if (e != null && !e.GetType().IsValueType&& !(e is string))
{
this.WriteCollectionEnd(writer, ref indent);
}
break;
}
}
else if (f.FieldType.IsInterface && v is ValueType)
{
this.WriteValueWrapper(writer, ref indent, v);
}
else if (f.FieldType.IsValueType) // must be IfcBinary
{
FieldInfo fieldValue = f.FieldType.GetField("Value");
if (fieldValue != null)
{
v = fieldValue.GetValue(v);
if (v is byte[])
{
this.WriteOpenElement(writer);
// binary data type - we don't support anything other than 8-bit aligned, though IFC doesn't either so no point in supporting extraBits
byte[] bytes = (byte[])v;
StringBuilder sb = new StringBuilder(bytes.Length * 2);
for (int i = 0; i < bytes.Length; i++)
{
byte b = bytes[i];
sb.Append(HexChars[b / 0x10]);
sb.Append(HexChars[b % 0x10]);
}
v = sb.ToString();
writer.WriteLine(v);
}
}
}
else
{
if (format != null && format == DocXsdFormatEnum.Attribute)
{
this.WriteEntityStart(writer, ref indent);
Type vt = v.GetType();
if (ft != vt)
{
this.WriteType(writer, indent, vt.Name);
}
bool closeelem = this.WriteEntityAttributes(writer, ref indent, v, saved, idmap, queue, ref nextID);
if (!closeelem)
{
this.WriteCloseElementEntity(writer, ref indent);
return;
}
this.WriteEntityEnd(writer, ref indent);
}
else
{
// if rooted, then check if we need to use reference; otherwise embed
this.WriteEntity(writer, ref indent, v, saved, idmap, queue, ref nextID);
}
}
WriteEndElementAttribute(writer, ref indent, f.Name.TrimStart('_'));
}
public string KeyGenrator()
{
//*****************starts of prime number genrator******************
System.Collections.ArrayList arr = new System.Collections.ArrayList();
int cnt = 1;
int InnerCnt = 1;
int InnerDiv = 0;
for (cnt = 1; cnt < 300; cnt++)
{
InnerDiv = 0;
for (InnerCnt = cnt; InnerCnt > 0; InnerCnt--)
{
if (cnt % InnerCnt == 0)
{
InnerDiv++;
}
}
if (InnerDiv <= 2)
{
arr.Add(cnt);
}
}
//*****************end of Prime Number******************
int arrayCount = arr.Count - 5;
Random rdn = new Random();
int randomNoForPrime = rdn.Next(15, arrayCount);
int p = Convert.ToInt32(arr[randomNoForPrime]);
int q = Convert.ToInt32(arr[randomNoForPrime + 2]);
int n = p * q;
int phi = (p - 1) * (q - 1);
//********Public Key Genration************
int e = 3;
Random rde = new Random();
int randomNoForE = rde.Next(10, arrayCount);
e = Convert.ToInt32(arr[randomNoForE]);
if (n / e == 0)
{
KeyGenrator();
}
//********Private Key Genration***********
int d = 2;
int remainder = 0;
while (remainder != 1)
{
d++;
remainder = (e * d) % phi;
if (d == phi)//thsi code is written for chek that 'd' is less then 'phi'
{
remainder = 1;
KeyGenrator();
}
}
//********Sending the public and private key********
string sn = n.ToString();
string se = e.ToString();
string sd = d.ToString();
MessageBox.Show("Congradualtion:\nYou Have Genrated Public and Private Keys Successfuly.\n\nYour\n Public key : " + se + "," + sn + "\n Private Key : " + sd + "," + sn + "\n\nPress Ok to Proceede");
StringBuilder sb = new StringBuilder();
sb.Append(se + "," + sn + "." + sd + "," + sn);
string st = sb.ToString();
return(st);
}
private void Initialize()
{
ReportMenu.SubGroups = new ArrayList();
MonthsDT = new DataTable();
MonthsDT.Columns.Add(new DataColumn("MonthID", Type.GetType("System.Int32")));
MonthsDT.Columns.Add(new DataColumn("MonthName", Type.GetType("System.String")));
for (int i = 1; i <= 12; i++)
{
DataRow NewRow = MonthsDT.NewRow();
NewRow["MonthID"] = i;
NewRow["MonthName"] = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(i).ToString();
MonthsDT.Rows.Add(NewRow);
}
cbxMonths.DataSource = MonthsDT.DefaultView;
cbxMonths.ValueMember = "MonthID";
cbxMonths.DisplayMember = "MonthName";
DateTime LastDay = new System.DateTime(DateTime.Now.Year, 12, 31);
System.Collections.ArrayList Quarters = new System.Collections.ArrayList();
System.Collections.ArrayList Years = new System.Collections.ArrayList();
for (int i = 1; i <= 4; i++)
{
Quarters.Add(i);
}
for (int i = 2013; i <= LastDay.Year; i++)
{
Years.Add(i);
}
cbxQuarters.DataSource = Quarters.ToArray();
cbxQuarters.SelectedIndex = 0;
cbxYears.DataSource = Years.ToArray();
cbxYears.SelectedIndex = cbxYears.Items.Count - 1;
GroupsDT = new DataTable();
SubGroupsDT = new DataTable();
GroupsBS = new BindingSource();
SubGroupsBS = new BindingSource();
if (StoreType == 1)
{
using (System.Data.SqlClient.SqlDataAdapter DA = new System.Data.SqlClient.SqlDataAdapter("SELECT * FROM TechStoreGroups" +
" WHERE TechStoreGroupID IN (SELECT TechStoreGroupID FROM TechStoreSubGroups WHERE TechStoreSubGroupID IN" +
" (SELECT TechStoreSubGroupID FROM TechStore WHERE TechStoreID IN (SELECT DISTINCT StoreItemID FROM infiniu2_storage.dbo.Store" +
" WHERE FactoryID = " + FactoryID + ")))" +
" ORDER BY TechStoreGroupName", ConnectionStrings.CatalogConnectionString))
{
DA.Fill(GroupsDT);
GroupsDT.Columns.Add(new DataColumn("Checked", Type.GetType("System.Boolean")));
foreach (DataRow Row in GroupsDT.Rows)
{
Row["Checked"] = false;
}
}
using (System.Data.SqlClient.SqlDataAdapter DA = new System.Data.SqlClient.SqlDataAdapter("SELECT * FROM TechStoreSubGroups WHERE TechStoreSubGroupID IN" +
" (SELECT TechStoreSubGroupID FROM TechStore WHERE TechStoreID IN (SELECT DISTINCT StoreItemID FROM infiniu2_storage.dbo.Store" +
" WHERE FactoryID = " + FactoryID + "))" +
" ORDER BY TechStoreSubGroupName", ConnectionStrings.CatalogConnectionString))
{
DA.Fill(SubGroupsDT);
SubGroupsDT.Columns.Add(new DataColumn("Checked", Type.GetType("System.Boolean")));
foreach (DataRow Row in SubGroupsDT.Rows)
{
Row["Checked"] = false;
}
}
}
if (StoreType == 2)
{
using (System.Data.SqlClient.SqlDataAdapter DA = new System.Data.SqlClient.SqlDataAdapter("SELECT * FROM TechStoreGroups" +
" WHERE TechStoreGroupID IN (SELECT TechStoreGroupID FROM TechStoreSubGroups WHERE TechStoreSubGroupID IN" +
" (SELECT TechStoreSubGroupID FROM TechStore WHERE TechStoreID IN (SELECT DISTINCT StoreItemID FROM infiniu2_storage.dbo.ManufactureStore" +
" WHERE FactoryID = " + FactoryID + ")))" +
" ORDER BY TechStoreGroupName", ConnectionStrings.CatalogConnectionString))
{
DA.Fill(GroupsDT);
GroupsDT.Columns.Add(new DataColumn("Checked", Type.GetType("System.Boolean")));
foreach (DataRow Row in GroupsDT.Rows)
{
Row["Checked"] = false;
}
}
using (System.Data.SqlClient.SqlDataAdapter DA = new System.Data.SqlClient.SqlDataAdapter("SELECT * FROM TechStoreSubGroups WHERE TechStoreSubGroupID IN" +
" (SELECT TechStoreSubGroupID FROM TechStore WHERE TechStoreID IN (SELECT DISTINCT StoreItemID FROM infiniu2_storage.dbo.ManufactureStore" +
" WHERE FactoryID = " + FactoryID + "))" +
" ORDER BY TechStoreSubGroupName", ConnectionStrings.CatalogConnectionString))
{
DA.Fill(SubGroupsDT);
SubGroupsDT.Columns.Add(new DataColumn("Checked", Type.GetType("System.Boolean")));
foreach (DataRow Row in SubGroupsDT.Rows)
{
Row["Checked"] = false;
}
}
}
GroupsBS.DataSource = GroupsDT;
SubGroupsBS.DataSource = SubGroupsDT;
GroupsGridSettings();
SubGroupsGridSettings();
}
//NECESSITA SER ASYNC POR TER QUE AGUARDAR A RESPOSTA DA API
public static async Task Main(string[] args)
{
Console.WriteLine("Consultando Ceps");
// Abrir arquivo excel existente
var tabela = new XLWorkbook(@"C:\Users\caio.telles\Desktop\importar_bairros\bairro-taxa.xlsx"); //coloca o caminho da pasta com o arquivo XLSM do EXCEL
var planilha = tabela.Worksheet(1);
// Console.WriteLine("".PadRight('-'));
// Console.WriteLine("Bairros".PadRight(35) + "Taxa".PadRight(15) + "Entrega".PadRight(15));
System.Collections.ArrayList Ceps = new System.Collections.ArrayList();
//CRIAÇÃO DE VARIAVEIS
var linha = 2; //CONTADOR DE LINHAS EXCEL
string ok = "nao"; //STRING DE REECONFIRMAÇÃO
System.Collections.ArrayList CepsValidos = new System.Collections.ArrayList(); //CRIAÇÃO DE ARRAY
var Faixa = planilha.Cell("a" + linha.ToString()).Value.ToString(); //CONVERSAO DE STRING FAIXA DOS CEPS
var FaixaInicial = (planilha.Cell("b" + linha.ToString()).Value.ToString()); ////CONVERSAO DE STRING FAIXAINICIAL DOS CEPS
var FaixaFinal = (planilha.Cell("c" + linha.ToString()).Value.ToString()); //CONVERSAO DE STRING FAIXAFINAL DOS CEPS
var lInicio = int.Parse(FaixaInicial); //CONVERSAO PARA USAR NA LOGICA FAIXA INICIAL
var lfim = int.Parse(FaixaFinal); ////CONVERSAO PARA USAR NA LOGICA FAIXA FINAL
var Lok = int.Parse(FaixaInicial); // VARIAVEL PARA INCRIMENTAR TODOS OS CEPS PROCURADOS
string Validcep = Lok.ToString(); //TRANSFORMAR PARA STRING
while (true)
{
while (true)
{
if (Lok <= lfim) // LINHA DO CEP NAO PODE SER MAIOR QUE A FAIXA FINAL
{
Lok++; //INCRIMENTA O CEP
Validcep = Lok.ToString();
Ceps.Add(Validcep); //ADICIONA NO ARRAY
ConsultaCEP(ok, linha, Lok, Validcep, CepsValidos); //CHAMA A FUNÇÃO DE CONSULTA API
}
if (Lok > lfim)//CASO O CEP SEJA MAIOR QUE A FAIXA FINAL PULA PARA A PROXIMA LINHA , OBS NÃO PODE SER VAZIA A LINHA
{
//ATRIBUIS NOVOS VALORES PARA A VARIAVEL DE FAIXAS E SOMA A LINHA
linha++;
Faixa = planilha.Cell("a" + linha.ToString()).Value.ToString();
FaixaInicial = (planilha.Cell("b" + linha.ToString()).Value.ToString());
FaixaFinal = (planilha.Cell("c" + linha.ToString()).Value.ToString());
//VERIFICA SE A LINHA ESTÁ VAZIA
if (string.IsNullOrEmpty(Faixa) ||
string.IsNullOrEmpty(FaixaInicial) ||
string.IsNullOrEmpty(FaixaFinal)
)
{
//CASO ESTEJA VAZIA CHAMA A FUNÇÃO DE CONSULTA PASSANDO SIM , PARA INICIAR A CRIAÇÃO DO EXCEL
Validcep = Lok.ToString();
Ceps.Add(Validcep);
ok = "sim";//PROVOCA A CRIAÇÃO DO EXCEL
ConsultaCEP(ok, linha, Lok, Validcep, CepsValidos);
break;
}
lInicio = int.Parse(FaixaInicial);
lfim = int.Parse(FaixaFinal);
Lok = int.Parse(FaixaInicial);
}
break;
}
}
}
/// <summary>
/// CSVをArrayListに変換
/// </summary>
/// <param name="csvText">CSVの内容が入ったString</param>
/// <returns>変換結果のArrayList</returns>
public ArrayList CsvToArrayList1(string csvText)
{
System.Collections.ArrayList csvRecords =
new System.Collections.ArrayList();
//前後の改行を削除しておく
csvText = csvText.Trim(new char[] { '\r', '\n' });
//一行取り出すための正規表現
System.Text.RegularExpressions.Regex regLine =
new System.Text.RegularExpressions.Regex(
"^.*(?:\\n|$)",
System.Text.RegularExpressions.RegexOptions.Multiline);
//1行のCSVから各フィールドを取得するための正規表現
System.Text.RegularExpressions.Regex regCsv =
new System.Text.RegularExpressions.Regex(
"\\s*(\"(?:[^\"]|\"\")*\"|[^,]*)\\s*,",
System.Text.RegularExpressions.RegexOptions.None);
System.Text.RegularExpressions.Match mLine = regLine.Match(csvText);
while (mLine.Success)
{
//一行取り出す
string line = mLine.Value;
//改行記号が"で囲まれているか調べる
while ((CountString(line, "\"") % 2) == 1)
{
mLine = mLine.NextMatch();
if (!mLine.Success)
{
throw new ApplicationException("不正なCSV");
}
line += mLine.Value;
}
//行の最後の改行記号を削除
line = line.TrimEnd(new char[] { '\r', '\n' });
//最後に「,」をつける
line += ",";
//1つの行からフィールドを取り出す
System.Collections.ArrayList csvFields =
new System.Collections.ArrayList();
System.Text.RegularExpressions.Match m = regCsv.Match(line);
while (m.Success)
{
string field = m.Groups[1].Value;
//前後の空白を削除
field = field.Trim();
//"で囲まれている時
if (field.StartsWith("\"") && field.EndsWith("\""))
{
//前後の"を取る
field = field.Substring(1, field.Length - 2);
//「""」を「"」にする
field = field.Replace("\"\"", "\"");
}
csvFields.Add(field);
m = m.NextMatch();
}
csvFields.TrimToSize();
csvRecords.Add(csvFields);
mLine = mLine.NextMatch();
}
csvRecords.TrimToSize();
return(csvRecords);
}
// this method is called by SecurityInfoCCW.GetSecurity
// its return is the SecurityDescriptor in binary format
// it loads the data from the registry
// [loads data from registry to UI]
public IntPtr GetSecurity(SecurityInfos requestedInformation, bool wantDefault)
{
if (requestedInformation == SecurityInfos.DiscretionaryAcl)
{
StringBuilder securityDescriptorBuilder = new StringBuilder("D:");
System.Collections.ArrayList kerb = new System.Collections.ArrayList(current.KerberosGlobalAcl);
System.Collections.ArrayList indexesOfInvalidItems = new System.Collections.ArrayList();
for (int i = 0; i < kerb.Count; i++)
{
try
{
string sid = ((new NTAccount((string)kerb[i])).Translate(typeof(SecurityIdentifier))).ToString();
securityDescriptorBuilder.Append("(A;;LCSWRP;;;" + sid + ")");
}
catch (ArgumentException) // invalid account, do not consider it
{
indexesOfInvalidItems.Add(i);
}
catch (IdentityNotMappedException)
{
indexesOfInvalidItems.Add(i);
}
}
//remove invalid items based on indexesOfInvalidItems
for (int i = indexesOfInvalidItems.Count - 1; i >= 0; i--)
{
kerb.RemoveAt((int)indexesOfInvalidItems[i]);
}
// rebuild the ACL, taking care not to leave it null
if (kerb.Count <= 0)
{
current.KerberosGlobalAcl = new string[] { "" };
}
else
{
current.KerberosGlobalAcl = (string[])kerb.ToArray(typeof(string));
}
IntPtr securityDescriptor;
int size = 0;
// call external function for transformig String SecurityDescriptors
// into their internal representation
#pragma warning suppress 56523
bool ret = SafeNativeMethods.ConvertStringSecurityDescriptorToSecurityDescriptor(
securityDescriptorBuilder.ToString(),
1, /*
* must be SDDL_REVISION_1 == 1 always
*/
out securityDescriptor,
out size
);
if (!ret)
{
return(IntPtr.Zero);
}
return(securityDescriptor);
}
return(IntPtr.Zero);
}
public Cube()
{
Draw = new System.Collections.ArrayList();
Draw.Add(Root.Instance.ResourceManager.LoadMesh("cube/cube.mesh"));
}
/// <summary>
/// 向发送客户端发送数据事情
/// </summary>
/// <param name="data">发送的数据</param>
/// <param name="endResponse"></param>
public void Send(WebMeta data, bool endResponse)
{
WebResponse response = this.Response;
if (data.ContainsKey("type") && data["type"] == "UI.Event")
{
if (runtime.Client.UIEvent != null)
{
var click = runtime.Client.UIEvent;
var key = data["key"];
if (String.Equals(key, "Click") && data.GetDictionary()["value"] is ListItem)
{
runtime.Client.UIEvent = null;
runtime.Client.Session.Storage(new Hashtable(), this);
var value = data.GetDictionary()["value"] as ListItem;
var objValue = click.Send();
if (objValue is Hashtable)
{
var val = objValue as Hashtable;
var em = val.GetEnumerator();
while (em.MoveNext())
{
if (String.Equals(em.Value, "Value"))
{
val[em.Key] = value.Value;
val[String.Format("{0}_Text", em.Key)] = value.Text;
//val.Put(em.Key as string, value.Value);
break;
}
}
response.Redirect(click.Model, click.Command, new WebMeta(val), false);
}
else if (objValue is WebMeta)
{
var val = objValue as WebMeta;
var em = val.GetDictionary().GetEnumerator();
while (em.MoveNext())
{
if (String.Equals(em.Value, "Value"))
{
val.Put(em.Key as string, value.Value);
val[String.Format("{0}_Text", em.Key)] = value.Text;
break;
}
}
response.Redirect(click.Model, click.Command, val, false);
}
else
{
response.Redirect(click.Model, click.Command, value.Value, false);
}
}
}
}
response.ClientEvent |= WebEvent.DataEvent;
if (response.Headers.ContainsKey("DataEvent"))
{
var ts = response.Headers.GetDictionary()["DataEvent"];
if (ts is WebMeta)
{
response.Headers.Set("DataEvent", (WebMeta)ts, data);
}
else if (ts is IDictionary)
{
response.Headers.Set("DataEvent", new WebMeta((IDictionary)ts), data);
}
else if (ts is Array)
{
var ats = new System.Collections.ArrayList();
ats.AddRange((Array)ts);
ats.Add(data);
response.Headers.Set("DataEvent", (WebMeta[])ats.ToArray(typeof(WebMeta)));
}
else
{
response.Headers.Set("DataEvent", data);
}
}
else
{
response.Headers.Set("DataEvent", data);
}
if (endResponse)
{
response.ClientEvent ^= response.ClientEvent & WebEvent.Normal;
this.End();
}
}
public Floor()
{
Draw = new System.Collections.ArrayList();
Draw.Add(Root.Instance.ResourceManager.LoadMesh("floor/floor.mesh"));
}
//Clearing Text Of List Of Files
public string ClearingTextOfListOfFiles(string TextOfListOfFiles)
{
//
string ClearedTextOfListOfFiles = "";
System.Collections.ArrayList ListOfNamesOfFiles = new System.Collections.ArrayList();
//
// Replacing <BR> To 13
//
TextOfListOfFiles = TextOfListOfFiles.Replace("<BR>", String.Format("{0}", (char)13));
//
// Division Of Text Of List Of Files
//
//string[] Separator = new string[1] { String.Format("{0}{1}", (char)13, (char)10) };
string[] Separator = new string[2] {
String.Format("{0}", (char)10), String.Format("{0}", (char)13)
};
string[] StringsOfListOfFiles =
TextOfListOfFiles.Split(Separator, StringSplitOptions.RemoveEmptyEntries);
//
// Getting Name Of File
//
for (int i = 0; i < StringsOfListOfFiles.Length; i++)
{
//
if (StringsOfListOfFiles[i].Length > 0)
{
//
// Checking Existence Of Tag A
//
int IndexOfBeginningA = StringsOfListOfFiles[i].IndexOf("<A ");
int IndexOfEndA = StringsOfListOfFiles[i].IndexOf(">");
//
if ((IndexOfBeginningA > -1) && (IndexOfEndA > -1))
{
//
// Getting Text Of Tag A
//
string TextOfA = "";
//
if (IndexOfEndA >= IndexOfBeginningA)
{
TextOfA =
StringsOfListOfFiles[i].Substring(IndexOfBeginningA, IndexOfEndA - IndexOfBeginningA);
}
//
// Checking Existence Of Name
//
int IndexOfBeginningName = TextOfA.IndexOf("\"");
int IndexOfEndName = TextOfA.LastIndexOf("\"");
//
if ((IndexOfBeginningName > -1) && (IndexOfEndName > -1))
{
//
// Getting Name Of File
//
string NameOfFile = "";
//
IndexOfBeginningName += 1;
//
if (IndexOfEndName >= IndexOfBeginningName)
{
NameOfFile =
TextOfA.Substring(IndexOfBeginningName, IndexOfEndName - IndexOfBeginningName);
}
//
// Checking Name
//
if (NameOfFile.IndexOf("/") > -1)
{
//
string[] ElementsOfNameOfFile =
NameOfFile.Split(new char[1] {
'/'
}, StringSplitOptions.RemoveEmptyEntries);
//
if (ElementsOfNameOfFile.Length > 0)
{
NameOfFile = ElementsOfNameOfFile[ElementsOfNameOfFile.GetUpperBound(0)];
}
else
{
NameOfFile = "";
}
}
//
if (NameOfFile.IndexOf("..") > -1)
{
NameOfFile = "";
}
//
// Addition Of Name
//
if (NameOfFile != "")
{
ListOfNamesOfFiles.Add(NameOfFile);
}
}
}
}
}
//
// Generation Of Text Of List Of Names Of Files
//
foreach (string CurrentName in ListOfNamesOfFiles)
{
ClearedTextOfListOfFiles += CurrentName + String.Format("{0}{1}", (char)13, (char)10);
}
//
// Return
//
return(ClearedTextOfListOfFiles);
}
public Car()
{
Draw = new System.Collections.ArrayList();
Draw.Add(new Marker());
}