/// <summary>
/// Fills SupplierCode From
/// </summary>
private void FillSuppFromList()
{
string[] orderBy = { "SupplierCode" };
string sql = " Retired = 0";
SupplierEx.LoadCombo(ref cboSuppFrom, "SupplierCode", false, false, "", sql, orderBy);
}
private bool IsValid()
{
bool result = true;
#region Supplier Code 唔可以吉
errorProvider.SetError(txtSupplierCode, string.Empty);
if (txtSupplierCode.Text.Length == 0)
{
errorProvider.SetError(txtSupplierCode, "Cannot be blank!");
errorProvider.SetIconAlignment(txtSupplierCode, ErrorIconAlignment.TopLeft);
return(false);
}
#endregion
#region 新增，要 check Supplier Code 係咪 in use
errorProvider.SetError(txtSupplierCode, string.Empty);
if (_SupplierId == Guid.Empty)
{
if (SupplierEx.IsSupplierCodeInUse(txtSupplierCode.Text.Trim()))
{
errorProvider.SetError(txtSupplierCode, "Supplier Code in use");
errorProvider.SetIconAlignment(txtSupplierCode, ErrorIconAlignment.TopLeft);
return(false);
}
}
#endregion
return(result);
}
/// <summary>
/// Fills the supplier to list.
/// </summary>
private void FillToList()
{
string[] orderBy = { "SupplierCode" };
string sql = " Retired = 0 ";
SupplierEx.LoadCombo(ref cboTo, "SupplierCode", false, false, "", sql, orderBy);
cboTo.SelectedIndex = cboTo.Items.Count - 1;
}
/// <summary>
/// Fills SupplierNumber To
/// </summary>
private void FillSuppToList()
{
SupplierEx.LoadCombo(ref cboSupplierTo, "SupplierCode", false, false, string.Empty, " Retired = 0");
if (cboSupplierTo.Items.Count > 0)
{
cboSupplierTo.SelectedIndex = cboSupplierTo.Items.Count - 1;
}
}
private void FillComboBox()
{
SupplierEx.LoadCombo(ref cmbFrom, "SupplierCode", false);
SupplierEx.LoadCombo(ref cmbTo, "SupplierCode", false);
cmbTo.SelectedIndex = cmbTo.Items.Count - 1;
}
private void FillSupplierList()
{
SupplierEx.LoadCombo(ref cboSupplier, "SupplierCode", false);
}
/// <summary>
/// Fills SupplierCode From
/// </summary>
private void FillSuppFromList()
{
SupplierEx.LoadCombo(ref cboSupplierFrom, "SupplierCode", false, false, string.Empty, " Retired = 0");
}
private int Import()
{
int result = 0;
using (var ctx = new EF6.RT2020Entities())
{
using (var scope = ctx.Database.BeginTransaction())
{
try
{
for (int i = 0; i < md.Length; i++)
{
string txNumber = SystemInfoHelper.Settings.QueuingTxNumber(EnumHelper.TxType.CAP);
#region Guid headerId = ImportCAPHeader(md[i].Master as CAPTxtIEMaster, txNumber);
CAPTxtIEMaster master = md[i].Master as CAPTxtIEMaster;
var oHeader = new EF6.InvtBatchCAP_Header();
oHeader.HeaderId = Guid.NewGuid();
oHeader.TxType = EnumHelper.TxType.CAP.ToString();
oHeader.TxNumber = txNumber;
oHeader.TxDate = master.RecvDate;
oHeader.WorkplaceId = WorkplaceEx.GetWorkplaceIdByCode(master.Location);
oHeader.StaffId = StaffEx.GetStaffIdByStaffNumber(master.Operator);
oHeader.SupplierId = SupplierEx.GetSupplierIdBySupplierCode(master.Supplier);
oHeader.Status = Convert.ToInt32(EnumHelper.Status.Draft.ToString("d"));
oHeader.Reference = master.RefNumber;
oHeader.Remarks = master.Remarks;
oHeader.CurrencyCode = "HKD";
oHeader.ExchangeRate = (decimal)1;
oHeader.CreatedBy = ConfigHelper.CurrentUserId;
oHeader.CreatedOn = DateTime.Now;
oHeader.ModifiedBy = ConfigHelper.CurrentUserId;
oHeader.ModifiedOn = DateTime.Now;
ctx.InvtBatchCAP_Header.Add(oHeader);
ctx.SaveChanges();
Guid headerId = oHeader.HeaderId;
#endregion
decimal ttlAmt = 0;
#region decimal ttlAmt = ImportCAPDetails(md[i].Details, headerId, txNumber);
object[] details = md[i].Details;
if (details != null)
{
for (int j = 0; j < details.Length; j++)
{
CAPTxtIEDetails detail = details[j] as CAPTxtIEDetails;
Guid prodId = GetProductId(detail);
if (prodId != Guid.Empty)
{
var oDetail = new EF6.InvtBatchCAP_Details();
oDetail.DetailsId = Guid.NewGuid();
oDetail.ProductId = prodId;
oDetail.HeaderId = headerId;
oDetail.LineNumber = j + 1;
oDetail.TxNumber = txNumber;
oDetail.TxType = EnumHelper.TxType.CAP.ToString();
oDetail.Qty = detail.ReceivedQty;
oDetail.UnitAmount = detail.ReceivedUnitAmount;
oDetail.UnitAmountInForeignCurrency = detail.ReceivedUnitAmount;
ctx.InvtBatchCAP_Details.Add(oDetail);
ctx.SaveChanges();
ttlAmt += oDetail.Qty.Value * oDetail.UnitAmount.Value;
}
else
{
string skippedProduct = String.Format("?{0} {1} {2} {3}",
detail.StockCode, detail.Appendix1, detail.Appendix2, detail.Appendix3);
skippedList.Add(skippedProduct);
}
}
}
#endregion
oHeader = ctx.InvtBatchCAP_Header.Find(headerId);
if (oHeader != null)
{
oHeader.TotalAmount = ttlAmt;
ctx.SaveChanges();
UpdateListView(i, txNumber);
skippedList.Clear();
}
result++;
}
scope.Commit();
}
catch (Exception ex)
{
scope.Rollback();
}
}
}
return(result);
}
