private void button1_Click(object sender, EventArgs e)
{
purchase p = new purchase();
List <rawmaterial> rs = new List <rawmaterial>();
rs = p.find_all1();
Console.Write(rs);
foreach (rawmaterial r1 in rs)
{
Console.Write(r1.Id);
}
}
public purchase newpurchase(int supplierid, string userid)
{
purchase po = new purchase();
po.supplierId = supplierid;
po.purchaseDate = DateTime.Today.Date;
po.expectedDeliveryDate = DateTime.Today.Date.AddDays(14);
po.status = "waiting";
po.userId = userid;
ctx.purchases.Add(po);
ctx.SaveChanges();
return(po);
}
public async Task <ActionResult> Edit([Bind(Include = "username,product,creditcardnumber,dateOfPurchase,dealID")] purchase purchase)
{
if (ModelState.IsValid)
{
db.Entry(purchase).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.creditcardnumber = new SelectList(db.paymentoptions, "creditcardnumber", "creditcardcompany", purchase.creditcardnumber);
ViewBag.product = new SelectList(db.products, "product1", "type", purchase.product);
ViewBag.username = new SelectList(db.users, "username", "password", purchase.username);
return(View(purchase));
}
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
purchase purchase = await db.purchases.FindAsync(id);
if (purchase == null)
{
return(HttpNotFound());
}
return(View(purchase));
}
// GET: purchases/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
purchase purchase = db.purchases.Find(id);
if (purchase == null)
{
return(HttpNotFound());
}
return(View(purchase));
}
public ActionResult Edit([Bind(Include = "Purchase_Id,Purchase_Name,Product_Id,Company_Id,Category_Id,Purchase_Date,Quantity,Pay_Id")] purchase purchase)
{
if (ModelState.IsValid)
{
db.Entry(purchase).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Category_Id = new SelectList(db.categories, "Category_Id", "Category_Name", purchase.Category_Id);
ViewBag.Company_Id = new SelectList(db.companies, "Company_Id", "Company_Name", purchase.Company_Id);
ViewBag.Pay_Id = new SelectList(db.pays, "pay_Id", "Value", purchase.Pay_Id);
ViewBag.Product_Id = new SelectList(db.products, "Product_Id", "Product_Name", purchase.Product_Id);
return(View(purchase));
}
//
public void formorder(User u)
{
var n = from a in ctx.items
where (a.balance < a.reorderlevel) && (a.status == "stockout")
from c in ctx.item_supplier
where a.itemId == c.itemId
from b in ctx.suppliers
where b.supplierId == c.supplierId && (c.priority == 1)
select b;
var d = from a in ctx.items
where (a.balance < a.reorderlevel) && (a.status == "stockout")
from c in ctx.item_supplier
where a.itemId == c.itemId
from b in ctx.suppliers
where b.supplierId == c.supplierId && (c.priority == 1)
select c;
List <supplier> s = n.ToList();
List <item_supplier> ls = d.ToList();
foreach (supplier x in s)
{
purchase po = new purchase();
po.supplierId = x.supplierId;
po.purchaseDate = DateTime.Today.Date;
po.userId = u.UserId;
po.expectedDeliveryDate = DateTime.Today.Date.AddDays(14);
po.status = "waiting";
ctx.purchases.Add(po);
ctx.SaveChanges();
foreach (item_supplier i in ls)
{
if (i.supplierId == x.supplierId)
{
var y = from a in ctx.items
where a.itemId == i.itemId
select a;
item item = y.SingleOrDefault();
item.status = "ordering";
purchase_item pitem = new purchase_item();
pitem.purchaseId = po.purchaserId;
pitem.itemId = i.itemId.Value;
pitem.requestQty = item.reorderlevel;
pitem.supplierid = po.supplierId;
ctx.purchase_item.Add(pitem);
ctx.SaveChanges();
}
}
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
if (!filledValues())
{
//MessageBox.Show("Complete la información");
}
else
{
//serviceDA = new DBControllerWSClient();
purchase p = new purchase();
p.state = 1;
p.serialCode = txtSerialCode.Text;
p.totalPurchase = float.Parse(txtTotal.Text);
//para el supplier
supplier c = new supplier();
serviceDA = new DBControllerWSClient();
c = serviceDA.querySupplierByCode(txtIdProv.Text);
p.supplier = c;
//para los purchase lanes
purchaseLane[] salelanes;
salelanes = new purchaseLane[dgvPurchaseDetails.RowCount - 1];
for (int i = 0; i < dgvPurchaseDetails.RowCount - 1; i++)
{
purchaseLane purchaselane = new purchaseLane();
purchaselane.subtotal = float.Parse(dgvPurchaseDetails.Rows[i].Cells[4].Value.ToString());
purchaselane.quantity = int.Parse(dgvPurchaseDetails.Rows[i].Cells[3].Value.ToString());
//purchaselane.purchase = p;
product pr = new product();
pr = serviceDA.queryProductBySKUCode(dgvPurchaseDetails.Rows[i].Cells[0].Value.ToString());
purchaselane.product = pr;
salelanes[i] = purchaselane;
}
p.currency = "Soles";
p.purchaseLanes = salelanes;
//Cursor.Current = Cursors.WaitCursor;
int salio = serviceDA.insertPurchase(p);
if (salio == 1)
{
MessageBox.Show("Se ingresó la compra correctamente");
}
else
{
MessageBox.Show("¡Hubo un problema!");
}
//Cursor.Current = Cursors.Arrow;
this.Close();
}
}
protected void Confirm_Click(object sender, EventArgs e)
{
try
{
purchase s = (purchase)Session["purchaseitem"];
string description = Itemchoose.SelectedValue;
int itemcode = pl.finditemcode(description, s.supplierId);
int qt = Convert.ToInt32(itemnumber.Text);
pl.additems(itemcode, s.supplierId, s.purchaserId, qt);
Response.Redirect("Purchaseitems.aspx");
}
catch
{
s.Text = "Number Validation not Pass!";
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
User u = (User)Session["UserEntity"];
int itemcode = Convert.ToInt32(e.CommandArgument);
string k = GridView1.Rows[itemcode].Cells[1].Text;
string l = GridView1.Rows[itemcode].Cells[3].Text;
itemcode = Convert.ToInt32(k);
int quantity = Convert.ToInt32(l);
int supplierid = pl.findsupplier(itemcode);
purchase s = pl.newpurhcase(supplierid, u.UserId);
pl.additems(itemcode, supplierid, s.purchaserId, quantity);
Session["purchaseitem"] = s;
Response.Redirect("Purchaseitems.aspx");
}
// GET: purchases/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
purchase purchase = db.purchases.Find(id);
if (purchase == null)
{
return(HttpNotFound());
}
ViewBag.client_id = new SelectList(db.clients, "id", "firstname", purchase.client_id);
ViewBag.product_id = new SelectList(db.products, "id", "name", purchase.product_id);
return(View(purchase));
}
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
purchase purchase = await db.purchases.FindAsync(id);
if (purchase == null)
{
return(HttpNotFound());
}
ViewBag.creditcardnumber = new SelectList(db.paymentoptions, "creditcardnumber", "creditcardcompany", purchase.creditcardnumber);
ViewBag.product = new SelectList(db.products, "product1", "type", purchase.product);
ViewBag.username = new SelectList(db.users, "username", "password", purchase.username);
return(View(purchase));
}
public ActionResult Create([Bind(Include = "id,client_id,product_id,count")] purchase purchase)
{
if (ModelState.IsValid)
{
purchase.date = DateTime.Now;
product p = db.products.Find(purchase.product_id);
purchase.productname = p.name;
purchase.productprice = p.price;
db.purchases.Add(purchase);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.client_id = new SelectList(db.clients, "id", "firstname", purchase.client_id);
ViewBag.product_id = new SelectList(db.products, "id", "name", purchase.product_id);
return(View(purchase));
}
public async Task <ActionResult> BuyCart(int paymentoptions)
{
string result = "";
if (ModelState.IsValid)
{
List <product> cartItems = (List <AlexMichaelProject.Models.product>)Session["cart"];
string username = (string)Session["username"];
for (int i = 0; i < cartItems.Count; i++)
{
int j = 0;
purchase temp = new purchase();
temp.username = username;
temp.product = cartItems.ElementAt(i).product1;
temp.creditcardnumber = paymentoptions;
temp.dateOfPurchase = DateTime.Today;
Boolean flag = false;
while (flag == false)
{
purchase test = new purchase();
test = await db.purchases.FindAsync(j);
if (test == null)
{
flag = true;
}
else
{
j++;
}
}
temp.dealID = j;
db.purchases.Add(temp);
}
Session["cart"] = null;
Session.Remove("cart");
Session.Remove("cartsize");
int zero = 0;
Session["cartsize"] = zero;
await db.SaveChangesAsync();
result = "true";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
// GET: purchases/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
purchase purchase = db.purchases.Find(id);
if (purchase == null)
{
return(HttpNotFound());
}
ViewBag.Category_Id = new SelectList(db.categories, "Category_Id", "Category_Name", purchase.Category_Id);
ViewBag.Company_Id = new SelectList(db.companies, "Company_Id", "Company_Name", purchase.Company_Id);
ViewBag.Pay_Id = new SelectList(db.pays, "pay_Id", "Value", purchase.Pay_Id);
ViewBag.Product_Id = new SelectList(db.products, "Product_Id", "Product_Name", purchase.Product_Id);
return(View(purchase));
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“lemonDataSet.supplier”中。您可以根据需要移动或删除它。
//panel1.Visible = false;
//自动生成单据
purchase p = new purchase();
int P_Int_newBillCode = p.selectMaxdanjuid() + 1;//记录单据编号中的数字码
textBox1.Text = DateTime.Now.ToString("yyyyMMdd") + "HappyLemon" + P_Int_newBillCode;
rawmaterial r1 = new rawmaterial();
rawmaterialdao dao = new rawmaterialdao();
//int index=this.purchaseTable.Rows.Add();
//Console.Write(number1[0]);
if (number1 == null)
{
}
else
{
foreach (string i in number1)
{
r1 = dao.selectNumber(i);
if (r1 == null)
{
}
else
{
int index = this.dataGridView1.Rows.Add();
this.dataGridView1.Rows[index].Cells[0].Value = r1.Rawmaterial_number;
this.dataGridView1.Rows[index].Cells[1].Value = r1.Rawmaterial_name;
this.dataGridView1.Rows[index].Cells[3].Value = r1.Rawmaterial_unit;
}
}
}
dataGridView1.Focus(); //使表格获得鼠标焦点
supplier_text.Focus(); //使供应商文本框成为焦点
//datagridview2
}
private void btnAddPRoduct_Click(object sender, EventArgs e)
{
CultureInfo cultureInfo = System.Threading.Thread.CurrentThread.CurrentCulture;
TextInfo textInfo = cultureInfo.TextInfo;
if (string.IsNullOrWhiteSpace(txtProductName.Text) || string.IsNullOrWhiteSpace(txtProductFeatures.Text) || string.IsNullOrWhiteSpace(txtPrice.Text) || string.IsNullOrWhiteSpace(datePurchasedDate.Text))
{
MessageBox.Show("You must fill in the required fields");
return;
}
if (txtPiece.Text == "0")
{
MessageBox.Show("You need to write minimum 1 for pieces");
return;
}
if (int.Parse(txtPrice.Text) < 0)
{
MessageBox.Show("You need to write positive value for price");
return;
}
//Change To Upper Case First Letter
txtProductName.Text = textInfo.ToTitleCase(txtProductName.Text.ToLower());
txtProductName.Select(txtProductName.Text.Length, 0);
txtProductFeatures.Text = textInfo.ToTitleCase(txtProductFeatures.Text.ToLower());
txtProductFeatures.Select(txtProductFeatures.Text.Length, 0);
//TODO:KULLAN BUNU int addedBy = 1;
product p = new product();
purchase purc = new purchase();
p.productName = txtProductName.Text;
p.productFeatures = txtProductFeatures.Text;
purc.purchasedDate = datePurchasedDate.Text;
p.pieces = int.Parse(txtPiece.Text);
purc.purchasedByID = userID;
purc.purchasePrice = int.Parse(txtPrice.Text);
Controller.ProductController.addProduct(p, purc);
}
public List <Purchaseitem111> showpurchaseitems(purchase p)
{
int x1 = p.purchaserId;
var n = from a in ctx.items
from b in ctx.purchase_item
from z in ctx.purchases
from c in ctx.item_supplier
from y in ctx.suppliers
where a.itemId == b.itemId && b.purchaseId == z.purchaserId && a.itemId == c.itemId && c.supplierId == y.supplierId && z.purchaserId == p.purchaserId && b.supplierid == y.supplierId
select new Purchaseitem111
{
Itemcode = a.itemId,
Description = a.description,
Quantity = b.requestQty,
price = c.price.Value,
Amount = c.price.Value * b.requestQty
};
return(n.ToList());
}
public ActionResult Create(PurchaseModel model)
{
purchase info = model.info;
String invitees = model.invitees;
String invitationContent = model.invitationContent;
info.companyId = (Int32)Session["user_id"];
info.purchase_time = DateTime.Now;
if (Utility.CheckSession(UserType.Company, Session))
{
var result = CreateRecord <purchase>(info);
if (result.first)
{
var inviteesList = invitees.Split(',').Distinct().ToList();
CreateInvitation(result.second.purchaseId, invitationContent, inviteesList);
return(RedirectToAction("Detail", new { id = result.second.purchaseId }));
}
}
return(RedirectToAction("Home", "Company"));
}
public void confirmorder(int s)
{
var n = from a in ctx.purchase_item
from b in ctx.items
where (a.itemId == b.itemId) && (a.purchaseId == s)
select b;
var x = from a in ctx.purchases
where a.purchaserId == s
select a;
var w = from a in ctx.purchase_item
from b in ctx.items
where (a.itemId == b.itemId) && (a.purchaseId == s)
select a;
foreach (item t in n.ToList())
{
foreach (purchase_item pt in w.ToList())
{
if (t.itemId == pt.itemId)
{
t.balance += pt.requestQty;
t.status = "sufficient";
}
}
}
purchase o = x.SingleOrDefault();
o.status = "Confirmed";
ctx.SaveChanges();
var purchaseitemlist = (from x1 in ctx.purchases
from y1 in ctx.purchase_item
from z1 in ctx.items
where x1.purchaserId == s && x1.purchaserId == y1.purchaseId && z1.itemId == y1.itemId
select z1).ToList();
revalidationForReq(purchaseitemlist);
}
private void btnRemoveProduct_Click(object sender, EventArgs e)
{
CultureInfo cultureInfo = System.Threading.Thread.CurrentThread.CurrentCulture;
TextInfo textInfo = cultureInfo.TextInfo;
//Change To Upper Case First Letter
txtProductName.Text = textInfo.ToTitleCase(txtProductName.Text.ToLower());
txtProductName.Select(txtProductName.Text.Length, 0);
txtProductFeatures.Text = textInfo.ToTitleCase(txtProductFeatures.Text.ToLower());
txtProductFeatures.Select(txtProductFeatures.Text.Length, 0);
if (string.IsNullOrWhiteSpace(txtProductName.Text) || string.IsNullOrWhiteSpace(txtProductFeatures.Text))
{
MessageBox.Show("You must fill in the required fields");
return;
}
if (txtPiece.Text == "0" || txtPiece.Text == "")
{
MessageBox.Show("You need to write minimum 1 for number.");
return;
}
var result = productList.Find(x => x.productName == cbProducts.SelectedItem.ToString());
product p = new product();
p.productID = result.productID;
p.productName = txtProductName.Text;
p.productFeatures = txtProductFeatures.Text;
purchase purc = new purchase();
purc.purchasePrice = int.Parse(txtPiece.Text);
//Call editProduct method from controller
Controller.ProductController.editProduct(purc, p);
txtPiece.Text = "";
}
public void changesupplier(int itemcode, int purchaseid, string comname, string userid)
{
var n = from a in ctx.purchase_item
from b in ctx.purchases
where (a.itemId == itemcode) && (b.purchaserId == purchaseid) &&
(a.purchaseId == b.purchaserId)
select a;
purchase_item pt = n.SingleOrDefault();
int x = pt.itemId;
ctx.purchase_item.Remove(pt);
var l = from a in ctx.suppliers
where a.compName == comname
select a.supplierId;
int ls = l.FirstOrDefault();
purchase po = new purchase();
po.supplierId = ls;
po.purchaseDate = DateTime.Today.Date;
po.expectedDeliveryDate = DateTime.Today.Date.AddDays(14);
po.status = "waiting";
po.userId = userid;
ctx.purchases.Add(po);
var xo = from a in ctx.items
where a.itemId == x
select a;
item xx = xo.SingleOrDefault();
purchase_item npt = new purchase_item();
npt.purchaseId = po.purchaserId;
npt.itemId = xx.itemId;
npt.requestQty = xx.reorderQty;
npt.supplierid = ls;
ctx.purchase_item.Add(npt);
ctx.SaveChanges();
}
public IHttpActionResult Putpurchase(int id, purchase purchase)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != purchase.id)
{
return(BadRequest());
}
//custom fix for error message in EntityState.Modified;
foreach (participants p in purchase.participants)
{
p.group_members = null;
}
db.Entry(purchase).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!purchaseExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void newpurchase()
{
purchase p = poFacade.newpurchase(1, "u005");
}
public ActionResult create(purchaseVM pvm)
{
decimal total_amount = 0;
if (pvm != null && pvm.product_id.Count() != 0)
{
purchase p = new purchase();
p.supplier_id = pvm.supplier_id;
p.warehouse_id = pvm.warehouse_id;
p.total_amount = pvm.total_amount;
p.create_date = DateTime.Now;
db.purchases.Add(p);
db.SaveChanges();
//get the purchas id
var id = db.purchases.Find(p.purchase_id);
//create purchase invoice
id.pInv = "#PINV-" + id.purchase_id + id.supplier_id;
//save all data in purchasse detiels page
purchase_details purchaseDetails = new purchase_details();
for (int i = 0; i < pvm.product_id.Count(); i++)
{
purchaseDetails.product_id = pvm.product_id[i];
purchaseDetails.quantity = pvm.quantity[i];
purchaseDetails.purchase_price = pvm.bayPrice[i];
purchaseDetails.sale_price = pvm.salePrice[i];
purchaseDetails.purchase_id = id.purchase_id;
purchaseDetails.sku = "SKU=" + purchaseDetails.product_id + "-" + purchaseDetails.purchase_id;
db.purchase_details.Add(purchaseDetails);
db.SaveChanges();
//samition the total price
total_amount += Convert.ToDecimal(purchaseDetails.purchase_price);
//update every product colams
var pro = db.product_tbl.Find(purchaseDetails.product_id);
//first create itemladger
ItemladgerController ic = new ItemladgerController();
ic.ladgerItem(Convert.ToInt32(pro.product_id), Convert.ToInt32(purchaseDetails.quantity), "in", Convert.ToInt32(p.warehouse_id), Convert.ToString(id.pInv));
pro.quantity += purchaseDetails.quantity;
pro.price = purchaseDetails.sale_price;
db.Entry(pro).State = EntityState.Modified;
db.SaveChanges();
}
//save the total price in
id.total_amount = total_amount;
db.Entry(id).State = EntityState.Modified;
db.SaveChanges();
message = " Purchase Created Is Successfully";
status = true;
TempData["Message"] = message;
TempData["Status"] = status;
return(RedirectToAction("purchaseInvoice", new { id = id.purchase_id }));
}
else
{
message = "There Are Some Problems";
}
TempData["Message"] = message;
TempData["Status"] = status;
return(RedirectToAction("create"));
}
private void UbahTSB_Click(object sender, EventArgs e)
{
// save purchase Header
purchase k = new purchase();
k.PONO = txtPONO.Text;
k.CURRENCYID = cbCurrency.Text;
k.DELIVERYTO = txtDeliveryTo.Text;
// DataRow selectedDataRow = ((DataRowView)cbTypeID.SelectedItem).Row;
// k.TYPEID = selectedDataRow["TYPEID"].ToString();
DataRow selectedDIV = ((DataRowView)cbDIV.SelectedItem).Row;
k.GDIV = selectedDIV["DIVID"].ToString();
k.CUSTVENDID = txtCustomerID.Text;
k.DELIVERYTO = txtDeliveryTo.Text;
k.DELIVERYTOADDRESS = txtAddress.Text;
//k.ACKNOWLEDGEMENT =
//k.ACKNOWLEDGEMENTBY=
//k.ACKNOWLEDGEMENTDATE=
//k.APPROVE=
//k.APPROVEBY=
//k.APPROVEDATE=
//k.CHECKBY=
//k.CHECKDATE=
//k.CHECKED=
//k.CLOSE=
k.CURRENCYID = cbCurrency.Text;
k.CUSTVENDID = txtCustomerID.Text;
k.DATE = dateCreated.Value;
k.DELIVERYTO = txtDeliveryTo.Text;
k.DELIVERYTOADDRESS = txtAddress.Text;
k.DELIVERYTONAME = txtRefer.Text;
k.DUEDATE = dateDue.Value;
k.ETA = dateETA.Value;
k.ETD = dateETD.Value;
// k.PPN = (float)Convert.ToDouble(txtPPN.Text);
k.KURS = (float)Convert.ToDouble(txtKurs.Text);
//k.GDIV=cbDIV.Text;
//k.NONREQ=
k.NOTE = txtRemarks.Text;
//k.OFFICER=GOFFICER
//k.PONO=
k.REFERTO = txtRefer.Text;
k.REMARKS = txtRemarks.Text;
//k.REVISE=
//k.REVISEBY=
//k.REVISEDATE=
//k.REVISEDUEDATE=
k.SHIPMODA = cbCourier.Text;
k.TERMOFPAYMENT = cbTerms.Text;
//k.TOTALAMOUNT=
//k.TOTALDISCOUNT=
//k.TOTALPAID=
//k.TOTALPPN=
//k.TOTALUPCHARGES=
//k.DELIVERYTOADDRESS=txta
if ((cbDIV.Text == "") || (txtCustomerID.Text == ""))
{
MessageBox.Show("Isian Belum lengkap,silahkan di lengkapi");
}
else if (new purchaseCRUD().updateData(k))
{
purchasedetail d = new purchasedetail();
//dtGrid.BeginEdit(true);
//dtGrid.Refresh();
dtGrid.EndEdit();
for (int i = 0; i < dtGrid.Rows.Count - 1; i++)
{
d.PONO = txtPONO.Text;
d.ID = Convert.ToInt32(dtGrid.Rows[i].Cells["hID"].Value); //i+1;//Convert.ToInt32(dtGrid.Rows[i].Cells["hCostingID"].Value);
d.COSTINGNO = dtGrid.Rows[i].Cells["hCostingNo"].Value.ToString();
d.COSTINGID = Convert.ToInt32(dtGrid.Rows[i].Cells["hCostingID"].Value);
// d.COSTINGDESC=dtGrid.Rows[i].Cells["hCostingID"].tr
//d.COSTINGDESC=
//d.MATERIALTYPEID=
d.ITEMSID = dtGrid.Rows[i].Cells["hItemsID"].Value == null ? null : dtGrid.Rows[i].Cells["hItemsID"].Value.ToString();
d.DESCRIPTION = dtGrid.Rows[i].Cells["hDescription"].Value == null?null:dtGrid.Rows[i].Cells["hDescription"].Value.ToString().ToString();
d.QUANTITY = (float)Convert.ToDouble(dtGrid.Rows[i].Cells["hQuantity"].Value);
d.UOM = dtGrid.Rows[i].Cells["hUOM"].Value == null ? null : dtGrid.Rows[i].Cells["hUOM"].Value.ToString();
d.PRICE = (float)Convert.ToDouble(dtGrid.Rows[i].Cells["hPrice"].Value);
d.CONVER = (float)Convert.ToDouble(dtGrid.Rows[i].Cells["hConvert"].Value);
d.QTYPURCHASE = (float)Convert.ToDouble(dtGrid.Rows[i].Cells["hQtyPurchase"].Value);
d.UOMPURCHASE = dtGrid.Rows[i].Cells["hUOMPurchase"].Value == null?null:dtGrid.Rows[i].Cells["hUOMPurchase"].Value.ToString();
d.PRICEPURCHASE = (float)Convert.ToDouble(dtGrid.Rows[i].Cells["hPricePurchase"].Value);
//d.TOTAL = (float)Convert.ToDouble(dtGrid.Rows[i].Cells["hTotal"].Value);
d.CURRENCYID = dtGrid.Rows[i].Cells["hCurrency"].Value == null ? null : dtGrid.Rows[i].Cells["hCurrency"].Value.ToString();
// d.DISCOUNT = (float)Convert.ToDouble(txtDiscount.Text);
// d.PPN = (float)Convert.ToDouble(txtPPN.Text);
d.KURS = (float)Convert.ToDouble(txtKurs.Text);
d.CURRENCYID = cbCurrency.SelectedValue.ToString();
//d.ITEMSID=
//d.COSTINGDESC=txtPONO.Text;
//d.COSTINGNO=txtPONO.Text;
//d.CURRENCYID=txtPONO.Text;
if (dtGrid.Rows[i].HeaderCell.Value.ToString() == "#")
{
d.ID = i + 1;
if (new purchasedetailCRUD().insertData(d))
{
// MessageBox.Show("Data berhasil di tambahkan");
// Binding();
dtGrid.Rows[i].HeaderCell.Value = "V";
}
else
{ //insert
}
}
else //if (dtGrid.Rows[i].HeaderCell.Value.ToString() == "E")
{
//update
if (new purchasedetailCRUD().updateData(d))
{
// MessageBox.Show("Data berhasil di tambahkan");
dtGrid.Rows[i].HeaderCell.Value = "V";
}
else
{
MessageBox.Show("Data gagal update");
//dtGrid.Rows[i].Cells["Check"].Value = "ER";
// dtGrid.Rows[i].HeaderCell.Value = "X";
}
}
}
MessageBox.Show("Data berhasil di update");
SimpanTSB.Enabled = false;
}
else
{
MessageBox.Show("Data gagal update");
}
}
private void SimpanTSB_Click(object sender, EventArgs e)
{
// save purchase Header
purchase k = new purchase();
Generate gen = new Generate();
txtPONO.Text = gen.genPONO();
k.PONO = txtPONO.Text;
k.DATE = dateCreated.Value;
k.CURRENCYID = cbCurrency.Text;
k.KURS = (float)Convert.ToDouble(txtKurs.Text);
// k.PPN = (float)Convert.ToDouble(txtPPN.Text);
//k.pp
// DataRow selectedDataRow = ((DataRowView)cbTypeID.SelectedItem).Row;
// k.TYPEID = selectedDataRow["TYPEID"].ToString();
DataRow selectedDIV = ((DataRowView)cbDIV.SelectedItem).Row;
k.GDIV = selectedDIV["DIVID"].ToString();
k.CUSTVENDID = txtCustomerID.Text;
k.DELIVERYTO = txtDeliveryTo.Text;
k.DELIVERYTOADDRESS = txtAddress.Text;
//k.ACKNOWLEDGEMENT =
//k.ACKNOWLEDGEMENTBY=
//k.ACKNOWLEDGEMENTDATE=
// k.APPROVE=
// k.APPROVEBY=
// k.APPROVEDATE=
// k.CHECKBY=
//k.CHECKDATE=
//k.CHECKED=
//k.CLOSE=
k.CURRENCYID = cbCurrency.Text;
k.CUSTVENDID = txtCustomerID.Text;
k.DATE = dateCreated.Value;
k.DELIVERYTOADDRESS = txtAddress.Text;
k.DELIVERYTONAME = txtRefer.Text;
k.DUEDATE = dateDue.Value;
k.ETA = dateETA.Value;
k.ETD = dateETD.Value;
k.GDIV = cbDIV.SelectedValue.ToString();
//k.NONREQ=
k.NOTE = txtRemarks.Text;
//k.OFFICER=GOFFIC
//k.PONO=
k.REFERTO = txtRefer.Text;
k.REMARKS = txtRemarks.Text;
//k.REVISE=
//k.REVISEBY=
//k.REVISEDATE=
//k.REVISEDUEDATE=
k.SHIPMODA = cbCourier.Text;
//k.TERMOFPAYMENT=cbt
//k.TOTALAMOUNT=
//k.TOTALDISCOUNT=
//k.TOTALPAID=
//k.TOTALPPN=
//k.TOTALUPCHARGES=
//k.DELIVERYTOADDRESS=txta
k.OFFICER = GlobalVariables.GUserID;
if ((cbDIV.Text == "") || (txtCustomerID.Text == ""))
{
MessageBox.Show("Isian Belum lengkap,silahkan di lengkapi");
}
else if (new purchaseCRUD().insertData(k))
{
MessageBox.Show("Data berhasil di tambahkan");
SimpanTSB.Enabled = false;
UbahTSB.Enabled = true;
dtGrid.Enabled = true;
// Binding();
}
else
{
MessageBox.Show("Data gagal ditambahkan");
}
}
public void findpurchaseorder()
{
purchase p = poFacade.findpurchaseorder(1);
Assert.IsNotNull(p);
}
private void button4_Click(object sender, EventArgs e)
{
bool b = true;
if (dataGridView1.Rows.Count == 1)
{
MessageBox.Show("请填写信息");
b = false;
}
else
{
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[0].Value == null)
{
MessageBox.Show("编号不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[1].Value == null)
{
MessageBox.Show("商品名称不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[3].Value == null)
{
MessageBox.Show("单位不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[4].Value == null)
{
MessageBox.Show("数量不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[5].Value == null)
{
MessageBox.Show("单价不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[6].Value == null)
{
MessageBox.Show("金额不能为空");
b = false;
}
else if (supplier_text.Text == "")
{
MessageBox.Show("请选择供应商");
b = false;
}
}
}
if (b == false)
{
}
else
{
purchase dao = new purchase();
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
purchase_material p = new purchase_material();
Console.Write(dataGridView1.Rows[i].Cells[0].Value + "lallalalaalalalalalalla");
p.RawMaterial_number = dataGridView1.Rows[i].Cells[0].Value.ToString();
p.Suppliernumber = supplier_text.Text;
p.Dan_date = Convert.ToDateTime(dateTimePicker1.Text);
p.Unit = dataGridView1.Rows[i].Cells[3].Value.ToString();
p.Count = Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value);
p.Price = Convert.ToDouble(dataGridView1.Rows[i].Cells[5].Value);
p.Money = Convert.ToDouble(dataGridView1.Rows[i].Cells[6].Value);
if (dataGridView1.Rows[i].Cells[7].Value == null)
{
p.Remark = " ";
}
else
{
p.Remark = dataGridView1.Rows[i].Cells[7].Value.ToString();
}
p.Status = 1;
dao.addpurchase(p);
}
MessageBox.Show("保存成功");
}
}
private void button4_Click_1(object sender, EventArgs e)
{
bool b = true;
if (dataGridView1.Rows.Count == 1)
{
MessageBox.Show("请填写信息");
b = false;
}
else
{
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[0].Value == null)
{
MessageBox.Show("编号不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[1].Value == null)
{
MessageBox.Show("商品名称不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[3].Value == null)
{
MessageBox.Show("单位不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[4].Value == null)
{
MessageBox.Show("数量不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[5].Value == null)
{
MessageBox.Show("单价不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[6].Value == null)
{
MessageBox.Show("金额不能为空");
b = false;
}
else if (textBox1.Text == "")
{
MessageBox.Show("请选择供应商");
b = false;
}
else if (textBox3.Text == "")
{
MessageBox.Show("操作人不能为空！");
}
}
}
if (b == false)
{
}
else
{
MessageBoxButtons messButton = MessageBoxButtons.OKCancel;
DialogResult dr = MessageBox.Show("是否确认保存？", "提交", messButton);
if (dr == DialogResult.OK)
{
string[] supplier = supplier_text.Text.Split(' ');
string[] employer = textBox3.Text.Split(' ');
try
{
purchase dao = new purchase();
double mm = Convert.ToDouble(label9.Text);
dao.addDanju(Convert.ToDateTime(dateTimePicker1.Text), textBox1.Text, employer[0], mm, textBox4.Text, supplier[0], 1);
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
purchase_material p = new purchase_material();
Console.Write(dataGridView1.Rows[i].Cells[0].Value + "lallalalaalalalalalalla");
p.RawMaterial_number = dataGridView1.Rows[i].Cells[0].Value.ToString();
p.Suppliernumber = supplier[0];
p.Dan_date = Convert.ToDateTime(dateTimePicker1.Text);
Console.Write("这是一个人" + p.Suppliernumber + "这是一个人");
p.Unit = dataGridView1.Rows[i].Cells[3].Value.ToString();
p.Count = Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value);
p.Price = Convert.ToDouble(dataGridView1.Rows[i].Cells[5].Value);
//Console.Write("这是一个人" + p.Price + "这是一个人");
p.Money = Convert.ToDouble(dataGridView1.Rows[i].Cells[6].Value);
if (dataGridView1.Rows[i].Cells[7].Value == null)
{
p.Remark = "";
}
else
{
p.Remark = dataGridView1.Rows[i].Cells[7].Value.ToString();
}
p.Status = 1;
p.Danju_id = textBox1.Text;
// Console.Write("这是一个人" + p.Danju_id + "这是一个人");
dao.addpurchase(p);
}
MessageBox.Show("保存成功");
}
catch (SystemException)
{
MessageBox.Show("操作有误");
}
}
else
{
}
}
}
