public static HtmlBuilder Crosstab(
this HtmlBuilder hb,
SiteSettings ss,
View view,
string groupByX,
string groupByY,
string columns,
string aggregateType,
string value,
string timePeriod,
DateTime month,
EnumerableRowCollection <DataRow> dataRows,
bool inRange = true)
{
return(hb.Div(id: "Crosstab", css: "both", action: () =>
{
hb
.FieldDropDown(
controlId: "CrosstabGroupByX",
fieldCss: "field-auto-thin",
controlCss: " auto-postback",
labelText: Displays.GroupByX(),
optionCollection: ss.CrosstabGroupByXOptions(),
selectedValue: groupByX,
method: "post")
.FieldDropDown(
controlId: "CrosstabGroupByY",
fieldCss: "field-auto-thin",
controlCss: " auto-postback",
labelText: Displays.GroupByY(),
optionCollection: ss.CrosstabGroupByYOptions(),
selectedValue: groupByY,
method: "post")
.FieldDropDown(
fieldId: "CrosstabColumnsField",
controlId: "CrosstabColumns",
fieldCss: "field-auto-thin",
controlCss: " auto-postback",
labelText: Displays.NumericColumn(),
optionCollection: ss.CrosstabColumnsOptions(),
selectedValue: columns,
multiple: true,
method: "post")
.FieldDropDown(
controlId: "CrosstabAggregateType",
fieldCss: "field-auto-thin",
controlCss: " auto-postback",
labelText: Displays.AggregationType(),
optionCollection: ss.CrosstabAggregationTypeOptions(),
selectedValue: aggregateType,
method: "post")
.FieldDropDown(
fieldId: "CrosstabValueField",
controlId: "CrosstabValue",
fieldCss: "field-auto-thin",
controlCss: " auto-postback",
labelText: Displays.AggregationTarget(),
optionCollection: ss.CrosstabValueOptions(),
selectedValue: value,
addSelectedValue: false,
method: "post")
.FieldDropDown(
fieldId: "CrosstabTimePeriodField",
controlId: "CrosstabTimePeriod",
fieldCss: "field-auto-thin",
controlCss: " auto-postback",
labelText: Displays.Period(),
optionCollection: ss.CrosstabTimePeriodOptions(),
selectedValue: timePeriod,
method: "post")
.DropDown(
controlId: "CrosstabMonth",
controlCss: " w100 auto-postback",
optionCollection: CrosstabMonth(),
selectedValue: new DateTime(month.Year, month.Month, 1).ToString(),
action: "Crosstab",
method: "post")
.Button(
controlId: "CrosstabPreviousButton",
text: Displays.Previous(),
controlCss: "button-icon",
accessKey: "b",
onClick: "$p.moveCrosstab('Previous');",
icon: "ui-icon-seek-prev")
.Button(
controlId: "CrosstabNextButton",
text: Displays.Next(),
controlCss: "button-icon",
accessKey: "n",
onClick: "$p.moveCrosstab('Next');",
icon: "ui-icon-seek-next")
.Button(
controlId: "CrosstabThisMonthButton",
text: Displays.ThisMonth(),
controlCss: "button-icon",
accessKey: "n",
onClick: "$p.moveCrosstab('ThisMonth');",
icon: "ui-icon-Crosstab")
.Div(id: "CrosstabBody", action: () =>
{
if (inRange)
{
hb.CrosstabBody(
ss: ss,
view: view,
groupByX: groupByX,
groupByY: groupByY,
columns: columns,
aggregateType: aggregateType,
value: value,
timePeriod: timePeriod,
month: month,
dataRows: dataRows);
}
});
}));
}
public UserCollection(SiteSettings ss, EnumerableRowCollection <DataRow> dataRows)
{
Set(ss, dataRows);
}
private void btSave_Click(object sender, EventArgs e)
{
#region "Блок проверок для шапки"
if (cmbTypeDicount.SelectedIndex == -1)
{
MessageBox.Show(Config.centralText($"Необходимо выбрать\n \"{lTypeDiscont.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cmbTypeDicount.Focus();
return;
}
if (cmbTypeTenant.SelectedIndex == -1)
{
MessageBox.Show(Config.centralText($"Необходимо выбрать\n \"{lTypeTenant.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cmbTypeTenant.Focus();
return;
}
if (cmbTypeAgreements.SelectedIndex == -1)
{
MessageBox.Show(Config.centralText($"Необходимо выбрать\n \"{lTypeAgreements.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cmbTypeAgreements.Focus();
return;
}
#endregion
#region "Блок проверок для таблицы журнал данных по скидкам"
if (tbPercentDiscount.Text.Trim().Length == 0)
{
MessageBox.Show(Config.centralText($"Необходимо заполнить\n \"{lPercentDiscount.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbPercentDiscount.Focus();
return;
}
if (tbDiscountPrice.Text.Trim().Length == 0)
{
MessageBox.Show(Config.centralText($"Необходимо заполнить\n \"{lDiscountPrice.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbDiscountPrice.Focus();
return;
}
if (tbPrice.Text.Trim().Length == 0)
{
MessageBox.Show(Config.centralText($"Необходимо заполнить\n \"{lPrice.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbPrice.Focus();
return;
}
if (tbTotalPrice.Text.Trim().Length == 0)
{
MessageBox.Show(Config.centralText($"Необходимо заполнить\n \"{lTotalPrice.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbTotalPrice.Focus();
return;
}
#endregion
#region "Блок проверок для таблицы журнал объекта скидки "
if (cmbObject.SelectedIndex == -1)
{
MessageBox.Show(Config.centralText($"Необходимо выбрать\n \"{lObject.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cmbObject.Focus();
return;
}
if (cmbBuilding.SelectedIndex == -1)
{
MessageBox.Show(Config.centralText($"Необходимо выбрать\n \"{lBuilding.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cmbBuilding.Focus();
return;
}
if (cmbFloor.SelectedIndex == -1)
{
MessageBox.Show(Config.centralText($"Необходимо выбрать\n \"{lFloor.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cmbFloor.Focus();
return;
}
if (cmbObjectDiscount.SelectedIndex == -1)
{
MessageBox.Show(Config.centralText($"Необходимо выбрать\n \"{lObjectDiscount.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cmbObjectDiscount.Focus();
return;
}
//if (cmbComby.SelectedIndex == -1)
//{
// MessageBox.Show(Config.centralText($"Необходимо выбрать\n \"{lComby.Text}\"\n"), "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// cmbComby.Focus();
// return;
//}
#endregion
DateTime dateStart = dtpStart.Value;
DateTime?dateEnd = null;
if (rbTime.Checked)
{
dateEnd = dtpEnd.Value;
}
int id_TypeDiscount = (int)cmbTypeDicount.SelectedValue;
int id_TypeTenant = (int)cmbTypeTenant.SelectedValue;
int id_TypeAgreements = (int)cmbTypeAgreements.SelectedValue;
int id_StatusDiscount = 1;
Task <DataTable> task = Config.hCntMain.setTDiscount(id, dateStart, dateEnd, id_TypeDiscount, id_TypeTenant, id_TypeAgreements, id_StatusDiscount, true, false, 0);
task.Wait();
DataTable dtResult = task.Result;
if (dtResult == null || dtResult.Rows.Count == 0)
{
MessageBox.Show("Не удалось сохранить данные", "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if ((int)dtResult.Rows[0]["id"] == -1)
{
MessageBox.Show("В справочнике уже присутствует должность с таким наименованием.", "Сохранение", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if ((int)dtResult.Rows[0]["id"] == -9999)
{
MessageBox.Show("Произошла неведомая хрень.", "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (id == 0)
{
id = (int)dtResult.Rows[0]["id"];
Logging.StartFirstLevel(1);
Logging.Comment("Добавить Тип документа");
Logging.Comment($"ID: {id}");
//Logging.Comment($"Наименование: {tbNumber.Text.Trim()}");
Logging.StopFirstLevel();
}
else
{
Logging.StartFirstLevel(1);
Logging.Comment("Редактировать Тип документа");
Logging.Comment($"ID: {id}");
//Logging.VariableChange("Наименование", tbNumber.Text.Trim(), oldName);
Logging.StopFirstLevel();
}
task = Config.hCntMain.setDiscountValue(id_DiscountValue, id, decimal.Parse(tbPercentDiscount.Text), decimal.Parse(tbDiscountPrice.Text), decimal.Parse(tbPrice.Text), decimal.Parse(tbTotalPrice.Text), true, false, 0);
task.Wait();
dtResult = task.Result;
if (dtResult == null || dtResult.Rows.Count == 0)
{
MessageBox.Show("Не удалось сохранить данные", "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if ((int)dtResult.Rows[0]["id"] == -9999)
{
MessageBox.Show("Произошла неведомая хрень.", "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//int? id_ObjectLease=null;
//if (cmbObject.SelectedValue != null) id_ObjectLease = (int)cmbObject.SelectedValue;
//int? id_Buildings = null;
//if (cmbBuilding.SelectedValue != null) id_Buildings = (int)cmbBuilding.SelectedValue;
//int? id_Floor = null;
//if (cmbFloor.SelectedValue != null) id_Floor = (int)cmbFloor.SelectedValue;
//int? id_Sections = null;
//if ((int)cmbObjectDiscount.SelectedValue == 1) id_Sections = (int)cmbComby.SelectedValue;
//int? id_ReclamaPlace = null;
//if ((int)cmbObjectDiscount.SelectedValue == 2) id_ReclamaPlace = (int)cmbComby.SelectedValue;
//int? id_LandPlot = null;
// if ((int)cmbObjectDiscount.SelectedValue == 3) id_LandPlot = (int)cmbComby.SelectedValue;
//bool isException = chbIsException.Checked;
task = Config.hCntMain.setDiscountObject(0, id, 0, 0, 0, 0, 0, false, true, true, 1);
task.Wait();
dtResult = task.Result;
//if (dtResult == null || dtResult.Rows.Count == 0)
//{
// MessageBox.Show("Не удалось сохранить данные", "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
//if ((int)dtResult.Rows[0]["id"] == -9999)
//{
// MessageBox.Show("Произошла неведомая хрень.", "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
EnumerableRowCollection <DataRow> rowCollect = dtData.DefaultView.ToTable().AsEnumerable().Where(r => r.Field <bool>("isSelect"));
foreach (DataRow row in rowCollect)
{
int id_ObjectLease = (int)row["id_ObjectLease"];
int?id_Buildings = null;
int?id_Floor = null;
int id_rentalObject = (int)row["id"];;
int typeRentalObject = (int)cmbObjectDiscount.SelectedValue;
bool isException = (bool)row["isException"];
if ((int)cmbObjectDiscount.SelectedValue == 1)
{
id_Buildings = (int)row["id_Building"];
id_Floor = (int)row["id_Floor"];
}
else if ((int)cmbObjectDiscount.SelectedValue == 2)
{
id_Buildings = (int)row["id_Building"];
}
task = Config.hCntMain.setDiscountObject(0, id, id_ObjectLease, id_Buildings, id_Floor, id_rentalObject, typeRentalObject, isException, true, false, 0);
task.Wait();
dtResult = task.Result;
if (dtResult == null || dtResult.Rows.Count == 0)
{
MessageBox.Show("Не удалось сохранить данные", "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if ((int)dtResult.Rows[0]["id"] == -9999)
{
MessageBox.Show("Произошла неведомая хрень.", "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
isEditData = false;
MessageBox.Show("Данные сохранены.", "Сохранение данных", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
}
private void ProcessParalyze(EnumerableRowCollection <EnfeebleGroup> paralyzeSet,
ref StringBuilder sb, ref List <StringMods> strModList)
{
strModList.Add(new StringMods
{
Start = sb.Length,
Length = lsParalyzeTitle.Length,
Bold = true,
Color = Color.Red
});
sb.Append(lsParalyzeTitle + "\n\n");
strModList.Add(new StringMods
{
Start = sb.Length,
Length = lsParalyzeHeader.Length,
Bold = true,
Underline = true,
Color = Color.Black
});
sb.Append(lsParalyzeHeader + "\n");
int totalFights = paralyzeSet.Count();
int totalParaCast = paralyzeSet.Sum(a => a.Enfeebled.Count());
int totalParalyzed = 0;
int totalActions = 0;
int totalMobsParalyzed = 0;
double paralyzeRate = 0;
DateTime paraBufferTime = DateTime.MinValue;
DateTime paraLimitTime = DateTime.MinValue;
foreach (var mob in paralyzeSet)
{
if (mob.Enfeebled.Any())
{
totalMobsParalyzed++;
totalParalyzed += mob.Paralyzed.Count();
}
for (int i = 0; i < mob.Enfeebled.Count(); i++)
{
// Get the limits of the time period we will look at for possible
// paralyze effects.
var enf = mob.Enfeebled.ElementAt(i);
// Start point
paraBufferTime = enf.Timestamp.AddSeconds(-3);
// Preliminary end point
paraLimitTime = mob.FightEndTime;
if ((i + 1) < mob.Enfeebled.Count())
{
paraLimitTime = mob.Enfeebled.ElementAt(i + 1).Timestamp.AddSeconds(-2);
}
if (paraLimitTime > enf.Timestamp.AddMinutes(3))
{
paraLimitTime = enf.Timestamp.AddMinutes(3);
}
// Final end point determined
// Get all actions within that window
var actionWindow = mob.Actions.Where(a =>
a.Timestamp >= paraBufferTime &&
a.Timestamp <= paraLimitTime);
totalActions += actionWindow.Count();
}
}
if (totalActions > 0)
{
paralyzeRate = (double)totalParalyzed / totalActions;
}
sb.AppendFormat(lsParalyzeFormat,
totalFights,
totalMobsParalyzed,
totalParalyzed,
totalActions,
paralyzeRate);
sb.Append("\n\n\n");
}
private void ProcessTPMoves(EnumerableRowCollection <TPMovesGroup> tpMoveSet,
ref StringBuilder sb, ref List <StringMods> strModList)
{
strModList.Add(new StringMods
{
Start = sb.Length,
Length = lsTPMovesTitle.Length,
Bold = true,
Color = Color.Red
});
sb.Append(lsTPMovesTitle + "\n\n");
strModList.Add(new StringMods
{
Start = sb.Length,
Length = lsTPMovesHeader.Length,
Bold = true,
Underline = true,
Color = Color.Black
});
sb.Append(lsTPMovesHeader + "\n");
TimeSpan sumFightLengths = TimeSpan.Zero;
int countMoves = 0;
int numFights = tpMoveSet.Count();
foreach (var tpUser in tpMoveSet)
{
var groupedMoves = tpUser.TPMoves.Where(a => a.Preparing == false).GroupBy(m => m.Timestamp);
countMoves += groupedMoves.Count();
sumFightLengths += tpUser.FightLength;
}
TimeSpan timePerTPMove = TimeSpan.Zero;
double avgTPMovesPerMinute = 0;
if (countMoves > 0)
{
timePerTPMove = TimeSpan.FromSeconds(sumFightLengths.TotalSeconds / countMoves);
}
if (timePerTPMove.TotalSeconds > 0)
{
avgTPMovesPerMinute = 60 / timePerTPMove.TotalSeconds;
}
string subFightsLengthString = sumFightLengths.FormattedShortTimeSpanString(true);
string timePerTPMoveString = timePerTPMove.FormattedShortTimeSpanString(true);
if (countMoves > 0)
{
sb.AppendFormat(lsTPMovesFormat,
countMoves, subFightsLengthString, numFights, timePerTPMoveString, avgTPMovesPerMinute);
sb.Append("\n");
}
if (showDetails == true)
{
sb.Append("\n");
strModList.Add(new StringMods
{
Start = sb.Length,
Length = lsDetails.Length,
Bold = true,
Color = Color.Blue
});
sb.Append(lsDetails + "\n");
foreach (var tpUser in tpMoveSet)
{
var groupedMoves = tpUser.TPMoves.Where(a => a.Preparing == false).GroupBy(m => m.Timestamp);
foreach (var move in groupedMoves)
{
sb.AppendFormat(" {0} - {1}\n",
move.Key.ToLocalTime().ToLongTimeString(),
move.First().ActionsRow.ActionName);
}
}
}
sb.Append("\n");
}
public static string Csv(
Context context,
SiteSettings ss,
View view,
Column groupByX,
Column groupByY,
List <Column> columns,
string aggregateType,
Column value,
string timePeriod,
DateTime month,
EnumerableRowCollection <DataRow> dataRows)
{
var csv = new StringBuilder();
if (groupByY != null)
{
csv.Body(
context: context,
ss: ss,
view: view,
choicesX: ChoicesX(
context: context,
groupByX: groupByX,
view: view,
timePeriod: timePeriod,
month: month),
choicesY: ChoicesY(
context: context,
groupByY: groupByY,
view: view),
aggregateType: aggregateType,
value: value,
firstHeaderText: $"{groupByY.LabelText} | {groupByX.LabelText}",
timePeriod: timePeriod,
month: month,
data: Elements(
groupByX: groupByX,
groupByY: groupByY,
dataRows: dataRows));
}
else
{
var columnList = GetColumns(
context: context,
ss: ss,
columns: columns);
csv.Body(
context: context,
ss: ss,
view: view,
choicesX: ChoicesX(
context: context,
groupByX: groupByX,
view: view,
timePeriod: timePeriod,
month: month),
choicesY: ChoicesY(columnList),
aggregateType: aggregateType,
value: value,
firstHeaderText: groupByX.LabelText,
timePeriod: timePeriod,
month: month,
data: ColumnsElements(
groupByX: groupByX,
dataRows: dataRows,
columnList: columnList),
columnList: columnList);
}
return(csv.ToString());
}
private static HtmlBuilder LinkTable(
this HtmlBuilder hb,
Context context,
SiteSettings ss,
View view,
EnumerableRowCollection <DataRow> dataRows,
string direction,
string dataTableName,
int tabIndex = 0)
{
ss.SetChoiceHash(dataRows: dataRows);
return(hb.Table(
id: dataTableName,
css: "grid",
attributes: new HtmlAttributes()
.DataId(ss.SiteId.ToString())
.DataName(direction)
.DataValue("back")
.DataAction("LinkTable")
.DataMethod("post")
.Add(
name: "from-tab-index",
value: tabIndex.ToString()),
action: () =>
{
var siteMenu = SiteInfo.TenantCaches.Get(context.TenantId)?.SiteMenu;
if (dataRows != null && dataRows.Any())
{
ss.SetColumnAccessControls(context: context);
var columns = ss.GetLinkTableColumns(
context: context,
view: view,
checkPermission: true);
switch (ss.ReferenceType)
{
case "Issues":
var issueCollection = new IssueCollection(
context: context,
ss: ss,
dataRows: dataRows);
issueCollection.SetLinks(context: context, ss: ss);
hb
.Caption(
action: () => hb
.Span(
css: "caption-direction",
action: () => hb
.Text(text: "{0} : ".Params(Caption(
context: context,
direction: direction))))
.Span(
css: "caption-title",
action: () => hb
.Text(text: "{0}".Params(siteMenu.Breadcrumb(
context: context,
siteId: ss.SiteId)
.Select(o => o.Title)
.Join(" > "))))
.Span(
css: "caption-quantity",
action: () => hb
.Text(text: " - {0} ".Params(
Displays.Quantity(context: context))))
.Span(
css: "caption-count",
action: () => hb
.Text(text: "{0}".Params(dataRows.Count()))))
.THead(action: () => hb
.GridHeader(
context: context,
ss: ss,
columns: columns,
view: view,
sort: true,
checkRow: false,
action: "LinkTable"))
.TBody(action: () => issueCollection
.ForEach(issueModel =>
{
ss.SetColumnAccessControls(
context: context,
mine: issueModel.Mine(context: context));
hb.Tr(
attributes: new HtmlAttributes()
.Class("grid-row")
.DataId(issueModel.IssueId.ToString()),
action: () => columns
.ForEach(column => hb
.TdValue(
context: context,
ss: ss,
column: column,
issueModel: issueModel,
tabIndex: tabIndex)));
}));
break;
case "Results":
var resultCollection = new ResultCollection(
context: context,
ss: ss,
dataRows: dataRows);
resultCollection.SetLinks(context: context, ss: ss);
hb
.Caption(
action: () => hb
.Span(
css: "caption-direction",
action: () => hb
.Text(text: "{0} : ".Params(Caption(
context: context,
direction: direction))))
.Span(
css: "caption-title",
action: () => hb
.Text(text: "{0}".Params(siteMenu.Breadcrumb(
context: context,
siteId: ss.SiteId)
.Select(o => o.Title)
.Join(" > "))))
.Span(
css: "caption-quantity",
action: () => hb
.Text(text: " - {0} ".Params(
Displays.Quantity(context: context))))
.Span(
css: "caption-count",
action: () => hb
.Text(text: "{0}".Params(dataRows.Count()))))
.THead(action: () => hb
.GridHeader(
context: context,
ss: ss,
columns: columns,
view: view,
sort: true,
checkRow: false,
action: "LinkTable"))
.TBody(action: () => resultCollection
.ForEach(resultModel =>
{
ss.SetColumnAccessControls(
context: context,
mine: resultModel.Mine(context: context));
hb.Tr(
attributes: new HtmlAttributes()
.Class("grid-row")
.DataId(resultModel.ResultId.ToString()),
action: () => columns
.ForEach(column => hb
.TdValue(
context: context,
ss: ss,
column: column,
resultModel: resultModel,
tabIndex: tabIndex)));
}));
break;
}
}
}));
}
private void filterTable(DataTable dtDeps, DataTable dtPostvsDeps, DataTable dtDepsLinkToDep)
{
if (tbNameDocuments.Text.Trim().Length > 0)
{
Task <DataTable> task = Config.hCntMain.getDoc_TypeDoc_Post(0, 0, false);
task.Wait();
if (tbNameDocuments.Text.Trim().Length > 0 && task.Result == null)
{
return;
}
foreach (DataRow row in dtDepsLinkToDep.Rows)
{
var rowCollectDocument = task.Result.AsEnumerable()
.Where(r =>
r.Field <int>("id_Departments") == (int)row["id_DepartmentsView"] &&
r.Field <string>("namePost").ToLower().Contains(tbNamePosts.Text.ToLower()) &&
r.Field <string>("nameDoc").ToLower().Contains(tbNameDocuments.Text.ToLower()) &&
((new List <int> {
4
}.Contains(r.Field <int>("id_Status")) && r.Field <bool>("ViewArchive")) || new List <int> {
2, 3
}.Contains(r.Field <int>("id_Status")))
)
.GroupBy(r => new { id_Departments = r.Field <int>("id_Departments") })
.Select(s => new { s.Key.id_Departments });
foreach (var gRDoc in rowCollectDocument)
{
var groupDepsVsPost_1 = dtPostvsDeps.AsEnumerable()
.Where(r =>
r.Field <int>("id_Departments") == gRDoc.id_Departments &&
r.Field <string>("namePost").ToLower().Contains(tbNamePosts.Text.ToLower()) &&
r.Field <string>("nameDeps").ToLower().Contains(tbNameDeps.Text.ToLower())
)
.GroupBy(r => new { id_Departments = r.Field <int>("id_Departments") })
.Select(s => new
{
s.Key.id_Departments
});
foreach (var gDepsv1 in groupDepsVsPost_1)
{
EnumerableRowCollection <DataRow> rowCollect = dtDeps.AsEnumerable().Where(r => r.Field <Int16>("id") == gDepsv1.id_Departments);
if (rowCollect.Count() > 0)
{
rowCollect.First()["isUsed"] = true;
}
}
}
}
}
else if (tbNamePosts.Text.Trim().Length > 0)
{
foreach (DataRow row in dtDepsLinkToDep.Rows)
{
var groupDepsVsPost_1 = dtPostvsDeps.AsEnumerable()
.Where(r =>
r.Field <int>("id_Departments") == (int)row["id_DepartmentsView"] &&
r.Field <string>("namePost").ToLower().Contains(tbNamePosts.Text.ToLower()) &&
r.Field <string>("nameDeps").ToLower().Contains(tbNameDeps.Text.ToLower())
)
.GroupBy(r => new { id_Departments = r.Field <int>("id_Departments") })
.Select(s => new
{
s.Key.id_Departments
});
foreach (var gDepsv1 in groupDepsVsPost_1)
{
EnumerableRowCollection <DataRow> rowCollect = dtDeps.AsEnumerable().Where(r => r.Field <Int16>("id") == gDepsv1.id_Departments);
if (rowCollect.Count() > 0)
{
rowCollect.First()["isUsed"] = true;
}
}
}
}
else
{
foreach (DataRow row in dtDepsLinkToDep.Rows)
{
EnumerableRowCollection <DataRow> rowCollect = dtDeps.AsEnumerable().Where(r => r.Field <Int16>("id") == (int)row["id_DepartmentsView"] && r.Field <string>("name").ToLower().Contains(tbNameDeps.Text.ToLower()));
if (rowCollect.Count() > 0)
{
rowCollect.First()["isUsed"] = true;
}
}
}
}
public OutgoingMailCollection(Context context, EnumerableRowCollection <DataRow> dataRows)
{
Set(context, dataRows);
}
public static void MainMenu()
{
Console.WriteLine();
OutputHandling.Message("1 - Add a book");
OutputHandling.Message("2 - Print book info");
OutputHandling.Message("3 - Update book info");
OutputHandling.Message("4 - Delete book from database");
OutputHandling.Message("5 - Exit");
ConsoleKeyInfo cki = Console.ReadKey(true);
if (cki.Key.Equals(ConsoleKey.D1) || cki.Key.Equals(ConsoleKey.NumPad1))
{
Console.Clear();
string title = InputHandling.ReadString("Book Title: ");
int pId = InputHandling.ReadValue("PublisherId: ");
int year = InputHandling.ReadValue("Year: ");
int price = InputHandling.ReadValue("Price: ");
BooksCrud.InsertBook(title, pId, year, price);
MainMenu();
}
else if (cki.Key.Equals(ConsoleKey.D2) || cki.Key.Equals(ConsoleKey.NumPad2))
{
Console.Clear();
int bId = InputHandling.ReadValue("Book Id:");
SqlParameter bookId = new SqlParameter {
Value = bId, SqlDbType = SqlDbType.Int, ParameterName = "bookId"
};
EnumerableRowCollection <DataRow> bookInfo = BooksCrud.ReadBook(bookId);
foreach (DataRow row in bookInfo)
{
Console.WriteLine($"Id: {row[0]}");
Console.WriteLine($"Title: {row[1]}");
Console.WriteLine($"Publisher: {row[2]}");
Console.WriteLine($"Year: {row[3]}");
Console.WriteLine($"Price: {row[4]}");
}
MainMenu();
}
else if (cki.Key.Equals(ConsoleKey.D3) || cki.Key.Equals(ConsoleKey.NumPad3))
{
Console.Clear();
int bId = InputHandling.ReadValue("Book Id:");
UpdateMenu(bId);
MainMenu();
}
else if (cki.Key.Equals(ConsoleKey.D4) || cki.Key.Equals(ConsoleKey.NumPad4))
{
int bId = InputHandling.ReadValue("Book Id:");
SqlParameter bookId = new SqlParameter {
Value = bId, SqlDbType = SqlDbType.Int, ParameterName = "bookId"
};
BooksCrud.DeleteBook(bookId);
MainMenu();
}
else if (cki.Key.Equals(ConsoleKey.D5) || cki.Key.Equals(ConsoleKey.NumPad5))
{
ProgramFlowHandling.Exit("Program will now exit...");
dbBooksConn.Dispose();
}
else
{
MainMenu();
}
}
public ReminderScheduleCollection(Context context, EnumerableRowCollection <DataRow> dataRows)
{
Set(context, dataRows);
}
public static void createReport(DataTable dtReport, string _nameObject, string status, DateTime _startDate)
{
Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad();
int indexRow = 1;
Control[] cnt = new frmAddReportMonth().Controls.Find("dgvData", false);
DataGridView dgvData = (DataGridView)cnt[0];
int maxColumns = 0;
foreach (DataGridViewColumn col in dgvData.Columns)
{
if (col.Visible)
{
maxColumns++;
if (col.Name.Equals("nameLandLord"))
{
setWidthColumn(indexRow, maxColumns, 20, report);
}
if (col.Name.Equals("nameTenant"))
{
setWidthColumn(indexRow, maxColumns, 20, report);
}
if (col.Name.Equals("TypeContract"))
{
setWidthColumn(indexRow, maxColumns, 13, report);
}
if (col.Name.Equals("cAgreements"))
{
setWidthColumn(indexRow, maxColumns, 22, report);
}
if (col.Name.Equals("timeLimit"))
{
setWidthColumn(indexRow, maxColumns, 14, report);
}
if (col.Name.Equals("cBuild"))
{
setWidthColumn(indexRow, maxColumns, 9, report);
}
if (col.Name.Equals("cFloor"))
{
setWidthColumn(indexRow, maxColumns, 10, report);
}
if (col.Name.Equals("cSection"))
{
setWidthColumn(indexRow, maxColumns, 10, report);
}
if (col.Name.Equals("cSquart"))
{
setWidthColumn(indexRow, maxColumns, 12, report);
}
if (col.Name.Equals("Cost_of_Meter"))
{
setWidthColumn(indexRow, maxColumns, 14, report);
}
if (col.Name.Equals("cSumDog"))
{
setWidthColumn(indexRow, maxColumns, 19, report);
}
if (col.Name.Equals("cDiscount"))
{
setWidthColumn(indexRow, maxColumns, 10, report);
}
if (col.Name.Equals("cPlane"))
{
setWidthColumn(indexRow, maxColumns, 20, report);
}
//Console.WriteLine(col.Name);
}
}
#region "Head"
report.Merge(indexRow, 1, indexRow, maxColumns);
report.AddSingleValue("Ежемесячный отчёт", indexRow, 1);
report.SetFontBold(indexRow, 1, indexRow, 1);
report.SetFontSize(indexRow, 1, indexRow, 1, 16);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1);
indexRow++;
indexRow++;
string[] monthNames = DateTimeFormatInfo.CurrentInfo.MonthNames;
report.Merge(indexRow, 1, indexRow, maxColumns);
report.AddSingleValue($"Период ежемесячного отчёта {monthNames[_startDate.Month-1]}.{_startDate.Year}", indexRow, 1);
indexRow++;
report.Merge(indexRow, 1, indexRow, maxColumns);
report.AddSingleValue($"Объект аренды: {_nameObject}", indexRow, 1);
indexRow++;
report.Merge(indexRow, 1, indexRow, maxColumns);
report.AddSingleValue($"Статус: {status}", indexRow, 1);
indexRow++;
report.Merge(indexRow, 1, indexRow, maxColumns);
report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1);
indexRow++;
report.Merge(indexRow, 1, indexRow, maxColumns);
report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1);
indexRow++;
indexRow++;
#endregion
int indexCol = 0;
foreach (DataGridViewColumn col in dgvData.Columns)
{
if (col.Visible)
{
indexCol++;
report.AddSingleValue(col.HeaderText, indexRow, indexCol);
}
}
report.SetFontBold(indexRow, 1, indexRow, maxColumns);
report.SetBorders(indexRow, 1, indexRow, maxColumns);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns);
indexRow++;
var groupByPost = dtReport.DefaultView.ToTable().AsEnumerable().GroupBy(r => new { id = r.Field <int>("id_Landlord") })
.Select(s => new { s.Key.id,
sumPlan = s.Sum(r => r.Field <decimal>("plane")) });
decimal maxResultPlane = 0;
foreach (var gPost in groupByPost)
{
EnumerableRowCollection <DataRow> rowCollect = dtReport.DefaultView.ToTable().AsEnumerable().Where(r => r.Field <int>("id_Landlord") == gPost.id);
int startMergRow = indexRow;
foreach (DataRow row in rowCollect)
{
indexCol = 1;
report.SetWrapText(indexRow, indexCol, indexRow, maxColumns);
foreach (DataGridViewColumn col in dgvData.Columns)
{
if (col.Visible)
{
if (new List <string>()
{
"nameLandLord"
}.Contains(col.Name))
{
indexCol++;
continue;
}
if (row[col.DataPropertyName] is DateTime)
{
report.AddSingleValue(((DateTime)row[col.DataPropertyName]).ToShortDateString(), indexRow, indexCol);
}
else
if (row[col.DataPropertyName] is decimal)
{
report.AddSingleValueObject(row[col.DataPropertyName], indexRow, indexCol);
report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00");
}
else
{
report.AddSingleValue(row[col.DataPropertyName].ToString(), indexRow, indexCol);
}
indexCol++;
}
}
report.SetBorders(indexRow, 1, indexRow, maxColumns);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns);
report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns);
indexRow++;
}
indexCol = 1;
foreach (DataGridViewColumn col in dgvData.Columns)
{
if (new List <string>()
{
"nameLandLord"
}.Contains(col.Name))
{
report.Merge(startMergRow, indexCol, indexRow - 1, indexCol);
if (rowCollect.First()[col.DataPropertyName] is DateTime)
{
report.AddSingleValue(((DateTime)rowCollect.First()[col.DataPropertyName]).ToShortDateString(), startMergRow, indexCol);
}
else
if (rowCollect.First()[col.DataPropertyName] is decimal)
{
report.AddSingleValueObject(rowCollect.First()[col.DataPropertyName], startMergRow, indexCol);
report.SetFormat(startMergRow, indexCol, startMergRow, indexCol, "0.00");
}
else
{
report.AddSingleValue(rowCollect.First()[col.DataPropertyName].ToString(), startMergRow, indexCol);
}
}
else if (new List <string>()
{
"cPlane"
}.Contains(col.Name))
{
report.AddSingleValueObject(gPost.sumPlan, indexRow, indexCol);
report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00");
report.Merge(indexRow, 1, indexRow, indexCol - 1);
report.AddSingleValue("Итого:", indexRow, 1);
report.SetCellAlignmentToRight(indexRow, 1, indexRow, indexCol - 1);
indexRow++;
}
indexCol++;
}
maxResultPlane += gPost.sumPlan;
}
report.AddSingleValueObject(maxResultPlane, indexRow, maxColumns);
report.SetFormat(indexRow, maxColumns, indexRow, maxColumns, "0.00");
report.Merge(indexRow, 1, indexRow, maxColumns - 1);
report.AddSingleValue("Итого:", indexRow, 1);
report.SetCellAlignmentToRight(indexRow, 1, indexRow, maxColumns - 1);
report.SetFontBold(indexRow, 1, indexRow, maxColumns);
indexRow++;
report.Show();
}
private void CargarPedidosUsuario()
{
Cls_Paquetes_BLL objBLL = new Cls_Paquetes_BLL();
Cls_Paquetes_DAL objDAL = new Cls_Paquetes_DAL();
gdvEstados.DataSource = null;
gdvEstados.DataBind();
objBLL.Listar(ref objDAL);
string prueba = txtBuscar.Value;
if (objDAL.SError == string.Empty)
{
gdvEstados.SelectedIndex = -1;
if (txtBuscar.Value == string.Empty)
{
DataTable dt = objDAL.DtTablaPaquetes;
EnumerableRowCollection <DataRow> query = from dtEstados in dt.AsEnumerable()
where !dtEstados.Field <int>("Id_Estado").Equals(3)
select dtEstados;
DataView view = query.AsDataView();
paquetesLista = view;
gdvEstados.DataSource = view;
gdvEstados.Columns[0].Visible = true;
}
else
{
DataTable dt = objDAL.DtTablaPaquetes;
EnumerableRowCollection <DataRow> query = from dtEstados in dt.AsEnumerable()
where dtEstados.Field <int>("Id_Paquete").ToString().ToLower().Replace(" ", "").Contains(txtBuscar.Value.ToLower().Replace(" ", ""))
select dtEstados;
DataView view = query.AsDataView();
foreach (DataRowView row in view)
{
if (row["Id_Estado"].ToString().Equals("3"))
{
gdvEstados.Columns[0].Visible = false;
}
}
gdvEstados.DataSource = view;
}
gdvEstados.DataBind();
updpnlGrid.Update();
if (gdvEstados.Rows.Count > 0)
{
gdvEstados.Visible = true;
lblMensaje.Visible = false;
lblMensaje.Text = "";
}
else
{
gdvEstados.Visible = false;
lblMensaje.Visible = true;
lblMensaje.Text = "No hay datos que mostrar";
}
}
else
{
lblMensaje.Text = objDAL.SError;
}
}
private void BuildAllowdModuleCheckBox()
{
StackPanel OuterStock = new StackPanel();
//OuterStock. = new Thickness(0, 5, 15, -25);
dhModule objModule = new dhModule();
// if (objUser != null)
// {
#region "Allowed Menu"
// objModule.AllowdModule = Globalized.objAppPreference.VEnableModules;
dsGeneral.dtPosModuleDataTable dtm = iFacede.GetModule(Globalized.ObjDbName, objModule);
EnumerableRowCollection <dsGeneral.dtPosModuleRow> result2 = from r in dtm.AsEnumerable()
where (r.Field <int>("iModuleParentID") == 0)
select r;
int CountRow = result2.Count <dsGeneral.dtPosModuleRow>();
if (CountRow > 0)
{
DataTable dtResult2 = result2.CopyToDataTable();
ObservableCollection <dhModule> sequence = ReflectionUtility.DataTableToObservableCollection <dhModule>(dtResult2);
if (sequence.Count > 0)
{
foreach (dhModule Module in sequence)
{
GroupBox objGroup = new GroupBox();
objGroup.Header = Module.VDisplayName;
objGroup.Margin = new Thickness(0, 0, 0, 15);
#region "Grid"
Grid grid = new Grid();
// grid.Width = 400;
// Create column definitions.
ColumnDefinition columnDefinition1 = new ColumnDefinition();
ColumnDefinition columnDefinition2 = new ColumnDefinition();
columnDefinition1.Width = new GridLength(200);
columnDefinition2.Width = new GridLength(200);
// Attached definitions to grid.
grid.ColumnDefinitions.Add(columnDefinition1);
grid.ColumnDefinitions.Add(columnDefinition2);
CheckBox cb = new CheckBox();
cb.Name = Module.VModuleName.ToString() + Module.IModuleID.ToString();
cb.Content = Module.VDisplayName.ToString();
// cb.Width = 100;
cb.Margin = new Thickness(5, 5, 5, 5);
cb.DataContext = Module;
Binding myBinding = new Binding("BIsActive");
myBinding.Source = Module;
cb.SetBinding(CheckBox.IsCheckedProperty, myBinding);
cb.Tag = Module;
cb.AddHandler(CheckBox.CheckedEvent, new RoutedEventHandler(DynamicCheckBox_Checked));
cb.AddHandler(CheckBox.UncheckedEvent, new RoutedEventHandler(DynamicCheckBox_Unchecked));
RowDefinition rowDefinition1 = new RowDefinition();
rowDefinition1.Height = new GridLength(30);
grid.RowDefinitions.Add(rowDefinition1);
grid.Children.Add(cb);
Grid.SetColumn(cb, 0);
Grid.SetRow(cb, 0);
#endregion "Grid"
EnumerableRowCollection <dsGeneral.dtPosModuleRow> Filter = from r2 in dtm.AsEnumerable()
where (r2.Field <int>("iModuleParentID") == Module.IModuleID)
select r2;
int CountRowInner = result2.Count <dsGeneral.dtPosModuleRow>();
if (CountRowInner > 0)
{
DataTable dtFilter;
if (Filter.Count() > 0)
{
dtFilter = Filter.CopyToDataTable();
}
else
{
dtFilter = new DataTable();
}
ObservableCollection <dhModule> sequencefilter = ReflectionUtility.DataTableToObservableCollection <dhModule>(dtFilter);
if (sequencefilter.Count > 0)
{
// int Bool = 1;
int row = 1;
int col = 0;
RowDefinition rowDefinition = new RowDefinition();
rowDefinition.Height = new GridLength(30);
grid.RowDefinitions.Add(rowDefinition);
#region "Child Module"
foreach (dhModule SubModule in sequencefilter)
{
//for (int i = 0; i < sequencefilter.Count ; i++)
//{
CheckBox NestedCb = new CheckBox();
//NestedStp.Orientation = Orientation.Horizontal;
NestedCb.Name = "Sub" + SubModule.VModuleName.ToString() + SubModule.IModuleID.ToString();
NestedCb.Content = SubModule.VDisplayName.ToString();
NestedCb.Margin = new Thickness(35, 5, 5, 5);
if (col == 2)
{
row = row + 1;
col = 0;
RowDefinition rowDefinition3 = new RowDefinition();
rowDefinition3.Height = new GridLength(30);
grid.RowDefinitions.Add(rowDefinition3);
}
NestedCb.DataContext = Module;
Binding mySubBinding = new Binding("BIsActive");
mySubBinding.Source = SubModule;
NestedCb.SetBinding(CheckBox.IsCheckedProperty, mySubBinding);
NestedCb.Tag = SubModule;
grid.Children.Add(NestedCb);
Grid.SetColumn(NestedCb, col);
Grid.SetRow(NestedCb, row);
col += 1;
}
#endregion "Child Module"
objGroup.Content = grid;
}
OuterStock.Children.Add(objGroup);
}
}
RightsGrid.Children.Add(OuterStock);
}
}
#endregion "Allowed Menu"
// }
}
public string GetLatestLottery()
{
BLL.RunLottery bll = new BLL.RunLottery();
int totalCount = 0;
DataSet ds = bll.GetRunLotteryItem(1, 6, out totalCount, "", null);
string jsonAppend = "[";
if (ds != null && ds.Tables.Count > 0)
{
EnumerableRowCollection <DataRow> erc = ds.Tables[0].AsEnumerable();
DateTime currTime = DateTime.Now;
DateTime lastUpdatedDate = DateTime.MinValue;
string itemName = "";
int totalMilliseconds = 0;
int remainMilliseconds = 0;
int betTime = 0;
DataRow dr = erc.Where(x => int.Parse(x["Status"].ToString()) == 0).OrderBy(x => Int32.Parse(x["Period"].ToString())).First();
lastUpdatedDate = DateTime.Parse(dr["LastUpdatedDate"].ToString());
itemName = dr["ItemName"].ToString();
TimeSpan ts = lastUpdatedDate - currTime;
totalMilliseconds = Int32.Parse(ts.TotalMilliseconds.ToString("0"));
remainMilliseconds = totalMilliseconds + 3000;
betTime = remainMilliseconds - 8000;
DataRow lastRow = null;
var q = erc.Where(x => int.Parse(x["Status"].ToString()) == 1).OrderByDescending(x => Int32.Parse(x["Period"].ToString()));
if (q != null && q.Count() > 0)
{
lastRow = q.First();
}
if (lastRow != null)
{
itemName = lastRow["ItemName"].ToString();
}
//else
//{
// lastUpdatedDate = DateTime.Parse(dr["LastUpdatedDate"].ToString());
// itemName = dr["ItemName"].ToString();
// TimeSpan ts = lastUpdatedDate - currTime;
// totalMilliseconds = Int32.Parse(ts.TotalMilliseconds.ToString("0"));
// remainMilliseconds = totalMilliseconds + 30000;
// betTime = remainMilliseconds - 8000;
//}
//jsonAppend += "{\"Period\":\"" + dr["Period"].ToString() + "\",\"ItemName\":\"" + lastRow["ItemName"].ToString() + "\",\"Lud\":\"" + remainMilliseconds + "\",\"EndTime\":\"" + currTime.AddMilliseconds(remainMilliseconds) + "\",\"BetTime\":\"" + betTime + "\"}";
if (totalMilliseconds >= 0 && totalMilliseconds <= 300000)
{
jsonAppend += "{\"Period\":\"" + dr["Period"].ToString() + "\",\"ItemName\":\"" + itemName + "\",\"Lud\":\"" + remainMilliseconds + "\",\"EndTime\":\"" + dr["RunDate"].ToString() + "\",\"BetTime\":\"" + betTime + "\"}";
}
else
{
//间隔2分钟
jsonAppend += "{\"Period\":\"0\",\"ItemName\":\"准备中\",\"Lud\":\"60000\",\"EndTime\":\"开奖未开始\"}";
}
}
else
{
//间隔2分钟
jsonAppend += "{\"Period\":\"0\",\"ItemName\":\"准备中\",\"Lud\":\"60000\",\"EndTime\":\"开奖未开始\"}";
}
jsonAppend += "]";
return(jsonAppend);
}
public HealthCollection(EnumerableRowCollection <DataRow> dataRows)
{
Set(dataRows);
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
this.Write("\r\n");
#line 8 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
SchemaDataSet schemaDataSet = _params.SchemaDataSet;
SchemaDataSet.SchemaPrimaryKeysDataTable primaryKeysTable = schemaDataSet.SchemaPrimaryKeys;
EnumerableRowCollection <SchemaDataSet.SchemaPrimaryKeysRow> primaryKeysRows = primaryKeysTable.AsEnumerable();
var primaryKeysQuery = from primaryKeysRow in primaryKeysRows
where primaryKeysRow.TABLE_SCHEMA.Equals(_schema, StringComparison.OrdinalIgnoreCase)
where primaryKeysRow.TABLE_NAME.Equals(_tableName, StringComparison.OrdinalIgnoreCase)
select primaryKeysRow;
#line default
#line hidden
this.Write("IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N\'[");
#line 17 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_params.AuditingSchema));
#line default
#line hidden
this.Write("].[");
#line 17 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_trackingTableName));
#line default
#line hidden
this.Write("]\') AND OBJECTPROPERTY(id, N\'IsUserTable\') = 1)\r\nBEGIN\r\n\tCREATE TABLE [");
#line 19 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_params.AuditingSchema));
#line default
#line hidden
this.Write("].[");
#line 19 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_trackingTableName));
#line default
#line hidden
this.Write("]\r\n\t\t(\r\n \t [TrackºId] [bigint]\r\n");
#line 22 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
foreach (SchemaDataSet.ColumnsRow columnsRow in _targetTableColumns)
{
#line default
#line hidden
this.Write("\t\t, [");
#line 23 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(columnsRow.COLUMN_NAME));
#line default
#line hidden
this.Write("] ");
#line 23 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(columnsRow.DATA_TYPE.ToUpperInvariant()));
#line default
#line hidden
#line 23 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(SchemaHelper.DataTypeDetail(columnsRow)));
#line default
#line hidden
this.Write(" NULL\r\n");
#line 24 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
}
#line default
#line hidden
this.Write("\r\n\t\t, CONSTRAINT [PK_");
#line 26 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_trackingTableName));
#line default
#line hidden
this.Write("_TrackºId] PRIMARY KEY CLUSTERED \r\n\t\t\t(\r\n\t\t\t\t[TrackºId] ASC\r\n\t\t\t)\r\n\t\t\tON [");
#line 30 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_params.AuditingFileGroup));
#line default
#line hidden
this.Write("]\r\n\t\t\t\r\n\t\t, CONSTRAINT [FK_");
#line 32 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_trackingTableName));
#line default
#line hidden
this.Write("_AuditMaster] FOREIGN KEY\r\n\t\t\t(\r\n\t\t\t\t[TrackºId]\r\n\t\t\t) \r\n\t\t\tREFERENCES [");
#line 36 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_params.AuditingSchema));
#line default
#line hidden
this.Write("].[AuditMaster]\r\n\t\t\t(\r\n\t\t\t\t[TrackºId]\r\n\t\t\t) \r\n\t\t\tON UPDATE CASCADE \r\n\t \t\tON DELET" +
"E CASCADE \t \r\n\t \t)\r\n\t\tON [");
#line 43 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_params.AuditingFileGroup));
#line default
#line hidden
this.Write("];\r\n\r\n\tCREATE NONCLUSTERED INDEX [IX_");
#line 45 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_trackingTableName));
#line default
#line hidden
this.Write("_PK] ON [");
#line 45 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_params.AuditingSchema));
#line default
#line hidden
this.Write("].[");
#line 45 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_trackingTableName));
#line default
#line hidden
this.Write("] \r\n\t(\r\n");
#line 47 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
bool first = true;
PushIndent(" ");
foreach (SchemaDataSet.SchemaPrimaryKeysRow primaryKeysRow in primaryKeysQuery)
{
if (!first)
{
Write(", ");
}
WriteLine("[" + primaryKeysRow.COLUMN_NAME + "] ASC");
first = false;
}
PopIndent();
#line default
#line hidden
this.Write("\t)\r\n\tINCLUDE \r\n\t(\r\n\t\t[TrackºId]\r\n\t) \r\n\tWITH \r\n\t(\r\n\t STATISTICS_NORECOMPUTE = OFF" +
"\r\n\t, SORT_IN_TEMPDB = OFF\r\n\t, IGNORE_DUP_KEY = OFF\r\n\t, DROP_EXISTING = OFF\r\n\t, O" +
"NLINE = OFF\r\n\t, ALLOW_ROW_LOCKS = ON\r\n\t, ALLOW_PAGE_LOCKS = ON\r\n\t)\r\n\tON [");
#line 76 "C:\Users\mcbeea\Desktop\AuditFramework\Model.AuditFramework\T4Templates\CreateTrackingTable.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(_params.AuditingFileGroup));
#line default
#line hidden
this.Write("];\r\n\r\nEND\r\nGO\r\n");
return(this.GenerationEnvironment.ToString());
}
public SearchIndexCollection(EnumerableRowCollection <DataRow> dataRows)
{
Set(dataRows);
}
public SiteCollection(EnumerableRowCollection <DataRow> dataRows)
{
Set(dataRows);
}
private void prcdToplamAl()
{
double dblIskToplami1 = 0;
double dblIskToplami2 = 0;
double dblIskToplami3 = 0;
double dblKdvToplami = 0;
double dblTutarToplami = 0;
double dblTutarIskontoluToplami = 0;
double dblTutarNetToplami = 0;
EnumerableRowCollection arrDR = from myRow in dtOdemeStoklar.AsEnumerable() where myRow.Field <int>("Sec") == 1 && string.IsNullOrEmpty(myRow.Field <string>("Odeme_Anahtar").TOSTRING().Trim()) select myRow;
foreach (DataRow DR in arrDR)
{
DR["Isk_Orani_1"] = dblMusteriIndirimOrani;
DR["Isk_Orani_2"] = dblIskontoOrani;
DR["Isk_Orani_3"] = dblYuvarlamaOrani;
double dblMiktari = DR["Miktari"].TODOUBLE();
double dblFiyati = DR["Fiyati"].TODOUBLE();
double dblKdvOrani = DR["Kdv_Orani"].TODOUBLE();
double dblIskOrani1 = DR["Isk_Orani_1"].TODOUBLE();
double dblIskOrani2 = DR["Isk_Orani_2"].TODOUBLE();
double dblIskOrani3 = DR["Isk_Orani_3"].TODOUBLE();
double dblTutari = dblMiktari * dblFiyati;
double dblTutariNet = dblTutari;
double dblTutariIskontolu = dblTutari;
double dblIskTutari1 = dblTutari * dblIskOrani1 / 100;
double dblIskTutari2 = (dblTutari - dblIskTutari1) * dblIskOrani2 / 100;
double dblIskTutari3 = (dblTutari - dblIskTutari1 - dblIskTutari2) * dblIskOrani3 / 100;
double dblTutariIskontoluYuvarlamali = dblTutari - dblIskTutari1 - dblIskTutari2 - dblIskTutari3;
dblTutariIskontolu = dblTutariIskontolu - dblIskTutari1 - dblIskTutari2;
dblTutariNet = dblTutariNet - dblIskTutari1 - dblIskTutari2 - dblIskTutari3;
double dblKdvTutari = dblTutariIskontoluYuvarlamali - (dblTutariIskontoluYuvarlamali / (1 + (dblKdvOrani / 100)));
DR["Isk_Tutari_1"] = dblIskTutari1;
DR["Isk_Tutari_2"] = dblIskTutari2;
DR["Isk_Tutari_3"] = dblIskTutari3;
DR["Kdv_Tutari"] = dblKdvTutari;
DR["Tutari"] = dblTutari;
DR["Tutari_Net"] = dblTutariNet;
dblIskToplami1 += dblIskTutari1;
dblIskToplami2 += dblIskTutari2;
dblIskToplami3 += dblIskTutari3;
dblKdvToplami += dblKdvTutari;
dblTutarToplami += dblTutari;
dblTutarIskontoluToplami += dblTutariIskontolu;
dblTutarNetToplami += dblTutariNet;
foreach (DataRow DRCesni in dtOdemeCesniler.Select(string.Format("Anahtar = '{0}'", DR["Anahtar"].TOSTRING())))
{
DRCesni["Isk_Orani_1"] = dblMusteriIndirimOrani;
DRCesni["Isk_Orani_2"] = dblIskontoOrani;
DRCesni["Isk_Orani_3"] = dblYuvarlamaOrani;
double dblMiktariCesni = DRCesni["Miktari"].TODOUBLE();
double dblFiyatiCesni = DRCesni["Fiyati"].TODOUBLE();
double dblKdvOraniCesni = DRCesni["Kdv_Orani"].TODOUBLE();
double dblIskOrani1Cesni = DRCesni["Isk_Orani_1"].TODOUBLE();
double dblIskOrani2Cesni = DRCesni["Isk_Orani_2"].TODOUBLE();
double dblIskOrani3Cesni = DRCesni["Isk_Orani_3"].TODOUBLE();
double dblTutariCesni = dblMiktariCesni * dblFiyatiCesni;
double dblTutariNetCesni = dblTutariCesni;
double dblTutariIskontoluCesni = dblTutariCesni;
double dblIskTutari1Cesni = dblTutariCesni * dblIskOrani1Cesni / 100;
double dblIskTutari2Cesni = (dblTutariCesni - dblIskTutari1Cesni) * dblIskOrani2Cesni / 100;
double dblIskTutari3Cesni = (dblTutariCesni - dblIskTutari1Cesni - dblIskTutari2Cesni) * dblIskOrani3Cesni / 100;
double dblTutariIskontoluYuvarlamaliCesni = dblTutariCesni - dblIskTutari1Cesni - dblIskTutari2Cesni - dblIskTutari3Cesni;
dblTutariIskontoluCesni = dblTutariIskontoluCesni - dblIskTutari1Cesni - dblIskTutari2Cesni;
dblTutariNetCesni = dblTutariNetCesni - dblIskTutari1Cesni - dblIskTutari2Cesni - dblIskTutari3Cesni;
double dblKdvTutariCesni = dblTutariIskontoluYuvarlamaliCesni - (dblTutariIskontoluYuvarlamaliCesni / (1 + (dblKdvOraniCesni / 100)));
DRCesni["Isk_Tutari_1"] = dblIskTutari1Cesni;
DRCesni["Isk_Tutari_2"] = dblIskTutari2Cesni;
DRCesni["Isk_Tutari_3"] = dblIskTutari3Cesni;
DRCesni["Kdv_Tutari"] = dblKdvTutariCesni;
DRCesni["Tutari"] = dblTutariCesni;
DRCesni["Tutari_Net"] = dblTutariNetCesni;
dblIskToplami1 += dblIskTutari1Cesni;
dblIskToplami2 += dblIskTutari2Cesni;
dblIskToplami3 += dblIskTutari3Cesni;
dblKdvToplami += dblKdvTutariCesni;
dblTutarToplami += dblTutariCesni;
dblTutarIskontoluToplami += dblTutariIskontoluCesni;
dblTutarNetToplami += dblTutariNetCesni;
}
}
double dblOdenen = dtOdemeTipleri.Compute("SUM(Odeme_Tutari)", "").TODOUBLE();
lblAraToplam.AccessibleDescription = dblTutarToplami.TOSTRING();
lblIskontoToplami.AccessibleDescription = (dblIskToplami1 + dblIskToplami2).TOSTRING();
lblToplam.AccessibleDescription = dblTutarIskontoluToplami.TOSTRING();
lblYuvarlama.AccessibleDescription = dblIskToplami3.TOSTRING();
lblKdvToplami.AccessibleDescription = dblKdvToplami.TOSTRING();
lblNetToplam.AccessibleDescription = dblTutarNetToplami.TOSTRING();
lblOdenen.AccessibleDescription = dblOdenen.TOSTRING();
if (dblTutarNetToplami - dblOdenen > 0)
{
lblKalan.AccessibleDescription = (dblTutarNetToplami - dblOdenen).TOSTRING();
lblParaUstu.AccessibleDescription = "0";
}
else
{
lblKalan.AccessibleDescription = "0";
lblParaUstu.AccessibleDescription = Math.Abs(dblTutarNetToplami - dblOdenen).TOSTRING();
}
lblAraToplam.Text = dblTutarToplami.ToString(clsGenel.strDoubleFormatTwo);
lblIskontoToplami.Text = (dblIskToplami1 + dblIskToplami2).ToString(clsGenel.strDoubleFormatTwo);
lblToplam.Text = dblTutarIskontoluToplami.ToString(clsGenel.strDoubleFormatTwo);
lblYuvarlama.Text = dblIskToplami3.ToString(clsGenel.strDoubleFormatTwo);
lblKdvToplami.Text = dblKdvToplami.ToString(clsGenel.strDoubleFormatTwo);
lblNetToplam.Text = dblTutarNetToplami.ToString(clsGenel.strDoubleFormatTwo);
lblOdenen.Text = dblOdenen.ToString(clsGenel.strDoubleFormatTwo);
if (dblTutarNetToplami - dblOdenen > 0)
{
lblKalan.Text = (dblTutarNetToplami - dblOdenen).ToString(clsGenel.strDoubleFormatTwo);
lblParaUstu.Text = "";
}
else
{
lblKalan.Text = "";
lblParaUstu.Text = Math.Abs(dblTutarNetToplami - dblOdenen).ToString(clsGenel.strDoubleFormatTwo);
}
}
protected override void ProcessData(KPDatabaseDataSet dataSet)
{
if (dataSet == null)
{
return;
}
ResetTextBox();
MobFilter mobFilter;
if (customMobSelection)
{
mobFilter = MobXPHandler.Instance.CustomMobFilter;
}
else
{
mobFilter = mobsCombo.CBGetMobFilter(exclude0XPMobs);
}
#region LINQ group construction
IEnumerable <DebuffGroup> durationSet = null;
EnumerableRowCollection <TPMovesGroup> tpMoveSet = null;
EnumerableRowCollection <EnfeebleGroup> paralyzeSet = null;
EnumerableRowCollection <EnfeebleGroup> slowSet = null;
// Process debuffs used by players
durationSet = from c in dataSet.Combatants
where (((EntityType)c.CombatantType == EntityType.Player) ||
((EntityType)c.CombatantType == EntityType.Pet) ||
((EntityType)c.CombatantType == EntityType.CharmedMob) ||
((EntityType)c.CombatantType == EntityType.Fellow))
orderby c.CombatantType, c.CombatantName
select new DebuffGroup
{
DebufferName = c.CombatantNameOrJobName,
Debuffs = from b in c.GetInteractionsRowsByActorCombatantRelation()
where (((HarmType)b.HarmType == HarmType.Enfeeble ||
(HarmType)b.HarmType == HarmType.Dispel ||
(HarmType)b.HarmType == HarmType.Unknown) &&
b.Preparing == false && b.IsActionIDNull() == false)
||
(b.Preparing == false &&
b.IsActionIDNull() == false &&
(diaRegex.Match(b.ActionsRow.ActionName).Success ||
bioRegex.Match(b.ActionsRow.ActionName).Success))
||
(b.Preparing == false && b.IsActionIDNull() == false &&
b.ActionsRow.GetInteractionsRows()
.Any(q => (HarmType)q.SecondHarmType == HarmType.Enfeeble ||
(HarmType)q.SecondHarmType == HarmType.Dispel))
group b by b.ActionsRow.ActionName into ba
orderby ba.Key
select new Debuffs
{
DebuffName = ba.Key,
DebuffTargets = from bt in ba
where (bt.IsTargetIDNull() == false &&
mobFilter.CheckFilterMobTarget(bt))
group bt by bt.CombatantsRowByTargetCombatantRelation.CombatantName into btn
orderby btn.Key
select new DebuffTargets
{
TargetName = btn.Key,
DebuffData = btn.OrderBy(i => i.Timestamp)
}
}
};
tpMoveSet = from b in dataSet.Battles
where (b.IsEnemyIDNull() == false &&
mobFilter.CheckFilterBattle(b) == true &&
b.DefaultBattle == false) &&
(b.IsKillerIDNull() == true ||
RegexUtility.ExcludedPlayer.Match(b.CombatantsRowByBattleKillerRelation.PlayerInfo).Success == false)
orderby b.BattleID
select new TPMovesGroup
{
FightLength = (b.IsOver == true)
? (b.EndTime - b.StartTime)
: (DateTime.Now.ToUniversalTime() - b.StartTime) < TimeSpan.FromDays(1)
? (DateTime.Now.ToUniversalTime() - b.StartTime)
: TimeSpan.Zero,
TPMoves = from i in b.GetInteractionsRows()
where i.IsActionIDNull() == false &&
i.IsActorIDNull() == false &&
i.ActorID == b.EnemyID &&
(ActionType)i.ActionType == ActionType.Ability
select i
};
paralyzeSet = from b in dataSet.Battles
where (b.IsEnemyIDNull() == false &&
mobFilter.CheckFilterBattle(b) == true &&
b.DefaultBattle == false) &&
(b.IsKillerIDNull() == true ||
RegexUtility.ExcludedPlayer.Match(b.CombatantsRowByBattleKillerRelation.PlayerInfo).Success == false)
orderby b.BattleID
select new EnfeebleGroup
{
Enfeebled = from i in b.GetInteractionsRows()
where i.IsActionIDNull() == false &&
i.IsTargetIDNull() == false &&
i.TargetID == b.EnemyID &&
(paralyzeRegex.Match(i.ActionsRow.ActionName).Success ||
jubakuRegex.Match(i.ActionsRow.ActionName).Success) &&
i.Preparing == false &&
(DefenseType)i.DefenseType == DefenseType.None
select i,
Actions = from i in b.GetInteractionsRows()
where (i.IsActorIDNull() == false &&
i.ActorID == b.EnemyID &&
((ActionType)i.ActionType == ActionType.Melee ||
(ActionType)i.ActionType == ActionType.Spell)) ||
((DefenseType)i.DefenseType == DefenseType.Shadow)
select i,
Paralyzed = from i in b.GetInteractionsRows()
where i.IsActorIDNull() == false &&
i.ActorID == b.EnemyID &&
(FailedActionType)i.FailedActionType == FailedActionType.Paralyzed
select i,
FightEndTime = b.EndTime
};
slowSet = from b in dataSet.Battles
where (b.IsEnemyIDNull() == false &&
mobFilter.CheckFilterBattle(b) == true &&
b.DefaultBattle == false) &&
(b.IsKillerIDNull() == true ||
RegexUtility.ExcludedPlayer.Match(b.CombatantsRowByBattleKillerRelation.PlayerInfo).Success == false)
orderby b.BattleID
select new EnfeebleGroup
{
Enfeebled = from i in b.GetInteractionsRows()
where i.IsActionIDNull() == false &&
i.IsTargetIDNull() == false &&
i.TargetID == b.EnemyID &&
(slowRegex.Match(i.ActionsRow.ActionName).Success ||
hojoRegex.Match(i.ActionsRow.ActionName).Success ||
elegyRegex.Match(i.ActionsRow.ActionName).Success) &&
i.Preparing == false &&
(DefenseType)i.DefenseType == DefenseType.None
select i,
Actions = from i in b.GetInteractionsRows()
where (i.IsActorIDNull() == false &&
i.ActorID == b.EnemyID &&
(ActionType)i.ActionType == ActionType.Melee) ||
(DefenseType)i.DefenseType == DefenseType.Shadow
select i,
FightEndTime = b.EndTime,
FightStartTime = b.StartTime
};
#endregion
List <StringMods> strModList = new List <StringMods>();
StringBuilder sb = new StringBuilder();
int analysisTypeIndex = categoryCombo.CBSelectedIndex();
switch (analysisTypeIndex)
{
case 1: // "Enfeeble Durations"
ProcessDurations(durationSet, ref sb, ref strModList);
break;
case 2: // "Paralyze"
ProcessParalyze(paralyzeSet, ref sb, ref strModList);
break;
case 3: // "TP Moves"
ProcessTPMoves(tpMoveSet, ref sb, ref strModList);
break;
case 4: // "Attack Speed"
ProcessAttackSpeed(slowSet, ref sb, ref strModList);
break;
case 0: // "All"
default:
ProcessDurations(durationSet, ref sb, ref strModList);
ProcessParalyze(paralyzeSet, ref sb, ref strModList);
ProcessTPMoves(tpMoveSet, ref sb, ref strModList);
//ProcessAttackSpeed(slowSet, ref sb, ref strModList);
break;
}
PushStrings(sb, strModList);
}
private bool fncKaydet()
{
bool blnReturn = false;
SqlConnection cnn = new SqlConnection(clsGenel.strConnectionString);
cnn.Open();
SqlCommand cmd = cnn.CreateCommand();
cmd.Transaction = cnn.BeginTransaction();
try
{
foreach (string strOdemeAnahtar in dOdemeler.Keys)
{
string strAnahtar = strOdemeAnahtar.Split('|')[0].TOSTRING();
int intCariNo = strOdemeAnahtar.Split('|')[1].TOINT();
int intFisTipi = (int)clsFisTipleri.FisTipleri.HizliSatis;
int intFisNo = clsGenel.fncYeniFisNoGetir(clsFisTipleri.FisTipleri.HizliSatis, clsGenel.intGenelIsyeriKodu, cnn, cmd);
string strParaBirimi = clsGenel.fncGetParameter("Para_Birimi", "TL");
DateTime dtFisTarihi = DateTime.ParseExact(strAnahtar, "yyyyMMddHHmmssfff", CultureInfo.InvariantCulture);
DataTable dtOdeme = dOdemeler[strOdemeAnahtar];
double dblOdemeToplami = dtOdeme.Compute("SUM(Odeme_Tutari)", "").TODOUBLE();
double dblOdemeToplamiVeresiyesiz = dtOdeme.Compute("SUM(Odeme_Tutari)", "Odeme_Tipi <> 3").TODOUBLE();
cmd.CommandText = "INSERT INTO Islem_Baslik (Depo_Kodu_1, Depo_Kodu_2, Fis_Tarihi, Fis_Saati, Cari_No, Belge_Tipi, Belge_No, Belge_Tarihi, Para_Birimi, Fiyat_Tipi, Kdv_Tipi_1, Kdv_Tipi_2, Aciklama, Insert_User, Inser_Date, Silindi, Fis_Tipi, Isyeri_Kodu, Fis_No) " +
"VALUES (@Depo_Kodu_1, @Depo_Kodu_2, @Fis_Tarihi, @Fis_Saati, @Cari_No, @Belge_Tipi, @Belge_No, @Belge_Tarihi, @Para_Birimi, @Fiyat_Tipi, @Kdv_Tipi_1, @Kdv_Tipi_2, @Aciklama, @Kullanici, @Zaman, @Silindi, @Fis_Tipi, @Isyeri_Kodu, @Fis_No)";
cmd.Parameters.AddWithValue("@Depo_Kodu_1", clsGenel.intGenelDepoKodu);
cmd.Parameters.AddWithValue("@Depo_Kodu_2", 0);
cmd.Parameters.AddWithValue("@Fis_Tarihi", dtFisTarihi.TODATE());
cmd.Parameters.AddWithValue("@Fis_Saati", dtFisTarihi.TOTIME());
cmd.Parameters.AddWithValue("@Cari_No", intCariNo);
cmd.Parameters.AddWithValue("@Belge_Tipi", "");
cmd.Parameters.AddWithValue("@Belge_No", strAnahtar);
cmd.Parameters.AddWithValue("@Belge_Tarihi", dtFisTarihi);
cmd.Parameters.AddWithValue("@Para_Birimi", strParaBirimi);
cmd.Parameters.AddWithValue("@Fiyat_Tipi", 1);
cmd.Parameters.AddWithValue("@Kdv_Tipi_1", 1);
cmd.Parameters.AddWithValue("@Kdv_Tipi_2", 1);
cmd.Parameters.AddWithValue("@Aciklama", "");
cmd.Parameters.AddWithValue("@Kullanici", clsGenel.strKullaniciKodu);
cmd.Parameters.AddWithValue("@Zaman", DateTime.Now);
cmd.Parameters.AddWithValue("@Silindi", 0);
cmd.Parameters.AddWithValue("@Fis_Tipi", intFisTipi);
cmd.Parameters.AddWithValue("@Isyeri_Kodu", clsGenel.intGenelIsyeriKodu);
cmd.Parameters.AddWithValue("@Fis_No", intFisNo);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
int intFisSira1 = 1;
int intFisSira2 = 1;
if (intCariNo > 0)
{
cmd.CommandText = "INSERT INTO Islem_Detay_Cari (Cari_No, Fis_Tarihi, Fis_Saati, Borc_Tutari, Borc_Tutari_Baslik, Borc_Tutari_Kart, Borc_Tutari_Sistem, Alacak_Tutari, Alacak_Tutari_Baslik, Alacak_Tutari_Kart, Alacak_Tutari_Sistem, Aciklama, Silindi, Fis_Tipi, Isyeri_Kodu, Fis_No, Fis_Sira, Islem_Yonu) " +
"VALUES (@Cari_No, @Fis_Tarihi, @Fis_Saati, @Borc_Tutari, @Borc_Tutari_Baslik, @Borc_Tutari_Kart, @Borc_Tutari_Sistem, @Alacak_Tutari, @Alacak_Tutari_Baslik, @Alacak_Tutari_Kart, @Alacak_Tutari_Sistem, @Aciklama, @Silindi, @Fis_Tipi, @Isyeri_Kodu, @Fis_No, @Fis_Sira, @Islem_Yonu)";
cmd.Parameters.AddWithValue("@Cari_No", intCariNo);
cmd.Parameters.AddWithValue("@Fis_Tarihi", dtFisTarihi.TODATE());
cmd.Parameters.AddWithValue("@Fis_Saati", dtFisTarihi.TOTIME());
cmd.Parameters.AddWithValue("@Borc_Tutari", dblOdemeToplami);
cmd.Parameters.AddWithValue("@Borc_Tutari_Baslik", dblOdemeToplami);
cmd.Parameters.AddWithValue("@Borc_Tutari_Kart", dblOdemeToplami);
cmd.Parameters.AddWithValue("@Borc_Tutari_Sistem", dblOdemeToplami);
cmd.Parameters.AddWithValue("@Alacak_Tutari", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Baslik", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Kart", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Sistem", 0);
cmd.Parameters.AddWithValue("@Aciklama", "");
cmd.Parameters.AddWithValue("@Silindi", 0);
cmd.Parameters.AddWithValue("@Fis_Tipi", intFisTipi);
cmd.Parameters.AddWithValue("@Isyeri_Kodu", clsGenel.intGenelIsyeriKodu);
cmd.Parameters.AddWithValue("@Fis_No", intFisNo);
cmd.Parameters.AddWithValue("@Fis_Sira", intFisSira1);
cmd.Parameters.AddWithValue("@Islem_Yonu", ((int)clsFisTipleri.IslemYonu.Giris));
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
intFisSira1++;
cmd.CommandText = "INSERT INTO Islem_Detay_Cari (Cari_No, Fis_Tarihi, Fis_Saati, Borc_Tutari, Borc_Tutari_Baslik, Borc_Tutari_Kart, Borc_Tutari_Sistem, Alacak_Tutari, Alacak_Tutari_Baslik, Alacak_Tutari_Kart, Alacak_Tutari_Sistem, Aciklama, Silindi, Fis_Tipi, Isyeri_Kodu, Fis_No, Fis_Sira, Islem_Yonu) " +
"VALUES (@Cari_No, @Fis_Tarihi, @Fis_Saati, @Borc_Tutari, @Borc_Tutari_Baslik, @Borc_Tutari_Kart, @Borc_Tutari_Sistem, @Alacak_Tutari, @Alacak_Tutari_Baslik, @Alacak_Tutari_Kart, @Alacak_Tutari_Sistem, @Aciklama, @Silindi, @Fis_Tipi, @Isyeri_Kodu, @Fis_No, @Fis_Sira, @Islem_Yonu)";
cmd.Parameters.AddWithValue("@Cari_No", intCariNo);
cmd.Parameters.AddWithValue("@Fis_Tarihi", dtFisTarihi.TODATE());
cmd.Parameters.AddWithValue("@Fis_Saati", dtFisTarihi.TOTIME());
cmd.Parameters.AddWithValue("@Borc_Tutari", 0);
cmd.Parameters.AddWithValue("@Borc_Tutari_Baslik", 0);
cmd.Parameters.AddWithValue("@Borc_Tutari_Kart", 0);
cmd.Parameters.AddWithValue("@Borc_Tutari_Sistem", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari", dblOdemeToplamiVeresiyesiz);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Baslik", dblOdemeToplamiVeresiyesiz);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Kart", dblOdemeToplamiVeresiyesiz);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Sistem", dblOdemeToplamiVeresiyesiz);
cmd.Parameters.AddWithValue("@Aciklama", "");
cmd.Parameters.AddWithValue("@Silindi", 0);
cmd.Parameters.AddWithValue("@Fis_Tipi", intFisTipi);
cmd.Parameters.AddWithValue("@Isyeri_Kodu", clsGenel.intGenelIsyeriKodu);
cmd.Parameters.AddWithValue("@Fis_No", intFisNo);
cmd.Parameters.AddWithValue("@Fis_Sira", intFisSira1);
cmd.Parameters.AddWithValue("@Islem_Yonu", ((int)clsFisTipleri.IslemYonu.Cikis));
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
intFisSira1++;
}
foreach (DataRow DR in dtOdeme.Rows)
{
if (DR["Kayit_Tipi"].TOINT() == 1)
{
cmd.CommandText = "INSERT INTO Islem_Detay_Cari (Cari_No, Fis_Tarihi, Fis_Saati, Borc_Tutari, Borc_Tutari_Baslik, Borc_Tutari_Kart, Borc_Tutari_Sistem, Alacak_Tutari, Alacak_Tutari_Baslik, Alacak_Tutari_Kart, Alacak_Tutari_Sistem, Aciklama, Odeme_No, Silindi, Fis_Tipi, Isyeri_Kodu, Fis_No, Fis_Sira, Islem_Yonu) " +
"VALUES (@Cari_No, @Fis_Tarihi, @Fis_Saati, @Borc_Tutari, @Borc_Tutari_Baslik, @Borc_Tutari_Kart, @Borc_Tutari_Sistem, @Alacak_Tutari, @Alacak_Tutari_Baslik, @Alacak_Tutari_Kart, @Alacak_Tutari_Sistem, @Aciklama, @Odeme_No, @Silindi, @Fis_Tipi, @Isyeri_Kodu, @Fis_No, @Fis_Sira, @Islem_Yonu)";
cmd.Parameters.AddWithValue("@Cari_No", DR["Kayit_Kodu"]);
cmd.Parameters.AddWithValue("@Fis_Tarihi", dtFisTarihi.TODATE());
cmd.Parameters.AddWithValue("@Fis_Saati", dtFisTarihi.TOTIME());
cmd.Parameters.AddWithValue("@Borc_Tutari", DR["Odeme_Tutari"]);
cmd.Parameters.AddWithValue("@Borc_Tutari_Baslik", DR["Odeme_Tutari"]);
cmd.Parameters.AddWithValue("@Borc_Tutari_Kart", DR["Odeme_Tutari"]);
cmd.Parameters.AddWithValue("@Borc_Tutari_Sistem", DR["Odeme_Tutari"]);
cmd.Parameters.AddWithValue("@Alacak_Tutari", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Baslik", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Kart", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Sistem", 0);
cmd.Parameters.AddWithValue("@Aciklama", "");
cmd.Parameters.AddWithValue("@Odeme_No", DR["Odeme_No"]);
cmd.Parameters.AddWithValue("@Silindi", 0);
cmd.Parameters.AddWithValue("@Fis_Tipi", intFisTipi);
cmd.Parameters.AddWithValue("@Isyeri_Kodu", clsGenel.intGenelIsyeriKodu);
cmd.Parameters.AddWithValue("@Fis_No", intFisNo);
cmd.Parameters.AddWithValue("@Fis_Sira", intFisSira1);
cmd.Parameters.AddWithValue("@Islem_Yonu", ((int)clsFisTipleri.IslemYonu.Giris));
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
intFisSira1++;
}
else if (DR["Kayit_Tipi"].TOINT() == 2)
{
cmd.CommandText = "INSERT INTO Islem_Detay_Kasa (Kasa_Kodu, Fis_Tarihi, Fis_Saati, Borc_Tutari, Borc_Tutari_Baslik, Borc_Tutari_Kart, Borc_Tutari_Sistem, Alacak_Tutari, Alacak_Tutari_Baslik, Alacak_Tutari_Kart, Alacak_Tutari_Sistem, Aciklama, Odeme_No, Silindi, Fis_Tipi, Isyeri_Kodu, Fis_No, Fis_Sira, Islem_Yonu) " +
"VALUES (@Kasa_Kodu, @Fis_Tarihi, @Fis_Saati, @Borc_Tutari, @Borc_Tutari_Baslik, @Borc_Tutari_Kart, @Borc_Tutari_Sistem, @Alacak_Tutari, @Alacak_Tutari_Baslik, @Alacak_Tutari_Kart, @Alacak_Tutari_Sistem, @Aciklama, @Odeme_No, @Silindi, @Fis_Tipi, @Isyeri_Kodu, @Fis_No, @Fis_Sira, @Islem_Yonu)";
cmd.Parameters.AddWithValue("@Kasa_Kodu", DR["Kayit_Kodu"]);
cmd.Parameters.AddWithValue("@Fis_Tarihi", dtFisTarihi.TODATE());
cmd.Parameters.AddWithValue("@Fis_Saati", dtFisTarihi.TOTIME());
cmd.Parameters.AddWithValue("@Borc_Tutari", DR["Odeme_Tutari"]);
cmd.Parameters.AddWithValue("@Borc_Tutari_Baslik", DR["Odeme_Tutari"]);
cmd.Parameters.AddWithValue("@Borc_Tutari_Kart", DR["Odeme_Tutari"]);
cmd.Parameters.AddWithValue("@Borc_Tutari_Sistem", DR["Odeme_Tutari"]);
cmd.Parameters.AddWithValue("@Alacak_Tutari", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Baslik", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Kart", 0);
cmd.Parameters.AddWithValue("@Alacak_Tutari_Sistem", 0);
cmd.Parameters.AddWithValue("@Aciklama", "");
cmd.Parameters.AddWithValue("@Odeme_No", DR["Odeme_No"]);
cmd.Parameters.AddWithValue("@Silindi", 0);
cmd.Parameters.AddWithValue("@Fis_Tipi", intFisTipi);
cmd.Parameters.AddWithValue("@Isyeri_Kodu", clsGenel.intGenelIsyeriKodu);
cmd.Parameters.AddWithValue("@Fis_No", intFisNo);
cmd.Parameters.AddWithValue("@Fis_Sira", intFisSira2);
cmd.Parameters.AddWithValue("@Islem_Yonu", ((int)clsFisTipleri.IslemYonu.Giris));
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
intFisSira2++;
}
}
List <DataRow> lstDRStok = new List <DataRow>();
EnumerableRowCollection <DataRow> arrDRStok = from myRow in dtOdemeStoklar.AsEnumerable() where myRow.Field <string>("Odeme_Anahtar").TOSTRING().Trim() == strOdemeAnahtar select myRow;
lstDRStok.AddRange(arrDRStok);
foreach (DataRow DR in arrDRStok)
{
EnumerableRowCollection <DataRow> arrDRCesni = from myRow in dtOdemeCesniler.AsEnumerable() where myRow.Field <string>("Anahtar").TOSTRING().Trim() == DR["Anahtar"].TOSTRING() select myRow;
lstDRStok.AddRange(arrDRCesni);
}
int intFisSiraStok = 1;
foreach (DataRow DR in lstDRStok)
{
cmd.CommandText = "INSERT INTO Islem_Detay_Stok (Depo_Kodu, Fis_Tarihi, Fis_Saati, Stok_No, Birim_Kodu, Giris_Miktari, Cikis_Miktari, Birim_Fiyati, Isk_Orani_1, Isk_Orani_2, Isk_Orani_3, Kdv_Orani, Isk_Tutari_1, Isk_Tutari_1_Baslik, Isk_Tutari_1_Kart, Isk_Tutari_1_Sistem, Isk_Tutari_2, Isk_Tutari_2_Baslik, Isk_Tutari_2_Kart, Isk_Tutari_2_Sistem, Isk_Tutari_3, Isk_Tutari_3_Baslik, Isk_Tutari_3_Kart, Isk_Tutari_3_Sistem, Kdv_Tutari, Kdv_Tutari_Baslik, Kdv_Tutari_Kart, Kdv_Tutari_Sistem, Giris_Tutari, Giris_Tutari_Baslik, Giris_Tutari_Kart, Giris_Tutari_Sistem, Cikis_Tutari, Cikis_Tutari_Baslik, Cikis_Tutari_Kart, Cikis_Tutari_Sistem, Giris_Tutari_Net, Giris_Tutari_Net_Baslik, Giris_Tutari_Net_Kart, Giris_Tutari_Net_Sistem, Cikis_Tutari_Net, Cikis_Tutari_Net_Baslik, Cikis_Tutari_Net_Kart, Cikis_Tutari_Net_Sistem, Aciklama, Silindi, Fis_Tipi, Isyeri_Kodu, Fis_No, Fis_Sira, Islem_Yonu) " +
"VALUES (@Depo_Kodu, @Fis_Tarihi, @Fis_Saati, @Stok_No, @Birim_Kodu, @Giris_Miktari, @Cikis_Miktari, @Birim_Fiyati, @Isk_Orani_1, @Isk_Orani_2, @Isk_Orani_3, @Kdv_Orani, @Isk_Tutari_1, @Isk_Tutari_1_Baslik, @Isk_Tutari_1_Kart, @Isk_Tutari_1_Sistem, @Isk_Tutari_2, @Isk_Tutari_2_Baslik, @Isk_Tutari_2_Kart, @Isk_Tutari_2_Sistem, @Isk_Tutari_3, @Isk_Tutari_3_Baslik, @Isk_Tutari_3_Kart, @Isk_Tutari_3_Sistem, @Kdv_Tutari, @Kdv_Tutari_Baslik, @Kdv_Tutari_Kart, @Kdv_Tutari_Sistem, @Giris_Tutari, @Giris_Tutari_Baslik, @Giris_Tutari_Kart, @Giris_Tutari_Sistem, @Cikis_Tutari, @Cikis_Tutari_Baslik, @Cikis_Tutari_Kart, @Cikis_Tutari_Sistem, @Giris_Tutari_Net, @Giris_Tutari_Net_Baslik, @Giris_Tutari_Net_Kart, @Giris_Tutari_Net_Sistem, @Cikis_Tutari_Net, @Cikis_Tutari_Net_Baslik, @Cikis_Tutari_Net_Kart, @Cikis_Tutari_Net_Sistem, @Aciklama, @Silindi, @Fis_Tipi, @Isyeri_Kodu, @Fis_No, @Fis_Sira, @Islem_Yonu)";
cmd.Parameters.AddWithValue("@Depo_Kodu", clsGenel.intGenelDepoKodu);
cmd.Parameters.AddWithValue("@Fis_Tarihi", dtFisTarihi.TODATE());
cmd.Parameters.AddWithValue("@Fis_Saati", dtFisTarihi.TOTIME());
cmd.Parameters.AddWithValue("@Stok_No", DR["Stok_No"].TOINT());
cmd.Parameters.AddWithValue("@Birim_Kodu", DR["Birim_Kodu"].TOSTRING());
cmd.Parameters.AddWithValue("@Giris_Miktari", 0);
cmd.Parameters.AddWithValue("@Cikis_Miktari", DR["Miktari"].TODOUBLE());
cmd.Parameters.AddWithValue("@Birim_Fiyati", DR["Fiyati"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Orani_1", DR["Isk_Orani_1"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Orani_2", DR["Isk_Orani_2"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Orani_3", DR["Isk_Orani_3"].TODOUBLE());
cmd.Parameters.AddWithValue("@Kdv_Orani", DR["Kdv_Orani"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_1", DR["Isk_Tutari_1"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_1_Baslik", DR["Isk_Tutari_1"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_1_Kart", DR["Isk_Tutari_1"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_1_Sistem", DR["Isk_Tutari_1"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_2", DR["Isk_Tutari_2"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_2_Baslik", DR["Isk_Tutari_2"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_2_Kart", DR["Isk_Tutari_2"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_2_Sistem", DR["Isk_Tutari_2"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_3", DR["Isk_Tutari_3"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_3_Baslik", DR["Isk_Tutari_3"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_3_Kart", DR["Isk_Tutari_3"].TODOUBLE());
cmd.Parameters.AddWithValue("@Isk_Tutari_3_Sistem", DR["Isk_Tutari_3"].TODOUBLE());
cmd.Parameters.AddWithValue("@Kdv_Tutari", DR["Kdv_Tutari"].TODOUBLE());
cmd.Parameters.AddWithValue("@Kdv_Tutari_Baslik", DR["Kdv_Tutari"].TODOUBLE());
cmd.Parameters.AddWithValue("@Kdv_Tutari_Kart", DR["Kdv_Tutari"].TODOUBLE());
cmd.Parameters.AddWithValue("@Kdv_Tutari_Sistem", DR["Kdv_Tutari"].TODOUBLE());
cmd.Parameters.AddWithValue("@Giris_Tutari", 0);
cmd.Parameters.AddWithValue("@Giris_Tutari_Baslik", 0);
cmd.Parameters.AddWithValue("@Giris_Tutari_Kart", 0);
cmd.Parameters.AddWithValue("@Giris_Tutari_Sistem", 0);
cmd.Parameters.AddWithValue("@Cikis_Tutari", DR["Tutari_Net"].TODOUBLE() - DR["Kdv_Tutari"].TODOUBLE());
cmd.Parameters.AddWithValue("@Cikis_Tutari_Baslik", DR["Tutari_Net"].TODOUBLE() - DR["Kdv_Tutari"].TODOUBLE());
cmd.Parameters.AddWithValue("@Cikis_Tutari_Kart", DR["Tutari_Net"].TODOUBLE() - DR["Kdv_Tutari"].TODOUBLE());
cmd.Parameters.AddWithValue("@Cikis_Tutari_Sistem", DR["Tutari_Net"].TODOUBLE() - DR["Kdv_Tutari"].TODOUBLE());
cmd.Parameters.AddWithValue("@Giris_Tutari_Net", 0);
cmd.Parameters.AddWithValue("@Giris_Tutari_Net_Baslik", 0);
cmd.Parameters.AddWithValue("@Giris_Tutari_Net_Kart", 0);
cmd.Parameters.AddWithValue("@Giris_Tutari_Net_Sistem", 0);
cmd.Parameters.AddWithValue("@Cikis_Tutari_Net", DR["Tutari_Net"]);
cmd.Parameters.AddWithValue("@Cikis_Tutari_Net_Baslik", DR["Tutari_Net"]);
cmd.Parameters.AddWithValue("@Cikis_Tutari_Net_Kart", DR["Tutari_Net"]);
cmd.Parameters.AddWithValue("@Cikis_Tutari_Net_Sistem", DR["Tutari_Net"]);
cmd.Parameters.AddWithValue("@Aciklama", DR["Aciklama"].TOSTRING());
cmd.Parameters.AddWithValue("@Silindi", 0);
cmd.Parameters.AddWithValue("@Fis_Tipi", intFisTipi);
cmd.Parameters.AddWithValue("@Isyeri_Kodu", clsGenel.intGenelIsyeriKodu);
cmd.Parameters.AddWithValue("@Fis_No", intFisNo);
cmd.Parameters.AddWithValue("@Fis_Sira", intFisSiraStok);
cmd.Parameters.AddWithValue("@Islem_Yonu", ((int)clsFisTipleri.IslemYonu.Cikis));
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
intFisSiraStok++;
}
intFisNo++;
}
cmd.Transaction.Commit();
blnReturn = true;
}
catch (Exception ex)
{
cmd.Transaction.Rollback();
MessageBox.Show("Satışların kayıt işleminde bir hata oluştu." + Environment.NewLine + ex.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
cmd.Dispose();
cnn.Close();
return(blnReturn);
}
private void ProcessAttackSpeed(EnumerableRowCollection <EnfeebleGroup> slowSet,
ref StringBuilder sb, ref List <StringMods> strModList)
{
strModList.Add(new StringMods
{
Start = sb.Length,
Length = lsSpeedTitle.Length,
Bold = true,
Color = Color.Red
});
sb.Append(lsSpeedTitle + "\n");
strModList.Add(new StringMods
{
Start = sb.Length,
Length = lsSpeedHeader1.Length,
Bold = true,
Color = Color.Black
});
sb.Append(lsSpeedHeader1 + "\n");
strModList.Add(new StringMods
{
Start = sb.Length,
Length = lsSpeedHeader2.Length,
Bold = true,
Underline = true,
Color = Color.Black
});
sb.Append(lsSpeedHeader2 + "\n");
int totalFights = slowSet.Count();
int totalSlowCast = slowSet.Sum(a => a.Enfeebled.Count());
int slowedActions = 0;
int normalActions = 0;
int totalMobsSlowed = 0;
double slowedAttackRate = 0;
double normalAttackRate = 0;
DateTime slowBufferTime = DateTime.MinValue;
DateTime slowLimitTime = DateTime.MinValue;
TimeSpan totalWindowTime = TimeSpan.Zero;
TimeSpan unslowedTime = TimeSpan.Zero;
foreach (var mob in slowSet)
{
if (mob.Enfeebled.Any())
{
totalMobsSlowed++;
}
var mobActionList = mob.Actions.ToList();
unslowedTime += mob.FightEndTime - mob.FightStartTime;
for (int i = 0; i < mob.Enfeebled.Count(); i++)
{
// Get the limits of the time period we will look at.
var enf = mob.Enfeebled.ElementAt(i);
// Start point
slowBufferTime = enf.Timestamp.AddSeconds(-3);
// Preliminary end point
slowLimitTime = mob.FightEndTime;
if ((i + 1) < mob.Enfeebled.Count())
{
slowLimitTime = mob.Enfeebled.ElementAt(i + 1).Timestamp.AddSeconds(-2);
}
if (slowLimitTime > enf.Timestamp.AddMinutes(3))
{
slowLimitTime = enf.Timestamp.AddMinutes(3);
}
// Final end point determined
totalWindowTime += slowLimitTime - slowBufferTime;
// Get all actions within that window
var actionsInWindow = mob.Actions.Where(a =>
a.Timestamp >= slowBufferTime &&
a.Timestamp <= slowLimitTime);
slowedActions += actionsInWindow.Count();
foreach (var action in actionsInWindow)
{
mobActionList.Remove(action);
}
}
normalActions += mobActionList.Count;
}
unslowedTime -= totalWindowTime;
if (totalWindowTime > TimeSpan.Zero)
{
slowedAttackRate = ((double)slowedActions / totalWindowTime.TotalSeconds) * 60;
}
if (unslowedTime > TimeSpan.Zero)
{
normalAttackRate = ((double)normalActions / unslowedTime.TotalSeconds) * 60;
}
sb.AppendFormat(lsSpeedFormat,
totalFights, totalSlowCast, totalMobsSlowed, slowedActions, slowedAttackRate,
normalActions, normalAttackRate);
sb.Append("\n\n\n");
}
private void btSelect_Click(object sender, EventArgs e)
{
if (decimal.Parse(tbMoney.Text.ToString()) == 0)
{
MessageBox.Show("Необходимо ввести сумму!", "Информирование", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
decimal summa = decimal.Parse(tbMoney.Text.Trim());
DataTable dtHistory = Config.hCntMain.getHistoryOrderAndReturn(id_ServiceRecords);
decimal maxSumma = decimal.Parse(dtHistory.Rows[0]["maxSumma"].ToString());
decimal balanceGet = decimal.Parse(dtHistory.Rows[0]["balanceGet"].ToString());
decimal balanceGetInValuta = decimal.Parse(dtHistory.Rows[0]["balanceGetInValuta"].ToString());
decimal balanceReturn = decimal.Parse(dtHistory.Rows[0]["balanceReturn"].ToString());
decimal debtReport = decimal.Parse(dtHistory.Rows[0]["debtReport"].ToString());
//decimal oldDebt = decimal.Parse(dtHistory.Rows[0]["oldDebt"].ToString()); // для ежемесячногй СЗ
string valuta = dtHistory.Rows[0]["Valuta"].ToString();
decimal sumGet = decimal.Parse(dtHistory.Rows[0]["sumGet"].ToString());
decimal sumOrderGetInValuta = decimal.Parse(dtHistory.Rows[0]["sumOrderGetInValuta"].ToString());
int monthDateCreateReport = DateTime.Parse(dtHistory.Rows[0]["DateCreateReport"].ToString()).Month;
int yearDateCreateReport = DateTime.Parse(dtHistory.Rows[0]["DateCreateReport"].ToString()).Year;
bool isTodayMonthAbdYear = nowTime.Month.Equals(monthDateCreateReport) && nowTime.Year.Equals(yearDateCreateReport);
//int typeSROnTime = (int)dtHistory.Rows[0]["typeSROnTime"];
if (idOrder != 0)
{
balanceGet += oldSumma;
balanceReturn += oldSumma;
}
if (summa > maxSumma && (type == 1 || (type == 2 && valuta == "RUB")))
{
MessageBox.Show("Сумма превышает \"Сумму СЗ\"!", "Информирование", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
decimal summaInValuta = 0;
if (tbSumInRub.Text.Length > 0 ? decimal.Parse(tbSumInRub.Text) > 0 ? true: false: false)
{
summa = decimal.Parse(tbSumInRub.Text.Trim());
summaInValuta = decimal.Parse(tbMoney.Text.Trim());
}
if (checkSumInRub && double.Parse(tbCourse.Text) <= 0)
{
MessageBox.Show("Заполните курс валюты!", "Информирование", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
// decimal balanceSumma = type == 1? getHistoryOrder(id_ServiceRecords, maxSumma) : getHistoryReturn(id_ServiceRecords, maxSumma);
if (type == 1 && (balanceGet - (checkSumInRub ? summaInValuta : summa) < 0) && valuta == "RUB") // - (checkSumInRub ? summaInValuta : summa) < 0)
{
MessageBox.Show("Вы можете получить не больше " + balanceGet, "Информирование", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (type == 1 && summaInValuta > balanceGetInValuta && valuta != "RUB") // - (checkSumInRub ? summaInValuta : summa) < 0)
{
MessageBox.Show("Вы можете получить не больше " + balanceGetInValuta, "Информирование", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (type == 2 && valuta == "RUB" && (checkSumInRub ? summaInValuta : summa) > balanceReturn)
{
MessageBox.Show("Вы можете вернуть не больше " + balanceReturn, "Информирование", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (type == 2 && valuta != "RUB" && summa > balanceReturn)
{
MessageBox.Show("Вы можете вернуть не больше " + balanceReturn, "Информирование", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (type == 2 && (checkSumInRub ? summaInValuta : summa) > balanceReturn && balanceReturn > 0 && !isTodayMonthAbdYear)
{
MessageBox.Show(Config.centralText("Вы можете вернуть по старому долгу\nне больше " + balanceReturn + "\n"), "Информирование", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (DialogResult.Yes == MessageBox.Show("Вы заказываете на имя " + cmbDirector.Text, "Заказ", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2))
{
int idMoneyRecipient;
idMoneyRecipient = (int)cmbDirector.SelectedValue;
DataTable dtTMP = new DataTable();
DataTable dtTMPUpdate = new DataTable();
if (idOrder == 0)
{
dtTMP = Config.hCntMain.setPayments(id_ServiceRecords,
dtpDate.Value,
summa,
type,
UserSettings.User.Id,
idMoneyRecipient,
status,
summaInValuta,
valuta //,
//oldDebt
);
}
else
{
dtTMPUpdate = Config.hCntMain.updatePayments(idOrder,
dtpDate.Value,
summa,
type,
UserSettings.User.Id,
idMoneyRecipient,
status,
summaInValuta, isChangeUserMoneyTake);
}
if ((dtTMP == null || dtTMP.Rows.Count == 0) && idOrder == 0)
{
MessageBox.Show("Ошибка добавления.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (dtTMPUpdate != null ? dtTMPUpdate.Rows.Count > 0 ? true: false: false)
{
if (dtTMPUpdate.Rows[0][0].ToString().Equals("ошибка"))
{
MessageBox.Show("Ошибка редактирования.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
this.DialogResult = DialogResult.OK;
}
if (isEdit)
{
DataTable dtTmpData = Config.hCntMain.getServiceRecordsBody(id_ServiceRecords);
Logging.StartFirstLevel(1503);
Logging.Comment("Произведено редактирование операции по ДС");
Logging.Comment("Тип операции:" + (type == 1 ? "Получение" : "Возврат"));
//Logging.Comment("ID: " + idOrder);
Logging.Comment("Id СЗ: " + id_ServiceRecords);
Logging.Comment("Номер СЗ: " + dtTmpData.Rows[0]["Number"].ToString());
Logging.Comment("Подномер: " + tbNumberSub.Text);
//Logging.VariableChange("Сумма", tbMoney.Text, oldSumma);
Logging.Comment("Сумма: " + tbMoney.Text);
Logging.Comment("Валюта: " + tbValuta.Text);
Logging.Comment("Тип СЗ по времени: " + ((int)dtTmpData.Rows[0]["TypeServiceRecordOnTime"] == 1 ? "разовая" : ((int)dtTmpData.Rows[0]["TypeServiceRecordOnTime"] == 2 ? "ежемесячная" : "Фонд")));
int?idFond = dtTmpData.Rows[0]["id_ServiceRecordsFond"] == DBNull.Value ? null : (int?)dtTmpData.Rows[0]["id_ServiceRecordsFond"];
if (idFond != null)
{
DataTable dtTmpFond = Config.hCntMain.getFondInfo(idFond, id_ServiceRecords);
if (dtTmpFond != null && dtTmpFond.Rows.Count > 0)
{
Logging.Comment($"№{dtTmpFond.Rows[0]["Number"].ToString()} на {dtTmpFond.Rows[0]["sumString"].ToString()} от {((DateTime)dtTmpFond.Rows[0]["DateConfirmationD"]).ToShortDateString()}");
}
}
else
{
Logging.Comment((int)dtTmpData.Rows[0]["TypeServiceRecordOnTime"] == 3 ? "Доп.фонд не выбран" : "Фонд не выбран");
}
if (dtTmpData.Rows[0]["inType"] != DBNull.Value)
{
DataTable dtTypicalWorks = Config.hCntMain.getTypicalWorks(false);
if (dtTypicalWorks != null && dtTypicalWorks.Rows.Count > 0)
{
EnumerableRowCollection <DataRow> rowType = dtTypicalWorks.AsEnumerable().Where(r => r.Field <int>("id") == (int)dtTmpData.Rows[0]["inType"]);
if (rowType.Count() > 0)
{
Logging.Comment($"Тип работ ID:{rowType.First()["id"]}; Наименование:{rowType.First()["cName"]}");
}
}
}
Logging.VariableChange("Получатель ID: ", cmbDirector.SelectedValue, oldIdDirector, typeLog._int);
Logging.VariableChange("Получатель ФИО: ", cmbDirector.Text, oldDirector == null ? "" : oldDirector);
Logging.Comment("Предполагаемая дата: " + dtpDate.Value.ToShortDateString());
if (!valuta.Equals("RUB") && type != 2)
{
Logging.Comment("Курс валюты: " + tbCourse.Text);
Logging.Comment("Сумму в рублях: " + tbSumInRub.Text);
}
if (dtTMPUpdate != null && dtTMPUpdate.Rows.Count > 0 && !dtTMPUpdate.Columns.Contains("error"))
{
Logging.Comment("ФИО автора СЗ ID: " + dtTMPUpdate.Rows[0]["id_Creator"].ToString() + "; ФИО: " + dtTMPUpdate.Rows[0]["FIO"].ToString());
}
if (dtTMP != null && dtTMP.Rows.Count > 0 && !dtTMP.Columns.Contains("error"))
{
Logging.Comment("Статус ДО ID: " + dtTMP.Rows[0]["id_prev"].ToString() + "; Наименование: " + dtTMP.Rows[0]["cName_prev"].ToString());
Logging.Comment("Статус После ID: " + dtTMP.Rows[0]["id"].ToString() + "; Наименование: " + dtTMP.Rows[0]["cName"].ToString());
}
Logging.Comment("Операцию выполнил: ID:" + Nwuram.Framework.Settings.User.UserSettings.User.Id
+ " ; ФИО:" + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername);
Logging.StopFirstLevel();
}
else
{
setLog(id_ServiceRecords, "", 0, type);
}
//тут запись в ДО ДЗ
if (!isChangeUserMoneyTake)
{
DataTable dtTmpMemo = Config.hCntMain.getMemorandums(nowTime, nowTime, id_ServiceRecords, false);
if (dtTmpMemo != null && dtTmpMemo.Rows.Count > 0)
{
foreach (DataRow row in dtTmpMemo.Rows)
{
int id_doc = (int)row["id_doc"];
Config.hCntDocumentsDZ.setMoveDocument(id_doc);
}
}
}
//if (id_doc != null)
//Config.hCntDocumentsDZ.setMoveDocument(id_doc);
//
if (inType == 4 && UserSettings.User.StatusCode.Equals("РКВ"))
{
if (MessageBox.Show("Вы хотите распечатать табель?", "Печать табеля", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DataTable dtTrialTable = Config.hCntMain.getTrialTablePayICServiceRecordLink(id_ServiceRecords);
DataTable dtTmpIC = dtTrialTable.Clone();
var groupKadr = dtTrialTable.AsEnumerable().GroupBy(g => new { id_Kadr = g.Field <int>("id_Kadr") }).Select(s => new { s.Key.id_Kadr });
foreach (var gKadr in groupKadr)
{
EnumerableRowCollection <DataRow> rowCollect = dtTrialTable.AsEnumerable().Where(r => r.Field <int>("id_Kadr") == gKadr.id_Kadr).OrderBy(r => r.Field <DateTime>("TimeIn"));
string periodPay = "";
DateTime tmpDate = (DateTime)rowCollect.First()["TimeIn"];
bool isNextTrue = false;
for (int i = 0; i < rowCollect.Count(); i++)
{
DataRow row = rowCollect.ElementAt(i);
TimeSpan span = ((DateTime)row["TimeIn"]).Date - tmpDate.Date;
if (span.Days == 0)
{
periodPay += (periodPay.Length == 0 ? "" : ",") + $"{tmpDate.ToShortDateString()}";
}
else
if (span.Days == 1)
{
isNextTrue = true;
if (i == rowCollect.Count() - 1)
{
periodPay += $"-{((DateTime)row["TimeIn"]).ToShortDateString()}";
}
}
else
{
if (isNextTrue)
{
periodPay += $"-{tmpDate.ToShortDateString()},{((DateTime)row["TimeIn"]).ToShortDateString()}";
}
else
{
periodPay += $",{((DateTime)row["TimeIn"]).ToShortDateString()}";
}
isNextTrue = false;
}
tmpDate = (DateTime)row["TimeIn"];
}
DataRow newRow = dtTmpIC.NewRow();
newRow["FIO"] = rowCollect.First()["FIO"];
newRow["namePost"] = rowCollect.First()["namePost"];
newRow["OldSalary"] = rowCollect.First()["OldSalary"];
newRow["MinSalary"] = rowCollect.First()["MinSalary"];
newRow["MaxSalary"] = rowCollect.First()["MaxSalary"];
newRow["nowSalary"] = rowCollect.First()["nowSalary"];
newRow["id_Kadr"] = rowCollect.First()["id_Kadr"];
newRow["periodPay"] = periodPay;
newRow["minuteWork"] = dtTrialTable.AsEnumerable().Where(r => r.Field <int>("id_Kadr") == gKadr.id_Kadr).Sum(r => r.Field <decimal>("WorkedHours"));
newRow["hourWorkOnDay"] = dtTrialTable.AsEnumerable().Where(r => r.Field <int>("id_Kadr") == gKadr.id_Kadr).Sum(r => r.Field <decimal>("hourWorkOnDay"));
newRow["payment"] = dtTrialTable.AsEnumerable().Where(r => r.Field <int>("id_Kadr") == gKadr.id_Kadr).Sum(r => r.Field <decimal>("payment")).ToString("0.00");
dtTmpIC.Rows.Add(newRow);
}
dtTrialTable = dtTmpIC.Copy();
DataTable dtToReport = dtTrialTable.Copy();
for (int i = dtToReport.Columns.Count - 1; i >= 0; i--)
//foreach (DataColumn col in dtToReport.Columns)
{
DataColumn col = dtToReport.Columns[i];
if (new List <string>()
{
"FIO", "namePost", "nowSalary", "periodPay", "minuteWork" /*, "hourWorkOnDay"*/, "Payment"
}.Contains(col.ColumnName))
{
continue;
}
removeColumn(dtToReport, col.ColumnName);
}
dtToReport.Columns.Add("sing", typeof(string)).DefaultValue = "";
dtToReport.Columns["FIO"].SetOrdinal(0);
dtToReport.Columns["namePost"].SetOrdinal(1);
dtToReport.Columns["nowSalary"].SetOrdinal(2);
dtToReport.Columns["periodPay"].SetOrdinal(3);
dtToReport.Columns["minuteWork"].SetOrdinal(4);
//dtToReport.Columns["hourWorkOnDay"].SetOrdinal(5);
dtToReport.Columns["Payment"].SetOrdinal(5);
dtToReport.Columns["sing"].SetOrdinal(6);
Nwuram.Framework.ToWord.HandmadeReport report = new Nwuram.Framework.ToWord.HandmadeReport(Application.StartupPath + @"\Templates\tamplateIC.dotx");
report.CurrentTable = report.GetTable(1);
report.SetCellText(1, 1, $"Отдел: {nameDep}");
report.SetCellText(1, 2, $"Выгрузил: {UserSettings.User.FullUsername}");
report.SetCellText(2, 1, $"№ СЗ на ДС: {NumSZ}");
report.SetCellText(2, 2, $"Дата выгрузки: {DateTime.Now.ToShortDateString()} {DateTime.Now.ToShortTimeString()}");
report.CurrentTable = report.GetTable(2);
report.ExportDataToTable(2, dtToReport, true);
report.CurrentTable = report.GetTable(3);
report.SetCellText(1, 6, $"{dtToReport.AsEnumerable().Sum(r => r.Field<decimal>("Payment")).ToString("0.00")}");
report.SetPageOrientation(Microsoft.Office.Interop.Word.WdOrientation.wdOrientLandscape);
report.Show();
}
}
this.DialogResult = DialogResult.OK;
}
else
{
return;
}
}
public LoginKeyCollection(EnumerableRowCollection <DataRow> dataRows)
{
Set(dataRows);
}
private void setLog(int id, string comment, int id_status, int isSend)
{
DataTable dtTmpData = Config.hCntMain.getServiceRecordsBody(id);
if (isSend == 1)
{
Logging.StartFirstLevel(1254);
}
else
{
Logging.StartFirstLevel(1255);
}
Logging.Comment("Id СЗ: " + id_ServiceRecords);
Logging.Comment("Номер СЗ: " + dtTmpData.Rows[0]["Number"].ToString());
Logging.Comment("Подномер: " + tbNumberSub.Text);
Logging.Comment("Сумма: " + tbMoney.Text);
Logging.Comment("Предполагаемая дата: " + dtpDate.Value.ToShortDateString());
Logging.Comment(chbChangeDirector.Text + ": " + (chbChangeDirector.Checked ? "Включен" : "Отключен"));
if (chbChangeDirector.Checked)
{
Logging.Comment("Получатель отличается от заказчика");
}
Logging.Comment("Руководиель ID: " + (int)dtDir.Rows[cmbDirector.SelectedIndex][0] + "; Наименование:" + cmbDirector.Text.ToString());
if (!valuta.Equals("RUB") && type != 2)
{
Logging.Comment("Курс валюты: " + tbCourse.Text);
Logging.Comment("Сумму в рублях: " + tbSumInRub.Text);
}
Logging.Comment("Тип СЗ: " + ((int)dtTmpData.Rows[0]["TypeServiceRecord"] == 0 ? "стандарт." : "предварит."));
//Logging.Comment("Тип СЗ по времени: " + ((int)dtTmpData.Rows[0]["TypeServiceRecordOnTime"] == 1 ? "разовая" : "ежемесячная"));
Logging.Comment("Тип СЗ по времени: " + ((int)dtTmpData.Rows[0]["TypeServiceRecordOnTime"] == 1 ? "разовая" : ((int)dtTmpData.Rows[0]["TypeServiceRecordOnTime"] == 2 ? "ежемесячная" : "Фонд")));
int?idFond = dtTmpData.Rows[0]["id_ServiceRecordsFond"] == DBNull.Value ? null : (int?)dtTmpData.Rows[0]["id_ServiceRecordsFond"];
if (idFond != null)
{
DataTable dtTmpFond = Config.hCntMain.getFondInfo(idFond, id);
if (dtTmpFond != null && dtTmpFond.Rows.Count > 0)
{
Logging.Comment($"№{dtTmpFond.Rows[0]["Number"].ToString()} на {dtTmpFond.Rows[0]["sumString"].ToString()} от {((DateTime)dtTmpFond.Rows[0]["DateConfirmationD"]).ToShortDateString()}");
}
}
else
{
Logging.Comment((int)dtTmpData.Rows[0]["TypeServiceRecordOnTime"] == 3 ? "Доп.фонд не выбран" : "Фонд не выбран");
}
if (dtTmpData.Rows[0]["inType"] != DBNull.Value)
{
DataTable dtTypicalWorks = Config.hCntMain.getTypicalWorks(false);
if (dtTypicalWorks != null && dtTypicalWorks.Rows.Count > 0)
{
EnumerableRowCollection <DataRow> rowType = dtTypicalWorks.AsEnumerable().Where(r => r.Field <int>("id") == (int)dtTmpData.Rows[0]["inType"]);
if (rowType.Count() > 0)
{
Logging.Comment($"Тип работ ID:{rowType.First()["id"]}; Наименование:{rowType.First()["cName"]}");
}
}
}
Logging.Comment("Сумма:" + decimal.Parse(dtTmpData.Rows[0]["Summa"].ToString()).ToString("0.00"));
Logging.Comment("Валюта:" + dtTmpData.Rows[0]["Valuta"].ToString());
if ((bool)dtTmpData.Rows[0]["Mix"])
{
Logging.Comment("Сумма нал:" + dtTmpData.Rows[0]["SummaCash"].ToString());
Logging.Comment("Сумма безнал:" + dtTmpData.Rows[0]["SummaNonCash"].ToString());
}
Logging.Comment("Объект ID: " + dtTmpData.Rows[0]["id_Object"].ToString() + "; Наименование:" + dtTmpData.Rows[0]["name_Object"].ToString());
Logging.Comment("Описание, комментарий: " + dtTmpData.Rows[0]["Description"].ToString());
//Logging.Comment("Оплата: " + (!(bool)dtTmpData.Rows[0]["bCashNonCash"] ? "Наличные" : "Карта"));
Logging.Comment("Оплата: " + ((bool)dtTmpData.Rows[0]["Mix"] ? "Смешанный" : (!(bool)dtTmpData.Rows[0]["bCashNonCash"] ? "Наличные" : "Карта")));
Logging.Comment("Дата создания СЗ: " + ((DateTime)dtTmpData.Rows[0]["CreateServiceRecord"]).ToShortDateString());
Logging.Comment("Блок ID: " + dtTmpData.Rows[0]["id_Block"].ToString() + "; Наименование:" + dtTmpData.Rows[0]["nameBlock"].ToString());
Logging.Comment("Отдел ID: " + dtTmpData.Rows[0]["id_Department"].ToString() + "; Наименование:" + dtTmpData.Rows[0]["nameDeps"].ToString());
Logging.Comment("На рассмотрении РП. Прошу включить в Б: " + ((DateTime)dtTmpData.Rows[0]["MonthB"]).ToShortDateString());
if (dtTmpData.Rows[0]["bDataSumma"] != DBNull.Value && !(bool)dtTmpData.Rows[0]["bDataSumma"] && dtTmpData.Rows[0]["DataSumma"] != DBNull.Value)
{
Logging.Comment("Дата получения ДС (при единовременном получении ДС): " + ((DateTime)dtTmpData.Rows[0]["DataSumma"]).ToShortDateString());
}
if (dtTmpData.Rows[0]["DataSumma"] == DBNull.Value && dtTmpData.Rows[0]["bDataSumma"] != DBNull.Value && (bool)dtTmpData.Rows[0]["bDataSumma"])
{
DataTable dtMultipleReceivingMone = Config.hCntMain.getMultipleReceivingMone(id);
Logging.Comment("Дата получения ДС (при распределенном ДС)");
foreach (DataRow r in dtMultipleReceivingMone.Rows)
{
Logging.Comment("Подномер:" + r["SubNumber"].ToString() + ";Сумма:" + r["Summa"].ToString() + ";Предполагаемая дата:" + r["DataSumma"].ToString());
}
}
Logging.Comment("Комментарий:" + dtTmpData.Rows[0]["Comments"].ToString().Replace(@"\r", "\r\n"));
if (comment.Length != 0)
{
Logging.Comment("Комментрий с формы:" + comment);
}
DataTable dtTmpMemo = Config.hCntMain.getMemorandums(nowTime, nowTime, id, false);
if (dtTmpMemo != null && dtTmpMemo.Rows.Count > 0)
{
if (dtTmpMemo != null && dtTmpMemo.Rows.Count > 0)
{
Logging.Comment("Произведена смена статуса у следующих ДЗ а ДО:");
foreach (DataRow row in dtTmpMemo.Rows)
{
Logging.Comment($"ID записи:{row["id"]}");
Logging.Comment($"№ ДЗ:{row["no_doc"]}");
Logging.Comment($"Дата:{row["date_create"]}");
Logging.Comment($"Отдел нарушителя:{row["depPenalty"]}");
Logging.Comment($"Заголовок ДЗ:{row["cname"]}");
Logging.Comment($"Тип нарушения:{row["DistrType"]}");
Logging.Comment($"Сумма нарушения:{row["sumPenalty"]}");
Logging.Comment($"Сумма премии:{row["SumBonus"]}");
Logging.Comment($"Сотрудник, обнаружевший нарушение:{row["FIOBonus"]}");
}
}
}
Logging.Comment("Операцию выполнил: ID:" + Nwuram.Framework.Settings.User.UserSettings.User.Id
+ " ; ФИО:" + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername);
Logging.StopFirstLevel();
}
public static void CopyDatabaseInfo(string name)
{
string infoPath = AppDomain.CurrentDomain.BaseDirectory + "info.sqlite";
string path = AppDomain.CurrentDomain.BaseDirectory + $"DataBase\\{name}.sqlite";
DataTable dataTable = dataTable = new DataTable();
using (SQLiteConnection conn = new SQLiteConnection("data source=" + infoPath))
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = conn;
conn.Open();
cmd.CommandText = "SELECT * FROM movie";
SQLiteDataReader sQLiteDataReader = cmd.ExecuteReader();
dataTable.Load(sQLiteDataReader);
}
}
//获取新数据库需要更新的值
DataTable newdataTable = new DataTable();
using (SQLiteConnection conn = new SQLiteConnection("data source=" + path))
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = conn;
conn.Open();
cmd.CommandText = "SELECT id FROM movie";
SQLiteDataReader sQLiteDataReader = cmd.ExecuteReader();
newdataTable.Load(sQLiteDataReader);
}
}
string sqltext = "UPDATE movie SET title=@title,releasedate=@releasedate,visits=@visits,director=@director,genre=@genre,tag=@tag," +
"actor=@actor,studio=@studio,rating=@rating,chinesetitle=@chinesetitle,favorites=@favorites,label=@label,plot=@plot,outline=@outline,year=@year,runtime=@runtime,country=@country,countrycode=@countrycode,otherinfo=@otherinfo,extraimageurl=@extraimageurl where id=@id";
using (SQLiteConnection conn = new SQLiteConnection("data source=" + path))
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = conn;
conn.Open();
foreach (DataRow row in newdataTable.Rows)
{
EnumerableRowCollection <DataRow> dataRows = dataTable.AsEnumerable().Where(myRow => myRow.Field <string>("id") == row["id"].ToString());
DataRow dataRow = null;
if (dataRows != null && dataRows.Count() > 0)
{
dataRow = dataRows.First();
}
else
{
continue;
}
cmd.CommandText = sqltext;
cmd.Parameters.Add("id", DbType.String).Value = dataRow["id"];
cmd.Parameters.Add("title", DbType.String).Value = dataRow["title"];
cmd.Parameters.Add("releasedate", DbType.String).Value = dataRow["releasedate"];
cmd.Parameters.Add("visits", DbType.Int16).Value = dataRow["visits"];
cmd.Parameters.Add("director", DbType.String).Value = dataRow["director"];
cmd.Parameters.Add("genre", DbType.String).Value = dataRow["genre"];
cmd.Parameters.Add("tag", DbType.String).Value = dataRow["tag"];
cmd.Parameters.Add("actor", DbType.String).Value = dataRow["actor"];
cmd.Parameters.Add("actorid", DbType.String).Value = dataRow["actorid"];
cmd.Parameters.Add("studio", DbType.String).Value = dataRow["studio"];
cmd.Parameters.Add("rating", DbType.Double).Value = dataRow["rating"];
cmd.Parameters.Add("chinesetitle", DbType.String).Value = dataRow["chinesetitle"];
cmd.Parameters.Add("favorites", DbType.Int16).Value = dataRow["favorites"];
cmd.Parameters.Add("label", DbType.String).Value = dataRow["label"];
cmd.Parameters.Add("plot", DbType.String).Value = dataRow["plot"];
cmd.Parameters.Add("outline", DbType.String).Value = dataRow["outline"];
cmd.Parameters.Add("year", DbType.Int16).Value = dataRow["year"];
cmd.Parameters.Add("runtime", DbType.Int16).Value = dataRow["runtime"];
cmd.Parameters.Add("country", DbType.String).Value = dataRow["country"];
cmd.Parameters.Add("countrycode", DbType.Int16).Value = dataRow["countrycode"];
cmd.Parameters.Add("otherinfo", DbType.String).Value = dataRow["otherinfo"];
cmd.Parameters.Add("sourceurl", DbType.String).Value = dataRow["sourceurl"];
cmd.Parameters.Add("source", DbType.String).Value = dataRow["source"];
cmd.Parameters.Add("extraimageurl", DbType.String).Value = dataRow["extraimageurl"];
cmd.ExecuteNonQuery();
}
}
}
}
private static bool HasChanges(
IEnumerable <ColumnDefinition> columnDefinitionCollection,
EnumerableRowCollection <DataRow> rdsColumnCollection)
{
return(rdsColumnCollection.Count() != columnDefinitionCollection.Count());
}
private void frmAdd_Load(object sender, EventArgs e)
{
init_combobox();
if (row != null)
{
id = (int)row["id"];
dtpStart.Value = (DateTime)row["DateStart"];
if (row["DateEnd"] == DBNull.Value)
{
rbStab.Checked = true; rbTime_Click(rbStab, null);
}
else
{
rbTime.Checked = true; rbTime_Click(rbTime, null); dtpEnd.Value = (DateTime)row["DateEnd"];
}
cmbTypeDicount.SelectedValue = row["id_TypeDiscount"];
cmbTypeTenant.SelectedValue = row["id_TypeTenant"];
cmbTypeAgreements.SelectedValue = row["id_TypeAgreements"];
#region ""
Task <DataTable> task = Config.hCntMain.getDiscountValue(id);
task.Wait();
if (task.Result != null && task.Result.Rows.Count > 0)
{
id_DiscountValue = (int)task.Result.Rows[0]["id"];
if (task.Result.Rows[0]["DiscountPrice"] != DBNull.Value)
{
tbDiscountPrice.Text = ((decimal)task.Result.Rows[0]["DiscountPrice"]).ToString("0.00");
}
if (task.Result.Rows[0]["PercentDiscount"] != DBNull.Value)
{
tbPercentDiscount.Text = ((decimal)task.Result.Rows[0]["PercentDiscount"]).ToString("0.00");
}
if (task.Result.Rows[0]["Price"] != DBNull.Value)
{
tbPrice.Text = ((decimal)task.Result.Rows[0]["Price"]).ToString("0.00");
}
if (task.Result.Rows[0]["TotalPrice"] != DBNull.Value)
{
tbTotalPrice.Text = ((decimal)task.Result.Rows[0]["TotalPrice"]).ToString("0.00");
}
}
#endregion
#region ""
task = Config.hCntMain.getDiscountObject(id);
task.Wait();
if (task.Result != null && task.Result.Rows.Count > 0)
{
cmbObjectDiscount.SelectedValue = task.Result.Rows[0]["typeRentalObject"];
cmbObjectDiscount_SelectionChangeCommitted(cmbObjectDiscount, null);
cmbObject.SelectedValue = task.Result.Rows[0]["id_ObjectLease"];
cmbObject_SelectionChangeCommitted(cmbObject, null);
foreach (DataRow row in task.Result.Rows)
{
EnumerableRowCollection <DataRow> rowCollect = dtData.AsEnumerable().Where(r => r.Field <int>("id") == (int)row["id_rentalObject"]);
if (rowCollect.Count() > 0)
{
rowCollect.First()["isSelect"] = true;
rowCollect.First()["isException"] = row["isException"];
}
}
setActiveTransferButton();
/*
* id_DiscountObject = (int)task.Result.Rows[0]["id"];
*
* if (task.Result.Rows[0]["id_ObjectLease"] != DBNull.Value)
* cmbObject.SelectedValue = task.Result.Rows[0]["id_ObjectLease"];
*
* if (task.Result.Rows[0]["id_Buildings"] != DBNull.Value)
* cmbBuilding.SelectedValue = task.Result.Rows[0]["id_Buildings"];
*
* if (task.Result.Rows[0]["id_Floor"] != DBNull.Value)
* cmbFloor.SelectedValue = task.Result.Rows[0]["id_Floor"];
*
*
*
* if (task.Result.Rows[0]["id_Sections"] != DBNull.Value)
* {
* cmbObjectDiscount.SelectedValue = 1;
* getObjectDicountData();
* cmbComby.SelectedValue = task.Result.Rows[0]["id_Sections"];
* }
*
* if (task.Result.Rows[0]["id_ReclamaPlace"] != DBNull.Value)
* {
* cmbObjectDiscount.SelectedValue = 2;
* getObjectDicountData();
* cmbComby.SelectedValue = task.Result.Rows[0]["id_ReclamaPlace"];
* }
*
* if (task.Result.Rows[0]["id_LandPlot"] != DBNull.Value)
* {
* cmbObjectDiscount.SelectedValue = 3;
* getObjectDicountData();
* cmbComby.SelectedValue = task.Result.Rows[0]["id_LandPlot"];
* }
*
* chbIsException.Checked = (bool)task.Result.Rows[0]["isException"];
*/
}
#endregion
//tbNumber.Text = (string)row["NumberPlace"];
//oldName = tbNumber.Text.Trim();
//cmbObject.SelectedValue = row["id_ObjectLease"];
//cmbBuilding.SelectedValue = row["id_Building"];
//tbLength.Text = row["Length"].ToString();
//tbWidth.Text = row["Width"].ToString();
}
isEditData = false;
}
/// <summary>
/// Applies the filter on the column corresponding to the pattern in the given datarow
/// </summary>
internal override Boolean ApplyFilter(DataRow row, Boolean applyNegation)
{
Boolean keepRow = false;
EnumerableRowCollection <DataRow> patternResultsEnumerable = this.PatternResults?.AsEnumerable();
if (patternResultsEnumerable?.Any() ?? false)
{
#region Disjoint Evaluation
//In case of disjointess between the query and the filter's pattern, all solutions are compatible
Boolean disjointSubject = this.Pattern.Subject is RDFVariable ?
!row.Table.Columns.Contains(this.Pattern.Subject.ToString()) : true;
Boolean disjointPredicate = this.Pattern.Predicate is RDFVariable ?
!row.Table.Columns.Contains(this.Pattern.Predicate.ToString()) : true;
Boolean disjointObject = this.Pattern.Object is RDFVariable ?
!row.Table.Columns.Contains(this.Pattern.Object.ToString()) : true;
if (disjointSubject && disjointPredicate && disjointObject)
{
keepRow = true;
}
#endregion
#region Non-Disjoint Evaluation
else
{
#region Subject
Boolean subjectCompared = false;
if (this.Pattern.Subject is RDFVariable &&
this.PatternResults.Columns.Contains(this.Pattern.Subject.ToString()) &&
row.Table.Columns.Contains(this.Pattern.Subject.ToString()))
{
//In case of emptiness the solution is compatible, otherwise proceed with comparison
if (!row.IsNull(this.Pattern.Subject.ToString()))
{
//Get subject filter's value for the given row
RDFPatternMember rowMember = RDFQueryUtilities.ParseRDFPatternMember(row[this.Pattern.Subject.ToString()].ToString());
//Apply subject filter on the pattern resultset
patternResultsEnumerable = patternResultsEnumerable.Where(x => RDFQueryUtilities.ParseRDFPatternMember(x.Field <String>(this.Pattern.Subject.ToString())).Equals(rowMember));
}
subjectCompared = true;
}
#endregion
#region Predicate
Boolean predicateCompared = false;
if (this.Pattern.Predicate is RDFVariable &&
this.PatternResults.Columns.Contains(this.Pattern.Predicate.ToString()) &&
row.Table.Columns.Contains(this.Pattern.Predicate.ToString()))
{
//In case of emptiness the solution is compatible, otherwise proceed with comparison
if (!row.IsNull(this.Pattern.Predicate.ToString()))
{
//Get predicate filter's value for the given row
RDFPatternMember rowMember = RDFQueryUtilities.ParseRDFPatternMember(row[this.Pattern.Predicate.ToString()].ToString());
//Apply predicate filter on the pattern resultset
patternResultsEnumerable = patternResultsEnumerable.Where(x => RDFQueryUtilities.ParseRDFPatternMember(x.Field <String>(this.Pattern.Predicate.ToString())).Equals(rowMember));
}
predicateCompared = true;
}
#endregion
#region Object
Boolean objectCompared = false;
if (this.Pattern.Object is RDFVariable &&
this.PatternResults.Columns.Contains(this.Pattern.Object.ToString()) &&
row.Table.Columns.Contains(this.Pattern.Object.ToString()))
{
//In case of emptiness the solution is compatible, otherwise proceed with comparison
if (!row.IsNull(this.Pattern.Object.ToString()))
{
//Get object filter's value for the given row
RDFPatternMember rowMember = RDFQueryUtilities.ParseRDFPatternMember(row[this.Pattern.Object.ToString()].ToString());
//Apply object filter on the pattern resultset
patternResultsEnumerable = patternResultsEnumerable.Where(x => RDFQueryUtilities.ParseRDFPatternMember(x.Field <String>(this.Pattern.Object.ToString())).Equals(rowMember));
}
objectCompared = true;
}
#endregion
#region Decision
//Verify filter's response on the pattern resultset
if ((subjectCompared || predicateCompared || objectCompared) && patternResultsEnumerable.ToList().Any())
{
keepRow = true;
}
#endregion
}
#endregion
}
//Apply the eventual negation
if (applyNegation)
{
keepRow = !keepRow;
}
return(keepRow);
}
