/// <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)); }