protected void Page_Load(object sender, EventArgs e) { var idListString = Request.QueryString["id"]; if (!String.IsNullOrEmpty(idListString)) { List <string> idList = idListString.Split('-').ToList(); var sqlString = String.Empty; var userIP = OtherMethods.GetIPAddress(); var userInSession = (Users)Session["userinsession"]; var userInSessionID = userInSession.ID.ToString(); var pageName = "PrintCheck"; var transferListString = String.Empty; var ticketToSendSmsListString = String.Empty; foreach (var id in idList) { sqlString = sqlString + "ID = " + id + " OR "; var currentTicket = new Tickets { ID = Convert.ToInt32(id) }; currentTicket.GetById(); if (currentTicket.StatusID == 1) { #region Обновление статусов и переносы заявок var updateTicket = new Tickets { ID = Convert.ToInt32(id) }; var dateDelivery = Convert.ToDateTime(Convert.ToDateTime(currentTicket.DeliveryDate).ToString("dd-MM-yyyy")); var dateNow = Convert.ToDateTime(DateTime.Now.ToString("dd-MM-yyyy")); //если день доставки просрочен - выставляем перенос. //Если день доставки вручную выставлен менеджеров через редактирование заявки //и этот день не просрочен и не поддается графику доставки - перенос не сработает if (dateDelivery < dateNow) { var allCity = Application["CityList"] as List <City>; if (allCity == null) { lblError.Text = "Непредвиденная ошибка! (города)"; return; } var city = allCity.FirstOrDefault(u => u.ID == currentTicket.CityID); var allDistricts = Application["Districts"] as List <Districts>; if (allDistricts == null) { lblError.Text = "Непредвиденная ошибка! (районы)"; return; } if (city == null) { lblError.Text = "Непредвиденная ошибка! (город)"; return; } var district = allDistricts.FirstOrDefault(u => u.ID == city.DistrictID); var avaliableDays = new List <DayOfWeek>(); if (district == null) { lblError.Text = "Непредвиденная ошибка! (район)"; return; } if (district.Monday == 1) { avaliableDays.Add(DayOfWeek.Monday); } if (district.Tuesday == 1) { avaliableDays.Add(DayOfWeek.Tuesday); } if (district.Wednesday == 1) { avaliableDays.Add(DayOfWeek.Wednesday); } if (district.Thursday == 1) { avaliableDays.Add(DayOfWeek.Thursday); } if (district.Friday == 1) { avaliableDays.Add(DayOfWeek.Friday); } if (district.Saturday == 1) { avaliableDays.Add(DayOfWeek.Saturday); } if (district.Sunday == 1) { avaliableDays.Add(DayOfWeek.Sunday); } //день для переноса по умолчанию на сутки доальше чем сегодня. срабатывает, если для района не установлен день доставки var dayOfTransfer = Convert.ToDateTime(DateTime.Now.AddDays(1).ToString("dd-MM-yyyy")); for (int i = 1; i <= 7; i++) { var potencialDayOfTransfer = Convert.ToDateTime(DateTime.Now.AddDays(i).ToString("dd-MM-yyyy")); if (avaliableDays.Contains(potencialDayOfTransfer.DayOfWeek)) { dayOfTransfer = potencialDayOfTransfer; break; } } updateTicket.StatusID = 4; updateTicket.AdmissionDate = DateTime.Now; updateTicket.DeliveryDate = dayOfTransfer; transferListString += currentTicket.SecureID + ", "; //добавляем запись в flash:now ticketToSendSmsListString += currentTicket.ID + ";"; //добавляем запись для отправки СМС var user = new Users { ID = Convert.ToInt32(currentTicket.UserID) }; user.GetById(); #region Отправка емейла о том, что заявка переведена в статус перенос (на складе) и зануление водителя var email = BackendHelper.TagToValue("transfer_in_stock_event_email"); EmailMethods.MailSendHTML("Новый перевод заявки в статус 'Перенос (на складе)' (приемка)", String.Format("Новый перевод заявки в статус 'Перенос (на складе)' (во время приемки)<br/>" + "ID заявки: <b>{0}</b>", currentTicket.SecureID), email); updateTicket.DriverID = 0; #endregion #region Отправка емейлов отправителям if (!String.IsNullOrEmpty(user.Email)) { var address = currentTicket.RecipientStreet; if (currentTicket.RecipientKorpus != String.Empty && currentTicket.RecipientKorpus != " ") { address += "/" + currentTicket.RecipientKorpus; } if (currentTicket.RecipientKvartira != String.Empty && currentTicket.RecipientKvartira != " ") { address += " кв." + currentTicket.RecipientKvartira; } const string emailTitle = "Перенос заявки"; var emailBody = BackendHelper.TagToValue("email-on-print-checks-text"); emailBody = emailBody .Replace("{full-name}", OtherMethods.GoodsStringFromTicketID(currentTicket.ID.ToString())) .Replace("{address}", city.Name + " " + address) .Replace("{id}", currentTicket.SecureID) .Replace("{recipient-phones}", currentTicket.RecipientPhone + "; " + currentTicket.RecipientPhoneTwo); EmailMethods.MailSendHTML(emailTitle, emailBody, user.Email); } #endregion } else { ticketToSendSmsListString += currentTicket.ID + ";";//добавляем запись для отправки СМС updateTicket.StatusID = 2; updateTicket.AdmissionDate = DateTime.Now; } updateTicket.Update(Convert.ToInt32(userInSessionID), userIP, pageName); #endregion } } var fullSqlString = "SELECT * FROM `tickets` WHERE " + sqlString.Remove(sqlString.Length - 3); var dm = new DataManager(); var dataset = dm.QueryWithReturnDataSet(fullSqlString); lvAllPrint.DataSource = dataset; lvAllPrint.DataBind(); #region Данные для flash:now с перенесенными заявками if (transferListString.Length > 2) { Session["flash:now"] = "<span style='color: red;'>Перенесенные заявки: " + transferListString.Remove(transferListString.Length - 2, 2) + "</span>"; } #endregion #region Отправляем СМС if (ticketToSendSmsListString.Length > 2 && BackendHelper.TagToValue("sms-on-print-checks-enable") == "true") { SmsSender.SendSmsBulkIfTicketOnStock(ticketToSendSmsListString.Remove(ticketToSendSmsListString.Length - 1, 1)); } #endregion } if (String.IsNullOrEmpty(idListString) || lvAllPrint.Items.Count == 0) { Page.Visible = false; Response.Write(Resources.PrintResources.PrintCheckEmptyText); } }
protected void Page_Load(object sender, EventArgs e) { Page.Title = PagesTitles.ManagerUserTicketEditTitle + BackendHelper.TagToValue("page_title_part"); OtherMethods.ActiveRightMenuStyleChanche("hlTickets", this.Page); Form.DefaultButton = btnCreate.UniqueID; AppKey = Globals.Settings.AppServiceSecureKey; FirstUserApiKey = Globals.Settings.FirstUserApiKey; #region Блок доступа к странице var userInSession = (Users)Session["userinsession"]; var rolesList = Application["RolesList"] as List <Roles>; var currentRole = Role = (Roles)rolesList.SingleOrDefault(u => u.Name.ToLower() == userInSession.Role.ToLower()); if (currentRole.PageUserTicketEdit != 1) { Response.Redirect("~/Error.aspx?id=1"); } #endregion #region Блок доступа к данным на странице IsVisibleUserProfileData = true; IsVisibleUserAccountData = true; if (currentRole.PageUserProfileView == 0) { IsVisibleUserProfileData = false; } if (currentRole.PageClientsView == 0) { IsVisibleUserAccountData = false; } trUserProfileData.Visible = IsVisibleUserProfileData; trUserAccountData.Visible = IsVisibleUserAccountData; #endregion #region едирект на страницу всех заявок если заявки нет if (Page.Request.Params["id"] == null || Page.Request.Params["id"] == String.Empty) { Page.Response.Redirect("~/ManagerUI/Menu/Tickets/UserTicketView.aspx"); } #endregion if (!IsPostBack) { #region Загрузка tickets по SecureID или FullSecureID. Метод на очистку. DAL.DataBaseObjects.Tickets ticket; if (Page.Request.Params["id"].Length > 7) { ticket = new DAL.DataBaseObjects.Tickets { FullSecureID = Page.Request.Params["id"] }; ticket.GetByFullSecureId(); } else { ticket = new DAL.DataBaseObjects.Tickets { SecureID = Page.Request.Params["id"] }; ticket.GetBySecureId(); } #endregion #region Создание форм для груза GoodsCount = GoodsHelper.GoodsCount(ticket.FullSecureID); hfHowManyControls.Value = GoodsCount.ToString(); AddGodsInPanel(GoodsCount); #endregion #region Заполнение созданных формы var goods = new Goods { TicketFullSecureID = ticket.FullSecureID }; var ds = goods.GetAllItems("ID", "ASC", "TicketFullSecureID"); var goodsIterator = 1; foreach (DataRow row in ds.Tables[0].Rows) { var tbGoodsDescription = (TextBox)pnlBooks.FindControl("tbGoodsDescription" + goodsIterator); var tbGoodsModel = (TextBox)pnlBooks.FindControl("tbGoodsModel" + goodsIterator); var tbGoodsNumber = (TextBox)pnlBooks.FindControl("tbGoodsNumber" + goodsIterator); var tbGoodsCost = (TextBox)pnlBooks.FindControl("tbGoodsCost" + goodsIterator); var hfGoodsID = (HiddenField)pnlBooks.FindControl("hfGoodsID" + goodsIterator); var hfWithoutAkciza = (HiddenField)pnlBooks.FindControl("hfWithoutAkciza" + goodsIterator); var hfGoodsNumber = (HiddenField)pnlBooks.FindControl("hfGoodsNumber" + goodsIterator); var hfGoodsCost = (HiddenField)pnlBooks.FindControl("hfGoodsCost" + goodsIterator); var hfGoodsDescription = (HiddenField)pnlBooks.FindControl("hfGoodsDescription" + goodsIterator); var hfGoodsModel = (HiddenField)pnlBooks.FindControl("hfGoodsModel" + goodsIterator); tbGoodsDescription.Text = hfGoodsDescription.Value = row["Description"].ToString(); tbGoodsModel.Text = hfGoodsModel.Value = row["Model"].ToString(); tbGoodsNumber.Text = hfGoodsNumber.Value = row["Number"].ToString(); tbGoodsCost.Text = hfGoodsCost.Value = MoneyMethods.MoneySeparator(row["Cost"].ToString()); hfGoodsID.Value = row["ID"].ToString(); hfWithoutAkciza.Value = row["WithoutAkciza"].ToString(); goodsIterator++; } #endregion #region Вывод старых грузов. Метод на очистку. if (GoodsCount == 0) { lblOldGoods.Visible = true; lblOldGoods.Text = "<b>" + OtherMethods.GoodsStringFromTicketID(ticket.ID.ToString()) + "</b><br/>"; } #endregion #region Инициализация сущностей var user = new Users(); user.ID = Convert.ToInt32(ticket.UserID); user.GetById(); #region Блок конфигурации удаления заявки if (currentRole.ActionUserTicketDelete != 1) { btnDelete.Visible = false; } #endregion var profile = new UsersProfiles(); profile.ID = Convert.ToInt32(ticket.UserProfileID); profile.GetById(); #endregion #region блок общей информации SpecialClient = user.SpecialClient; hfID.Value = ticket.ID.ToString(); hfDriverID.Value = ticket.DriverID.ToString(); hfStatusID.Value = ticket.StatusID.ToString(); hfStatusIDOld.Value = ticket.StatusIDOld.ToString(); hfStatusDescription.Value = ticket.StatusDescription; hfAdmissionDate.Value = ticket.AdmissionDate.ToString(); hfUserID.Value = UserID = ticket.UserID.ToString(); hfUserDiscount.Value = user.Discount.ToString(); hfUserProfileType.Value = profile.TypeID.ToString(); hfFullSecureID.Value = ticket.FullSecureID; lblID.Text = ticket.SecureID; hlUser.Text = user.Family + ' ' + user.Name; hlUser.NavigateUrl = "~/ManagerUI/Menu/Souls/ClientEdit.aspx?id=" + ticket.UserID; hlProfile.Text = profile.TypeID == 1 ? (profile.FirstName + ' ' + profile.LastName) : profile.CompanyName; hlProfile.NavigateUrl = "~/ManagerUI/Menu/Souls/ProfileView.aspx?id=" + ticket.UserProfileID; lblProfileType.Text = UsersProfilesHelper.UserProfileTypeToText(Convert.ToInt32(profile.TypeID)); lblCreateDate.Text = OtherMethods.DateConvert(ticket.CreateDate.ToString()); lblAdmissionDate.Text = OtherMethods.DateConvert(ticket.AdmissionDate.ToString()); lblDeliveryDateStatic.Text = OtherMethods.DateConvert(ticket.DeliveryDate.ToString()); lblIsExchange.Text = ticket.IsExchange == 0 ? "нет" : "да"; cbWithoutMoney.Checked = ticket.WithoutMoney != 0; lblNN.Text = ticket.PrintNaklInMap == 0 ? "нет" : "да"; lblPN.Text = ticket.PrintNakl == 0 ? "нет" : "да"; if (String.IsNullOrEmpty(ticket.Comment)) { tdComment.Visible = false; } else { lblComment.Text = WebUtility.HtmlDecode(ticket.Comment); } var regionText = CityHelper.CityToTrack(Convert.ToInt32(ticket.CityID), ticket.ID.ToString()); if (ticket.TrackIDUser != 0 || regionText == "Не задано") { ddlUserTrack.Visible = true; lblTrack.Visible = false; var region = new Tracks(); ddlUserTrack.DataSource = region.GetAllItems(); ddlUserTrack.DataTextField = "Name"; ddlUserTrack.DataValueField = "ID"; ddlUserTrack.DataBind(); ddlUserTrack.Items.Insert(0, new ListItem("Не задано", "0")); ddlUserTrack.SelectedValue = Convert.ToString(ticket.TrackIDUser); } else { lblTrack.Text = regionText; } if (string.IsNullOrEmpty(lblAdmissionDate.Text)) { lblAdmissionDate.Text = "Груз пока не на складе"; } #endregion #region блок информации, заполняемой пользователем AssessedCost = MoneyMethods.MoneySeparator(ticket.AssessedCost.ToString()); hfAssessedCost.Value = ticket.AssessedCost.ToString(); lblAssessedCost.Text = MoneyMethods.MoneySeparator(ticket.AssessedCost.ToString()); tbDeliveryCost.Text = MoneyMethods.MoneySeparator(ticket.DeliveryCost.ToString()); ddlRecipientStreetPrefix.SelectedValue = ticket.RecipientStreetPrefix; tbRecipientStreet.Text = ticket.RecipientStreet; tbRecipientStreetNumber.Text = ticket.RecipientStreetNumber; tbRecipientKorpus.Text = ticket.RecipientKorpus; tbRecipientKvartira.Text = ticket.RecipientKvartira; tbRecipientPhone.Text = ticket.RecipientPhone; tbRecipientPhone2.Text = ticket.RecipientPhoneTwo; ddlSenderStreetPrefix.SelectedValue = ticket.SenderStreetPrefix; tbSenderStreetName.Text = ticket.SenderStreetName; tbSenderStreetNumber.Text = ticket.SenderStreetNumber; tbSenderHousing.Text = ticket.SenderHousing; tbSenderApartmentNumber.Text = ticket.SenderApartmentNumber; tbNote.Text = ticket.Note; tbBoxesNumber.Text = string.IsNullOrEmpty(ticket.BoxesNumber.ToString()) ? "1" : ticket.BoxesNumber.ToString(); tbDeliveryDate.Text = Convert.ToDateTime(ticket.DeliveryDate).ToString("dd-MM-yyyy"); tbRecipientFirstName.Text = ticket.RecipientFirstName; tbRecipientLastName.Text = ticket.RecipientLastName; tbRecipientThirdName.Text = ticket.RecipientThirdName; tbTtnSeria.Text = ticket.TtnSeria; tbTtnNumber.Text = ticket.TtnNumber; tbOtherDocuments.Text = ticket.OtherDocuments; tbPassportNumber.Text = ticket.PassportNumber; tbPassportSeria.Text = ticket.PassportSeria; if (!String.IsNullOrEmpty(ticket.DeliveryCost.ToString()) && ticket.DeliveryCost != 0) { cbIsDeliveryCost.Checked = true; } //автокомплит наименования var titles = new Titles(); var availableTitles = titles.GetAllItems("Name", "ASC", null).Tables[0].Rows.Cast <DataRow>().Aggregate(String.Empty, (current, items) => current + ("\"" + items["Name"] + "\",")); AvailableTitles = availableTitles.Remove(availableTitles.Length - 1); #endregion #region Заполнение города var allCity = Application["CityList"] as List <City>; if (allCity != null) { tbCity.Text = CityHelper.CityIDToAutocompleteString(allCity.FirstOrDefault(u => u.ID == ticket.CityID)); hfCityID.Value = ticket.CityID.ToString(); var senderCity = allCity.First(u => u.ID == ticket.SenderCityID); tbSenderCity.Text = CityHelper.CityIDToAutocompleteString(senderCity); hfSenderCityID.Value = ticket.SenderCityID.ToString(); } #endregion hfWharehouse.Value = ticket.WharehouseId.ToString(); #region блок информации, заполняемой менеджером ddlStatus.DataSource = DAL.DataBaseObjects.Tickets.TicketStatuses; ddlStatus.DataTextField = "Value"; ddlStatus.DataValueField = "Key"; ddlStatus.DataBind(); ddlStatus.SelectedValue = Convert.ToString(ticket.StatusID); var ddrivers = new Drivers { StatusID = 1 }; var dataSet5 = ddrivers.GetAllActivatedDrivers(); dataSet5.Tables[0].Columns.Add("FIOAndID", typeof(string), "'(' + ID + ') ' + FirstName + ' ' + SUBSTRING(LastName,1,1) + '.' + SUBSTRING(ThirdName,1,1) + '.'"); ddlDrivers.DataSource = dataSet5; ddlDrivers.DataTextField = "FIOAndID"; ddlDrivers.DataValueField = "ID"; ddlDrivers.DataBind(); ddlDrivers.Items.Insert(0, new ListItem("Водитель не назначен", "0")); tbAgreedCost.Text = MoneyMethods.MoneySeparator(ticket.AgreedCost.ToString()); tbGruzobozCost.Text = MoneyMethods.MoneySeparator(ticket.GruzobozCost.ToString()); #region Блок блокировки полей if (currentRole.ActionControlGruzobozCost != 1) { tbGruzobozCost.Enabled = false; } if (currentRole.ActionStatusAdd != 1) { ddlStatus.Enabled = false; tbDeliveryDate.Enabled = false; tbStatusDescription.Enabled = false; } if (currentRole.ActionDriverAdd != 1) { ddlDrivers.Enabled = false; } if (currentRole.ActionAllowChangeMoneyAndCourse != 1) { tbAgreedCost.Enabled = false; tbGruzobozCost.Enabled = false; } #endregion //если id водителя 0 или -1 - водитель не назначен if (ticket.DriverID != 0 && ticket.DriverID != -1) { ddlDrivers.SelectedValue = ticket.DriverID.ToString(); } else { ddlDrivers.SelectedValue = "0"; } //если статусы На складе (перенесен), Отказ (у курьера), Возврат (на складе), Отмена (на складе), Отмена то показываем почему if (ddlStatus.SelectedValue == "7" || ddlStatus.SelectedValue == "8" || ddlStatus.SelectedValue == "4" || ddlStatus.SelectedValue == "9" || ddlStatus.SelectedValue == "10") { lblStatusDescription.Visible = true; tbStatusDescription.Visible = true; tbStatusDescription.Text = ticket.StatusDescription; } #endregion #region Ограничения на правку текстбоксов //если админ или статусы "Не обработана" или "На складе" или "На складе (перенесено)", или "Отмена" или "Отмена (на складе)" - можно изменять все поля пользователя if (currentRole.ActionDisallowEditSomeFieldInTickets != 1 && (ddlStatus.SelectedValue == "1" || ddlStatus.SelectedValue == "2" || ddlStatus.SelectedValue == "4" || ddlStatus.SelectedValue == "9" || ddlStatus.SelectedValue == "10") && currentRole.ActionDisallowTicketChangeWithoutManagerInfo != 1) { tbCity.Enabled = tbRecipientStreetNumber.Enabled = tbRecipientKorpus.Enabled = tbRecipientFirstName.Enabled = tbRecipientLastName.Enabled = tbRecipientThirdName.Enabled = tbRecipientKvartira.Enabled = tbRecipientPhone.Enabled = tbBoxesNumber.Enabled = tbDeliveryDate.Enabled = tbOtherDocuments.Enabled = tbTtnNumber.Enabled = tbTtnSeria.Enabled = tbPassportNumber.Enabled = tbPassportSeria.Enabled = tbRecipientPhone2.Enabled = tbRecipientStreet.Enabled = tbNote.Enabled = true; for (var i = 1; i <= GoodsCount; i++) { var tbGoodsDescription = (TextBox)pnlBooks.FindControl("tbGoodsDescription" + i); var tbGoodsModel = (TextBox)pnlBooks.FindControl("tbGoodsModel" + i); var tbGoodsNumber = (TextBox)pnlBooks.FindControl("tbGoodsNumber" + i); tbGoodsDescription.Enabled = true; tbGoodsModel.Enabled = true; tbGoodsNumber.Enabled = true; } } if (currentRole.ActionDisallowTicketChangeWithoutManagerInfo == 1) { ddlUserTrack.Enabled = false; tbRecipientFirstName.Enabled = false; tbRecipientLastName.Enabled = false; tbRecipientThirdName.Enabled = false; } //только админ может изменять курсы if (currentRole.ActionAllowChangeMoneyAndCourse == 1 && currentRole.ActionDisallowTicketChangeWithoutManagerInfo != 1) { cbIsDeliveryCost.Enabled = tbDeliveryCost.Enabled = true; for (var i = 1; i <= GoodsCount; i++) { var tbGoodsCost = (TextBox)pnlBooks.FindControl("tbGoodsCost" + i); tbGoodsCost.Enabled = true; } } #endregion } if (!String.IsNullOrEmpty(hfCityID.Value)) { var coefficientDeviationCost = Convert.ToDouble(BackendHelper.TagToValue("coefficient_deviation_cost")); var city = new City { ID = Convert.ToInt32(hfCityID.Value) }; city.GetById(); var district = new Districts { ID = Convert.ToInt32(city.DistrictID) }; district.GetById(); lblCityCost.Text = MoneyMethods.MoneySeparatorForCityTableView((city.DistanceFromCity * Convert.ToDecimal(coefficientDeviationCost)).ToString()); lblCityDeliveryDate.Text = DistrictsHelper.DeliveryDateStringToRuss(DistrictsHelper.DeliveryDateString(city.DistrictID)); lblCityDeliveryTerms.Text = DistrictsHelper.DeliveryTermsToRuss(DistrictsHelper.DeliveryTerms(city.DistrictID)); } }