private Boolean ShowListByLine()
{
string line = this.cmbSMTMantainTableLine.InnerDropDownList.SelectedValue;
this.cmdMaintainSMTDashboardRefreshTime.SmtLine = line;
this.cmdMaintainSMTDashboardStation.SmtLine = line;
try
{
SMT_DashBoard_MantainInfo condition = new SMT_DashBoard_MantainInfo();
condition.line = line;
IList<SMT_DashBoard_MantainInfo> dataList = iSA_SMTDashboard.GetSMTDashBoardLineListByCondition(condition);
if (dataList == null || dataList.Count == 0)
{
bindTable(null, DEFAULT_ROWS);
}
else
{
bindTable(dataList, DEFAULT_ROWS);
}
}
catch (FisException ex)
{
bindTable(null, DEFAULT_ROWS);
showErrorMessage(ex.mErrmsg);
return false;
}
catch (Exception ex)
{
//show error
bindTable(null, DEFAULT_ROWS);
showErrorMessage(ex.Message);
return false;
}
return true;
}
public void AddOrUpDateSMTDashboardRefreshTimeAndStation(SMT_DashBoard_MantainInfo condition, string DBConnection)
{
string methodName = MethodBase.GetCurrentMethod().Name;
BaseLog.LoggingBegin(logger, methodName);
try
{
string SQL = @"if exists(select * from SMT_Dashboard_Line_RefreshTime_Station where Line=@line)
Update SMT_Dashboard_Line_RefreshTime_Station Set RefreshTime=@refreshtime,
Station=@station,Editor=@editor,Udt=getdate()
where Line=@line
else
Insert SMT_Dashboard_Line_RefreshTime_Station
Values(@line,@refreshtime,@station,@editor,getdate(),getdate())";
SQLHelper.ExecuteNonQuery(DBConnection,
System.Data.CommandType.Text,
SQL,
SQLHelper.CreateSqlParameter("@line", 1024, condition.line),
SQLHelper.CreateSqlParameter("@refreshtime", condition.refreshTime),
SQLHelper.CreateSqlParameter("@station", 1024, condition.station),
SQLHelper.CreateSqlParameter("@editor", 1024, condition.editor)
);
}
catch (Exception)
{
throw;
}
finally
{
BaseLog.LoggingEnd(logger, methodName);
}
}
protected void btnSave_ServerClick(Object sender, EventArgs e)
{
string id = this.HidID.Value.Trim();
string cdt = this.Hcdt.Value.Trim();
string lineValue = this.cmbSMTMantainTableLine.InnerDropDownList.SelectedValue.Trim();
string stationValue = this.cmdMaintainSMTDashboardStation.InnerDropDownList.SelectedValue.Trim();
string durTimeValue = this.dDurTime.Text.Trim();
string refreshTimeValue = this.cmdMaintainSMTDashboardRefreshTime.InnerDropDownList.SelectedValue;
string StandardOutputValue = this.dStandardOutput.Text.Trim();
try
{
SMT_DashBoard_MantainInfo condition = new SMT_DashBoard_MantainInfo();
if (id != "")
{
condition.id = Convert.ToInt32(id);
condition.line = lineValue;
condition.refreshTime = Convert.ToInt32(refreshTimeValue);
condition.station = stationValue;
condition.editor = userName;
condition.StandardOutputCdt = Convert.ToDateTime(cdt);
}
else
{
condition.line = lineValue;
condition.durTime = durTimeValue;
condition.refreshTime = Convert.ToInt32(refreshTimeValue);
if (StandardOutputValue != "")
{
condition.standardOutput = Convert.ToInt32(StandardOutputValue);
}
condition.station = stationValue;
condition.editor = userName;
}
//先对SMT_Dashboard_Line_RefreshTime_Station表进行Insert或update
iSA_SMTDashboard.AddOrUpDateSMTDashboardRefreshTimeAndStation(condition, connectionStr);
if (refreshTimeValue == "" || StandardOutputValue == "")
{
return;
}
IList<SMT_DashBoard_MantainInfo> InfoList = iSA_SMTDashboard.GetSMTDashBoardLineListByCondition(condition);
SMT_DashBoard_MantainInfo addEditInfo = new SMT_DashBoard_MantainInfo();
if (InfoList.Count >= 12&&id=="")
{
showErrorMessage(pmtMessage6);
return;
}
if (InfoList.Count == 0)
{
addEditInfo.line = lineValue;
addEditInfo.durTime = durTimeValue;
addEditInfo.standardOutput = Convert.ToInt32(StandardOutputValue);
addEditInfo.editor = userName;
iSA_SMTDashboard.AddSMTDashboardInfo(addEditInfo);
}
else
{
addEditInfo.id = Convert.ToInt32(id);
addEditInfo.line = lineValue;
addEditInfo.durTime = durTimeValue;
addEditInfo.editor = userName;
addEditInfo.standardOutput = Convert.ToInt32(StandardOutputValue);
addEditInfo.StandardOutputCdt = Convert.ToDateTime(cdt);
iSA_SMTDashboard.UpdateSMTDashBoardInfo(addEditInfo);
}
}
catch (FisException ex)
{
showErrorMessage(ex.mErrmsg);
return;
}
catch (Exception ex)
{
showErrorMessage(ex.Message);
return;
}
finally
{
initLabel();
//initcmbSMTMantainTableLineList();
//this.updatePanel1.Update();
this.updatePanel2.Update();
ScriptManager.RegisterStartupScript(this.updatePanelAll, typeof(System.Object), "saveUpdate", "DealHideWait();", true);
}
}
public IList<SMT_DashBoard_MantainInfo> GetSMTDashBoardRefreshTimeAndStationByLine(SMT_DashBoard_MantainInfo condition)
{
string methodName = MethodBase.GetCurrentMethod().Name;
BaseLog.LoggingBegin(logger, methodName);
IList<SMT_DashBoard_MantainInfo> ret = new List<SMT_DashBoard_MantainInfo>();
try
{
using (UnitOfWork uow = new UnitOfWork())
{
ret = (from SMTRefreshTimeStation in SMTLineRefreshTimeStationtRep.Query()
where SMTRefreshTimeStation.Line ==condition.line
select new SMT_DashBoard_MantainInfo { line = SMTRefreshTimeStation.Line, refreshTime = SMTRefreshTimeStation.RefreshTime, station = SMTRefreshTimeStation.Station }).Distinct().ToList();
}
return ret;
}
catch (Exception)
{
throw;
}
finally
{
BaseLog.LoggingEnd(logger, methodName);
}
}
public void UpdateSMTDashBoardInfo(SMT_DashBoard_MantainInfo conditicon)
{
string methodName = MethodBase.GetCurrentMethod().Name;
logger.DebugFormat("BEGIN: {0}()", methodName);
SMT_Dashboard_Line_Time_Qty smtDashBoardMaintain = new SMT_Dashboard_Line_Time_Qty();
try
{
using (UnitOfWork uow = new UnitOfWork())
{
smtDashBoardMaintain.ID = conditicon.id;
smtDashBoardMaintain.Line = conditicon.line;
smtDashBoardMaintain.Qty = conditicon.standardOutput;
smtDashBoardMaintain.DurTime = conditicon.durTime;
smtDashBoardMaintain.Editor = conditicon.editor;
smtDashBoardMaintain.Cdt = conditicon.StandardOutputCdt;
smtDashBoardMaintain.Udt = DateTime.Now;
SMTDashBoardRep.Update(smtDashBoardMaintain);
uow.Commit();
}
}
catch (Exception e)
{
BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e);
throw;
}
finally
{
BaseLog.LoggingEnd(logger, methodName);
}
}
public void AddSMTDashboardInfo(SMT_DashBoard_MantainInfo conditicon)
{
string methodName = MethodBase.GetCurrentMethod().Name;
logger.DebugFormat("BEGIN: {0}()", methodName);
try
{
using (UnitOfWork uow = new UnitOfWork())
{
SMT_Dashboard_Line_Time_Qty smtDashBoardMaintain = new SMT_Dashboard_Line_Time_Qty();
SMT_Dashboard_Result smtDashboardResult = new SMT_Dashboard_Result();
smtDashBoardMaintain.Line = conditicon.line;
smtDashBoardMaintain.Qty = conditicon.standardOutput;
smtDashBoardMaintain.DurTime = "08:00--10:00";
smtDashBoardMaintain.Editor = conditicon.editor;
smtDashBoardMaintain.Cdt = DateTime.Now;
smtDashBoardMaintain.Udt = DateTime.Now;
smtDashboardResult.Line = conditicon.line;
smtDashboardResult.DurTime = "08:00--10:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain); // 将数据塞入Maintain 表中
SMTDashBoardResultRep.Insert(smtDashboardResult);//将Line和时间段塞入 结果表中
uow.Commit();
smtDashBoardMaintain.DurTime = "10:00--12:00";
smtDashboardResult.DurTime = "10:00--12:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "12:00--14:00";
smtDashboardResult.DurTime = "12:00--14:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "14:00--16:00";
smtDashboardResult.DurTime = "14:00--16:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "16:00--18:00";
smtDashboardResult.DurTime = "16:00--18:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "18:00--20:30";
smtDashboardResult.DurTime = "18:00--20:30";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "20:30--22:00";
smtDashboardResult.DurTime = "20:30--22:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "22:00--00:00";
smtDashboardResult.DurTime = "22:00--00:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "00:00--02:00";
smtDashboardResult.DurTime = "00:00--02:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "02:00--04:00";
smtDashboardResult.DurTime = "02:00--04:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "04:00--06:00";
smtDashboardResult.DurTime = "04:00--06:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
smtDashBoardMaintain.DurTime = "06:00--08:00";
smtDashboardResult.DurTime = "06:00--08:00";
SMTDashBoardRep.Insert(smtDashBoardMaintain);
SMTDashBoardResultRep.Insert(smtDashboardResult);
uow.Commit();
}
}
catch (Exception e)
{
BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e);
throw;
}
finally
{
BaseLog.LoggingEnd(logger, methodName);
}
}
public IList<SMT_DashBoard_MantainInfo> GetSMTDashBoardLineListById(SMT_DashBoard_MantainInfo condition)
{
string methodName = MethodBase.GetCurrentMethod().Name;
BaseLog.LoggingBegin(logger, methodName);
IList<SMT_DashBoard_MantainInfo> ret = new List<SMT_DashBoard_MantainInfo>();
try
{
using (UnitOfWork uow = new UnitOfWork())
{
ret = (from SMTDashboard in SMTDashBoardRep.Query()
where SMTDashboard.ID ==Convert.ToInt32(condition.id)
select new SMT_DashBoard_MantainInfo { id = SMTDashboard.ID, line = SMTDashboard.Line, durTime = SMTDashboard.DurTime, standardOutput = SMTDashboard.Qty }).Distinct().ToList();
}
return ret;
}
catch (Exception)
{
throw;
}
finally
{
BaseLog.LoggingEnd(logger, methodName);
}
}
public IList<SMT_DashBoard_MantainInfo> GetSMTDashBoardLineListByCondition(SMT_DashBoard_MantainInfo condition)
{
string methodName = MethodBase.GetCurrentMethod().Name;
BaseLog.LoggingBegin(logger, methodName);
IList<SMT_DashBoard_MantainInfo> ret = new List<SMT_DashBoard_MantainInfo>();
try
{
using (UnitOfWork uow = new UnitOfWork())
{
ret = (from SMTDashboard in SMTDashBoardRep.Query()
where SMTDashboard.Line==condition.line
select new SMT_DashBoard_MantainInfo { id = SMTDashboard.ID, line = SMTDashboard.Line, durTime = SMTDashboard.DurTime, standardOutput = SMTDashboard.Qty,editor=SMTDashboard.Editor,StandardOutputCdt=SMTDashboard.Cdt,StandardOutputUdt=SMTDashboard.Udt}).OrderBy(x=>x.line).Distinct().ToList();
}
return ret;
}
catch (Exception)
{
throw;
}
finally
{
BaseLog.LoggingEnd(logger, methodName);
}
}