/// <summary>
/// 登录成功后，设置COOKIE
/// </summary>
/// <param name="model"></param>
public static void SaveUserFormsCookie(MR_Admin model)
{
ZAuthentication.AuthHelper.SetUser(new ZAuthentication.UserTickModel(
model.AName, model.GetJSON(), DateTime.Now, DateTime.Now.AddHours(3), StaticFunctions.GetUserIp()));
}
public bool UpdateInventory(string index, int amount)
{
int cAmnt = storedVals[index];
//check if it would be negative
if ((cAmnt + amount) < 0)
{
//flash the displays and break out
if (index == "Refined Copper")
{
countDisplays[0].transform.parent.GetComponent <Animator>().SetTrigger("Flash");
}
else if (index == "Refined Iron")
{
countDisplays[1].transform.parent.GetComponent <Animator>().SetTrigger("Flash");
}
else if (index == "Pycrete")
{
countDisplays[2].transform.parent.GetComponent <Animator>().SetTrigger("Flash");
}
else if (index == "Brick")
{
countDisplays[3].transform.parent.GetComponent <Animator>().SetTrigger("Flash");
}
return(false);
}
//update values, then
string disp = StaticFunctions.AbbreviateNumber(cAmnt + amount);
UpdateDisplayTexts(index, disp);
storedVals[index] = cAmnt + amount;
//Make it pretty if you got a big input
if (amount > 50)
{
//flash the displays green
if (index == "Refined Copper")
{
countDisplays[0].transform.parent.GetComponent <Animator>().SetTrigger("FlashGreen");
}
else if (index == "Refined Iron")
{
countDisplays[1].transform.parent.GetComponent <Animator>().SetTrigger("FlashGreen");
}
else if (index == "Pycrete")
{
countDisplays[2].transform.parent.GetComponent <Animator>().SetTrigger("FlashGreen");
}
else if (index == "Brick")
{
countDisplays[3].transform.parent.GetComponent <Animator>().SetTrigger("FlashGreen");
}
}
/*
*
*
* if(core.level < 2)
* {
* if (storedVals["Brick"] >= core.lvlCosts[core.level].w & storedVals["Refined Copper"] >= core.lvlCosts[core.level].x && storedVals["Refined Iron"] >= core.lvlCosts[core.level].y && storedVals["Pycrete"] >= core.lvlCosts[core.level].z)
* {
* if (!buttonOn)
* {
* ToggleUpButton(true);
* }
* }
* else
* {
* ToggleUpButton(false);
* }
* }
* else
* {
* ToggleUpButton(false);
* }*/
//check project
if (proj.panOn)
{
proj.UpdatePanel(storedVals["Refined Copper"], storedVals["Refined Iron"], storedVals["Pycrete"], storedVals["Brick"]);
}
//cleanup
return(true);
}
public override string ToString()
{
return(StaticFunctions.FormatCurrencyStr(convertedFromValue));
}
public void ToggleEasyMode(bool value)
{
StaticFunctions.ToggleTextYesNo(easyModeToggleText, value);
userData.SetEasyMode(value);
masterManager.SaveSettings();
}
protected List <(float, float)> GetPositionsAroundCenter(TrainingInstanceController trainingInstanceController,
int mid, int mapScale)
{
var max = StaticFunctions.GetMaxLocalDistance(mapScale);
var position1X = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid - 1, mid - 1)).Position, trainingInstanceController).x);
var position1Y = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid - 1, mid - 1)).Position, trainingInstanceController).z);
var position2X = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid - 1, mid)).Position, trainingInstanceController).x);
var position2Y = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid - 1, mid)).Position, trainingInstanceController).z);
var position3X = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid - 1, mid + 1)).Position, trainingInstanceController).x);
var position3Y = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid - 1, mid + 1)).Position, trainingInstanceController).z);
var position4X = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid, mid + 1)).Position, trainingInstanceController).x);
var position4Y = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid, mid + 1)).Position, trainingInstanceController).z);
var position5X = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid, mid - 1)).Position, trainingInstanceController).x);
var position5Y = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid, mid - 1)).Position, trainingInstanceController).z);
var position6X = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid + 1, mid + 1)).Position, trainingInstanceController).x);
var position6Y = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid + 1, mid + 1)).Position, trainingInstanceController).z);
var position7X = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid + 1, mid)).Position, trainingInstanceController).x);
var position7Y = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid + 1, mid)).Position, trainingInstanceController).z);
var position8X = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid + 1, mid - 1)).Position, trainingInstanceController).x);
var position8Y = StaticFunctions.NormalisedFloat(-max, max, VectorConversions.GetLocalPosition(
trainingInstanceController
.TileDict[TileType.FreeTiles]
.First(tile => tile.Coords == (mid + 1, mid - 1)).Position, trainingInstanceController).z);
return(new List <(float, float)>
{
(position1X, position1Y),
(position2X, position2Y),
(position3X, position3Y),
(position4X, position4Y),
(position5X, position5Y),
(position6X, position6Y),
(position7X, position7Y),
(position8X, position8Y)
});
void OnAudioFilterRead(float[] data, int channels)
{
if (_audioOutputStream == null || _audioOutputStream.nativePointerIsNull)
{
// Zero the data back out.
for (int i = 0; i < data.Length; i++)
{
data[i] = 0.0f;
}
// Zero db level
_dbLevel = -42.0f;
// Bail
return;
}
// Configure the AudioOutputStream to resample to our desired sample rate
_audioOutputStream.SetSampleRate(_systemSampleRate);
int incomingNumberOfChannels = _audioOutputStream.Channels();
int numberOfFramesNeeded = data.Length / channels;
int numberOfIncomingSamplesNeeded = numberOfFramesNeeded * incomingNumberOfChannels;
if (_audioData == null || numberOfIncomingSamplesNeeded > _audioData.Length)
{
_audioData = new float[numberOfIncomingSamplesNeeded];
}
if (_audioOutputStream.GetAudioData(_audioData))
{
// Mix incoming audio data into buffer buffer
for (int f = 0; f < numberOfFramesNeeded; f++)
{
for (int c = 0; c < channels; c++)
{
int cIn = c;
if (cIn >= incomingNumberOfChannels)
{
cIn = incomingNumberOfChannels - 1;
}
int sIn = f * incomingNumberOfChannels + cIn;
int sOut = f * channels + c;
data[sOut] = !_mute ? data[sOut] * _audioData[sIn] : 0.0f;
}
}
// Calculate db level using the last 256 frames
int firstFrame = numberOfFramesNeeded - 256;
if (firstFrame < 0)
{
firstFrame = 0;
}
int firstSample = firstFrame * incomingNumberOfChannels;
_dbLevel = !_mute?StaticFunctions.CalculateAverageDbForAudioBuffer(_audioData, firstSample) : -42.0f;
}
else
{
// Failed to retrieve audio samples. zero the data back out.
// TODO: Maybe we should fade in/out here? Maybe the native interface can do that for us?
for (int i = 0; i < data.Length; i++)
{
data[i] = 0.0f;
}
// Zero db level
_dbLevel = -42.0f;
}
}
private void JavascriptFillRows(ref StringBuilder sb, string suffix, DataRow dr)
{
sb.AppendFormat("document.getElementById(\"estProduct{0}\").value='{1}';{2}", suffix, G.ParseJSString(dr["Description"].ToString()), Environment.NewLine);
sb.AppendFormat("document.getElementById(\"estProductID{0}\").value='{1}';{2}", suffix, dr["catalogid"].ToString(), Environment.NewLine);
sb.AppendFormat("document.getElementById(\"estUm{0}\").value='{1}';{2}", suffix, dr["UnitMeasure"].ToString(), Environment.NewLine);
sb.AppendFormat("document.getElementById(\"estQta{0}\").value='{1}';{2}", suffix, dr["qta"].ToString(), Environment.NewLine);
sb.AppendFormat("for(var i=0;i<document.getElementById(\"estVat{0}\").length;i++){1}{{", suffix, Environment.NewLine);
sb.AppendFormat("if(document.getElementById(\"estVat{0}\").options[i].value=='{1}'){2}{{document.getElementById(\"estVat{0}\").options[i].selected=true;{2}break;}}}};{2}", suffix, ((dr["tax"].ToString().Length > 0)?dr["Tax"].ToString():"0"), Environment.NewLine);
sb.AppendFormat("document.getElementById(\"estCost{0}\").value=FixCurrency('{1}',2,true,true);{2}", suffix, StaticFunctions.FixDecimalJS(dr["cost"].ToString()), Environment.NewLine);
if (((long)dr["catalogid"]) > 0)
{
sb.AppendFormat("document.getElementById(\"estCost{0}\").readOnly=true;{1}", suffix, Environment.NewLine);
sb.AppendFormat("document.getElementById(\"estCost{0}\").style.backgroundColor='#eeeeee';{1}", suffix, Environment.NewLine);
}
sb.AppendFormat("document.getElementById(\"estDiscount{0}\").value='{1}';{2}", suffix, dr["reduction"].ToString(), Environment.NewLine);
sb.AppendFormat("document.getElementById(\"estPl{0}\").value=FixCurrency('{1}',2,true,true);{2}", suffix, StaticFunctions.FixDecimalJS(dr["ListPrice"].ToString()), Environment.NewLine);
sb.AppendFormat("document.getElementById(\"estUp{0}\").value=FixCurrency('{1}',2,true,true);{2}", suffix, StaticFunctions.FixDecimalJS(dr["Uprice"].ToString()), Environment.NewLine);
sb.AppendFormat("document.getElementById(\"estPf{0}\").value=FixCurrency('{1}',2,true,true);{2}", suffix, StaticFunctions.FixDecimalJS(dr["newuprice"].ToString()), Environment.NewLine);
}
public async Task <ActionResult <List <RideOut> > > GetSearchRidesCustomerAsync(DateTime startTime, DateTime endTime, string startAddress, string targetAddress)
{
try //Searching Rides from CosmosDB with right TimeTable.
{
{
//Functions for delayed response -- timeout try /catch
// Get route from Google Directions Api
var response = await GoogleApiFunctions.GetRouteGoogle(startAddress, targetAddress);
// parse response from Google
RootObject obj = JsonConvert.DeserializeObject <RootObject>(response);
RideOut valueOut = new RideOut();
if (obj.status == "ZERO_RESULTS")
{
return(BadRequest("Reittiä ei löytynyt. Tarkista antamasi osoitteet, tai kokeile hakea kaupunginosalla."));
}
else if (obj.status == "OK")
{
// parse incoming object to outgoing start and end point from Google to CosmosDB -object
valueOut.Nickname = "Haku";
valueOut.Price = 0.00;
valueOut.StartTime = startTime;
valueOut.EndTime = endTime;
valueOut.StartAddress = startAddress;
valueOut.StartLocation = new Point(obj.routes[0].legs[0].start_location.lng, obj.routes[0].legs[0].start_location.lat);
valueOut.TargetAddress = targetAddress;
valueOut.TargetLocation = new Point(obj.routes[0].legs[0].end_location.lng, obj.routes[0].legs[0].end_location.lat);
valueOut.OfferingRide = false;
valueOut.SeatsLeft = 0;
valueOut.MondayFrequency = false;
valueOut.TuesdayFrequency = false;
valueOut.WednesdayFrequency = false;
valueOut.ThursdayFrequency = false;
valueOut.FridayFrequency = false;
valueOut.SaturdayFrequency = false;
valueOut.SundayFrequency = false;
// search for matches
FeedOptions queryOptions = new FeedOptions {
MaxItemCount = -1
};
IQueryable <RideOut> query = _cosmosDBclient.CreateDocumentQuery <RideOut>(
rideCollectionUri, queryOptions).Where(f => f.OfferingRide == true &&
f.StartTime >= valueOut.StartTime &&
f.StartTime <= valueOut.EndTime &&
f.StartLocation.Distance(valueOut.StartLocation) < f.StartLocation.Distance(valueOut.TargetLocation));
//&& f.TargetLocation.Distance(valueOut.StartLocation) > f.TargetLocation.Distance(valueOut.TargetLocation));
//&& (f.RoutePoints.Where(p => p.Distance(valueOut.StartLocation) < 500).First() != null)); // Distance (to) etäisyys metreinä
List <RideOut> incomingRides = query.ToList();
List <RideOut> returnRides = new List <RideOut>();
foreach (var item in incomingRides)
{
bool startPointMatch = false;
bool targetPointMatch = false;
try
{
if (StaticFunctions.CalculateDistanceBetweenPoints(item.RoutePoints.Where(p => StaticFunctions.CalculateDistanceBetweenPoints(p, valueOut.StartLocation) < 501).First(), valueOut.StartLocation) < 501)
{
startPointMatch = true;
}
}
catch (Exception)
{
//startPointMatch = false;
//continue;
}
try
{
if (StaticFunctions.CalculateDistanceBetweenPoints(item.RoutePoints.Where(p => StaticFunctions.CalculateDistanceBetweenPoints(p, valueOut.TargetLocation) < 501).First(), valueOut.TargetLocation) < 501)
{
;
}
{
targetPointMatch = true;
}
}
catch (Exception)
{
//targetPointMatch = false;
//continue;
}
if (startPointMatch && targetPointMatch)
{
returnRides.Add(item);
}
startPointMatch = false;
targetPointMatch = false;
}
// check for contents in query before returning?
if (returnRides == null)
{
valueOut.Nickname = "Hakusi ei tuottanut tuloksia";
returnRides.Add(valueOut);
}
return(returnRides);
}
else
{
return(NoContent());// "Nyt kävi jotain.";
}
}
}
catch (DocumentClientException de)
{
switch (de.StatusCode.Value)
{
case System.Net.HttpStatusCode.NotFound:
return(NotFound());
}
}
return(BadRequest());
}
private void UpdateValues()
{
var limit = MFFD.IDataset.GetDataSet().MaxminSet.Limit(AttachedTable);
if (PureSlipX)
{
if (Selector != null)
{
Selector.RemoveConstrain(FZ, AttachedTable);
Selector.RemoveConstrain(P, AttachedTable);
Selector.RemoveConstrain(IA, AttachedTable);
Selector.RemoveConstrain(T, AttachedTable);
Selector.RemoveConstrain(SA, AttachedTable);
}
FZ = new TireDataConstrain("FZ", TireDataColumn.FZ, limit.Max.FZ, limit.Min.FZ);
P = new TireDataConstrain("P", TireDataColumn.P, limit.Max.P, limit.Min.P);
IA = new TireDataConstrain("IA", TireDataColumn.IA, limit.Max.IA, limit.Min.IA);
T = new TireDataConstrain("T", TireDataColumn.TSTC, limit.Max.TSTC, limit.Min.TSTC);
SA = new TireDataConstrain("SA", TireDataColumn.SA, limit.Max.SA, limit.Min.SA);
Selector = new TireDataSetSelector(mffd.IDataset);
Selector.AddConstrain(FZ, AttachedTable);
Selector.AddConstrain(P, AttachedTable);
Selector.AddConstrain(IA, AttachedTable);
Selector.AddConstrain(T, AttachedTable);
Selector.AddConstrain(SA, AttachedTable);
}
else
{
if (Selector != null)
{
Selector.RemoveConstrain(FZ, Table.CorneringTable);
Selector.RemoveConstrain(P, Table.CorneringTable);
Selector.RemoveConstrain(IA, Table.CorneringTable);
Selector.RemoveConstrain(T, Table.CorneringTable);
Selector.RemoveConstrain(SA, Table.CorneringTable);
Selector.RemoveConstrain(SR, Table.CorneringTable);
Selector.RemoveConstrain(FZ, Table.DriveBrakeTable);
Selector.RemoveConstrain(P, Table.DriveBrakeTable);
Selector.RemoveConstrain(IA, Table.DriveBrakeTable);
Selector.RemoveConstrain(T, Table.DriveBrakeTable);
Selector.RemoveConstrain(SA, Table.DriveBrakeTable);
Selector.RemoveConstrain(SR, Table.DriveBrakeTable);
}
limit = StaticFunctions.TireDataMaxminMerge(
MFFD.IDataset.GetDataSet().MaxminSet.Limit(Table.CorneringTable),
MFFD.IDataset.GetDataSet().MaxminSet.Limit(Table.DriveBrakeTable)
);
limit = StaticFunctions.TireDataMaxminMerge(
limit,
MFFD.IDataset.GetDataSet().MaxminSet.Limit(Table.TransientTable)
);
FZ = new TireDataConstrain("FZ", TireDataColumn.FZ, limit.Max.FZ, limit.Min.FZ);
P = new TireDataConstrain("P", TireDataColumn.P, limit.Max.P, limit.Min.P);
IA = new TireDataConstrain("IA", TireDataColumn.IA, limit.Max.IA, limit.Min.IA);
T = new TireDataConstrain("T", TireDataColumn.TSTC, limit.Max.TSTC, limit.Min.TSTC);
SA = new TireDataConstrain("SA", TireDataColumn.SA, limit.Max.SA, limit.Min.SA);
SR = new TireDataConstrain("SR", TireDataColumn.SR, limit.Max.SR, limit.Min.SR);
Selector = new TireDataSetSelector(mffd.IDataset);
Selector.AddConstrain(FZ, Table.CorneringTable);
Selector.AddConstrain(P, Table.CorneringTable);
Selector.AddConstrain(IA, Table.CorneringTable);
Selector.AddConstrain(T, Table.CorneringTable);
Selector.AddConstrain(SA, Table.CorneringTable);
Selector.AddConstrain(SR, Table.CorneringTable);
Selector.AddConstrain(FZ, Table.DriveBrakeTable);
Selector.AddConstrain(P, Table.DriveBrakeTable);
Selector.AddConstrain(IA, Table.DriveBrakeTable);
Selector.AddConstrain(T, Table.DriveBrakeTable);
Selector.AddConstrain(SA, Table.DriveBrakeTable);
Selector.AddConstrain(SR, Table.DriveBrakeTable);
}
FZBar.Max = limit.Max.FZ;
FZBar.Min = limit.Min.FZ;
PBar.Max = limit.Max.P;
PBar.Min = limit.Min.P;
IABar.Max = limit.Max.IA;
IABar.Min = limit.Min.IA;
TBar.Max = limit.Max.TSTC;
TBar.Min = limit.Min.TSTC;
SABar.Max = limit.Max.SA;
SABar.Min = limit.Min.SA;
SRBar.Max = limit.Max.SR;
SRBar.Min = limit.Min.SR;
FZBar.valueR = limit.Max.FZ;
FZBar.valueL = limit.Min.FZ;
PBar.valueR = limit.Max.P;
PBar.valueL = limit.Min.P;
IABar.valueR = limit.Max.IA;
IABar.valueL = limit.Min.IA;
TBar.valueR = limit.Max.TSTC;
TBar.valueL = limit.Min.TSTC;
SABar.valueR = limit.Max.SA;
SABar.valueL = limit.Min.SA;
SRBar.valueR = limit.Max.SR;
SRBar.valueL = limit.Min.SR;
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostEnvironment env, ILogger <Startup> logger)
{
IDBrowserConfiguration configuration = new IDBrowserConfiguration();
Configuration.Bind(configuration);
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseSerilogRequestLogging();
try
{
if (configuration.Sites != null)
{
foreach (KeyValuePair <string, SiteSettings> siteKeyValuePair in configuration.Sites)
{
string strSiteName = siteKeyValuePair.Key;
SiteSettings siteSettings = siteKeyValuePair.Value;
ConnectionStringSettings connectionStringSettings = siteSettings.ConnectionStrings;
ServiceSettings serviceSettings = siteSettings.ServiceSettings;
//https://www.strathweb.com/2017/04/running-multiple-independent-asp-net-core-pipelines-side-by-side-in-the-same-application/
app.UseBranchWithServices("/" + strSiteName,
services =>
{
services
.AddMvc(option => option.EnableEndpointRouting = false)
.AddXmlSerializerFormatters();
services.AddSingleton <ServiceSettings>(serviceSettings);
if (configuration.UseSwagger)
{
//Register the Swagger generator, defining 1 or more Swagger documents
services.AddSwaggerGen(c =>
{
c.SwaggerDoc("v1", new OpenApiInfo
{
Title = $"IDBrowserService Core Site \"{strSiteName}\"",
Version = "v1",
Description = "Webservice for IDBrowser Android app."
});
// Set the comments path for the Swagger JSON and UI.
var xmlFile = $"{Assembly.GetExecutingAssembly().GetName().Name}.xml";
var xmlPath = Path.Combine(AppContext.BaseDirectory, xmlFile);
if (File.Exists(xmlPath))
{
c.IncludeXmlComments(xmlPath);
}
});
}
if (configuration.UseResponseCompression)
{
services.AddResponseCompression(options =>
{
options.Providers.Add <BrotliCompressionProvider>();
options.Providers.Add <GzipCompressionProvider>();
options.EnableForHttps = true;
});
}
services.AddDbContextPool <IDImagerDB>(options => StaticFunctions
.SetDbContextOptions(options, connectionStringSettings.DBType, connectionStringSettings.IDImager));
services.AddDbContextPool <IDImagerThumbsDB>(options => StaticFunctions
.SetDbContextOptions(options, connectionStringSettings.DBType, connectionStringSettings.IDImagerThumbs));
},
appBuilder =>
{
if (configuration.UseResponseCompression)
{
appBuilder.UseResponseCompression();
}
appBuilder.UseMvc();
if (configuration.UseSwagger)
{
// Enable middleware to serve generated Swagger as a JSON endpoint.
appBuilder.UseSwagger();
// Enable middleware to serve swagger-ui (HTML, JS, CSS, etc.),
// specifying the Swagger JSON endpoint.
appBuilder.UseSwaggerUI(c =>
{
c.SwaggerEndpoint($"/{strSiteName}/swagger/v1/swagger.json", "IDBrowserServiceCore V1");
});
}
});
}
}
app.Run(async c =>
{
await c.Response.WriteAsync("Service online!");
});
}
catch (Exception ex)
{
logger.LogError(ex.ToString());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ArrayList pp = Rowediting1.ProductRows();
if (pp.Count > 0)
{
bool newQuote;
long billId;
using (DigiDapter dg = new DigiDapter())
{
dg.Add("OWNERID", this.TextboxSearchOwnerID.Text);
if (this.TextboxSearchManagerID.Text.Length > 0)
{
dg.Add("MANAGERID", this.TextboxSearchManagerID.Text);
}
if (this.TextboxSearchSignalerID.Text.Length > 0)
{
dg.Add("SIGNALER", this.TextboxSearchSignalerID.Text);
}
dg.Add("SUBJECT", this.QSubject.Text);
dg.Add("DESCRIPTION", this.QuoteDescription.Text);
dg.Add("CURRENCY", Rowediting1.RowEstCurrency);
dg.Add("CHANGE", StaticFunctions.FixDecimal(Rowediting1.RowEstChange));
DateTime ExpirationDate;
try
{
ExpirationDate = UC.LTZ.ToUniversalTime(Convert.ToDateTime(QValidData.Text));
}
catch
{
ExpirationDate = DateTime.Now.AddDays(30);
}
dg.Add("EXPIRATIONDATE", ExpirationDate);
DateTime QuoteDate;
try
{
QuoteDate = UC.LTZ.ToUniversalTime(Convert.ToDateTime(QuoteData.Text));
}
catch
{
QuoteDate = DateTime.Now;
}
dg.Add("QUOTEDATE", QuoteDate);
if (ShipDescription.SelectedIndex > 0)
{
dg.Add("SHIPID", ShipDescription.SelectedValue.Split('|')[0]);
}
if (ShipData.Text.Length > 0)
{
dg.Add("SHIPDATE", UC.LTZ.ToUniversalTime(Convert.ToDateTime(ShipData.Text)));
}
dg.Add("LASTMODIFIEDDATE", DateTime.Now);
dg.Add("LASTMODIFIEDBYID", UC.UserId);
if (this.QuoteID == -1)
{
dg.Add("CREATEDBYID", UC.UserId);
}
dg.Add("ACTIVITYID", this.ActivityID);
if (this.QStage.SelectedValue == "-1")
{
dg.Add("STAGE", ((int)QuoteStage.Negotiation).ToString());
}
else
{
dg.Add("STAGE", this.QStage.SelectedValue);
}
dg.Add("PAYMENTID", this.QPayment.SelectedValue);
if (this.Qnumber.Text.Length > 0)
{
dg.Add("NUMBER", this.Qnumber.Text);
}
dg.Add("REDUCTION", 0);
dg.Add("CROSSTYPE", CrossWith.SelectedValue);
dg.Add("CROSSID", CrossWithID.Text);
dg.Add("ADDRESS", QAddress.Text);
dg.Add("SHIPADDRESS", SAddress.Text);
dg.Add("GRANDTOTAL", Convert.ToDecimal(Request["grandtotal"]));
dg.Add("SUBTOTAL", Convert.ToDecimal(Request["subtotal"]));
dg.Add("TAXTOTAL", Convert.ToDecimal(Request["taxtotal"]));
dg.Add("SHIP", (Request["shiptotal"].Length > 0)?Convert.ToDecimal(Request["shiptotal"]):0);
dg.Add("SHIPVAT", (Request["shipVat"].Length > 0)?Convert.ToDecimal(Request["shipVat"]):0);
dg.Add("GROUPS", "|" + UC.UserGroupId.ToString() + "|");
dg.Add("INCLUDEPRODPDF", (chkIncludePDFDoc.Checked)?1:0);
billId = Convert.ToInt64(dg.Execute("ORDERS", "ID=" + this.QuoteID, DigiDapter.Identities.Identity));
if (this.QuoteID == -1)
{
this.QuoteID = Convert.ToInt64(billId);
}
newQuote = dg.RecordInserted;
}
if (InvoiceNumber.Text.Length > 0)
{
using (DigiDapter dg = new DigiDapter())
{
dg.Add("ORDERID", this.QuoteID);
DateTime invoiceDate;
try
{
invoiceDate = UC.LTZ.ToUniversalTime(Convert.ToDateTime(InvoiceDate.Text));
}
catch
{
try
{
invoiceDate = UC.LTZ.ToUniversalTime(Convert.ToDateTime(QuoteData.Text));
}
catch
{
invoiceDate = DateTime.Now;
}
}
dg.Add("INVOICEDATE", invoiceDate);
dg.Add("INVOICENUMBER", InvoiceNumber.Text);
if (InvoiceExpirationDate.Text.Length > 0)
{
dg.Add("EXPIRATIONDATE", UC.LTZ.ToUniversalTime(Convert.ToDateTime(InvoiceExpirationDate.Text)));
}
if (InvoicePaymentDate.Text.Length > 0)
{
dg.Add("PAYMENTDATE", UC.LTZ.ToUniversalTime(Convert.ToDateTime(InvoicePaymentDate.Text)));
}
dg.Add("PAID", InvoicePaid.Checked);
dg.Execute("INVOICES", "ID=" + InvoiceId.Text);
}
}
if (!newQuote)
{
DatabaseConnection.DoCommand("DELETE FROM ORDERROWS WHERE ORDERID=" + this.QuoteID);
DatabaseConnection.DoCommand("DELETE FROM ORDERDOCUMENT WHERE ORDERID=" + this.QuoteID);
}
foreach (PurchaseProduct Pprod in pp)
{
using (DigiDapter dg = new DigiDapter())
{
dg.Add("ORDERID", this.QuoteID);
dg.Add("DESCRIPTION", Pprod.ShortDescription);
dg.Add("DESCRIPTION2", Pprod.LongDescription);
dg.Add("UPRICE", Pprod.UnitPrice);
dg.Add("NEWUPRICE", Pprod.FinalPrice);
dg.Add("LISTPRICE", Pprod.ListPrice);
dg.Add("CATALOGID", Pprod.id);
dg.Add("QTA", Pprod.Qta);
dg.Add("REDUCTION", Pprod.Reduction);
dg.Add("TAX", Pprod.Vat);
dg.Add("COST", Pprod.Cost);
dg.Add("REALLISTPRICE", Pprod.RealListPrice);
dg.Execute("ORDERROWS");
}
}
if (Request["IDDocument"] != null && Request["IDDocument"].ToString().Length > 0)
{
using (DigiDapter dg = new DigiDapter())
{
dg.Add("QUOTEID", this.QuoteID);
dg.Add("DOCUMENTID", Convert.ToInt64(Request["IDDocument"]));
dg.Execute("ORDERDOCUMENT");
}
}
int otherdocument = 1;
while (Request["IDDocument_" + otherdocument] != null && Request["IDDocument_" + otherdocument].ToString().Length > 0)
{
using (DigiDapter dg = new DigiDapter())
{
dg.Add("QUOTEID", this.QuoteID);
dg.Add("DOCUMENTID", Convert.ToInt64(Request["IDDocument_" + otherdocument]));
dg.Execute("ORDERDOCUMENT");
}
otherdocument++;
}
ClientScript.RegisterStartupScript(this.GetType(), "OK", "<script>alert('" + string.Format(Root.rm.GetString("Ordtxt11"), this.Qnumber.Text) + "');location.href='/erp/orderlist.aspx?m=67&dgb=1&si=69';</script>");
FillQuote(this.QuoteID);
if (CheckActivity.Checked && CrossWithID.Text.Length > 0)
{
ActivityInsert ai = new ActivityInsert();
string A = "";
string C = "";
string L = "";
switch (CrossWith.SelectedValue)
{
case "0":
A = CrossWithID.Text;
C = "";
L = "";
break;
case "1":
C = CrossWithID.Text;
A = "";
L = "";
break;
case "2":
L = CrossWithID.Text;
A = "";
C = "";
break;
}
if (A.Length > 0 || C.Length > 0 || L.Length > 0)
{
ai.InsertActivity("7", "", UC.UserId.ToString(), C, A, L, Root.rm.GetString("Ordtxt12") + ":" + this.QSubject.Text, this.QuoteDescription.Text, UC.LTZ.ToUniversalTime(DateTime.Now), UC, 1);
}
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "OK", "<script>alert('" + Root.rm.GetString("Quotxt29") + "');</script>");
}
}
public Action GetActionFromInput(ActionInput a_input)
{
return(StaticFunctions.GetAction(a_input, actionSlots));
}
public void OnQuit()
{
StaticFunctions.QuitGame();
}
public void BeforeReplot()
{
CheckInitialized();
Table t = (TableCB.SelectedItem as Table?).Value;
if (Initialized)
{
if (SourceCB.SelectedIndex < numDataList)
{
var node = SourceCB.SelectedItem as ProjectTree.Node_TireDataSet;
if (node != null && ID != null && ID != suffix.ToString("000") + "_" + node.ID.ToString())
{
OnDelete();
}
ID = suffix.ToString("000") + "_" + node.ID.ToString();
List <int> transientIndex = null;
if (t == Table.TransientTable)
{
transientIndex = node.IDataSet.GetDataSet().TransientTableIndexHolder;
}
Viewer.SetDataList(node.IDataSet.GetDataSet().GetDataList(t), t, ID, transientIndex);
if (MFSourceCB.SelectedIndex >= 0)
{
if (Args == null)
{
var mfnode = MFSourceCB.SelectedItem as ProjectTree.Node_MagicFormula;
var data = mfnode.MFFD.IDataset.GetDataSet().MaxminSet.Limit(t).Mean;
Args = new MagicFormulaArguments(data);
}
var nodeMF = MFSourceCB.SelectedItem as ProjectTree.Node_MagicFormula;
Viewer.SetDataListRefMF(ID, nodeMF.ID.ToString());
Viewer.SetMagicFormula(nodeMF.MFFD.MagicFormula, StaticFunctions.ConstArgToViewer(Args), nodeMF.ID.ToString());
}
else
{
Viewer.SetDataListRefMF(ID, null);
}
}
else
{
var node = SourceCB.SelectedItem as ProjectTree.Node_MagicFormula;
if (node != null && ID != null && ID != suffix.ToString("000") + "_" + node.ID.ToString())
{
OnDelete();
DialogResult result = MessageBox.Show("引数をリセットしますか?", "確認",
MessageBoxButtons.YesNo,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button2);
if (result == DialogResult.Yes)
{
var data = node.MFFD.IDataset.GetDataSet().MaxminSet.Limit(t).Mean;
Args = new MagicFormulaArguments(data);
}
}
if (Args == null)
{
var data = node.MFFD.IDataset.GetDataSet().MaxminSet.Limit(t).Mean;
Args = new MagicFormulaArguments(data);
}
ID = suffix.ToString("000") + "_" + node.ID.ToString();
Viewer.SetMagicFormula(node.MFFD.MagicFormula, StaticFunctions.ConstArgToViewer(Args), ID);
}
KnownColor color = (KnownColor)(ColorCB.SelectedIndex + 1);
var ct = PlotTypeCB.SelectedIndex == 0 ? SeriesChartType.FastLine : SeriesChartType.FastPoint;
Viewer.SetChartType(ct, ID);
Viewer.SetColor(Color.FromKnownColor(color), ID);
Viewer.SetLineWidth(int.Parse(SizeTB.Text), ID);
Viewer.LegendTextOverride(ID, NameTB.Text);
Viewer.SetEnable(ShowCB.Checked, ID);
}
}
void ShowImage()
{
_tutorialImage.gameObject.SetActive(true);
StartCoroutine(StaticFunctions.FadeInAlpha(result => _tutorialImage.color = result, _tutorialImage.color, 1f));
}
public void Btn_Click(object sender, EventArgs e)
{
DataSet dsCSV = null;
if (Cache[UC.UserId + "CSV"] is DataSet)
{
dsCSV = Cache[UC.UserId + "CSV"] as DataSet;
Cache.Remove(UC.UserId + "CSV");
}
else
{
SendError("Cache Expired during import", UC.UserRealName + " - " + UC.UserName);
Context.Items["warning"] = "Cache Expired during import!";
Response.Redirect("/");
}
string tableRef = String.Empty;
int loadedRows = 0;
int savedActivities = 0;
int reduntantRows = 0;
int unmatchingRows = 0;
switch (((LinkButton)sender).ID)
{
case "RefreshRepCategories":
FillRepCategories();
break;
case "CmdLoadData":
GetMap((CRMTables)int.Parse(TableImport.SelectedValue));
tableRef = _CRMtables[int.Parse(TableImport.SelectedValue)];
DataTable dtMatch = XMLDataTable();
DataTable dtMatchFields = XMLDataTable();
bool csvOk = true;
try
{
if (dsCSV.Tables["CSVData"].Rows.Count < 1)
{
csvOk = false;
}
}
catch
{
csvOk = false;
}
if (csvOk)
{
string sqlString = "SELECT * FROM " + tableRef + " WHERE ID = -1";
IDataReader rd = DatabaseConnection.CreateReader(sqlString);
DataTable St = rd.GetSchemaTable();
DataTable dt = new DataTable();
DataColumn dc;
for (int i = 0; i < St.Rows.Count; i++)
{
dc = new DataColumn(St.Rows[i]["ColumnName"].ToString(), Type.GetType(St.Rows[i]["DataType"].ToString()));
dc.Unique = Convert.ToBoolean(St.Rows[i]["IsUnique"]);
dc.AllowDBNull = Convert.ToBoolean(St.Rows[i]["AllowDBNull"]);
dc.ReadOnly = Convert.ToBoolean(St.Rows[i]["IsReadOnly"]);
if (dc.DataType.ToString() == "System.String")
{
dc.MaxLength = (int)St.Rows[i]["ColumnSize"];
}
dt.Columns.Add(dc);
}
DataRow templaterow = dt.NewRow();
foreach (DataRow d in dsCSV.Tables["CSVData"].Rows)
{
bool noImport = false;
string companyId = String.Empty;
string referrerId = String.Empty;
string leadId = String.Empty;
string accountGroupId = String.Empty;
string query = String.Empty;
for (int i = 0; i < dtMatch.Rows.Count; i++)
{
if (dtMatch.Rows[i]["Must"].ToString() == "1" && (Request.Form[dtMatch.Rows[i]["Name"].ToString()] == "0" || d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString().Length == 0))
{
noImport = true;
unmatchingRows++;
break;
}
if (Request.Form[dtMatch.Rows[i]["Name"].ToString()] == "0")
{
continue;
}
if (Request.Form["Check_" + dtMatch.Rows[i]["Name"].ToString()] != null)
{
query += " AND " + dtMatchFields.Rows[i]["TblSrc"].ToString() + "='" + DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString()) + "'";
}
if (dtMatchFields.Rows[i]["TblSrc"].ToString() == "companylink")
{
companyId = DatabaseConnection.SqlScalar(String.Format("SELECT ID FROM BASE_COMPANIES WHERE ({0}) AND LTRIM(RTRIM(COMPANYNAME))='{1}'", GroupsSecure(), DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString())));
}
else if (dtMatchFields.Rows[i]["TblSrc"].ToString() == "referrerlink" && companyId.Length > 0)
{
referrerId = DatabaseConnection.SqlScalar(String.Format("SELECT ID FROM BASE_CONTACTS WHERE ({0}) AND LTRIM(RTRIM(COMPANYNAME))='{1}'", GroupsSecure(), DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString())));
}
else if (dtMatchFields.Rows[i]["TblSrc"].ToString() == "leadlink")
{
leadId = DatabaseConnection.SqlScalar(String.Format("SELECT ID FROM CRM_LEADS WHERE ({0}) AND LTRIM(RTRIM(COMPANYNAME))='{1}'", GroupsSecure(), DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString())));
}
else if (dtMatchFields.Rows[i]["TblSrc"].ToString() == "accountlink")
{
accountGroupId = DatabaseConnection.SqlScalar(String.Format("SELECT CAST(UID AS VARCHAR)+'|'+CAST(GROUPID AS VARCHAR) FROM ACCOUNT ((LTRNAME))+' '+LTRIM(RTRIM(SURNAME)))='{0}' OR (LTRIM(RTRIM(SURNAME))+' '+LTRIM(RTRIM(NAME)))='{0}' OR USERACCOUNT='{0}')", DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString())));
}
}
if (noImport)
{
break;
}
if (query.Length > 0)
{
string empty;
empty = DatabaseConnection.SqlScalar(String.Format("SELECT COUNT(*) FROM {0} WHERE {1}", tableRef, query));
if (empty != "0")
{
d["DUP"] = true;
}
}
if (!(bool)d["DUP"])
{
DataRow myDataRow = templaterow;
string group = UC.UserGroupId.ToString();
string uId = UC.UserId.ToString();
if (accountGroupId.Length > 0)
{
string[] arr = accountGroupId.Split('|');
uId = arr[0];
group = arr[1];
}
myDataRow["OwnerID"] = uId;
myDataRow["CreatedByID"] = uId;
if (companyId.Length > 0)
{
myDataRow["CompanyID"] = companyId;
}
myDataRow["Groups"] = "|" + group + "|";
if (tableRef.Equals("CRM_WorkActivity"))
{
bool skip = true;
myDataRow["Type"] = "7";
if (referrerId.Length > 0)
{
skip = false;
myDataRow["ReferrerID"] = referrerId;
}
if (leadId.Length > 0)
{
skip = false;
myDataRow["LeadID"] = leadId;
}
if (companyId.Length > 0)
{
skip = false;
}
if (skip)
{
savedActivities++;
continue;
}
}
string cat = "|";
foreach (RepeaterItem it in RepCategories.Items)
{
CheckBox Check = (CheckBox)it.FindControl("Check");
if (Check.Checked)
{
cat += ((Literal)it.FindControl("IDCat")).Text + "|";
}
}
if (cat.Length > 1)
{
myDataRow["Categories"] = cat;
}
for (int i = 0; i < dtMatch.Rows.Count; i++)
{
if (Request.Form[dtMatch.Rows[i]["Name"].ToString()] != "0" &&
dtMatchFields.Rows[i]["TblSrc"].ToString() != "companylink" &&
dtMatchFields.Rows[i]["TblSrc"].ToString() != "referrerlink" &&
dtMatchFields.Rows[i]["TblSrc"].ToString() != "leadlink" &&
dtMatchFields.Rows[i]["TblSrc"].ToString() != "accountlink")
{
int fieldLen = dt.Columns[dtMatchFields.Rows[i]["TblSrc"].ToString()].MaxLength;
if (myDataRow.Table.Columns[dtMatchFields.Rows[i]["TblSrc"].ToString()].DataType.ToString() == "System.Decimal")
{
try
{
decimal dec = StaticFunctions.FixDecimal(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString());
myDataRow[dtMatchFields.Rows[i]["TblSrc"].ToString()] = dec;
}
catch
{
}
}
else if (myDataRow.Table.Columns[dtMatchFields.Rows[i]["TblSrc"].ToString()].DataType.ToString() == "System.DateTime")
{
DateTime today = new DateTime();
try
{
today = DateTime.Parse(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString().Trim(new char[] { '"', '\'', '\t', ' ' }));
}
catch
{
today = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 12, 0, 0);
}
finally
{
myDataRow[dtMatchFields.Rows[i]["TblSrc"].ToString()] = UC.LTZ.ToUniversalTime(today);
}
}
else if (fieldLen > 4000) //2147483647
{
myDataRow[dtMatchFields.Rows[i]["TblSrc"].ToString()] = d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString().Replace("\r", "").Replace("\n", ((char)13 + (char)10).ToString());
}
else
{
try
{
string colcontent = d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString().Trim(new char[] { '"', '\'', '\t', ' ' });
if (colcontent.Length > fieldLen)
{
colcontent = colcontent.Substring(0, fieldLen - 1);
}
myDataRow[dtMatchFields.Rows[i]["TblSrc"].ToString()] = colcontent;
}
catch
{
}
}
}
}
switch ((CRMTables)int.Parse(TableImport.SelectedValue))
{
case CRMTables.Base_Companies:
if (myDataRow["CompanyName"] == DBNull.Value)
{
myDataRow["CompanyName"] = "N/A";
}
break;
case CRMTables.Base_Contacts:
case CRMTables.CRM_Leads:
if (myDataRow["Surname"] == DBNull.Value)
{
myDataRow["Surname"] = "N/A";
}
break;
case CRMTables.CRM_WorkActivity:
if (myDataRow["Subject"] == DBNull.Value)
{
myDataRow["Subject"] = "N/A";
}
break;
}
StringBuilder sbColumn = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
sbColumn.AppendFormat("INSERT INTO {0} (", tableRef);
sbValue.Append(" VALUES (");
DbSqlParameterCollection sqlParam = new DbSqlParameterCollection();
foreach (DataColumn cc in myDataRow.Table.Columns)
{
if (cc.ColumnName.ToUpper() != "ID" && myDataRow[cc.ColumnName] != DBNull.Value)
{
sbColumn.AppendFormat("{0},", cc.ColumnName);
sbValue.AppendFormat("@{0},", cc.ColumnName);
sqlParam.Add(new DbSqlParameter("@" + cc.ColumnName, myDataRow[cc.ColumnName]));
}
}
DatabaseConnection.DoCommand(string.Format("{0}){1});", sbColumn.ToString(0, sbColumn.Length - 1), sbValue.ToString(0, sbValue.Length - 1)), sqlParam);
loadedRows++;
}
else
{
reduntantRows++;
}
}
LblInfo.Text = Root.rm.GetString("Csvtxt9") + loadedRows.ToString() + "<br>" +
Root.rm.GetString("Csvtxt10") + reduntantRows.ToString() + "<br>" +
Root.rm.GetString("Csvtxt10") + unmatchingRows.ToString();
UploadForm.Visible = false;
dataform.Visible = false;
Matchdiv.Visible = false;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "NoData", "<script>alert('" + Root.rm.GetString("Csvtxt26") + "');</script>");
}
break;
}
HelpLabel.Visible = false;
Session.Remove("CSV");
}
public void HideTutorielStep()
{
StartCoroutine(StaticFunctions.FadeOutAlpha(result => _tutorialImage.color = result, _tutorialImage.color, 1f, DisableImage));
}
public Documento UsuariosExportarExcel(UsuarioFilter filter)
{
SLExcelData data = new SLExcelData();
try
{
data.HeadersFiltro = new List <string>();
data.HeadersFiltro.Add("Nombre");
data.HeadersFiltro.Add("Apellido");
data.HeadersFiltro.Add("Rol");
List <string> rowFiltro = new List <string>();
if (filter.nombre != null)
{
rowFiltro.Add(filter.nombre);
}
else
{
rowFiltro.Add("Sin datos");
}
if (filter.apellido != null)
{
rowFiltro.Add(filter.apellido);
}
else
{
rowFiltro.Add("Sin datos");
}
switch (filter.idRol)
{
case 1:
rowFiltro.Add("Dueño");
break;
case 2:
rowFiltro.Add("Ingeniero");
break;
case 3:
rowFiltro.Add("Peón");
break;
default:
rowFiltro.Add("Sin datos");
break;
}
data.DataRowsFiltro = new List <List <string> >();
data.DataRowsFiltro.Add(rowFiltro);
var lista = GetList(filter);
data.Headers.Add("Usuario");
data.Headers.Add("Nombre");
data.Headers.Add("Apellido");
data.Headers.Add("Rol");
data.Headers.Add("Estado");
data.Headers.Add("Fecha Alta");
data.Headers.Add("Fecha Baja");
foreach (var item in lista)
{
List <string> row = new List <string>();
row.Add(item.usuario);
row.Add(item.nombre);
row.Add(item.apellido);
if (item.idRol == 1)
{
row.Add("Dueño");
}
else if (item.idRol == 2)
{
row.Add("Ingeniero");
}
else
{
row.Add("Peón");
}
row.Add(item.fechaBaja == " " ? "Activo" : "Inactivo");
row.Add(item.fechaAlta != " " ? item.fechaAlta : "-");
row.Add(item.fechaBaja != " " ? item.fechaBaja : "-");
data.DataRows.Add(row);
}
var archivo = StaticFunctions.GenerateExcel(data, "Usuarios", filter.campo, filter.usuario, filter.periodo);
return(new Documento()
{
nombre = archivo
});
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ArrayList pp = Rowediting1.ProductRows();
if (pp.Count > 0)
{
bool newQuote;
long billId;
using (DigiDapter dg = new DigiDapter())
{
dg.Add("OWNERID", this.TextboxSearchOwnerID.Text);
if (this.TextboxSearchManagerID.Text.Length > 0)
{
dg.Add("MANAGERID", this.TextboxSearchManagerID.Text);
}
if (this.TextboxSearchSignalerID.Text.Length > 0)
{
dg.Add("SIGNALER", this.TextboxSearchSignalerID.Text);
}
dg.Add("SUBJECT", this.QSubject.Text);
dg.Add("DESCRIPTION", this.QuoteDescription.Text);
dg.Add("CURRENCY", Rowediting1.RowEstCurrency);
dg.Add("CHANGE", StaticFunctions.FixDecimal(Rowediting1.RowEstChange));
DateTime ExpirationDate;
try
{
ExpirationDate = UC.LTZ.ToUniversalTime(Convert.ToDateTime(QValidData.Text));
}
catch
{
ExpirationDate = DateTime.Now.AddDays(30);
}
dg.Add("EXPIRATIONDATE", ExpirationDate);
DateTime QuoteDate;
try
{
QuoteDate = UC.LTZ.ToUniversalTime(Convert.ToDateTime(QuoteData.Text));
}
catch
{
QuoteDate = DateTime.Now;
}
dg.Add("QUOTEDATE", QuoteDate);
if (ShipDescription.SelectedIndex > 0)
{
dg.Add("SHIPID", ShipDescription.SelectedValue.Split('|')[0]);
}
if (ShipData.Text.Length > 0)
{
dg.Add("SHIPDATE", UC.LTZ.ToUniversalTime(Convert.ToDateTime(ShipData.Text)));
}
dg.Add("LASTMODIFIEDDATE", DateTime.Now);
dg.Add("LASTMODIFIEDBYID", UC.UserId);
if (this.QuoteID == -1)
{
dg.Add("CREATEDBYID", UC.UserId);
}
dg.Add("ACTIVITYID", this.ActivityID);
if (this.QStage.SelectedValue == "-1")
{
dg.Add("STAGE", ((int)QuoteStage.Negotiation).ToString());
}
else
{
dg.Add("STAGE", this.QStage.SelectedValue);
}
dg.Add("PAYMENTID", this.QPayment.SelectedValue);
Object progressive;
progressive = DatabaseConnection.SqlScalartoObj("SELECT DISABLED FROM QUOTENUMBERS WHERE TYPE=0");
if (progressive != null && !((bool)progressive))
{
DataRow drprog;
drprog = DatabaseConnection.CreateDataset("SELECT * FROM QUOTENUMBERS WHERE TYPE=0").Tables[0].Rows[0];
string newprog = string.Empty;
if (Convert.ToInt32(drprog["NPROGRESTART"]) > 0)
{
if (DateTime.Now >= new DateTime(DateTime.Now.Year, Convert.ToInt32(drprog["NPROGRESTART"]), 1) && new DateTime(DateTime.Now.Year, Convert.ToInt32(drprog["NPROGRESTART"]), 1) >= (DateTime)drprog["LASTRESET"])
{
DatabaseConnection.DoCommand("UPDATE QUOTENUMBERS SET NPROG=NPROGSTART,LASTRESET=GETDATE() WHERE TYPE=0");
drprog = DatabaseConnection.CreateDataset("SELECT * FROM QUOTENUMBERS WHERE TYPE=0").Tables[0].Rows[0];
}
}
newprog += (((int)drprog["NPROG"]) + 1).ToString();
if ((bool)drprog["CHECKDAY"])
{
newprog += "-" + DateTime.Now.Day.ToString();
}
if ((bool)drprog["CHECKMONTH"])
{
newprog += "-" + DateTime.Now.Month.ToString();
}
if ((bool)drprog["CHECKYEAR"])
{
if ((bool)drprog["TWODIGITYEAR"])
{
newprog += "-" + DateTime.Now.ToString("yyyy");
}
else
{
newprog += "-" + DateTime.Now.ToString("yy");
}
}
if ((bool)drprog["CHECKCUSTOMERCODE"])
{
switch (CrossWith.SelectedIndex)
{
case 0:
newprog += "-" + DatabaseConnection.SqlScalar("SELECT COMPANYCODE FROM BASE_COMPANIES WHERE ID=" + CrossWithID.Text);
break;
case 1:
break;
case 2:
break;
}
}
this.Qnumber.Text = newprog;
DatabaseConnection.DoCommand("UPDATE QUOTENUMBERS SET NPROG=NPROG+1 WHERE TYPE=0");
}
if (this.Qnumber.Text.Length > 0)
{
dg.Add("NUMBER", this.Qnumber.Text);
}
dg.Add("REDUCTION", 0);
dg.Add("CROSSTYPE", CrossWith.SelectedValue);
dg.Add("CROSSID", CrossWithID.Text);
dg.Add("ADDRESS", QAddress.Text);
dg.Add("SHIPADDRESS", SAddress.Text);
dg.Add("GRANDTOTAL", Convert.ToDecimal(Request["grandtotal"]));
dg.Add("SUBTOTAL", Convert.ToDecimal(Request["subtotal"]));
dg.Add("TAXTOTAL", Convert.ToDecimal(Request["taxtotal"]));
dg.Add("SHIP", (Request["shiptotal"].Length > 0)?Convert.ToDecimal(Request["shiptotal"]):0);
dg.Add("SHIPVAT", (Request["shipVat"].Length > 0)?Convert.ToDecimal(Request["shipVat"]):0);
dg.Add("GROUPS", "|" + UC.UserGroupId.ToString() + "|");
dg.Add("INCLUDEPRODPDF", (chkIncludePDFDoc.Checked)?1:0);
dg.Add("LIST", currentPriceList.Text);
billId = Convert.ToInt64(dg.Execute("QUOTES", "id=" + this.QuoteID, DigiDapter.Identities.Identity));
if (this.QuoteID == -1)
{
this.QuoteID = Convert.ToInt64(billId);
}
newQuote = dg.RecordInserted;
}
if (!newQuote)
{
DatabaseConnection.DoCommand("DELETE FROM QUOTEROWS WHERE ESTIMATEID=" + this.QuoteID);
DatabaseConnection.DoCommand("DELETE FROM QUOTEDOCUMENT WHERE QUOTEID=" + this.QuoteID);
}
foreach (PurchaseProduct Pprod in pp)
{
using (DigiDapter dg = new DigiDapter())
{
dg.Add("ESTIMATEID", this.QuoteID);
dg.Add("DESCRIPTION", Pprod.ShortDescription);
dg.Add("DESCRIPTION2", Pprod.LongDescription);
dg.Add("UPRICE", Pprod.UnitPrice);
dg.Add("NEWUPRICE", Pprod.FinalPrice);
dg.Add("LISTPRICE", Pprod.ListPrice);
dg.Add("CATALOGID", Pprod.id);
dg.Add("QTA", Pprod.Qta);
dg.Add("REDUCTION", Pprod.Reduction);
dg.Add("TAX", Pprod.Vat);
dg.Add("COST", Pprod.Cost);
dg.Add("PRODUCTCODE", Pprod.ProductCode);
dg.Add("REALLISTPRICE", Pprod.RealListPrice);
dg.Execute("QUOTEROWS");
}
}
if (Request["IDDocument"] != null && Request["IDDocument"].ToString().Length > 0)
{
using (DigiDapter dg = new DigiDapter())
{
dg.Add("QUOTEID", this.QuoteID);
dg.Add("DOCUMENTID", Convert.ToInt64(Request["IDDocument"]));
dg.Execute("QUOTEDOCUMENT");
}
}
int otherdocument = 1;
while (Request["IDDocument_" + otherdocument] != null && Request["IDDocument_" + otherdocument].ToString().Length > 0)
{
using (DigiDapter dg = new DigiDapter())
{
dg.Add("QUOTEID", this.QuoteID);
dg.Add("DOCUMENTID", Convert.ToInt64(Request["IDDocument_" + otherdocument]));
dg.Execute("QUOTEDOCUMENT");
}
otherdocument++;
}
ClientScript.RegisterStartupScript(this.GetType(), "OK", "<script>alert('" + string.Format(Root.rm.GetString("Esttxt19"), this.Qnumber.Text) + "');location.href='/erp/quotelist.aspx?m=67&dgb=1&si=69';</script>");
FillQuote(this.QuoteID);
if (CheckActivity.Checked && CrossWithID.Text.Length > 0)
{
ActivityInsert ai = new ActivityInsert();
string A = "";
string C = "";
string L = "";
switch (CrossWith.SelectedValue)
{
case "0":
A = CrossWithID.Text;
C = "";
L = "";
break;
case "1":
C = CrossWithID.Text;
A = "";
L = "";
break;
case "2":
L = CrossWithID.Text;
A = "";
C = "";
break;
}
if (A.Length > 0 || C.Length > 0 || L.Length > 0)
{
ai.InsertActivity("7", "", UC.UserId.ToString(), C, A, L, Root.rm.GetString("Esttxt2") + ":" + this.QSubject.Text, this.QuoteDescription.Text, UC.LTZ.ToUniversalTime(DateTime.Now), UC, 1);
}
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "OK", "<script>alert('" + Root.rm.GetString("Quotxt29") + "');</script>");
}
}
public Documento ClientesExportarExcel(ReporteFilter filter)
{
SLExcelData data = new SLExcelData();
try
{
data.HeadersFiltro = new List <string>();
data.HeadersFiltro.Add("Apellido");
data.HeadersFiltro.Add("Nombre");
data.HeadersFiltro.Add("Estado Cuenta");
data.HeadersFiltro.Add("Plan");
data.HeadersFiltro.Add("Fecha Desde");
data.HeadersFiltro.Add("Fecha Hasta");
List <string> rowFiltro = new List <string>();
if (filter.apellido != null)
{
rowFiltro.Add(filter.apellido);
}
else
{
rowFiltro.Add("Sin datos");
}
if (filter.nombre != null)
{
rowFiltro.Add(filter.nombre);
}
else
{
rowFiltro.Add("Sin datos");
}
if (filter.estadoCuenta != "0")
{
rowFiltro.Add(filter.estadoCuenta);
}
else
{
rowFiltro.Add("Sin datos");
}
switch (filter.idPlan)
{
case 1:
rowFiltro.Add("Plan pequeño");
break;
case 2:
rowFiltro.Add("Plan mediano");
break;
case 3:
rowFiltro.Add("Plan grande");
break;
case 4:
rowFiltro.Add("Plan super");
break;
default:
rowFiltro.Add("Sin datos");
break;
}
if (filter.fechaDesde != null)
{
rowFiltro.Add(filter.fechaDesde);
}
else
{
rowFiltro.Add("Sin datos");
}
if (filter.fechaHasta != null)
{
rowFiltro.Add(filter.fechaHasta);
}
else
{
rowFiltro.Add("Sin datos");
}
data.DataRowsFiltro = new List <List <string> >();
data.DataRowsFiltro.Add(rowFiltro);
var lista = GetClientes(filter);
data.Headers.Add("Apellido");
data.Headers.Add("Nombre");
data.Headers.Add("Fecha Alta");
data.Headers.Add("Plan Contratado");
data.Headers.Add("Administradores");
data.Headers.Add("Usuarios");
data.Headers.Add("Campos");
data.Headers.Add("Bovinos");
data.Headers.Add("Estado Cuenta");
foreach (var item in lista)
{
List <string> row = new List <string>();
row.Add(item.apellido);
row.Add(item.nombre);
row.Add(item.fechaAlta);
if (item.idPlan == 1)
{
row.Add("Plan Pequeño");
}
else if (item.idPlan == 2)
{
row.Add("Plan Mediano");
}
else if (item.idPlan == 3)
{
row.Add("Plan Grande");
}
else
{
row.Add("Plan Super");
}
row.Add(item.cantidadAdministradores.ToString());
row.Add(item.cantidadUsuarios.ToString());
row.Add(item.cantidadCampos.ToString());
row.Add(item.cantidadBovinos.ToString());
row.Add(item.estadoCuenta);
data.DataRows.Add(row);
}
var archivo = StaticFunctions.GenerateExcel(data, "Clientes", filter.campo, filter.usuario, filter.periodo);
return(new Documento()
{
nombre = archivo
});
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public void ToggleCheckpoints(bool value)
{
StaticFunctions.ToggleTextYesNo(checkpointsToggleText, value);
userData.SetCheckpoints(value);
masterManager.SaveSettings();
}
public Action GetActionSlot(StateManager st)
{
ActionInput a_input = GetActionInput(st);
return(StaticFunctions.GetAction(a_input, actionSlots));
}
public void ToggleDynamicLights(bool value)
{
StaticFunctions.ToggleTextYesNo(dynamicLightsToggleText, value);
userData.SetDynamicLights(value);
masterManager.SaveSettings();
}
public string GetCompanyQuery()
{
string formAdvanced_CompanyName = String.Empty;
string formAdvanced_Address = String.Empty;
string formAdvanced_City = String.Empty;
string formAdvanced_State = String.Empty;
string formAdvanced_Nation = String.Empty;
string formAdvanced_Zip = String.Empty;
string formAdvanced_Phone = String.Empty;
string formAdvanced_Fax = String.Empty;
string formAdvanced_Email = String.Empty;
string formAdvanced_Site = String.Empty;
string formAdvanced_Code = String.Empty;
string formSAdvanced_CompanyType = String.Empty;
string formSAdvanced_ContactType = String.Empty;
string formAdvanced_Billed = String.Empty;
string formAdvanced_Employees = String.Empty;
string formSAdvanced_Estimate = String.Empty;
string formSAdvanced_Category = String.Empty;
string formSAdvanced_Opportunity = String.Empty;
foreach (string strKey in Request.Params.Keys)
{
if (strKey.IndexOf("Advanced_CompanyName") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_CompanyName.IndexOf(Request[strKey]) < 0)
{
formAdvanced_CompanyName += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_Address") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Address.IndexOf(Request[strKey]) < 0)
{
formAdvanced_Address += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_City") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_City.IndexOf(Request[strKey]) < 0)
{
formAdvanced_City += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_State") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_State.IndexOf(Request[strKey]) < 0)
{
formAdvanced_State += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_Nation") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Nation.IndexOf(Request[strKey]) < 0)
{
formAdvanced_Nation += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_Zip") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Zip.IndexOf(Request[strKey]) < 0)
{
formAdvanced_Zip += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_Phone") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Phone.IndexOf(Request[strKey]) < 0)
{
formAdvanced_Phone += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_Fax") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Fax.IndexOf(Request[strKey]) < 0)
{
formAdvanced_Fax += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_Email") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Email.IndexOf(Request[strKey]) < 0)
{
formAdvanced_Email += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_Site") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Site.IndexOf(Request[strKey]) < 0)
{
formAdvanced_Site += Request[strKey] + "|";
}
}
if (strKey.IndexOf("Advanced_Code") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Code.IndexOf(Request[strKey]) < 0)
{
formAdvanced_Code += Request[strKey] + "|";
}
}
if (strKey.IndexOf("SAdvanced_CompanyType") > -1)
{
if (Request[strKey].Length > 0 && Request[strKey] != "0" && formSAdvanced_CompanyType.IndexOf(Request[strKey]) < 0)
{
formSAdvanced_CompanyType += Request[strKey] + "|";
}
}
if (strKey.IndexOf("SAdvanced_ContactType") > -1 && formSAdvanced_ContactType.IndexOf(Request[strKey]) < 0)
{
if (Request[strKey].Length > 0 && Request[strKey] != "0")
{
formSAdvanced_ContactType += Request[strKey] + "|";
}
}
if (strKey.IndexOf("RFormAdvanced_Billed") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Billed.IndexOf(Request[strKey]) < 0)
{
string suffix = String.Empty;
if (strKey.Length > 16)
{
suffix = strKey.Substring(16, strKey.Length - 16);
}
switch (Request[strKey])
{
case "0":
formAdvanced_Billed += "a" + Request["Advanced_Billed" + suffix] + "|";
break;
case "1":
formAdvanced_Billed += "b" + Request["Advanced_Billed" + suffix] + "|";
break;
case "2":
formAdvanced_Billed += "c" + Request["Advanced_Billed" + suffix] + "|";
break;
case "3":
formAdvanced_Billed += "d" + Request["Advanced_Billed" + suffix] + "|";
break;
case "4":
formAdvanced_Billed += "e" + Request["Advanced_Billed" + suffix] + "|";
break;
case "5":
formAdvanced_Billed += "f" + Request["Advanced_Billed" + suffix] + "|";
break;
}
}
}
if (strKey.IndexOf("RAdvanced_Employees") > -1)
{
if (Request[strKey].Length > 0 && formAdvanced_Employees.IndexOf(Request[strKey]) < 0)
{
string suffix = String.Empty;
if (strKey.Length > 19)
{
suffix = strKey.Substring(19, strKey.Length - 19);
}
switch (suffix)
{
case "0":
formAdvanced_Employees += "a" + Request["Advanced_Employees" + suffix] + "|";
break;
case "1":
formAdvanced_Employees += "b" + Request["Advanced_Employees" + suffix] + "|";
break;
case "2":
formAdvanced_Employees += "c" + Request["Advanced_Employees" + suffix] + "|";
break;
case "3":
formAdvanced_Employees += "d" + Request["Advanced_Employees" + suffix] + "|";
break;
case "4":
formAdvanced_Employees += "e" + Request["Advanced_Employees" + suffix] + "|";
break;
case "5":
formAdvanced_Employees += "f" + Request["Advanced_Employees" + suffix] + "|";
break;
}
}
}
if (strKey.IndexOf("SAdvanced_Estimate") > -1)
{
if (Request[strKey].Length > 0 && Request[strKey] != "0" && formSAdvanced_Estimate.IndexOf(Request[strKey]) < 0)
{
formSAdvanced_Estimate += Request[strKey] + "|";
}
}
if (strKey.IndexOf("SAdvanced_Category") > -1)
{
if (Request[strKey].Length > 0 && Request[strKey] != "0" && formSAdvanced_Category.IndexOf(Request[strKey]) < 0)
{
formSAdvanced_Category += Request[strKey] + "|";
}
}
if (strKey.IndexOf("SAdvanced_Opportunity") > -1)
{
if (Request[strKey].Length > 0 && Request[strKey] != "0" && formSAdvanced_Opportunity.IndexOf(Request[strKey]) < 0)
{
formSAdvanced_Opportunity += Request[strKey] + "|";
}
}
}
string queryType = String.Empty;
string Advanced_CompanyName = String.Empty;
string Advanced_Address = String.Empty;
string Advanced_City = String.Empty;
string Advanced_State = String.Empty;
string Advanced_Zip = String.Empty;
string Advanced_Phone = String.Empty;
string Advanced_Fax = String.Empty;
string Advanced_Email = String.Empty;
string Advanced_Site = String.Empty;
string Advanced_Code = String.Empty;
string SAdvanced_CompanyType = String.Empty;
string SAdvanced_ContactType = String.Empty;
string Advanced_Billed = String.Empty;
string Advanced_Employees = String.Empty;
string SAdvanced_Estimate = String.Empty;
string SAdvanced_Category = String.Empty;
string SAdvanced_Opportunity = String.Empty;
queryType = " AND ((BASE_COMPANIES.FLAGGLOBALORPERSONAL=2 AND BASE_COMPANIES.OWNERID=" + UC.UserId.ToString() + ") oR (BASE_COMPANIES.FLAGGLOBALORPERSONAL<>2))";
StringBuilder sqlString = new StringBuilder();
sqlString.AppendFormat("SELECT TOP {0} BASE_COMPANIES.ID,", DatabaseConnection.MaxResult);
if (this.onlyName)
{
sqlString.Append("BASE_COMPANIES.COMPANYNAME,BASE_COMPANIES.PHONE,BASE_COMPANIES.FAX,BASE_COMPANIES.EMAIL,BASE_COMPANIES.DESCRIPTION,BASE_COMPANIES.GROUPS, BASE_COMPANIES.SALESPERSONID, BASE_COMPANIES.OWNERID ");
}
if (this.primaryAddress)
{
sqlString.Append("BASE_COMPANIES.INVOICINGADDRESS,BASE_COMPANIES.INVOICINGCITY,BASE_COMPANIES.INVOICINGSTATEPROVINCE,BASE_COMPANIES.INVOICINGSTATE,BASE_COMPANIES.INVOICINGZIPCODE,");
}
if (this.secondAddress)
{
sqlString.Append("BASE_COMPANIES.SHIPMENTADDRESS,BASE_COMPANIES.SHIPMENTCITY,BASE_COMPANIES.SHIPMENTSTATEPROVINCE,BASE_COMPANIES.SHIPMENTSTATE,BASE_COMPANIES.SHIPMENTZIPCODE,BASE_COMPANIES.SHIPMENTPHONE,BASE_COMPANIES.SHIPMENTFAX,BASE_COMPANIES.SHIPMENTEMAIL,");
}
if (this.thirdAddress)
{
sqlString.Append("BASE_COMPANIES.WAREHOUSEADDRESS,BASE_COMPANIES.WAREHOUSECITY,BASE_COMPANIES.WAREHOUSESTATEPROVINCE,BASE_COMPANIES.WAREHOUSESTATE,BASE_COMPANIES.WAREHOUSEZIPCODE,BASE_COMPANIES.WAREHOUSEPHONE,BASE_COMPANIES.WAREHOUSEFAX,BASE_COMPANIES.WAREHOUSEEMAIL,");
}
if (this.mlMailField)
{
sqlString.Append("CAST(BASE_COMPANIES.ID AS VARCHAR(12))+'|'+ISNULL(BASE_COMPANIES.MLEMAIL, BASE_COMPANIES.EMAIL)+'|'+BASE_COMPANIES.COMPANYNAME AS IDMAIL,");
}
sqlString.Remove(sqlString.Length - 1, 1);
sqlString.Append(" FROM BASE_COMPANIES ");
if (formSAdvanced_Opportunity.Length > 0)
{
sqlString.Append("INNER JOIN CRM_OPPORTUNITYCONTACT ON BASE_COMPANIES.ID = CRM_OPPORTUNITYCONTACT.CONTACTID AND CRM_OPPORTUNITYCONTACT.CONTACTTYPE = 0 ");
}
if (geoCheck.Checked)
{
sqlString.AppendFormat("JOIN GEO.DBO.NEARCITIES('{0}','{1}',{2}) AS GEO ON GEO.CITY = INVOICINGCITY ", DatabaseConnection.FilterInjection(geoCity.Text), geoCountry.SelectedValue, DatabaseConnection.FilterInjection(geoDistance.Text));
}
sqlString.AppendFormat("WHERE (BASE_COMPANIES.LIMBO=0) {0} AND (", queryType);
string[] strKeys = formSAdvanced_Opportunity.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
SAdvanced_Opportunity += String.Format("(CRM_OPPORTUNITYCONTACT.OPPORTUNITYID = {0}) OR ", int.Parse(strKey));
}
}
strKeys = formAdvanced_CompanyName.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_CompanyName += String.Format("(BASE_COMPANIES.COMPANYNAME LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_Address.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_Address += String.Format("(BASE_COMPANIES.INVOICINGADDRESS LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_City.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_City += String.Format("(BASE_COMPANIES.INVOICINGCITY LIKE '%{0}%' OR BASE_COMPANIES.SHIPMENTCITY LIKE '%{0}%' OR BASE_COMPANIES.WAREHOUSECITY LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_State.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_State += String.Format("(BASE_COMPANIES.INVOICINGSTATEPROVINCE LIKE '%{0}%' OR BASE_COMPANIES.SHIPMENTSTATEPROVINCE LIKE '%{0}%' OR BASE_COMPANIES.WAREHOUSESTATEPROVINCE LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_Nation.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_State += String.Format("(BASE_COMPANIES.INVOICINGSTATE LIKE '%{0}%' OR BASE_COMPANIES.SHIPMENTSTATE LIKE '%{0}%' OR BASE_COMPANIES.WAREHOUSESTATE LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_Zip.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_Zip += String.Format("(BASE_COMPANIES.INVOICINGZIPCODE LIKE '%{0}%' OR BASE_COMPANIES.SHIPMENTZIPCODE LIKE '%{0}%' OR BASE_COMPANIES.WAREHOUSEZIPCODE LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_Phone.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_Phone += String.Format("(BASE_COMPANIES.PHONE LIKE '%{0}%' OR BASE_COMPANIES.SHIPMENTPHONE LIKE '%{0}%' OR BASE_COMPANIES.WAREHOUSEPHONE LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_Fax.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_Fax += String.Format("(BASE_COMPANIES.FAX LIKE '%{0}%' OR BASE_COMPANIES.SHIPMENTFAX LIKE '%{0}%' OR BASE_COMPANIES.WAREHOUSEFAX LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_Email.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_Email += String.Format("(BASE_COMPANIES.EMAIL LIKE '%{0}%' OR BASE_COMPANIES.SHIPMENTEMAIL LIKE '%{0}%' OR BASE_COMPANIES.WAREHOUSEEMAIL LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_Site.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_Site += String.Format("(BASE_COMPANIES.WEBSITE LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_Code.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
Advanced_Code += String.Format("(BASE_COMPANIES.COMPANYCODE LIKE '%{0}%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formSAdvanced_CompanyType.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
SAdvanced_CompanyType += String.Format("(BASE_COMPANIES.COMPANYTYPEID = '{0}') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formSAdvanced_ContactType.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
SAdvanced_ContactType += String.Format("(BASE_COMPANIES.CONTACTTYPEID = '{0}') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
strKeys = formAdvanced_Billed.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
switch (strKey.Substring(0, 1))
{
case "a":
Advanced_Billed += String.Format("(BASE_COMPANIES.BILLED = {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "b":
Advanced_Billed += String.Format("(BASE_COMPANIES.BILLED <= {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "c":
Advanced_Billed += String.Format("(BASE_COMPANIES.BILLED < {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "d":
Advanced_Billed += String.Format("(BASE_COMPANIES.BILLED <> {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "e":
Advanced_Billed += String.Format("(BASE_COMPANIES.BILLED > {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "f":
Advanced_Billed += String.Format("(BASE_COMPANIES.BILLED >= {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
}
}
}
strKeys = formAdvanced_Employees.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
switch (strKey.Substring(0, 1))
{
case "a":
Advanced_Employees += String.Format("(BASE_COMPANIES.EMPLOYEES = {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "b":
Advanced_Employees += String.Format("(BASE_COMPANIES.EMPLOYEES <= {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "c":
Advanced_Employees += String.Format("(BASE_COMPANIES.EMPLOYEES < {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "d":
Advanced_Employees += String.Format("(BASE_COMPANIES.EMPLOYEES <> {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "e":
Advanced_Employees += String.Format("(BASE_COMPANIES.EMPLOYEES > {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
case "f":
Advanced_Employees += String.Format("(BASE_COMPANIES.EMPLOYEES >= {0}) OR ", int.Parse(strKey.Substring(1, strKey.Length - 1)));
break;
}
}
}
strKeys = formSAdvanced_Estimate.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
SAdvanced_Estimate += String.Format("(BASE_COMPANIES.ESTIMATE = {0}) OR ", strKey);
}
}
strKeys = formSAdvanced_Category.Split('|');
foreach (string strKey in strKeys)
{
if (strKey.Length > 0)
{
SAdvanced_Category += String.Format("(BASE_COMPANIES.CATEGORIES LIKE '%|{0}|%') OR ", DatabaseConnection.FilterInjection(strKey));
}
}
string sqlAv = sqlString.ToString();
string sAnd = String.Empty;
if (Advanced_CompanyName.Length > 0)
{
sqlAv += sAnd + Advanced_CompanyName.Substring(0, Advanced_CompanyName.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_Address.Length > 0)
{
sqlAv += sAnd + Advanced_Address.Substring(0, Advanced_Address.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_City.Length > 0)
{
sqlAv += sAnd + Advanced_City.Substring(0, Advanced_City.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_State.Length > 0)
{
sqlAv += sAnd + Advanced_State.Substring(0, Advanced_State.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_Zip.Length > 0)
{
sqlAv += sAnd + Advanced_Zip.Substring(0, Advanced_Zip.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_Phone.Length > 0)
{
sqlAv += sAnd + Advanced_Phone.Substring(0, Advanced_Phone.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_Fax.Length > 0)
{
sqlAv += sAnd + Advanced_Fax.Substring(0, Advanced_Fax.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_Email.Length > 0)
{
sqlAv += sAnd + Advanced_Email.Substring(0, Advanced_Email.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_Site.Length > 0)
{
sqlAv += sAnd + Advanced_Site.Substring(0, Advanced_Site.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_Code.Length > 0)
{
sqlAv += sAnd + Advanced_Code.Substring(0, Advanced_Code.Length - 3) + ")";
sAnd = " AND (";
}
if (SAdvanced_CompanyType.Length > 0)
{
sqlAv += sAnd + SAdvanced_CompanyType.Substring(0, SAdvanced_CompanyType.Length - 3) + ")";
sAnd = " AND (";
}
if (SAdvanced_ContactType.Length > 0)
{
sqlAv += sAnd + SAdvanced_ContactType.Substring(0, SAdvanced_ContactType.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_Billed.Length > 0)
{
sqlAv += sAnd + Advanced_Billed.Substring(0, Advanced_Billed.Length - 3) + ")";
sAnd = " AND (";
}
if (Advanced_Employees.Length > 0)
{
sqlAv += sAnd + Advanced_Employees.Substring(0, Advanced_Employees.Length - 3) + ")";
sAnd = " AND (";
}
if (SAdvanced_Estimate.Length > 0)
{
sqlAv += sAnd + SAdvanced_Estimate.Substring(0, SAdvanced_Estimate.Length - 3) + ")";
sAnd = " AND (";
}
if (SAdvanced_Category.Length > 0)
{
sqlAv += sAnd + SAdvanced_Category.Substring(0, SAdvanced_Category.Length - 3) + ")";
sAnd = " AND (";
}
if (SAdvanced_Opportunity.Length > 0)
{
sqlAv += sAnd + SAdvanced_Opportunity.Substring(0, SAdvanced_Opportunity.Length - 3) + ")";
sAnd = " AND (";
}
if (sqlAv.EndsWith("AND ("))
{
sqlAv = sqlAv.Substring(0, sqlAv.Length - 5);
}
if (AdvancedCreatedDate1.Text.Length > 0 && AdvancedCreatedDate2.Text.Length > 0)
{
if (StaticFunctions.IsDate(AdvancedCreatedDate1.Text) && StaticFunctions.IsDate(AdvancedCreatedDate1.Text))
{
sqlAv += " AND (BASE_COMPANIES.CREATEDDATE BETWEEN '" + Convert.ToDateTime(AdvancedCreatedDate1.Text + " 00:00").ToString(@"yyyyMMdd HH:mm", G.InvariantCultureForDB) + "' AND '" + Convert.ToDateTime(AdvancedCreatedDate2.Text + " 23:59").ToString(@"yyyyMMdd HH:mm", G.InvariantCultureForDB) + "') ";
}
}
G g = new G();
string queryGroup = g.GroupsSecure("BASE_COMPANIES.GROUPS", UC);
if (queryGroup.Length > 0)
{
sqlAv += String.Format(" AND ({0})", queryGroup);
}
if (UC.Zones.Length > 0)
{
sqlAv += String.Format(" AND ({0})", g.ZoneSecure("BASE_COMPANIES.COMMERCIALZONE", UC));
}
return(sqlAv + " ORDER BY BASE_COMPANIES.COMPANYNAME");
}
private void InitContr()
{
if (dsLoad != null)
{
return;
}
dsFormUkyndaAdt = this.GetFrmLoadUkyndaDsAdt(strBusClassName);
dsFormUkyndaAdt.AcceptChanges();
dsFormAdt = this.GetFrmLoadDsAdt(strBusClassName);
dsFormAdt.AcceptChanges();
dsLoad = this.GetFrmLoadDsNew(strBusClassName);
dsLoad.AcceptChanges();
dtShow = dsLoad.Tables[0];
dtConst = dsLoad.Tables[1];
drMain = dsLoad.Tables[2].Rows[0];
strSpName = drMain["SpName"].ToString();
strQueryFlag = drMain["QueryFlag"].ToString();
dtBtns = dsLoad.Tables[3];
dtTabs = dsLoad.Tables[4];
dtGroupC = dsLoad.Tables[5];
dtSte = dsLoad.Tables[6];
dtContr = dsLoad.Tables[7];
dtBtnsM = dsLoad.Tables[8];
dtSp = dsLoad.Tables[9];
ParentControl = gcQuery;
int igcHeight;
Rectangle rect = SystemInformation.VirtualScreen;
List <Control> lisGcContrs = StaticFunctions.ShowGroupControl(gcQuery, rect.Width - 50, dtShow, dtConst, true, 30, false, null, true, out igcHeight);
List <BarButtonItem> lisBarItems = StaticFunctions.ShowBarButtonItem(dtBtns, bar2, "bar2", strAllowList, imageList1);
foreach (BarButtonItem item in lisBarItems)
{
item.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.btn_ItemClick);
}
gcItems = StaticFunctions.ShowTabItem(dtTabs, xtabItemInfo, "xtabItemInfo", strAllowList, lisrepImg);
foreach (string strGv in gcItems.Keys)
{
StaticFunctions.ShowGridControl(gcItems[strGv], dtShow, dtConst);
StaticFunctions.SaveOrLoadDelLayout(gcItems[strGv], this.strBusClassName + "_" + strGv, "LOAD");
StaticFunctions.SetGridViewStyleFormatCondition(gcItems[strGv], dtBtnsM);
}
#region gcQuery
foreach (Control ctrl in lisGcContrs)
{
switch (ctrl.GetType().ToString())
{
case "DevExpress.XtraEditors.TextEdit":
break;
case "DevExpress.XtraEditors.CheckEdit":
break;
case "DevExpress.XtraEditors.LookUpEdit":
LookUpEdit dpl = ctrl as LookUpEdit;
dpl.Properties.QueryPopUp += new System.ComponentModel.CancelEventHandler(this.lookUpEdit_Properties_QueryPopUp);
dpl.Properties.Closed += new DevExpress.XtraEditors.Controls.ClosedEventHandler(this.lookUpEdit_Properties_Closed);
break;
case "DevExpress.XtraEditors.CheckedComboBoxEdit":
CheckedComboBoxEdit chkdpl = ctrl as CheckedComboBoxEdit;
chkdpl.Properties.Closed += new DevExpress.XtraEditors.Controls.ClosedEventHandler(this.lookUpEdit_Properties_Closed);
break;
case "DevExpress.XtraEditors.DateEdit":
break;
case "ProduceManager.UcTxtPopup":
ProduceManager.UcTxtPopup ucp = ctrl as ProduceManager.UcTxtPopup;
ucp.onClosePopUp += new UcTxtPopup.ClosePopUp(ucp_onClosePopUp);
StaticFunctions.BoundSpicalContr(dtContr, dsFormAdt, dsFormUkyndaAdt, ucp, dtShow);
break;
case "ProduceManager.UcTreeList":
ProduceManager.UcTreeList uct = ctrl as ProduceManager.UcTreeList;
uct.onClosePopUp += new UcTreeList.ClosePopUp(uct_onClosePopUp);
StaticFunctions.BoundSpicalContr(dtContr, dsFormAdt, dsFormUkyndaAdt, uct, dtShow);
break;
case "ExtendControl.ExtPopupTree":
ExtendControl.ExtPopupTree ept = ctrl as ExtendControl.ExtPopupTree;
ept.Properties.Closed += new DevExpress.XtraEditors.Controls.ClosedEventHandler(this.lookUpEdit_Properties_Closed);
StaticFunctions.BoundSpicalContr(dtContr, dsFormAdt, dsFormUkyndaAdt, ept, dtShow);
break;
default:
break;
}
}
#endregion
StaticFunctions.SetBtnStyle(barManager1, null, drMain);
if (drMain["HideQuery"].ToString() == "True")
{
gcQuery.Visible = false;
}
if (xtabItemInfo.TabPages.Count == 1)
{
xtabItemInfo.ShowTabHeader = DevExpress.Utils.DefaultBoolean.False;
}
else
{
xtabItemInfo.ShowTabHeader = DevExpress.Utils.DefaultBoolean.True;
}
}
//组合模式
private void btnLayoutMode_Click(object sender, EventArgs e)
{
StaticFunctions.ChangeView(gridCMain, gridCMain.LevelTree, "LayoutView", true);
}
private void SetPressShifts()
{
PressShifts.Clear();
DateTime lastShiftBegin = ShiftHandler.CoatingInstance.GetPreviousShiftStart(StaticFunctions.GetDayAndTime(CoatingLine.Date,
CoatingLine.Shift.StartTime), CoatingLine.Shift);
var thisShiftStart = StaticFunctions.GetDayAndTime(CoatingLine.Date, CoatingLine.Shift.StartTime);
// Use previous day if this shift starts on the previous day
if ((new TimeSpan(CoatingLine.Shift.StartTime.Hour, CoatingLine.Shift.StartTime.Minute, CoatingLine.Shift.StartTime.Second) +
CoatingLine.Shift.Duration).TotalHours > 24)
{
thisShiftStart = thisShiftStart.AddDays(-1);
}
var pShifts = PressManager.Instance.GetPressShifts(lastShiftBegin, thisShiftStart);
foreach (var pressShift in pShifts)
{
PressShifts.Add(pressShift);
}
}
private void Update()
{
if (typeSelected == 3)
{
if (ore.eternal)
{
MidInfoT.text = "Quantity: Eternal" + " Hardness: " + System.Environment.NewLine + ore.hardness;
}
else
{
MidInfoT.text = "Quantity: " + StaticFunctions.AbbreviateNumber(ore.currentQuantity) + System.Environment.NewLine + "Hardness: " + ore.hardness;
}
if (metaInventory.eternalizers > 0)
{
bottomButton.interactable = true;
}
else if (!ore.eternal)
{
bottomButton.interactable = false;
}
}
else if (typeSelected == 4)
{
string allItems = "Contains: <size=75%>";
for (int i = 0; i < craft.currentItems.Count; i++)
{
allItems += System.Environment.NewLine + craft.currentItems[i];
}
if (allItems == "Contains: <size=75%>")
{
allItems += System.Environment.NewLine + "<color=red>Empty</color>";
}
MidInfoT.text = allItems;
}
else if (typeSelected == 8)
{
if (pump.amntContainersStored > 0)
{
MidInfoT.text = "Stored Barrels: " + pump.amntContainersStored.ToString();
}
else
{
MidInfoT.text = "Needs empty barrel";
}
}
else if (typeSelected == 10)
{
rCopSlider.ChangeValue(rocket.storedCopper);
rIronSlider.ChangeValue(rocket.storedIron);
rFuelSlider.ChangeValue(rocket.storedFuel);
//rTexts[0].text = rocket.storedCopper.ToString();
//rTexts[1].text = rocket.storedIron.ToString();
//rTexts[2].text = rocket.storedFuel.ToString();
if (rocket.storedFuel < 1)
{
MidInfoT.text = "Needs rocket fuel";
}
else
{
float percent = StaticFunctions.RoundTo(((((float)rocket.storedFuel + (float)rocket.storedIron + (float)rocket.storedCopper) / (float)rocket.totalMax) * 100f), 2);
MidInfoT.text = "Rocket is " + percent.ToString() + "% complete";
}
}
if (Input.GetKeyDown(KeyCode.Escape))
{
Close();
Cursor.visible = false;
}
}
public override void OnBulletTrigger(Collider collision)
{
StaticFunctions.CreateExplosion(transform.position, explosiveRadius, explosiveDamage, owner.GetTeam());
base.OnBulletTrigger(collision);
}
private void btn_IP_Click(object sender, EventArgs e)
{
MessageBox.Show(StaticFunctions.GetClientRealIpV2());
}
