/// <summary>
/// 添加计划执行记录表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int AddProJectList(dynamic data)
{
Entity.projectlist t = p.Value.SetData(data);
string sql = "insert into projectlist values(" + t.t_id + "," + t.create_time + "," + t.work_time + ",'" + t.project_body + "'," +
"" + t.work_usid + ",'" + t.l_desc + "'," + t.l_us_id + ",'" + t.work_length + "')";
return(help.Count(sql));
}
/// <summary>
/// 添加培训计划
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int Add(dynamic data)
{
Entity.projectlist t = p.Value.SetData(data);
string sql = "insert into train_project values('" + t.t_name + "'," + t.start_time + "," + t.end_time + ",'" + t.score_name + "'," +
"'" + t.b_id + "'," + t.c_id + "," + t.head_id + "," + t.com_id + "," + t.time_length + ",'" + t.score_type + "','" + t.descs + "'," + t.create_time + "," +
"" + t.us_id + "," + t.work_usid + ")";
return(help.Count(sql));
}
/// <summary>
/// 修改培训计划信息
/// </summary>
/// <param name="data"></param>
/// <param name="t_id"></param>
/// <returns></returns>
public int Update(dynamic data, int t_id)
{
Entity.projectlist t = p.Value.SetData(data);
string sql = "update train_project set t_name='" + t.t_name + "',start_time=" + t.start_time + ",end_time=" + t.end_time + "," +
"score_name='" + t.score_name + "'," +
"head_id=" + t.head_id + ",com_id=" + t.com_id + ",b_id='" + t.b_id + "',c_id=" + t.c_id + ",time_length=" + t.time_length + "," +
"score_type='" + t.score_type + "',descs='" + t.descs + "',create_time=" + t.create_time + "," +
"work_usid=" + t.work_usid + ",us_id=" + t.us_id + " where t_id=" + t_id;
return(help.Count(sql));
}
