public void DoInsertRequestPay(tinprequestpay requestPay, List<tinprequestpaydtl> lstDtl)
{
try
{
dbInstance.BeginTransaction();
List<MESParameterInfo> lstParams = new List<MESParameterInfo>() {
new MESParameterInfo(){ParamName="shippingsysid",ParamValue=requestPay.shippingsysid}
};
requestPayDtlDal.DoDelete<tinprequestpaydtl>(lstParams);
localDal.DoDelete<tinprequestpay>(lstParams);
localDal.DoInsert<tinprequestpay>(requestPay);
foreach (tinprequestpaydtl dtl in lstDtl)
{
requestPayDtlDal.DoInsert<tinprequestpaydtl>(dtl);
}
dbInstance.Commit();
}
catch (Exception ex)
{
dbInstance.Rollback();
throw ex;
}
finally
{
dbInstance.CloseConnection();
}
}
private void doPrint()
{
try
{
#region Check Input
foreach (UltraGridRow row in this.grdDetail.Rows)
{
if (row.Cells["itemname"].Value.ToString().Equals(""))
{
throw new Exception(UtilCulture.GetString("Msg.R01020", UtilCulture.GetString("Label.R0104401")));
}
if (Convert.ToInt16(row.Cells["qty"].Value) <= 0)
{
throw new Exception(UtilCulture.GetString("Msg.R01016", UtilCulture.GetString("Label.R0104403")));
}
}
#endregion
#region Save Input
tinprequestpay requestPay = new tinprequestpay();
requestPay.shippingsysid = ShipingSysId;
requestPay.rptdate = rptDate;
requestPay.currency = ((ValueInfo)this.cmbCurrency.SelectedItem).ValueField;
requestPay.template = ((ValueInfo)this.cmbTemplate.SelectedItem).ValueField;
List<tinprequestpaydtl> lstRequestPayDtl = new List<tinprequestpaydtl>();
foreach (UltraGridRow row in this.grdDetail.Rows)
{
tinprequestpaydtl requestpaydtl = new tinprequestpaydtl();
requestpaydtl.shippingsysid = ShipingSysId;
requestpaydtl.itemname = row.Cells["itemname"].Value.ToString();
requestpaydtl.currency = row.Cells["currency"].Value.ToString();
requestpaydtl.unit = row.Cells["unit"].Value.ToString();
requestpaydtl.price = Convert.ToDecimal(row.Cells["price"].Value);
requestpaydtl.qty = Convert.ToDecimal(row.Cells["qty"].Value);
lstRequestPayDtl.Add(requestpaydtl);
}
DoInsertRequestPay(requestPay, lstRequestPayDtl);
#endregion
#region Get Data
DataTable pricingDt = GetValidPricing(customerId, rptDate);
DataTable iqcDt = GetValidIQC(customerId);
DataTable exDt = GetValidExchange(rptDate);
string currency = ((ValueInfo)this.cmbCurrency.SelectedItem).ValueField.Trim();
#endregion
#region Check Shipping
var qByStyleNo=from p in dtlDt.AsEnumerable()
group p by new
{
styleno = p["styleno"].ToString(),
checktype = p["checktype"].ToString()
} into g
select new
{
g.Key.styleno,
g.Key.checktype
};
foreach (var data in qByStyleNo)
{
var iqcckq=from p in iqcDt.AsEnumerable()
where p["styleno"].ToString().Equals(data.styleno.ToString())
&& p["customerid"].ToString().Equals(customerId)
select p;
//Check IQC
if (iqcckq.Count() == 0)
{
throw new Exception(UtilCulture.GetString("Msg.R01028", data.styleno.ToString()));
}
else
{
string shoeCategory = iqcckq.ElementAt(0)["category"].ToString();
Double bootHeight = Convert.ToDouble(iqcckq.ElementAt(0)["bootheight"]);
//Check Pricing
var pricingckq = from p in pricingDt.AsEnumerable()
where p["category"].ToString().Equals(shoeCategory)
&& Convert.ToDouble(p["sbootheight"]) <= bootHeight
&& Convert.ToDouble(p["ebootheight"]) >= bootHeight
&& p["checktype"].ToString().Equals(data.checktype)
select p;
if (pricingckq.Count() == 0)
{
throw new Exception(UtilCulture.GetString("Msg.R01029", shoeCategory + "," + bootHeight + "," + data.checktype));
}
else
{
//Check Exchange
if (!pricingckq.ElementAt(0)["currency"].ToString().Trim().Equals(currency))
{
var exckq = from p in exDt.AsEnumerable()
where p["fromcurrency"].ToString().Equals(pricingckq.ElementAt(0)["currency"].ToString())
&& p["tocurrency"].ToString().Equals(currency)
select p;
if (exckq.Count() == 0)
{
throw new Exception(UtilCulture.GetString("Msg.R01030", pricingckq.ElementAt(0)["currency"].ToString() + "->" + bootHeight + "," + currency));
}
}
}
if (data.checktype.Equals("IX"))
{
var pricingckiq = from p in pricingDt.AsEnumerable()
where p["category"].ToString().Equals(shoeCategory)
&& Convert.ToDouble(p["sbootheight"]) <= bootHeight
&& Convert.ToDouble(p["ebootheight"]) >= bootHeight
&& p["checktype"].ToString().Equals("I")
select p;
if (pricingckiq.Count() == 0)
{
throw new Exception(UtilCulture.GetString("Msg.R01029", shoeCategory + "," + bootHeight + ",I"));
}
else
{
//Check Exchange
if (!pricingckiq.ElementAt(0)["currency"].ToString().Trim().Equals(currency))
{
var exckq = from p in exDt.AsEnumerable()
where p["fromcurrency"].ToString().Equals(pricingckiq.ElementAt(0)["currency"].ToString())
&& p["tocurrency"].ToString().Equals(currency)
select p;
if (exckq.Count() == 0)
{
throw new Exception(UtilCulture.GetString("Msg.R01030", pricingckiq.ElementAt(0)["currency"].ToString() + "->" + currency));
}
}
}
}
}
}
#endregion
#region Check Other Pricing has exchange rate
foreach (tinprequestpaydtl requestpaydtl in lstRequestPayDtl)
{
//Check Exchange
if (!requestpaydtl.currency.Trim().Equals(currency))
{
var exckq = from p in exDt.AsEnumerable()
where p["fromcurrency"].ToString().Equals(requestpaydtl.currency)
&& p["tocurrency"].ToString().Equals(currency)
select p;
if (exckq.Count() == 0)
{
throw new Exception(UtilCulture.GetString("Msg.R01030", requestpaydtl.currency + "->" + currency));
}
}
}
#endregion
WaitingForm.CreateWaitForm();
WaitingForm.SetWaitMessage("正在生成请款单，请稍候...");
(new ExcelExport()).ExportRequestPay(((ValueInfo)this.cmbTemplate.SelectedItem).ValueField,rptDate,
currency, GetSingleShipping(ShipingSysId), GetShippingOrigDtlForReport(ShipingSysId), GetPackingRecRetrieve(ShipingSysId), iqcDt, pricingDt, exDt, lstRequestPayDtl);
WaitingForm.CloseWaitForm();
}
catch (Exception ex)
{
baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, ex.Message);
}
}
private void DoInsertRequestPay(tinprequestpay requestPay, List<tinprequestpaydtl> lstRequestPayDtl)
{
wsINP.IwsINPClient client = new wsINP.IwsINPClient();
try
{
client.DoInsertRequestPay(baseForm.CurrentContextInfo, requestPay, lstRequestPayDtl.ToArray<tinprequestpaydtl>());
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
/// <summary>
/// Create a new tinprequestpay object.
/// </summary>
/// <param name="shippingsysid">Initial value of the shippingsysid property.</param>
public static tinprequestpay Createtinprequestpay(global::System.String shippingsysid)
{
tinprequestpay tinprequestpay = new tinprequestpay();
tinprequestpay.shippingsysid = shippingsysid;
return tinprequestpay;
}
/// <summary>
/// Deprecated Method for adding a new object to the tinprequestpay EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotinprequestpay(tinprequestpay tinprequestpay)
{
base.AddObject("tinprequestpay", tinprequestpay);
}
public void DoInsertRequestPay(ContextInfo contextInfo, tinprequestpay requestPay, List<tinprequestpaydtl> lstDtl)
{
contextInfo.Action = MES_ActionType.Insert;
RequestPayBll bll = new RequestPayBll(contextInfo);
bll.CallAccessControl();
bll.DoInsertRequestPay(requestPay, lstDtl);
GC.Collect();
}