public FormShippingRecordsedit(string title, FishEntity.ShippingRecordsEntity entity)
{
InitializeComponent();
BindData();
_entity = entity;
if (_entity != null)
{
//cmbPort.SelectedValue == null ? string.Empty : cmbPort.SelectedValue.ToString()
dtppickuptime.Value = _entity.Pickuptime.Value;
txttonnage.Text = _entity.Tonnage.ToString();
txtNumberOfPacks.Text = _entity.NumberOfPacks.ToString();
txtShippingUnit.Text = _entity.ShippingUnit;
txtArrivalUnit.Text = _entity.ArrivalUnit;
txtFreight.Text = _entity.Freight;
txtCarNumber.Text = _entity.CarNumber;
txtShipName.Text = _entity.ShipName;
txtBillOfLadingNumber.Text = _entity.BillOfLadingNumber;
cmbCountry.SelectedValue = _entity.Country.ToString();
cmbBrand.SelectedValue = _entity.Brand.ToString();
cmbquality.SelectedValue = _entity.Quality == null ? string.Empty : _entity.Quality.ToString();
dtpProductionDate.Value = _entity.ProductionDate.Value;
txtRemarks.Text = _entity.Remarks;
}
this.Text = title;
}
private void btnOk_Click(object sender, EventArgs e)
{
bool isAdd = false;
if (_entity == null)
{
_entity = new FishEntity.ShippingRecordsEntity();
isAdd = true;
}
ShippingRecordsset();
FishBll.Bll.ShippingRecordsBll bll = new FishBll.Bll.ShippingRecordsBll();
if (_entity.Code != "" && _entity.Code != null)
{
}
else
{
_entity.Code = FishBll.Bll.SequenceUtil.GerShippingRecords();
}
bool isok = bll.Exists(_entity.Code);
while (isok)
{
_entity.Code = FishBll.Bll.SequenceUtil.GerShippingRecords();
isok = bll.Exists(_entity.Code);
}
if (isAdd)
{
_entity.Modifyman = FishEntity.Variable.User.username;
_entity.Modifytime = DateTime.Now;
_entity.Createman = _entity.Modifyman;
_entity.Createtime = DateTime.Now;
FishBll.Bll.ShippingRecordsBll _bll = new FishBll.Bll.ShippingRecordsBll();
int id = _bll.add(_entity);
if (id > 0)
{
OnRefresh();
}
MessageBox.Show("添加成功");
}
else
{
_entity.Modifyman = FishEntity.Variable.User.username;
_entity.Modifytime = DateTime.Now;
FishBll.Bll.ShippingRecordsBll _bll = new FishBll.Bll.ShippingRecordsBll();
bool isOk = _bll.Update(_entity);
if (isOk)
{
OnRefresh();
}
MessageBox.Show("编辑成功");
}
this.Close();
}
public int Add(FishEntity.ShippingRecordsEntity model)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("insert into t_shippingrecords (code,pickuptime,tonnage,NumberOfPacks,ShippingUnit,ArrivalUnit,Freight,CarNumber,ShipName,BillOfLadingNumber,Country,Brand,quality,ProductionDate,Remarks,createtime,createman,modifytime,modifyman)");
strsql.Append("values(@code,@pickuptime,@tonnage,@NumberOfPacks,@ShippingUnit,@ArrivalUnit,@Freight,@CarNumber,@ShipName,@BillOfLadingNumber,@Country,@Brand,@quality,@ProductionDate,@Remarks,@createtime,@createman,@modifytime,@modifyman)");
MySqlParameter[] Parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@pickuptime", MySqlDbType.DateTime),
new MySqlParameter("@tonnage", MySqlDbType.Decimal, 45),
new MySqlParameter("@NumberOfPacks", MySqlDbType.Int32, 11),
new MySqlParameter("@ShippingUnit", MySqlDbType.VarChar, 45),
new MySqlParameter("@ArrivalUnit", MySqlDbType.VarChar, 45),
new MySqlParameter("@Freight", MySqlDbType.VarChar, 45),
new MySqlParameter("@CarNumber", MySqlDbType.VarChar, 45),
new MySqlParameter("@ShipName", MySqlDbType.VarChar, 45),
new MySqlParameter("@BillOfLadingNumber", MySqlDbType.VarChar, 45),
new MySqlParameter("@Country", MySqlDbType.VarChar, 45),
new MySqlParameter("@Brand", MySqlDbType.VarChar, 45),
new MySqlParameter("@quality", MySqlDbType.VarChar, 45),
new MySqlParameter("@ProductionDate", MySqlDbType.DateTime),
new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500),
new MySqlParameter("@createtime", MySqlDbType.Timestamp),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45)
};
Parameters[0].Value = model.Code;
Parameters[1].Value = model.Pickuptime;
Parameters[2].Value = model.Tonnage;
Parameters[3].Value = model.NumberOfPacks;
Parameters[4].Value = model.ShippingUnit;
Parameters[5].Value = model.ArrivalUnit;
Parameters[6].Value = model.Freight;
Parameters[7].Value = model.CarNumber;
Parameters[8].Value = model.ShipName;
Parameters[9].Value = model.BillOfLadingNumber;
Parameters[10].Value = model.Country;
Parameters[11].Value = model.Brand;
Parameters[12].Value = model.Quality;
Parameters[13].Value = model.ProductionDate;
Parameters[14].Value = model.Remarks;
Parameters[15].Value = model.Createtime;
Parameters[16].Value = model.Createman;
Parameters[17].Value = model.Modifytime;
Parameters[18].Value = model.Modifyman;
int id = MySqlHelper.ExecuteSqlReturnId(strsql.ToString(), Parameters);
return(id);
}
public override int Modify()
{
if (dataGridView1.CurrentCell == null)
{
MessageBox.Show("请选择要编辑的行");
return(0);
}
FishEntity.ShippingRecordsEntity entity = dataGridView1.CurrentRow.DataBoundItem as FishEntity.ShippingRecordsEntity;
if (entity == null)
{
MessageBox.Show("请选择需要编辑的行");
return(0);
}
FormShippingRecordsedit inven = new FormShippingRecordsedit("编辑数据", entity);
inven.RefreshEvent += form_RefreshEvent;
inven.ShowDialog();
return(0);
}
public bool Update(FishEntity.ShippingRecordsEntity model)
{
return(dal.Update(model));
}
public int add(FishEntity.ShippingRecordsEntity model)
{
return(dal.Add(model));
}
public FishEntity.ShippingRecordsEntity DataRowToModel(DataRow row)
{
FishEntity.ShippingRecordsEntity model = new FishEntity.ShippingRecordsEntity();
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["pickuptime"] != null && row["pickuptime"].ToString() != "")
{
model.Pickuptime = DateTime.Parse(row["pickuptime"].ToString());
}
if (row["tonnage"] != null && row["tonnage"].ToString() != "")
{
model.Tonnage = decimal.Parse(row["tonnage"].ToString());
}
if (row["NumberOfPacks"] != null && row["NumberOfPacks"].ToString() != "")
{
model.NumberOfPacks = int.Parse(row["NumberOfPacks"].ToString());
}
if (row["ShippingUnit"] != null)
{
model.ShippingUnit = row["ShippingUnit"].ToString();
}
if (row["ArrivalUnit"] != null)
{
model.ArrivalUnit = row["ArrivalUnit"].ToString();
}
if (row["Freight"] != null)
{
model.Freight = row["Freight"].ToString();
}
if (row["CarNumber"] != null && row["CarNumber"].ToString() != "")
{
model.CarNumber = row["CarNumber"].ToString();
}
if (row["ShipName"] != null && row["ShipName"].ToString() != "")
{
model.ShipName = row["ShipName"].ToString();
}
if (row["BillOfLadingNumber"] != null)
{
model.BillOfLadingNumber = row["BillOfLadingNumber"].ToString();
}
if (row["Country"] != null)
{
model.Country = row["Country"].ToString();
}
if (row["Brand"] != null)
{
model.Brand = row["Brand"].ToString();
}
if (row["quality"] != null && row["quality"].ToString() != "")
{
model.Quality = row["quality"].ToString();
}
if (row["ProductionDate"] != null && row["ProductionDate"].ToString() != "")
{
model.ProductionDate = DateTime.Parse(row["ProductionDate"].ToString());
}
if (row["Remarks"] != null)
{
model.Remarks = row["Remarks"].ToString();
}
}
return(model);
}
public bool Update(FishEntity.ShippingRecordsEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_shippingrecords set ");
strSql.Append("pickuptime = @pickuptime,");
strSql.Append("tonnage = @tonnage,");
strSql.Append("NumberOfPacks = @NumberOfPacks,");
strSql.Append("ShippingUnit = @ShippingUnit,");
strSql.Append("ArrivalUnit = @ArrivalUnit,");
strSql.Append("Freight = @Freight,");
strSql.Append("CarNumber = @CarNumber,");
strSql.Append("ShipName = @ShipName,");
strSql.Append("BillOfLadingNumber = @BillOfLadingNumber,");
strSql.Append("Country = @Country,");
strSql.Append("Brand = @Brand,");
strSql.Append("quality = @quality,");
strSql.Append("ProductionDate = @ProductionDate,");
strSql.Append("Remarks = @Remarks,");
strSql.Append("modifytime = @modifytime,");
strSql.Append("modifyman = @modifyman ");
strSql.Append("where id = @id");
MySqlParameter[] parameter =
{
new MySqlParameter("@pickuptime", MySqlDbType.DateTime),
new MySqlParameter("@tonnage", MySqlDbType.Decimal, 45),
new MySqlParameter("@NumberOfPacks", MySqlDbType.Int32, 11),
new MySqlParameter("@ShippingUnit", MySqlDbType.VarChar, 45),
new MySqlParameter("@ArrivalUnit", MySqlDbType.VarChar, 45),
new MySqlParameter("@Freight", MySqlDbType.VarChar, 45),
new MySqlParameter("@CarNumber", MySqlDbType.VarChar, 45),
new MySqlParameter("@ShipName", MySqlDbType.VarChar, 45),
new MySqlParameter("@BillOfLadingNumber", MySqlDbType.VarChar, 45),
new MySqlParameter("@Country", MySqlDbType.VarChar, 45),
new MySqlParameter("@Brand", MySqlDbType.VarChar, 45),
new MySqlParameter("@quality", MySqlDbType.VarChar, 45),
new MySqlParameter("@ProductionDate", MySqlDbType.DateTime),
new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@id", MySqlDbType.Int32, 11),
};
parameter[0].Value = model.Pickuptime;
parameter[1].Value = model.Tonnage;
parameter[2].Value = model.NumberOfPacks;
parameter[3].Value = model.ShippingUnit;
parameter[4].Value = model.ArrivalUnit;
parameter[5].Value = model.Freight;
parameter[6].Value = model.CarNumber;
parameter[7].Value = model.ShipName;
parameter[8].Value = model.BillOfLadingNumber;
parameter[9].Value = model.Country;
parameter[10].Value = model.Brand;
parameter[11].Value = model.Quality;
parameter[12].Value = model.ProductionDate;
parameter[13].Value = model.Remarks;
parameter[14].Value = model.Modifytime;
parameter[15].Value = model.Modifyman;
parameter[16].Value = model.Id;
int row = MySqlHelper.ExecuteSql(strSql.ToString(), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
