private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } _fish = new FishEntity.PurchaseRequisitionEntity(); if (dataGridView1.CurrentRow == null) { return; } if (dataGridView1.Rows[e.RowIndex].Cells["ContractNo"].Value != null) { _fish.ContractNo = dataGridView1.Rows[e.RowIndex].Cells["ContractNo"].Value.ToString(); if (dataGridView1.Rows[e.RowIndex].Cells["supplier"].Value != null && dataGridView1.Rows[e.RowIndex].Cells["supplier"].Value.ToString() != "") { _fish.Supplier = dataGridView1.Rows[e.RowIndex].Cells["supplier"].Value.ToString(); } if (dataGridView1.Rows[e.RowIndex].Cells["Purchasingcontacts"].Value != null && dataGridView1.Rows[e.RowIndex].Cells["Purchasingcontacts"].Value.ToString() != "") { _fish.Purchasingcontacts = dataGridView1.Rows[e.RowIndex].Cells["Purchasingcontacts"].Value.ToString(); } _fish.Openbank = dataGridView1.Rows[e.RowIndex].Cells["Openbank"].Value.ToString(); _fish.Accountnumber = dataGridView1.Rows[e.RowIndex].Cells["accountnumber"].Value.ToString(); } this.DialogResult = System.Windows.Forms.DialogResult.OK; }
protected void Numbering() { _model = new FishEntity.PurchaseRequisitionEntity(); List <FishEntity.PurchaseRequisitionEntity> model = new List <FishEntity.PurchaseRequisitionEntity>(); FishBll.Bll.PurchaseRequisitionBll bll = new FishBll.Bll.PurchaseRequisitionBll(); _model.Numbering = bll.code(); string str = string.Empty; int sum = 0; if (_model.Numbering == string.Empty) { str = DateTime.Now.Year.ToString() + "C" + "0001001"; } else { sum = int.Parse(_model.Numbering) + 1000; _model.Numbering = sum.ToString(); while (_model.Numbering.Length != 7) { _model.Numbering = "0" + _model.Numbering; } str = DateTime.Now.Year.ToString() + "C" + _model.Numbering; } txtNumbering.Text = str; }
private void btnOk_Click(object sender, EventArgs e) { if (Check() == false) { return; } bool isAdd = false; if (_model == null) { _model = new FishEntity.PurchaseRequisitionEntity(); isAdd = true; } PurchaseRequisition(); FishBll.Bll.PurchaseRequisitionBll bll = new FishBll.Bll.PurchaseRequisitionBll(); if (isAdd) { bool isok = bll.Exists(txtContractNo.Text); while (isok) { MessageBox.Show("合同编号已存在!"); break; } if (!isok) { _model.ContractNo = txtContractNo.Text; _model.Modifyman = FishEntity.Variable.User.username; _model.Modifytime = DateTime.Now; _model.Createman = _model.Modifyman; _model.Createtime = DateTime.Now; FishBll.Bll.PurchaseRequisitionBll _bll = new FishBll.Bll.PurchaseRequisitionBll(); int id = _bll.Add(_model); if (id > 0) { MessageBox.Show("添加成功!"); } OnRefresh(); } _model = null; } else { _model.ContractNo = txtContractNo.Text; _model.Modifyman = FishEntity.Variable.User.username; _model.Modifytime = DateTime.Now; FishBll.Bll.PurchaseRequisitionBll _bll = new FishBll.Bll.PurchaseRequisitionBll(); bool isOk = _bll.Update(_model); if (isOk) { MessageBox.Show("编辑成功"); } OnRefresh(); } //this.Close(); }
private void dataGridView1_CellContentDoubleClick_1(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } if (dataGridView1.CurrentRow == null) { return; } _fish = new FishEntity.PurchaseRequisitionEntity(); this.DialogResult = System.Windows.Forms.DialogResult.OK; }
public override int Modify() { if (dataGridView1.CurrentCell == null) { MessageBox.Show("请选择要编辑的行"); return(0); } FishEntity.PurchaseRequisitionEntity entity = dataGridView1.CurrentRow.DataBoundItem as FishEntity.PurchaseRequisitionEntity; if (entity == null) { MessageBox.Show("请选择需要编辑的行"); return(0); } PurchaseRequisitionEdit inven = new PurchaseRequisitionEdit("采购申请单", entity); inven.RefreshEvent += form_RefreshEvent; inven.Show(); return(0); }
protected void codeNum() { _model = new FishEntity.PurchaseRequisitionEntity(); FishBll.Bll.PurchaseRequisitionBll bll = new FishBll.Bll.PurchaseRequisitionBll(); DateTime dt = bll.getDate(); _model.ContractNo = bll.ContractNo(); if (_model.ContractNo == string.Empty) { _model.ContractNo = "ZD" + dt.ToString("MMdd") + "0001"; } else { if (_model.ContractNo.Substring(2, 4) == dt.ToString("MMdd")) { _model.ContractNo = "ZD" + (Convert.ToInt64(_model.ContractNo.Substring(2, 8)) + 1).ToString().PadLeft(8, '0'); } else { _model.ContractNo = "ZD" + dt.ToString("MMdd") + "0001"; } } txtContractNo.Text = _model.ContractNo; }
public bool Update(FishEntity.PurchaseRequisitionEntity model) { return(dal.Update(model)); }
public int Add(FishEntity.PurchaseRequisitionEntity model) { return(dal.Add(model)); }
public PurchaseRequisitionEdit(string title, FishEntity.PurchaseRequisitionEntity model) { InitializeComponent(); menuStrip1.Visible = false; BindData(); this.Text = title; _model = model; if (_model != null) { //txtContractNo.ReadOnly = true; txtContractNo.Text = _model.ContractNo; txtNumbering.Text = _model.Numbering; txtsupplier.Text = _model.Supplier; txtsupplier.Tag = _model.SupplierId; txtPurchasingcontacts.Text = _model.Purchasingcontacts; txtPurchasingcontacts.Tag = _model.PurchasingcontactsId; txtDemandSide.Text = _model.DemandSide; txtDemandSide.Tag = _model.DemandSideId; dtpDateOfSigni.Value = _model.DateOfSigni.Value; dtpdeliverytime.Value = _model.Deliverytime.Value; txtPlaceOfSign.Text = _model.PlaceOfSign; txtProductName.Text = _model.ProductName; txtUnit.Text = _model.Unit; txtFishmealId.Text = _model.FishmealId; txtOpenbank.Text = _model.Openbank; txtaccountnumber.Text = _model.Accountnumber; //txtVariety.Text = _model.Variety; txtQuantity.Text = _model.Quantity; txtNameOfTheShip.Text = _model.NameOfTheShip; txtBillOfLadingNumber.Text = _model.BillOfLadingNumber; txtDemandSideShort.Text = _model.DemandSideShort; txtSupplierAbbreviation.Text = _model.SupplierAbbreviation; txtHTprotein.Text = _model.HTprotein; txtAsh.Text = _model.Ash; txtHTTVB.Text = _model.HTTVB; txtHTHistamine.Text = _model.HTHistamine; txtHTFFA.Text = _model.HTFFA; txtHTFat.Text = _model.HTFat; txtHTMoisture.Text = _model.HTMoisture; txtHTSandAndSalt.Text = _model.HTSandAndSalt; txtHTSand.Text = _model.HTSand; txtHTUnit.Text = _model.HTUnit; txtHTAsh.Text = _model.HTAsh; txtLysine.Text = _model.Lysine; txtMethionine.Text = _model.Methionine; txtUnitPrice.Text = _model.UnitPrice.ToString(); txtAmountOfMoney.Text = _model.AmountOfMoney.ToString(); txtProtein.Text = _model.Protein.ToString(); txtTVN.Text = _model.TVN.ToString(); txtHistamine.Text = _model.Histamine.ToString(); txtFFA.Text = _model.FFA.ToString(); txtFat.Text = _model.Fat.ToString(); txtMoisture.Text = _model.Moisture.ToString(); txtSandAndSalt.Text = _model.SandAndSalt.ToString(); txtSand.Text = _model.Sand.ToString(); txtRebate.Text = _model.Rebate.ToString(); txtUSDollarPrice.Text = _model.USDollarPrice.ToString(); txtMJAmount.Text = _model.MJAmount; cmbSpecification.SelectedValue = _model.Specification == null ? string.Empty : _model.Specification; cmbvalidate.SelectedItem = _model.validate == null ? string.Empty : _model.validate; cmbCountry.SelectedValue = _model.Country == null ? string.Empty : _model.Country; cmbBrand.SelectedValue = _model.Brand == null ? string.Empty : _model.Brand; cmbVariety.SelectedValue = _model.Variety == null ? string.Empty : _model.Variety; txtTradingLocations.Text = _model.TradingLocations; dtpTimeOfShipment.Value = _model.TimeOfShipment.Value; dtpExpectedDate.Value = _model.ExpectedDate.Value; txtRemarks.Text = _model.Remarks.ToString(); } else { //txtContractNo.ReadOnly = false; Numbering(); codeNum(); cmbvalidate.Text = "有效"; _model = null; } }
private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { if (e.RowIndex < 0) { return; } _fish = new FishEntity.PurchaseRequisitionEntity(); if (dataGridView1.CurrentRow == null) { return; } if (dataGridView1.Rows[e.RowIndex].Cells["ContractNo"].Value != null && dataGridView1.Rows[e.RowIndex].Cells["FishmealId"].Value != null) { _fish.ContractNo = dataGridView1.Rows[e.RowIndex].Cells["ContractNo"].Value.ToString(); if (dataGridView1.Rows[e.RowIndex].Cells["supplier"].Value != null && dataGridView1.Rows[e.RowIndex].Cells["supplier"].Value.ToString() != "") { _fish.Supplier = dataGridView1.Rows[e.RowIndex].Cells["supplier"].Value.ToString(); } if (dataGridView1.Rows[e.RowIndex].Cells["Purchasingcontacts"].Value != null && dataGridView1.Rows[e.RowIndex].Cells["Purchasingcontacts"].Value.ToString() != "") { _fish.Purchasingcontacts = dataGridView1.Rows[e.RowIndex].Cells["Purchasingcontacts"].Value.ToString(); } if (dataGridView1.Rows[e.RowIndex].Cells["SupplierId"].Value != null && dataGridView1.Rows[e.RowIndex].Cells["SupplierId"].Value.ToString() != "") { _fish.SupplierId = dataGridView1.Rows[e.RowIndex].Cells["SupplierId"].Value.ToString(); } if (dataGridView1.Rows[e.RowIndex].Cells["DemandSideId"].Value != null && dataGridView1.Rows[e.RowIndex].Cells["DemandSideId"].Value.ToString() != "") { _fish.DemandSideId = dataGridView1.Rows[e.RowIndex].Cells["DemandSideId"].Value.ToString(); } if (dataGridView1.Rows[e.RowIndex].Cells["PurchasingcontactsId"].Value != null && dataGridView1.Rows[e.RowIndex].Cells["PurchasingcontactsId"].Value.ToString() != "") { _fish.PurchasingcontactsId = dataGridView1.Rows[e.RowIndex].Cells["PurchasingcontactsId"].Value.ToString(); } _fish.FishmealId = dataGridView1.Rows[e.RowIndex].Cells["FishmealId"].Value.ToString(); _fish.Openbank = dataGridView1.Rows[e.RowIndex].Cells["Openbank"].Value.ToString(); _fish.Accountnumber = dataGridView1.Rows[e.RowIndex].Cells["accountnumber"].Value.ToString(); if (dataGridView1.Rows[e.RowIndex].Cells["NameOfTheShip"].Value != null) { _fish.NameOfTheShip = dataGridView1.Rows[e.RowIndex].Cells["NameOfTheShip"].Value.ToString(); } else { _fish.NameOfTheShip = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["BillOfLadingNumber"].Value != null) { _fish.BillOfLadingNumber = dataGridView1.Rows[e.RowIndex].Cells["BillOfLadingNumber"].Value.ToString(); } else { _fish.BillOfLadingNumber = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["Country"].Value != null) { _fish.Country = dataGridView1.Rows[e.RowIndex].Cells["Country"].Value.ToString(); } else { _fish.Country = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["Brand"].Value != null) { _fish.Brand = dataGridView1.Rows[e.RowIndex].Cells["Brand"].Value.ToString(); } else { _fish.Brand = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["Variety"].Value != null) { _fish.Variety = dataGridView1.Rows[e.RowIndex].Cells["Variety"].Value.ToString(); } else { _fish.Variety = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["Specification"].Value != null) { _fish.Specification = dataGridView1.Rows[e.RowIndex].Cells["Specification"].Value.ToString(); } else { _fish.Specification = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["Protein"].Value != null) { _fish.Protein = dataGridView1.Rows[e.RowIndex].Cells["Protein"].Value.ToString(); } else { _fish.Protein = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["TVN"].Value != null) { _fish.TVN = dataGridView1.Rows[e.RowIndex].Cells["TVN"].Value.ToString(); } else { _fish.TVN = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["Histamine"].Value != null) { _fish.Histamine = dataGridView1.Rows[e.RowIndex].Cells["Histamine"].Value.ToString(); } else { _fish.Histamine = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["FFA"].Value != null) { _fish.FFA = dataGridView1.Rows[e.RowIndex].Cells["FFA"].Value.ToString(); } else { _fish.FFA = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["Fat"].Value != null) { _fish.Fat = dataGridView1.Rows[e.RowIndex].Cells["Fat"].Value.ToString(); } else { _fish.Fat = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["Moisture"].Value != null) { _fish.Moisture = dataGridView1.Rows[e.RowIndex].Cells["Moisture"].Value.ToString(); } else { _fish.Moisture = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["SandAndSalt"].Value != null) { _fish.SandAndSalt = dataGridView1.Rows[e.RowIndex].Cells["SandAndSalt"].Value.ToString(); } else { _fish.SandAndSalt = string.Empty; } if (dataGridView1.Rows[e.RowIndex].Cells["Sand"].Value != null) { _fish.Sand = dataGridView1.Rows[e.RowIndex].Cells["Sand"].Value.ToString(); } else { _fish.Sand = string.Empty; } } this.DialogResult = System.Windows.Forms.DialogResult.OK; }