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 code " + operate + orderBy;
}
_model = _bll.GetModel(whereEx);
if (_model == null)
{
MessageBox.Show("已经没有记录了");
return;
}
setValue( );
}
public FormReturnReceipt(string name)
{
InitializeComponent();
_model = new FishEntity.ReturnReceiptEntity();
_bll = new FishBll.Bll.ReturnReceiptBll();
InitDataUtil.BindComboBoxData(txtcountry, FishEntity.Constant.CountryType, true);
InitDataUtil.BindComboBoxData(txtbrand, FishEntity.Constant.Brand, true);
InitDataUtil.BindComboBoxData(txtvarieties, FishEntity.Constant.Goods, true);
getname = name; panel1.Enabled = false;
}
public override int Add( )
{
clearControl( );
txtcode.Text = _bll.getCode( );
if (getname != null && getname != "")
{
FishEntity.SalesRequisitionEntity _model = new FishEntity.SalesRequisitionEntity();
_bll = new FishBll.Bll.ReturnReceiptBll();
_model = _bll.getTHD(getname);
if (_model != null)
{//22
txtcodeNumContract.Text = _model.code;
txtreturnParty.Text = _model.demand;
txtreturnParty.Tag = _model.demandId;
txtreturnPartyJ.Text = _model.DemandAbbreviation;
txtreceive.Text = _model.supplier;
txtreceiveJ.Text = _model.SupplierAbbreviation;
txtreceive.Tag = _model.supplierId;
txtfishId.Text = _model.Product_id;
txtcodeNum.Text = _model.Numbering;
txtcountry.Text = _model.Country;
txtbrand.Text = _model.pp;
txtspeci.Text = _model.Funit;
txtproName.Text = _model.Productname;
txtcondb.Text = _model.Db;
txtconza.Text = _model.Za;
txtcons.Text = _model.Sz;
txtcontvn.Text = _model.Tvn;
txtconhf.Text = _model.Hf;
txtconsf.Text = _model.Sf;
txtconshy.Text = _model.Shy;
txtconzf.Text = _model.Zf;
txtprice.Text = _model.HeTongDanJia;
txtdeliAdd.Text = _model.delivery;
if (_model.RabZy == true)
{
rabchengpin.Visible = false;
}
panel1.Enabled = true;
}
if (getname != null && getname != "")
{
FishEntity.OnepoundEntity _modeloo = new FishEntity.OnepoundEntity();
_bll = new FishBll.Bll.ReturnReceiptBll();
_modeloo = _bll.getjingz(getname);
if (_modeloo != null)
{
txtShipmentsTons.Text = _modeloo.Competition;
}
}
}
tmiSave.Visible = true;
return(base.Add( ));
}
public override int Query( )
{
FormOutboundOrderQuery form = new FormOutboundOrderQuery(this.Text + "查询");
if (form.ShowDialog( ) == DialogResult.OK)
{
strWhere = form.getWhere;
_model = _bll.GetModel(strWhere);
if (_model == null)
{
MessageBox.Show("没有记录了");
return(0);
}
setValue( );
}
return(base.Query( ));
}
private void FormReturnReceipt_Load(object sender, EventArgs e)
{
MenuCode = "M462"; ControlButtomRoles();
if (Megres.oddNum != "")
{
_rolewhere = " code='" + Megres.oddNum + "'";
_model = _bll.GetModel(_rolewhere);
}
Megres.oddNum = string.Empty;
if (_model == null)
{
MessageBox.Show("没有记录了");
}
else
{
setValue();
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FishEntity.ReturnReceiptEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update t_returnreceipt set ");
strSql.Append("codeNum=@codeNum,");
strSql.Append("codeNumContract=@codeNumContract,");
strSql.Append("returnParty=@returnParty,");
strSql.Append("receive=@receive,");
strSql.Append("signDate=@signDate,");
strSql.Append("varieties=@varieties,");
strSql.Append("inputDate=@inputDate,");
strSql.Append("returnPartyJ=@returnPartyJ,");
strSql.Append("receiveJ=@receiveJ,");
strSql.Append("proName=@proName,");
strSql.Append("speci=@speci,");
strSql.Append("tons=@tons,");
strSql.Append("ShipmentsTons=@ShipmentsTons,");
strSql.Append("LiNumber=@LiNumber,");
strSql.Append("price=@price,");
strSql.Append("money=@money,");
strSql.Append("country=@country,");
strSql.Append("brand=@brand,");
strSql.Append("deliAdd=@deliAdd,");
strSql.Append("fishId=@fishId,");
strSql.Append("freight=@freight,");
strSql.Append("cost=@cost,");
strSql.Append("loss=@loss,");
strSql.Append("condb=@condb,");
strSql.Append("conza=@conza,");
strSql.Append("cons=@cons,");
strSql.Append("contvn=@contvn,");
strSql.Append("conhf=@conhf,");
strSql.Append("consf=@consf,");
strSql.Append("conshy=@conshy,");
strSql.Append("conzf=@conzf,");
strSql.Append("returnGoodsAdd=@returnGoodsAdd,");
strSql.Append("duanxuan=@duanxuan,");
strSql.Append("remark=@remark");
strSql.Append(" where code=@code ");
MySqlParameter [] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeNum", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 45),
new MySqlParameter("@returnParty", MySqlDbType.VarChar, 45),
new MySqlParameter("@receive", MySqlDbType.VarChar, 45),
new MySqlParameter("@signDate", MySqlDbType.Date),
new MySqlParameter("@varieties", MySqlDbType.VarChar, 45),
new MySqlParameter("@inputDate", MySqlDbType.Date),
new MySqlParameter("@returnPartyJ", MySqlDbType.VarChar, 45),
new MySqlParameter("@receiveJ", MySqlDbType.VarChar, 45),
new MySqlParameter("@proName", MySqlDbType.VarChar, 45),
new MySqlParameter("@speci", MySqlDbType.VarChar, 45),
new MySqlParameter("@tons", MySqlDbType.Decimal, 10),
new MySqlParameter("@price", MySqlDbType.Decimal, 10),
new MySqlParameter("@money", MySqlDbType.Decimal, 10),
new MySqlParameter("@country", MySqlDbType.VarChar, 45),
new MySqlParameter("@brand", MySqlDbType.VarChar, 45),
new MySqlParameter("@deliAdd", MySqlDbType.VarChar, 45),
new MySqlParameter("@fishId", MySqlDbType.VarChar, 45),
new MySqlParameter("@freight", MySqlDbType.Decimal, 10),
new MySqlParameter("@cost", MySqlDbType.Decimal, 10),
new MySqlParameter("@loss", MySqlDbType.Decimal, 10),
new MySqlParameter("@condb", MySqlDbType.VarChar, 45),
new MySqlParameter("@conza", MySqlDbType.VarChar, 45),
new MySqlParameter("@cons", MySqlDbType.VarChar, 45),
new MySqlParameter("@contvn", MySqlDbType.VarChar, 45),
new MySqlParameter("@conhf", MySqlDbType.VarChar, 45),
new MySqlParameter("@consf", MySqlDbType.VarChar, 45),
new MySqlParameter("@conshy", MySqlDbType.VarChar, 45),
new MySqlParameter("@conzf", MySqlDbType.VarChar, 45),
new MySqlParameter("@returnGoodsAdd", MySqlDbType.VarChar, 45),
new MySqlParameter("@remark", MySqlDbType.VarChar, 225),
new MySqlParameter("@duanxuan", MySqlDbType.VarChar, 45),
new MySqlParameter("@LiNumber", MySqlDbType.Decimal, 10),
new MySqlParameter("@ShipmentsTons", MySqlDbType.Decimal, 45)
};
parameters [0].Value = model.code;
parameters [1].Value = model.codeNum;
parameters [2].Value = model.codeNumContract;
parameters [3].Value = model.returnParty;
parameters [4].Value = model.receive;
parameters [5].Value = model.signDate;
parameters [6].Value = model.varieties;
parameters [7].Value = model.inputDate;
parameters [8].Value = model.returnPartyJ;
parameters [9].Value = model.receiveJ;
parameters [10].Value = model.proName;
parameters [11].Value = model.speci;
parameters [12].Value = model.tons;
parameters [13].Value = model.price;
parameters [14].Value = model.money;
parameters [15].Value = model.country;
parameters [16].Value = model.brand;
parameters [17].Value = model.deliAdd;
parameters [18].Value = model.fishId;
parameters [19].Value = model.freight;
parameters [20].Value = model.cost;
parameters [21].Value = model.loss;
parameters [22].Value = model.condb;
parameters [23].Value = model.conza;
parameters [24].Value = model.cons;
parameters [25].Value = model.contvn;
parameters [26].Value = model.conhf;
parameters [27].Value = model.consf;
parameters [28].Value = model.conshy;
parameters [29].Value = model.conzf;
parameters [30].Value = model.returnGoodsAdd;
parameters [31].Value = model.remark;
parameters[32].Value = model.duanxuan;
parameters[33].Value = model.LiNumber;
parameters[34].Value = model.ShipmentsTons;
int rows = MySqlHelper.ExecuteSql(strSql.ToString( ), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FishEntity.ReturnReceiptEntity DataRowToModel(DataRow row)
{
FishEntity.ReturnReceiptEntity model = new FishEntity.ReturnReceiptEntity( );
if (row != null)
{
if (row ["id"] != null && row ["id"].ToString( ) != "")
{
model.id = int.Parse(row ["id"].ToString( ));
}
if (row ["code"] != null)
{
model.code = row ["code"].ToString( );
}
if (row ["codeNum"] != null)
{
model.codeNum = row ["codeNum"].ToString( );
}
if (row ["codeNumContract"] != null)
{
model.codeNumContract = row ["codeNumContract"].ToString( );
}
if (row["duanxuan"] != null)
{
model.duanxuan = row["duanxuan"].ToString();
}
if (row ["returnParty"] != null)
{
model.returnParty = row ["returnParty"].ToString( );
}
if (row ["receive"] != null)
{
model.receive = row ["receive"].ToString( );
}
if (row ["signDate"] != null && row ["signDate"].ToString( ) != "")
{
model.signDate = DateTime.Parse(row ["signDate"].ToString( ));
}
if (row ["varieties"] != null)
{
model.varieties = row ["varieties"].ToString( );
}
if (row ["inputDate"] != null && row ["inputDate"].ToString( ) != "")
{
model.inputDate = DateTime.Parse(row ["inputDate"].ToString( ));
}
if (row ["returnPartyJ"] != null)
{
model.returnPartyJ = row ["returnPartyJ"].ToString( );
}
if (row ["receiveJ"] != null)
{
model.receiveJ = row ["receiveJ"].ToString( );
}
if (row ["proName"] != null)
{
model.proName = row ["proName"].ToString( );
}
if (row ["speci"] != null)
{
model.speci = row ["speci"].ToString( );
}
if (row ["tons"] != null && row ["tons"].ToString( ) != "")
{
model.tons = decimal.Parse(row ["tons"].ToString( ));
}
if (row["ShipmentsTons"] != null && row["ShipmentsTons"].ToString() != "")
{
model.ShipmentsTons = decimal.Parse(row["ShipmentsTons"].ToString());
}
if (row["LiNumber"] != null && row["LiNumber"].ToString() != "")
{
model.LiNumber = decimal.Parse(row["LiNumber"].ToString());
}
if (row ["price"] != null && row ["price"].ToString( ) != "")
{
model.price = decimal.Parse(row ["price"].ToString( ));
}
if (row ["money"] != null && row ["money"].ToString( ) != "")
{
model.money = decimal.Parse(row ["money"].ToString( ));
}
if (row ["country"] != null)
{
model.country = row ["country"].ToString( );
}
if (row ["brand"] != null)
{
model.brand = row ["brand"].ToString( );
}
if (row ["deliAdd"] != null)
{
model.deliAdd = row ["deliAdd"].ToString( );
}
if (row ["fishId"] != null)
{
model.fishId = row ["fishId"].ToString( );
}
if (row ["freight"] != null && row ["freight"].ToString( ) != "")
{
model.freight = decimal.Parse(row ["freight"].ToString( ));
}
if (row ["cost"] != null && row ["cost"].ToString( ) != "")
{
model.cost = decimal.Parse(row ["cost"].ToString( ));
}
if (row ["loss"] != null && row ["loss"].ToString( ) != "")
{
model.loss = decimal.Parse(row ["loss"].ToString( ));
}
if (row ["condb"] != null)
{
model.condb = row ["condb"].ToString( );
}
if (row ["conza"] != null)
{
model.conza = row ["conza"].ToString( );
}
if (row ["cons"] != null)
{
model.cons = row ["cons"].ToString( );
}
if (row ["contvn"] != null)
{
model.contvn = row ["contvn"].ToString( );
}
if (row ["conhf"] != null)
{
model.conhf = row ["conhf"].ToString( );
}
if (row ["consf"] != null)
{
model.consf = row ["consf"].ToString( );
}
if (row ["conshy"] != null)
{
model.conshy = row ["conshy"].ToString( );
}
if (row ["conzf"] != null)
{
model.conzf = row ["conzf"].ToString( );
}
if (row ["returnGoodsAdd"] != null)
{
model.returnGoodsAdd = row ["returnGoodsAdd"].ToString( );
}
if (row ["remark"] != null)
{
model.remark = row ["remark"].ToString( );
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FishEntity.ReturnReceiptEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into t_returnreceipt(");
strSql.Append("id,code,codeNum,codeNumContract,returnParty,receive,signDate,varieties,inputDate,returnPartyJ,receiveJ,proName,speci,tons,ShipmentsTons,price,money,country,brand,deliAdd,fishId,freight,cost,loss,condb,conza,cons,contvn,conhf,consf,conshy,conzf,returnGoodsAdd,remark,duanxuan,LiNumber)");
strSql.Append(" values (");
strSql.Append("@id,@code,@codeNum,@codeNumContract,@returnParty,@receive,@signDate,@varieties,@inputDate,@returnPartyJ,@receiveJ,@proName,@speci,@tons,@ShipmentsTons,@price,@money,@country,@brand,@deliAdd,@fishId,@freight,@cost,@loss,@condb,@conza,@cons,@contvn,@conhf,@consf,@conshy,@conzf,@returnGoodsAdd,@remark,@duanxuan,@LiNumber)");
MySqlParameter [] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeNum", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 45),
new MySqlParameter("@returnParty", MySqlDbType.VarChar, 45),
new MySqlParameter("@receive", MySqlDbType.VarChar, 45),
new MySqlParameter("@signDate", MySqlDbType.Date),
new MySqlParameter("@varieties", MySqlDbType.VarChar, 45),
new MySqlParameter("@inputDate", MySqlDbType.Date),
new MySqlParameter("@returnPartyJ", MySqlDbType.VarChar, 45),
new MySqlParameter("@receiveJ", MySqlDbType.VarChar, 45),
new MySqlParameter("@proName", MySqlDbType.VarChar, 45),
new MySqlParameter("@speci", MySqlDbType.VarChar, 45),
new MySqlParameter("@tons", MySqlDbType.Decimal, 10),
new MySqlParameter("@price", MySqlDbType.Decimal, 10),
new MySqlParameter("@money", MySqlDbType.Decimal, 10),
new MySqlParameter("@country", MySqlDbType.VarChar, 45),
new MySqlParameter("@brand", MySqlDbType.VarChar, 45),
new MySqlParameter("@deliAdd", MySqlDbType.VarChar, 45),
new MySqlParameter("@fishId", MySqlDbType.VarChar, 45),
new MySqlParameter("@freight", MySqlDbType.Decimal, 10),
new MySqlParameter("@cost", MySqlDbType.Decimal, 10),
new MySqlParameter("@loss", MySqlDbType.Decimal, 10),
new MySqlParameter("@condb", MySqlDbType.VarChar, 45),
new MySqlParameter("@conza", MySqlDbType.VarChar, 45),
new MySqlParameter("@cons", MySqlDbType.VarChar, 45),
new MySqlParameter("@contvn", MySqlDbType.VarChar, 45),
new MySqlParameter("@conhf", MySqlDbType.VarChar, 45),
new MySqlParameter("@consf", MySqlDbType.VarChar, 45),
new MySqlParameter("@conshy", MySqlDbType.VarChar, 45),
new MySqlParameter("@conzf", MySqlDbType.VarChar, 45),
new MySqlParameter("@returnGoodsAdd", MySqlDbType.VarChar, 45),
new MySqlParameter("@remark", MySqlDbType.VarChar, 225),
new MySqlParameter("@duanxuan", MySqlDbType.VarChar, 45),
new MySqlParameter("@LiNumber", MySqlDbType.Decimal, 10),
new MySqlParameter("@ShipmentsTons", MySqlDbType.Decimal, 45)
};
parameters [0].Value = model.id;
parameters [1].Value = model.code;
parameters [2].Value = model.codeNum;
parameters [3].Value = model.codeNumContract;
parameters [4].Value = model.returnParty;
parameters [5].Value = model.receive;
parameters [6].Value = model.signDate;
parameters [7].Value = model.varieties;
parameters [8].Value = model.inputDate;
parameters [9].Value = model.returnPartyJ;
parameters [10].Value = model.receiveJ;
parameters [11].Value = model.proName;
parameters [12].Value = model.speci;
parameters [13].Value = model.tons;
parameters [14].Value = model.price;
parameters [15].Value = model.money;
parameters [16].Value = model.country;
parameters [17].Value = model.brand;
parameters [18].Value = model.deliAdd;
parameters [19].Value = model.fishId;
parameters [20].Value = model.freight;
parameters [21].Value = model.cost;
parameters [22].Value = model.loss;
parameters [23].Value = model.condb;
parameters [24].Value = model.conza;
parameters [25].Value = model.cons;
parameters [26].Value = model.contvn;
parameters [27].Value = model.conhf;
parameters [28].Value = model.consf;
parameters [29].Value = model.conshy;
parameters [30].Value = model.conzf;
parameters [31].Value = model.returnGoodsAdd;
parameters [32].Value = model.remark;
parameters[33].Value = model.duanxuan;
parameters[34].Value = model.LiNumber;
parameters[25].Value = model.ShipmentsTons;
int rows = MySqlHelper.ExecuteSql(strSql.ToString( ), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FishEntity.ReturnReceiptEntity model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FishEntity.ReturnReceiptEntity model)
{
return(dal.Update(model));
}
