/// <summary>
/// 得到一个对象实体
/// </summary>
public TF.RunSafty.Model.TAB_Plan_Train GetModel(int nid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 nid,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,dtLastArriveTime,strMainPlanGUID,strPlaceID from TAB_Plan_Train ");
strSql.Append(" where nid=@nid");
SqlParameter[] parameters =
{
new SqlParameter("@nid", SqlDbType.Int, 4)
};
parameters[0].Value = nid;
TF.RunSafty.Model.TAB_Plan_Train model = new TF.RunSafty.Model.TAB_Plan_Train();
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.BLL.Plan.TAB_Plan_Train bllPlan = new TF.RunSafty.BLL.Plan.TAB_Plan_Train();
TF.RunSafty.Model.TAB_Plan_Train plan = new TF.RunSafty.Model.TAB_Plan_Train();
try
{
DateTime dtStartTime;
if (DateTime.TryParse(param.data.trainPlan.startTime, out dtStartTime))
{
plan.dtStartTime = dtStartTime;
}
if (!string.IsNullOrEmpty(param.data.trainPlan.dragTypeID))
{
plan.nDragType = int.Parse(param.data.trainPlan.dragTypeID);
}
if (!string.IsNullOrEmpty(param.data.trainPlan.kehuoID))
{
plan.nKehuoID = int.Parse(param.data.trainPlan.kehuoID);
}
if (!string.IsNullOrEmpty(param.data.trainPlan.planTypeID))
{
plan.nPlanType = int.Parse(param.data.trainPlan.planTypeID);
}
if (!string.IsNullOrEmpty(param.data.trainPlan.remarkTypeID))
{
plan.nRemarkType = int.Parse(param.data.trainPlan.remarkTypeID);
}
if (!string.IsNullOrEmpty(param.data.trainPlan.trainmanTypeID))
{
plan.nTrainmanTypeID = int.Parse(param.data.trainPlan.trainmanTypeID);
}
plan.strCreateSiteGUID = param.data.site.siteID;
plan.strCreateUserGUID = param.data.user.userID;
plan.strPlaceID = param.data.trainPlan.placeID;
plan.strStartStation = param.data.trainPlan.startStationID;
plan.strEndStation = param.data.trainPlan.endStationID;
plan.strTrainJiaoluGUID = param.data.trainPlan.trainjiaoluID;
plan.strTrainNo = param.data.trainPlan.trainNo;
plan.strTrainNumber = param.data.trainPlan.trainNumber;
plan.strTrainTypeName = param.data.trainPlan.trainTypeName;
plan.dtCreateTime = DateTime.Now;
plan.dtRealStartTime = plan.dtStartTime;
string planGUID = Guid.NewGuid().ToString();
plan.strTrainPlanGUID = planGUID;
plan.nPlanState = (int)TRsPlanState.psEdit;
if (!string.IsNullOrEmpty(param.data.trainPlan.kaiCheTime))
{
DateTime dtChuqinTime;
if (DateTime.TryParse(param.data.trainPlan.kaiCheTime, out dtChuqinTime))
{
plan.dtChuQinTime = dtChuqinTime;
}
}
if (bllPlan.Add(plan) > 0)
{
jsonModel.data.planID = planGUID;
jsonModel.result = 0;
jsonModel.resultStr = "返回成功";
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter).Replace(":null", ":\"\"");
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddPlanTrain(TF.RunSafty.Model.TAB_Plan_Train model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Plan_Train(");
strSql.Append("strTrainNo,dtChuQinTime,nNeedRest,dtArriveTime,dtCallTime,nDragType,nKehuoID,nPlanType,nRemarkType,nTrainmanTypeID,strTrainJiaoluGUID,strTrainTypeName,dtStartTime,dtFirstStartTime,dtRealStartTime,nPlanState,strPlaceID,strStartStation,strEndStation,strRemark,strTrainNumber,strCreateSiteGUID,strCreateUserGUID");
strSql.Append(") values (");
strSql.Append("@strTrainNo,@dtChuQinTime,@nNeedRest,@dtArriveTime,@dtCallTime,@nDragType,@nKehuoID,@nPlanType,@nRemarkType,@nTrainmanTypeID,@strTrainJiaoluGUID,@strTrainTypeName,@dtStartTime,@dtFirstStartTime,@dtRealStartTime,@nPlanState,@strPlaceID,@strStartStation,@strEndStation,@strRemark,@strTrainNumber,@strCreateSiteGUID,@strCreateUserGUID");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@strTrainNo", SqlDbType.VarChar, 50),
new SqlParameter("@dtChuQinTime", SqlDbType.DateTime),
new SqlParameter("@dtArriveTime", SqlDbType.DateTime),
new SqlParameter("@dtCallTime", SqlDbType.DateTime),
new SqlParameter("@nDragType", SqlDbType.Int, 4),
new SqlParameter("@nKehuoID", SqlDbType.Int, 4),
new SqlParameter("@nNeedRest", SqlDbType.Int, 4),
new SqlParameter("@nPlanType", SqlDbType.Int, 4),
new SqlParameter("@nRemarkType", SqlDbType.Int, 4),
new SqlParameter("@nTrainmanTypeID", SqlDbType.Int, 4),
new SqlParameter("@strTrainJiaoluGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strTrainTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@dtStartTime", SqlDbType.DateTime),
new SqlParameter("@dtFirstStartTime", SqlDbType.DateTime),
new SqlParameter("@dtRealStartTime", SqlDbType.DateTime),
new SqlParameter("@nPlanState", SqlDbType.Int, 4),
new SqlParameter("@strPlaceID", SqlDbType.VarChar, 50),
new SqlParameter("@strStartStation", SqlDbType.VarChar, 50),
new SqlParameter("@strEndStation", SqlDbType.VarChar, 50),
new SqlParameter("@strRemark", SqlDbType.VarChar, 50),
new SqlParameter("@strTrainNumber", SqlDbType.VarChar, 50),
new SqlParameter("@strCreateSiteGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strCreateUserGUID", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.strTrainNo;
parameters[1].Value = model.dtChuQinTime;
parameters[2].Value = model.dtArriveTime;
parameters[3].Value = model.dtCallTime;
parameters[4].Value = model.nDragType;
parameters[5].Value = model.nKehuoID;
parameters[6].Value = model.nNeedRest;
parameters[7].Value = model.nPlanType;
parameters[8].Value = model.nRemarkType;
parameters[9].Value = model.nTrainmanTypeID;
parameters[10].Value = model.strTrainJiaoluGUID;
parameters[11].Value = model.strTrainTypeName;
parameters[12].Value = model.dtStartTime;
parameters[13].Value = model.dtFirstStartTime;
parameters[14].Value = model.dtRealStartTime;
parameters[15].Value = model.nPlanState;
parameters[16].Value = model.strPlaceID;
parameters[17].Value = model.strStartStation;
parameters[18].Value = model.strEndStation;
parameters[19].Value = model.strRemark;
parameters[20].Value = model.strTrainNumber;
parameters[21].Value = model.strCreateSiteGUID;
parameters[22].Value = model.strCreateUserGUID;
int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TF.RunSafty.Model.TAB_Plan_Train DataRowToModel(DataRow row)
{
TF.RunSafty.Model.TAB_Plan_Train model = new TF.RunSafty.Model.TAB_Plan_Train();
if (row != null)
{
if (row["nid"] != null && row["nid"].ToString() != "")
{
model.nid = int.Parse(row["nid"].ToString());
}
if (row["strTrainPlanGUID"] != null)
{
model.strTrainPlanGUID = row["strTrainPlanGUID"].ToString();
}
if (row["strTrainTypeName"] != null)
{
model.strTrainTypeName = row["strTrainTypeName"].ToString();
}
if (row["strTrainNumber"] != null)
{
model.strTrainNumber = row["strTrainNumber"].ToString();
}
if (row["strTrainNo"] != null)
{
model.strTrainNo = row["strTrainNo"].ToString();
}
if (row["dtStartTime"] != null && row["dtStartTime"].ToString() != "")
{
model.dtStartTime = DateTime.Parse(row["dtStartTime"].ToString());
}
if (row["dtRealStartTime"] != null && row["dtRealStartTime"].ToString() != "")
{
model.dtRealStartTime = DateTime.Parse(row["dtRealStartTime"].ToString());
}
if (row["strTrainJiaoluGUID"] != null)
{
model.strTrainJiaoluGUID = row["strTrainJiaoluGUID"].ToString();
}
if (row["strStartStation"] != null)
{
model.strStartStation = row["strStartStation"].ToString();
}
if (row["strEndStation"] != null)
{
model.strEndStation = row["strEndStation"].ToString();
}
if (row["nTrainmanTypeID"] != null && row["nTrainmanTypeID"].ToString() != "")
{
model.nTrainmanTypeID = int.Parse(row["nTrainmanTypeID"].ToString());
}
if (row["nPlanType"] != null && row["nPlanType"].ToString() != "")
{
model.nPlanType = int.Parse(row["nPlanType"].ToString());
}
if (row["nDragType"] != null && row["nDragType"].ToString() != "")
{
model.nDragType = int.Parse(row["nDragType"].ToString());
}
if (row["nKehuoID"] != null && row["nKehuoID"].ToString() != "")
{
model.nKehuoID = int.Parse(row["nKehuoID"].ToString());
}
if (row["nRemarkType"] != null && row["nRemarkType"].ToString() != "")
{
model.nRemarkType = int.Parse(row["nRemarkType"].ToString());
}
if (row["strRemark"] != null)
{
model.strRemark = row["strRemark"].ToString();
}
if (row["nPlanState"] != null && row["nPlanState"].ToString() != "")
{
model.nPlanState = int.Parse(row["nPlanState"].ToString());
}
if (row["dtCreateTime"] != null && row["dtCreateTime"].ToString() != "")
{
model.dtCreateTime = DateTime.Parse(row["dtCreateTime"].ToString());
}
if (row["strCreateSiteGUID"] != null)
{
model.strCreateSiteGUID = row["strCreateSiteGUID"].ToString();
}
if (row["strCreateUserGUID"] != null)
{
model.strCreateUserGUID = row["strCreateUserGUID"].ToString();
}
if (row["dtFirstStartTime"] != null && row["dtFirstStartTime"].ToString() != "")
{
//model.dtFirstStartTime=DateTime.Parse(row["dtFirstStartTime"].ToString());
DateTime dtFirstStartTime;
if (DateTime.TryParse(row["dtFirstStartTime"].ToString(), out dtFirstStartTime))
{
model.dtFirstStartTime = dtFirstStartTime;
}
}
if (row["dtChuQinTime"] != null && row["dtChuQinTime"].ToString() != "")
{
model.dtChuQinTime = DateTime.Parse(row["dtChuQinTime"].ToString());
}
if (row["nNeedRest"] != null && row["nNeedRest"].ToString() != "")
{
model.nNeedRest = int.Parse(row["nNeedRest"].ToString());
}
if (row["dtArriveTime"] != null && row["dtArriveTime"].ToString() != "")
{
model.dtArriveTime = DateTime.Parse(row["dtArriveTime"].ToString());
}
if (row["dtCallTime"] != null && row["dtCallTime"].ToString() != "")
{
model.dtCallTime = DateTime.Parse(row["dtCallTime"].ToString());
}
if (row["strBak1"] != null)
{
model.strBak1 = row["strBak1"].ToString();
}
if (row["dtLastArriveTime"] != null && row["dtLastArriveTime"].ToString() != "")
{
//model.dtLastArriveTime=DateTime.Parse(row["dtLastArriveTime"].ToString());
DateTime dtLastArriveTime;
if (DateTime.TryParse(row["dtLastArriveTime"].ToString(), out dtLastArriveTime))
{
model.dtLastArriveTime = dtLastArriveTime;
}
}
if (row["strMainPlanGUID"] != null)
{
model.strMainPlanGUID = row["strMainPlanGUID"].ToString();
}
if (row["strPlaceID"] != null)
{
model.strPlaceID = row["strPlaceID"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TF.RunSafty.Model.TAB_Plan_Train model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TAB_Plan_Train set ");
strSql.Append("strTrainTypeName=@strTrainTypeName,");
strSql.Append("strTrainNumber=@strTrainNumber,");
strSql.Append("strTrainNo=@strTrainNo,");
strSql.Append("dtRealStartTime=@dtRealStartTime,");
strSql.Append("strTrainJiaoluGUID=@strTrainJiaoluGUID,");
strSql.Append("strStartStation=@strStartStation,");
strSql.Append("strEndStation=@strEndStation,");
strSql.Append("nTrainmanTypeID=@nTrainmanTypeID,");
strSql.Append("nPlanType=@nPlanType,");
strSql.Append("nDragType=@nDragType,");
strSql.Append("nKehuoID=@nKehuoID,");
strSql.Append("nRemarkType=@nRemarkType,");
strSql.Append("strRemark=@strRemark,");
strSql.Append("dtCreateTime=@dtCreateTime,");
strSql.Append("strCreateSiteGUID=@strCreateSiteGUID,");
strSql.Append("strCreateUserGUID=@strCreateUserGUID,");
strSql.Append("dtFirstStartTime=@dtFirstStartTime,");
strSql.Append("dtChuQinTime=@dtChuQinTime,");
strSql.Append("nNeedRest=@nNeedRest,");
strSql.Append("dtArriveTime=@dtArriveTime,");
strSql.Append("dtCallTime=@dtCallTime,");
strSql.Append("strBak1=@strBak1,");
strSql.Append("dtLastArriveTime=@dtLastArriveTime,");
strSql.Append("strMainPlanGUID=@strMainPlanGUID,");
strSql.Append("strPlaceID=@strPlaceID");
strSql.Append(" where nid=@nid");
SqlParameter[] parameters =
{
new SqlParameter("@strTrainTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@strTrainNumber", SqlDbType.VarChar, 50),
new SqlParameter("@strTrainNo", SqlDbType.VarChar, 50),
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("@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("@dtLastArriveTime", SqlDbType.DateTime),
new SqlParameter("@strMainPlanGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strPlaceID", SqlDbType.VarChar, 50),
new SqlParameter("@nid", SqlDbType.Int, 4),
new SqlParameter("@strTrainPlanGUID", SqlDbType.VarChar, 50),
new SqlParameter("@dtStartTime", SqlDbType.DateTime),
new SqlParameter("@nPlanState", SqlDbType.Int, 4)
};
parameters[0].Value = model.strTrainTypeName;
parameters[1].Value = model.strTrainNumber;
parameters[2].Value = model.strTrainNo;
parameters[3].Value = model.dtRealStartTime;
parameters[4].Value = model.strTrainJiaoluGUID;
parameters[5].Value = model.strStartStation;
parameters[6].Value = model.strEndStation;
parameters[7].Value = model.nTrainmanTypeID;
parameters[8].Value = model.nPlanType;
parameters[9].Value = model.nDragType;
parameters[10].Value = model.nKehuoID;
parameters[11].Value = model.nRemarkType;
parameters[12].Value = model.strRemark;
parameters[13].Value = model.dtCreateTime;
parameters[14].Value = model.strCreateSiteGUID;
parameters[15].Value = model.strCreateUserGUID;
parameters[16].Value = model.dtFirstStartTime;
parameters[17].Value = model.dtChuQinTime;
parameters[18].Value = model.nNeedRest;
parameters[19].Value = model.dtArriveTime;
parameters[20].Value = model.dtCallTime;
parameters[21].Value = model.strBak1;
parameters[22].Value = model.dtLastArriveTime;
parameters[23].Value = model.strMainPlanGUID;
parameters[24].Value = model.strPlaceID;
parameters[25].Value = model.nid;
parameters[26].Value = model.strTrainPlanGUID;
parameters[27].Value = model.dtStartTime;
parameters[28].Value = model.nPlanState;
int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
