public override int Query() { panel1.Enabled = true; if (_queryForm == null) { _queryForm = new UIForms.FormOnepoundCondition(); _queryForm.StartPosition = FormStartPosition.CenterParent; _queryForm.ShowInTaskbar = false; } if (_queryForm.ShowDialog() != System.Windows.Forms.DialogResult.OK) { return(0); } _where = _queryForm.GetWhereCondition; List <FishEntity.OnepoundEntityVo> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy); if (list == null || list.Count < 1) { _fish = null; MessageBox.Show("查无数据!"); return(1); } else { _fish = list[0]; SetOnepound(); return(1); } //return base.Query(); }
protected void AddImages(FishEntity.OnepoundEntity fish) { if (fish == null) { return; } FishBll.Bll.ImageBll bll = new FishBll.Bll.ImageBll(); if (fish.Id > 0) { bll.DeleteByRecordIdAndType(fish.Id, (int)FishEntity.ImageTypeEnum.Onepoundcode); } List <FishEntity.ImageEntity> images = GetSGSImages(); images = 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); } } }
private void FormOnepound_Load(object sender, EventArgs e) { MenuCode = "M402"; ControlButtomRoles(); if (Megres.oddNum != null && Megres.oddNum != "") { _rolewhere = " and code='" + Megres.oddNum + "'"; getname = Megres.oddNum; List <FishEntity.OnepoundEntityVo> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy); Megres.oddNum = string.Empty; if (list == null || list.Count < 1) { _fish = null; } else { _fish = list[0]; SetOnepound(); this.panel1.Enabled = true; menuStrip1.Visible = true; tmiQuery.Visible = true; tmiPrevious.Visible = false; tmiExport.Visible = false; tmiReview.Visible = true; tmiAdd.Visible = true; tmiModify.Visible = true; tmiDelete.Visible = false; tmiClose.Visible = true; tmiCancel.Visible = false; tmiSave.Visible = false; tmiNext.Visible = false; tmiprint.Visible = 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( )); }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex < 0 || e.RowIndex < 0) { return; } fish = new FishEntity.OnepoundEntity(); if (dataGridView1.CurrentRow == null) { return; } if (dataGridView1.Rows[e.RowIndex].Cells["codeOne"].Value != null && dataGridView1.Columns[e.ColumnIndex].Name.Equals("codeOne", StringComparison.OrdinalIgnoreCase) == true) { fish.Competition = dataGridView1.Rows[e.RowIndex].Cells["Competition"].Value.ToString(); fish.Code = dataGridView1.Rows[e.RowIndex].Cells["codeOne"].Value.ToString(); fish.FishMealId = dataGridView1.Rows[e.RowIndex].Cells["FishMealId"].Value.ToString(); this.DialogResult = System.Windows.Forms.DialogResult.OK; } }
public FishEntity.OnepoundEntity getjingz(string Numbering) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SUM(Competition)as Competition from t_poundsalone "); strSql.Append("where Numbering= '" + Numbering + "'"); DataSet ds = MySqlHelper.Query(strSql.ToString()); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { FishEntity.OnepoundEntity model = new FishEntity.OnepoundEntity(); DataRow row = ds.Tables[0].Rows[0]; if (row["Competition"] != null && row["Competition"].ToString() != "") { model.Competition = row["Competition"].ToString(); } return(model); } else { return(null); } }
public bool Update(FishEntity.OnepoundEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_poundsalone set "); strSql.Append("Dateofmanufacture = @Dateofmanufacture,"); strSql.Append("IntothefactoryDate = @IntothefactoryDate,"); strSql.Append("Carnumber = @Carnumber,"); strSql.Append("Grossweight = @Grossweight,"); strSql.Append("Tareweight = @Tareweight,"); strSql.Append("Competition = @Competition,"); strSql.Append("Goods = @Goods,"); strSql.Append("Remarks=@Remarks,"); strSql.Append("Shipno=@Shipno,"); strSql.Append("Owner = @Owner,"); strSql.Append("OwnerId = @OwnerId,"); strSql.Append("modifytime = @modifytime,"); strSql.Append("modifyman = @modifyman,"); strSql.Append("BuyersId = @BuyersId,"); strSql.Append("Address = @Address,code = @code,"); strSql.Append("Serialnumber = @Serialnumber,Buyers = @Buyers,"); strSql.Append("Sellers = @Sellers,Country = @Country,"); strSql.Append("PName = @PName,Qualit = @Qualit,"); strSql.Append("Quantity = @Quantity,Pileangle = @Pileangle,"); strSql.Append("BillOfLadingid = @BillOfLadingid,"); strSql.Append("codeContract = @codeContract, "); strSql.Append("SellersId = @SellersId "); strSql.Append(" where id = @id"); MySqlParameter[] parameters = { new MySqlParameter("@Dateofmanufacture", MySqlDbType.Timestamp), new MySqlParameter("@IntothefactoryDate", MySqlDbType.Timestamp), new MySqlParameter("@Carnumber", MySqlDbType.VarChar, 45), new MySqlParameter("@Grossweight", MySqlDbType.VarChar, 45), new MySqlParameter("@Tareweight", MySqlDbType.VarChar, 45), new MySqlParameter("@Competition", MySqlDbType.VarChar, 45), new MySqlParameter("@Goods", MySqlDbType.VarChar, 45), new MySqlParameter("@Owner", MySqlDbType.VarChar, 45), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@Address", MySqlDbType.VarChar, 100), new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@Serialnumber", MySqlDbType.VarChar, 45), new MySqlParameter("@Buyers", MySqlDbType.VarChar, 45), new MySqlParameter("@Sellers", MySqlDbType.VarChar, 45), new MySqlParameter("@Country", MySqlDbType.VarChar, 45), new MySqlParameter("@PName", MySqlDbType.VarChar, 45), new MySqlParameter("@Qualit", MySqlDbType.VarChar, 45), new MySqlParameter("@Quantity", MySqlDbType.VarChar, 45), new MySqlParameter("@Pileangle", MySqlDbType.VarChar, 45), new MySqlParameter("@BillOfLadingid", MySqlDbType.VarChar, 45), new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200), new MySqlParameter("@id", MySqlDbType.Int16, 11), new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500), new MySqlParameter("@Shipno", MySqlDbType.VarChar, 45), new MySqlParameter("@OwnerId", MySqlDbType.VarChar, 45), new MySqlParameter("@BuyersId", MySqlDbType.VarChar, 45), new MySqlParameter("@SellersId", MySqlDbType.VarChar, 45) }; parameters[0].Value = model.Dateofmanufacture; parameters[1].Value = model.IntothefactoryDate; parameters[2].Value = model.Carnumber; parameters[3].Value = model.Grossweight; parameters[4].Value = model.Tareweight; parameters[5].Value = model.Competition; parameters[6].Value = model.Goods; parameters[7].Value = model.Owner; parameters[8].Value = model.Modifytime; parameters[9].Value = model.Modifyman; parameters[10].Value = model.Address; parameters[11].Value = model.Code; parameters[12].Value = model.Serialnumber; parameters[13].Value = model.Buyers; parameters[14].Value = model.Sellers; parameters[15].Value = model.Country; parameters[16].Value = model.PName; parameters[17].Value = model.Qualit; parameters[18].Value = model.Quantity; parameters[19].Value = model.Pileangle; parameters[20].Value = model.BillOfLadingid; parameters[21].Value = model.codeContract; parameters[22].Value = model.Id; parameters[23].Value = model.Remarks; parameters[24].Value = model.Shipno; parameters[25].Value = model.OwnerId; parameters[26].Value = model.BuyersId; parameters[27].Value = model.SellersId; int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public int Add(FishEntity.OnepoundEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_poundsalone("); strSql.Append("Numbering,code,Dateofmanufacture,IntothefactoryDate,Carnumber,Grossweight,Tareweight,Competition,Goods,Remarks,Shipno,Owner,OwnerId,createtime,createman,modifytime,modifyman,Address,Buyers,BuyersId,Sellers,SellersId,Country,PName,Qualit,Quantity,Pileangle,BillOfLadingid,Serialnumber,codeContract)"); strSql.Append("values("); strSql.Append("@Numbering,@code,@Dateofmanufacture,@Intothefactorydate,@Carnumber,@Grossweight,@Tareweight,@Competition,@Goods,@Remarks,@Shipno,@Owner,@OwnerId,@createtime,@createman,@modifytime,@modifyman,@Address,@Buyers,@BuyersId,@Sellers,@SellersId,@Country,@PName,@Qualit,@Quantity,@Pileangle,@BillOfLadingid,@Serialnumber,@codeContract);"); strSql.Append("select last_insert_id();"); MySqlParameter[] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@Dateofmanufacture", MySqlDbType.Timestamp), new MySqlParameter("@IntothefactoryDate", MySqlDbType.Timestamp), new MySqlParameter("@Carnumber", MySqlDbType.VarChar, 45), new MySqlParameter("@Grossweight", MySqlDbType.VarChar, 45), new MySqlParameter("@Tareweight", MySqlDbType.VarChar, 45), new MySqlParameter("@Competition", MySqlDbType.VarChar, 45), new MySqlParameter("@Goods", MySqlDbType.VarChar, 45), new MySqlParameter("@Owner", MySqlDbType.VarChar, 45), new MySqlParameter("@createtime", MySqlDbType.Timestamp), new MySqlParameter("@createman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@Address", MySqlDbType.VarChar, 100), new MySqlParameter("@Serialnumber", MySqlDbType.VarChar, 45), new MySqlParameter("@Buyers", MySqlDbType.VarChar, 45), new MySqlParameter("@Sellers", MySqlDbType.VarChar, 45), new MySqlParameter("@Country", MySqlDbType.VarChar, 45), new MySqlParameter("@PName", MySqlDbType.VarChar, 45), new MySqlParameter("@Qualit", MySqlDbType.VarChar, 45), new MySqlParameter("@Quantity", MySqlDbType.VarChar, 45), new MySqlParameter("@Pileangle", MySqlDbType.VarChar, 45), new MySqlParameter("@BillOfLadingid", MySqlDbType.VarChar, 45), new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200), new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500), new MySqlParameter("@Shipno", MySqlDbType.VarChar, 45), new MySqlParameter("@OwnerId", MySqlDbType.VarChar, 45), new MySqlParameter("@BuyersId", MySqlDbType.VarChar, 45), new MySqlParameter("@SellersId", MySqlDbType.VarChar, 45), new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45) }; parameters[0].Value = model.Code; parameters[1].Value = model.Dateofmanufacture; parameters[2].Value = model.IntothefactoryDate; parameters[3].Value = model.Carnumber; parameters[4].Value = model.Grossweight; parameters[5].Value = model.Tareweight; parameters[6].Value = model.Competition; parameters[7].Value = model.Goods; parameters[8].Value = model.Owner; parameters[9].Value = model.Createtime; parameters[10].Value = model.Createman; parameters[11].Value = model.Modifytime; parameters[12].Value = model.Modifyman; parameters[13].Value = model.Address; parameters[14].Value = model.Serialnumber; parameters[15].Value = model.Buyers; parameters[16].Value = model.Sellers; parameters[17].Value = model.Country; parameters[18].Value = model.PName; parameters[19].Value = model.Qualit; parameters[20].Value = model.Quantity; parameters[21].Value = model.Pileangle; parameters[22].Value = model.BillOfLadingid; parameters[23].Value = model.codeContract; parameters[24].Value = model.Remarks; parameters[25].Value = model.Shipno; parameters[26].Value = model.OwnerId; parameters[27].Value = model.BuyersId; parameters[28].Value = model.SellersId; parameters[29].Value = model.Numbering; int id = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameters); //MySqlHelper.ExecuteSql(strSql.ToString(), parameters); return(id); }
public override void Save() { FishEntity.OnepoundEntity _fish = new FishEntity.OnepoundEntity(); _fish.Buyers = Buyers.Text; if (string.IsNullOrEmpty(Sellers.Text) == false) { FishEntity.CompanyEntity company = Sellers.Tag as FishEntity.CompanyEntity; _fish.Sellers = Sellers.Text.ToString(); } else { MessageBox.Show("请选择销售商。"); return; } if (string.IsNullOrEmpty(txtCodeOdd.Text)) { MessageBox.Show("请选择销售合同号"); return; } if (GetValue() == false) { return; } decimal temp = 0; _fish.Code = FishBll.Bll.SequenceUtil.GerLadingNumber(); _fish.OwnerId = txtOwner.Tag.ToString(); _fish.BuyersId = Buyers.Tag.ToString(); _fish.SellersId = Sellers.Tag.ToString(); _fish.Dateofmanufacture = dtpfactureDate.Value; _fish.IntothefactoryDate = dtpfactoryDate.Value; _fish.Carnumber = txtCarnumber.Text.Trim(); _fish.Goods = cmbspecies.SelectedValue == null ? string.Empty : cmbspecies.SelectedValue.ToString(); _fish.Remarks = txtRemarks.Text; _fish.Shipno = txtshipno.Text; _fish.Grossweight = txtGrossweight.Text; _fish.Tareweight = txtTareweight.Text; _fish.Competition = txtCompetition.Text; _fish.Owner = txtOwner.Text.Trim(); _fish.Quantity = Quantity.Text.Trim(); _fish.Pileangle = Pileangle.Text.Trim(); _fish.BillOfLadingid = BillOfLadingid.Text.Trim(); _fish.PName = cmbName.SelectedValue == null ? string.Empty : cmbName.SelectedValue.ToString(); _fish.Country = cmbCountry.SelectedValue == null ? string.Empty : cmbCountry.SelectedValue.ToString(); _fish.Qualit = txtSpecification.Text; _fish.Serialnumber = Serialnumber.Text.Trim(); _fish.Address = txtAddress.Text.Trim(); _fish.Createtime = DateTime.Now; _fish.Createman = FishEntity.Variable.User.username; _fish.Modifytime = DateTime.Now; _fish.Modifyman = _fish.Createman; _fish.codeContract = txtCodeOdd.Text; _fish.Numbering = txtNumbering.Text; FishBll.Bll.OnepoundBll bll = new FishBll.Bll.OnepoundBll(); bool isok = bll.Exists(_fish.Code); while (isok) { _fish.Code = FishBll.Bll.SequenceUtil.GerLadingNumber(); isok = bll.Exists(_fish.Code); } int id = bll.Add(_fish); if (id > 0) { if (txtNumbering.Text != "") { _Refreshbll = new FishBll.Bll.ProcessStateBll(); _Refreshbll.GetFormOnepound(txtNumbering.Text); } _fish.Id = id; AddImages(_fish); tmiQuery.Visible = false; tmiDelete.Visible = false; tmiModify.Visible = false; tmiAdd.Visible = true; tmiSave.Visible = false; tmiCancel.Visible = true; MessageBox.Show("添加成功。"); txtCode.Text = _fish.Code.ToString(); } else { // txtCode.Text = _fish.Code; MessageBox.Show("添加失败。"); } }
public bool Update(FishEntity.OnepoundEntity model) { return dal.Update(model); }
public int Add(FishEntity.OnepoundEntity model,string name) { return dal . Add ( model ,name ); }
public int Add(FishEntity.OnepoundEntity model, string name) { Hashtable SQLString = new Hashtable( ); SQLString = ReviewInfo.getSQLString(name, model.Code, string.Empty, SQLString); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_poundsalone("); strSql.Append("FishMealId,Numbering,code,Dateofmanufacture,IntothefactoryDate,Carnumber,Grossweight,Tareweight,Competition,TiDanCode,RedemptionWeight,Goods,Remarks,Shipno,Owner,OwnerId,createtime,createman,modifytime,modifyman,Address,Buyers,BuyersId,Sellers,SellersId,Country,PName,Qualit,Quantity,Pileangle,BillOfLadingid,Serialnumber,codeContract)"); strSql.Append("values("); strSql.Append("@FishMealId,@Numbering,@code,@Dateofmanufacture,@Intothefactorydate,@Carnumber,@Grossweight,@Tareweight,@Competition,@TiDanCode,@RedemptionWeight,@Goods,@Remarks,@Shipno,@Owner,@OwnerId,@createtime,@createman,@modifytime,@modifyman,@Address,@Buyers,@BuyersId,@Sellers,@SellersId,@Country,@PName,@Qualit,@Quantity,@Pileangle,@BillOfLadingid,@Serialnumber,@codeContract);"); //strSql.Append("select last_insert_id();"); MySqlParameter[] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@Dateofmanufacture", MySqlDbType.Timestamp), new MySqlParameter("@IntothefactoryDate", MySqlDbType.Timestamp), new MySqlParameter("@Carnumber", MySqlDbType.VarChar, 45), new MySqlParameter("@Grossweight", MySqlDbType.VarChar, 45), new MySqlParameter("@Tareweight", MySqlDbType.VarChar, 45), new MySqlParameter("@Competition", MySqlDbType.VarChar, 45), new MySqlParameter("@Goods", MySqlDbType.VarChar, 45), new MySqlParameter("@Owner", MySqlDbType.VarChar, 45), new MySqlParameter("@createtime", MySqlDbType.Timestamp), new MySqlParameter("@createman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@Address", MySqlDbType.VarChar, 100), new MySqlParameter("@Serialnumber", MySqlDbType.VarChar, 45), new MySqlParameter("@Buyers", MySqlDbType.VarChar, 45), new MySqlParameter("@Sellers", MySqlDbType.VarChar, 45), new MySqlParameter("@Country", MySqlDbType.VarChar, 45), new MySqlParameter("@PName", MySqlDbType.VarChar, 45), new MySqlParameter("@Qualit", MySqlDbType.VarChar, 45), new MySqlParameter("@Quantity", MySqlDbType.VarChar, 45), new MySqlParameter("@Pileangle", MySqlDbType.VarChar, 45), new MySqlParameter("@BillOfLadingid", MySqlDbType.VarChar, 45), new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200), new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500), new MySqlParameter("@Shipno", MySqlDbType.VarChar, 45), new MySqlParameter("@OwnerId", MySqlDbType.VarChar, 45), new MySqlParameter("@BuyersId", MySqlDbType.VarChar, 45), new MySqlParameter("@SellersId", MySqlDbType.VarChar, 45), new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45), new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50), new MySqlParameter("@TiDanCode", MySqlDbType.VarChar, 45), new MySqlParameter("@RedemptionWeight", MySqlDbType.Decimal, 45) }; parameters[0].Value = model.Code; parameters[1].Value = model.Dateofmanufacture; parameters[2].Value = model.IntothefactoryDate; parameters[3].Value = model.Carnumber; parameters[4].Value = model.Grossweight; parameters[5].Value = model.Tareweight; parameters[6].Value = model.Competition; parameters[7].Value = model.Goods; parameters[8].Value = model.Owner; parameters[9].Value = model.Createtime; parameters[10].Value = model.Createman; parameters[11].Value = model.Modifytime; parameters[12].Value = model.Modifyman; parameters[13].Value = model.Address; parameters[14].Value = model.Serialnumber; parameters[15].Value = model.Buyers; parameters[16].Value = model.Sellers; parameters[17].Value = model.Country; parameters[18].Value = model.PName; parameters[19].Value = model.Qualit; parameters[20].Value = model.Quantity; parameters[21].Value = model.Pileangle; parameters[22].Value = model.BillOfLadingid; parameters[23].Value = model.codeContract; parameters[24].Value = model.Remarks; parameters[25].Value = model.Shipno; parameters[26].Value = model.OwnerId; parameters[27].Value = model.BuyersId; parameters[28].Value = model.SellersId; parameters[29].Value = model.Numbering; parameters[30].Value = model.FishMealId; parameters[31].Value = model.TiDanCode; parameters[32].Value = model.RedemptionWeight; SQLString.Add(strSql, parameters); if (MySqlHelper.ExecuteSqlTran(SQLString)) { strSql = new StringBuilder( ); strSql.AppendFormat("select id from t_poundsalone where code='{0}'", model.Code); DataTable dt = MySqlHelper.Query(strSql.ToString( )).Tables [0]; if (dt != null && dt.Rows.Count > 0) { return(string.IsNullOrEmpty(dt.Rows [0] ["id"].ToString( )) == true ? 0 : Convert.ToInt32(dt.Rows [0] ["id"].ToString( ))); } else { return(0); } } else { return(0); } }
public int Add(FishEntity.OnepoundEntity model) { return(dal.Add(model)); }