public override int GetHashCode()
{
int hash = 1;
if (OrderNo.Length != 0)
{
hash ^= OrderNo.GetHashCode();
}
if (Amonut != 0D)
{
hash ^= pbc::ProtobufEqualityComparers.BitwiseDoubleEqualityComparer.GetHashCode(Amonut);
}
if (OrderType != 0)
{
hash ^= OrderType.GetHashCode();
}
if (Buyer.Length != 0)
{
hash ^= Buyer.GetHashCode();
}
if (CreateTime != 0L)
{
hash ^= CreateTime.GetHashCode();
}
hash ^= items_.GetHashCode();
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public override int GetHashCode()
{
unchecked
{
return(((OrderNo != null ? OrderNo.GetHashCode() : 0) * 397) ^ (Name != null ? Name.GetHashCode() : 0));
}
}
public PurchaseOrder(OrderNo orderNo, Supplier supplier)
{
OrderNo = orderNo ?? throw new ArgumentNullException(nameof(orderNo));
Supplier = supplier ?? throw new ArgumentNullException(nameof(supplier));
Status = new PurchaseOrderStatus();
}
public virtual int _GetUniqueIdentifier()
{
var hashCode = 399326290;
hashCode = hashCode * -1521134295 + (Id?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (BookingDate?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (OrderNo?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (NoIdentity?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (FromExtTime?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (ToExtTime?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (BookStatus?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (NoPlatform?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (NoCourier?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Warehouse?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Driver?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (DriverTelephone?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Plate?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Trailerplate?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (PalletIN?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (TotalPallet?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (DateArrived?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (TimeArrived?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (DateExit?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (TImeExit?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (RouteTracking_ID?.GetHashCode() ?? 0);
return(hashCode);
}
public void Always_AssignsValues()
{
var orderNoValue = "orderNo";
var orderNo = new OrderNo(orderNoValue);
Assert.That(orderNo.Value, Is.EqualTo(orderNoValue));
}
public EditCommand(int purchaseOrderId, int supplierId, OrderNo orderNo, int?shipmentId)
{
PurchaseOrderId = purchaseOrderId;
SupplierId = supplierId;
OrderNo = orderNo ?? throw new ArgumentNullException(nameof(orderNo));
ShipmentId = shipmentId;
}
public Result(int purchaseOrderId, OrderNo purchaseOrderOrderNo,
IEnumerable <PurchaseOrderLine> lineItems, Dictionary <int, ProductName> productOptions)
{
PurchaseOrderId = purchaseOrderId;
PurchaseOrderOrderNo = purchaseOrderOrderNo;
LineItems = lineItems;
ProductOptions = productOptions;
}
public JsonResult InsertHdrPurchaseReq(string purReqHdr, string ObjKy)
{
int cky = HTNSession.CKy;
int usrKy = HTNSession.UsrKy;
OrderNo OrdKy = apiOpr.InsertHdrPurchaseReq(HTNSession.Environment, cky, usrKy, Convert.ToInt32(ObjKy), purReqHdr);
HTNCache.ClearCacheItems("OdrCode", "CKy-" + cky.ToString());
return(Json(OrdKy, JsonRequestBehavior.AllowGet));
}
public override int GetHashCode()
{
if (OrderNo != null)
{
return(OrderNo.GetHashCode() ^ ItemCode.GetHashCode());
}
else
{
return(base.GetHashCode());
}
}
public override int GetHashCode()
{
if (OrderNo != null)
{
return OrderNo.GetHashCode();
}
else
{
return base.GetHashCode();
}
}
private void Cancel_Click(object sender, RoutedEventArgs e)
{
CustName.Clear();
InvoiceNo.Clear();
OrderNo.Clear();
InvoiceDate.Clear();
DueDate.Clear();
SubTotal.Clear();
Adjustment.Clear();
Total.Clear();
CustNotes.Clear();
TermAndCondns.Clear();
}
public OrderNo InsertHdrPurchaseReq(string EnvironmentName, int CKy, int UsrKy, int ObjKy, string purReqHdr)
{
string actionUri = "InsertHdrPurchaseReq";
Dictionary <string, object> paramDictionary = new Dictionary <string, object>();
paramDictionary.Add("CKy", CKy);
paramDictionary.Add("UsrKy", UsrKy);
paramDictionary.Add("ObjKy", ObjKy);
paramDictionary.Add("purReqHdr", purReqHdr);
OrderNo List = new OrderNo();
List = RunApiOperation(
OrderBaseUri,
actionUri,
EnvironmentName,
paramDictionary,
List.GetType()) as OrderNo;
return(List);
}
public override int GetHashCode()
{
unchecked
{
const int HashingBase = (int)2166136261;
const int HashingMultiplier = 16777619;
int hash = HashingBase;
hash = (hash * HashingMultiplier) ^ OrderNo.GetHashCode();
hash = (hash * HashingMultiplier) ^ ((DateFrom != null) ? DateFrom.GetHashCode() : 0);
hash = (hash * HashingMultiplier) ^ ((DateTo != null) ? DateTo.GetHashCode() : 0);
hash = (hash * HashingMultiplier) ^ CustomerName.GetHashCode();
hash = (hash * HashingMultiplier) ^ VehicleType.GetHashCode();
hash = (hash * HashingMultiplier) ^ Address.GetHashCode();
hash = (hash * HashingMultiplier) ^ ProjectNo.GetHashCode();
hash = (hash * HashingMultiplier) ^ Imei.GetHashCode();
hash = (hash * HashingMultiplier) ^ TrackerName.GetHashCode();
hash = (hash * HashingMultiplier) ^ AddressLatitude.GetHashCode();
hash = (hash * HashingMultiplier) ^ AddressLongitude.GetHashCode();
return(hash);
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
int OrderNo;
var data = PurOrBLL.GetPurOrderNo();
if (data.Count <= 0)
{
OrderNo = 1;
}
else
{
OrderNo = Convert.ToInt32(data.FirstOrDefault().PurOrderNO.ToString()) + 1;
}
foreach (GridViewRow row in GVPur.Rows)
{
// PurOrDTO.BrProId = Convert.ToInt32(row.Cells[10].Text);
PurOrDTO.Priority = row.Cells[6].Text;
PurOrDTO.ProductId = Convert.ToInt32(row.Cells[3].Text);
PurOrDTO.PurOrderBy = HttpContext.Current.User.Identity.Name;
PurOrDTO.PurOrderDate = System.DateTime.Now;
PurOrDTO.PurOrderStatus = "0";
PurOrDTO.Quantity = Convert.ToInt32(row.Cells[7].Text);
if (row.Cells[8].Text != " ")
{
PurOrDTO.UnitPrice = Convert.ToDouble(row.Cells[8].Text);
}
else
{
PurOrDTO.UnitPrice = 0;
}
PurOrDTO.PurOrderNO = OrderNo;
PurOrBLL.Add(PurOrDTO);
//var puroder = PurOrBLL.GetPurOrderNo();
// int purorderno = puroder.First().PurOrderNO;
if (row.Cells[9].Text != " ")
{
ReqDTO.CenPurReqId = Convert.ToInt32(row.Cells[9].Text);
ReqDTO.PurReqStatus = "1";
ReqBLL.Edit_PurRequsitionStatus(ReqDTO);
}
}
Show(" Data Save Succesfully");
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('/Manager/Report/CentralPurchaseOrderRptUI.aspx?PurOrderNO=" + OrderNo.ToString() + "');", true);
PurCancel();
}
/// <summary>
/// 查询运单信息
/// </summary>
/// <param name="para"></param>
public virtual void Search(SplashScreenManager splash)
{
splash.ShowWaitForm();
#region 拼接sql语句的where条件
string sqlWhere = $" tb_SFI_TrackNum.int_AGid={SelectedAgent.AGid}";
if (!string.IsNullOrWhiteSpace(OrderNo))
{
if (OrderNo.IndexOf(",") > 0)
{
sqlWhere = $"{sqlWhere} AND tb_SFI_TrackNum.vchar_SFInum in (";
string[] strs = OrderNo.Split(',');
foreach (string str in strs)
{
sqlWhere = $"{sqlWhere}'{str}',";
}
sqlWhere = $"{sqlWhere.TrimEnd(',')})";
}
else
{
sqlWhere = $"{sqlWhere} AND tb_SFI_TrackNum.vchar_SFInum='{OrderNo}'";
}
}
if (!string.IsNullOrWhiteSpace(AgentNo))
{
if (AgentNo.IndexOf(",") > 0)
{
sqlWhere = $"{sqlWhere} AND tb_SFI_TrackNum.vchar_AGnum in (";
string[] strs = AgentNo.Split(',');
foreach (string str in strs)
{
sqlWhere = $"{sqlWhere}'{str}',";
}
sqlWhere = $"{sqlWhere.TrimEnd(',')})";
}
else
{
sqlWhere = $"{sqlWhere} AND tb_SFI_TrackNum.vchar_AGnum='{OrderNo}'";
}
}
sqlWhere = $"{sqlWhere} AND CONVERT(varchar(10),tb_SFI_TrackNum.dttm_updateDttm,112) ='{ImportDate.ToString("yyyyMMdd")}'";
//string sqlSelect = $"SELECT tb_SFI_TrackNum.int_Mappingid AS 数据编号, tb_SFI_TrackNum.vchar_SFInum AS SFI单号,tb_SFI_TrackNum.vchar_AGnum AS 代理单号, (CONVERT(varchar(10),tb_SFI_TrackNum.int_AGid) + N'-' + tb_Agent.vchar_AGname) AS 代理名称, tb_SFI_TrackNum.dttm_updateDttm AS 数据导入时间, tb_SFI_TrackNum.dttm_AG_LastSyn AS 最后同步时间, tb_SFI_TrackNum.char_IsStop AS 运输服务完毕 FROM tb_SFI_TrackNum INNER JOIN tb_Agent ON tb_SFI_TrackNum.int_AGid = tb_Agent.int_AGid WHERE {sqlWhere} ORDER BY tb_SFI_TrackNum.dttm_updateDttm DESC";
string sqlSelect = $"SELECT tb_SFI_TrackNum.int_Mappingid, tb_SFI_TrackNum.vchar_SFInum,tb_SFI_TrackNum.vchar_AGnum , (CONVERT(varchar(10),tb_SFI_TrackNum.int_AGid) + N'-' + tb_Agent.vchar_AGname), tb_SFI_TrackNum.dttm_updateDttm, tb_SFI_TrackNum.dttm_AG_LastSyn, tb_SFI_TrackNum.char_IsStop FROM tb_SFI_TrackNum INNER JOIN tb_Agent ON tb_SFI_TrackNum.int_AGid = tb_Agent.int_AGid WHERE {sqlWhere} ORDER BY tb_SFI_TrackNum.dttm_updateDttm DESC";
//DataSet ds = SQLHelper.GetDataSet(sqlSelect);
//if (ds != null && ds.Tables.Count == 1)
//{
// //para.Grid.BeginUpdate();
// //para.Grid.DataSource = ds.Tables[0].DefaultView;
// //para.Grid.EndUpdate();
//}
var tracks = (SQLHelper.GetObject <SFITrackNum>(sqlSelect)).ToList();
trackNumInfos.Clear();
if (tracks.Count > 0)
{
foreach (SFITrackNum track in tracks)
{
trackNumInfos.Add(track);
}
}
else
{
trackNumInfos.Clear();
}
splash.CloseWaitForm();
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
OrderNo = HotelCloud.Common.HCRequest.GetString("OrderNo").ToUpper().Trim();
if (!string.IsNullOrEmpty(OrderNo))
{
if (OrderNo.Contains("C"))
{
var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 * from WeiXin..RechargeUser where OrderNo=@OrderNo", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
{ "OrderNo", new HotelCloud.SqlServer.DBParam {
ParamValue = OrderNo
} }
});
if (dt.Rows.Count > 0)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
int OrderAmount = Convert.ToInt32(Convert.ToDecimal(dr["SPrice"].ToString()) * 1);
OrderRoom = "充值扣款";
total_fee = OrderAmount.ToString();
}
}
}
else if (OrderNo.Contains("K"))
{
var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 * from WeiXin..MemberCardBuyRecord where OrderNo=@OrderNo", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
{ "OrderNo", new HotelCloud.SqlServer.DBParam {
ParamValue = OrderNo
} }
});
if (dt.Rows.Count > 0)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
int OrderAmount = Convert.ToInt32(Convert.ToDecimal(dr["BuyMoney"].ToString()) * 1);
OrderRoom = "会员卡购买";
total_fee = OrderAmount.ToString();
}
}
}
else if (OrderNo.Contains("D"))
{
var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 * from WeiXin..SupermarketOrder_Levi where OrderId=@OrderId", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
{ "OrderId", new HotelCloud.SqlServer.DBParam {
ParamValue = OrderNo.Trim()
} }
});
if (dt.Rows.Count > 0)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
int OrderAmount = Convert.ToInt32(Convert.ToDecimal(dr["Money"].ToString()) * 1);
OrderRoom = "酒店周边超市消费";
total_fee = OrderAmount.ToString();
}
}
}
else if (OrderNo.Contains("P"))
{
var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 * from WeiXin..SaleProducts_Orders where OrderNo=@OrderNo", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
{ "OrderNo", new HotelCloud.SqlServer.DBParam {
ParamValue = OrderNo
} }
});
if (dt.Rows.Count > 0)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
int OrderAmount = Convert.ToInt32(Convert.ToDecimal(dr["OrderMoney"].ToString()) * 1);
OrderRoom = dr["ProductName"].ToString().Trim() + "[" + dr["TcName"].ToString().Trim() + "]";
total_fee = OrderAmount.ToString();
}
}
}
else if (OrderNo.Contains("L"))
{
var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 bagging,amount,youhuiamount,hotelid,userweixinid,hotelWeixinId,orderCode,(select sum(AliPayAmount) from WeiXin..wkn_payrecords where OrderNO=orderCode and Channel='微信支付回调') as zhifu from WeiXin..T_OrderInfo where orderCode=@orderCode", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
{ "orderCode", new HotelCloud.SqlServer.DBParam {
ParamValue = OrderNo.Trim()
} }
});
if (dt.Rows.Count > 0)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
string bagging = dr["bagging"].ToString();
string youhuiamount = dr["youhuiamount"].ToString();
if (string.IsNullOrEmpty(bagging))
{
bagging = "0";
}
if (string.IsNullOrEmpty(youhuiamount))
{
youhuiamount = "0";
}
int OrderAmount = Convert.ToInt32((Convert.ToDecimal(dr["amount"].ToString()) - Convert.ToDecimal(youhuiamount) + Convert.ToDecimal(bagging)) * 1);
OrderRoom = "酒店周边餐饮消费";
total_fee = OrderAmount.ToString();
}
}
}
else
{
hotel3g.Repository.Order order = hotel3g.Repository.OrderRepository.GetOrderInfo(OrderNo.Trim());
OrderRoom = order.RoomName + "[" + order.RatePlanName + "]";
total_fee = order.OrderAmount.ToString();
url = string.Format("http://hotel.weikeniu.com/Hotel/Index/{0}?key={1}@{2}", order.HotelID.ToString(), order.WeiXinID.ToString(), order.UserWeiXinID.ToString());
}
}
if (HotelCloud.Common.HCRequest.GetString("action") == "code")
{
WxPayAPI.NativePay np = new WxPayAPI.NativePay();
/** ================得到长连接========= */
string long_url = np.GetPrePayUrl(HotelCloud.Common.HCRequest.GetString("OrderNo"));
WxPayAPI.WxPayData data = new WxPayAPI.WxPayData();
data.SetValue("long_url", long_url);
/** ================减小二维码数据量，提升扫描速度和精确度========= */
WxPayAPI.WxPayData Result = WxPayAPI.WxPayApi.ShortUrl(data, 6);
if (Result != null)
{
if (Result.GetValue("return_code").ToString() == "SUCCESS")
{
string ShortUrl = Result.GetValue("short_url").ToString();
WxPayAPI.Log.Debug("WxPayApi", "ShortUrl : " + long_url);
Response.Write(CreateCode_Choose(ShortUrl, "Byte", "M", 8, 4));
}
}
Response.End();
}
}
}
Int32 DisplayOrders(string CustomerNameFilter)
{
Int32 OrderNo; //var to store the primary key
String CustomerName; //var to store the Device Name
String ItemName; //var to store the Device Name
Int32 Invoice; //var to store the primary key
; //create an instance of the phone class
clsOrderCollection Order = new clsOrderCollection();
Order.ReportByCustomerName(CustomerNameFilter);
Int32 RecordCount; //var to store the count of records
Int32 Index = 0; //var to store the index for the loop
RecordCount = Order.Count; // get the count of records
lstOrders.Items.Clear(); //clear the list box
while (Index < RecordCount) //while there are records to process
{
OrderNo = Order.OrderList[Index].OrderNo; //get the primary key
CustomerName = Order.OrderList[Index].CustomerName; //get the Device Name
ItemName = Order.OrderList[Index].ItemName; //get the Operating System
Invoice = Order.OrderList[Index].Invoice; //get the Price
//create a new entry for the list box
ListItem NewEntry = new ListItem(CustomerName + ", " + ItemName + ", " + Invoice, OrderNo.ToString());
lstOrders.Items.Add(NewEntry); //add the phone to the list
Index++; //move the index to the next record
}
return(RecordCount); //return the count of the records found
}
void pdoc_PrintPage(object sender, PrintPageEventArgs e)
{
Graphics graphics = e.Graphics;
Font font = new Font("Verdana", 8);
Font fontBold = new Font("Verdana", 8, FontStyle.Bold);
Pen boldPen = new Pen(Color.Black, 3);
Pen lightPen = new Pen(Color.Black, 1);
float fontHeight = font.GetHeight();
int startX = 3;
int startY = 2;
int Offset = 5;
string RestaurantName = ConfigurationManager.AppSettings["RestaurantName"];
graphics.DrawString(RestaurantName, new Font("Courier New", 13, FontStyle.Bold),
new SolidBrush(Color.Black), startX, startY + Offset);
graphics.DrawString(CreateDate,
font,
new SolidBrush(Color.Black), startX + 180, startY + Offset);
Offset = Offset + 30;
graphics.DrawString("No:118, Jalan Trus, 80000 Johor Bahru.",
font, new SolidBrush(Color.Black), startX, startY + Offset);
Offset = Offset + 20;
graphics.DrawString(string.Format("{0}", OrderNo),
new Font("Verdana", 12, FontStyle.Bold),
new SolidBrush(Color.Black), startX, startY + Offset);
graphics.DrawString(string.Format("Tel: 07-2214113"),
fontBold,
new SolidBrush(Color.Black), startX + 160, startY + Offset);
Offset = Offset + 20;
graphics.DrawString(string.Format("Service: {0} {1}", CreatedBy, Seats),
font,
new SolidBrush(Color.Black), startX, startY + Offset);
string[] headerTxts = { "No", "Item", "Qty", "UPrice", "Amt" };
DrawRow(startX, startY = Offset + 20, graphics, lightPen, headerTxts, fontBold);
int Sno = 0;
foreach (OrderedProduct item in OrderedProducts)
{
decimal? tot = item.Price * item.Quantity;
string[] rowTxt = { (++Sno).ToString(), item.ProductName, item.Quantity.ToString(),
String.Format("{0:0.00}", item.Price), String.Format("{0:0.00}", tot) };
DrawRow(startX, startY = startY + 20, graphics, lightPen, rowTxt, font);
}
//Total
RectangleF rf = new RectangleF(startX, startY = startY + 20, 280, 30);
graphics.DrawRectangle(lightPen, rf.X, rf.Y, rf.Width, rf.Height);
StringFormat stringFormat = new StringFormat();
stringFormat.Alignment = StringAlignment.Far;
stringFormat.LineAlignment = StringAlignment.Center;
graphics.DrawString("Total: RM " + String.Format("{0:0.00}", TotalAmount), new Font("Verdana", 12, FontStyle.Bold), Brushes.Blue, rf, stringFormat);
bool isAppendStar;
bool.TryParse(ConfigurationManager.AppSettings["AppendStarInBarcode"], out isAppendStar);
string strOrderNo = OrderNo.ToString();
if (isAppendStar)
{
strOrderNo = "*" + OrderNo.ToString() + "*";
}
graphics.DrawString(strOrderNo,
new Font("IDAutomationHC39M", 16),
new SolidBrush(Color.Black), 80, startY + Offset);
}
public CreateCommand(OrderNo orderNo, int supplierId)
{
OrderNo = orderNo;
SupplierId = supplierId;
}
public override string ToString()
{
String Items = "";
String Final = "";
for (int i = 0; i < ItemList.Count; i++)
{
Items = "";
if (itemList[i].Item.ProductList.Count > 1)
{
foreach (Product p in ItemList[i].Item.ProductList)
{
Items += "\t " + p.Name + "\n";
}
}
Final += String.Format("{0} {1}${2:0.00}\n{3}\n", ItemList[i].Quantity.ToString().PadRight(5), itemList[i].Item.Name.PadRight(27), ItemList[i].GetItemTotalAmt(), Items);
}
return(String.Format("Receipt #{0}\n{1:dd/MM/yyyy HH:mm}\n\n{2}\n{3}${4:0.00}", OrderNo.ToString().PadLeft(5, '0'), DateTime.Now, Final, "Total".PadRight(33), GetTotalAmt()));
}
