//用油表绑定 private void bindOilBalanceInfo(string baseId) { if (!baseId.Equals("0")) { //燃料油 DataTable dt = new OilUseBalance().GetOilBalanceInfo(baseId).Tables[0]; if (dt.Rows.Count > 0) { lbOilBalFuel.Text = dt.Rows[0]["ID1"].ToString(); tbRemain1.Text = dt.Rows[0]["Remaining1"].ToString(); tbAdd1.Text = dt.Rows[0]["Addition1"].ToString(); tbConsume1.Text = dt.Rows[0]["Consuming1"].ToString(); tbBalance1.Text = dt.Rows[0]["Balance1"].ToString(); //柴油 lbOilBalDiesel.Text = dt.Rows[0]["ID2"].ToString(); tbRemain2.Text = dt.Rows[0]["Remaining2"].ToString(); tbAdd2.Text = dt.Rows[0]["Addition2"].ToString(); tbConsume2.Text = dt.Rows[0]["Consuming2"].ToString(); tbBalance2.Text = dt.Rows[0]["Balance2"].ToString(); //机油 lbOilBalEngine.Text = dt.Rows[0]["ID3"].ToString(); tbRemain3.Text = dt.Rows[0]["Remaining3"].ToString(); tbAdd3.Text = dt.Rows[0]["Addition3"].ToString(); tbConsume3.Text = dt.Rows[0]["Consuming3"].ToString(); tbBalance3.Text = dt.Rows[0]["Balance3"].ToString(); //气缸油 lbOilBalCylinder.Text = dt.Rows[0]["ID4"].ToString(); tbRemain4.Text = dt.Rows[0]["Remaining4"].ToString(); tbAdd4.Text = dt.Rows[0]["Addition4"].ToString(); tbConsume4.Text = dt.Rows[0]["Consuming4"].ToString(); tbBalance4.Text = dt.Rows[0]["Balance4"].ToString(); //透平油 lbOilBalTurbine.Text = dt.Rows[0]["ID5"].ToString(); tbRemain5.Text = dt.Rows[0]["Remaining5"].ToString(); tbAdd5.Text = dt.Rows[0]["Addition5"].ToString(); tbConsume5.Text = dt.Rows[0]["Consuming5"].ToString(); tbBalance5.Text = dt.Rows[0]["Balance5"].ToString(); //液压油 lbOilBalHydraulic.Text = dt.Rows[0]["ID6"].ToString(); tbRemain6.Text = dt.Rows[0]["Remaining6"].ToString(); tbAdd6.Text = dt.Rows[0]["Addition6"].ToString(); tbConsume6.Text = dt.Rows[0]["Consuming6"].ToString(); tbBalance6.Text = dt.Rows[0]["Balance6"].ToString(); //冷冻油 lbFrozenOil.Text = dt.Rows[0]["ID7"].ToString(); tbRemain7.Text = dt.Rows[0]["Remaining7"].ToString(); tbAdd7.Text = dt.Rows[0]["Addition7"].ToString(); tbConsume7.Text = dt.Rows[0]["Consuming7"].ToString(); tbBalance7.Text = dt.Rows[0]["Balance7"].ToString(); //空压机油 lbPressOil.Text = dt.Rows[0]["ID8"].ToString(); tbRemain8.Text = dt.Rows[0]["Remaining8"].ToString(); tbAdd8.Text = dt.Rows[0]["Addition8"].ToString(); tbConsume8.Text = dt.Rows[0]["Consuming8"].ToString(); tbBalance8.Text = dt.Rows[0]["Balance8"].ToString(); //其他 lbOtherOil.Text = dt.Rows[0]["ID9"].ToString(); tbRemain9.Text = dt.Rows[0]["Remaining9"].ToString(); tbAdd9.Text = dt.Rows[0]["Addition9"].ToString(); tbConsume9.Text = dt.Rows[0]["Consuming9"].ToString(); tbBalance9.Text = dt.Rows[0]["Balance9"].ToString(); } else { emptyOilBalInput(); } } else { emptyOilBalInput(); } }
protected void btnSave_Click(object sender, EventArgs e) { try { #region 验证逻辑 string hangciBaseId = ""; double diff = Convert.ToDouble(ViewState["diffHrs"].ToString()); double t1 = Convert.ToDouble(judgeIsNull(tbWorkTime1.Text)); if (t1 > diff) { ShowMsg("主机航次工作时间不能大于航次总时间!"); return; } double t2 = Convert.ToDouble(judgeIsNull(tbWorkTime2.Text)); if (t2 > diff) { ShowMsg("副机1航次工作时间不能大于航次总时间!"); return; } double t3 = Convert.ToDouble(judgeIsNull(tbWorkTime3.Text)); if (t3 > diff) { ShowMsg("副机2航次工作时间不能大于航次总时间!"); return; } double t4 = Convert.ToDouble(judgeIsNull(tbWorkTime4.Text)); if (t4 > diff) { ShowMsg("副机3航次工作时间不能大于航次总时间!"); return; } double t5 = Convert.ToDouble(judgeIsNull(tbWorkTime5.Text)); if (t5 > diff) { ShowMsg("锅炉航次工作时间不能大于航次总时间!"); return; } #endregion string voyageIds = this.VoyageIds; string baseId = GetViewState("baseId"); hangciBaseId = baseId; HangciBaseInputInfo hcbii = new HangciBaseInputInfo(); if (string.IsNullOrEmpty(hangciBaseId)) { hangciBaseId = new HangciBaseInput().Add(hcbii); new Voyage().UpdateVoyage(voyageIds, hangciBaseId); } hcbii = new HangciBaseInput().GetByID(baseId); if (!cCaptainDate.Text.Equals("")) { hcbii.ShipInputDate = Convert.ToDateTime(cCaptainDate.Text); } if (!cGeneralDate.Text.Equals("")) { hcbii.GeneralManagerDate = Convert.ToDateTime(cGeneralDate.Text); } new HangciBaseInput().Update(hcbii); //--------------------船舶油料航次消耗表------------------ VoyageConsume vc = new VoyageConsume(); VoyageConsumeInfo vci = new VoyageConsumeInfo(); vci.BaseInputID = Convert.ToInt32(hangciBaseId); //主机 vci.MainSlowWorkTime = judgeIsNull(tbSlowWorkTime1.Text); vci.MainCruiseWorkTime = judgeIsNull(tbCruiseWorkTime1.Text); vci.VoyageWorkTime = judgeIsNull(tbWorkTime1.Text); vci.FuelConsume = judgeIsNull(tbFuelConsume1.Text); vci.DieselConsume = judgeIsNull(tbDieselConsume1.Text); vci.OtherConsume = judgeIsNull(tbOtherConsume1.Text); vci.ShipComponentID = 1; if (string.IsNullOrEmpty(lbConZhuji.Text)) { lbConZhuji.Text = vc.Add(vci); } else { vci.ID = lbConZhuji.Text; vc.Update(vci); } //副机1 vci.MainSlowWorkTime = judgeIsNull(tbSlowWorkTime2.Text); vci.MainCruiseWorkTime = judgeIsNull(tbCruiseWorkTime2.Text); vci.VoyageWorkTime = judgeIsNull(tbWorkTime2.Text); vci.FuelConsume = judgeIsNull(tbFuelConsume2.Text); vci.DieselConsume = judgeIsNull(tbDieselConsume2.Text); vci.OtherConsume = judgeIsNull(tbOtherConsume2.Text); vci.ShipComponentID = 2; if (string.IsNullOrEmpty(lbConFuji1.Text)) { lbConFuji1.Text = vc.Add(vci); } else { vci.ID = lbConFuji1.Text; vc.Update(vci); } //副机2 vci.MainSlowWorkTime = judgeIsNull(tbSlowWorkTime3.Text); vci.MainCruiseWorkTime = judgeIsNull(tbCruiseWorkTime3.Text); vci.VoyageWorkTime = judgeIsNull(tbWorkTime3.Text); vci.FuelConsume = judgeIsNull(tbFuelConsume3.Text); vci.DieselConsume = judgeIsNull(tbDieselConsume3.Text); vci.OtherConsume = judgeIsNull(tbOtherConsume3.Text); vci.ShipComponentID = 3; if (string.IsNullOrEmpty(lbConFuji2.Text)) { lbConFuji2.Text = vc.Add(vci); } else { vci.ID = lbConFuji2.Text; vc.Update(vci); } //副机3 vci.MainSlowWorkTime = judgeIsNull(tbSlowWorkTime4.Text); vci.MainCruiseWorkTime = judgeIsNull(tbCruiseWorkTime4.Text); vci.VoyageWorkTime = judgeIsNull(tbWorkTime4.Text); vci.FuelConsume = judgeIsNull(tbFuelConsume4.Text); vci.DieselConsume = judgeIsNull(tbDieselConsume4.Text); vci.OtherConsume = judgeIsNull(tbOtherConsume4.Text); vci.ShipComponentID = 4; vc.Add(vci); if (string.IsNullOrEmpty(lbConFuji3.Text)) { lbConFuji3.Text = vc.Add(vci); } else { vci.ID = lbConFuji3.Text; vc.Update(vci); } //锅炉 vci.MainSlowWorkTime = judgeIsNull(tbSlowWorkTime5.Text); vci.MainCruiseWorkTime = judgeIsNull(tbCruiseWorkTime5.Text); vci.VoyageWorkTime = judgeIsNull(tbWorkTime5.Text); vci.FuelConsume = judgeIsNull(tbFuelConsume5.Text); vci.DieselConsume = judgeIsNull(tbDieselConsume5.Text); vci.OtherConsume = judgeIsNull(tbOtherConsume5.Text); vci.ShipComponentID = 5; if (string.IsNullOrEmpty(lbConGuolu.Text)) { lbConGuolu.Text = vc.Add(vci); } else { vci.ID = lbConGuolu.Text; vc.Update(vci); } //--------------------燃润油领用结存(吨)------------------ OilUseBalance oub = new OilUseBalance(); OilUseBalanceInfo oubi = new OilUseBalanceInfo(); oubi.BaseInputID = Convert.ToInt32(hangciBaseId); //燃料油 oubi.Remaining = judgeIsNull(tbRemain1.Text); oubi.Addition = judgeIsNull(tbAdd1.Text); oubi.Consuming = judgeIsNull(tbConsume1.Text); oubi.Balance = judgeIsNull(tbBalance1.Text); oubi.OilTypeID = 1; if (string.IsNullOrEmpty(lbOilBalFuel.Text)) { lbOilBalFuel.Text = oub.Add(oubi); } else { oubi.ID = lbOilBalFuel.Text; oub.Update(oubi); } //柴油 oubi.Remaining = judgeIsNull(tbRemain2.Text); oubi.Addition = judgeIsNull(tbAdd2.Text); oubi.Consuming = judgeIsNull(tbConsume2.Text); oubi.Balance = judgeIsNull(tbBalance2.Text); oubi.OilTypeID = 2; if (string.IsNullOrEmpty(lbOilBalDiesel.Text)) { lbOilBalDiesel.Text = oub.Add(oubi); } else { oubi.ID = lbOilBalDiesel.Text; oub.Update(oubi); } //机油 oubi.Remaining = judgeIsNull(tbRemain3.Text); oubi.Addition = judgeIsNull(tbAdd3.Text); oubi.Consuming = judgeIsNull(tbConsume3.Text); oubi.Balance = judgeIsNull(tbBalance3.Text); oubi.OilTypeID = 3; if (string.IsNullOrEmpty(lbOilBalEngine.Text)) { lbOilBalEngine.Text = oub.Add(oubi); } else { oubi.ID = lbOilBalEngine.Text; oub.Update(oubi); } //气缸油 oubi.Remaining = judgeIsNull(tbRemain4.Text); oubi.Addition = judgeIsNull(tbAdd4.Text); oubi.Consuming = judgeIsNull(tbConsume4.Text); oubi.Balance = judgeIsNull(tbBalance4.Text); oubi.OilTypeID = 4; if (string.IsNullOrEmpty(lbOilBalCylinder.Text)) { lbOilBalCylinder.Text = oub.Add(oubi); } else { oubi.ID = lbOilBalCylinder.Text; oub.Update(oubi); } //透平油 oubi.Remaining = judgeIsNull(tbRemain5.Text); oubi.Addition = judgeIsNull(tbAdd5.Text); oubi.Consuming = judgeIsNull(tbConsume5.Text); oubi.Balance = judgeIsNull(tbBalance5.Text); oubi.OilTypeID = 5; if (string.IsNullOrEmpty(lbOilBalTurbine.Text)) { lbOilBalTurbine.Text = oub.Add(oubi); } else { oubi.ID = lbOilBalTurbine.Text; oub.Update(oubi); } //液压油 oubi.Remaining = judgeIsNull(tbRemain6.Text); oubi.Addition = judgeIsNull(tbAdd6.Text); oubi.Consuming = judgeIsNull(tbConsume6.Text); oubi.Balance = judgeIsNull(tbBalance6.Text); oubi.OilTypeID = 6; if (string.IsNullOrEmpty(lbOilBalHydraulic.Text)) { lbOilBalHydraulic.Text = oub.Add(oubi); } else { oubi.ID = lbOilBalHydraulic.Text; oub.Update(oubi); } //冷冻油 oubi.Remaining = judgeIsNull(tbRemain7.Text); oubi.Addition = judgeIsNull(tbAdd7.Text); oubi.Consuming = judgeIsNull(tbConsume7.Text); oubi.Balance = judgeIsNull(tbBalance7.Text); oubi.OilTypeID = 8; if (string.IsNullOrEmpty(lbFrozenOil.Text)) { lbFrozenOil.Text = oub.Add(oubi); } else { oubi.ID = lbFrozenOil.Text; oub.Update(oubi); } //空压机油 oubi.Remaining = judgeIsNull(tbRemain8.Text); oubi.Addition = judgeIsNull(tbAdd8.Text); oubi.Consuming = judgeIsNull(tbConsume8.Text); oubi.Balance = judgeIsNull(tbBalance8.Text); oubi.OilTypeID = 9; if (string.IsNullOrEmpty(lbPressOil.Text)) { lbPressOil.Text = oub.Add(oubi); } else { oubi.ID = lbPressOil.Text; oub.Update(oubi); } //其他 oubi.Remaining = judgeIsNull(tbRemain9.Text); oubi.Addition = judgeIsNull(tbAdd9.Text); oubi.Consuming = judgeIsNull(tbConsume9.Text); oubi.Balance = judgeIsNull(tbBalance9.Text); oubi.OilTypeID = 7; if (string.IsNullOrEmpty(lbOtherOil.Text)) { lbOtherOil.Text = oub.Add(oubi); } else { oubi.ID = lbOtherOil.Text; oub.Update(oubi); } ShowMsg("保存成功"); } catch (ArgumentNullException aex) { ShowMsg(aex.Message); } catch (Exception ex) { ShowMsg(ex.Message); Log(ex); } }