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); }