public override int Query()
{
UIForms.PurchaseApplicationCondition form = new UIForms.PurchaseApplicationCondition(this.Text + "查询");
this.panel1.Enabled = true;
if (form.ShowDialog() == DialogResult.OK)
{
_model = new FishEntity.PurchaseApplicationEntity(); _bll = new FishBll.Bll.PurchaseApplicationBll();
strWhere = form.getStrWhere;
_model = _bll.getModel(strWhere);
if (_model == null)
{
MessageBox.Show("请重新查询");
this.panel1.Enabled = false;
return(0);
}
setValue();
//if (string.IsNullOrEmpty(_model.codeNum))
// return 0;
//List<FishEntity.PurchaseFishInfo> listFishInfo = _bll.getFishInfoList(_model.codeNum);
//if (listFishInfo != null && listFishInfo.Count > 0)
// setValueFishInfo(listFishInfo);
//List<FishEntity . PurchaseOtherInfo> listOtherInfo = _bll . getOtherInfoList ( _model . codeNum );
//if ( listOtherInfo != null && listOtherInfo . Count > 0 )
// setValueOtherInfo ( listOtherInfo );
}
return(base.Query());
}
void QueryOne(string operate, string orderBy)
{
string whereEx = string.Empty;
if (string.IsNullOrEmpty(strWhere))
{
whereEx = "1=1";
}
else
{
whereEx = strWhere;
}
if (_model != null)
{
whereEx = whereEx + " AND codeNum " + operate + orderBy;
}
_model = _bll.getModel(whereEx);
if (_model == null)
{
MessageBox.Show("已经没有记录了");
return;
}
setValue( );
}
private void FormPurchaseApplication_Load(object sender, EventArgs e)
{
this.tmiPrevious.Visible = false;
this.tmiNext.Visible = false;
if (Megres.oddNum != "")
{
_model = new FishEntity.PurchaseApplicationEntity();
_bll = new FishBll.Bll.PurchaseApplicationBll();
_fishInfo = new FishEntity.PurchaseFishInfo();
_otherInfo = new FishEntity.PurchaseOtherInfo();
strWhere = " codeNum='" + Megres.oddNum + "'";
_model = _bll.getModel(strWhere);
if (_model == null)
{
MessageBox.Show("请重新查询");
this.panel1.Enabled = false;
return;
}
setValue();
//if (string.IsNullOrEmpty(_model.codeNum))
// return ;
//List<FishEntity.PurchaseFishInfo> listFishInfo = _bll.getFishInfoList(_model.codeNum);
//if (listFishInfo != null && listFishInfo.Count > 0)
// setValueFishInfo(listFishInfo);
this.panel1.Enabled = true;
}
else
{
strWhere = string.Empty;
}
//权限控制功能。
Megres.oddNum = string.Empty;
}
public FormPurchaseApplication( )
{
InitializeComponent( );
_model = new FishEntity.PurchaseApplicationEntity( );
_bll = new FishBll.Bll.PurchaseApplicationBll( );
this.txtprice.LostFocus += txtprice_LostFocus;
this.txtpriceMY.LostFocus += txtpriceMY_LostFocus;
}
private void txtcodeNum_DoubleClick(object sender, EventArgs e)
{
FormPurchaseApplication form = new FormPurchaseApplication( );
if (form.ShowDialog( ) == DialogResult.OK)
{
FishEntity.PurchaseApplicationEntity model = form.getModel;
txtcodeNum.Text = model.codeNum;
txtcodeNumContract.Text = model.codeNumContract;
}
}
private void txtsupply_Click(object sender, EventArgs e)
{
FormCompanyList form = new FormCompanyList();
if (form.ShowDialog() == DialogResult.OK)
{
FishEntity.PurchaseApplicationEntity _model = new FishEntity.PurchaseApplicationEntity();
_model = form.getModel;
txtsupply.Text = _model.buyer;
}
}
//采购方
private void txtpurchase_DoubleClick(object sender, EventArgs e)
{
FormCompanyList form = new FormCompanyList();
if (form.ShowDialog() == DialogResult.OK)
{
_model = form.getModel;
txtpurchase.Text = _model.buyer;
//txtpurchaseAbb.Text = _model.buyerAbb;
txtpurchaseUser.Text = _model.buyerUser;
}
}
private void txtdeliveryLast_Click(object sender, EventArgs e)
{
FormCompanyList form = new FormCompanyList();
FishEntity.PurchaseApplicationEntity get1 = new FishEntity.PurchaseApplicationEntity();
if (form.ShowDialog() == DialogResult.OK)
{
get1 = form.getModel;
txtdeliveryLast.Text = get1.buyer;
txtdeliveryLastUse.Text = get1.buyerUser;
}
}
private void txtCodeNum_DoubleClick(object sender, EventArgs e)
{
FormPurchaseApplication form = new FormPurchaseApplication( );
if (form.ShowDialog( ) == DialogResult.OK)
{
FishEntity.PurchaseApplicationEntity _model = form.getModel;
List <FishEntity.PurchaseOtherInfo> getOtherInfo = form.getOtherInfo;
List <FishEntity.PurchaseFishInfo> getFishInfo = form.getFishInfo;
setValue(_model, getOtherInfo, getFishInfo);
}
}
//供方
private void txtsupplier_DoubleClick(object sender, EventArgs e)
{
FormCompanyList form = new FormCompanyList();
if (form.ShowDialog() == DialogResult.OK)
{
_model = form.getModel;
txtsupplier.Text = _model.buyer;
//txtsupplierAbb.Text = _model.buyerAbb;
txtsupplierUser.Text = _model.buyerUser;
txtaccount.Text = form.getModel.account.ToString();
txtBank.Text = form.getModel.Bank.ToString();
}
}
public override int Query( )
{
UIForms.PurchaseApplicationCondition form = new UIForms.PurchaseApplicationCondition( );
if (form.ShowDialog( ) == DialogResult.OK)
{
strWhere = form.getStrWhere;
_model = _bll.getModel(strWhere);
if (_model == null)
{
MessageBox.Show("请重新查询");
return(0);
}
setValue( );
}
return(base.Query( ));
}
void QueryOne(string operate, string orderBy)
{
string whereEx = string.Empty;
if (string.IsNullOrEmpty(strWhere))
{
whereEx = "1=1";
}
else
{
whereEx = strWhere;
}
if (_model != null)
{
whereEx = whereEx + " AND a.id " + operate + orderBy;
}
if (operate != "" && orderBy != "")
{
_model = new FishEntity.PurchaseApplicationEntity();
_bll = new FishBll.Bll.PurchaseApplicationBll();
_model = _bll.getModel(whereEx);
}
else
{
_model = _bll.getModel(strWhere);
}
if (_model == null)
{
MessageBox.Show("已经没有记录了");
this.panel1.Enabled = false;
return;
}
setValue();
//if (string.IsNullOrEmpty(_model.codeNum))
// return;
//List<FishEntity.PurchaseFishInfo> listFishInfo = _bll.getFishInfoList(_model.codeNum);
//if (listFishInfo != null && listFishInfo.Count > 0)
// setValueFishInfo(listFishInfo);
this.panel1.Enabled = true;
whereEx = string.Empty;
//List<FishEntity . PurchaseOtherInfo> listOtherInfo = _bll . getOtherInfoList ( _model . codeNum );
//if ( listOtherInfo != null && listOtherInfo . Count > 0 )
// setValueOtherInfo ( listOtherInfo );
}
public override int Add( )
{
panel1.Enabled = true;
ControlClear( );
//txtcodeNumContract . Text = _bll . getCodeNum ( );
if (getname != "" && getname != null)
{
FishEntity.PurchaseApplicationEntity fish = new FishEntity.PurchaseApplicationEntity();
FishBll.Bll.PurchaseApplicationBll _Addbll = new FishBll.Bll.PurchaseApplicationBll();
fish = _Addbll.getModel(" codeNum='" + getname + "' ");
if (fish != null)
{
yincang(fish.choise);
jincang = fish.choise;
txtCodeNum.Text = fish.codeNum;
txtsupplier.Text = fish.supplier;
txtsupplierUser.Text = fish.supplierUser;
txtbuyer.Text = fish.buyer;
txtbuyerUser.Text = fish.buyerUser;
txtsigndate.Text = fish.signDate.ToString();
txtsignAdd.Text = fish.signAdd;
txtpurchase.Text = fish.purchase;
txtpurchaseUser.Text = fish.purchaseUser;
txtvarieties.Text = fish.varieties;
txtheight.Text = fish.Weight.ToString();
txtMoney.Text = fish.AmountOfMoney.ToString();
txtUnitPrice.Text = fish.danjia.ToString();
txtDollar.Text = fish.priceMY.ToString();
txtMoneyMJ.Text = fish.Dollarjine.ToString();
txtproName.Text = fish.proName;
//FishBll.Bll.PurchaseApplicationBll bll = new FishBll.Bll.PurchaseApplicationBll();
//List<FishEntity.PurchaseOtherInfo> listOtherInfo = bll.getOtherInfoList(_model.codeNum);
//if (listOtherInfo != null && listOtherInfo.Count > 0)
// setValue(listOtherInfo);
//List<FishEntity.PurchaseContractFishInfo> listFishInfo = _bll.getFishInfoList(_model.codeNum);
//if (listFishInfo != null && listFishInfo.Count > 0)
// setValue(listFishInfo);
}
}
return(base.Add( ));
}
void setValue(FishEntity.PurchaseApplicationEntity _model, List <FishEntity.PurchaseOtherInfo> listOtherInfo, List <FishEntity.PurchaseFishInfo> getFishInfo)
{
txtsupplier.Text = _model.supplier;
txtsupplierUser.Text = _model.supplierUser;
txtbuyer.Text = _model.buyer;
txtbuyerUser.Text = _model.buyerUser;
txtCodeNum.Text = _model.codeNum;
txtsignAdd.Text = _model.signAdd;
txtsigndate.Text = _model.signDate.ToString( );
txtvarieties.Text = _model.varieties;
txtheight.Text = Convert.ToDecimal(_model.height).ToString("f2");
txtMoney.Text = Convert.ToDecimal(_model.price).ToString("f2");
txtMoneyMJ.Text = Convert.ToDecimal(_model.billNum).ToString("f2");
txtdateshipDate.Text = _model.shipDate.ToString( );
txtdatedeliveryDate.Text = _model.deliveryDate.ToString( );
txtdeliveryAdd.Text = _model.deliveryAdd;
jincang = _model.choise;
txtconDAS.Text = _model.conDAS;
txtconFFA.Text = _model.conFFA;
txtconHF.Text = _model.conHF;
txtconLAS.Text = _model.conLAS;
txtconProtein.Text = _model.conProtein;
txtconS.Text = _model.conS;
txtconSF.Text = _model.conSF;
txtconSHY.Text = _model.conSHY;
txtconSJ.Text = _model.conSJ;
txtconTVN.Text = _model.conTVN;
txtconZA.Text = _model.conZA;
txtconZF.Text = _model.conZF;
txtpurchase.Text = _model.purchase;
txtpurchaseUser.Text = _model.purchaseUser;
yincang(_model.choise);
//dataGridView2 . Rows . Clear ( );
//foreach ( FishEntity . PurchaseOtherInfo otherInfo in listOtherInfo )
//{
// int idx = dataGridView2 . Rows . Add ( );
// DataGridViewRow row = dataGridView2 . Rows [ idx ];
// row . Cells [ "idx" ] . Value = otherInfo . id;
// row . Cells [ "brands" ] . Value = otherInfo . brand;
// row . Cells [ "moneys" ] . Value = otherInfo . money;
// row . Cells [ "nums" ] . Value = otherInfo . num;
//}
//dataGridView1 . Rows . Clear ( );
//foreach ( FishEntity . PurchaseFishInfo fishInfo in getFishInfo )
//{
// int idx = dataGridView1 . Rows . Add ( );
// DataGridViewRow row = dataGridView1 . Rows [ idx ];
// row . Cells [ "id" ] . Value = fishInfo . id;
// row . Cells [ "fishId" ] . Value = fishInfo . fishId;
// row . Cells [ "price" ] . Value = fishInfo . price;
// row . Cells [ "weight" ] . Value = fishInfo . weight;
// row . Cells [ "priceUSA" ] . Value = fishInfo . priceUSA;
// row . Cells [ "specifications" ] . Value = fishInfo . specifications;
// row . Cells [ "brand" ] . Value = fishInfo . brand;
// row . Cells [ "country" ] . Value = fishInfo . country;
// row . Cells [ "shipName" ] . Value = fishInfo . shipName;
// row . Cells [ "billName" ] . Value = fishInfo . billName;
// row . Cells [ "money" ] . Value = fishInfo . price * fishInfo . weight;
// row . Cells [ "moneyUSA" ] . Value = fishInfo . priceUSA * fishInfo . weight;
//}
//int index = this . dataGridView1 . Rows . Add ( );
//dataGridView1 . Rows [ index ] . Cells [ "fishId" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "price" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "weight" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "priceUSA" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "specifications" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "brand" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "country" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "shipName" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "billName" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "money" ] . Value = string . Empty;
//dataGridView1 . Rows [ index ] . Cells [ "moneyUSA" ] . Value = string . Empty;
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Edit(FishEntity.PurchaseApplicationEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update t_purchaseapplication set ");
strSql.Append("codeNum=@codeNum,");
strSql.Append("codeNumContract=@codeNumContract,");
strSql.Append("supplier=@supplier,");
strSql.Append("supplierAbb=@supplierAbb,");
strSql.Append("supplierUser=@supplierUser,");
strSql.Append("buyer=@buyer,");
strSql.Append("buyerAbb=@buyerAbb,");
strSql.Append("buyerUser=@buyerUser,");
strSql.Append("signDate=@signDate,");
strSql.Append("signAdd=@signAdd,");
strSql.Append("proName=@proName,");
strSql.Append("bondPro=@bondPro,");
strSql.Append("varieties=@varieties,");
strSql.Append("quaSpe=@quaSpe,");
strSql.Append("height=@height,");
strSql.Append("price=@price,");
strSql.Append("priceMY=@priceMY,");
strSql.Append("conutry=@conutry,");
strSql.Append("brand=@brand,");
strSql.Append("shipName=@shipName,");
strSql.Append("billNum=@billNum,");
strSql.Append("shipDate=@shipDate,");
strSql.Append("arriveDate=@arriveDate,");
strSql.Append("deliveryDate=@deliveryDate,");
strSql.Append("SGSDB=@SGSDB,");
strSql.Append("SGSTVN=@SGSTVN,");
strSql.Append("SGSZA=@SGSZA,");
strSql.Append("SGSZF=@SGSZF,");
strSql.Append("SGSSF=@SGSSF,");
strSql.Append("SGSSHY=@SGSSHY,");
strSql.Append("SGSS=@SGSS,");
strSql.Append("SGSSJ=@SGSSJ,");
strSql.Append("SGSHF=@SGSHF,");
strSql.Append("deliveryAdd=@deliveryAdd,");
strSql.Append("deliveryLast=@deliveryLast,");
strSql.Append("fishId=@fishId,");
strSql.Append("conProtein=@conProtein,");
strSql.Append("conTVN=@conTVN,");
strSql.Append("conZA=@conZA,");
strSql.Append("conFFA=@conFFA,");
strSql.Append("conZF=@conZF,");
strSql.Append("conSF=@conSF,");
strSql.Append("conSHY=@conSHY,");
strSql.Append("conS=@conS,");
strSql.Append("conSJ=@conSJ,");
strSql.Append("conHF=@conHF,");
strSql.Append("conLAS=@conLAS,");
strSql.Append("conDAS=@conDAS,");
strSql.Append("remark=@remark ");
strSql.Append(" where id=@id");
MySqlParameter [] parameters =
{
new MySqlParameter("@codeNum", MySqlDbType.VarChar, 30),
new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 30),
new MySqlParameter("@supplier", MySqlDbType.VarChar, 50),
new MySqlParameter("@supplierAbb", MySqlDbType.VarChar, 50),
new MySqlParameter("@supplierUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyer", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyerAbb", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyerUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@signDate", MySqlDbType.DateTime),
new MySqlParameter("@signAdd", MySqlDbType.VarChar, 100),
new MySqlParameter("@proName", MySqlDbType.VarChar, 100),
new MySqlParameter("@bondPro", MySqlDbType.Decimal, 18),
new MySqlParameter("@varieties", MySqlDbType.VarChar, 50),
new MySqlParameter("@quaSpe", MySqlDbType.VarChar, 50),
new MySqlParameter("@height", MySqlDbType.Decimal, 18),
new MySqlParameter("@price", MySqlDbType.Decimal, 18),
new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18),
new MySqlParameter("@conutry", MySqlDbType.VarChar, 30),
new MySqlParameter("@brand", MySqlDbType.VarChar, 30),
new MySqlParameter("@shipName", MySqlDbType.VarChar, 50),
new MySqlParameter("@billNum", MySqlDbType.VarChar, 50),
new MySqlParameter("@shipDate", MySqlDbType.DateTime),
new MySqlParameter("@arriveDate", MySqlDbType.DateTime),
new MySqlParameter("@deliveryDate", MySqlDbType.DateTime),
new MySqlParameter("@SGSDB", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSTVN", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSZA", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSZF", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSSF", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSSHY", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSS", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSSJ", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSHF", MySqlDbType.VarChar, 50),
new MySqlParameter("@deliveryAdd", MySqlDbType.VarChar, 50),
new MySqlParameter("@deliveryLast", MySqlDbType.DateTime),
new MySqlParameter("@fishId", MySqlDbType.VarChar, 50),
new MySqlParameter("@conProtein", MySqlDbType.VarChar, 50),
new MySqlParameter("@conTVN", MySqlDbType.VarChar, 50),
new MySqlParameter("@conZA", MySqlDbType.VarChar, 50),
new MySqlParameter("@conFFA", MySqlDbType.VarChar, 50),
new MySqlParameter("@conZF", MySqlDbType.VarChar, 50),
new MySqlParameter("@conSF", MySqlDbType.VarChar, 50),
new MySqlParameter("@conSHY", MySqlDbType.VarChar, 50),
new MySqlParameter("@conS", MySqlDbType.VarChar, 50),
new MySqlParameter("@conSJ", MySqlDbType.VarChar, 50),
new MySqlParameter("@conHF", MySqlDbType.VarChar, 50),
new MySqlParameter("@conLAS", MySqlDbType.VarChar, 50),
new MySqlParameter("@conDAS", MySqlDbType.VarChar, 50),
new MySqlParameter("@remark", MySqlDbType.VarChar, 255),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters [0].Value = model.codeNum;
parameters [1].Value = model.codeNumContract;
parameters [2].Value = model.supplier;
parameters [3].Value = model.supplierAbb;
parameters [4].Value = model.supplierUser;
parameters [5].Value = model.buyer;
parameters [6].Value = model.buyerAbb;
parameters [7].Value = model.buyerUser;
parameters [8].Value = model.signDate;
parameters [9].Value = model.signAdd;
parameters [10].Value = model.proName;
parameters [11].Value = model.bondPro;
parameters [12].Value = model.varieties;
parameters [13].Value = model.quaSpe;
parameters [14].Value = model.height;
parameters [15].Value = model.price;
parameters [16].Value = model.priceMY;
parameters [17].Value = model.conutry;
parameters [18].Value = model.brand;
parameters [19].Value = model.shipName;
parameters [20].Value = model.billNum;
parameters [21].Value = model.shipDate;
parameters [22].Value = model.arriveDate;
parameters [23].Value = model.deliveryDate;
parameters [24].Value = model.SGSDB;
parameters [25].Value = model.SGSTVN;
parameters [26].Value = model.SGSZA;
parameters [27].Value = model.SGSZF;
parameters [28].Value = model.SGSSF;
parameters [29].Value = model.SGSSHY;
parameters [30].Value = model.SGSS;
parameters [31].Value = model.SGSSJ;
parameters [32].Value = model.SGSHF;
parameters [33].Value = model.deliveryAdd;
parameters [34].Value = model.deliveryLast;
parameters [35].Value = model.fishId;
parameters [36].Value = model.conProtein;
parameters [37].Value = model.conTVN;
parameters [38].Value = model.conZA;
parameters [39].Value = model.conFFA;
parameters [40].Value = model.conZF;
parameters [41].Value = model.conSF;
parameters [42].Value = model.conSHY;
parameters [43].Value = model.conS;
parameters [44].Value = model.conSJ;
parameters [45].Value = model.conHF;
parameters [46].Value = model.conLAS;
parameters [47].Value = model.conDAS;
parameters [48].Value = model.remark;
parameters [49].Value = model.id;
return(MySqlHelper.ExecuteSql(strSql.ToString( ), parameters));
}
private FishEntity.PurchaseApplicationEntity getModel(DataRow row)
{
FishEntity.PurchaseApplicationEntity model = new FishEntity.PurchaseApplicationEntity( );
if (row != null)
{
if (row ["id"] != null && row ["id"].ToString( ) != "")
{
model.id = int.Parse(row ["id"].ToString( ));
}
if (row["process"] != null)
{
model.Process = row["process"].ToString();
}
if (row["Money"] != null)
{
model.Money = row["Money"].ToString();
}
if (row["Dollarjine"] != null && row["Dollarjine"].ToString() != "")
{
model.Dollarjine = decimal.Parse(row["Dollarjine"].ToString());
}
if (row["choise"] != null)
{
model.choise = row["choise"].ToString();
}
if (row ["codeNum"] != null)
{
model.codeNum = row ["codeNum"].ToString( );
}
if (row ["codeNumContract"] != null)
{
model.codeNumContract = row ["codeNumContract"].ToString( );
}
if (row ["supplier"] != null)
{
model.supplier = row ["supplier"].ToString( );
}
if (row ["supplierAbb"] != null)
{
model.supplierAbb = row ["supplierAbb"].ToString( );
}
if (row ["supplierUser"] != null)
{
model.supplierUser = row ["supplierUser"].ToString( );
}
if (row ["buyer"] != null)
{
model.buyer = row ["buyer"].ToString( );
}
if (row ["buyerAbb"] != null)
{
model.buyerAbb = row ["buyerAbb"].ToString( );
}
if (row ["buyerUser"] != null)
{
model.buyerUser = row ["buyerUser"].ToString( );
}
if (row ["purchase"] != null)
{
model.purchase = row ["purchase"].ToString( );
}
if (row ["purchaseAbb"] != null)
{
model.purchaseAbb = row ["purchaseAbb"].ToString( );
}
if (row ["purchaseUser"] != null)
{
model.purchaseUser = row ["purchaseUser"].ToString( );
}
if (row ["danjia"] != null && row ["danjia"].ToString( ) != "")
{
model.danjia = decimal.Parse(row ["danjia"].ToString( ));
}
if (row ["weight"] != null && row ["weight"].ToString( ) != "")
{
model.Weight = decimal.Parse(row ["weight"].ToString( ));
}
if (row["EexchangeRate"] != null && row["EexchangeRate"].ToString() != "")
{
model.EexchangeRate = decimal.Parse(row["EexchangeRate"].ToString());
}
if (row ["fishId"] != null)
{
model.FishId = row ["fishId"].ToString( );
}
if (row ["rebate"] != null && row ["rebate"].ToString( ) != "")
{
model.rebate = decimal.Parse(row ["rebate"].ToString( ));
}
if (row ["brands"] != null)
{
model.brands = row ["brands"].ToString( );
}
if (row ["country"] != null)
{
model.conutry = row ["country"].ToString( );
}
if (row ["proName"] != null)
{
model.proName = row ["proName"].ToString( );
}
if (row ["bondPro"] != null && row ["bondPro"].ToString( ) != "")
{
model.bondPro = decimal.Parse(row ["bondPro"].ToString( ));
}
if (row ["varieties"] != null)
{
model.varieties = row ["varieties"].ToString( );
}
if (row ["signDate"] != null && row ["signDate"].ToString( ) != "")
{
model.signDate = DateTime.Parse(row ["signDate"].ToString( ));
}
if (row ["signAdd"] != null)
{
model.signAdd = row ["signAdd"].ToString( );
}
if (row ["amountOfMoney"] != null && row ["amountOfMoney"].ToString( ) != "")
{
model.AmountOfMoney = decimal.Parse(row ["amountOfMoney"].ToString( ));
}
if (row ["priceMY"] != null && row ["priceMY"].ToString( ) != "")
{
model.priceMY = decimal.Parse(row ["priceMY"].ToString( ));
}
if (row ["remark"] != null)
{
model.remark = row ["remark"].ToString( );
}
if (row["account"] != null)
{
model.account = row["account"].ToString();
}
if (row["Bank"] != null)
{
model.Bank = row["Bank"].ToString();
}
if (row ["createUser"] != null)
{
model.createUser = row ["createUser"].ToString( );
}
if (row ["createDate"] != null && row ["createDate"].ToString( ) != "")
{
model.createDate = DateTime.Parse(row ["createDate"].ToString( ));
}
if (row ["modifyUser"] != null)
{
model.modifyUser = row ["modifyUser"].ToString( );
}
if (row ["modifyDate"] != null && row ["modifyDate"].ToString( ) != "")
{
model.modifyDate = DateTime.Parse(row ["modifyDate"].ToString( ));
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 新怎数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(FishEntity.PurchaseApplicationEntity model)
{
return(dal.Add(model));
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Edit(FishEntity.PurchaseApplicationEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update t_purchaseapplication set ");
strSql.Append("codeNum=@codeNum,");
strSql.Append("codeNumContract=@codeNumContract,");
strSql.Append("supplier=@supplier,");
strSql.Append("supplierAbb=@supplierAbb,");
strSql.Append("supplierUser=@supplierUser,");
strSql.Append("buyer=@buyer,");
strSql.Append("buyerAbb=@buyerAbb,");
strSql.Append("buyerUser=@buyerUser,");
strSql.Append("purchase=@purchase,");
strSql.Append("purchaseAbb=@purchaseAbb,");
strSql.Append("purchaseUser=@purchaseUser,");
strSql.Append("danjia=@danjia,");
strSql.Append("weight=@weight,");
strSql.Append("fishId=@fishId,");
strSql.Append("rebate=@rebate,");
strSql.Append("brands=@brands,");
strSql.Append("country=@country,");
strSql.Append("proName=@proName,");
strSql.Append("bondPro=@bondPro,");
strSql.Append("choise=@choise,");
strSql.Append("varieties=@varieties,");
strSql.Append("signDate=@signDate,");
strSql.Append("signAdd=@signAdd,");
strSql.Append("amountOfMoney=@amountOfMoney,");
strSql.Append("priceMY=@priceMY,");
strSql.Append("remark=@remark,");
strSql.Append("modifyUser=@modifyUser,");
strSql.Append("process=@process,");
strSql.Append("Money=@Money,");
strSql.Append("Dollarjine=@Dollarjine,");
strSql.Append("EexchangeRate=@EexchangeRate,");
strSql.Append("account=@account,");
strSql.Append("Bank=@Bank,");
strSql.Append("modifyDate=@modifyDate");
strSql.Append(" where id=@id");
MySqlParameter [] parameters =
{
new MySqlParameter("@codeNum", MySqlDbType.VarChar, 30),
new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 30),
new MySqlParameter("@supplier", MySqlDbType.VarChar, 50),
new MySqlParameter("@supplierAbb", MySqlDbType.VarChar, 50),
new MySqlParameter("@supplierUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyer", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyerAbb", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyerUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@purchase", MySqlDbType.VarChar, 45),
new MySqlParameter("@purchaseAbb", MySqlDbType.VarChar, 45),
new MySqlParameter("@purchaseUser", MySqlDbType.VarChar, 45),
new MySqlParameter("@danjia", MySqlDbType.Decimal, 18),
new MySqlParameter("@weight", MySqlDbType.Decimal, 18),
new MySqlParameter("@fishId", MySqlDbType.VarChar, 45),
new MySqlParameter("@rebate", MySqlDbType.Decimal, 18),
new MySqlParameter("@brands", MySqlDbType.VarChar, 45),
new MySqlParameter("@country", MySqlDbType.VarChar, 45),
new MySqlParameter("@proName", MySqlDbType.VarChar, 100),
new MySqlParameter("@bondPro", MySqlDbType.Decimal, 18),
new MySqlParameter("@varieties", MySqlDbType.VarChar, 50),
new MySqlParameter("@signDate", MySqlDbType.DateTime),
new MySqlParameter("@signAdd", MySqlDbType.VarChar, 100),
new MySqlParameter("@amountOfMoney", MySqlDbType.Decimal, 18),
new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18),
new MySqlParameter("@remark", MySqlDbType.VarChar, 255),
new MySqlParameter("@modifyUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@modifyDate", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@process", MySqlDbType.VarChar, 45),
new MySqlParameter("@choise", MySqlDbType.VarChar, 45),
new MySqlParameter("@EexchangeRate", MySqlDbType.VarChar, 45),
new MySqlParameter("@Money", MySqlDbType.VarChar, 45),
new MySqlParameter("@Dollarjine", MySqlDbType.VarChar, 45),
new MySqlParameter("@account", MySqlDbType.VarChar, 200),
new MySqlParameter("@Bank", MySqlDbType.VarChar, 200)
};
parameters [0].Value = model.codeNum;
parameters [1].Value = model.codeNumContract;
parameters [2].Value = model.supplier;
parameters [3].Value = model.supplierAbb;
parameters [4].Value = model.supplierUser;
parameters [5].Value = model.buyer;
parameters [6].Value = model.buyerAbb;
parameters [7].Value = model.buyerUser;
parameters [8].Value = model.purchase;
parameters [9].Value = model.purchaseAbb;
parameters [10].Value = model.purchaseUser;
parameters [11].Value = model.danjia;
parameters [12].Value = model.Weight;
parameters [13].Value = model.FishId;
parameters [14].Value = model.rebate;
parameters [15].Value = model.brands;
parameters [16].Value = model.conutry;
parameters [17].Value = model.proName;
parameters [18].Value = model.bondPro;
parameters [19].Value = model.varieties;
parameters [20].Value = model.signDate;
parameters [21].Value = model.signAdd;
parameters [22].Value = model.AmountOfMoney;
parameters [23].Value = model.priceMY;
parameters [24].Value = model.remark;
parameters [25].Value = model.modifyUser;
parameters [26].Value = model.modifyDate;
parameters [27].Value = model.id;
parameters[28].Value = model.Process;
parameters[29].Value = model.choise;
parameters[30].Value = model.EexchangeRate;
parameters[31].Value = model.Money;
parameters[32].Value = model.Dollarjine;
parameters[33].Value = model.account;
parameters[34].Value = model.Bank;
return(MySqlHelper.ExecuteSql(strSql.ToString( ), parameters));
}
/// <summary>
/// 新增数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(FishEntity.PurchaseApplicationEntity model)
{
//
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into t_purchaseapplication(");
strSql.Append("codeNum,codeNumContract,supplier,supplierAbb,supplierUser,buyer,buyerAbb,buyerUser,purchase,purchaseAbb,purchaseUser,danjia,weight,fishId,rebate,brands,country,proName,bondPro,varieties,signDate,signAdd,amountOfMoney,priceMY,remark,createUser,createDate,modifyUser,modifyDate,Process,choise,EexchangeRate,Money,Dollarjine,account,Bank)");
strSql.Append(" values (");
strSql.Append("@codeNum,@codeNumContract,@supplier,@supplierAbb,@supplierUser,@buyer,@buyerAbb,@buyerUser,@purchase,@purchaseAbb,@purchaseUser,@danjia,@weight,@fishId,@rebate,@brands,@country,@proName,@bondPro,@varieties,@signDate,@signAdd,@amountOfMoney,@priceMY,@remark,@createUser,@createDate,@modifyUser,@modifyDate,@Process,@choise,@EexchangeRate,@Money,@Dollarjine,@account,@Bank);select last_insert_id();");
MySqlParameter [] parameters =
{
new MySqlParameter("@codeNum", MySqlDbType.VarChar, 30),
new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 30),
new MySqlParameter("@supplier", MySqlDbType.VarChar, 50),
new MySqlParameter("@supplierAbb", MySqlDbType.VarChar, 50),
new MySqlParameter("@supplierUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyer", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyerAbb", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyerUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@purchase", MySqlDbType.VarChar, 45),
new MySqlParameter("@purchaseAbb", MySqlDbType.VarChar, 45),
new MySqlParameter("@purchaseUser", MySqlDbType.VarChar, 45),
new MySqlParameter("@danjia", MySqlDbType.Decimal, 18),
new MySqlParameter("@weight", MySqlDbType.Decimal, 18),
new MySqlParameter("@fishId", MySqlDbType.VarChar, 45),
new MySqlParameter("@rebate", MySqlDbType.Decimal, 18),
new MySqlParameter("@brands", MySqlDbType.VarChar, 45),
new MySqlParameter("@country", MySqlDbType.VarChar, 45),
new MySqlParameter("@proName", MySqlDbType.VarChar, 100),
new MySqlParameter("@bondPro", MySqlDbType.Decimal, 18),
new MySqlParameter("@varieties", MySqlDbType.VarChar, 50),
new MySqlParameter("@signDate", MySqlDbType.DateTime),
new MySqlParameter("@signAdd", MySqlDbType.VarChar, 100),
new MySqlParameter("@amountOfMoney", MySqlDbType.Decimal, 18),
new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18),
new MySqlParameter("@remark", MySqlDbType.VarChar, 255),
new MySqlParameter("@createUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@createDate", MySqlDbType.DateTime),
new MySqlParameter("@modifyUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@modifyDate", MySqlDbType.DateTime),
new MySqlParameter("@Process", MySqlDbType.VarChar, 45),
new MySqlParameter("@choise", MySqlDbType.VarChar, 45),
new MySqlParameter("@EexchangeRate", MySqlDbType.VarChar, 45),
new MySqlParameter("@Money", MySqlDbType.VarChar, 45),
new MySqlParameter("@Dollarjine", MySqlDbType.VarChar, 45),
new MySqlParameter("@account", MySqlDbType.VarChar, 200),
new MySqlParameter("@Bank", MySqlDbType.VarChar, 200)
};
parameters [0].Value = model.codeNum;
parameters [1].Value = model.codeNumContract;
parameters [2].Value = model.supplier;
parameters [3].Value = model.supplierAbb;
parameters [4].Value = model.supplierUser;
parameters [5].Value = model.buyer;
parameters [6].Value = model.buyerAbb;
parameters [7].Value = model.buyerUser;
parameters [8].Value = model.purchase;
parameters [9].Value = model.purchaseAbb;
parameters [10].Value = model.purchaseUser;
parameters [11].Value = model.danjia;
parameters [12].Value = model.Weight;
parameters [13].Value = model.FishId;
parameters [14].Value = model.rebate;
parameters [15].Value = model.brands;
parameters [16].Value = model.conutry;
parameters [17].Value = model.proName;
parameters [18].Value = model.bondPro;
parameters [19].Value = model.varieties;
parameters [20].Value = model.signDate;
parameters [21].Value = model.signAdd;
parameters [22].Value = model.AmountOfMoney;
parameters [23].Value = model.priceMY;
parameters [24].Value = model.remark;
parameters [25].Value = model.createUser;
parameters [26].Value = model.createDate;
parameters [27].Value = model.modifyUser;
parameters [28].Value = model.modifyDate;
parameters[29].Value = model.Process;
parameters[30].Value = model.choise;
parameters[31].Value = model.EexchangeRate;
parameters[32].Value = model.Money;
parameters[33].Value = model.Dollarjine;
parameters[34].Value = model.account;
parameters[35].Value = model.Bank;
return(MySqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters));
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Edit(FishEntity.PurchaseApplicationEntity model)
{
return(dal.Edit(model));
}
private FishEntity.PurchaseApplicationEntity getModel(DataRow row)
{
FishEntity.PurchaseApplicationEntity model = new FishEntity.PurchaseApplicationEntity( );
if (row != null)
{
if (row ["id"] != null && row ["id"].ToString( ) != "")
{
model.id = int.Parse(row ["id"].ToString( ));
}
if (row ["codeNum"] != null)
{
model.codeNum = row ["codeNum"].ToString( );
}
if (row ["codeNumContract"] != null)
{
model.codeNumContract = row ["codeNumContract"].ToString( );
}
if (row ["supplier"] != null)
{
model.supplier = row ["supplier"].ToString( );
}
if (row ["supplierAbb"] != null)
{
model.supplierAbb = row ["supplierAbb"].ToString( );
}
if (row ["supplierUser"] != null)
{
model.supplierUser = row ["supplierUser"].ToString( );
}
if (row ["buyer"] != null)
{
model.buyer = row ["buyer"].ToString( );
}
if (row ["buyerAbb"] != null)
{
model.buyerAbb = row ["buyerAbb"].ToString( );
}
if (row ["buyerUser"] != null)
{
model.buyerUser = row ["buyerUser"].ToString( );
}
if (row ["signDate"] != null && row ["signDate"].ToString( ) != "")
{
model.signDate = DateTime.Parse(row ["signDate"].ToString( ));
}
if (row ["signAdd"] != null)
{
model.signAdd = row ["signAdd"].ToString( );
}
if (row ["proName"] != null)
{
model.proName = row ["proName"].ToString( );
}
if (row ["bondPro"] != null && row ["bondPro"].ToString( ) != "")
{
model.bondPro = decimal.Parse(row ["bondPro"].ToString( ));
}
if (row ["varieties"] != null)
{
model.varieties = row ["varieties"].ToString( );
}
if (row ["quaSpe"] != null)
{
model.quaSpe = row ["quaSpe"].ToString( );
}
if (row ["height"] != null && row ["height"].ToString( ) != "")
{
model.height = decimal.Parse(row ["height"].ToString( ));
}
if (row ["price"] != null && row ["price"].ToString( ) != "")
{
model.price = decimal.Parse(row ["price"].ToString( ));
}
if (row ["priceMY"] != null && row ["priceMY"].ToString( ) != "")
{
model.priceMY = decimal.Parse(row ["priceMY"].ToString( ));
}
if (row ["conutry"] != null)
{
model.conutry = row ["conutry"].ToString( );
}
if (row ["brand"] != null)
{
model.brand = row ["brand"].ToString( );
}
if (row ["shipName"] != null)
{
model.shipName = row ["shipName"].ToString( );
}
if (row ["billNum"] != null)
{
model.billNum = row ["billNum"].ToString( );
}
if (row ["shipDate"] != null && row ["shipDate"].ToString( ) != "")
{
model.shipDate = DateTime.Parse(row ["shipDate"].ToString( ));
}
if (row ["arriveDate"] != null && row ["arriveDate"].ToString( ) != "")
{
model.arriveDate = DateTime.Parse(row ["arriveDate"].ToString( ));
}
if (row ["deliveryDate"] != null && row ["deliveryDate"].ToString( ) != "")
{
model.deliveryDate = DateTime.Parse(row ["deliveryDate"].ToString( ));
}
if (row ["SGSDB"] != null)
{
model.SGSDB = row ["SGSDB"].ToString( );
}
if (row ["SGSTVN"] != null)
{
model.SGSTVN = row ["SGSTVN"].ToString( );
}
if (row ["SGSZA"] != null)
{
model.SGSZA = row ["SGSZA"].ToString( );
}
if (row ["SGSZF"] != null)
{
model.SGSZF = row ["SGSZF"].ToString( );
}
if (row ["SGSSF"] != null)
{
model.SGSSF = row ["SGSSF"].ToString( );
}
if (row ["SGSSHY"] != null)
{
model.SGSSHY = row ["SGSSHY"].ToString( );
}
if (row ["SGSS"] != null)
{
model.SGSS = row ["SGSS"].ToString( );
}
if (row ["SGSSJ"] != null)
{
model.SGSSJ = row ["SGSSJ"].ToString( );
}
if (row ["SGSHF"] != null)
{
model.SGSHF = row ["SGSHF"].ToString( );
}
if (row ["deliveryAdd"] != null)
{
model.deliveryAdd = row ["deliveryAdd"].ToString( );
}
if (row ["deliveryLast"] != null && row ["deliveryLast"].ToString( ) != "")
{
model.deliveryLast = DateTime.Parse(row ["deliveryLast"].ToString( ));
}
if (row ["fishId"] != null)
{
model.fishId = row ["fishId"].ToString( );
}
if (row ["conProtein"] != null)
{
model.conProtein = row ["conProtein"].ToString( );
}
if (row ["conTVN"] != null)
{
model.conTVN = row ["conTVN"].ToString( );
}
if (row ["conZA"] != null)
{
model.conZA = row ["conZA"].ToString( );
}
if (row ["conFFA"] != null)
{
model.conFFA = row ["conFFA"].ToString( );
}
if (row ["conZF"] != null)
{
model.conZF = row ["conZF"].ToString( );
}
if (row ["conSF"] != null)
{
model.conSF = row ["conSF"].ToString( );
}
if (row ["conSHY"] != null)
{
model.conSHY = row ["conSHY"].ToString( );
}
if (row ["conS"] != null)
{
model.conS = row ["conS"].ToString( );
}
if (row ["conSJ"] != null)
{
model.conSJ = row ["conSJ"].ToString( );
}
if (row ["conHF"] != null)
{
model.conHF = row ["conHF"].ToString( );
}
if (row ["conLAS"] != null)
{
model.conLAS = row ["conLAS"].ToString( );
}
if (row ["conDAS"] != null)
{
model.conDAS = row ["conDAS"].ToString( );
}
if (row ["remark"] != null)
{
model.remark = row ["remark"].ToString( );
}
}
return(model);
}
/// <summary>
/// 新增数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(FishEntity.PurchaseApplicationEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into t_purchaseapplication(");
strSql.Append("codeNum,codeNumContract,supplier,supplierAbb,supplierUser,buyer,buyerAbb,buyerUser,signDate,signAdd,proName,bondPro,varieties,quaSpe,height,price,priceMY,conutry,brand,shipName,billNum,shipDate,arriveDate,deliveryDate,SGSDB,SGSTVN,SGSZA,SGSZF,SGSSF,SGSSHY,SGSS,SGSSJ,SGSHF,deliveryAdd,deliveryLast,fishId,conProtein,conTVN,conZA,conFFA,conZF,conSF,conSHY,conS,conSJ,conHF,conLAS,conDAS,remark)");
strSql.Append(" values (");
strSql.Append("@codeNum,@codeNumContract,@supplier,@supplierAbb,@supplierUser,@buyer,@buyerAbb,@buyerUser,@signDate,@signAdd,@proName,@bondPro,@varieties,@quaSpe,@height,@price,@priceMY,@conutry,@brand,@shipName,@billNum,@shipDate,@arriveDate,@deliveryDate,@SGSDB,@SGSTVN,@SGSZA,@SGSZF,@SGSSF,@SGSSHY,@SGSS,@SGSSJ,@SGSHF,@deliveryAdd,@deliveryLast,@fishId,@conProtein,@conTVN,@conZA,@conFFA,@conZF,@conSF,@conSHY,@conS,@conSJ,@conHF,@conLAS,@conDAS,@remark);select last_insert_id();");
MySqlParameter [] parameters =
{
new MySqlParameter("@codeNum", MySqlDbType.VarChar, 30),
new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 30),
new MySqlParameter("@supplier", MySqlDbType.VarChar, 50),
new MySqlParameter("@supplierAbb", MySqlDbType.VarChar, 50),
new MySqlParameter("@supplierUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyer", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyerAbb", MySqlDbType.VarChar, 50),
new MySqlParameter("@buyerUser", MySqlDbType.VarChar, 50),
new MySqlParameter("@signDate", MySqlDbType.DateTime),
new MySqlParameter("@signAdd", MySqlDbType.VarChar, 100),
new MySqlParameter("@proName", MySqlDbType.VarChar, 100),
new MySqlParameter("@bondPro", MySqlDbType.Decimal, 18),
new MySqlParameter("@varieties", MySqlDbType.VarChar, 50),
new MySqlParameter("@quaSpe", MySqlDbType.VarChar, 50),
new MySqlParameter("@height", MySqlDbType.Decimal, 18),
new MySqlParameter("@price", MySqlDbType.Decimal, 18),
new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18),
new MySqlParameter("@conutry", MySqlDbType.VarChar, 30),
new MySqlParameter("@brand", MySqlDbType.VarChar, 30),
new MySqlParameter("@shipName", MySqlDbType.VarChar, 50),
new MySqlParameter("@billNum", MySqlDbType.VarChar, 50),
new MySqlParameter("@shipDate", MySqlDbType.DateTime),
new MySqlParameter("@arriveDate", MySqlDbType.DateTime),
new MySqlParameter("@deliveryDate", MySqlDbType.DateTime),
new MySqlParameter("@SGSDB", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSTVN", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSZA", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSZF", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSSF", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSSHY", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSS", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSSJ", MySqlDbType.VarChar, 50),
new MySqlParameter("@SGSHF", MySqlDbType.VarChar, 50),
new MySqlParameter("@deliveryAdd", MySqlDbType.VarChar, 50),
new MySqlParameter("@deliveryLast", MySqlDbType.DateTime),
new MySqlParameter("@fishId", MySqlDbType.VarChar, 50),
new MySqlParameter("@conProtein", MySqlDbType.VarChar, 50),
new MySqlParameter("@conTVN", MySqlDbType.VarChar, 50),
new MySqlParameter("@conZA", MySqlDbType.VarChar, 50),
new MySqlParameter("@conFFA", MySqlDbType.VarChar, 50),
new MySqlParameter("@conZF", MySqlDbType.VarChar, 50),
new MySqlParameter("@conSF", MySqlDbType.VarChar, 50),
new MySqlParameter("@conSHY", MySqlDbType.VarChar, 50),
new MySqlParameter("@conS", MySqlDbType.VarChar, 50),
new MySqlParameter("@conSJ", MySqlDbType.VarChar, 50),
new MySqlParameter("@conHF", MySqlDbType.VarChar, 50),
new MySqlParameter("@conLAS", MySqlDbType.VarChar, 50),
new MySqlParameter("@conDAS", MySqlDbType.VarChar, 50),
new MySqlParameter("@remark", MySqlDbType.VarChar, 255)
};
parameters [0].Value = model.codeNum;
parameters [1].Value = model.codeNumContract;
parameters [2].Value = model.supplier;
parameters [3].Value = model.supplierAbb;
parameters [4].Value = model.supplierUser;
parameters [5].Value = model.buyer;
parameters [6].Value = model.buyerAbb;
parameters [7].Value = model.buyerUser;
parameters [8].Value = model.signDate;
parameters [9].Value = model.signAdd;
parameters [10].Value = model.proName;
parameters [11].Value = model.bondPro;
parameters [12].Value = model.varieties;
parameters [13].Value = model.quaSpe;
parameters [14].Value = model.height;
parameters [15].Value = model.price;
parameters [16].Value = model.priceMY;
parameters [17].Value = model.conutry;
parameters [18].Value = model.brand;
parameters [19].Value = model.shipName;
parameters [20].Value = model.billNum;
parameters [21].Value = model.shipDate;
parameters [22].Value = model.arriveDate;
parameters [23].Value = model.deliveryDate;
parameters [24].Value = model.SGSDB;
parameters [25].Value = model.SGSTVN;
parameters [26].Value = model.SGSZA;
parameters [27].Value = model.SGSZF;
parameters [28].Value = model.SGSSF;
parameters [29].Value = model.SGSSHY;
parameters [30].Value = model.SGSS;
parameters [31].Value = model.SGSSJ;
parameters [32].Value = model.SGSHF;
parameters [33].Value = model.deliveryAdd;
parameters [34].Value = model.deliveryLast;
parameters [35].Value = model.fishId;
parameters [36].Value = model.conProtein;
parameters [37].Value = model.conTVN;
parameters [38].Value = model.conZA;
parameters [39].Value = model.conFFA;
parameters [40].Value = model.conZF;
parameters [41].Value = model.conSF;
parameters [42].Value = model.conSHY;
parameters [43].Value = model.conS;
parameters [44].Value = model.conSJ;
parameters [45].Value = model.conHF;
parameters [46].Value = model.conLAS;
parameters [47].Value = model.conDAS;
parameters [48].Value = model.remark;
return(MySqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters));
}
