public override int Delete()
{
if (_entity == null)
{
return(0);
}
string msg = string.Format("你确定要删除进仓单号为【{0}】的记录吗?", _entity.code);
if (MessageBox.Show(msg, "询问", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.No)
{
return(0);
}
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
bool isok = productBll.UpdateState(_entity.productid.Value, FishEntity.Constant.STATE_CONFIRM, -_entity.actualnumber.Value, -_entity.tons.Value);
if (isok)
{
_bll.Delete(_entity.id);
ClearText();
Query();
}
else
{
MessageBox.Show("删除失败。");
}
return(1);
}
protected void Query()
{
FishBll.Bll.ProductBll bll = new FishBll.Bll.ProductBll();
string where = GetWhere();
//List<FishEntity.ProductEntity> list = bll.GetModelList(where);
List <FishEntity.ProductVo> list = bll.GetModelListVo(where);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = list;
}
public override int Delete()
{
if (_entity == null)
{
return(0);
}
string msg = string.Format("你确定要删除提货单号为【{0}】的记录吗?", _entity.code);
if (MessageBox.Show(msg, "询问", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.No)
{
return(0);
}
_bll.Delete(_entity.id);
FishBll.Bll.LoadingDetailBll detailbll = new FishBll.Bll.LoadingDetailBll();
List <FishEntity.LoadingDetailEntity> details = detailbll.GetDetailOfBill(_entity.id);
if (details != null)
{
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
foreach (FishEntity.LoadingDetailEntity item in details)
{
//FishEntity.ProductEntity product = productBll.GetModel(item.productid);
//if (product == null) continue;
//if (product.state == FishEntity.Constant.STATE_SELFMAKE.ToString ())
//{
// productBll.UpdateHomemadeWeightQuantity(item.productid , item.tons, item.packages );
//}
//else
//{
// productBll.UpdateRemainWeightQuantity(item.productid , item.tons, item.packages);
//}
FishBll.Bll.ProductExBll productexbll = new FishBll.Bll.ProductExBll();
productexbll.UpdateSaleInfo(item.productid, -item.tons, -item.packages);
FishBll.Bll.ContractDetailBll contractdetailbll = new FishBll.Bll.ContractDetailBll();
contractdetailbll.UpdateContractWeight(item.contractid, item.contractdetailid, -item.tons, -item.packages);
}
}
detailbll.DeleteByMid(_entity.id);
ClearText();
Query();
return(1);
}
public override void Save()
{
if (Check() == false)
{
return;
}
_entity = new FishEntity.StorageBillsEntity();
GetStorageBills();
_entity.code = FishBll.Bll.SequenceUtil.GetStorageBillSequence();
while (_bll.Exists(_entity.code))
{
_entity.code = FishBll.Bll.SequenceUtil.GetStorageBillSequence();
}
_entity.createman = FishEntity.Variable.User.username;
_entity.createtime = DateTime.Now;
_entity.modifyman = _entity.createman;
_entity.modifytime = _entity.createtime;
int id = _bll.Add(_entity);
if (id > 0)
{
_entity.id = id;
txtCode.Text = _entity.code;
//更新 鱼粉的状态为“自营”，重量，数量
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
bool isok = productBll.UpdateState(_entity.productid.Value, FishEntity.Constant.STATE_SELFBUY, _entity.actualnumber.Value, _entity.tons.Value);
//tmiSave.Visible = false;
//tmiCancel.Visible = false;
//tmiDelete.Visible = true;
//tmiAdd.Visible = true;
//tmiModify.Visible = true;
//tmiQuery.Visible = true;
//tmiPrevious.Visible = true;
//tmiNext.Visible = true;
ControlButtomRoles();
MessageBox.Show("新增成功。");
}
else
{
MessageBox.Show("新增失败。");
}
}
public override void Save()
{
if (Check() == false)
{
return;
}
int startcol = 3;
int startrow = 0;
DateTime lateDate = DateTime.MinValue;
FishEntity.CheckRecordEntity lateRecord = null;
for (int i = 0; i < 6; i++)
{
FishEntity.CheckRecordEntity vo = null;// new FishEntity.CheckRecordEntity();
if (_records == null || _records.Count < 1)
{
vo = new FishEntity.CheckRecordEntity();
vo.recordno = i + 1;
vo.productid = _productId;
vo.productcode = _productCode;
vo.productname = _productName;
}
else
{
vo = _records.Find((m) => { return(m.recordno == (i + 1)); });
if (vo == null)
{
vo = new FishEntity.CheckRecordEntity();
vo.recordno = i + 1;
vo.productid = _productId;
vo.productcode = _productCode;
vo.productname = _productName;
}
}
vo.checkdate = GetString(startcol + i, startrow);
vo.testdate = GetString(startcol + i, startrow + 1);
int companyid = 0;
string companyname = string.Empty;
string sends = string.Empty;
GetValue(startcol + i, startrow + 2, ref companyid, ref sends);
GetValue(startcol + i, startrow + 3, ref companyid, ref companyname);
vo.testcompanyid = companyid;
vo.testcompanyname = companyname;
vo.Sendsamplename = sends;
vo.regularindex1 = GetDecimalNull(startcol + i, startrow + 7);
vo.regularindex2 = GetDecimalNull(startcol + i, startrow + 8);
vo.regularindex3 = GetDecimalNull(startcol + i, startrow + 9);
vo.regularindex4 = GetDecimalNull(startcol + i, startrow + 10);
vo.regularindex5 = GetDecimalNull(startcol + i, startrow + 11);
vo.regularindex6 = GetDecimalNull(startcol + i, startrow + 12);
vo.regularindex7 = GetDecimalNull(startcol + i, startrow + 13);
vo.regularindex8 = GetDecimalNull(startcol + i, startrow + 14);
vo.Digestibility = GetDecimalNull(startcol + i, startrow + 15);
vo.aminoindex1 = GetDecimalNull(startcol + i, startrow + 16);
vo.aminoindex2 = GetDecimalNull(startcol + i, startrow + 17);
vo.aminoindex3 = GetDecimalNull(startcol + i, startrow + 18);
vo.aminoindex4 = GetDecimalNull(startcol + i, startrow + 19);
vo.aminoindex5 = GetDecimalNull(startcol + i, startrow + 20);
vo.aminoindex6 = GetDecimalNull(startcol + i, startrow + 21);
vo.aminoindex7 = GetDecimalNull(startcol + i, startrow + 22);
vo.aminoindex8 = GetDecimalNull(startcol + i, startrow + 23);
vo.aminoindex9 = GetDecimalNull(startcol + i, startrow + 24);
vo.aminoindex10 = GetDecimalNull(startcol + i, startrow + 25);
vo.aminoindex11 = GetDecimalNull(startcol + i, startrow + 26);
vo.aminoindex12 = GetDecimalNull(startcol + i, startrow + 27);
vo.aminoindex13 = GetDecimalNull(startcol + i, startrow + 28);
vo.aminoindex14 = GetDecimalNull(startcol + i, startrow + 29);
vo.aminoindex15 = GetDecimalNull(startcol + i, startrow + 30);
vo.aminoindex16 = GetDecimalNull(startcol + i, startrow + 31);
vo.aminoindex17 = GetDecimalNull(startcol + i, startrow + 32);
vo.aminoindex18 = GetDecimalNull(startcol + i, startrow + 33);
vo.aminoindex19 = GetDecimalNull(startcol + i, startrow + 34);
vo.specialindex1 = GetString(startcol + i, startrow + 35);
vo.fee = GetDecimalNull(startcol + i, startrow + 36);
vo.Describe = GetString(startcol + i, startrow + 37);
if (vo.id > 0)
{
bool isUpdate = _bll.Update(vo);
}
else
{
int id = _bll.Add(vo);
vo.id = id;
if (_records == null)
{
_records = new List <FishEntity.CheckRecordEntity>();
}
_records.Add(vo);
}
DateTime tempDate = DateTime.MinValue;
if (DateTime.TryParseExact(vo.checkdate, "yyyy.MM.dd", null, System.Globalization.DateTimeStyles.None, out tempDate))
{
if (lateDate < tempDate)
{
lateDate = tempDate;
lateRecord = vo;
}
}
}
//更新鱼粉的 国检指标，和送样日期
if (lateRecord != null)
{
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
productBll.UpdateCheckRecord(lateRecord);
}
MessageBox.Show("保存成功。");
if (RefreshDataEvent != null)
{
RefreshDataEvent(this, EventArgs.Empty);
}
}
protected void AddDetails(int mid, bool isAdd, out decimal cost_hj, int n_solutionid, int s_solutionid)
{
cost_hj = 0;
List <FishEntity.FoodOutDetailEntityVO> listNews = GetDetails(mid);
List <FishEntity.FoodOutDetailEntityVO> listsource = null;
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
FishBll.Bll.ProductExBll productExBll = new FishBll.Bll.ProductExBll();
if (isAdd == false)
{
listsource = _detailBll.GetDetailByMid(mid);
if (listsource != null)
{
//foreach (FishEntity.FoodOutDetailEntityVO item in listsource)
//{
// bool isExist = listNews.Exists((i) => { return i.id == item.id; });
// if (isExist) continue;
// productBll.UpdateHomemadeWeightQuantityCost(item.productid, item.tons, item.package , item.tons * item.homemadeunitprice );
// bool isDelte = _detailBll.Delete(item.id);
//}
List <FishEntity.FoodOutDetailEntityVO> solution = listsource.FindAll((i) => { return(i.solutionid == s_solutionid); });
if (solution != null)
{
foreach (FishEntity.FoodOutDetailEntityVO detail in solution)
{
if (/*detail.no < FinishNo &&*/ detail.productid > 0)
{
productExBll.UpdateHomeMadeInfo(detail.productid, detail.tons, detail.package);
}
else if (/*detail.no == FinishNo &&*/ detail.productid > 0)
{
productExBll.UpdateHomeMadeInfo(detail.productid, -detail.tons, -detail.package);
}
}
_detailBll.DeleteByMid(mid);
}
}
}
foreach (FishEntity.FoodOutDetailEntityVO item in listNews)
{
cost_hj += item.cost;
//if (item.id == 0)
//{
int detailId = _detailBll.Add(item);
if (detailId > 0 && item.solutionid == n_solutionid)
{
//减少 明细中鱼粉自制仓 吨位，包数,成本
//productBll.UpdateHomemadeWeightQuantityCost(item.productid, -item.tons, -item.package , -item.tons * item.homemadeunitprice );
item.id = detailId;
if (/*item.no < FinishNo &&*/ item.productid > 0)
{
productExBll.UpdateHomeMadeInfo(item.productid, -item.tons, -item.package);
}
else if (/*item.no == FinishNo &&*/ item.productid > 0)
{
productExBll.UpdateHomeMadeInfo(item.productid, item.tons, item.package);
}
}
}
SetDetail(listNews);
}
protected void SetEntity()
{
if (_entity == null)
{
return;
}
txtCode.Text = _entity.code;
txtFishCode.Text = _entity.productcode;
txtFishCode.Tag = _entity.productid;
txtfishname.Text = _entity.productname;
txtgrossweight.Text = _entity.grossweight.ToString();
txtnetweight.Text = _entity.netweight.ToString();
txtpackagenum.Text = _entity.packages.ToString();
txtSeq.Text = _entity.seq;
txttureweight.Text = _entity.tareweight.ToString();
txtunitprice.Text = _entity.unitprice.ToString();
dtpIntime.Value = _entity.intime.Value;
dtpOuttime.Value = _entity.outtime.Value;
dtpStorageDate.Value = _entity.storagetime.Value;
txtweight.Text = _entity.storageweight.ToString();
txtquantity.Text = _entity.storagequantity.ToString();
txtselfprice.Text = _entity.selfprice.ToString();
txtsaleprice.Text = _entity.saleprice.ToString();
txtpurposeman.Text = _entity.purchaseman;
txtpurposeman.Tag = _entity.purchasemanid;
txtdeliveryman.Text = _entity.storageman;
txtdeliveryman.Tag = _entity.storagemanid;
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
FishEntity.ProductEntity fish = productBll.GetModel(_entity.productid.Value);
if (fish == null)
{
return;
}
txtsgs_amine.Text = fish.sgs_amine.ToString();
txtsgs_fat.Text = fish.sgs_fat.ToString();
txtsgs_ffa.Text = fish.sgs_ffa.ToString();
txtsgs_graypart.Text = fish.sgs_graypart.ToString();
txtsgs_protein.Text = fish.sgs_protein.ToString();
txtsgs_sand.Text = fish.sgs_sand.ToString();
txtsgs_sandsalt.Text = fish.sgs_sandsalt.ToString();
txtsgs_tvn.Text = fish.sgs_tvn.ToString();
txtsgs_water.Text = fish.sgs_water.ToString();
txtlabel_lysine.Text = fish.label_lysine.ToString();
txtlabel_methionine.Text = fish.label_methionine.ToString();
txtdomestic_graypart.Text = fish.domestic_graypart.ToString();
txtdomestic_lysine.Text = fish.domestic_lysine.ToString();
txtdomestic_methionine.Text = fish.domestic_methionine.ToString();
txtdomestic_protein.Text = fish.domestic_protein.ToString();
txtdomestic_sandsalt.Text = fish.domestic_sandsalt.ToString();
txtdomestic_sour.Text = fish.domestic_sour.ToString();
txtdomestic_tvn.Text = fish.domestic_tvn.ToString();
dtpStorageDate.Value = _entity.storagetime.Value;
txtweight.Text = _entity.storageweight.ToString();
txtquantity.Text = _entity.storagequantity.ToString();
txtselfprice.Text = _entity.selfprice.ToString();
txtsaleprice.Text = _entity.saleprice.ToString();
txtpurposeman.Text = _entity.purchaseman;
txtpurposeman.Tag = _entity.purchasemanid;
txtdeliveryman.Text = _entity.storageman;
txtdeliveryman.Tag = _entity.storagemanid;
txtFishCode.Enabled = false;
txtfishname.Enabled = false;
}
public override int Modify()
{
if (_entity == null)
{
MessageBox.Show("请查询需要修改的进仓单。");
return(0);
}
if (Check() == false)
{
return(0);
}
int s_productid = _entity.productid.Value;
int s_actualnumber = _entity.actualnumber.Value;
decimal s_tons = _entity.tons.Value;
GetStorageBills();
_entity.modifyman = FishEntity.Variable.User.username;
_entity.modifytime = DateTime.Now;
int d_productid = _entity.productid.Value;
int d_actualnumber = _entity.actualnumber.Value;
decimal d_tons = _entity.tons.Value;
int actualnumber = 0; // d_actualnumber - s_actualnumber;
decimal tons = 0; // d_tons - s_tons;
bool isok = _bll.Update(_entity);
if (isok)
{
if (s_productid == d_productid)
{//当鱼粉ID没有改变时， 更新 鱼粉的状态为 “自营”，重量，数量
actualnumber = d_actualnumber - s_actualnumber;
tons = d_tons - s_tons;
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
isok = productBll.UpdateState(_entity.productid.Value, FishEntity.Constant.STATE_SELFBUY, actualnumber, tons);
}
else
{//当鱼粉id改变时，先调整原鱼粉资料的重量和包数，再调整新鱼粉资料的重量和包数
actualnumber = -s_actualnumber;
tons = -s_tons;
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
isok = productBll.UpdateState(s_productid, FishEntity.Constant.STATE_CONFIRM, actualnumber, tons);
actualnumber = d_actualnumber;
tons = d_tons;
isok = productBll.UpdateState(d_productid, FishEntity.Constant.STATE_SELFBUY, actualnumber, tons);
}
//更新 鱼粉的状态为 “自营”，重量，数量
//FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
//isok = productBll.UpdateState(_entity.productid.Value, FishEntity.Constant.STATE_SELFBUY , actualnumber, tons);
MessageBox.Show("修改成功。");
}
else
{
MessageBox.Show("修改失败。");
}
return(1);
}
protected void AddProducts(int billId, bool isAdd)
{
List <FishEntity.LoadingDetailEntity> listNews = GetDetails(billId);
List <FishEntity.LoadingDetailEntity> listsource = null;
FishBll.Bll.LoadingDetailBll detailBll = new FishBll.Bll.LoadingDetailBll();
FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll();
if (isAdd == false)
{
listsource = detailBll.GetDetailOfBill(billId);
if (listsource != null)
{
foreach (FishEntity.LoadingDetailEntity item in listsource)
{
bool isExist = listNews.Exists((i) => { return(i.id == item.id); });
if (isExist == false)
{
UpdateProductCount(item.productid, -item.tons, -item.packages);
UpdateContract(item.contractid, item.contractdetailid, -item.tons, -item.packages);
bool isDelte = detailBll.Delete(item.id);
}
}
}
}
foreach (FishEntity.LoadingDetailEntity item in listNews)
{
if (item.id == 0)
{
int detailId = detailBll.Add(item);
if (detailId > 0)
{
UpdateProductCount(item.productid, -item.tons, -item.packages);
UpdateContract(item.contractid, item.contractdetailid, item.tons, item.packages);
item.id = detailId;
}
}
else
{
decimal sWeight = 0;
int sPackage = 0;
if (listsource != null)
{
FishEntity.LoadingDetailEntity sRecord = listsource.Find((i) => { return(i.id == item.id); });
if (sRecord != null)
{
sWeight = sRecord.tons;
sPackage = sRecord.packages;
}
}
decimal dWeight = item.tons;
int dPackage = item.packages;
decimal weight = dWeight - sWeight;
int package = dPackage - sPackage;
UpdateProductCount(item.productid, weight, package);
UpdateContract(item.contractid, item.contractdetailid, weight, package);
detailBll.Update(item);
}
}
SetDetail(listNews);
}
