protected void Page_Load(object sender, EventArgs e)
{
AppKey = Globals.Settings.AppServiceSecureKey;
var controlTicketID = String.Empty;
var idListString = Request.QueryString["id"];
if (!String.IsNullOrEmpty(idListString))
{
var deliveryCost = 0.00;
List <string> idList = idListString.Split('-').ToList();
var sqlString = String.Empty;
foreach (var id in idList)
{
sqlString = sqlString + "T.ID = " + id + " OR ";
controlTicketID = id;
double cost;
if (double.TryParse(MoneyMethods.AgreedAssessedDeliveryCosts(id.ToString()), out cost))
{
deliveryCost += cost;
}
}
var fullSqlString = "SELECT * FROM `tickets` as T JOIN `city` as C on T.CityID = C.ID WHERE " + sqlString.Remove(sqlString.Length - 3) + "ORDER BY C.Name ASC";
var dm = new DataManager();
var dataset = dm.QueryWithReturnDataSet(fullSqlString);
lblGruzobozCost.Text = MoneyMethods.MoneySeparator(
dm.QueryWithReturnDataSet("SELECT SUM(T.`GruzobozCost`) FROM `tickets` as T JOIN `city` as C on T.CityID = C.ID WHERE " + sqlString.Remove(sqlString.Length - 3)).Tables[0].Rows[0][0].ToString());
lblDeliveryCost.Text = MoneyMethods.MoneySeparator(deliveryCost);
var i = 1;
dataset.Tables[0].Columns.Add("PNumber", typeof(String));
foreach (DataRow row in dataset.Tables[0].Rows)
{
row["PNumber"] = i++;
}
lvAllPrint.DataSource = dataset;
lvAllPrint.DataBind();
var ticket = new Tickets {
ID = Convert.ToInt32(controlTicketID)
};
ticket.GetById();
DriverName = lblDriver.Text = DriversHelper.DriverIDToFioToPrint(ticket.DriverID.ToString());
lblDriverPhone.Text = DriversHelper.DriverIDToPhone(ticket.DriverID.ToString());
lblTrack.Text = lblTrack2.Text = CityHelper.CityToTrack(Convert.ToInt32(ticket.CityID), ticket.ID.ToString());
lblOperatorName.Text = CityHelper.CityToTrackOperatorName(Convert.ToInt32(ticket.CityID));
lblOperatorPhone.Text = CityHelper.CityToTrackOperatorPhone(Convert.ToInt32(ticket.CityID));
}
lblDate.Text = DateTime.Now.AddDays(1).ToString("dd.MM.yyyy");
if (String.IsNullOrEmpty(idListString) || lvAllPrint.Items.Count == 0)
{
Page.Visible = false;
Response.Write(Resources.PrintResources.PrintMapEmptyText);
}
}
public static string OldNewValueToRuss(string tableName, string propertyName, string value)
{
#region таблица заявок
if (tableName == "tickets")
{
if (propertyName == "CourseRUR" ||
propertyName == "CourseUSD" ||
propertyName == "CourseEUR" ||
propertyName == "DeliveryCost" ||
propertyName == "AssessedCost" ||
propertyName == "AgreedCost" ||
propertyName == "ReceivedUSD" ||
propertyName == "ReceivedEUR" ||
propertyName == "ReceivedEUR" ||
propertyName == "ReceivedBLR" ||
propertyName == "GruzobozCost")
{
return(MoneyMethods.MoneySeparator(value));
}
if (propertyName == "DriverID")
{
return(DriversHelper.DriverIDToFioToPrint(value));
}
if (propertyName == "StatusIDOld" || propertyName == "StatusID")
{
return(OtherMethods.TicketStatusToText(value));
}
if (propertyName == "CityID")
{
return(CityHelper.CityIDToCityNameWithotCustom(value));
}
if (propertyName == "TrackIDUser")
{
return(OtherMethods.TrackToText(Convert.ToInt32(value)));
}
if (propertyName == "DeliveryDate")
{
return(value.Remove(value.Length - 8));
}
if (propertyName == "Comment")
{
return(WebUtility.HtmlDecode(value));
}
if (propertyName == "PrintNakl" ||
propertyName == "PrintNaklInMap" ||
propertyName == "IsExchange" ||
propertyName == "WithoutMoney" ||
propertyName == "CheckedOut" ||
propertyName == "Phoned")
{
return(value == "0" ? "нет" : "да");
}
if (propertyName == "OvDateFrom" || propertyName == "OvDateTo")
{
return(String.IsNullOrEmpty(value) ? String.Empty : Convert.ToDateTime(value).ToString("HH:mm"));
}
}
#endregion
#region таблица пользователей
if (tableName == "users")
{
if (propertyName == "SpecialClient" || propertyName == "IsCourse" || propertyName == "AllowApi")
{
return(value == "0" ? "нет" : "да");
}
if (propertyName == "Status")
{
return(UsersHelper.UserStatusToText(Convert.ToInt32(value)));
}
if (propertyName == "Role")
{
return(UsersHelper.RoleToRuss(value));
}
if (propertyName == "Discount")
{
return(String.Format("{0}%", value));
}
if (propertyName == "Password")
{
return(String.Empty);
}
if (propertyName == "Validity" && value.Length >= 8)
{
return(value.Remove(value.Length - 8));
}
if (propertyName == "BirthDay" && value.Length >= 8)
{
return(value.Remove(value.Length - 8));
}
if (propertyName == "DateOfIssue" && value.Length >= 8)
{
return(value.Remove(value.Length - 8));
}
}
#endregion
#region таблица грузов
if (tableName == "goods")
{
if (propertyName == "Cost")
{
return(MoneyMethods.MoneySeparator(value));
}
if (propertyName == "WithoutAkciza")
{
return(value == "0" ? "нет" : "да");
}
}
#endregion
#region таблица профилей
if (tableName == "usersprofiles")
{
if (propertyName == "StatusID")
{
return(UsersProfilesHelper.UserProfileStatusToText(Convert.ToInt32(value)));
}
}
#endregion
#region таблица водителй
if (tableName == "drivers")
{
if (propertyName == "StatusID" && !String.IsNullOrEmpty(value))
{
return(DriversHelper.DriverStatusToText(Convert.ToInt32(value)));
}
if (value.Length >= 8 && (propertyName == "DateOfIssue" ||
propertyName == "Validity" ||
propertyName == "BirthDay" ||
propertyName == "DriverPassportDateOfIssue" ||
propertyName == "DriverPassportValidity" ||
propertyName == "MedPolisDateOfIssue" ||
propertyName == "MedPolisValidity"))
{
return(value.Remove(value.Length - 8));
}
}
#endregion
#region таблица авто
if (tableName == "cars")
{
if (propertyName == "TypeID" && !String.IsNullOrEmpty(value))
{
return(CarsHelper.CarTypeToFullString(Convert.ToInt32(value)));
}
}
#endregion
#region таблица категорий
if (tableName == "category")
{
if (propertyName == "Name")
{
return(value);
}
}
#endregion
return(value);
}
protected void Page_Load(object sender, EventArgs e)
{
AppKey = Globals.Settings.AppServiceSecureKey;
var controlTicketID = String.Empty;
var idListString = Request.QueryString["id"];
if (!String.IsNullOrEmpty(idListString))
{
List <string> idList = idListString.Split('-').ToList();
var sqlString = String.Empty;
foreach (var id in idList)
{
sqlString = sqlString + "T.ID = " + id + " OR ";
controlTicketID = id;
}
bool withoutDriver = false;
var fullSqlString = "SELECT * FROM `tickets` as T JOIN `city` as C on T.CityID = C.ID WHERE " + sqlString.Remove(sqlString.Length - 3) + "ORDER BY C.Name ASC";
var dm = new DataManager();
var dataset = dm.QueryWithReturnDataSet(fullSqlString);
Iterator = 1;
dataset.Tables[0].Columns.Add("PNumber", typeof(String));
foreach (DataRow row in dataset.Tables[0].Rows)
{
row["PNumber"] = Iterator++;
var driverID = row["DriverID"].ToString();
if ((driverID == "0" || driverID == "-1") && withoutDriver == false)
{
withoutDriver = true;
}
}
lvAllPrint.DataSource = dataset;
lvAllPrint.DataBind();
var ticket = new Tickets {
ID = Convert.ToInt32(controlTicketID)
};
ticket.GetById();
if (withoutDriver == false)
{
DriverName = lblDriver.Text = DriversHelper.DriverIDToFioToPrint(ticket.DriverID.ToString());
}
else
{
DriverName = lblDriver.Text = String.Empty;
}
lblTrack.Text = lblTrack2.Text = CityHelper.CityToTrack(Convert.ToInt32(ticket.CityID), ticket.ID.ToString());
lblOperatorName.Text = CityHelper.CityToTrackOperatorName(Convert.ToInt32(ticket.CityID));
lblOperatorPhone.Text = CityHelper.CityToTrackOperatorPhone(Convert.ToInt32(ticket.CityID));
Inpdate.Text =
dm.QueryWithReturnDataSet("SELECT `MapDate` FROM `printdata`").Tables[0].Rows[0][0]
.ToString();
}
if (String.IsNullOrEmpty(idListString) || lvAllPrint.Items.Count == 0)
{
Page.Visible = false;
Response.Write(Resources.PrintResources.PrintMapEmptyText);
}
}
