protected PurchaseBill CopyBill(PurchaseBill toCopy)
{
var list = new List <PurchaseItem>();
foreach (var item in toCopy.Items)
{
list.Add(new PurchaseItem()
{
PurchaseItemID = item.PurchaseItemID,
PurchaseID = item.PurchaseID,
ProductID = item.ProductID,
ProductName = item.ProductName,
Unit = item.Unit,
UnitPrice = item.UnitPrice,
Quantity = item.Quantity,
Description = item.Description,
});
}
return(new PurchaseBill()
{
PurchaseID = toCopy.PurchaseID,
BillDate = toCopy.BillDate,
BillCode = toCopy.BillCode,
SupplierID = toCopy.SupplierID,
SupplierName = toCopy.SupplierName,
Description = toCopy.Description,
Items = list,
});
}
private void cbSearch_SelectedIndexChanged(object sender, EventArgs e)
{
//查询时 根据选择的查询条件 设置相应的控件的属性
if (cbSearch.SelectedIndex == 4)
{
txtSearch.Enabled = false;
dtBeginTime.Enabled = true;
dtEndTime.Enabled = true;
}
else
{
txtSearch.Enabled = true;
dtBeginTime.Enabled = false;
dtEndTime.Enabled = false;
}
//选择不同的查询条件时 清空相应的值
lbPurChaseID.DataSource = null;
bill = null;
idList = null;
dgPurchaseDetaillInfo.DataSource = null;
txtSearch.Text = "";
txtStockDate.Text = "";
txtOnProcess.Text = "";
txtMemo.Text = "";
txtPurchaseID.Text = "";
txtTotalPrice.Text = "";
lbPurChaseID.Enabled = true;
}
public string InsertPurchaseBill(PurchaseBill objPurchaseBill)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction trn = connection.BeginTransaction();
try
{
var internalId = DatabaseCommonRepository.GetNewDocNo(connection, objPurchaseBill.OrganizationId, 32, true, trn);
objPurchaseBill.PurchaseBillRefNo = internalId;
var id = _InsertPurchaseBill(objPurchaseBill, connection, trn);
InsertLoginHistory(dataConnection, objPurchaseBill.CreatedBy, "Create", "Purchase Bill", id.ToString(), "0");
trn.Commit();
return id + "|" + internalId;
}
catch (Exception)
{
trn.Rollback();
return "0";
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
op = Operation.Insert;
try
{
//命令按钮的控制（7个按钮）
btnAdd.Enabled = btnRevoke.Enabled = btnModify.Enabled = false;
btnSave.Enabled = btnConcel.Enabled = true;
btnAddDetail.Enabled = btnDeleteDetail.Enabled = true;
//订单信息控件的控制（6个控件）
dtPurchaseDate.Enabled = true;
cbSupplierID.Enabled = true;
txtMemo.Enabled = true;
txtOnProcess.Enabled = txtStockDate.Enabled = txtPurchaseID.Enabled = false;
//列表框的控制（1个控制）
lbPurchaseID.Enabled = false;
//DataGridView列的控制（2列）
dgPurchaseBill.Columns[3].ReadOnly = false;
dgPurchaseBill.Columns[4].ReadOnly = false;
//查询控件的控制（分组框的控制）
gbSelect.Enabled = false;
pBill = new PurchaseBill(); //初始化订单
detailList = new List <PurchaseDetail>(); //初始化明细列表
ClearControls();
}
catch
{
}
}
public ActionResult Create()
{
double? automaticNumbering;
PurchaseBill purchaseBill = new PurchaseBill();
ViewBag.SupplierId = new SelectList(_dbContext.Suppliers, "Id", "AccountName");
var automaticInvoiceForm = _dbContext.AutomaticInvoiceForm.Where(a => a.Type == "Purchase").FirstOrDefault();
if (automaticInvoiceForm != null)
{
if (automaticInvoiceForm.AutomaticPurchaseInvoice == true)
{
double?Count = _dbContext.PurchaseBills.Count();
if (Count != 0)
{
automaticNumbering = automaticInvoiceForm.Numbering + Count + 1;
purchaseBill.BillInvoice = automaticInvoiceForm.Prefix + automaticNumbering.ToString() + automaticInvoiceForm.Suffix;
}
else
{
automaticNumbering = automaticInvoiceForm.Numbering + 1;
purchaseBill.BillInvoice = automaticInvoiceForm.Prefix + automaticNumbering.ToString() + automaticInvoiceForm.Suffix;
}
}
}
else
{
}
return(View(purchaseBill));
}
public void InsertTest()
{
//有效的
PurchaseBill p = new PurchaseBill();
p.PurchaseID = "20160130001";
p.SupplierID = "0";
p.PurchaseDate = Convert.ToDateTime("2015-05-06");
p.StockDate = new DateTime();
p.Clerk = "1";
p.Examiner = "2";
p.Custodian = "3";
p.OnProcess = 0;
p.Memo = "哈哈哈";
List <PurchaseDetail> pdd = new List <PurchaseDetail>();
PurchaseDetail pd = new PurchaseDetail();
pd.PurchaseID = "20160130001";
pd.PurchaseDetailID = 1;
pd.ProductID = "0002";
pd.PurchasePrice = 2;
pd.Quantity = 100;
pdd.Add(pd);
p.DetailList = pdd;
PurchaseBillDAL target = new PurchaseBillDAL();
bool atual = target.Insert(p); //实际的结果
bool expected = true; //预期的结果
Assert.AreEqual(expected, atual); //断言判等
}
public ActionResult DeleteConfirmed(Guid id)
{
PurchaseBill purchaseBill = _dbContext.PurchaseBills.Find(id);
_dbContext.PurchaseBills.Remove(purchaseBill);
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
protected override bool Create()
{
var bl = new PurchaseBillBL();
this.Current = bl.Create();
this.Original = CopyBill(this.Current);
return(this.Current != null);
}
public DetailPurchaseBillUserControl(PurchaseBill purchaseBill)
{
InitializeComponent();
this.purchaseBill = purchaseBill;
this.DataContext = purchaseBill;
DataGrid_PurchaseBillDetail.DataContext = purchaseBill.PurchaseBillDetails;
DataGrid_PurchaseBillDetail.ItemsSource = purchaseBill.PurchaseBillDetails;
}
public EditPurchaseBillUserControl(PurchaseBill purchaseBill)
{
InitializeComponent();
_purchaseBillBusiness = new PurchaseBillBusiness();
_supplierBusiness = new SupplierBusiness();
this.purchaseBillViewModel = new PurchaseBillViewModel(purchaseBill);
InitializeData();
}
protected override bool GetByID(int id)
{
var bl = new PurchaseBillBL();
this.Current = bl.GetByID(id);
this.Original = CopyBill(this.Current);
return(this.Current != null);
}
//D
public ResultMessage Delete(PurchaseBill toDelete)
{
var rm = _checkBalanceDate(toDelete.BillDate);
if (rm.Result)
{
rm.Result = _da.Delete(toDelete) > 0;
}
return(rm);
}
public ActionResult Create(IList <PendingGRN> PendingGRNSelected)
{
FillAdditionDeduction();
FillCurrency();
PurchaseBill purchasebill = new PurchaseBill();
PurchaseBillRepository rep = new PurchaseBillRepository();
if (PendingGRNSelected != null)
{
if (PendingGRNSelected.Count > 0)
{
List <int> selectedgrn = (from PendingGRN p in PendingGRNSelected
where p.Select
select p.GRNId).ToList <int>();
purchasebill = rep.GetGRNHeadData(selectedgrn);
purchasebill.Items = rep.GetGRNItems(selectedgrn);
purchasebill.SupplyOrderNo = rep.GetSupplyOrderNos(selectedgrn).SupplyOrderNo;
}
}
string internalId = "";
try
{
internalId = DatabaseCommonRepository.GetNextDocNo(32, OrganizationId);
}
catch (NullReferenceException nx)
{
TempData["success"] = "";
TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message;
}
catch (Exception ex)
{
TempData["success"] = "";
TempData["error"] = "Some error occurred. Please try again.|" + ex.Message;
}
try
{
purchasebill.PurchaseBillRefNo = internalId;
purchasebill.Supplier = PendingGRNSelected[0].SupplierName;
purchasebill.SupplierId = PendingGRNSelected[0].SupplierId;
purchasebill.PurchaseBillDate = System.DateTime.Today;
purchasebill.PurchaseBillDueDate = rep.GetBillDueDate(PendingGRNSelected[0].SupplierId).PurchaseBillDueDate;
purchasebill.CurrencyId = new SupplierRepository().GetSupplierCurrency(PendingGRNSelected[0].SupplierId).CurrencyId;
//purchasebill.CurrencyId = new CurrencyRepository().GetCurrencyFrmOrganization(OrganizationId).CurrencyId;
return(View(purchasebill));
}
catch (Exception)
{
TempData["error"] = "Some required data was missing. Please try again.";
return(RedirectToAction("Index"));
}
}
public async Task <IActionResult> Create(int?id)
{
string CompId = User.Claims.Where(r => r.Type == "CompanyID").FirstOrDefault().Value;
int CompID = Convert.ToInt32(CompId);
if (id == null)
{
return(NotFound());
}
PurchaseReturnVM model = new PurchaseReturnVM();
PurchaseBill purchaseBill = new PurchaseBill();
purchaseBill = await _context.PurchaseBill.Where(r => r.CompanyID == CompID).Include(r => r.Parties).FirstOrDefaultAsync(m => m.PurchaseBillID == id);
if (purchaseBill == null)
{
return(NotFound());
}
model.TLandingExpenses = purchaseBill.TLandingExpenses;
model.PurchaseImport = purchaseBill.PurchaseImport;
model.PurchaseBillID = purchaseBill.PurchaseBillID;
model.BillDate_OldBill = purchaseBill.BillDate.ToString("d");
model.ContactNumber_OldBill = purchaseBill.ContactNumber;
model.ContactPerson_OldBill = purchaseBill.ContactPerson;
model.GrossTotal_OldBill = purchaseBill.GrossTotal;
model.NetAmount_OldBill = purchaseBill.NetAmount;
if (purchaseBill.PartiesID == null)
{
model.PartiesID = null;
model.PR_S_1 = "Cash Purchase";
}
else
{
model.PartiesID = purchaseBill.PartiesID;
model.PR_S_1 = purchaseBill.Parties.PartyName;
}
model.Remarks_OldBill = purchaseBill.Remarks;
model.TDiscount_OldBill = purchaseBill.TDiscount;
model.TotalQuantity_OldBill = purchaseBill.TotalQuantity;
model.PurchaseBillItem_List = _context.PurchaseBillItem.Include(r => r.Item).Where(r => r.PurchaseBillID == id).ToList();
ViewData["Ids"] = _context.Bank.Select(m => m.BankID).ToList();
ViewData["Name"] = _context.Bank.Select(m => m.BankName).ToList();
ViewData["BankID"] = new SelectList(_context.Bank.Where(r => r.CompanyID == CompID), "BankID", "BankName");
ViewData["CurrencyID"] = new SelectList(_context.Currency.Where(r => r.CompanyID == CompID), "CurrencyID", "CurrencyName", purchaseBill.CurrencyID);
//ViewData["PartiesID"] = new SelectList(_context.Parties, "PartiesID", "PartyName", purchaseBill.PartiesID);
ViewData["ItemID"] = new SelectList(_context.Item.Where(r => r.CompanyID == CompID), "ItemID", "ItemID");
ViewData["PartiesID"] = new SelectList(_context.Parties.Where(r => r.CompanyID == CompID), "PartiesID", "PartyName");
ViewData["PurchaseBillID"] = new SelectList(_context.PurchaseBill.Where(r => r.CompanyID == CompID), "PurchaseBillID", "PurchaseBillNo");
return(View(model));
}
//U
public ResultMessage Insert(PurchaseBill toInsert, out int newID)
{
newID = 0;
var rm = _checkBalanceDate(toInsert.BillDate);
if (rm.Result)
{
rm.Result = _da.Insert(toInsert, out newID) > 0;
}
return(rm);
}
protected override bool SelectItem()
{
var item = dataGridView1.CurrentRow.DataBoundItem;
if (item is PurchaseBill)
{
this.Selected = (item as PurchaseBill);
return(true);
}
return(false);
}
public ActionResult Edit([Bind(Include = "Id,BillInvoice,BillDate,SupplierId,SupplierInvoice,Freight,Packaging,OtherExpenses")] PurchaseBill purchaseBill)
{
if (ModelState.IsValid)
{
_dbContext.Entry(purchaseBill).State = EntityState.Modified;
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SupplierId = new SelectList(_dbContext.Suppliers, "Id", "AccountName", purchaseBill.SupplierId);
return(View(purchaseBill));
}
public void GenerateBill(object sender, RoutedEventArgs e)
{
// MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
Button b = sender as Button;
Sale sale = b.CommandParameter as Sale;
Log.Info("Before: generate bill call from ShowPurchase");
Log.Info("Request to salesbill for report");
PurchaseBill rpt = new PurchaseBill(sale.PurchaseBill);
rpt.ShowDialog();
Log.Info("After: generate bill call, from ShowPurchase");
}
public ActionResult Create([Bind(Include = "Id,BillInvoice,BillDate,SupplierId,SupplierInvoice")] PurchaseBill purchaseBill)
{
if (ModelState.IsValid)
{
purchaseBill.Id = Guid.NewGuid();
_dbContext.PurchaseBills.Add(purchaseBill);
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SupplierId = new SelectList(_dbContext.Suppliers, "Id", "AccountName", purchaseBill.SupplierId);
return(View(purchaseBill));
}
public ResultMessage Update(PurchaseBill original, PurchaseBill toUpdate)
{
var rm = _checkBalanceDate(original.BillDate);
if (rm.Result)
{
rm = _checkBalanceDate(toUpdate.BillDate);
if (rm.Result)
{
rm.Result = _da.Update(original, toUpdate) > 0;
}
}
return(rm);
}
public ActionResult Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseBill purchaseBill = _dbContext.PurchaseBills.Find(id);
if (purchaseBill == null)
{
return(HttpNotFound());
}
return(View(purchaseBill));
}
public ActionResult Edit(PurchaseBill model)
{
ViewBag.Title = "Edit";
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
FillAdditionDeduction();
FillCurrency();
var repo = new PurchaseBillRepository();
//var result1 = new PurchaseBillRepository().CHECK(model.SupplyOrderId);
//if (result1 > 0)
//{
// TempData["error"] = "Sorry!!..Already Used!!";
// TempData["PurchaseRequestNo"] = null;
// return View("Edit", model);
//}
//else
{
try
{
//var result2 = new PurchaseBillRepository().DeletePuchaseBillDT(model.PurchaseBillId);
//var result3 = new PurchaseBillRepository().DeletePuchaseBillHD(model.PurchaseBillId, UserID.ToString());
//string id = new PurchaseBillRepository().InsertPurchaseBill(model);
int output = new PurchaseBillRepository().UpdatePurchaseBill(model);
TempData["success"] = "Updated successfully. (" + model.PurchaseBillRefNo + ")";
TempData["error"] = "";
return(RedirectToAction("PurchaseBillList"));
}
catch (SqlException sx)
{
TempData["error"] = "Some error occured while connecting to database. Please check your network connection and try again.|" + sx.Message;
}
catch (NullReferenceException nx)
{
TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message;
}
catch (Exception ex)
{
TempData["error"] = "Some error occured. Please try again.|" + ex.Message;
}
return(View(model));
}
}
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseBill purchaseBill = _dbContext.PurchaseBills.Find(id);
if (purchaseBill == null)
{
return(HttpNotFound());
}
ViewBag.SupplierId = new SelectList(_dbContext.Suppliers, "Id", "AccountName", purchaseBill.SupplierId);
return(View(purchaseBill));
}
public PurchaseBill MapToPuchaseBill()
{
PurchaseBill purchaseBill = new PurchaseBill()
{
PurchaseBillId = this.PurchaseBillId,
SupplierId = this.SupplierId,
Discount = this.Discount,
Note = this.Note,
VAT = this.VAT,
TotalMoney = this.TotalMoney,
CreatedDate = this.CreatedDate,
StaffId = this.StaffId
};
return(purchaseBill);
}
public static void Chain()
{
PurchaseBill bill = new PurchaseBill()
{
BilNo = "CGDD001",
MaterialName = "惠普电脑",
Qty = 50,
Price = 5000,
BillMaker = new Purchaser("采购员--小张")
};
Console.WriteLine($"创建采购申请单：{bill.BilNo};申请购买{bill.Qty}台{bill.MaterialName}");
bill.BillMaker.HandleBill(bill);
Console.ReadLine();
}
public DateTime GetDueDate(DateTime d, int sup)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
var param = new DynamicParameters();
//PurchaseBill PurchaseBill = connection.Query<PurchaseBill>("select (d+CreditPeriod) PurchaseBillDueDate FROM Supplier WHERE SupplierId= " + sup).FirstOrDefault();
PurchaseBill PurchaseBill = connection.Query<PurchaseBill>(
"select DATEADD(day,CreditPeriod,@date) PurchaseBillDueDate FROM Supplier WHERE SupplierId= " + sup,
new { date = d }).Single<PurchaseBill>();
DateTime duedate = System.DateTime.Today;
if (PurchaseBill != null)
{
duedate = PurchaseBill.PurchaseBillDueDate;
}
return duedate;
}
}
public void FindByIDTest()
{
PurchaseBillDAL pdal = new PurchaseBillDAL();
PurchaseBill list = pdal.FindByID("201706010001");
Assert.IsNotNull(list);
Assert.IsNull(pdal.FindByID("2165321010"));
Assert.AreEqual("201706010001", list.PurchaseID);
Assert.AreEqual(Convert.ToDateTime("2018.10.1"), list.PurchaseDate);
Assert.AreEqual("1", list.Clerk);
Assert.AreEqual(3, list.DetailList.Count);
//从明细列表中取出一行明细进行测试
PurchaseDetail pDetail = list.DetailList[0];
Assert.AreEqual("1", pDetail.PurchaseDetailID);
Assert.AreEqual(Convert.ToDecimal(3), pDetail.PurchasePrice);
Assert.AreEqual("10", pDetail.Quantity);
}
public ActionResult Save(PurchaseBill model)
{
try
{
if (ModelState.IsValid)
{
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
string id = new PurchaseBillRepository().InsertPurchaseBill(model);
if (id.Split('|')[0] != "0")
{
TempData["success"] = "Saved successfully. Purchase Bill Reference No. is " + id.Split('|')[1];
TempData["error"] = "";
return(RedirectToAction("Index"));
}
else
{
throw new Exception();
}
}
else
{
var allErrors = ModelState.Values.SelectMany(v => v.Errors);
}
}
catch (SqlException sx)
{
TempData["error"] = "Some error occured while connecting to database. Please check your network connection and try again.|" + sx.Message;
}
catch (NullReferenceException nx)
{
TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message;
}
catch (Exception ex)
{
TempData["error"] = "Some error occured. Please try again.|" + ex.Message;
}
FillAdditionDeduction();
FillCurrency();
return(View("Create", model));
}
private void guna2Button1_Click(object sender, EventArgs e)
{
if (DateTime.Now > Program.expdate)
{
Trialform tf = new Trialform();
tf.Show();
}
else
{
//this.Controls.Clear();
PurchaseBill PB = new PurchaseBill();
PB.TopLevel = false;
// PB.AutoScroll = true;
this.Controls.Add(PB);
PB.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
PB.Dock = DockStyle.Fill;
PB.Show();
// PB.BringToFront();
}
}
public PurchaseBillViewModel(PurchaseBill purchaseBill)
{
this.PurchaseBillId = purchaseBill.PurchaseBillId;
this.SupplierId = purchaseBill.SupplierId;
this.Account = purchaseBill.Account;
this.VAT = purchaseBill.VAT;
this.Discount = purchaseBill.Discount;
this.Note = purchaseBill.Note;
//this.TotalMoney = purchaseBill.TotalMoney;
this.CreatedDate = purchaseBill.CreatedDate;
this.StaffId = purchaseBill.StaffId;
if (purchaseBill.PurchaseBillDetails != null)
{
foreach (var item in purchaseBill.PurchaseBillDetails)
{
var purchaseBillVM = new PurchaseBillDetailViewModel(item);
this.PurchaseBillDetailViewModels.Add(purchaseBillVM);
}
}
}
