/// <summary>
/// 保存更新项目
/// </summary>
/// <param name="project"></param>
/// <returns></returns>
public static bool UpdateProject(Proj_Main project)
{
string addSql = @"update Proj_Main set name=:name,
description=:description ,
group_id=:group_id ,
logintype=:logintype,
loginpageinfo=:loginpageinfo,
detailgrabtype=:detailgrabtype,
detailgrabinfo=:detailgrabinfo,
programaftergraball=:programaftergraball,
programexternalrun=:programexternalrun
where id=:id";
Dictionary <string, object> p2vs = new Dictionary <string, object>();
p2vs.Add("id", project.Id);
p2vs.Add("name", project.Name);
p2vs.Add("description", project.Description);
p2vs.Add("group_id", project.Group_Id);
p2vs.Add("logintype", project.LoginType);
p2vs.Add("loginpageinfo", project.LoginPageInfo);
p2vs.Add("detailgrabtype", project.DetailGrabType);
p2vs.Add("detailgrabinfo", project.DetailGrabInfo);
p2vs.Add("programaftergraball", project.ProgramAfterGrabAll);
p2vs.Add("programexternalrun", project.ProgramExternalRun);
return(SqliteHelper.MainDbHelper.ExecuteSql(addSql, p2vs));
}
/// <summary>
/// 根据Id获取项目
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Proj_Main GetProjectInfoByIdFromDB(string id)
{
string sql = @"select p.id as id,
p.name as name,
p.description as description,
p.group_id as group_id,
p.logintype as logintype,
p.loginpageinfo as loginpageinfo,
p.detailgrabtype as detailgrabtype,
p.detailgrabinfo as detailgrabinfo,
p.programaftergraball as programaftergraball,
p.programexternalrun as programexternalrun from Proj_Main p where p.isdeleted = 'N' and p.id = :id";
Dictionary <string, object> p2vs = new Dictionary <string, object>();
p2vs.Add("id", id);
DataTable dt = null;
try
{
dt = SqliteHelper.MainDbHelper.GetDataTable(sql, p2vs);
}
catch (Exception ex)
{
CommonUtil.Alert("错误提示", "无法获取项目信息. Id = " + id + "\r\n" + ex.Message);
}
if (dt != null)
{
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
Proj_Main p = new Proj_Main();
p.Id = (string)row["id"];
p.Name = (string)row["name"];
p.Description = (string)row["description"];
p.Group_Id = (string)row["group_id"];
p.LoginType = (LoginLevelType)Enum.Parse(typeof(LoginLevelType), (string)row["logintype"]);
p.LoginPageInfo = (string)row["loginpageinfo"];
p.DetailGrabType = (DetailGrabType)Enum.Parse(typeof(DetailGrabType), (string)row["detailgrabtype"]);
p.DetailGrabInfo = (string)row["detailgrabinfo"];
p.ProgramAfterGrabAll = (string)row["programaftergraball"];
p.ProgramExternalRun = (string)row["programexternalrun"];
return(p);
}
}
return(null);
}
/// <summary>
/// 获取所有项目
/// </summary>
/// <returns></returns>
public static List <Proj_Main> GetAllProjectsFromDB()
{
string sql = @"select p.id as id,
p.name as name,
p.description as description,
p.group_id as group_id,
p.logintype as logintype,
p.loginpageinfo as loginpageinfo,
p.detailgrabtype as detailgrabtype,
p.detailgrabinfo as detailgrabinfo,
p.programaftergraball as programaftergraball,
p.programexternalrun as programexternalrun from Proj_Main p where p.isdeleted = 'N' order by p.name";
DataTable dt = null;
try
{
dt = SqliteHelper.MainDbHelper.GetDataTable(sql, null);
}
catch (Exception ex)
{
CommonUtil.Alert("错误提示", "无法获取项目信息. \r\n" + ex.Message);
}
if (dt != null)
{
List <Proj_Main> allProjects = new List <Proj_Main>();
foreach (DataRow row in dt.Rows)
{
Proj_Main p = new Proj_Main();
p.Id = (string)row["id"];
p.Name = (string)row["name"];
p.Description = (string)row["description"];
p.Group_Id = (string)row["group_id"];
p.LoginType = (LoginLevelType)Enum.Parse(typeof(LoginLevelType), (string)row["logintype"]);
p.LoginPageInfo = (string)row["loginpageinfo"];
p.DetailGrabType = (DetailGrabType)Enum.Parse(typeof(DetailGrabType), (string)row["detailgrabtype"]);
p.DetailGrabInfo = (string)row["detailgrabinfo"];
p.ProgramAfterGrabAll = (string)row["programaftergraball"];
p.ProgramExternalRun = (string)row["programexternalrun"];
allProjects.Add(p);
}
return(allProjects);
}
return(null);
}
/// <summary>
/// 添加项目
/// </summary>
/// <param name="project"></param>
/// <returns></returns>
public static string AddNewProject(Proj_Main newProject)
{
string id = Guid.NewGuid().ToString();
string addSql = @"insert into Proj_Main(id,
name,
description ,
group_id,
logintype,
loginpageinfo,
detailgrabtype,
detailgrabinfo,
programaftergraball,
programexternalrun)
values(:id,
:name,
:description ,
:group_id,
:logintype,
:loginpageinfo,
:detailgrabtype,
:detailgrabinfo,
:programaftergraball,
:programexternalrun)";
Dictionary <string, object> p2vs = new Dictionary <string, object>();
p2vs.Add("id", id);
p2vs.Add("name", newProject.Name);
p2vs.Add("description", newProject.Description);
p2vs.Add("group_id", newProject.Group_Id);
p2vs.Add("logintype", newProject.LoginType);
p2vs.Add("loginpageinfo", newProject.LoginPageInfo);
p2vs.Add("detailgrabtype", newProject.DetailGrabType);
p2vs.Add("detailgrabinfo", newProject.DetailGrabInfo);
p2vs.Add("programaftergraball", newProject.ProgramAfterGrabAll);
p2vs.Add("programexternalrun", newProject.ProgramExternalRun);
if (SqliteHelper.MainDbHelper.ExecuteSql(addSql, p2vs))
{
return(id);
}
else
{
return(null);
}
}