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