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;
}
