/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TSIMSServer.Model.t_time_set model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_time_set(");
strSql.Append("dept_head_start,dept_head_end,teacher_satrt,teacher_end,student_start,student_end)");
strSql.Append(" values (");
strSql.Append("@dept_head_start,@dept_head_end,@teacher_satrt,@teacher_end,@student_start,@student_end)");
MySqlParameter[] parameters =
{
new MySqlParameter("@dept_head_start", MySqlDbType.DateTime),
new MySqlParameter("@dept_head_end", MySqlDbType.DateTime),
new MySqlParameter("@teacher_satrt", MySqlDbType.DateTime),
new MySqlParameter("@teacher_end", MySqlDbType.DateTime),
new MySqlParameter("@student_start", MySqlDbType.DateTime),
new MySqlParameter("@student_end", MySqlDbType.DateTime)
};
parameters[0].Value = model.dept_head_start;
parameters[1].Value = model.dept_head_end;
parameters[2].Value = model.teacher_satrt;
parameters[3].Value = model.teacher_end;
parameters[4].Value = model.student_start;
parameters[5].Value = model.student_end;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TSIMSServer.Model.t_time_set model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_time_set set ");
strSql.Append("dept_head_start=@dept_head_start,");
strSql.Append("dept_head_end=@dept_head_end,");
strSql.Append("teacher_satrt=@teacher_satrt,");
strSql.Append("teacher_end=@teacher_end,");
strSql.Append("student_start=@student_start,");
strSql.Append("student_end=@student_end");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@dept_head_start", MySqlDbType.DateTime),
new MySqlParameter("@dept_head_end", MySqlDbType.DateTime),
new MySqlParameter("@teacher_satrt", MySqlDbType.DateTime),
new MySqlParameter("@teacher_end", MySqlDbType.DateTime),
new MySqlParameter("@student_start", MySqlDbType.DateTime),
new MySqlParameter("@student_end", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.dept_head_start;
parameters[1].Value = model.dept_head_end;
parameters[2].Value = model.teacher_satrt;
parameters[3].Value = model.teacher_end;
parameters[4].Value = model.student_start;
parameters[5].Value = model.student_end;
parameters[6].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TSIMSServer.Model.t_time_set DataRowToModel(DataRow row)
{
TSIMSServer.Model.t_time_set model = new TSIMSServer.Model.t_time_set();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["dept_head_start"] != null && row["dept_head_start"].ToString() != "")
{
model.dept_head_start = DateTime.Parse(row["dept_head_start"].ToString());
}
if (row["dept_head_end"] != null && row["dept_head_end"].ToString() != "")
{
model.dept_head_end = DateTime.Parse(row["dept_head_end"].ToString());
}
if (row["teacher_satrt"] != null && row["teacher_satrt"].ToString() != "")
{
model.teacher_satrt = DateTime.Parse(row["teacher_satrt"].ToString());
}
if (row["teacher_end"] != null && row["teacher_end"].ToString() != "")
{
model.teacher_end = DateTime.Parse(row["teacher_end"].ToString());
}
if (row["student_start"] != null && row["student_start"].ToString() != "")
{
model.student_start = DateTime.Parse(row["student_start"].ToString());
}
if (row["student_end"] != null && row["student_end"].ToString() != "")
{
model.student_end = DateTime.Parse(row["student_end"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TSIMSServer.Model.t_time_set GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,dept_head_start,dept_head_end,teacher_satrt,teacher_end,student_start,student_end from t_time_set ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
TSIMSServer.Model.t_time_set model = new TSIMSServer.Model.t_time_set();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
