/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Eday.Model.ISOTrain_Relation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ISOTrain_Relation set ");
strSql.Append("ID=@ID,");
strSql.Append("code=@code,");
strSql.Append("name=@name,");
strSql.Append("ModuleCode=@ModuleCode,");
strSql.Append("Description=@Description,");
strSql.Append("CourseCode=@CourseCode,");
strSql.Append("CourseTitleDescription=@CourseTitleDescription,");
strSql.Append("TaskLevel=@TaskLevel,");
strSql.Append("NotifyDays=@NotifyDays,");
strSql.Append("NeedRetraining=@NeedRetraining,");
strSql.Append("Frequency=@Frequency");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 50),
new SqlParameter("@code", SqlDbType.NVarChar, 50),
new SqlParameter("@name", SqlDbType.NVarChar, 200),
new SqlParameter("@ModuleCode", SqlDbType.NVarChar, 50),
new SqlParameter("@Description", SqlDbType.NVarChar, 500),
new SqlParameter("@CourseCode", SqlDbType.NVarChar, 50),
new SqlParameter("@CourseTitleDescription", SqlDbType.NVarChar, -1),
new SqlParameter("@TaskLevel", SqlDbType.NVarChar, 50),
new SqlParameter("@NotifyDays", SqlDbType.NVarChar, 50),
new SqlParameter("@NeedRetraining", SqlDbType.NVarChar, 50),
new SqlParameter("@Frequency", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.code;
parameters[2].Value = model.name;
parameters[3].Value = model.ModuleCode;
parameters[4].Value = model.Description;
parameters[5].Value = model.CourseCode;
parameters[6].Value = model.CourseTitleDescription;
parameters[7].Value = model.TaskLevel;
parameters[8].Value = model.NotifyDays;
parameters[9].Value = model.NeedRetraining;
parameters[10].Value = model.Frequency;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eday.Model.ISOTrain_Relation DataRowToModel(DataRow row)
{
Eday.Model.ISOTrain_Relation model = new Eday.Model.ISOTrain_Relation();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["code"] != null)
{
model.code = row["code"].ToString();
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["ModuleCode"] != null)
{
model.ModuleCode = row["ModuleCode"].ToString();
}
if (row["Description"] != null)
{
model.Description = row["Description"].ToString();
}
if (row["CourseCode"] != null)
{
model.CourseCode = row["CourseCode"].ToString();
}
if (row["CourseTitleDescription"] != null)
{
model.CourseTitleDescription = row["CourseTitleDescription"].ToString();
}
if (row["TaskLevel"] != null)
{
model.TaskLevel = row["TaskLevel"].ToString();
}
if (row["NotifyDays"] != null)
{
model.NotifyDays = row["NotifyDays"].ToString();
}
if (row["NeedRetraining"] != null)
{
model.NeedRetraining = row["NeedRetraining"].ToString();
}
if (row["Frequency"] != null)
{
model.Frequency = row["Frequency"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Eday.Model.ISOTrain_Relation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ISOTrain_Relation(");
strSql.Append("ID,code,name,ModuleCode,Description,CourseCode,CourseTitleDescription,TaskLevel,NotifyDays,NeedRetraining,Frequency)");
strSql.Append(" values (");
strSql.Append("@ID,@code,@name,@ModuleCode,@Description,@CourseCode,@CourseTitleDescription,@TaskLevel,@NotifyDays,@NeedRetraining,@Frequency)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 50),
new SqlParameter("@code", SqlDbType.NVarChar, 50),
new SqlParameter("@name", SqlDbType.NVarChar, 200),
new SqlParameter("@ModuleCode", SqlDbType.NVarChar, 50),
new SqlParameter("@Description", SqlDbType.NVarChar, 500),
new SqlParameter("@CourseCode", SqlDbType.NVarChar, 50),
new SqlParameter("@CourseTitleDescription", SqlDbType.NVarChar, -1),
new SqlParameter("@TaskLevel", SqlDbType.NVarChar, 50),
new SqlParameter("@NotifyDays", SqlDbType.NVarChar, 50),
new SqlParameter("@NeedRetraining", SqlDbType.NVarChar, 50),
new SqlParameter("@Frequency", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.code;
parameters[2].Value = model.name;
parameters[3].Value = model.ModuleCode;
parameters[4].Value = model.Description;
parameters[5].Value = model.CourseCode;
parameters[6].Value = model.CourseTitleDescription;
parameters[7].Value = model.TaskLevel;
parameters[8].Value = model.NotifyDays;
parameters[9].Value = model.NeedRetraining;
parameters[10].Value = model.Frequency;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eday.Model.ISOTrain_Relation GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,code,name,ModuleCode,Description,CourseCode,CourseTitleDescription,TaskLevel,NotifyDays,NeedRetraining,Frequency from ISOTrain_Relation ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Eday.Model.ISOTrain_Relation model = new Eday.Model.ISOTrain_Relation();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
