public void SetFish(FishEntity.ProductEntity entity)
{
txtweight.Text = entity.weight.ToString();
txtremainweight.Text = entity.remainweight.ToString();
txtquantity.Text = entity.quantity.ToString();
txtremainquantity.Text = entity.remainquantity.ToString();
txthomemadecost.Text = entity.homemadecost.ToString();
txthomemadepackages.Text = entity.homemadepackages.ToString();
//自制仓单价= 自制仓成本/自制仓重量
decimal unitprice = entity.homemadeweight.Value == 0 ? 0: entity.homemadecost.Value / entity.homemadeweight.Value;
txthomemadeunitprice.Text = unitprice.ToString("f2"); // entity.homemadeunitprice.ToString();
txthomemadeweight.Text = entity.homemadeweight.ToString();
txtarriveportdate.Text = entity.arriveportdate;
//txtbillofgoods.Text = entity.billofgoods;
txtcustomsofcompany.Text = entity.customsofcompany;
txtagentifcompany.Text = entity.agentifcompany;
txtowner.Text = entity.ownername;
txtownershort.Text = entity.ownershortname;
txtownershort.Tag = entity.ownerCode;
txtprice.Text = entity.price.ToString();
txtsailingschedule.Text = entity.sailingschedule;
}
private void txtcountry_DoubleClick(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtfishId.Text))
{
MessageBox.Show("请选择鱼粉ID");
return;
}
FormFish form = new FormFish(txtfishId.Text);
if (form.ShowDialog() == DialogResult.OK)
{
FishEntity.ProductEntity _fish = form.getEntity;
if (_fish == null)
{
return;
}
txtcountry.Text = _fish.nature;
txtbrand.Text = _fish.brand;
txtpileNum.Text = _fish.cornerno;
txtproName.Text = _fish.name;
txtqualitySpe.Text = _fish.specification;
txtza.Text = _fish.sgs_amine.ToString("f2");
txttvn.Text = _fish.sgs_tvn.ToString("f2");
txtzf.Text = _fish.sgs_fat.ToString();
txthf.Text = _fish.sgs_graypart.ToString();
txtsand.Text = _fish.sgs_sand.ToString();
txtbillName.Text = _fish.billofgoods;
txtsf.Text = _fish.sgs_water.ToString();
txtdb.Text = _fish.sgs_protein.ToString();
txtshy.Text = _fish.sgs_sandsalt.ToString();
}
}
public void Getnum1(FishEntity.ProductEntity entity)
{
decimal temp2 = 0;
entity.code = txtCode.Text;
entity.specification = entity.specification = cmbSpecification.SelectedValue == null ? string.Empty : cmbSpecification.SelectedValue.ToString();
if (cmbBand.SelectedValue != null)
{
entity.brand = cmbBand.SelectedValue.ToString();
}
else
{
entity.brand = string.Empty;
}
entity.nature = cmbCountry.SelectedValue.ToString();
entity.type = cmbPort.SelectedValue == null ? string.Empty : cmbPort.SelectedValue.ToString();
decimal.TryParse(txtquote_protein.Text, out temp2);
entity.quote_protein = temp2;
decimal.TryParse(txtquote_tvn.Text, out temp2);
entity.quote_tvn = temp2;
decimal.TryParse(txtquote_sand.Text, out temp2);
entity.quote_sand = temp2;
decimal.TryParse(txtquote_sandsalt.Text, out temp2);
entity.quote_sandsalt = temp2;
decimal.TryParse(txtquote_amine.Text, out temp2);
entity.quote_amine = temp2;
decimal.TryParse(txtquote_ffa.Text, out temp2);
entity.quote_ffa = temp2;
decimal.TryParse(txtquote_fat.Text, out temp2);
entity.quote_fat = temp2;
decimal.TryParse(txtquote_water.Text, out temp2);
entity.quote_water = temp2;
}
public override int Add()
{
tmiSave.Visible = true;
tmiCancel.Visible = true;
tmiAdd.Visible = false;
tmiModify.Visible = false;
tmiQuery.Visible = false;
tmiPrevious.Visible = false;
tmiNext.Visible = false;
tmiDelete.Visible = false;
_fish = null;
fishInfoControl1.Clear();
fishSummaryControl1.Clear();
fishCompositionControl1.Clear();
fishQuoteControl1.Clear();
fishComfirmControl1.Clear();
fishSpotGoodsControl1.Clear();
fishSelfControl1.Clear();
fishSaleControl1.Clear();
//txtman.Text = FishEntity.Variable.User.username;
//txtmodifytime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
panelAll.Enabled = true;
return(1);
}
/// <summary>
///
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public List <FishEntity.ProductEntity> Report(string strWhere, out decimal weight, out int package, out decimal homeweight, out int homepackage)
{
weight = 0;
package = 0;
homepackage = 0;
homeweight = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from t_product");
if (string.IsNullOrEmpty(strWhere) == false)
{
strSql.Append(" where " + strWhere);
}
DataSet ds = MySqlHelper.Query(strSql.ToString());
List <FishEntity.ProductEntity> list = new List <FishEntity.ProductEntity>();
FishEntity.ProductEntity model = new FishEntity.ProductEntity();
int rowcount = ds.Tables[0].Rows.Count;
for (int i = 0; i < rowcount; i++)
{
DataRow row = ds.Tables[0].Rows[i];
model = DataRowToModel(row);//
list.Add(model);
weight += model.weight.Value;
package += model.quantity.Value;
homeweight += model.homemadeweight.Value;
homepackage += model.homemadepackages.Value;
}
return(list);
}
protected void QueryOne(string operate, string orderBy)
{
string whereEx = string.Empty;
if (string.IsNullOrEmpty(_where))
{
whereEx = " 1=1 ";
}
else
{
whereEx = _where;
}
if (_fish != null)
{
whereEx += " and code " + operate + _fish.code;
}
List <FishEntity.ProductEntity> list = _bll.GetModelList(whereEx + orderBy);
if (list == null || list.Count < 1)
{
MessageBox.Show("已经没有记录了!");
return;
}
_fish = list[0];
//
_fishex = _bllex.GetModel(_fish.id);
SetFish();
}
public List <FishEntity.ContractPorductEntity> GetProducts(int contractid, int detailid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select a.id as cpid , b.* from t_contractproduct a inner join t_product b on a.productid=b.id where ");
strSql.Append(" a.contractid=" + contractid + " and a.contractdetailid=" + detailid);
DataSet dsData = MySqlHelper.Query(strSql.ToString());
List <FishEntity.ContractPorductEntity> list = new List <FishEntity.ContractPorductEntity>();
for (int i = 0; i < dsData.Tables[0].Rows.Count; i++)
{
FishEntity.ProductEntity entity = ProductDao.DataRowToModel(dsData.Tables[0].Rows[i]);
FishEntity.ContractPorductEntity model = new FishEntity.ContractPorductEntity();
if (dsData.Tables[0].Rows[i]["cpid"] != null)
{
model.cpid = int.Parse(dsData.Tables[0].Rows[i]["cpid"].ToString());
}
model.id = entity.id;
model.code = entity.code;
model.name = entity.name;
model.specification = entity.specification;
list.Add(model);
}
return(list);
}
public override void Save()
{
_fish = new FishEntity.ProductEntity();
Getnum1(_fish);
_fish.createman = FishEntity.Variable.User.username;
_fish.modifyman = _fish.createman;
_fish.code = FishBll.Bll.SequenceUtil.GetFishSequence();
bool isok = _bll.Exists(_fish.code);
while (isok)
{
_fish.code = FishBll.Bll.SequenceUtil.GetFishSequence();
isok = _bll.Exists(_fish.code);
}
int id = _bll.Entry_Add(_fish);
if (id > 0)
{
_fish.id = id;
SaveEx(id);
SetFish(_fish);
tmiQuery.Visible = false;
tmiDelete.Visible = false;
tmiModify.Visible = false;
tmiAdd.Visible = false;
tmiSave.Visible = true;
tmiCancel.Visible = true;
MessageBox.Show("添加成功。");
}
else
{
MessageBox.Show("添加失败。");
}
}
public void Clear()
{
errorProvider1.Clear();
_fish = null;
txtdomestic_graypart.Text = string.Empty;
txtdomestic_lysine.Text = string.Empty;
txtdomestic_methionine.Text = string.Empty;
txtdomestic_protein.Text = string.Empty;
txtdomestic_sandsalt.Text = string.Empty;
txtdomestic_sour.Text = string.Empty;
txtdomestic_tvn.Text = string.Empty;
txtdomestic_amine.Text = string.Empty;
txtdomestic_aminototal.Text = string.Empty;
txtdomestic_fat.Text = string.Empty;
txtSampleingDate.Text = string.Empty;
txtlabe_water.Text = string.Empty;
txtlabel_amine.Text = string.Empty;
txtlabel_fat.Text = string.Empty;
txtlabel_ffa.Text = string.Empty;
txtlabel_graypart.Text = string.Empty;
txtlabel_lysine.Text = string.Empty;
txtlabel_methionine.Text = string.Empty;
txtlabel_protein.Text = string.Empty;
txtlabel_sand.Text = string.Empty;
txtlabel_sandsalt.Text = string.Empty;
txtlabel_tvn.Text = string.Empty;
//txtLinkman.Text = string.Empty;
//txtLinkManCode.Text = string.Empty;
//txtLinkManCode.Tag = string.Empty;
txtquote_amine.Text = string.Empty;
txtquote_fat.Text = string.Empty;
txtquote_ffa.Text = string.Empty;
txtquote_graypart.Text = string.Empty;
txtquote_protein.Text = string.Empty;
txtquote_sand.Text = string.Empty;
txtquote_sandsalt.Text = string.Empty;
txtquote_tvn.Text = string.Empty;
txtquote_water.Text = string.Empty;
txtsgs_amine.Text = string.Empty;
txtsgs_fat.Text = string.Empty;
txtsgs_ffa.Text = string.Empty;
txtsgs_graypart.Text = string.Empty;
txtsgs_protein.Text = string.Empty;
txtsgs_sand.Text = string.Empty;
txtsgs_sandsalt.Text = string.Empty;
txtsgs_tvn.Text = string.Empty;
txtsgs_water.Text = string.Empty;
//txtSupplier.Text = string.Empty;
//txtSupplierCode.Text = string.Empty;
//txtSupplierCode.Tag = string.Empty;
_formSGS = null;
_formLabel = null;
_formGJ = null;
_formQuote = null;
}
public override void Save()
{
if (Check() == false)
{
return;
}
_entity = new FishEntity.HomemadeStorageEntity();
_en = new FishEntity.ProductEntity();
GetEntity();
_entity.createman = FishEntity.Variable.User.username;
_entity.createtime = DateTime.Now;
_entity.modifyman = _entity.createman;
_entity.modifytime = _entity.createtime;
_entity.code = FishBll.Bll.SequenceUtil.GetHomemadeStorageSequence();
while (_bll.Exists(_entity.code))
{
_entity.code = FishBll.Bll.SequenceUtil.GetHomemadeStorageSequence();
}
int id = _bll.Add(_entity);
_bll.Add1(_en);
if (id > 0)
{
_entity.id = id;
txtCode.Text = _entity.code;
//更新 鱼粉资料 的自制仓 成本，数量 , 重量
//FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
//decimal cost = _entity.unitprice.Value * _entity.netweight.Value;
//decimal weight = _entity.netweight.Value;
//bool isok = productBll.UpdateHomemade(_entity.productid.Value , weight , cost, _entity.packages.Value);
//更新 鱼粉资料的 自制仓 入库重量，数量，采购单价，销售单价，入库时间等信息
FishBll.Bll.ProductExBll productExBll = new FishBll.Bll.ProductExBll();
bool isok = productExBll.UpdateHomeMadeInfo(_entity.productid.Value, _entity.storageweight, _entity.storagequantity, _entity.selfprice, _entity.saleprice, _entity.storagetime.Value.ToString("yyyy/MM/dd"));
//tmiCancel.Visible = false;
//tmiSave.Visible = false;
//tmiAdd.Visible = true;
//tmiModify.Visible = true;
//tmiDelete.Visible = true;
//tmiQuery.Visible = true;
//tmiPrevious.Visible = true;
//tmiNext.Visible = true;
//txtfishname.Enabled = false;
//txtFishCode.Enabled = false;
ControlButtomRoles();
MessageBox.Show("新增成功。");
}
else
{
MessageBox.Show("新增失败。");
}
return;
}
public override void Save()
{
_fish = new FishEntity.ProductEntity();
fishInfoControl1.GetFish(_fish); //上
fishCompositionControl1.GetFish(_fish); //中
fishSummaryControl1.GetFish(_fish); //下
_fish.createman = FishEntity.Variable.User.username;
_fish.modifyman = _fish.createman;
if (Check() == false)
{
return;
}
_fish.code = FishBll.Bll.SequenceUtil.GetFishSequence();
bool isok = _bll.Exists(_fish.code);
while (isok)
{
_fish.code = FishBll.Bll.SequenceUtil.GetFishSequence();
isok = _bll.Exists(_fish.code);
}
int id = _bll.Add(_fish);
if (id > 0)
{
_fish.id = id;
AddImages(_fish);
AddImages1(_fish);
SaveEx(id);
fishInfoControl1.SetFish(_fish);
fishCompositionControl1.SetFish(_fish);
//tmiAdd.Visible = true;
//tmiModify.Visible = true;
//tmiQuery.Visible = true;
//tmiPrevious.Visible = true;
//tmiNext.Visible = true;
//tmiDelete.Visible = true;
//tmiSave.Visible = false;
//tmiCancel.Visible = false;
ControlButtomRoles();
MessageBox.Show("添加成功。");
}
else
{
MessageBox.Show("添加失败。");
}
return;
}
public void SetFish(FishEntity.ProductEntity entity)
{
_formLabel = null;
_formSGS = null;
_formGJ = null;
_formQuote = null;
_fish = entity;
if (_fish == null)
{
return;
}
txtsgs_amine.Text = _fish.sgs_amine.ToString("f2");
txtsgs_fat.Text = _fish.sgs_fat.ToString();
txtsgs_ffa.Text = _fish.sgs_ffa.ToString();
txtsgs_graypart.Text = _fish.sgs_graypart.ToString();
txtsgs_protein.Text = _fish.sgs_protein.ToString();
txtsgs_sand.Text = _fish.sgs_sand.ToString();
txtsgs_sandsalt.Text = _fish.sgs_sandsalt.ToString();
txtsgs_tvn.Text = _fish.sgs_tvn.ToString("f2");
txtsgs_water.Text = _fish.sgs_water.ToString();
txtlabe_water.Text = _fish.labe_water.ToString();
txtlabel_amine.Text = _fish.label_amine.ToString("f2");
txtlabel_fat.Text = _fish.label_fat.ToString();
txtlabel_ffa.Text = _fish.label_ffa.ToString();
txtlabel_graypart.Text = _fish.label_graypart.ToString();
txtlabel_lysine.Text = _fish.label_lysine.ToString();
txtlabel_methionine.Text = _fish.label_methionine.ToString();
txtlabel_protein.Text = _fish.label_protein.ToString();
txtlabel_sand.Text = _fish.label_sand.ToString();
txtlabel_sandsalt.Text = _fish.label_sandsalt.ToString();
txtlabel_tvn.Text = _fish.label_tvn.ToString();
txtquote_amine.Text = _fish.quote_amine.ToString("f2");
txtquote_fat.Text = _fish.quote_fat.ToString();
txtquote_ffa.Text = _fish.quote_ffa.ToString();
txtquote_graypart.Text = _fish.quote_graypart.ToString();
txtquote_protein.Text = _fish.quote_protein.ToString();
txtquote_sand.Text = _fish.quote_sand.ToString();
txtquote_sandsalt.Text = _fish.quote_sandsalt.ToString();
txtquote_tvn.Text = _fish.quote_tvn.ToString("f2");
txtquote_water.Text = _fish.quote_water.ToString();
txtdomestic_graypart.Text = _fish.domestic_graypart.ToString();
txtdomestic_lysine.Text = _fish.domestic_lysine.ToString();
txtdomestic_methionine.Text = _fish.domestic_methionine.ToString();
txtdomestic_protein.Text = _fish.domestic_protein.ToString();
txtdomestic_sandsalt.Text = _fish.domestic_sandsalt.ToString();
txtdomestic_sour.Text = _fish.domestic_sour.ToString();
txtdomestic_tvn.Text = _fish.domestic_tvn.ToString();
txtdomestic_fat.Text = _fish.domestic_fat.ToString();
txtdomestic_amine.Text = _fish.domestic_amine.ToString();
txtdomestic_aminototal.Text = _fish.domestic_aminototal.ToString();
txtSampleingDate.Text = _fish.samplingtime;
}
public void GetFish(FishEntity.ProductEntity entity)
{
decimal temp1 = 0;
decimal.TryParse(txtweight.Text, out temp1);
entity.weight = temp1;
int temp2 = 0;
int.TryParse(txtquantity.Text, out temp2);
entity.quantity = temp2;
decimal.TryParse(txtremainweight.Text, out temp1);
entity.remainweight = temp1;
int.TryParse(txtremainquantity.Text, out temp2);
entity.remainquantity = temp2;
decimal.TryParse(txthomemadeweight.Text, out temp1);
entity.homemadeweight = temp1;
decimal.TryParse(txthomemadecost.Text, out temp1);
entity.homemadecost = temp1;
int.TryParse(txthomemadepackages.Text, out temp2);
entity.homemadepackages = temp2;
decimal.TryParse(txthomemadeunitprice.Text, out temp1);
entity.homemadeunitprice = temp1;
decimal.TryParse(txtprice.Text, out temp1);
entity.price = temp1;
entity.arriveportdate = txtarriveportdate.Text;
entity.sailingschedule = txtsailingschedule.Text;
if (string.IsNullOrEmpty(txtownershort.Text) == false)
{
entity.ownerCode = txtownershort.Tag.ToString();
entity.ownershortname = txtownershort.Text;
entity.ownername = txtowner.Text;
}
else
{
entity.ownername = string.Empty;
entity.ownerCode = string.Empty;
entity.ownershortname = string.Empty;
}
//entity.billofgoods = txtbillofgoods.Text;
entity.agentifcompany = txtagentifcompany.Text;
entity.customsofcompany = txtcustomsofcompany.Text;
}
private void dataGridView1_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
{
if (boolget == true)
{
if (e.ColumnIndex < 0 || e.RowIndex < 0)
{
}
else
{
}
if (dataGridView1.Rows[e.RowIndex].Cells["code"].Value.ToString() == "分组小计")
{
return;
}
if (dataGridView1.Columns[e.ColumnIndex].Name.Equals("isdelete4", StringComparison.OrdinalIgnoreCase) == true)
{
if (FishEntity.Variable.User.username == "admin" || FishEntity.Variable.User.username == "ceo" || FishEntity.Variable.User.username == "zd_lyk")
{
FishEntity.ProductEntity _fish = new FishEntity.ProductEntity();
FishBll.Bll.FinishBll fishbll = new FishBll.Bll.FinishBll();
_fish.code = dataGridView1.Rows[e.RowIndex].Cells["code"].Value.ToString();
System.Console.WriteLine(dataGridView1.Rows[e.RowIndex].Cells["isdelete4"].Value.ToString());
if (("0").Equals(dataGridView1.Rows[e.RowIndex].Cells["isdelete4"].Value.ToString()))
{
_fish.isdelete = 1;
}
else if (("1").Equals(dataGridView1.Rows[e.RowIndex].Cells["isdelete4"].Value.ToString()))
{
_fish.isdelete = 0;
}
string names = "isdelete4";
bool idx = fishbll.update(_fish, names);
if (idx)
{
MessageBox.Show("修改成功！");
boolget = false;
}
else
{
MessageBox.Show("修改失败！");
boolget = false;
}
}
}
}
else
{
return;
}
}
protected int QueryByWhere(string where, string orderBy)
{
List <FishEntity.ProductEntity> list = _bll.GetModelList(where + orderBy);
if (list == null || list.Count < 1)
{
_fish = null;
_fishex = null;
return(0);
}
else
{
_fish = list[0];
_fishex = _bllex.GetModel(_fish.id);
SetFish();
return(1);
}
}
public override int Delete()
{
if (_fish == null)
{
return(0);
}
if (FishEntity.Variable.User.roletype.Equals(FishEntity.Constant.Role_SalesMan) &&
false == FishEntity.Variable.User.username.Equals(_fish.createman))
{
MessageBox.Show("对不起，您不能删除别人创建的鱼粉资料！");
return(0);
}
string fishid = _fish.code;
if (MessageBox.Show("您确定要删除的【" + fishid + "】鱼粉信息吗?", "询问", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.Cancel)
{
return(0);
}
bool isok1 = _bll.Delete(_fish.id);
bool isok2 = _bllex.Delete(_fish.id);
if (isok1 == false || isok2 == false)
{
MessageBox.Show("删除鱼粉信息失败。");
}
else
{
MessageBox.Show("删除鱼粉信息成功。");
_fish = null;
Next();
}
return(base.Delete());
}
public bool upde(FishEntity.ProductEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_product set ");
strSql.Append("isdelete4=5 ");
strSql.Append(" where code=@code");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45)
};
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void SetFish(FishEntity.ProductEntity entity)
{
if (entity == null)
{
return;
}
txtCode.Text = entity.code;
cmbSpecification.SelectedValue = entity.specification;
cmbCountry.SelectedValue = entity.nature;
cmbBand.SelectedValue = entity.brand;
cmbPort.SelectedValue = entity.type;
_fish = entity;
txtquote_amine.Text = _fish.quote_amine.ToString();
txtquote_fat.Text = _fish.quote_fat.ToString();
txtquote_ffa.Text = _fish.quote_ffa.ToString();
txtquote_protein.Text = _fish.quote_protein.ToString();
txtquote_sand.Text = _fish.quote_sand.ToString();
txtquote_sandsalt.Text = _fish.quote_sandsalt.ToString();
txtquote_tvn.Text = _fish.quote_tvn.ToString();
txtquote_water.Text = _fish.quote_water.ToString();
}
public bool update(FishEntity.ProductEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_product set ");
strSql.Append(" Display=@Display ");
strSql.Append(" where code=@code ");
MySqlParameter[] parameter =
{
new MySqlParameter("@Display", model.Display),
new MySqlParameter("@code", model.code)
};
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameter);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//鱼粉ID
private void txtfishId_MouseClick(object sender, MouseEventArgs e)
{
FormFish form = new FormFish( );
if (form.ShowDialog( ) == DialogResult.OK)
{
FishEntity.ProductEntity _fish = form.getEntity;
txtfishId.Text = _fish.code;
txtvarieties.Text = _fish.name;
txtquaSpe.Text = _fish.specification;
txtconutry.Text = _fish.nature;
txtbrand.Text = _fish.brand;
txtSGSDB.Text = _fish.sgs_protein.ToString( );
txtSGSTVN.Text = _fish.sgs_tvn.ToString( );
txtSGSZA.Text = _fish.sgs_amine.ToString( );
txtSGSFFA.Text = _fish.sgs_ffa.ToString( );
txtSGSZF.Text = _fish.sgs_fat.ToString( );
txtSGSSF.Text = _fish.sgs_water.ToString( );
txtSGSSHY.Text = _fish.sgs_sandsalt.ToString( );
txtSGSS.Text = _fish.sgs_sand.ToString( );
txtSGSSJ.Text = _fish.domestic_sour.ToString( );
txtSGSHF.Text = _fish.sgs_graypart.ToString( );
}
}
protected void SetEntity()
{
if (_entity == null)
{
return;
}
txtCode.Text = _entity.code;
txtFishCode.Text = _entity.productcode;
txtFishCode.Tag = _entity.productid;
txtfishname.Text = _entity.productname;
txtgrossweight.Text = _entity.grossweight.ToString();
txtnetweight.Text = _entity.netweight.ToString();
txtpackagenum.Text = _entity.packages.ToString();
txtSeq.Text = _entity.seq;
txttureweight.Text = _entity.tareweight.ToString();
txtunitprice.Text = _entity.unitprice.ToString();
dtpIntime.Value = _entity.intime.Value;
dtpOuttime.Value = _entity.outtime.Value;
dtpStorageDate.Value = _entity.storagetime.Value;
txtweight.Text = _entity.storageweight.ToString();
txtquantity.Text = _entity.storagequantity.ToString();
txtselfprice.Text = _entity.selfprice.ToString();
txtsaleprice.Text = _entity.saleprice.ToString();
txtpurposeman.Text = _entity.purchaseman;
txtpurposeman.Tag = _entity.purchasemanid;
txtdeliveryman.Text = _entity.storageman;
txtdeliveryman.Tag = _entity.storagemanid;
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
FishEntity.ProductEntity fish = productBll.GetModel(_entity.productid.Value);
if (fish == null)
{
return;
}
txtsgs_amine.Text = fish.sgs_amine.ToString();
txtsgs_fat.Text = fish.sgs_fat.ToString();
txtsgs_ffa.Text = fish.sgs_ffa.ToString();
txtsgs_graypart.Text = fish.sgs_graypart.ToString();
txtsgs_protein.Text = fish.sgs_protein.ToString();
txtsgs_sand.Text = fish.sgs_sand.ToString();
txtsgs_sandsalt.Text = fish.sgs_sandsalt.ToString();
txtsgs_tvn.Text = fish.sgs_tvn.ToString();
txtsgs_water.Text = fish.sgs_water.ToString();
txtlabel_lysine.Text = fish.label_lysine.ToString();
txtlabel_methionine.Text = fish.label_methionine.ToString();
txtdomestic_graypart.Text = fish.domestic_graypart.ToString();
txtdomestic_lysine.Text = fish.domestic_lysine.ToString();
txtdomestic_methionine.Text = fish.domestic_methionine.ToString();
txtdomestic_protein.Text = fish.domestic_protein.ToString();
txtdomestic_sandsalt.Text = fish.domestic_sandsalt.ToString();
txtdomestic_sour.Text = fish.domestic_sour.ToString();
txtdomestic_tvn.Text = fish.domestic_tvn.ToString();
dtpStorageDate.Value = _entity.storagetime.Value;
txtweight.Text = _entity.storageweight.ToString();
txtquantity.Text = _entity.storagequantity.ToString();
txtselfprice.Text = _entity.selfprice.ToString();
txtsaleprice.Text = _entity.saleprice.ToString();
txtpurposeman.Text = _entity.purchaseman;
txtpurposeman.Tag = _entity.purchasemanid;
txtdeliveryman.Text = _entity.storageman;
txtdeliveryman.Tag = _entity.storagemanid;
txtFishCode.Enabled = false;
txtfishname.Enabled = false;
}
public bool update(FishEntity.ProductEntity model)
{
return(dal.update(model));
}
/// <summary>
/// 有效性
/// </summary>
/// <param name="Numbering"></param>
/// <param name="effect"></param>
/// <returns></returns>
public bool update(FishEntity.ProductEntity model, string names)
{
return(dal.update(model, names));
}
public bool Add1(FishEntity.ProductEntity model)
{
return(da.upde(model));
}
public void GetFish(FishEntity.ProductEntity entity)
{
//int temp1 = 0;
decimal temp2 = 0;
decimal.TryParse(txtquote_amine.Text, out temp2);
entity.quote_amine = temp2;
decimal.TryParse(txtquote_fat.Text, out temp2);
entity.quote_fat = temp2;
decimal.TryParse(txtquote_ffa.Text, out temp2);
entity.quote_ffa = temp2;
decimal.TryParse(txtquote_graypart.Text, out temp2);
entity.quote_graypart = temp2;
decimal.TryParse(txtquote_protein.Text, out temp2);
entity.quote_protein = temp2;
decimal.TryParse(txtquote_sand.Text, out temp2);
entity.quote_sand = temp2;
decimal.TryParse(txtquote_sandsalt.Text, out temp2);
entity.quote_sandsalt = temp2;
decimal.TryParse(txtquote_tvn.Text, out temp2);
entity.quote_tvn = temp2;
decimal.TryParse(txtquote_water.Text, out temp2);
entity.quote_water = temp2;
//--------------------------------------------------
decimal.TryParse(txtsgs_amine.Text, out temp2);
entity.sgs_amine = temp2;
decimal.TryParse(txtsgs_ffa.Text, out temp2);
entity.sgs_ffa = temp2;
decimal.TryParse(txtsgs_fat.Text, out temp2);
entity.sgs_fat = temp2;
decimal.TryParse(txtsgs_graypart.Text, out temp2);
entity.sgs_graypart = temp2;
decimal.TryParse(txtsgs_protein.Text, out temp2);
entity.sgs_protein = temp2;
decimal.TryParse(txtsgs_sand.Text, out temp2);
entity.sgs_sand = temp2;
decimal.TryParse(txtsgs_sandsalt.Text, out temp2);
entity.sgs_sandsalt = temp2;
decimal.TryParse(txtsgs_tvn.Text, out temp2);
entity.sgs_tvn = temp2;
decimal.TryParse(txtsgs_water.Text, out temp2);
entity.sgs_water = temp2;
//----------------------------------------------------
decimal.TryParse(txtlabe_water.Text, out temp2);
entity.labe_water = temp2;
decimal.TryParse(txtlabel_amine.Text, out temp2);
entity.label_amine = temp2;
decimal.TryParse(txtlabel_fat.Text, out temp2);
entity.label_fat = temp2;
decimal.TryParse(txtlabel_ffa.Text, out temp2);
entity.label_ffa = temp2;
decimal.TryParse(txtlabel_graypart.Text, out temp2);
entity.label_graypart = temp2;
decimal.TryParse(txtlabel_lysine.Text, out temp2);
entity.label_lysine = temp2;
decimal.TryParse(txtlabel_methionine.Text, out temp2);
entity.label_methionine = temp2;
decimal.TryParse(txtlabel_protein.Text, out temp2);
entity.label_protein = temp2;
decimal.TryParse(txtlabel_sand.Text, out temp2);
entity.label_sand = temp2;
decimal.TryParse(txtlabel_sandsalt.Text, out temp2);
entity.label_sandsalt = temp2;
decimal.TryParse(txtlabel_tvn.Text, out temp2);
entity.label_tvn = temp2;
//----------------------------------------------------
decimal.TryParse(txtdomestic_graypart.Text, out temp2);
entity.domestic_graypart = temp2;
decimal.TryParse(txtdomestic_lysine.Text, out temp2);
entity.domestic_lysine = temp2;
decimal.TryParse(txtdomestic_methionine.Text, out temp2);
entity.domestic_methionine = temp2;
decimal.TryParse(txtdomestic_protein.Text, out temp2);
entity.domestic_protein = temp2;
decimal.TryParse(txtdomestic_sandsalt.Text, out temp2);
entity.domestic_sandsalt = temp2;
decimal.TryParse(txtdomestic_sour.Text, out temp2);
entity.domestic_sour = temp2;
decimal.TryParse(txtdomestic_tvn.Text, out temp2);
entity.domestic_tvn = temp2;
decimal.TryParse(txtdomestic_amine.Text, out temp2);
entity.domestic_amine = temp2;
decimal.TryParse(txtdomestic_aminototal.Text, out temp2);
entity.domestic_aminototal = temp2;
decimal.TryParse(txtdomestic_fat.Text, out temp2);
entity.domestic_fat = temp2;
txtSampleingDate.Text = string.Empty;
}
private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (dataGridView1.CurrentRow == null)
{
return;
}
//this . _model = dataGridView1 . CurrentRow . DataBoundItem as FishEntity . ProductEntity;
_model = new FishEntity.ProductEntity( );
if (dataGridView1.Rows [e.RowIndex].Cells ["code"].Value != null)
{
_model.code = dataGridView1.Rows [e.RowIndex].Cells ["code"].Value.ToString( );
}
else
{
_model.code = string.Empty;
}
if (dataGridView1.Rows [e.RowIndex].Cells ["name"].Value != null)
{
_model.name = dataGridView1.Rows [e.RowIndex].Cells ["name"].Value.ToString( );
}
else
{
_model.name = string.Empty;
}
if (dataGridView1.Rows [e.RowIndex].Cells ["specification"].Value != null)
{
_model.specification = dataGridView1.Rows [e.RowIndex].Cells ["specification"].Value.ToString( );
}
else
{
_model.specification = string.Empty;
}
if (dataGridView1.Rows [e.RowIndex].Cells ["brand"].Value != null)
{
_model.brand = dataGridView1.Rows [e.RowIndex].Cells ["brand"].Value.ToString( );
}
else
{
_model.brand = string.Empty;
}
if (dataGridView1.Rows [e.RowIndex].Cells ["nature"].Value != null)
{
_model.nature = dataGridView1.Rows [e.RowIndex].Cells ["nature"].Value.ToString( );
}
else
{
_model.nature = string.Empty;
}
if (dataGridView1.Rows[e.RowIndex].Cells["brand"].Value != null)
{
_model.brand = dataGridView1.Rows[e.RowIndex].Cells["brand"].Value.ToString();
}
else
{
_model.brand = string.Empty;
}
if (dataGridView1.Rows[e.RowIndex].Cells["sgs_protein"].Value != null)
{
_model.sgs_protein = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["sgs_protein"].Value.ToString());
}
if (dataGridView1.Rows[e.RowIndex].Cells["sgs_tvn"].Value != null)
{
_model.sgs_tvn = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["sgs_tvn"].Value.ToString());
}
if (dataGridView1.Rows[e.RowIndex].Cells["sgs_sandsalt"].Value != null)
{
_model.sgs_sandsalt = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["sgs_sandsalt"].Value.ToString());
}
if (dataGridView1.Rows[e.RowIndex].Cells["sgs_amine"].Value != null)
{
_model.sgs_amine = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["sgs_amine"].Value.ToString());
}
if (dataGridView1.Rows[e.RowIndex].Cells["sgs_ffa"].Value != null)
{
_model.sgs_ffa = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["sgs_ffa"].Value.ToString());
}
if (dataGridView1.Rows[e.RowIndex].Cells["sgs_fat"].Value != null)
{
_model.sgs_fat = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["sgs_fat"].Value.ToString());
}
if (dataGridView1.Rows[e.RowIndex].Cells["sgs_water"].Value != null)
{
_model.sgs_water = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["sgs_water"].Value.ToString());
}
if (dataGridView1.Rows[e.RowIndex].Cells["sgs_sand"].Value != null)
{
_model.sgs_sand = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["sgs_sand"].Value.ToString());
}
if (dataGridView1.Rows[e.RowIndex].Cells["shipno"].Value != null)
{
_model.shipno = dataGridView1.Rows[e.RowIndex].Cells["shipno"].Value.ToString();
}
if (dataGridView1.Rows[e.RowIndex].Cells["billofgoods"].Value != null)
{
_model.billofgoods = dataGridView1.Rows[e.RowIndex].Cells["billofgoods"].Value.ToString();
}
if (dataGridView1.Rows[e.RowIndex].Cells["cornerno"].Value != null)
{
_model.cornerno = dataGridView1.Rows[e.RowIndex].Cells["cornerno"].Value.ToString();
}
if (dataGridView1.Rows[e.RowIndex].Cells["warehouse"].Value != null)
{
_model.warehouse = dataGridView1.Rows[e.RowIndex].Cells["warehouse"].Value.ToString();
}
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
public int Entry_Add(FishEntity.ProductEntity model)
{
return(dal.Entry_Add(model));
}
public bool Entry_Update(FishEntity.ProductEntity model)
{
return(dal.Entry_Update(model));
}
protected void AddImages1(FishEntity.ProductEntity fish)
{
if (fish == null)
{
return;
}
FishBll.Bll.ImageS_Bll bll = new FishBll.Bll.ImageS_Bll();
//if (fish.id > 0)
//{
// bll.DeleteByRecordIdAndType(fish.id, (int)FishEntity.ImageTypeEnum.SGS);
// bll.DeleteByRecordIdAndType(fish.id, (int)FishEntity.ImageTypeEnum.Label);
// bll.DeleteByRecordIdAndType(fish.id, (int)FishEntity.ImageTypeEnum.GJ);
// bll.DeleteByRecordIdAndType(fish.id, (int)FishEntity.ImageTypeEnum.QUOTE);
//}
List <FishEntity.t_image_S> images = fishCompositionControl1.GetQuoteImages1();
if (images != null)
{
foreach (FishEntity.t_image_S item in images)
{
item.Fid1 = fish.id;
//item.createman = fish.createman;
item.Date_ = fish.createtime;
bll.Add(item);
}
}
images = fishCompositionControl1.GetSGSImages1();
if (images != null)
{
foreach (FishEntity.t_image_S item in images)
{
item.Fid1 = fish.id;
//item.createman = fish.createman;
item.Date_ = fish.createtime;
bll.Add(item);
}
}
images = fishCompositionControl1.GetLabelImages1();
if (images != null)
{
foreach (FishEntity.t_image_S item in images)
{
item.Fid1 = fish.id;
item.Date_ = fish.createtime;
bll.Add(item);
}
}
images = fishCompositionControl1.GetGJImages1();
if (images != null)
{
foreach (FishEntity.t_image_S item in images)
{
item.Fid1 = fish.id;
//item.createman = fish.createman;
item.Date_ = fish.createtime;
bll.Add(item);
}
}
}
protected void AddImages(FishEntity.ProductEntity fish)
{
if (fish == null)
{
return;
}
FishBll.Bll.ImageBll bll = new FishBll.Bll.ImageBll();
if (fish.id > 0)
{
bll.DeleteByRecordIdAndType(fish.id, (int)FishEntity.ImageTypeEnum.SGS);
bll.DeleteByRecordIdAndType(fish.id, (int)FishEntity.ImageTypeEnum.Label);
bll.DeleteByRecordIdAndType(fish.id, (int)FishEntity.ImageTypeEnum.GJ);
bll.DeleteByRecordIdAndType(fish.id, (int)FishEntity.ImageTypeEnum.QUOTE);
}
List <FishEntity.ImageEntity> images = fishCompositionControl1.GetQuoteImages();
if (images != null)
{
foreach (FishEntity.ImageEntity item in images)
{
item.recordid = fish.id;
item.createman = fish.createman;
item.createtime = fish.createtime;
bll.Add(item);
}
}
images = fishCompositionControl1.GetSGSImages();
if (images != null)
{
foreach (FishEntity.ImageEntity item in images)
{
item.recordid = fish.id;
item.createman = fish.createman;
item.createtime = fish.createtime;
bll.Add(item);
}
}
images = fishCompositionControl1.GetLabelImages();
if (images != null)
{
foreach (FishEntity.ImageEntity item in images)
{
item.recordid = fish.id;
item.createman = fish.createman;
item.createtime = fish.createtime;
bll.Add(item);
}
}
images = fishCompositionControl1.GetGJImages();
if (images != null)
{
foreach (FishEntity.ImageEntity item in images)
{
item.recordid = fish.id;
item.createman = fish.createman;
item.createtime = fish.createtime;
bll.Add(item);
}
}
}
