private Boolean AddRunEvent(RunEvent Rec, TrainmanPlan plan, string eventGUID,
ref string ErrInfo, ref int ErrCode)
{
ErrCode = 0;
ErrInfo = "";
RsRunEvent rsEvent = new RsRunEvent();
if (Rec.strRunEventGUID == string.Empty)
{
ErrCode = 1;
return(false);
}
if (Rec.dtEventTime > plan.trainPlan.lastArriveTime)
{
ErrCode = 3;
ErrInfo = "超时被丢弃";
return(false);
}
bool bHasEvent = GetRunEventOfPlan(plan.trainPlan.planID, Rec.nEventID, rsEvent);
if ((bHasEvent) && (rsEvent.dtEventTime == Rec.dtEventTime))
{
ErrCode = 4;
ErrInfo = "记录重复";
return(false);
}
rsEvent.JiaoLuAndnStationNo = Rec.JiaoLuAndnStationNo;
rsEvent.strRunEventGUID = eventGUID;
rsEvent.nEventID = Rec.nEventID;
rsEvent.strTrainPlanGUID = plan.trainPlan.planID;
rsEvent.dtEventTime = Rec.dtEventTime;
rsEvent.nTMIS = Rec.strStationName;
rsEvent.strGroupGUID = plan.trainPlan.planID;
rsEvent.strTrainmanNumber1 = Rec.strTrainmanNumber1;
rsEvent.strTrainmanNumber2 = Rec.strTrainmanNumber2;
rsEvent.nResultID = Rec.nResultID;
rsEvent.strTrainNo = Rec.strTrainNo;
rsEvent.strTrainNumber = Rec.strTrainNumber;
rsEvent.strTrainTypeName = Rec.strTrainTypeName;
rsEvent.strResult = Rec.strResult;
AddRunEvent(rsEvent);
return(true);
}
public int SubmitRunEvent(RunEvent model)
{
int ErrCode = 0;
string ErrInfo = "";
string eventGUID = Guid.NewGuid().ToString();
TrainmanPlan plan = new TrainmanPlan();
if (DBPlan.GetTrainPlanBriefByRange(model.strTrainmanNumber1, model.dtEventTime, plan))
{
AddRunEvent(model, plan, eventGUID, ref ErrInfo, ref ErrCode);
ErrCode = 0;
}
else
{
ErrCode = 0;
ErrInfo = "没有指定乘务员的计划或机组信息";
}
Plan_RunEvent_TrainDetail eventParam = new Plan_RunEvent_TrainDetail();
eventParam.strRunEventGUID = eventGUID;
eventParam.dtEventTime = model.dtEventTime;
eventParam.strTrainmanNumber1 = model.strTrainmanNumber1;
eventParam.strTrainmanNumber2 = model.strTrainmanNumber2;
eventParam.nTMIS = model.strStationName;
eventParam.JiaoLuAndnStationNo = model.JiaoLuAndnStationNo;
eventParam.nKeHuo = model.nKehuo;
eventParam.strTrainNo = model.strTrainNo;
eventParam.strTrainTypeName = model.strTrainTypeName;
eventParam.strTrainNumber = model.strTrainNumber;
eventParam.dtCreateTime = DateTime.Now;
eventParam.nResultID = model.nResultID;
eventParam.strResult = model.strResult;
eventParam.nEventID = model.nEventID;
eventParam.strGUID = Guid.NewGuid().ToString();
////向TAB_Plan_RunEvent_Site中插入数据
SubmitEventLog(eventParam);
return(ErrCode);
}
public int AddRunEvent(RunEvent model, TrainmanPlan plan, ref string ErrInfo, ref int ErrCode)
{
string strSql = "select dbo.CovnertTrainType('" + model.strTrainTypeName + "') as TrainTypeName,dbo.CovnertTrainNumber('" + model.strTrainNumber + "') as TrainNumber";
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
model.strTrainTypeName = dt.Rows[0]["TrainTypeName"].ToString();
model.strTrainNumber = dt.Rows[0]["TrainNumber"].ToString();
string strUpSql = "insert into TAB_Plan_RunEvent (strRunEventGUID,strTrainPlanGUID, " +
" nEventID,dtEventTime,strTrainNo,strTrainTypeName,strTrainNumber,nTMIS, " +
" nKeHuo,strGroupGUID,strTrainmanNumber1,strTrainmanNumber2,dtCreateTime,nResult,strResult) " +
" values (@strRunEventGUID,@strTrainPlanGUID,@nEventID,@dtEventTime,@strTrainNo, " +
" @strTrainTypeName,@strTrainNumber,@nTMIS,@nKeHuo,@strGroupGUID,@strTrainmanNumber1," +
" @strTrainmanNumber2,getdate(),@nResult,@strResult)";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("strRunEventGUID", model.strRunEventGUID),
new SqlParameter("strTrainPlanGUID", model.strTrainPlanGUID),
new SqlParameter("nEventID", model.nEventID),
new SqlParameter("dtEventTime", model.dtEventTime),
new SqlParameter("strTrainNo", model.strTrainNo),
new SqlParameter("strTrainTypeName", model.strTrainTypeName),
new SqlParameter("strTrainNumber", model.strTrainNumber),
new SqlParameter("nTMIS", model.nTMIS),
new SqlParameter("nKeHuo", model.nKehuo),
new SqlParameter("strGroupGUID", model.strGroupGUID),
new SqlParameter("strTrainmanNumber1", model.strTrainmanNumber1),
new SqlParameter("strTrainmanNumber2", model.strTrainmanNumber2),
new SqlParameter("nResult", model.nResultID),
new SqlParameter("strResult", model.strResult)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strUpSql.ToString(), sqlParameters));
}
else
{
return(0);
}
}
/// <summary>
/// 根据人员工号及事件时间获取出勤计划，取事件时间向前3天至当前时间的最后一条计划
/// </summary>
/// <param name="tmid"></param>
/// <param name="eventTime"></param>
/// <param name="Plan"></param>
/// <returns></returns>
public static Boolean GetTrainPlanBriefByRange(string tmid, DateTime?eventTime, TrainmanPlan Plan)
{
string sql = @"select top 1 * from VIEW_Plan_Trainman
where dtStartTime > DATEADD (Day,-3,@eventTime) and dtStartTime < @eventTime and nPlanState >= 4
and ((strTrainmanNumber1 = @tmid) or
(strTrainmanNumber2 = @tmid) or
(strTrainmanNumber3 = @tmid) or
(strTrainmanNumber4 = @tmid)) order by dtStartTime desc";
SqlParameter[] sqlParams =
{
new SqlParameter("@eventTime", eventTime),
new SqlParameter("@tmid", tmid)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql, sqlParams).Tables[0];
if (dt.Rows.Count == 0)
{
return(false);
}
else
{
Plan.trainPlan.planID = dt.Rows[0]["strTrainPlanGUID"].ToString();
Plan.trainPlan.lastArriveTime = DataTypeConvert.ToDateTime(dt.Rows[0]["dtlastArriveTime"]);
Plan.trainPlan.startTime = DataTypeConvert.ToDateTime(dt.Rows[0]["dtStartTime"]);
Plan.trainPlan.createTime = DataTypeConvert.ToDateTime(dt.Rows[0]["dtCreateTime"]);
Plan.tmGUID1 = dt.Rows[0]["strTrainmanGUID1"].ToString();
Plan.tmGUID2 = dt.Rows[0]["strTrainmanGUID2"].ToString();
Plan.tmGUID3 = dt.Rows[0]["strTrainmanGUID3"].ToString();
Plan.tmGUID4 = dt.Rows[0]["strTrainmanGUID4"].ToString();
Plan.tmid1 = dt.Rows[0]["strTrainmanNumber1"].ToString();
Plan.tmid2 = dt.Rows[0]["strTrainmanNumber2"].ToString();
Plan.tmid3 = dt.Rows[0]["strTrainmanNumber3"].ToString();
Plan.tmid4 = dt.Rows[0]["strTrainmanNumber4"].ToString();
Plan.tmname1 = dt.Rows[0]["strTrainmanName1"].ToString();
Plan.tmname2 = dt.Rows[0]["strTrainmanName2"].ToString();
Plan.tmname3 = dt.Rows[0]["strTrainmanName3"].ToString();
Plan.tmname4 = dt.Rows[0]["strTrainmanName4"].ToString();
return(true);
}
}
