public override int Query()
{
if (_BillForm == null)
{
_BillForm = new UIForms.FormBillofladingCondition();
_BillForm.StartPosition = FormStartPosition.CenterParent;
_BillForm.ShowInTaskbar = false;
}
if (_BillForm.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return(0);
}
_where = _BillForm.GetWhereCondition;
List <FishEntity.BillofladingEntityVo> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy);
if (list == null || list.Count < 1)
{
_fish = null;
return(1);
}
else
{
_fish = list[0];
SetOnepound();
panel1.Enabled = true;
return(1);
}
}
protected void AddImages(FishEntity.BillofladingEntity 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);
}
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 dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.ColumnIndex < 0 || e.RowIndex < 0)
{
return;
}
if (dataGridView1.Columns[e.ColumnIndex].Name.Equals("codeOne", StringComparison.OrdinalIgnoreCase) == true)
{
_model = new FishEntity.BillofladingEntity();
if (dataGridView1.Rows[e.RowIndex].Cells["RedemptionWeight"].Value != null && dataGridView1.Rows[e.RowIndex].Cells["RedemptionWeight"].Value.ToString() != "")
{
_model.RedemptionWeight = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["RedemptionWeight"].Value.ToString());
}
else
{
_model.RedemptionWeight = 0;
}
_model.Code = dataGridView1.Rows[e.RowIndex].Cells["codeOne"].Value.ToString();
_model.Specification = dataGridView1.Rows[e.RowIndex].Cells["specification"].Value.ToString();
_model.Ferryname = dataGridView1.Rows[e.RowIndex].Cells["ferryname"].Value.ToString();
_model.Cornerno = dataGridView1.Rows[e.RowIndex].Cells["cornerno"].Value.ToString();
_model.Listname = dataGridView1.Rows[e.RowIndex].Cells["listname"].Value.ToString();
_model.Warehouse = dataGridView1.Rows[e.RowIndex].Cells["warehouse"].Value.ToString();
_model.Country = dataGridView1.Rows[e.RowIndex].Cells["Country"].Value.ToString();
_model.Brands = dataGridView1.Rows[e.RowIndex].Cells["Brands"].Value.ToString();
this.DialogResult = DialogResult.OK;
}
}
public int Add(FishEntity.BillofladingEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_billoflading(Numbering,code,Issuingtime,contactsunit,ContactsunitId,warehouse,species,specification,ferryname,listname,cornerno,Ton,packagenumber,Remarks,ShipNotice,Storagecosts,createtime,createman,modifytime,modifyman,codeContract,Recipient,SerialNumber )");
strSql.Append("values(@Numbering,@code,@Issuingtime,@contactsunit,@ContactsunitId,@warehouse,@species,@specification,@ferryname,@listname,@cornerno,@Ton,@packagenumber,@Remarks,@ShipNotice,@Storagecosts,@createtime,@createman,@modifytime,@modifyman,@codeContract,@Recipient,@SerialNumber );select last_insert_id();");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@Issuingtime", MySqlDbType.Timestamp),
new MySqlParameter("@contactsunit", MySqlDbType.VarChar, 100),
new MySqlParameter("@warehouse", MySqlDbType.VarChar, 100),
new MySqlParameter("@species", MySqlDbType.VarChar, 45),
new MySqlParameter("@specification", MySqlDbType.VarChar, 45),
new MySqlParameter("@ferryname", MySqlDbType.VarChar, 45),
new MySqlParameter("@listname", MySqlDbType.VarChar, 45),
new MySqlParameter("@Ton", MySqlDbType.VarChar, 45),
new MySqlParameter("@packagenumber", MySqlDbType.VarChar, 45),
new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500),
new MySqlParameter("@ShipNotice", MySqlDbType.VarChar, 200),
new MySqlParameter("@Storagecosts", 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("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@Recipient", MySqlDbType.VarChar, 445),
new MySqlParameter("@cornerno", MySqlDbType.VarChar, 45),
new MySqlParameter("@ContactsunitId", MySqlDbType.VarChar, 100),
new MySqlParameter("@SerialNumber", MySqlDbType.VarBinary, 100),
new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Issuingtime;
parameters[2].Value = model.Contactsunit;
parameters[3].Value = model.Warehouse;
parameters[4].Value = model.Species;
parameters[5].Value = model.Specification;
parameters[6].Value = model.Ferryname;
parameters[7].Value = model.Listname;
parameters[8].Value = model.Ton;
parameters[9].Value = model.Packagenumber;
parameters[10].Value = model.Remarks;
parameters[11].Value = model.ShipNotice;
parameters[12].Value = model.Storagecosts;
parameters[13].Value = model.Createtime;
parameters[14].Value = model.Createman;
parameters[15].Value = model.Modifytime;
parameters[16].Value = model.Modifyman;
parameters [17].Value = model.codeContract;
parameters[18].Value = model.Recipient;
parameters[19].Value = model.Cornerno;
parameters[20].Value = model.ContactsunitId;
parameters[21].Value = model.SerialNumber;
parameters[22].Value = model.Numbering;
int id = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameters); //MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
return(id);
}
private void dataGridView4_CellClick(object sender, DataGridViewCellEventArgs e)
{
//if ( e . ColumnIndex < 0 || e . RowIndex < 0 )
// return;
//if ( dataGridView4 . Columns [ e . ColumnIndex ] . Name . Equals ( "yftdh" ,StringComparison . OrdinalIgnoreCase ) == true )
//{
// FormBilloflading from = new FormBilloflading ( );
// DialogResult result = from . ShowDialog ( );
// if ( result == DialogResult . OK )
// {
// dataGridView4 . Rows [ e . RowIndex ] . Cells [ "yftdh" ] . Value = from . bdh;
// }
//}
if (e.ColumnIndex < 0 || e.RowIndex < 0)
{
return;
}
if (dataGridView4.Columns[e.ColumnIndex].Name.Equals("yftdh", StringComparison.OrdinalIgnoreCase) == true)
{
FormBilloftable form = new FormBilloftable();
DialogResult result = form.ShowDialog();
if (result == DialogResult.OK)
{
bool isOk = true;
FishEntity.BillofladingEntity _model = form.bil;
for (int i = 0; i < dataGridView4.Rows.Count - 1; i++)
{
if (!string.IsNullOrEmpty(dataGridView1.Rows[i].Cells["product_id"].Value.ToString()))// && dataGridView1.Rows[i].Cells["product_id"].Value.ToString() == _model.Code
{
if (i != e.RowIndex)
{
isOk = false;
break;
}
}
}
if (isOk == false)
{
return;
}
dataGridView4.Rows[e.RowIndex].Cells["yfcm"].Value = _model.Ferryname;
dataGridView4.Rows[e.RowIndex].Cells["yftdh"].Value = _model.Listname;
}
}
}
private void FormBilloflading_Load(object sender, EventArgs e)
{
MenuCode = "M403"; ControlButtomRoles();
if (Megres.oddNum != null && Megres.oddNum.ToString() != "")
{
_rolewhere = " and code='" + Megres.oddNum + "'";
List <FishEntity.BillofladingEntityVo> list = _bll.GetModelListVo(_rolewhere);
if (list == null || list.Count < 1)
{
_fish = null;
}
else
{
_fish = list[0];
SetOnepound();
panel1.Enabled = true;
}
}
Megres.oddNum = string.Empty;
}
private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (dataGridView1.CurrentRow == null)
{
return;
}
_model = new FishEntity.BillofladingEntity();
if (dataGridView1.Rows[e.RowIndex].Cells["ferryname"].Value != null)
{
_model.Ferryname = dataGridView1.Rows[e.RowIndex].Cells["ferryname"].Value.ToString();
}
if (dataGridView1.Rows[e.RowIndex].Cells["listname"].Value != null)
{
_model.Listname = dataGridView1.Rows[e.RowIndex].Cells["listname"].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();
}
if (dataGridView1.Rows[e.RowIndex].Cells["Contactsunit"].Value != null)
{
_model.Contactsunit = dataGridView1.Rows[e.RowIndex].Cells["Contactsunit"].Value.ToString();
}
if (dataGridView1.Rows[e.RowIndex].Cells["packagenumber"].Value != null)
{
_model.Packagenumber = dataGridView1.Rows[e.RowIndex].Cells["packagenumber"].Value.ToString();
}
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
public override void Save()
{
if (GetValue() == false)
{
return;
}
FishEntity.BillofladingEntity _fish = new FishEntity.BillofladingEntity();
if (string.IsNullOrEmpty(txtcontactsunit.Text) == false)
{
_fish.Contactsunit = txtcontactsunit.Text.Trim().ToString();
}
else
{
MessageBox.Show("请选择提货单位。");
return;
}
if (string.IsNullOrEmpty(txtCodeOdd.Text))
{
MessageBox.Show("请选择销售合同号");
return;
}
_fish.Code = FishBll.Bll.SequenceUtil.GetBillofladingnumber();
_fish.ContactsunitId = txtcontactsunit.Tag.ToString();
_fish.Issuingtime = dtpIssuingtime.Value;
_fish.Warehouse = txtwarehouse.Text.ToString();
_fish.Species = cmbspecies.SelectedValue == null ? string.Empty : cmbspecies.SelectedValue.ToString();
_fish.Specification = cmbspecification.SelectedValue == null ? string.Empty : cmbspecification.SelectedValue.ToString();
_fish.Ferryname = txtferryname.Text.ToString();
_fish.FishMealId = txtFishMealId.Text.ToString();
_fish.Country = cmbCountry.SelectedValue == null ? string.Empty : cmbCountry.SelectedValue.ToString();
_fish.Brands = cmbBrands.SelectedValue == null ? string.Empty : cmbBrands.SelectedValue.ToString();
_fish.Listname = txtlistname.Text.ToString();
_fish.Cornerno = txtcornerno.Text.ToString();
_fish.Ton = txtTon.Text;
decimal temp = 0;
decimal.TryParse(txtRedemptionWeight.Text, out temp);
_fish.RedemptionWeight = temp;
_fish.Packagenumber = txtpackagenumber.Text;
_fish.Remarks = txtRemarks.Text.ToString().Trim();
_fish.SerialNumber = txtSerialNumber.Text.ToString();
_fish.ShipNotice = txtShipNotice.Text.ToString().Trim();
_fish.Storagecosts = txtStoragecosts.Text;
_fish.Createtime = DateTime.Now;
_fish.Createman = FishEntity.Variable.User.username;
_fish.Modifytime = DateTime.Now;
_fish.Modifyman = _fish.Createman;
_fish.codeContract = txtCodeOdd.Text;
_fish.Recipient = txtRecipient.Text;
_fish.Numbering = txtNumbering.Text;
FishBll.Bll.BillofladingBll bll = new FishBll.Bll.BillofladingBll();
bool isok = bll.Exists(_fish.Code);
while (isok)
{
_fish.Code = FishBll.Bll.SequenceUtil.GetBillofladingnumber();
isok = bll.Exists(_fish.Code);
}
int id = bll.Add(_fish, this.Name);
if (id > 0)
{
//if (txtNumbering.Text!="")
//{
// _Refreshbll = new FishBll.Bll.ProcessStateBll();
// _Refreshbll.GetFormBilloflading(txtNumbering.Text);
//}
_fish.Id = id;
AddImages(_fish);
tmiQuery.Visible = false;
tmiDelete.Visible = false;
tmiModify.Visible = true;
tmiAdd.Visible = false;
tmiSave.Visible = false;
tmiCancel.Visible = true;
MessageBox.Show("添加成功。");
txtcode.Text = _fish.Code;
}
else
{
txtcode.Text = _fish.Code;
MessageBox.Show("添加失败。");
}
}
public int Add(FishEntity.BillofladingEntity 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_billoflading(Numbering,code,Issuingtime,contactsunit,ContactsunitId,warehouse,species,specification,ferryname,listname,cornerno,Ton,RedemptionWeight,packagenumber,Remarks,ShipNotice,Storagecosts,createtime,createman,modifytime,modifyman,codeContract,Recipient,SerialNumber,FishMealId,Country,Brands )");
strSql.Append("values(@Numbering,@code,@Issuingtime,@contactsunit,@ContactsunitId,@warehouse,@species,@specification,@ferryname,@listname,@cornerno,@Ton,@RedemptionWeight,@packagenumber,@Remarks,@ShipNotice,@Storagecosts,@createtime,@createman,@modifytime,@modifyman,@codeContract,@Recipient,@SerialNumber,@FishMealId,@Country,@Brands );select last_insert_id();");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@Issuingtime", MySqlDbType.Timestamp),
new MySqlParameter("@contactsunit", MySqlDbType.VarChar, 100),
new MySqlParameter("@warehouse", MySqlDbType.VarChar, 100),
new MySqlParameter("@species", MySqlDbType.VarChar, 45),
new MySqlParameter("@specification", MySqlDbType.VarChar, 45),
new MySqlParameter("@ferryname", MySqlDbType.VarChar, 45),
new MySqlParameter("@listname", MySqlDbType.VarChar, 45),
new MySqlParameter("@Ton", MySqlDbType.VarChar, 45),
new MySqlParameter("@packagenumber", MySqlDbType.VarChar, 45),
new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500),
new MySqlParameter("@ShipNotice", MySqlDbType.VarChar, 200),
new MySqlParameter("@Storagecosts", 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("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@Recipient", MySqlDbType.VarChar, 445),
new MySqlParameter("@cornerno", MySqlDbType.VarChar, 45),
new MySqlParameter("@ContactsunitId", MySqlDbType.VarChar, 100),
new MySqlParameter("@SerialNumber", MySqlDbType.VarBinary, 100),
new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45),
new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Country", MySqlDbType.VarChar, 50),
new MySqlParameter("@Brands", MySqlDbType.VarChar, 50),
new MySqlParameter("@RedemptionWeight", MySqlDbType.Decimal, 45)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Issuingtime;
parameters[2].Value = model.Contactsunit;
parameters[3].Value = model.Warehouse;
parameters[4].Value = model.Species;
parameters[5].Value = model.Specification;
parameters[6].Value = model.Ferryname;
parameters[7].Value = model.Listname;
parameters[8].Value = model.Ton;
parameters[9].Value = model.Packagenumber;
parameters[10].Value = model.Remarks;
parameters[11].Value = model.ShipNotice;
parameters[12].Value = model.Storagecosts;
parameters[13].Value = model.Createtime;
parameters[14].Value = model.Createman;
parameters[15].Value = model.Modifytime;
parameters[16].Value = model.Modifyman;
parameters [17].Value = model.codeContract;
parameters[18].Value = model.Recipient;
parameters[19].Value = model.Cornerno;
parameters[20].Value = model.ContactsunitId;
parameters[21].Value = model.SerialNumber;
parameters[22].Value = model.Numbering;
parameters[23].Value = model.FishMealId;
parameters[24].Value = model.Country;
parameters[25].Value = model.Brands;
parameters[26].Value = model.RedemptionWeight;
SQLString.Add(strSql, parameters);
if (MySqlHelper.ExecuteSqlTran(SQLString))
{
strSql = new StringBuilder( );
strSql.AppendFormat("select id from t_billoflading 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 bool Update(FishEntity.BillofladingEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_billoflading set ");
strSql.Append("Issuingtime = @Issuingtime,");
strSql.Append("codeContract = @codeContract,");
strSql.Append("contactsunit = @contactsunit,");
strSql.Append("ContactsunitId = @ContactsunitId,");
strSql.Append("warehouse = @warehouse,");
strSql.Append("species = @species,");
strSql.Append("specification = @specification,");
strSql.Append("cornerno = @cornerno,");
strSql.Append("ferryname = @ferryname,");
strSql.Append("listname = @listname,");
strSql.Append("Ton = @Ton,");
strSql.Append("packagenumber = @packagenumber,");
strSql.Append("Remarks = @Remarks,");
strSql.Append("SerialNumber=@SerialNumber,");
strSql.Append(" ShipNotice = @ShipNotice,");
strSql.Append("modifyman = @modifyman,");
strSql.Append("Storagecosts = @Storagecosts,");
strSql.Append("FishMealId = @FishMealId,");
strSql.Append("Country = @Country,");
strSql.Append("Brands = @Brands,");
strSql.Append("RedemptionWeight=@RedemptionWeight,");
strSql.Append("Recipient=@Recipient ");
strSql.Append(" where id = @id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Issuingtime", MySqlDbType.DateTime),
new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@contactsunit", MySqlDbType.VarChar, 100),
new MySqlParameter("@warehouse", MySqlDbType.VarChar, 100),
new MySqlParameter("@species", MySqlDbType.VarChar, 45),
new MySqlParameter("@specification", MySqlDbType.VarChar, 45),
new MySqlParameter("@cornerno", MySqlDbType.VarChar, 45),
new MySqlParameter("@ferryname", MySqlDbType.VarChar, 45),
new MySqlParameter("@listname", MySqlDbType.VarChar, 45),
new MySqlParameter("@Ton", MySqlDbType.VarChar, 45),
new MySqlParameter("@packagenumber", MySqlDbType.VarChar, 45),
new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500),
new MySqlParameter("@ShipNotice", MySqlDbType.VarChar, 200),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@Storagecosts", MySqlDbType.VarChar, 45),
new MySqlParameter("@Recipient", MySqlDbType.VarChar, 445),
new MySqlParameter("@ContactsunitId", MySqlDbType.VarChar, 100),
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@SerialNumber", MySqlDbType.VarChar, 100),
new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Country", MySqlDbType.VarChar, 50),
new MySqlParameter("@Brands", MySqlDbType.VarChar, 50),
new MySqlParameter("@RedemptionWeight", MySqlDbType.Decimal, 45)
};
parameters[0].Value = model.Issuingtime;
parameters[1].Value = model.codeContract;
parameters[2].Value = model.Contactsunit;
parameters[3].Value = model.Warehouse;
parameters[4].Value = model.Species;
parameters[5].Value = model.Specification;
parameters[6].Value = model.Cornerno;
parameters[7].Value = model.Ferryname;
parameters[8].Value = model.Listname;
parameters[9].Value = model.Ton;
parameters[10].Value = model.Packagenumber;
parameters[11].Value = model.Remarks;
parameters[12].Value = model.ShipNotice;
parameters[13].Value = model.Modifytime;
parameters[14].Value = model.Modifyman;
parameters[15].Value = model.Storagecosts;
parameters[16].Value = model.Recipient;
parameters[17].Value = model.ContactsunitId;
parameters [18].Value = model.Id;
parameters[19].Value = model.SerialNumber;
parameters[20].Value = model.FishMealId;
parameters[21].Value = model.Country;
parameters[22].Value = model.Brands;
parameters[23].Value = model.RedemptionWeight;
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Update(FishEntity.BillofladingEntity model)
{
return(dal.Update(model));
}
public int Add(FishEntity.BillofladingEntity model, string name)
{
return(dal.Add(model, name));
}
public int Add(FishEntity.BillofladingEntity model)
{
return(dal.Add(model));
}
