/// <summary>
/// 获得对象信息
/// <summary>
public InterfaceOutPut GetEntry(String Data)
{
InterfaceOutPut output = new InterfaceOutPut();
output.result = 0;
try
{
CommonJsonModel cjm = new CommonJsonModel(Data);
Base_TrainNoQueryCondition _Base_TrainNoQueryCondition = new Base_TrainNoQueryCondition();
_Base_TrainNoQueryCondition.strGUID = ObjectConvertClass.static_ext_string(cjm.GetValue("strGUID"));
DBBase_TrainNo dbBase_TrainNo = new DBBase_TrainNo(ThinkFreely.DBUtility.SqlHelper.ConnString);
Base_TrainNo _Base_TrainNo = dbBase_TrainNo.GetModel(_Base_TrainNoQueryCondition);
if (_Base_TrainNo == null)
{
output.resultStr = "没有对应数据";
}
else
{
output.result = 1;
List <Base_TrainNo> Base_TrainNoList = new List <Base_TrainNo>();
Base_TrainNoList.Add(_Base_TrainNo);
output.data = Base_TrainNoList;
}
}
catch (Exception ex)
{
output.resultStr = ex.Message;
LogClass.log("InterfaceBase_TrainNo.GetEntry:" + ex.Message);
}
return(output);
}
/// <summary>
/// 获得数据List
/// <summary>
public List <Base_TrainNo> GetDataList(Base_TrainNoQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
if (QueryCondition.page == 0)
{
strSql.Append("select * ");
strSql.Append(" FROM TAB_Base_TrainNo where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_Base_TrainNo where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from TAB_Base_TrainNo where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
}
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
List <Base_TrainNo> list = new List <Base_TrainNo>();
foreach (DataRow dr in dt.Rows)
{
Base_TrainNo _Base_TrainNo = new Base_TrainNo();
DataRowToModel(_Base_TrainNo, dr);
list.Add(_Base_TrainNo);
}
return(list);
}
/// <summary>
/// 添加数据
/// <summary>
public bool Add(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)");
strSql.Append("values(@strGUID,@strTrainTypeName,@strTrainNumber,@strTrainNo,@dtStartTime,@dtRealStartTime,@strTrainJiaoluGUID,@strStartStation,@strEndStation,@nTrainmanTypeID,@nPlanType,@nDragType,@nKehuoID,@nRemarkType,@strRemark,@dtCreateTime,@strCreateSiteGUID,@strCreateUserGUID,@strPlaceID,@dtPlanStartTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@strGUID", model.strGUID),
new SqlParameter("@strTrainTypeName", model.strTrainTypeName),
new SqlParameter("@strTrainNumber", model.strTrainNumber),
new SqlParameter("@strTrainNo", model.strTrainNo),
new SqlParameter("@dtStartTime", model.dtStartTime),
new SqlParameter("@dtRealStartTime", model.dtRealStartTime),
new SqlParameter("@strTrainJiaoluGUID", model.strTrainJiaoluGUID),
new SqlParameter("@strStartStation", model.strStartStation),
new SqlParameter("@strEndStation", model.strEndStation),
new SqlParameter("@nTrainmanTypeID", model.nTrainmanTypeID),
new SqlParameter("@nPlanType", model.nPlanType),
new SqlParameter("@nDragType", model.nDragType),
new SqlParameter("@nKehuoID", model.nKehuoID),
new SqlParameter("@nRemarkType", model.nRemarkType),
new SqlParameter("@strRemark", model.strRemark),
new SqlParameter("@dtCreateTime", model.dtCreateTime),
new SqlParameter("@strCreateSiteGUID", model.strCreateSiteGUID),
new SqlParameter("@strCreateUserGUID", model.strCreateUserGUID),
new SqlParameter("@strPlaceID", model.strPlaceID),
new SqlParameter("@dtPlanStartTime", model.dtPlanStartTime)
};
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 检查数据是否存在
/// <summary>
public bool Exists(Base_TrainNo _Base_TrainNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from TAB_Base_TrainNo where strGUID=@strGUID");
SqlParameter[] parameters =
{
new SqlParameter("strGUID", _Base_TrainNo.strGUID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters)) > 0);
}
/// <summary>
/// 更新数据
/// <summary>
public bool Update(Base_TrainNo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update TAB_Base_TrainNo set ");
strSql.Append(" strGUID = @strGUID, ");
strSql.Append(" strTrainTypeName = @strTrainTypeName, ");
strSql.Append(" strTrainNumber = @strTrainNumber, ");
strSql.Append(" strTrainNo = @strTrainNo, ");
strSql.Append(" dtStartTime = @dtStartTime, ");
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(" strPlaceID = @strPlaceID, ");
strSql.Append(" dtPlanStartTime = @dtPlanStartTime ");
strSql.Append(" where strGUID = @strGUID ");
SqlParameter[] parameters =
{
new SqlParameter("@strGUID", model.strGUID),
new SqlParameter("@strTrainTypeName", model.strTrainTypeName),
new SqlParameter("@strTrainNumber", model.strTrainNumber),
new SqlParameter("@strTrainNo", model.strTrainNo),
new SqlParameter("@dtStartTime", model.dtStartTime),
new SqlParameter("@dtRealStartTime", model.dtRealStartTime),
new SqlParameter("@strTrainJiaoluGUID", model.strTrainJiaoluGUID),
new SqlParameter("@strStartStation", model.strStartStation),
new SqlParameter("@strEndStation", model.strEndStation),
new SqlParameter("@nTrainmanTypeID", model.nTrainmanTypeID),
new SqlParameter("@nPlanType", model.nPlanType),
new SqlParameter("@nDragType", model.nDragType),
new SqlParameter("@nKehuoID", model.nKehuoID),
new SqlParameter("@nRemarkType", model.nRemarkType),
new SqlParameter("@strRemark", model.strRemark),
new SqlParameter("@dtCreateTime", model.dtCreateTime),
new SqlParameter("@strCreateSiteGUID", model.strCreateSiteGUID),
new SqlParameter("@strCreateUserGUID", model.strCreateUserGUID),
new SqlParameter("@strPlaceID", model.strPlaceID),
new SqlParameter("@dtPlanStartTime", model.dtPlanStartTime)
};
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 获得一个实体对象
/// <summary>
public Base_TrainNo GetModel(Base_TrainNoQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * ");
strSql.Append(" FROM TAB_Base_TrainNo where 1=1 " + strSqlOption.ToString());
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
Base_TrainNo _Base_TrainNo = null;
if (dt.Rows.Count > 0)
{
_Base_TrainNo = new Base_TrainNo();
DataRowToModel(_Base_TrainNo, dt.Rows[0]);
}
return(_Base_TrainNo);
}
/// <summary>
/// 保存信息
/// <summary>
public InterfaceOutPut Save(String Data)
{
InterfaceOutPut output = new InterfaceOutPut();
output.result = 0;
try
{
CommonJsonModel cjm = new CommonJsonModel(Data);
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
Base_TrainNo _Base_TrainNo = javaScriptSerializer.Deserialize <Base_TrainNo>(Data);
DBBase_TrainNo dbBase_TrainNo = new DBBase_TrainNo(ThinkFreely.DBUtility.SqlHelper.ConnString);
dbBase_TrainNo.Add(_Base_TrainNo);
output.result = 1;
}
catch (Exception ex)
{
output.resultStr = ex.Message;
LogClass.log("InterfaceBase_TrainNo.Save:" + ex.Message);
}
return(output);
}
/// <summary>
/// 读取DataRow数据到Model中
/// <summary>
private void DataRowToModel(Base_TrainNo model, DataRow dr)
{
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
model.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.dtStartTime = ObjectConvertClass.static_ext_date(dr["dtStartTime"]);
model.dtRealStartTime = ObjectConvertClass.static_ext_date(dr["dtRealStartTime"]);
model.strTrainJiaoluGUID = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluGUID"]);
model.strStartStation = ObjectConvertClass.static_ext_string(dr["strStartStation"]);
model.strEndStation = ObjectConvertClass.static_ext_string(dr["strEndStation"]);
model.nTrainmanTypeID = ObjectConvertClass.static_ext_int(dr["nTrainmanTypeID"]);
model.nPlanType = ObjectConvertClass.static_ext_int(dr["nPlanType"]);
model.nDragType = ObjectConvertClass.static_ext_int(dr["nDragType"]);
model.nKehuoID = ObjectConvertClass.static_ext_int(dr["nKehuoID"]);
model.nRemarkType = ObjectConvertClass.static_ext_int(dr["nRemarkType"]);
model.strRemark = ObjectConvertClass.static_ext_string(dr["strRemark"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.strCreateSiteGUID = ObjectConvertClass.static_ext_string(dr["strCreateSiteGUID"]);
model.strCreateUserGUID = ObjectConvertClass.static_ext_string(dr["strCreateUserGUID"]);
model.strPlaceID = ObjectConvertClass.static_ext_string(dr["strPlaceID"]);
model.dtPlanStartTime = ObjectConvertClass.static_ext_date(dr["dtPlanStartTime"]);
}
