/// <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>
/// <param name="options"></param>
/// <param name="filepath"></param>
/// <param name="id"></param>
/// <returns></returns>
public string RunScript(CommConf options, string wwwrootpath, string id)
{
try
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(options.AttriList.FirstOrDefault(o => o.key == "DBLink").value);
string strsql = string.Format(@"select * from QTStrategy where id = {0}", id);
DataTable dt = conn.QueryDt(strsql, out errorMsg);
QTStrategyStru obj = new QTStrategyStru();
foreach (DataRow item in dt.Rows)
{
obj.strategyname = item["strategyname"].ToString();
obj.strategynumber = item["strategynumber"].ToString();
obj.strategypath = item["strategypath"].ToString();
obj.strategyinfo = item["strategyinfo"].ToString();
}
Dictionary <string, string> paralist = new Dictionary <string, string>();
string context = Common.Verify.html_txt_n(obj.strategyinfo);
//所在文件夹路径
string scriptpath = Path.Combine(wwwrootpath, options.AttriList.FirstOrDefault(o => o.key == "ScriptPath").value, obj.strategypath);
//脚本完整路径
string path = Path.Combine(scriptpath, obj.strategyname) + ".py";
lock (Lock)
{
Common.FileHelper.TxtHelper.Write_txt(scriptpath, obj.strategyname + ".py", context);
return(Common.CallPython.RunFile(path, paralist));
}
}
catch (Exception e)
{
return(e.ToString());
}
}
/// <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 List <QTStrategyStru> GetData(CommConf options, Dictionary <string, string> Para, ref string count)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(options.AttriList.FirstOrDefault(o => o.key == "DBLink").value);
bool ispara = false;
//拼接sql查询条件
string strPara = " where 1=1 and ";
foreach (var item in Para)
{
if (!string.IsNullOrEmpty(item.Value) && item.Key != "page" && item.Key != "limit")
{
strPara += item.Key + "='" + item.Value + "' and ";
ispara = true;
}
}
strPara = strPara.Substring(0, strPara.Length - 4);
string strsql = string.Format(@"select * from(select * from (select * from QTStrategy {0} order by id asc limit {1})
order by id desc limit {2}) order by id asc", strPara, int.Parse(Para["page"]) * int.Parse(Para["limit"]), Para["limit"]);
DataTable dt = conn.QueryDt(strsql, out errorMsg);
QTStrategyStru obj = new QTStrategyStru();
List <QTStrategyStru> DataList = new List <QTStrategyStru>();
foreach (DataRow item in dt.Rows)
{
obj = new QTStrategyStru();
obj.id = int.Parse(item["id"].ToString());
obj.strategyname = item["strategyname"].ToString();
obj.strategynumber = item["strategynumber"].ToString();
obj.strategypath = item["strategypath"].ToString();
obj.creattime = item["creattime"].ToString();
obj.describe = item["describe"].ToString();
obj.remark = item["remark"].ToString();
obj.states = item["states"].ToString();
obj.isrun = item["isrun"].ToString();
//obj.strategyinfo = Common.Verify.html_txt_n(item["strategyinfo"].ToString());
obj.strategyinfo = item["strategyinfo"].ToString();
obj.strategytype = item["strategytype"].ToString();
DataList.Add(obj);
}
//是否是条件查询，统计条数
if (ispara == false)
{
strsql = "select count(*) from QTStrategy";
}
else
{
strsql = string.Format(@"select count(*) from QTStrategy {0}", strPara);
}
DataTable dtcount = conn.QueryDt(strsql, out errorMsg);
count = dtcount.Rows[0][0].ToString();
return(DataList);
}
/// <summary>
/// 查询数据
/// </summary>
/// <returns></returns>
public List <MemberList_DynamicStru> GetData(CommConf options, Dictionary <string, string> Para, ref string count)
{
string errorMsg;
SqliteAccess conn = new SqliteAccess(options.AttriList.FirstOrDefault(o => o.key == "DBLink").value);
bool ispara = false;
//拼接sql查询条件
string strPara = " where 1=1 and ";
foreach (var item in Para)
{
if (!string.IsNullOrEmpty(item.Value) && item.Key != "page" && item.Key != "limit")
{
strPara += item.Key + "='" + item.Value + "' and ";
ispara = true;
}
}
strPara = strPara.Substring(0, strPara.Length - 4);
string strsql = string.Format(@"select * from(select * from (select * from MemberList_Dynamic {0} order by id asc limit {1})
order by id desc limit {2}) order by id asc", strPara, int.Parse(Para["page"]) * int.Parse(Para["limit"]), Para["limit"]);
DataTable dt = conn.QueryDt(strsql, out errorMsg);
MemberList_DynamicStru obj = new MemberList_DynamicStru();
List <MemberList_DynamicStru> DataList = new List <MemberList_DynamicStru>();
foreach (DataRow item in dt.Rows)
{
obj = new MemberList_DynamicStru();
obj.id = int.Parse(item["id"].ToString());
obj.username = item["username"].ToString();
obj.sex = item["sex"].ToString();
obj.tel = item["tel"].ToString();
obj.addr = item["addr"].ToString();
obj.states = item["states"].ToString();
DataList.Add(obj);
}
//是否是条件查询，统计条数
if (ispara == false)
{
strsql = "select count(*) from MemberList_Dynamic";
}
else
{
strsql = string.Format(@"select count(*) from MemberList_Dynamic {0}", strPara);
}
DataTable dtcount = conn.QueryDt(strsql, out errorMsg);
count = dtcount.Rows[0][0].ToString();
return(DataList);
}
/// <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);
}
}
/// <summary>
/// 查询数据
/// </summary>
/// <returns></returns>
public List <MemberList_StaticStru> GetDate(CommConf options)
{
string errorMsg;
DBLink = options.AttriList.FirstOrDefault(o => o.key == "DBLink").value;
SqliteAccess conn = new SqliteAccess(DBLink);
DataTable dt = conn.QueryDt("select * from MemberList_Static order by ID", out errorMsg);
MemberList_StaticStru obj = new MemberList_StaticStru();
dataInfoList = new List <MemberList_StaticStru>();
foreach (DataRow item in dt.Rows)
{
obj = new MemberList_StaticStru();
obj.ID = int.Parse(item["id"].ToString());
obj.username = item["username"].ToString();
obj.sex = item["sex"].ToString();
obj.tel = item["tel"].ToString();
obj.addr = item["addr"].ToString();
obj.states = item["states"].ToString();
dataInfoList.Add(obj);
}
return(dataInfoList);
}
/// <summary>
/// 搜索
/// </summary>
/// <param name="options"></param>
/// <returns></returns>
public List <MemberList_StaticStru> GetDateSreach(CommConf options, ref Dictionary <string, string> sqlDic)
{
string errorMsg;
DBLink = options.AttriList.FirstOrDefault(o => o.key == "DBLink").value;
SqliteAccess conn = new SqliteAccess(DBLink);
string sql = string.Format("select * from MemberList_Static {0} order by ID asc", CommonMethod.SqlStrWithTime(sqlDic));
DataTable dt = conn.QueryDt(sql, out errorMsg);
MemberList_StaticStru obj = new MemberList_StaticStru();
dataInfoList = new List <MemberList_StaticStru>();
foreach (DataRow item in dt.Rows)
{
obj = new MemberList_StaticStru();
obj.ID = int.Parse(item["id"].ToString());
obj.username = item["username"].ToString();
obj.sex = item["sex"].ToString();
obj.tel = item["tel"].ToString();
obj.addr = item["addr"].ToString();
obj.states = item["states"].ToString();
dataInfoList.Add(obj);
}
return(dataInfoList);
}
