public override void FillTheTable(AmbleClient.RfqGui.RfqManager.Rfq rfq)
{
base.FillTheTable(rfq);
this.tbCustomer.Text = string.Empty;
this.tbContact.Text = string.Empty;
this.tbPhone.Text = string.Empty;
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
cbSales.Items.Add(accountMgr.GetNameById(rfq.salesId));
cbSales.SelectedIndex = 0;
if (rfq.firstPA != null)
{
cbPrimaryPA.Items.Add(accountMgr.GetNameById(rfq.firstPA.Value));
cbPrimaryPA.SelectedIndex = 0;
}
if (rfq.secondPA != null)
{
cbAltPA.Items.Add(accountMgr.GetNameById(rfq.secondPA.Value));
cbAltPA.SelectedIndex = 0;
}
}
public override void FillTheTable(AmbleClient.RfqGui.RfqManager.Rfq rfq)
{
base.FillTheTable(rfq);
this.tbCustomer.Text = string.Empty;
this.tbContact.Text = string.Empty;
this.tbPhone.Text = string.Empty;
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
cbSales.Items.Add(accountMgr.GetNameById(rfq.salesId));
cbSales.SelectedIndex = 0;
if (rfq.firstPA != null)
{
cbPrimaryPA.Items.Add(accountMgr.GetNameById(rfq.firstPA.Value));
cbPrimaryPA.SelectedIndex = 0;
}
if (rfq.secondPA != null)
{
cbAltPA.Items.Add(accountMgr.GetNameById(rfq.secondPA.Value));
cbAltPA.SelectedIndex = 0;
}
}
public override void FillTheTable(Rfq rfq)
{
base.FillTheTable(rfq);
//Fill the salesId
tbCustomer.Text = rfq.customerName;
//select the sales ID
//获得下级号和名字
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
mySubs = accountMgr.GetAllSubsId(UserInfo.UserId,UserCombine.GetUserCanBeSales());
Dictionary<int, string> mySubsIdAndName = accountMgr.GetIdsAndNames(mySubs);
foreach (string name in mySubsIdAndName.Values)
{
cbSales.Items.Add(name);
}
for (int i = 0; i < mySubs.Count; i++)
{
if (mySubs[i] == rfq.salesId)
{
cbSales.SelectedIndex = i;
break;
}
}
List<int> pAList=new List<int>();
//Fill the PA
if (rfq.firstPA.HasValue)
pAList.Add(rfq.firstPA.Value);
if (rfq.secondPA.HasValue)
pAList.Add(rfq.secondPA.Value);
if (pAList.Count > 0)
{
Dictionary<int, string> paIDAndName = accountMgr.GetIdsAndNames(pAList);
if (rfq.firstPA.HasValue&&rfq.secondPA.HasValue)
{
cbPrimaryPA.Text = paIDAndName[rfq.firstPA.Value];
cbAltPA.Text = paIDAndName[rfq.secondPA.Value];
}
else if (rfq.firstPA.HasValue)
{
cbPrimaryPA.Text = paIDAndName[rfq.firstPA.Value];
}
else if(rfq.secondPA.HasValue)
{
cbAltPA.Text = paIDAndName[rfq.secondPA.Value];
}
else
{
//error
}
}
}
private void FillThePACombo()
{
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
mysubs = accountMgr.GetAllSubsId(UserInfo.UserId, UserCombine.GetUserCanBeBuyers());
buyerIdsAndNames = accountMgr.GetIdsAndNames(mysubs);
foreach (string buyerName in buyerIdsAndNames.Values)
{
cbPa.Items.Add(buyerName);
}
}
private void FillTheSalesComboBox()
{
AmbleClient.Admin.AccountMgr.AccountMgr accMgr = new Admin.AccountMgr.AccountMgr();
mySubs = accMgr.GetAllSubsId(UserInfo.UserId, UserCombine.GetUserCanBeSales());
Dictionary <int, string> mySubsIdAndName = accMgr.GetIdsAndNames(mySubs);
foreach (string name in mySubsIdAndName.Values)
{
cbSp.Items.Add(name);
}
}
public void NewRfqFill()
{
this.tbCustomer.Leave += new System.EventHandler(this.tbCustomer_Leave);
cbCloseReason.Enabled = false;
tbRfqDate.ReadOnly = true; tbRfqDate.Enabled = false;
//clear all the necessary textbox
tbCustomer.Clear();
//customer auto complete
CustomerAutoComplete();
tbProject.Clear();
tbContact.Clear();
tbPhone.Clear();
tbFax.Clear();
tbEmail.Clear();
cbPriority.SelectedIndex = -1;
cbRohs.Checked = false;
tbPartNo.Clear();
tbMfg.Clear();
tbDc.Clear();
tbCustPartNo.Clear();
tbGenPartNo.Clear();
tbAlt.Clear();
tbQuantity.Clear();
tbPartNo.Clear();
tbTargetPrice.Clear();
tbResale.Clear();
tbCost.Clear();
cbPrimaryPA.Text = "";
cbAltPA.Text = "";
cbCloseReason.SelectedIndex = -1;
tbToCustomer.Clear();
tbToInternal.Clear();
tbRoutingHistory.Clear();
//Fill the cbSale;
//获得下级号和名字
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
mySubs = accountMgr.GetAllSubsId(UserInfo.UserId, UserCombine.GetUserCanBeSales());
Dictionary <int, string> mySubsIdAndName = accountMgr.GetIdsAndNames(mySubs);
foreach (string name in mySubsIdAndName.Values)
{
cbSales.Items.Add(name);
}
cbSales.SelectedIndex = 0;
}
public void NewRfqFill()
{
this.tbCustomer.Leave += new System.EventHandler(this.tbCustomer_Leave);
cbCloseReason.Enabled = false;
tbRfqDate.ReadOnly = true; tbRfqDate.Enabled = false;
//clear all the necessary textbox
tbCustomer.Clear();
//customer auto complete
CustomerAutoComplete();
tbProject.Clear();
tbContact.Clear();
tbPhone.Clear();
tbFax.Clear();
tbEmail.Clear();
cbPriority.SelectedIndex = -1;
cbRohs.Checked = false;
tbPartNo.Clear();
tbMfg.Clear();
tbDc.Clear();
tbCustPartNo.Clear();
tbGenPartNo.Clear();
tbAlt.Clear();
tbQuantity.Clear();
tbPartNo.Clear();
tbTargetPrice.Clear();
tbResale.Clear();
tbCost.Clear();
cbPrimaryPA.Text = "";
cbAltPA.Text = "";
cbCloseReason.SelectedIndex = -1;
tbToCustomer.Clear();
tbToInternal.Clear();
tbRoutingHistory.Clear();
//Fill the cbSale;
//获得下级号和名字
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
mySubs = accountMgr.GetAllSubsId(UserInfo.UserId,UserCombine.GetUserCanBeSales());
Dictionary<int, string> mySubsIdAndName = accountMgr.GetIdsAndNames(mySubs);
foreach (string name in mySubsIdAndName.Values)
{
cbSales.Items.Add(name);
}
cbSales.SelectedIndex = 0;
}
static void FillTheSoSheet(ISheet sheet, So so, List <SoItemsContentAndState> soitemList)
{
AmbleClient.Admin.AccountMgr.AccountMgr accMgr = new Admin.AccountMgr.AccountMgr();
sheet.GetRow(0).CreateCell(2).SetCellValue(so.customerName);
sheet.GetRow(0).CreateCell(6).SetCellValue(so.contact);
sheet.GetRow(0).CreateCell(9).SetCellValue(accMgr.GetNameById(so.salesId));
if (so.approverId != null)
{
sheet.GetRow(0).CreateCell(14).SetCellValue(accMgr.GetNameById(so.approverId.Value) + "," + so.approveDate.Value.ToShortDateString());
}
sheet.GetRow(1).CreateCell(2).SetCellValue(so.salesOrderNo);
sheet.GetRow(1).CreateCell(6).SetCellValue(so.orderDate.ToShortDateString());
sheet.GetRow(1).CreateCell(9).SetCellValue(so.customerPo);
sheet.GetRow(1).CreateCell(14).SetCellValue(so.paymentTerm);
sheet.GetRow(2).CreateCell(2).SetCellValue(so.freightTerm);
sheet.GetRow(2).CreateCell(6).SetCellValue(so.customerAccount);
sheet.GetRow(2).CreateCell(9).SetCellValue(so.specialInstructions);
IRow row = sheet.CreateRow(4);
row.CreateCell(0).SetCellValue(so.billTo);
row.CreateCell(8).SetCellValue(so.shipTo);
int itemRowIndex = 9;
foreach (SoItemsContentAndState scs in soitemList)
{
IRow itemRow = sheet.CreateRow(itemRowIndex);
itemRow.CreateCell(0).SetCellValue(soitemList.IndexOf(scs) + 1);
string strSaleType;
switch (scs.soitem.saleType)
{
case 0:
strSaleType = "OEM EXCESS";
break;
case 1:
strSaleType = "OWN STOCK";
break;
case 2:
strSaleType = "OTHERS";
break;
default:
strSaleType = "ERROR";
break;
}
itemRow.CreateCell(1).SetCellValue(strSaleType);
itemRow.CreateCell(2).SetCellValue(scs.soitem.partNo);
itemRow.CreateCell(3).SetCellValue(scs.soitem.mfg);
itemRow.CreateCell(4).SetCellValue(scs.soitem.rohs == 1 ? "Y" : "N");
itemRow.CreateCell(5).SetCellValue(scs.soitem.dc);
itemRow.CreateCell(6).SetCellValue(scs.soitem.intPartNo);
itemRow.CreateCell(7).SetCellValue(scs.soitem.shipFrom);
itemRow.CreateCell(8).SetCellValue(scs.soitem.shipMethod);
itemRow.CreateCell(9).SetCellValue(scs.soitem.trackingNo);
itemRow.CreateCell(10).SetCellValue(scs.soitem.qty);
itemRow.CreateCell(11).SetCellValue(scs.soitem.qtyshipped);
itemRow.CreateCell(12).SetCellValue(Enum.GetName(typeof(AmbleClient.Currency), scs.soitem.currencyType));
itemRow.CreateCell(13).SetCellValue(scs.soitem.unitPrice);
itemRow.CreateCell(14).SetCellValue(scs.soitem.unitPrice * scs.soitem.qty);
itemRow.CreateCell(15).SetCellValue(scs.soitem.dockDate.ToShortDateString());
if (scs.soitem.shippedDate != null)
{
itemRow.CreateCell(16).SetCellValue(scs.soitem.shippedDate.Value.ToShortDateString());
}
itemRowIndex++;
IRow infoRow = sheet.CreateRow(itemRowIndex);
infoRow.CreateCell(1).SetCellValue("Shipping Instructions >>" + scs.soitem.shippingInstruction);
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(itemRowIndex, itemRowIndex, 1, 16));
itemRowIndex++;
infoRow = sheet.CreateRow(itemRowIndex);
infoRow.CreateCell(1).SetCellValue("Packing Instructions >>" + scs.soitem.packingInstruction);
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(itemRowIndex, itemRowIndex, 1, 16));
itemRowIndex++;
}
}
static void FillThePoSheet(ISheet sheet, po po, List <PoItemContentAndState> poitemList)
{
AmbleClient.Admin.AccountMgr.AccountMgr accMgr = new Admin.AccountMgr.AccountMgr();
sheet.GetRow(0).CreateCell(2).SetCellValue(po.vendorName);
sheet.GetRow(0).CreateCell(9).SetCellValue(po.contact);
if (po.pa != null)
{
sheet.GetRow(0).CreateCell(14).SetCellValue(accMgr.GetNameById((int)po.pa.Value));
}
sheet.GetRow(1).CreateCell(2).SetCellValue(po.vendorNumber);
if (po.poDate != null)
{
sheet.GetRow(1).CreateCell(5).SetCellValue(po.poDate.Value.ToShortDateString());
}
sheet.GetRow(1).CreateCell(9).SetCellValue(po.poNo);
sheet.GetRow(1).CreateCell(14).SetCellValue(po.paymentTerms);
sheet.GetRow(2).CreateCell(2).SetCellValue(po.shipMethod);
sheet.GetRow(2).CreateCell(9).SetCellValue(po.freight);
sheet.GetRow(2).CreateCell(14).SetCellValue(po.shipToLocation);
IRow row = sheet.CreateRow(4);
row.CreateCell(0).SetCellValue(po.billTo);
row.CreateCell(10).SetCellValue(po.shipTo);
int itemRowIndex = 9; int totalQty = 0; float totalTotal = 0; int totalQtyRecd = 0;
foreach (PoItemContentAndState pcs in poitemList)
{
IRow itemRow = sheet.CreateRow(itemRowIndex);
itemRow.CreateCell(0).SetCellValue(poitemList.IndexOf(pcs) + 1);
itemRow.CreateCell(1).SetCellValue(pcs.poItem.partNo);
itemRow.CreateCell(2).SetCellValue(pcs.poItem.mfg);
itemRow.CreateCell(3).SetCellValue(pcs.poItem.dc);
itemRow.CreateCell(4).SetCellValue(pcs.poItem.vendorIntPartNo);
itemRow.CreateCell(5).SetCellValue(pcs.poItem.org);
itemRow.CreateCell(6).SetCellValue(pcs.poItem.qty.Value);
totalQty += pcs.poItem.qty.Value;
if (pcs.poItem.qtyRecd != null)
{
itemRow.CreateCell(7).SetCellValue(pcs.poItem.qtyRecd.Value);
totalQtyRecd += pcs.poItem.qtyRecd.Value;
}
if (pcs.poItem.qtyCorrected != null)
{
itemRow.CreateCell(8).SetCellValue(pcs.poItem.qtyCorrected.Value);
}
if (pcs.poItem.qtyAccept != null)
{
itemRow.CreateCell(9).SetCellValue(pcs.poItem.qtyAccept.Value);
}
if (pcs.poItem.qtyRejected != null)
{
itemRow.CreateCell(10).SetCellValue(pcs.poItem.qtyRejected.Value);
}
if (pcs.poItem.qtyRTV != null)
{
itemRow.CreateCell(11).SetCellValue(pcs.poItem.qtyRTV.Value);
}
if (pcs.poItem.qcPending != null)
{
itemRow.CreateCell(12).SetCellValue(pcs.poItem.qcPending.Value);
}
itemRow.CreateCell(13).SetCellValue(Enum.GetName(typeof(AmbleClient.Currency), pcs.poItem.currency));
itemRow.CreateCell(14).SetCellValue(pcs.poItem.unitPrice.Value);
itemRow.CreateCell(15).SetCellValue(pcs.poItem.qty.Value * pcs.poItem.unitPrice.Value);
totalTotal += pcs.poItem.qty.Value * pcs.poItem.unitPrice.Value;
if (pcs.poItem.dueDate != null)
{
itemRow.CreateCell(16).SetCellValue(pcs.poItem.dueDate.Value.ToShortDateString());
}
if (pcs.poItem.receiveDate != null)
{
itemRow.CreateCell(17).SetCellValue(pcs.poItem.receiveDate.Value.ToShortDateString());
}
itemRow.CreateCell(18).SetCellValue(pcs.poItem.stepCode);
itemRow.CreateCell(19).SetCellValue("Unknown");
itemRowIndex++;
IRow infoRow = sheet.CreateRow(itemRowIndex);
infoRow.CreateCell(1).SetCellValue("Note To Vendor >>" + pcs.poItem.noteToVendor);
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(itemRowIndex, itemRowIndex, 1, 16));
itemRowIndex++;
}
//add total bar
IRow totalRow = sheet.CreateRow(itemRowIndex);
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(itemRowIndex, itemRowIndex, 0, 4));
totalRow.CreateCell(5).SetCellValue("Total");
totalRow.CreateCell(6).SetCellValue(totalQty);
totalRow.CreateCell(7).SetCellValue(totalQtyRecd);
totalRow.CreateCell(15).SetCellValue(totalTotal);
}
public override void FillTheTable(Rfq rfq)
{
base.FillTheTable(rfq);
//Fill the salesId
tbCustomer.Text = rfq.customerName;
//select the sales ID
//获得下级号和名字
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
mySubs = accountMgr.GetAllSubsId(UserInfo.UserId, UserCombine.GetUserCanBeSales());
Dictionary <int, string> mySubsIdAndName = accountMgr.GetIdsAndNames(mySubs);
foreach (string name in mySubsIdAndName.Values)
{
cbSales.Items.Add(name);
}
for (int i = 0; i < mySubs.Count; i++)
{
if (mySubs[i] == rfq.salesId)
{
cbSales.SelectedIndex = i;
break;
}
}
List <int> pAList = new List <int>();
//Fill the PA
if (rfq.firstPA.HasValue)
{
pAList.Add(rfq.firstPA.Value);
}
if (rfq.secondPA.HasValue)
{
pAList.Add(rfq.secondPA.Value);
}
if (pAList.Count > 0)
{
Dictionary <int, string> paIDAndName = accountMgr.GetIdsAndNames(pAList);
if (rfq.firstPA.HasValue && rfq.secondPA.HasValue)
{
cbPrimaryPA.Text = paIDAndName[rfq.firstPA.Value];
cbAltPA.Text = paIDAndName[rfq.secondPA.Value];
}
else if (rfq.firstPA.HasValue)
{
cbPrimaryPA.Text = paIDAndName[rfq.firstPA.Value];
}
else if (rfq.secondPA.HasValue)
{
cbAltPA.Text = paIDAndName[rfq.secondPA.Value];
}
else
{
//error
}
}
}
public override void FillTheTable(AmbleClient.RfqGui.RfqManager.Rfq rfq)
{
base.FillTheTable(rfq);
tbCustomer.Text = rfq.customerName;
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
this.tbContact.Text = string.Empty; //can not be seen by sales Manager
this.tbPhone.Text = string.Empty; //can not be seen by sales Manager.
//Fill the sales
List <int> sales = new List <int>();
sales.Add(rfq.salesId);
cbSales.Items.Add(accountMgr.GetIdsAndNames(sales)[rfq.salesId]);
cbSales.SelectedIndex = 0;
// cbSales.Text = (GlobalRemotingClient.GetAccountMgr().GetIdsAndNames(sales))[rfq.salesId];
//Fill the PA
mySubs = accountMgr.GetAllSubsId(UserInfo.UserId, UserCombine.GetUserCanBeBuyers());
Dictionary <int, string> mySubsIdAndName = accountMgr.GetIdsAndNames(mySubs);
//确认里面的buyer是不是我的下属，如果不是，不能更改。
if (rfq.firstPA.HasValue == false || mySubs.Contains(rfq.firstPA.Value))
{
foreach (string name in mySubsIdAndName.Values)
{
cbPrimaryPA.Items.Add(name);
}
if (rfq.firstPA.HasValue == false)
{
cbPrimaryPA.SelectedIndex = -1;
}
else
{
cbPrimaryPA.SelectedIndex = mySubs.IndexOf(rfq.firstPA.Value);
}
}
else
{
List <int> buyer = new List <int>();
buyer.Add(rfq.firstPA.Value);
cbPrimaryPA.Items.Add(accountMgr.GetIdsAndNames(buyer)[rfq.firstPA.Value]);
cbPrimaryPA.SelectedIndex = 0;
}
if (rfq.secondPA.HasValue == false || mySubs.Contains(rfq.secondPA.Value))
{
foreach (string name in mySubsIdAndName.Values)
{
cbAltPA.Items.Add(name);
}
if (rfq.secondPA.HasValue == false)
{
cbAltPA.SelectedIndex = -1;
}
else
{
cbAltPA.SelectedIndex = mySubs.IndexOf(rfq.secondPA.Value);
}
}
else
{
List <int> buyer = new List <int>();
buyer.Add(rfq.secondPA.Value);
cbAltPA.Items.Add(accountMgr.GetIdsAndNames(buyer)[rfq.secondPA.Value]);
cbAltPA.SelectedIndex = 0;
}
}
private void FillTheIdNameDict()
{
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
idNameDict =accountMgr.GetIdsAndNames(accountMgr.GetAllSubsId(UserInfo.UserId,null));
}
private void FillTheIdNameDict()
{
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
idNameDict = accountMgr.GetIdsAndNames(accountMgr.GetAllSubsId(UserInfo.UserId, null));
}
private void FillThePACombo()
{
AmbleClient.Admin.AccountMgr.AccountMgr accountMgr = new Admin.AccountMgr.AccountMgr();
mysubs = accountMgr.GetAllSubsId(UserInfo.UserId, UserCombine.GetUserCanBeBuyers());
buyerIdsAndNames=accountMgr.GetIdsAndNames(mysubs);
foreach (string buyerName in buyerIdsAndNames.Values)
{
cbPa.Items.Add(buyerName);
}
}
private void FillTheSalesComboBox()
{
AmbleClient.Admin.AccountMgr.AccountMgr accMgr = new Admin.AccountMgr.AccountMgr();
mySubs =accMgr.GetAllSubsId(UserInfo.UserId,UserCombine.GetUserCanBeSales());
Dictionary<int, string> mySubsIdAndName = accMgr.GetIdsAndNames(mySubs);
foreach (string name in mySubsIdAndName.Values)
{
cbSp.Items.Add(name);
}
}
