/// <summary>
/// 批量删除数据
/// </summary>
/// <returns></returns>
public bool DeleteDataAll(string[] ids)
{
string errorMsg;
string deleteNom = "";
foreach (var id in ids)
{
deleteNom += "'" + id + "',";
}
if (deleteNom.Length > 0)
{
deleteNom = deleteNom.Substring(0, deleteNom.Length - 1);
}
SqliteAccess conn = new SqliteAccess(DBLink);
string str = string.Format("delete from MemberList_Static where id in ({0})", deleteNom);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除数据
/// </summary>
/// <returns></returns>
public bool DeleteDataAll(CommConf options, string[] ids)
{
string errorMsg;
string deleteNom = "";
foreach (var id in ids)
{
deleteNom += "'" + id + "',";
}
if (deleteNom.Length > 0)
{
deleteNom = deleteNom.Substring(0, deleteNom.Length - 1);
}
SqliteAccess conn = new SqliteAccess(options.AttriList.FirstOrDefault(o => o.key == "DBLink").value);
string str = string.Format("delete from QTStrategy where id in ({0})", deleteNom);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
public bool DeleteData(CommConf options, QTStrategyStru objstru)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(options.AttriList.FirstOrDefault(o => o.key == "DBLink").value);
string str = string.Format("delete from QTStrategy where id='{0}'", objstru.id);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 编辑数据
/// </summary>
/// <returns></returns>
public bool UpdateData(CommConf options, MemberList_DynamicStru objstru)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(options.AttriList.FirstOrDefault(o => o.key == "DBLink").value);
string str = string.Format("update MemberList_Dynamic set sex = '{0}', tel = '{1}', addr = '{2}', states = '{3}' where username='******'", objstru.sex, objstru.tel, objstru.addr, objstru.states, objstru.username);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增数据
/// </summary>
/// <returns></returns>
public bool AddData(CommConf options, MemberList_DynamicStru objstru)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(options.AttriList.FirstOrDefault(o => o.key == "DBLink").value);
string str = string.Format("insert into MemberList_Dynamic (username,sex,tel,addr,states) values('{0}','{1}','{2}','{3}','{4}')", objstru.username, objstru.sex, objstru.tel, objstru.addr, objstru.states);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
public bool DeleteData(MemberList_StaticStru objstru)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(DBLink);
string str = string.Format("delete from MemberList_Static where id='{0}'", objstru.ID);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 编辑数据
/// </summary>
/// <returns></returns>
public bool UpdateData(MemberList_StaticStru objstru)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(DBLink);
string str = string.Format("update MemberList_Static set sex = '{0}', tel = '{1}', addr = '{2}', states = '{3}' where username='******'", objstru.sex, objstru.tel, objstru.addr, objstru.states, objstru.username);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增数据
/// </summary>
/// <returns></returns>
public bool AddData(MemberList_StaticStru objstru)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(DBLink);
string str = string.Format("insert into MemberList_Static (username,sex,tel,addr,states) values('{0}','{1}','{2}','{3}','{4}')", objstru.username, objstru.sex, objstru.tel, objstru.addr, objstru.states);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增数据
/// 第一次新增时确定创建时间和路径，今后不可修改
/// </summary>
/// <returns></returns>
public bool AddData(CommConf options, QTStrategyStru objstru)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(options.AttriList.FirstOrDefault(o => o.key == "DBLink").value);
string str = string.Format("insert into QTStrategy (strategyname,strategynumber,strategyinfo,strategytype,strategypath,describe,states,remark,creattime,isrun) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')",
objstru.strategyname, objstru.strategynumber, Common.Verify.txt_html_n(objstru.strategyinfo), objstru.strategytype, objstru.strategypath, objstru.describe, objstru.states, objstru.remark, objstru.creattime, objstru.isrun);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 编辑数据
/// 不允许编辑创建时间和路径
/// </summary>
/// <returns></returns>
public bool UpdateData(CommConf options, QTStrategyStru objstru)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(options.AttriList.FirstOrDefault(o => o.key == "DBLink").value);
string str = string.Format("update QTStrategy set strategyname = '{0}', describe = '{1}', states = '{2}', remark = '{3}', strategyinfo = '{4}', strategytype = '{5}', isrun = '{6}' where strategynumber='{7}'",
objstru.strategyname, objstru.describe, objstru.states, objstru.remark, Common.Verify.txt_html_n(objstru.strategyinfo), objstru.strategytype, objstru.isrun, objstru.strategynumber);
int count = conn.Execute(str, out errorMsg);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
