public int AddPlan(MDTrain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Plan_Train(");
strSql.Append("strTrainPlanGUID,strTrainTypeName,strTrainNumber,strTrainNo,dtStartTime,dtRealStartTime,strTrainJiaoluGUID,strStartStation,strEndStation,nTrainmanTypeID,nPlanType,nDragType,nKehuoID,nRemarkType,strRemark,nPlanState,dtCreateTime,strCreateSiteGUID,strCreateUserGUID,dtFirstStartTime,dtChuQinTime,nNeedRest,dtArriveTime,dtCallTime,strBak1,strMainPlanGUID,strPlaceID)");
strSql.Append(" values (");
strSql.Append("@strTrainPlanGUID,@strTrainTypeName,@strTrainNumber,@strTrainNo,@dtStartTime,@dtRealStartTime,@strTrainJiaoluGUID,@strStartStation,@strEndStation,@nTrainmanTypeID,@nPlanType,@nDragType,@nKehuoID,@nRemarkType,@strRemark,@nPlanState,@dtCreateTime,@strCreateSiteGUID,@strCreateUserGUID,@dtFirstStartTime,@dtChuQinTime,@nNeedRest,@dtArriveTime,@dtCallTime,@strBak1,@strMainPlanGUID,@strPlaceID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@strTrainPlanGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strTrainTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@strTrainNumber", SqlDbType.VarChar, 50),
new SqlParameter("@strTrainNo", SqlDbType.VarChar, 50),
new SqlParameter("@dtStartTime", SqlDbType.DateTime),
new SqlParameter("@dtRealStartTime", SqlDbType.DateTime),
new SqlParameter("@strTrainJiaoluGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strStartStation", SqlDbType.VarChar, 50),
new SqlParameter("@strEndStation", SqlDbType.VarChar, 50),
new SqlParameter("@nTrainmanTypeID", SqlDbType.Int, 4),
new SqlParameter("@nPlanType", SqlDbType.Int, 4),
new SqlParameter("@nDragType", SqlDbType.Int, 4),
new SqlParameter("@nKehuoID", SqlDbType.Int, 4),
new SqlParameter("@nRemarkType", SqlDbType.Int, 4),
new SqlParameter("@strRemark", SqlDbType.VarChar, 50),
new SqlParameter("@nPlanState", SqlDbType.Int, 4),
new SqlParameter("@dtCreateTime", SqlDbType.DateTime),
new SqlParameter("@strCreateSiteGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strCreateUserGUID", SqlDbType.VarChar, 50),
new SqlParameter("@dtFirstStartTime", SqlDbType.DateTime),
new SqlParameter("@dtChuQinTime", SqlDbType.DateTime),
new SqlParameter("@nNeedRest", SqlDbType.Int, 4),
new SqlParameter("@dtArriveTime", SqlDbType.DateTime),
new SqlParameter("@dtCallTime", SqlDbType.DateTime),
new SqlParameter("@strBak1", SqlDbType.VarChar, 50),
new SqlParameter("@strMainPlanGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strPlaceID", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.strTrainPlanGUID;
parameters[1].Value = model.strTrainTypeName;
parameters[2].Value = model.strTrainNumber;
parameters[3].Value = model.strTrainNo;
parameters[4].Value = model.dtStartTime;
parameters[5].Value = model.dtRealStartTime;
parameters[6].Value = model.strTrainJiaoluGUID;
parameters[7].Value = model.strStartStation;
parameters[8].Value = model.strEndStation;
parameters[9].Value = model.nTrainmanTypeID;
parameters[10].Value = model.nPlanType;
parameters[11].Value = model.nDragType;
parameters[12].Value = model.nKehuoID;
parameters[13].Value = model.nRemarkType;
parameters[14].Value = model.strRemark;
parameters[15].Value = model.nPlanState;
parameters[16].Value = model.dtCreateTime;
parameters[17].Value = model.strCreateSiteGUID;
parameters[18].Value = model.strCreateUserGUID;
parameters[19].Value = model.dtFirstStartTime;
parameters[20].Value = model.dtChuQinTime;
parameters[21].Value = model.nNeedRest;
parameters[22].Value = model.dtArriveTime;
parameters[23].Value = model.dtCallTime;
parameters[24].Value = model.strBak1;
parameters[25].Value = model.strMainPlanGUID;
parameters[26].Value = model.strPlaceID;
object obj = SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public bool ProduceJDPlan(string SectionID, string SiteName, string SiteNumber, string TrainID, string JiaoluGUID, string SiteGUID, string UserGUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM TAB_TMIS_Train where train_id='" + TrainID + "' ");
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0];
if (dt.Rows.Count <= 0)
{
throw new Exception("未在TAB_TMIS_Train 表中找到train_id为" + TrainID + "的数据");
}
else
{
MDTrain model = new MDTrain();
model.strTrainNo = ObjectConvertClass.static_ext_string(dt.Rows[0]["train_code"]);
//通过出勤规则，计划开车时间计算出计划出勤时间
int minutes = GetPlanTimes(1, "2200004");
DateTime dtStartTime = ObjectConvertClass.static_ext_Date(dt.Rows[0]["time_deptart"]).AddMinutes(-minutes);
model.dtStartTime = dtStartTime;
model.strStartStation = getStationGUIDByName(ObjectConvertClass.static_ext_string(dt.Rows[0]["station_deptart"]));
model.strEndStation = getStationGUIDByName(ObjectConvertClass.static_ext_string(dt.Rows[0]["station_arrived"]));
model.strTrainPlanGUID = Guid.NewGuid().ToString();
model.strTrainTypeName = "";
model.strTrainNumber = "";
model.dtRealStartTime = Convert.ToDateTime("2000-01-01 00:00:00");
model.strTrainJiaoluGUID = JiaoluGUID;
model.nTrainmanTypeID = 1;
model.nPlanType = 1;
model.nDragType = 2;
TF.RunSafty.Utility.TGlobalDM d = new Utility.TGlobalDM();
string remark = "";
model.nKehuoID = Convert.ToInt32(d.getKeHuoByTrainNo(model.strTrainNo, ref remark));
TF.CommonUtility.LogClass.log("获取客货类型----车次：" + model.strTrainNo + "客货类型：" + model.nKehuoID + "备注：" + remark);
model.nRemarkType = 1;
model.strRemark = "";
model.nPlanState = 1;
model.dtCreateTime = DateTime.Now;
model.strCreateSiteGUID = SiteGUID;
model.strCreateUserGUID = UserGUID;
model.dtFirstStartTime = Convert.ToDateTime("2000-01-01 00:00:00");
model.dtChuQinTime = ObjectConvertClass.static_ext_Date(dt.Rows[0]["time_deptart"]);
model.nNeedRest = 0;
model.dtArriveTime = Convert.ToDateTime("2000-01-01 00:00:00");
model.dtCallTime = Convert.ToDateTime("2000-01-01 00:00:00");
model.strBak1 = "";
model.strMainPlanGUID = "";
model.strPlaceID = getPlaceIDByTJLGUID(JiaoluGUID);
if (this.AddPlan(model) >= 1)
{
string sql = "update TAB_TMIS_Train set strTrainPlanGUID = @strTrainPlanGUID where train_id='" + TrainID + "'";
SqlParameter[] param =
{
new SqlParameter("strTrainPlanGUID", model.strTrainPlanGUID)
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sql, param);
return(true);
}
}
return(false);
}