public ActionResult Create(SupplierTable supplierTable)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
int userid = Convert.ToInt32(Convert.ToString(Session["UserID"]));
supplierTable.UserID = userid;
if (ModelState.IsValid)
{
var find = db.SupplierTables.Where(s => s.SupplierName == supplierTable.SupplierName && s.ContactNo == supplierTable.ContactNo).FirstOrDefault();
if (find == null)
{
db.SupplierTables.Add(supplierTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.Message = "Dostawca jest już zarejestrowany!";
}
}
return(View(supplierTable));
}
private void FormSupplierEdit_Load(object sender, EventArgs e)
{
this.textBoxCredit.Text = "0";
this.textBoxVatRate.Text = "17";
if (!m_isAdd)
{
this.buttonAdd.Enabled = false;
this.buttonSupplierGroup.Enabled = false;
if (m_isEditSupplier)
{
m_supplier = Supplier.getInctance().getSupplierInfoFromPkey(m_supplierPkey);
}
else
{
m_supplierType = SupplierType.getInctance().getSupplierTypeInfoFromPkey(m_supplierGroupPkey);
m_isSupplierGroup = true;
}
setPageActiveState();
setPageActiveValue();
}
// 初始化区域下拉框值
ComboBoxExtend.initComboBox(this.comboBoxArea, "BASE_AREA_LIST");
}
public ActionResult DeleteConfirmed(int id)
{
SupplierTable supplierTable = db.SupplierTables.Find(id);
db.SupplierTables.Remove(supplierTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public virtual SupplierTable convertToSupplierTable(ProjectDBProperties prop)
{
SupplierTable obj = BlankResourceInitializer.createBlankSupplier(null);
obj.DatabaseId = SupplierDatabaseId;
if (DatabaseCreationDate == null)
{
obj.DatabaseCreationDate = 100L; //ResourceUtil.MISSING_DB_CREATE_DATE);
}
else
{
obj.DatabaseCreationDate = DatabaseCreationDate;
}
obj.Address = quotationTable.Address;
obj.Title = quotationTable.CompanyName;
obj.ContactPerson = quotationTable.ContactPerson;
obj.GroupCode = boqItemTable.GroupCode;
obj.GekCode = boqItemTable.GekCode;
obj.Description = boqItemTable.Description;
obj.Notes = boqItemTable.Notes;
obj.EditorId = DatabaseDBUtil.Properties.UserId;
obj.PhoneNumber = quotationTable.PhoneNumber;
obj.MobileNumber = quotationTable.MobileNumber;
obj.Email = quotationTable.Email;
obj.Url = quotationTable.Url;
obj.Country = quotationTable.Country;
obj.City = quotationTable.City;
obj.StateProvince = quotationTable.StateProvince;
obj.GeoLocation = quotationTable.GeoLocation;
obj.FaxNumber = quotationTable.FaxNumber;
obj.Performance = "" + quotationTable.Performance;
obj.ExtraCode1 = boqItemTable.ExtraCode1;
obj.ExtraCode2 = boqItemTable.ExtraCode2;
obj.ExtraCode3 = boqItemTable.ExtraCode3;
obj.ExtraCode4 = boqItemTable.ExtraCode4;
obj.ExtraCode5 = boqItemTable.ExtraCode5;
obj.ExtraCode6 = boqItemTable.ExtraCode6;
obj.ExtraCode7 = boqItemTable.ExtraCode7;
obj.ExtraCode8 = boqItemTable.ExtraCode8;
obj.ExtraCode9 = boqItemTable.ExtraCode9;
obj.ExtraCode10 = boqItemTable.ExtraCode10;
obj.CreateUserId = quotationTable.EditorId;
if (quotationTable.ReceivedDate != null)
{
obj.LastUpdate = quotationTable.ReceivedDate;
obj.CreateDate = quotationTable.ReceivedDate;
}
else
{
obj.LastUpdate = DateTime.Now;
obj.CreateDate = obj.LastUpdate;
}
obj.recalculate();
return(obj);
}
private void buttonSelect_Click(object sender, EventArgs e)
{
FormBaseSupplier fbs = new FormBaseSupplier(true);
fbs.ShowDialog();
m_supplierPkey = fbs.getSelectRecordPkey();
SupplierTable record = Supplier.getInctance().getSupplierInfoFromPkey(m_supplierPkey);
this.textBoxSupplierName.Text = Convert.ToString(record.pkey) + "-" + record.name;
}
private static async Task InsertSupplierAsync(SupplierTable supplierTable)
{
await SupplierEntityBuilder.Create()
.WithId(supplierTable.Id)
.WithName(supplierTable.SupplierName)
.WithSummary(supplierTable.Summary)
.WithSupplierUrl(supplierTable.SupplierUrl)
.WithAddress(supplierTable.Address)
.Build()
.InsertAsync();
}
public ActionResult Edit([Bind(Include = "SupplierID,SupplierName,UserID,ContactNo,Email,Description")] SupplierTable supplierTable)
{
if (ModelState.IsValid)
{
db.Entry(supplierTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", supplierTable.UserID);
return(View(supplierTable));
}
private static async Task InsertSupplierAsync(SupplierTable supplierTable)
{
var organisations = (await OrganisationEntity.FetchAllAsync().ConfigureAwait(false)).ToList();
await SupplierEntityBuilder.Create()
.WithId(supplierTable.Id)
.WithOrganisation(organisations.First(o => o.Name == supplierTable.OrganisationName).Id)
.WithName(supplierTable.Id)
.Build()
.InsertAsync()
.ConfigureAwait(false);
}
private void addSupplier()
{
SupplierTable supplier = new SupplierTable();
// 基本信息-基础信息
supplier.supplierType = m_supplierGroupPkey;
supplier.name = this.textBoxName.Text.ToString();
supplier.nameShort = this.textBoxShortName.Text.ToString();
supplier.mnemonicCode = this.textBoxMnemonicCode.Text.ToString();
if (this.textBoxCredit.Text.ToString().Length == 0)
{
supplier.credit = 0;
}
else
{
supplier.credit = Convert.ToInt32(this.textBoxCredit.Text.ToString());
}
if (this.textBoxVatRate.Text.ToString().Length == 0)
{
supplier.varRate = Convert.ToInt32(this.textBoxVatRate.Text.ToString());
}
else
{
// 增值税税率默认为17%
supplier.varRate = 17;
}
// 基础信息-银行信息
supplier.bankName = this.textBoxBankName.Text.ToString();
supplier.bankAccount = this.textBoxBankAccount.Text.ToString();
supplier.taxAccount = this.textBoxTaxAccount.Text.ToString();
// 联系方式
supplier.area = this.comboBoxArea.Text.ToString();
supplier.contact = this.textBoxContact.Text.ToString();
supplier.tel = this.textBoxTel.Text.ToString();
supplier.fax = this.textBoxFax.Text.ToString();
supplier.homePage = this.textBoxHomePage.Text.ToString();
supplier.email = this.textBoxEmail.Text.ToString();
supplier.address = this.textBoxAddress.Text.ToString();
supplier.zipCode = this.textBoxZipCode.Text.ToString();
supplier.note = this.textBoxNote.Text.ToString();
if (supplier.name.Length == 0)
{
MessageBoxExtend.messageWarning("公司名称不能为空，请重新填写!");
return;
}
Supplier.getInctance().insert(supplier);
}
// GET: SupplierTables/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SupplierTable supplierTable = db.SupplierTables.Find(id);
if (supplierTable == null)
{
return(HttpNotFound());
}
return(View(supplierTable));
}
public void Initialice(string applicationPath, string applicationDataPath)
{
this.m_comLockObj = Guid.NewGuid();
this.m_applicationPath = applicationPath;
this.m_applicationDataPath = applicationDataPath;
this.m_masterData = new Working.MasterData();
this.m_supplier = new Working.Supplier();
this.m_position = new Working.Positions();
this.m_materialCategoryTable = BasicTable.OpenDataTable <MaterialCategoryTable>(applicationDataPath);
this.m_manufacturerTable = BasicTable.OpenDataTable <ManufacturerTable>(applicationDataPath);
this.m_supplierTable = BasicTable.OpenDataTable <SupplierTable>(applicationDataPath);
this.m_positionsTable = BasicTable.OpenDataTable <PositionsTable>(applicationDataPath);
}
// GET: SupplierTables/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SupplierTable supplierTable = db.SupplierTables.Find(id);
if (supplierTable == null)
{
return(HttpNotFound());
}
ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", supplierTable.UserID);
return(View(supplierTable));
}
private void panelPurchaseName_DoubleClick(object sender, EventArgs e)
{
if (!this.textBoxPurchaseName.Visible)
{
this.labelPurchaseName.Visible = false;
this.textBoxPurchaseName.Visible = true;
}
else
{
FormBaseSupplier fbs = new FormBaseSupplier(true);
fbs.ShowDialog();
m_supplierPkey = fbs.getSelectRecordPkey();
SupplierTable record = Supplier.getInctance().getSupplierInfoFromPkey(m_supplierPkey);
this.textBoxPurchaseName.Text = record.name;
this.textBoxPurchaseName.Visible = true;
}
}
// GET: SupplierTables/Details/5
public ActionResult Details(int?id)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SupplierTable supplierTable = db.SupplierTables.Find(id);
if (supplierTable == null)
{
return(HttpNotFound());
}
return(View(supplierTable));
}
public ActionResult Edit(SupplierTable supplierTable)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
int userid = Convert.ToInt32(Convert.ToString(Session["UserID"]));
supplierTable.UserID = userid;
if (ModelState.IsValid)
{
db.Entry(supplierTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", supplierTable.UserID);
return(View(supplierTable));
}
private void noForbid_Click(object sender, EventArgs e)
{
SortedDictionary <int, SupplierTable> forbidSupplierList = Supplier.getInctance().getAllForbidSupplierInfo();
ArrayList forbidSuppliers = new ArrayList();
foreach (KeyValuePair <int, SupplierTable> index in forbidSupplierList)
{
SupplierTable supplier = new SupplierTable();
supplier = index.Value;
forbidSuppliers.Add(Convert.ToString(supplier.pkey));
forbidSuppliers.Add(Convert.ToString(supplier.name));
}
FormNoForbid fnfs = new FormNoForbid(forbidSuppliers, "供应商反禁用", ForbidDataType.Supplier);
fnfs.ShowDialog();
updateDataGridView(getCurrentNodeAllChildNodesSupplier());
}
// GET: SupplierTables/Edit/5
public ActionResult Edit(int?id)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SupplierTable supplierTable = db.SupplierTables.Find(id);
if (supplierTable == null)
{
return(HttpNotFound());
}
ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", supplierTable.UserID);
return(View(supplierTable));
}
private void buttonSelect_Click(object sender, EventArgs e)
{
if (m_userInterfaceValue.isAccountReceivable)
{
FormBaseCustomer fbs = new FormBaseCustomer(true);
fbs.ShowDialog();
m_selectRecordPkey = fbs.getSelectRecordPkey();
CustomerTable record = Customer.getInctance().getCustomerInfoFromPkey(m_selectRecordPkey);
this.textBoxName.Text = Convert.ToString(record.pkey) + "-" + record.name;
}
else
{
FormBaseSupplier fbs = new FormBaseSupplier(true);
fbs.ShowDialog();
m_selectRecordPkey = fbs.getSelectRecordPkey();
SupplierTable record = Supplier.getInctance().getSupplierInfoFromPkey(m_selectRecordPkey);
this.textBoxName.Text = Convert.ToString(record.pkey) + "-" + record.name;
}
}
private void panelSourceOrderNumber_Click(object sender, EventArgs e)
{
if (comboBoxPaymentType.Text.IndexOf("应付") != -1)
{
FormInitAccountReceivabler fiar = new FormInitAccountReceivabler(false, true);
fiar.ShowDialog();
m_supplierData = Supplier.getInctance().getSupplierInfoFromPkey(fiar.getCustomerOrSupplierID());
this.textBoxSourceOrderNumber.Text = m_supplierData.name;
this.textBoxSourceOrderNumber.ReadOnly = true;
}
else if (comboBoxPaymentType.Text.IndexOf("采购入库") != -1)
{
FormPurchaseOrderSequence fpos = new FormPurchaseOrderSequence(FormPurchaseOrderSequence.OrderType.PurchaseIn, true);
fpos.ShowDialog();
this.textBoxSourceOrderNumber.Text = fpos.getSelectOrderNumber();
}
else
{
this.textBoxSourceOrderNumber.Text = "";
}
}
private void updateDataGridView(SortedDictionary <int, SupplierTable> supplierList)
{
m_supplierRecordCount = supplierList.Count;
this.labelSupplierGroupName.Text = "[" + m_supplierGroupName + "]供应商共计[" + Convert.ToString(m_supplierRecordCount) + "]条记录";
SortedDictionary <int, ArrayList> suppliers = new SortedDictionary <int, ArrayList>();
for (int i = 0; i < supplierList.Count; i++)
{
SupplierTable supplier = new SupplierTable();
supplier = (SupplierTable)supplierList[i];
ArrayList temp = new ArrayList();
temp.Add(supplier.pkey);
temp.Add(supplier.supplierType);
temp.Add(supplier.name);
temp.Add(supplier.nameShort);
temp.Add(supplier.mnemonicCode);
temp.Add(supplier.area);
temp.Add(supplier.credit);
temp.Add(supplier.varRate);
temp.Add(supplier.contact);
temp.Add(supplier.tel);
temp.Add(supplier.fax);
temp.Add(supplier.mobilePhone);
temp.Add(supplier.email);
temp.Add(supplier.homePage);
temp.Add(supplier.address);
temp.Add(supplier.zipCode);
temp.Add(supplier.bankName);
temp.Add(supplier.bankAccount);
temp.Add(supplier.taxAccount);
temp.Add(supplier.note);
suppliers.Add(i, temp);
}
m_dataGridViewExtend.initDataGridViewData(suppliers, 3);
}
private SortedDictionary <int, SupplierTable> getCurrentNodeAllChildNodesSupplier()
{
SortedDictionary <int, SupplierTable> supplierList = new SortedDictionary <int, SupplierTable>();
SortedDictionary <int, int> childNodeValues = SupplierOrgStruct.getInctance().getAllChildNodeValue(m_supplierGroupPkey);
if (!childNodeValues.ContainsKey(m_supplierGroupPkey))
{
childNodeValues.Add(m_supplierGroupPkey, m_supplierGroupPkey);
}
foreach (KeyValuePair <int, int> index in childNodeValues)
{
SortedDictionary <int, SupplierTable> temp = Supplier.getInctance().getSupplierInfoFromSupplierType(index.Value);
foreach (KeyValuePair <int, SupplierTable> i in temp)
{
SupplierTable supplier = new SupplierTable();
supplierList.Add(supplierList.Count, (SupplierTable)i.Value);
}
}
return(supplierList);
}
public SupplierViewModel()
{
DisplayName = null;
Address = null;
Phone = null;
ContractDay = DateTime.Today;
loadUserCurrentLogin();
ListSupplier = new List <SupplierTable>(DataProvider.Ins.Entities.SupplierTable);
LoadEditCommand = new RelayCommand <object>((p) => { return(true); }, (p) => { LoadDialogAccountEdit(); });
AddCommand = new RelayCommand <object>((p) =>
{
var Supplier = DataProvider.Ins.Entities.SupplierTable.Where(x => x.DisplayName == DisplayName);
if (string.IsNullOrEmpty(DisplayName) || string.IsNullOrEmpty(Phone) || string.IsNullOrEmpty(Address) || ContractDay == null)
{
return(false);
}
if (Supplier.Count() != 0 || Supplier == null)
{
return(false);
}
return(true);
},
(p) =>
{
var newSupplier = new SupplierTable();
newSupplier.DisplayName = DisplayName;
newSupplier.Address = Address;
newSupplier.Phone = Phone;
newSupplier.ContractDay = ContractDay;
DataProvider.Ins.Entities.SupplierTable.Add(newSupplier);
DataProvider.Ins.Entities.SaveChanges();
ListSupplier = new List <SupplierTable>(DataProvider.Ins.Entities.SupplierTable);
DisplayName = null;
Address = null;
Phone = null;
ContractDay = DateTime.Today;
SelectedItems = null;
IsActiveSnackBar = true;
Message = "Thêm Thành Công!";
System.Timers.Timer timer = new System.Timers.Timer();
timer.Interval = 3000;
timer.Enabled = true;
timer.Elapsed += ShowSnackBar;
timer.Start();
});
ConfirmEditCommand = new RelayCommand <Button>((p) =>
{
var Supplier = DataProvider.Ins.Entities.SupplierTable.Where(x => x.DisplayName == DisplayName);
if (string.IsNullOrEmpty(DisplayName) || string.IsNullOrEmpty(Phone) || string.IsNullOrEmpty(Address) || ContractDay == null)
{
return(false);
}
if (Supplier == null || SelectedItems == null)
{
return(false);
}
return(true);
},
(p) =>
{
SupplierTable EditItem = DataProvider.Ins.Entities.SupplierTable.Where(x => x.ID == SelectedItems.ID).SingleOrDefault();
if (EditItem == null)
{
return;
}
EditItem.DisplayName = DisplayName;
EditItem.Address = Address;
EditItem.ContractDay = ContractDay;
EditItem.Phone = Phone;
DataProvider.Ins.Entities.SaveChanges();
ListSupplier = new List <SupplierTable>(DataProvider.Ins.Entities.SupplierTable);
DisplayName = null;
Address = null;
Phone = null;
ContractDay = DateTime.Today;
SelectedItems = null;
IsActiveSnackBar = true;
Message = "Sửa Thành Công!";
DialogHost.CloseDialogCommand.Execute(null, null);
System.Timers.Timer timer = new System.Timers.Timer();
timer.Interval = 3000;
timer.Enabled = true;
timer.Elapsed += ShowSnackBar;
timer.Start();
});
DeleteCommand = new RelayCommand <object>((p) =>
{
var Supplier = DataProvider.Ins.Entities.SupplierTable.Where(x => x.DisplayName == DisplayName);
if (string.IsNullOrEmpty(DisplayName) || string.IsNullOrEmpty(Phone) || string.IsNullOrEmpty(Address) || ContractDay == null)
{
return(false);
}
if (Supplier == null || SelectedItems == null)
{
return(false);
}
return(true);
},
(p) =>
{
SupplierTable DeleteItem = DataProvider.Ins.Entities.SupplierTable.Where(x => x.ID == SelectedItems.ID).SingleOrDefault();
var listProduct = DataProvider.Ins.Entities.ProductTable.Where(x => x.ID_Supplier == SelectedItems.ID);
if (DeleteItem == null)
{
return;
}
if (listProduct.Count() > 0)
{
DisplayName = null;
Address = null;
Phone = null;
ContractDay = DateTime.Today;
SelectedItems = null;
LoadDialogErrorDelete();
return;
}
DataProvider.Ins.Entities.SupplierTable.Remove(DeleteItem);
DataProvider.Ins.Entities.SaveChanges();
ListSupplier = new List <SupplierTable>(DataProvider.Ins.Entities.SupplierTable);
DisplayName = null;
Address = null;
Phone = null;
ContractDay = DateTime.Today;
SelectedItems = null;
IsActiveSnackBar = true;
Message = "Xóa Thành Công!";
System.Timers.Timer timer = new System.Timers.Timer();
timer.Interval = 3000;
timer.Enabled = true;
timer.Elapsed += ShowSnackBar;
timer.Start();
});
SearchCommand = new RelayCommand <object>((p) =>
{
return(true);
},
(p) =>
{
if (SearchTerm == null)
{
return;
}
ListSupplier = new List <SupplierTable> (DataProvider.Ins.Entities.SupplierTable.Where(
x => x.DisplayName.ToLower().Contains(SearchTerm) ||
x.Address.ToLower().Contains(SearchTerm) || x.ContractDay.ToString().ToLower().Contains(SearchTerm) ||
x.Phone.ToLower().Contains(SearchTerm)
));
});
EditCommand = new RelayCommand <object>((p) =>
{
return(true);
},
(p) =>
{
LoadDialogEdit();
});
}
