private void GetGoodsRecdDetailByGoodsRecdID(int iGoodRecdID, string IPONO)
{
DataSet dsPODetail = new DataSet();
// StockDal objStockDal = new StockDal();
StockDal objStockDal = new StockDal();
dsPODetail = objStockDal.GetGoodsRecdDetailByGoodsRecdID(iGoodRecdID, IPONO);
if (dsPODetail != null)
{
if (dsPODetail.Tables[0].Rows.Count > 0)
{
grdGoodsRecd.DataSource = dsPODetail.Tables[0];
grdGoodsRecd.DataBind();
}
if (dsPODetail.Tables[1].Rows.Count > 0)
{
dgInvoiced.DataSource = dsPODetail.Tables[1];
dgInvoiced.DataBind();
}
if (dsPODetail.Tables[2].Rows.Count > 0)
{
try
{
lblTotalRecvd.Text = Convert.ToString(GetAfterDecimalCalculatedValue(Convert.ToDecimal(dsPODetail.Tables[2].Rows[0]["TotalInvoiced"].ToString())));
lblInvoiced.Text = Convert.ToString(GetAfterDecimalCalculatedValue(Convert.ToDecimal(dsPODetail.Tables[2].Rows[0]["TotalRecd"].ToString())));
lblVarience.Text = Convert.ToString(GetAfterDecimalCalculatedValue(Convert.ToDecimal(dsPODetail.Tables[2].Rows[0]["Varience"].ToString())));
}
catch (Exception ex) { string ss = ex.Message.ToString(); }
}
}
}
public void GetPODetailValues(string IPONO)
{
DataSet dsPO = new DataSet();
StockDal objStockDal = new StockDal();
dTotalReceived = objStockDal.PropReceived;
dTotalInvoiced = objStockDal.PropInvoiced;
dVerience = objStockDal.PropVarience;
Currency = objStockDal.CurrencyType;
lblDocumentNo.Text = IPONO.ToString();
//kk
Currency = Convert.ToString(Session["CurrencyType"].ToString());
lblCurrency.Text = Currency.ToString();
}
// /// <summary>
// /// 获取订单物流信息
// /// </summary>
// /// <param name="orderCode"></param>
// /// <returns></returns>
// public IList<OrderLogisticsEntity> GetOrderLogistics(string orderCode)
// {
// string sql = @"SELECT oe.Id, oe.OrderCode, oe.ExpressCompany, oe.ExpressList, oe.ExPressStatus,ol.LogisticsTime,
// ol.[Status], ol.Remark, ol.CreateTime, ol.CreateBy
// FROM OrderExpress AS oe
// LEFT JOIN OrderLogistics AS ol ON oe.OrderCode=ol.OrderCode AND ol.[Status]=1
// WHERE ol.OrderCode=@OrderCode
// ORDER BY ol.CreateTime DESC ";
// try
// {
// var parameters = DbSFO2ORead.CreateParameterCollection();
// parameters.Append("@OrderCode", orderCode);
// return DbSFO2OMain.ExecuteSqlList<OrderLogisticsEntity>(sql, parameters);
// }
// catch (Exception ex)
// {
// LogHelper.Error(ex);
// return new List<OrderLogisticsEntity>();
// }
// }
/// <summary>
/// 取消订单
/// </summary>
/// <param name="orderCode"></param>
/// <returns></returns>
public bool CancelOrder(string orderCode, List <StockEntity> list, int userId, decimal huoli, int couponId, bool IsUpdateGiftStatus)
{
var db = DbSFO2OMain;
var connection = db.CreateConnection();
connection.Open();
using (var tran = connection.BeginTransaction())
{
try
{
foreach (var item in list)
{
StockDal.UpdateByForOrderQty(item.Spu, item.Sku, item.Qty, db, tran);
}
if (huoli > 0)
{
HuoliDal.UpdateByLockedForHuoli(userId, huoli, db, tran);
}
CancelOrder(orderCode, db, tran);
if (couponId > 0)
{
// 是否更新优惠券状态
if (IsUpdateGiftStatus)
{
//查询优惠券时间
GiftCardDal.ChangeGiftCardStatusByEventType(3, couponId, db, tran);
}
}
tran.Commit();
connection.Close();
connection.Dispose();
return(true);
}
catch (Exception ext)
{
tran.Rollback();
connection.Close();
connection.Dispose();
LogHelper.Error(ext);
return(false);
}
}
}
private void grdInvCur_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
try
{
if (e.Item.ItemType == ListItemType.Item)
{
// string customerId = grdInvCur.DataKeys[e.Item.ItemIndex].ToString();
GridView gvOrders = e.Item.FindControl("gvOrders") as GridView;
gvOrders.DataSource = GetInvalidPONumberFor();
gvOrders.DataBind();
}
}
catch { }
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
((System.Web.UI.WebControls.Label)e.Item.FindControl("lblTotReceived")).Text = Convert.ToString(GetAfterDecimalCalculatedValue(Convert.ToDecimal(((Label)e.Item.FindControl("lblTotReceived")).Text)));
((System.Web.UI.WebControls.Label)e.Item.FindControl("lblTotInvoiced")).Text = Convert.ToString(GetAfterDecimalCalculatedValue(Convert.ToDecimal(((Label)e.Item.FindControl("lblTotInvoiced")).Text)));
((System.Web.UI.WebControls.Label)e.Item.FindControl("Label2")).Text = Convert.ToString(GetAfterDecimalCalculatedValue(Convert.ToDecimal(((Label)e.Item.FindControl("Label2")).Text)));
if (((Label)e.Item.FindControl("lblTotReceived")).Text != "")
{
dTotalReceived = dTotalReceived + Convert.ToDecimal(((System.Web.UI.WebControls.Label)e.Item.FindControl("lblTotReceived")).Text.Trim());
}
if (((Label)e.Item.FindControl("lblTotInvoiced")).Text != "")
{
dTotalInvoiced = dTotalInvoiced + Convert.ToDecimal(((System.Web.UI.WebControls.Label)e.Item.FindControl("lblTotInvoiced")).Text.Trim());
}
}
else if (e.Item.ItemType == ListItemType.Footer)
{
((System.Web.UI.WebControls.Label)e.Item.FindControl("lblFooterTotalReceived")).Text = Convert.ToString(dTotalReceived);
((System.Web.UI.WebControls.Label)e.Item.FindControl("lblFooterTotInvoiced")).Text = Convert.ToString(dTotalInvoiced);
dVerience = dTotalInvoiced - dTotalReceived;
((System.Web.UI.WebControls.Label)e.Item.FindControl("lblFooterVarience")).Text = Convert.ToString(GetAfterDecimalCalculatedValue(Convert.ToDecimal(dVerience)));
StockDal oSDal = new StockDal();
oSDal.PropInvoiced = dTotalInvoiced;
oSDal.PropReceived = dTotalReceived;
oSDal.PropVarience = dVerience;
}
}
//Added by Mainak 2018-05-28
//protected void Page_LoadComplete(object sender, EventArgs e)
//{
// if (Request.QueryString["POID"] != null)
// {
// IPONO = Convert.ToString(Request.QueryString["POID"]);
// GoodsRecgID = Convert.ToInt32(Request.QueryString["GRID"]);
// DataSet dsPODetail = new DataSet();
// StockDal objStockDal = new StockDal();
// dsPODetail = objStockDal.GetGoodsRecdDetailByGoodsRecdID(GoodsRecgID, IPONO);
// int grdGoodsRecdCount = dsPODetail.Tables[0].Rows.Count;
// for (int i = 0; i < grdGoodsRecdCount; i++)
// {
// string PurOrderLineNoGR = dsPODetail.Tables[0].Rows[i]["PurOrderLineNo"].ToString();
// string PurOrderNoGR = dsPODetail.Tables[0].Rows[i]["PurOrderNo"].ToString();
// string SupplierCompanyIDGR = dsPODetail.Tables[0].Rows[i]["SupplierCompanyID"].ToString();
// string BuyerCompanyIDGR = dsPODetail.Tables[0].Rows[i]["BuyerCompanyID"].ToString();
// string QuantityGR = dsPODetail.Tables[0].Rows[i]["Quantity"].ToString();
// string RateGR = dsPODetail.Tables[0].Rows[i]["Rate"].ToString();
// string PurOrderLineNoINV = dsPODetail.Tables[1].Rows[i]["PurOrderLineNo"].ToString();
// string PurOrderNoINV = dsPODetail.Tables[1].Rows[i]["PurOrderNo"].ToString();
// string SupplierCompanyIDINV = dsPODetail.Tables[1].Rows[i]["SupplierCompanyID"].ToString();
// string BuyerCompanyIDINV = dsPODetail.Tables[1].Rows[i]["BuyerCompanyID"].ToString();
// string QuantityINV = dsPODetail.Tables[1].Rows[i]["Quantity"].ToString();
// string RateINV = dsPODetail.Tables[1].Rows[i]["Rate"].ToString();
// DataGridItem dgi1 = dgInvoiced.Items[i];
// if ((PurOrderLineNoGR != PurOrderLineNoINV) || (PurOrderNoGR != PurOrderNoINV)
// || (SupplierCompanyIDGR != SupplierCompanyIDINV) || (BuyerCompanyIDGR != BuyerCompanyIDINV)
// || (QuantityGR != QuantityINV))
// {
// //dgi1.Cells[5].ForeColor = Color.Red;
// Label Label3 = dgi1.Cells[5].FindControl("Label3") as Label;
// Label3.Style.Add("color", "red !important;");
// }
// if ((PurOrderLineNoGR != PurOrderLineNoINV) || (PurOrderNoGR != PurOrderNoINV)
// || (SupplierCompanyIDGR != SupplierCompanyIDINV) || (BuyerCompanyIDGR != BuyerCompanyIDINV)
// || (RateGR != RateINV))
// {
// Label Label4 = dgi1.Cells[6].FindControl("Label4") as Label;
// Label4.Style.Add("color", "red !important;");
// }
// }
// //foreach (DataGridItem dgi in grdGoodsRecd.Items)
// //{
// // foreach (DataGridItem dgi1 in dgInvoiced.Items)
// // {
// // Label LeftHandQty = dgi.FindControl("lblRCVQty") as Label;
// // Label RightHandQty = dgi1.FindControl("Label3") as Label;
// // if (dgi.Cells[0].Text == "")
// // {
// // dgi1.Cells[5].ForeColor = Color.Red;
// // }
// // }
// //}
// }
//}
//Modified by Mainak 2018-08-02
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (Request.QueryString["POID"] != null)
{
IPONO = Convert.ToString(Request.QueryString["POID"]);
GoodsRecgID = Convert.ToInt32(Request.QueryString["GRID"]);
DataSet dsPODetail = new DataSet();
StockDal objStockDal = new StockDal();
dsPODetail = objStockDal.GetGoodsRecdDetailByGoodsRecdID(GoodsRecgID, IPONO);
int grdGoodsRecdCount = dsPODetail.Tables[0].Rows.Count;
int grdInvoiceCount = dsPODetail.Tables[1].Rows.Count;
for (int i = 0; i < grdGoodsRecdCount; i++)
{
string PurOrderLineNoGR = dsPODetail.Tables[0].Rows[i]["PurOrderLineNo"].ToString();
string PurOrderNoGR = dsPODetail.Tables[0].Rows[i]["PurOrderNo"].ToString();
string SupplierCompanyIDGR = dsPODetail.Tables[0].Rows[i]["SupplierCompanyID"].ToString();
string BuyerCompanyIDGR = dsPODetail.Tables[0].Rows[i]["BuyerCompanyID"].ToString();
string QuantityGR = dsPODetail.Tables[0].Rows[i]["Quantity"].ToString();
string RateGR = dsPODetail.Tables[0].Rows[i]["Rate"].ToString();
for (int j = 0; j < grdInvoiceCount; j++)
{
string PurOrderLineNoINV = dsPODetail.Tables[1].Rows[j]["PurOrderLineNo"].ToString();
string PurOrderNoINV = dsPODetail.Tables[1].Rows[j]["PurOrderNo"].ToString();
string SupplierCompanyIDINV = dsPODetail.Tables[1].Rows[j]["SupplierCompanyID"].ToString();
string BuyerCompanyIDINV = dsPODetail.Tables[1].Rows[j]["BuyerCompanyID"].ToString();
string QuantityINV = dsPODetail.Tables[1].Rows[j]["Quantity"].ToString();
string RateINV = dsPODetail.Tables[1].Rows[j]["Rate"].ToString();
DataGridItem dgi1 = dgInvoiced.Items[j];
if (PurOrderLineNoGR == PurOrderLineNoINV)
{
// if ((SupplierCompanyIDGR != SupplierCompanyIDINV) || (BuyerCompanyIDGR != BuyerCompanyIDINV)
// || (QuantityGR != QuantityINV))
// {
// //dgi1.Cells[5].ForeColor = Color.Red;
// Label Label3 = dgi1.Cells[5].FindControl("Label3") as Label;
// Label3.Style.Add("color", "red !important;");
// }
// if ((SupplierCompanyIDGR != SupplierCompanyIDINV) || (BuyerCompanyIDGR != BuyerCompanyIDINV)
//|| (RateGR != RateINV))
// {
// Label Label4 = dgi1.Cells[6].FindControl("Label4") as Label;
// Label4.Style.Add("color", "red !important;");
// }
if (QuantityGR != QuantityINV)
{
Label Label3 = dgi1.Cells[5].FindControl("Label3") as Label;
Label3.Style.Add("color", "red !important;");
}
if (RateGR != RateINV)
{
Label Label4 = dgi1.Cells[6].FindControl("Label4") as Label;
Label4.Style.Add("color", "red !important;");
}
}
}
}
for (int i = 0; i < grdInvoiceCount; i++)
{
int found = 0;
string PurOrderLineNoINV = dsPODetail.Tables[1].Rows[i]["PurOrderLineNo"].ToString();
for (int j = 0; j < grdGoodsRecdCount; j++)
{
string PurOrderLineNoGR = dsPODetail.Tables[0].Rows[j]["PurOrderLineNo"].ToString();
if (PurOrderLineNoINV == PurOrderLineNoGR)
{
found = 1;
}
}
DataGridItem dgi1 = dgInvoiced.Items[i];
if (found == 0)
{
Label Label3 = dgi1.Cells[5].FindControl("Label3") as Label;
Label3.Style.Add("color", "red !important;");
Label Label4 = dgi1.Cells[6].FindControl("Label4") as Label;
Label4.Style.Add("color", "red !important;");
}
}
//foreach (DataGridItem dgi in grdGoodsRecd.Items)
//{
// foreach (DataGridItem dgi1 in dgInvoiced.Items)
// {
// Label LeftHandQty = dgi.FindControl("lblRCVQty") as Label;
// Label RightHandQty = dgi1.FindControl("Label3") as Label;
// if (dgi.Cells[0].Text == "")
// {
// dgi1.Cells[5].ForeColor = Color.Red;
// }
// }
//}
}
}
public void GetStockDocumentDetails(int InvID)
{
StockDal oStockDal = new StockDal();
DataSet dsStock = new DataSet();
dsStock = oStockDal.GetStockDocumentDetails(InvID, "CRN");
if (dsStock != null)
{
if (dsStock.Tables.Count > 0)
{
#region Tables[0].Rows.Count
if (dsStock.Tables[0].Rows.Count > 0)
{
lblDocumentNo.Text = dsStock.Tables[0].Rows[0]["InvoiceNo"].ToString();
lblinvoicedate.Text = dsStock.Tables[0].Rows[0]["InvoiceDate"].ToString();
lblsupplier.Text = dsStock.Tables[0].Rows[0]["SupplierCompanyName"].ToString();
lblBuyerName.Text = dsStock.Tables[0].Rows[0]["BuyerCompanyName"].ToString();
try
{
Session["BuyerID_STK"] = dsStock.Tables[0].Rows[0]["BuyerID"].ToString();
Session["SupplierID_STK"] = dsStock.Tables[0].Rows[0]["SupplierID"].ToString();
}
catch { }
lblCurrency.Text = dsStock.Tables[0].Rows[0]["CurrencyCode"].ToString();
#region
oStockDal.CurrencyType = dsStock.Tables[0].Rows[0]["CurrencyCode"].ToString();
Session["CurrencyType"] = dsStock.Tables[0].Rows[0]["CurrencyCode"].ToString(); //kk
#endregion
lblinvoicestatus.Text = dsStock.Tables[0].Rows[0]["Status"].ToString();
ViewState["StatusID"] = dsStock.Tables[0].Rows[0]["StatusID"].ToString();
try
{
lblCreditNo.Text = dsStock.Tables[0].Rows[0]["CreditInvoiceNo"].ToString();
}
catch { }
try
{
lblDepartmant.Text = dsStock.Tables[0].Rows[0]["Department"].ToString();
lblNominal.Text = dsStock.Tables[0].Rows[0]["NominalCodeID"].ToString();
}
catch { }
try
{
lblinvoicetype.Text = dsStock.Tables[0].Rows[0]["DocType"].ToString();
Session["Doctype_STK"] = dsStock.Tables[0].Rows[0]["DocType"].ToString();//added by kuntalkarar on 2ndMarch2017
}
catch { }
lblNet.Text = dsStock.Tables[0].Rows[0]["Net"].ToString();
lblVat.Text = dsStock.Tables[0].Rows[0]["Vat"].ToString();
lblGross.Text = dsStock.Tables[0].Rows[0]["Total"].ToString();
}
#endregion
#region Tables[0].Rows.Count
if (dsStock.Tables[1].Rows.Count > 0)
{
grdInvCur.DataSource = dsStock.Tables[1];
grdInvCur.DataBind();
}
#endregion
}
}
}
