public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.Model.TAB_Base_TrainNo train = new TF.RunSafty.Model.TAB_Base_TrainNo();
TF.RunSafty.BLL.TAB_Base_TrainNo bllTrain = new TF.RunSafty.BLL.TAB_Base_TrainNo();
if (bllTrain.Delete(paramModel.data.trainnoID))
{
jsonModel.result = 0;
jsonModel.resultStr = "返回成功";
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel);
return(result);
}
/// <summary>
/// 添加图定车次
/// </summary>
/// <returns></returns>
public Add_Out Add(string data)
{
Add_Out json = new Add_Out();
Add_In trainNo = Newtonsoft.Json.JsonConvert.DeserializeObject <Add_In>(data);
TF.RunSafty.BLL.TAB_Base_TrainNo bllTrain = new TF.RunSafty.BLL.TAB_Base_TrainNo();
TF.RunSafty.Model.TAB_Base_TrainNo train = new TF.RunSafty.Model.TAB_Base_TrainNo();
Train t = new Train();
try
{
string strGUID = Guid.NewGuid().ToString();
train.strGUID = strGUID;
SetModelValue(trainNo.trainnoInfo, train);
if (bllTrain.Add(train))
{
t.trainnoID = train.strGUID;
json.result = "0";
json.resultStr = "返回成功";
json.data = t;
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
throw ex;
}
return(json);
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.Model.TAB_Base_TrainNo train = new TF.RunSafty.Model.TAB_Base_TrainNo();
TF.RunSafty.BLL.TAB_Base_TrainNo bllTrain = new TF.RunSafty.BLL.TAB_Base_TrainNo();
DateTime dtBegin, dtEnd;
string strTrainjiao = paramModel.data.trainjiaoluID;
dtBegin = DateTime.Parse(paramModel.data.beginTime);
dtEnd = DateTime.Parse(paramModel.data.endTime);
int PlanState = paramModel.data.planState <= 0 ? 1 : paramModel.data.planState;
bllTrain.GetTrainnoByTime(strTrainjiao, dtBegin, dtEnd, PlanState);
jsonModel.result = 0;
jsonModel.resultStr = "返回成功";
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel);
return(result);
}
public void SetModelValue(TrainNo paramModel, TF.RunSafty.Model.TAB_Base_TrainNo train)
{
train.dtCreateTime = DateTime.Now;
if (!string.IsNullOrEmpty(paramModel.dragTypeID))
{
train.nDragType = int.Parse(paramModel.dragTypeID);
}
if (!string.IsNullOrEmpty(paramModel.kehuoID))
{
train.nKehuoID = int.Parse(paramModel.kehuoID);
}
if (!string.IsNullOrEmpty(paramModel.planTypeID))
{
train.nPlanType = int.Parse(paramModel.planTypeID);
}
train.nRemarkType = int.Parse(paramModel.remarkTypeID);
train.nTrainmanTypeID = int.Parse(paramModel.trainmanTypeID);
train.strEndStation = paramModel.endStationID;
train.strPlaceID = paramModel.placeID;
train.strRemark = paramModel.remark;
train.strStartStation = paramModel.startStationID;
train.strTrainJiaoluGUID = paramModel.trainjiaoluID;
train.strTrainNo = paramModel.trainNo;
train.strTrainNumber = paramModel.trainNumber;
train.strTrainTypeName = paramModel.trainTypeName;
DateTime dt = paramModel.startTime;
train.dtStartTime = dt;
train.dtRealStartTime = dt;
DateTime dtChuQinTime;
if (DateTime.TryParse(paramModel.kaiCheTime.ToString(), out dtChuQinTime))
{
train.dtPlanStartTime = dtChuQinTime;
}
train.nNeedRest = paramModel.nNeedRest;
train.dtCallTime = paramModel.dtCallTime;
train.dtArriveTime = paramModel.dtArriveTime;
train.strWorkDay = paramModel.strWorkDay;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TF.RunSafty.Model.TAB_Base_TrainNo GetModel(string strGUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 strGUID,strTrainTypeName,strTrainNumber,strTrainNo,dtStartTime,dtRealStartTime,strTrainJiaoluGUID,strStartStation,strEndStation,nTrainmanTypeID,nPlanType,nDragType,nKehuoID,nRemarkType,strRemark,dtCreateTime,strCreateSiteGUID,strCreateUserGUID,strPlaceID,dtPlanStartTime,nNeedRest,dtArriveTime,dtCallTime,strWorkDay from TAB_Base_TrainNo ");
strSql.Append(" where strGUID=@strGUID ");
SqlParameter[] parameters =
{
new SqlParameter("@strGUID", SqlDbType.VarChar, 50)
};
parameters[0].Value = strGUID;
TF.RunSafty.Model.TAB_Base_TrainNo model = new TF.RunSafty.Model.TAB_Base_TrainNo();
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public Update_Out Update(string data)
{
Update_Out json = new Update_Out();
Update_In input = Newtonsoft.Json.JsonConvert.DeserializeObject <Update_In>(data);
try
{
TF.RunSafty.BLL.TAB_Base_TrainNo bllTrain = new TF.RunSafty.BLL.TAB_Base_TrainNo();
TF.RunSafty.Model.TAB_Base_TrainNo train = bllTrain.GetModel(input.trainnoInfo.trainNoID);
SetModelValue(input.trainnoInfo, train);
if (bllTrain.Update(train))
{
json.result = "0";
json.resultStr = "返回成功";
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
json.result = "1";
json.resultStr = "提交失败" + ex.InnerException.Message;
}
return(json);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TF.RunSafty.Model.TAB_Base_TrainNo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Base_TrainNo(");
strSql.Append("strGUID,strTrainTypeName,strTrainNumber,strTrainNo,dtStartTime,dtRealStartTime,strTrainJiaoluGUID,strStartStation,strEndStation,nTrainmanTypeID,nPlanType,nDragType,nKehuoID,nRemarkType,strRemark,dtCreateTime,strCreateSiteGUID,strCreateUserGUID,strPlaceID,dtPlanStartTime,nNeedRest,dtArriveTime,dtCallTime,strWorkDay)");
strSql.Append(" values (");
strSql.Append("@strGUID,@strTrainTypeName,@strTrainNumber,@strTrainNo,@dtStartTime,@dtRealStartTime,@strTrainJiaoluGUID,@strStartStation,@strEndStation,@nTrainmanTypeID,@nPlanType,@nDragType,@nKehuoID,@nRemarkType,@strRemark,@dtCreateTime,@strCreateSiteGUID,@strCreateUserGUID,@strPlaceID,@dtPlanStartTime,@nNeedRest,@dtArriveTime,@dtCallTime,@strWorkDay)");
SqlParameter[] parameters =
{
new SqlParameter("@strGUID", 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("@dtCreateTime", SqlDbType.DateTime),
new SqlParameter("@strCreateSiteGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strCreateUserGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strPlaceID", SqlDbType.VarChar, 50),
new SqlParameter("@dtPlanStartTime", SqlDbType.DateTime),
new SqlParameter("@nNeedRest", SqlDbType.Int, 4),
new SqlParameter("@dtArriveTime", SqlDbType.DateTime),
new SqlParameter("@dtCallTime", SqlDbType.DateTime),
new SqlParameter("@strWorkDay", SqlDbType.VarChar, 50),
};
parameters[0].Value = model.strGUID;
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.dtCreateTime;
parameters[16].Value = model.strCreateSiteGUID;
parameters[17].Value = model.strCreateUserGUID;
parameters[18].Value = model.strPlaceID;
parameters[19].Value = model.dtPlanStartTime;
parameters[20].Value = model.nNeedRest;
parameters[21].Value = model.dtArriveTime;
parameters[22].Value = model.dtCallTime;
parameters[23].Value = model.strWorkDay;
int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TF.RunSafty.Model.TAB_Base_TrainNo DataRowToModel(DataRow row)
{
TF.RunSafty.Model.TAB_Base_TrainNo model = new TF.RunSafty.Model.TAB_Base_TrainNo();
if (row != null)
{
if (row["strGUID"] != null)
{
model.strGUID = row["strGUID"].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["dtPlanStartTime"] != null && row["dtPlanStartTime"].ToString() != "")
{
model.dtPlanStartTime = DateTime.Parse(row["dtPlanStartTime"].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["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["strPlaceID"] != null)
{
model.strPlaceID = row["strPlaceID"].ToString();
}
model.nNeedRest = 0;
if (row["nNeedRest"] != null)
{
int nTemp;
if (Int32.TryParse(row["nNeedRest"].ToString(), out nTemp))
{
model.nNeedRest = nTemp;
}
}
if (row["dtArriveTime"] != null && !string.IsNullOrEmpty(row["dtArriveTime"].ToString()))
{
model.dtArriveTime = DateTime.Parse(row["dtArriveTime"].ToString());
}
if (row["dtCallTime"] != null && !string.IsNullOrEmpty(row["dtCallTime"].ToString()))
{
model.dtCallTime = DateTime.Parse(row["dtCallTime"].ToString());
}
if (row["strWorkDay"] != null && !string.IsNullOrEmpty(row["strWorkDay"].ToString()))
{
model.strWorkDay = row["strWorkDay"].ToString();
}
}
return(model);
}
