/// <summary>
/// 获得数据List
/// </summary>
public Plan_Beginwork_StepDefList GetDataList(Plan_Beginwork_StepDefQueryCondition 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_Plan_Beginwork_StepDef where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_Plan_Beginwork_StepDef where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from TAB_Plan_Beginwork_StepDef where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
}
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
Plan_Beginwork_StepDefList list = new Plan_Beginwork_StepDefList();
foreach (DataRow dr in dt.Rows)
{
Plan_Beginwork_StepDef _Plan_Beginwork_StepDef = new Plan_Beginwork_StepDef();
DataRowToModel(_Plan_Beginwork_StepDef, dr);
list.Add(_Plan_Beginwork_StepDef);
}
return(list);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(Plan_Beginwork_StepDef model, DataRow dr)
{
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
model.strStepName = ObjectConvertClass.static_ext_string(dr["strStepName"]);
model.strStepBrief = ObjectConvertClass.static_ext_string(dr["strStepBrief"]);
model.nStepIndex = ObjectConvertClass.static_ext_int(dr["nStepIndex"]);
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
}
/// <summary>
/// 检查数据是否存在
/// </summary>
public bool Exists(Plan_Beginwork_StepDef _Plan_Beginwork_StepDef)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from TAB_Plan_Beginwork_StepDef where nID=@nID");
SqlParameter[] parameters =
{
new SqlParameter("nID", _Plan_Beginwork_StepDef.nID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)) > 0);
}
public List <Plan_Beginwork_StepDef> getStep(string strWorkShopGUID, int nWorkTypeID)
{
string sql = "select * from TAB_Plan_Beginwork_StepDef where strWorkShopGUID='" + strWorkShopGUID + "' and nWorkTypeID='" + nWorkTypeID + "' order by nStepIndex";
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql).Tables[0];
List <Plan_Beginwork_StepDef> list = new List <Plan_Beginwork_StepDef>();
foreach (DataRow dr in dt.Rows)
{
Plan_Beginwork_StepDef Plan_Beginwork_StepDefM = new Plan_Beginwork_StepDef();
DataRowToStepModel(Plan_Beginwork_StepDefM, dr);
list.Add(Plan_Beginwork_StepDefM);
}
return(list);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToStepModel(Plan_Beginwork_StepDef model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
model.strStepName = ObjectConvertClass.static_ext_string(dr["strStepName"]);
model.strStepBrief = ObjectConvertClass.static_ext_string(dr["strStepBrief"]);
model.nStepIndex = ObjectConvertClass.static_ext_int(dr["nStepIndex"]);
model.strStepID = ObjectConvertClass.static_ext_string(dr["strStepID"]);
model.nIsNecessary = ObjectConvertClass.static_ext_int(dr["nIsNecessary"]);
//model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
//model.nStepIndex = ObjectConvertClass.static_ext_int(dr["nStepIndex"]);
//model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
//model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
}
/// <summary>
/// 添加数据
/// </summary>
public int Add(Plan_Beginwork_StepDef model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Plan_Beginwork_StepDef");
strSql.Append("(strWorkShopGUID,strWorkShopName,strStepName,strStepBrief,nStepIndex)");
strSql.Append("values(@strWorkShopGUID,@strWorkShopName,@strStepName,@strStepBrief,@nStepIndex)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID),
new SqlParameter("@strWorkShopName", model.strWorkShopName),
new SqlParameter("@strStepName", model.strStepName),
new SqlParameter("@strStepBrief", model.strStepBrief),
new SqlParameter("@nStepIndex", model.nStepIndex),
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)));
}
/// <summary>
/// 获得一个实体对象
/// </summary>
public Plan_Beginwork_StepDef GetModel(Plan_Beginwork_StepDefQueryCondition 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_Plan_Beginwork_StepDef where 1=1 " + strSqlOption.ToString());
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
Plan_Beginwork_StepDef _Plan_Beginwork_StepDef = null;
if (dt.Rows.Count > 0)
{
_Plan_Beginwork_StepDef = new Plan_Beginwork_StepDef();
DataRowToModel(_Plan_Beginwork_StepDef, dt.Rows[0]);
}
return(_Plan_Beginwork_StepDef);
}
/// <summary>
/// 更新数据
/// </summary>
public bool Update(Plan_Beginwork_StepDef model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update TAB_Plan_Beginwork_StepDef set ");
strSql.Append(" strWorkShopGUID = @strWorkShopGUID, ");
strSql.Append(" strWorkShopName = @strWorkShopName, ");
strSql.Append(" strStepName = @strStepName, ");
strSql.Append(" strStepBrief = @strStepBrief, ");
strSql.Append(" nStepIndex = @nStepIndex, ");
strSql.Append(" where nID = @nID ");
SqlParameter[] parameters =
{
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID),
new SqlParameter("@strWorkShopName", model.strWorkShopName),
new SqlParameter("@strStepName", model.strStepName),
new SqlParameter("@strStepBrief", model.strStepBrief),
new SqlParameter("@nStepIndex", model.nStepIndex),
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
