//用油表绑定
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);
}
}
