public void DeleteBysid(int sid) { string sql = string.Format("delete from sys_Treeview where sid={0}", sid); DbHelperSQLite.ExecuteSql(sql); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("Id", "UserInfo")); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Hd model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Inv_Rcv_Bill_Hd("); strSql.Append("Id,RcvType,RcvUserId,RcvUserName,RcvPhone,RcvDateTime,RcvReason,RcvAddress,RentSubject,RentUserId,RentUserName,RentPhone,RrcBillId,PlanRtnDateTime,ActualRtnDateTime,BillStatus,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId)"); strSql.Append(" values ("); strSql.Append("@Id,@RcvType,@RcvUserId,@RcvUserName,@RcvPhone,@RcvDateTime,@RcvReason,@RcvAddress,@RentSubject,@RentUserId,@RentUserName,@RentPhone,@RrcBillId,@PlanRtnDateTime,@ActualRtnDateTime,@BillStatus,@DateTimeCreated,@UserCreator,@DateTimeModified,@UserModified,@State,@OrgId)"); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 4), new SQLiteParameter("@RcvType", DbType.String, 0), new SQLiteParameter("@RcvUserId", DbType.Int32, 4), new SQLiteParameter("@RcvUserName", DbType.String, 0), new SQLiteParameter("@RcvPhone", DbType.String, 0), new SQLiteParameter("@RcvDateTime", DbType.Date), new SQLiteParameter("@RcvReason", DbType.String, 0), new SQLiteParameter("@RcvAddress", DbType.String, 0), new SQLiteParameter("@RentSubject", DbType.String, 0), new SQLiteParameter("@RentUserId", DbType.String, 0), new SQLiteParameter("@RentUserName", DbType.String, 0), new SQLiteParameter("@RentPhone", DbType.String, 0), new SQLiteParameter("@RrcBillId", DbType.Int32, 4), new SQLiteParameter("@PlanRtnDateTime", DbType.Date), new SQLiteParameter("@ActualRtnDateTime", DbType.Date), new SQLiteParameter("@BillStatus", DbType.String, 0), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1), new SQLiteParameter("@OrgId", DbType.String, 0) }; parameters[0].Value = model.Id; parameters[1].Value = model.RcvType; parameters[2].Value = model.RcvUserId; parameters[3].Value = model.RcvUserName; parameters[4].Value = model.RcvPhone; parameters[5].Value = model.RcvDateTime; parameters[6].Value = model.RcvReason; parameters[7].Value = model.RcvAddress; parameters[8].Value = model.RentSubject; parameters[9].Value = model.RentUserId; parameters[10].Value = model.RentUserName; parameters[11].Value = model.RentPhone; parameters[12].Value = model.RrcBillId; parameters[13].Value = model.PlanRtnDateTime; parameters[14].Value = model.ActualRtnDateTime; parameters[15].Value = model.BillStatus; parameters[16].Value = model.DateTimeCreated; parameters[17].Value = model.UserCreator; parameters[18].Value = model.DateTimeModified; parameters[19].Value = model.UserModified; parameters[20].Value = model.State; parameters[21].Value = model.OrgId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PlayMediaInfo set "); strSql.Append("PlayMediaName=@PlayMediaName,"); strSql.Append("PlayReaderID=@PlayReaderID,"); strSql.Append("PlayLoop=@PlayLoop,"); strSql.Append("PlayType1=@PlayType1,"); strSql.Append("PlayMediaGroupID1=@PlayMediaGroupID1,"); strSql.Append("STime1=@STime1,"); strSql.Append("ETime1=@ETime1,"); strSql.Append("PlayType2=@PlayType2,"); strSql.Append("PlayMediaGroupID2=@PlayMediaGroupID2,"); strSql.Append("STime2=@STime2,"); strSql.Append("ETime2=@ETime2,"); strSql.Append("PlayType3=@PlayType3,"); strSql.Append("PlayMediaGroupID3=@PlayMediaGroupID3,"); strSql.Append("STime3=@STime3,"); strSql.Append("ETime3=@ETime3,"); strSql.Append("PlayType4=@PlayType4,"); strSql.Append("PlayMediaGroupID4=@PlayMediaGroupID4,"); strSql.Append("STime4=@STime4,"); strSql.Append("ETime4=@ETime4,"); strSql.Append("PlayType5=@PlayType5,"); strSql.Append("PlayMediaGroupID5=@PlayMediaGroupID5,"); strSql.Append("STime5=@STime5,"); strSql.Append("ETime5=@ETime5,"); strSql.Append("PlayType6=@PlayType6,"); strSql.Append("PlayMediaGroupID6=@PlayMediaGroupID6,"); strSql.Append("STime6=@STime6,"); strSql.Append("ETime6=@ETime6"); strSql.Append(" where PlayMediaID=@PlayMediaID "); SQLiteParameter[] parameters = { new SQLiteParameter("@PlayMediaName", DbType.String), new SQLiteParameter("@PlayReaderID", DbType.Int32, 4), new SQLiteParameter("@PlayLoop", DbType.Boolean, 1), new SQLiteParameter("@PlayType1", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID1", DbType.Int32, 4), new SQLiteParameter("@STime1", DbType.String), new SQLiteParameter("@ETime1", DbType.String), new SQLiteParameter("@PlayType2", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID2", DbType.Int32, 4), new SQLiteParameter("@STime2", DbType.String), new SQLiteParameter("@ETime2", DbType.String), new SQLiteParameter("@PlayType3", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID3", DbType.Int32, 4), new SQLiteParameter("@STime3", DbType.String), new SQLiteParameter("@ETime3", DbType.String), new SQLiteParameter("@PlayType4", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID4", DbType.Int32, 4), new SQLiteParameter("@STime4", DbType.String), new SQLiteParameter("@ETime4", DbType.String), new SQLiteParameter("@PlayType5", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID5", DbType.Int32, 4), new SQLiteParameter("@STime5", DbType.String), new SQLiteParameter("@ETime5", DbType.String), new SQLiteParameter("@PlayType6", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID6", DbType.Int32, 4), new SQLiteParameter("@STime6", DbType.String), new SQLiteParameter("@ETime6", DbType.String), new SQLiteParameter("@PlayMediaID", DbType.Int32, 4) }; parameters[0].Value = model.PlayMediaName; parameters[1].Value = model.PlayReaderID; parameters[2].Value = model.PlayLoop; parameters[3].Value = model.PlayType1; parameters[4].Value = model.PlayMediaGroupID1; parameters[5].Value = model.STime1; parameters[6].Value = model.ETime1; parameters[7].Value = model.PlayType2; parameters[8].Value = model.PlayMediaGroupID2; parameters[9].Value = model.STime2; parameters[10].Value = model.ETime2; parameters[11].Value = model.PlayType3; parameters[12].Value = model.PlayMediaGroupID3; parameters[13].Value = model.STime3; parameters[14].Value = model.ETime3; parameters[15].Value = model.PlayType4; parameters[16].Value = model.PlayMediaGroupID4; parameters[17].Value = model.STime4; parameters[18].Value = model.ETime4; parameters[19].Value = model.PlayType5; parameters[20].Value = model.PlayMediaGroupID5; parameters[21].Value = model.STime5; parameters[22].Value = model.ETime5; parameters[23].Value = model.PlayType6; parameters[24].Value = model.PlayMediaGroupID6; parameters[25].Value = model.STime6; parameters[26].Value = model.ETime6; parameters[27].Value = model.PlayMediaID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PlayMediaInfo("); strSql.Append("PlayMediaID,PlayMediaName,PlayReaderID,PlayLoop,PlayType1,PlayMediaGroupID1,STime1,ETime1,PlayType2,PlayMediaGroupID2,STime2,ETime2,PlayType3,PlayMediaGroupID3,STime3,ETime3,PlayType4,PlayMediaGroupID4,STime4,ETime4,PlayType5,PlayMediaGroupID5,STime5,ETime5,PlayType6,PlayMediaGroupID6,STime6,ETime6)"); strSql.Append(" values ("); strSql.Append("@PlayMediaID,@PlayMediaName,@PlayReaderID,@PlayLoop,@PlayType1,@PlayMediaGroupID1,@STime1,@ETime1,@PlayType2,@PlayMediaGroupID2,@STime2,@ETime2,@PlayType3,@PlayMediaGroupID3,@STime3,@ETime3,@PlayType4,@PlayMediaGroupID4,@STime4,@ETime4,@PlayType5,@PlayMediaGroupID5,@STime5,@ETime5,@PlayType6,@PlayMediaGroupID6,@STime6,@ETime6)"); SQLiteParameter[] parameters = { new SQLiteParameter("@PlayMediaID", DbType.Int32, 4), new SQLiteParameter("@PlayMediaName", DbType.String), new SQLiteParameter("@PlayReaderID", DbType.Int32, 4), new SQLiteParameter("@PlayLoop", DbType.Boolean, 1), new SQLiteParameter("@PlayType1", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID1", DbType.Int32, 4), new SQLiteParameter("@STime1", DbType.String), new SQLiteParameter("@ETime1", DbType.String), new SQLiteParameter("@PlayType2", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID2", DbType.Int32, 4), new SQLiteParameter("@STime2", DbType.String), new SQLiteParameter("@ETime2", DbType.String), new SQLiteParameter("@PlayType3", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID3", DbType.Int32, 4), new SQLiteParameter("@STime3", DbType.String), new SQLiteParameter("@ETime3", DbType.String), new SQLiteParameter("@PlayType4", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID4", DbType.Int32, 4), new SQLiteParameter("@STime4", DbType.String), new SQLiteParameter("@ETime4", DbType.String), new SQLiteParameter("@PlayType5", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID5", DbType.Int32, 4), new SQLiteParameter("@STime5", DbType.String), new SQLiteParameter("@ETime5", DbType.String), new SQLiteParameter("@PlayType6", DbType.Int32, 4), new SQLiteParameter("@PlayMediaGroupID6", DbType.Int32, 4), new SQLiteParameter("@STime6", DbType.String), new SQLiteParameter("@ETime6", DbType.String) }; parameters[0].Value = model.PlayMediaID; parameters[1].Value = model.PlayMediaName; parameters[2].Value = model.PlayReaderID; parameters[3].Value = model.PlayLoop; parameters[4].Value = model.PlayType1; parameters[5].Value = model.PlayMediaGroupID1; parameters[6].Value = model.STime1; parameters[7].Value = model.ETime1; parameters[8].Value = model.PlayType2; parameters[9].Value = model.PlayMediaGroupID2; parameters[10].Value = model.STime2; parameters[11].Value = model.ETime2; parameters[12].Value = model.PlayType3; parameters[13].Value = model.PlayMediaGroupID3; parameters[14].Value = model.STime3; parameters[15].Value = model.ETime3; parameters[16].Value = model.PlayType4; parameters[17].Value = model.PlayMediaGroupID4; parameters[18].Value = model.STime4; parameters[19].Value = model.ETime4; parameters[20].Value = model.PlayType5; parameters[21].Value = model.PlayMediaGroupID5; parameters[22].Value = model.STime5; parameters[23].Value = model.ETime5; parameters[24].Value = model.PlayType6; parameters[25].Value = model.PlayMediaGroupID6; parameters[26].Value = model.STime6; parameters[27].Value = model.ETime6; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void Insert(string sql) { DbHelperSQLite.ExecuteSql(sql); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("ManagerID", "Manager")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DXD.Model.business_report model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update business_report set "); strSql.Append("query_id=@query_id,"); strSql.Append("bus_name=@bus_name,"); strSql.Append("scope=@scope,"); strSql.Append("reg_no=@reg_no,"); strSql.Append("bus_type=@bus_type,"); strSql.Append("reg_capital=@reg_capital,"); strSql.Append("subscribe=@subscribe,"); strSql.Append("proportion=@proportion,"); strSql.Append("status=@status,"); strSql.Append("paid_in=@paid_in,"); strSql.Append("found_date=@found_date,"); strSql.Append("lost_date=@lost_date,"); strSql.Append("office=@office,"); strSql.Append("remark=@remark,"); strSql.Append("add_user=@add_user,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SQLiteParameter[] parameters = { new SQLiteParameter("@query_id", DbType.Int32, 8), new SQLiteParameter("@bus_name", DbType.String, 255), new SQLiteParameter("@scope", DbType.String), new SQLiteParameter("@reg_no", DbType.String, 50), new SQLiteParameter("@bus_type", DbType.String, 50), new SQLiteParameter("@reg_capital", DbType.Decimal, 4), new SQLiteParameter("@subscribe", DbType.Decimal, 4), new SQLiteParameter("@proportion", DbType.Decimal, 4), new SQLiteParameter("@status", DbType.char, 10), new SQLiteParameter("@paid_in", DbType.Decimal, 4), new SQLiteParameter("@found_date", DbType.DateTime), new SQLiteParameter("@lost_date", DbType.DateTime), new SQLiteParameter("@office", DbType.String, 50), new SQLiteParameter("@remark", DbType.String, 255), new SQLiteParameter("@add_user", DbType.String, 50), new SQLiteParameter("@add_time", DbType.DateTime), new SQLiteParameter("@id", DbType.Int32, 8) }; parameters[0].Value = model.query_id; parameters[1].Value = model.bus_name; parameters[2].Value = model.scope; parameters[3].Value = model.reg_no; parameters[4].Value = model.bus_type; parameters[5].Value = model.reg_capital; parameters[6].Value = model.subscribe; parameters[7].Value = model.proportion; parameters[8].Value = model.status; parameters[9].Value = model.paid_in; parameters[10].Value = model.found_date; parameters[11].Value = model.lost_date; parameters[12].Value = model.office; parameters[13].Value = model.remark; parameters[14].Value = model.add_user; parameters[15].Value = model.add_time; parameters[16].Value = model.id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("id", "business_report")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("ID", "Article")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("Lid", "Log")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("InterLockID", "InterLock")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("Gid", "Shangpin")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("ID", "User")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DXD.Model.query_list model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update query_list set "); strSql.Append("query_title=@query_title,"); strSql.Append("batch=@batch,"); strSql.Append("client=@client,"); strSql.Append("query_type=@query_type,"); strSql.Append("entrust_date=@entrust_date,"); strSql.Append("is_import=@is_import,"); strSql.Append("feedback_passport=@feedback_passport,"); strSql.Append("feedback_leave=@feedback_leave,"); strSql.Append("feedback_house1=@feedback_house1,"); strSql.Append("feedback_house2=@feedback_house2,"); strSql.Append("feedback_security=@feedback_security,"); strSql.Append("feedback_insurance=@feedback_insurance,"); strSql.Append("feedback_business=@feedback_business,"); strSql.Append("add_user=@add_user,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SQLiteParameter[] parameters = { new SQLiteParameter("@query_title", DbType.String, 255), new SQLiteParameter("@batch", DbType.String, 50), new SQLiteParameter("@client", DbType.String, 200), new SQLiteParameter("@query_type", DbType.String, 4), new SQLiteParameter("@entrust_date", DbType.DateTime), new SQLiteParameter("@is_import", DbType.Boolean), new SQLiteParameter("@feedback_passport", DbType.Boolean), new SQLiteParameter("@feedback_leave", DbType.Boolean), new SQLiteParameter("@feedback_house1", DbType.Boolean), new SQLiteParameter("@feedback_house2", DbType.Boolean), new SQLiteParameter("@feedback_security", DbType.Boolean), new SQLiteParameter("@feedback_insurance", DbType.Boolean), new SQLiteParameter("@feedback_business", DbType.Boolean), new SQLiteParameter("@add_user", DbType.String, 50), new SQLiteParameter("@add_time", DbType.DateTime), new SQLiteParameter("@id", DbType.Int32, 8) }; parameters[0].Value = model.query_title; parameters[1].Value = model.batch; parameters[2].Value = model.client; parameters[3].Value = model.query_type; parameters[4].Value = model.entrust_date; parameters[5].Value = model.is_import; parameters[6].Value = model.feedback_passport; parameters[7].Value = model.feedback_leave; parameters[8].Value = model.feedback_house1; parameters[9].Value = model.feedback_house2; parameters[10].Value = model.feedback_security; parameters[11].Value = model.feedback_insurance; parameters[12].Value = model.feedback_business; parameters[13].Value = model.add_user; parameters[14].Value = model.add_time; parameters[15].Value = model.id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void setApacheConf(string domain, string domain2, string webindex, string port, string path, int https) { string rewrite = this.textBox5.Text; string gzip = checkBox2.Checked ? @" <IfModule deflate_module> SetOutputFilter DEFLATE DeflateCompressionLevel 6 AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript AddOutputFilter DEFLATE css|js|txt|xml|rss|html|htm Header append Vary User-Agent env=!dont-vary SetEnvIfNoCase Request_URI .(?:gif|jpe?g|png|bmp|tif|ico|eot|svg|ttf|woff)$ no-gzip dont-vary SetEnvIfNoCase Request_URI .(?:exe|t?gz|zip|7z|bz2|sit|rar|bin|iso)$ no-gzip dont-vary SetEnvIfNoCase Request_URI .(?:pdf|doc|docx|xls|xlsx|ppt|pptx)$ no-gzip dont-vary SetEnvIfNoCase Request_URI .(?:mov|flv|avi|mp3|mp4|rm|webm|ogv)$ no-gzip dont-vary </IfModule>" : ""; string proxy = checkBox4.Checked ? @" <Proxy *> Order deny,allow Allow from all </Proxy> ProxyPass " + this.textBox10.Text + @" " + this.textBox9.Text + @" ProxyPassReverse " + this.textBox10.Text + @" " + this.textBox9.Text + @"" : ""; string php_cgi = this.comboBox2.Text.Equals("PHP") ? @" FcgidInitialEnv PHPRC """ + Application.StartupPath.Replace("\\", "/") + @"/soft/php/php7.0.9nts/"" AddHandler fcgid-script .php FcgidWrapper """ + Application.StartupPath.Replace("\\", "/") + @"/soft/php/php7.0.9nts/php-cgi.exe"" .php " : ""; string conf = @" <VirtualHost *:" + port + @"> DocumentRoot """ + path + @""" ServerName " + domain + @" " + domain2 + @" ServerAlias " + php_cgi + @" " + gzip + @" " + proxy + @" <Directory """ + path + @"""> Options FollowSymLinks ExecCGI AllowOverride All Order allow,deny Allow from all Require all granted DirectoryIndex " + webindex + @" </Directory> </VirtualHost>"; string httpsconf = @" <VirtualHost *:443> DocumentRoot """ + path + @""" ServerName " + domain + @" " + domain2 + @" ServerAlias " + php_cgi + @" SSLEngine on SSLProtocol TLSv1 TLSv1.1 TLSv1.2 SSLCipherSuite HIGH:MEDIUM:!aNULL:!MD5 SSLCertificateFile """ + Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain + @"\ca.pem" + @""" SSLCertificateKeyFile """ + Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain + @"\private.key" + @""" " + proxy + @" <Directory """ + path + @"""> Options FollowSymLinks ExecCGI AllowOverride All Order allow,deny Allow from all Require all granted DirectoryIndex " + webindex + @" </Directory> </VirtualHost> "; if (this.checkBox3.Checked) { conf = conf + httpsconf; try { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain); System.IO.File.WriteAllText(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain + @"\ca.pem", this.textBox6.Text, new System.Text.UTF8Encoding(false)); System.IO.File.WriteAllText(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain + @"\private.key", this.textBox8.Text, new System.Text.UTF8Encoding(false)); } catch (Exception ep) { Form1.form1.writeLog("创建HTTPS证书文件失败"); MessageBox.Show("创建HTTPS证书文件失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } try { System.IO.File.WriteAllText(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\vhosts\\" + domain + "_" + port + ".conf", conf, new System.Text.UTF8Encoding(false)); string listen = "Listen 443\n"; string sql = "select * from apacheweblist group by port"; SQLiteDataReader reader = DbHelperSQLite.ExecuteReader(sql); while (reader.Read()) { listen += "listen " + reader["port"] + "\n"; } System.IO.File.WriteAllText(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\vhosts\\Listen.conf", listen, new System.Text.UTF8Encoding(false)); } catch (Exception e) { Form1.form1.writeLog("创建网站配置文件失败"); MessageBox.Show("创建网站配置文件失败!请删除后重试", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } string subPath = this.textBox3.Text.Trim(); if (false == System.IO.Directory.Exists(subPath)) { try { System.IO.Directory.CreateDirectory(subPath); } catch (Exception e) { Form1.form1.writeLog("创建根目录失败"); MessageBox.Show("创建根目录失败,请自行创建", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (!rewrite.Equals("")) { try { if (false == System.IO.Directory.Exists(subPath)) { System.IO.Directory.CreateDirectory(subPath); } System.IO.File.WriteAllText(this.textBox3.Text.Trim() + "\\.htaccess", rewrite, new System.Text.UTF8Encoding(false)); } catch (Exception e) { Form1.form1.writeLog("生成网站伪静态文件失败"); MessageBox.Show("生成网站伪静态文件失败!请自行创建", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("id", "query_list")); }
private void button2_Click(object sender, EventArgs e) { try { string domain = this.textBox1.Text.Trim(); string domain2 = this.textBox4.Text.Trim(); string webindex = this.textBox7.Text; string port = this.textBox2.Text.Trim(); string rewrite = this.textBox5.Text; string path = this.textBox3.Text.Trim(); string ca = this.textBox6.Text; string key = this.textBox8.Text; string webtype = this.comboBox2.Text; string proxy_path = this.textBox10.Text; string proxy_url = this.textBox9.Text; int gzip = 0; int https = 0; int proxy = 0; string str_add = ""; if (domain == null || domain.Equals("")) { MessageBox.Show("主域名必须填写", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (port == null || port.Equals("")) { MessageBox.Show("端口不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (path == null || path.Equals("")) { MessageBox.Show("根目录不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (webindex == null || webindex.Equals("")) { MessageBox.Show("默认首页不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (this.checkBox3.Checked) { https = 1; if (ca == null || ca.Equals("")) { MessageBox.Show("CA证书不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (key == null || key.Equals("")) { MessageBox.Show("证书私钥不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } if (this.checkBox4.Checked) { proxy = 1; if (proxy_path == null || proxy_path.Equals("")) { MessageBox.Show("反代配置目录不能为空,根目录请填写/", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (proxy_url == null || proxy_url.Equals("")) { MessageBox.Show("反代URL不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } //--start 判断库里是否已经存在此网站信息 StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from apacheweblist"); strSql.Append(" where domain=@domain "); SQLiteParameter[] parameters = { new SQLiteParameter("@domain") }; parameters[0].Value = domain; if (DbHelperSQLite.Exists(strSql.ToString(), parameters)) { MessageBox.Show("此域名网站已经存在,请勿重复添加", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //--end 判断库里是否已经存在此网站信息 if (checkBox1.Checked) { //--start 判断库里是否已经存在同名数据库信息 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("select count(1) from mysql"); strSql2.Append(" where dbname=@dbname "); SQLiteParameter[] parameters2 = { new SQLiteParameter("@dbname") }; parameters2[0].Value = domain.Replace(".", "_"); if (DbHelperSQLite.Exists(strSql2.ToString(), parameters2)) { MessageBox.Show("此同名数据库已存在,请删除或手动添加其他名称数据库", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //--end 判断库里是否已经存在同名数据库信息 } if (checkBox2.Checked) { gzip = 1; } //--start 插入一条网站信息入软件Sqlite数据库 string sql = "insert into apacheweblist(domain,domain2,webindex,port,path,rewrite,gzip,https,https_ca,https_key,proxy,proxy_path,proxy_url,type) values(@domain,@domain2,@webindex,@port,@path,@rewrite,@gzip,@https,@https_ca,@https_key,@proxy,@proxy_path,@proxy_url,@type)"; SQLiteParameter[] paras = new SQLiteParameter[] { new SQLiteParameter("@domain", domain), new SQLiteParameter("@domain2", domain2), new SQLiteParameter("@webindex", webindex), new SQLiteParameter("@port", port), new SQLiteParameter("@path", path), new SQLiteParameter("@rewrite", rewrite), new SQLiteParameter("@gzip", gzip), new SQLiteParameter("@https", https), new SQLiteParameter("@https_ca", ca), new SQLiteParameter("@https_key", key), new SQLiteParameter("@proxy", proxy), new SQLiteParameter("@proxy_path", proxy_path), new SQLiteParameter("@proxy_url", proxy_url), new SQLiteParameter("@type", webtype) }; int res = DbHelperSQLite.ExecuteSql(sql, paras); //--end 插入一条网站信息入软件Sqlite数据库 if (res == 1) { //--start 选中了创建mysql数据库,执行数据库创建操作 if (checkBox1.Checked) { MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider(); Random rd = new Random(); TimeSpan ts = DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0, 0); string nowRand = Convert.ToInt64(ts.TotalSeconds).ToString() + "qwe@123@asd@456@zxc@789" + rd.Next().ToString(); string dbpass = BitConverter.ToString(md5.ComputeHash(UTF8Encoding.Default.GetBytes(nowRand), 4, 8)); dbpass = dbpass.Replace("-", ""); dbpass = dbpass.ToLower(); int mysqlCreate = this.CreateMysqlDataBase(domain.Replace(".", "_"), domain.Replace(".", "_"), dbpass); if (mysqlCreate == 1) { str_add = ""; string sql_insertmysql = "insert into mysql(dbname,dbpass,dbuser) values(@dbname,@dbpass,@dbuser)"; SQLiteParameter[] paras_insertmysql = new SQLiteParameter[] { new SQLiteParameter("@dbname", domain.Replace(".", "_")), new SQLiteParameter("@dbpass", dbpass), new SQLiteParameter("@dbuser", domain.Replace(".", "_")) }; DbHelperSQLite.ExecuteSql(sql_insertmysql, paras_insertmysql); Form1.form1.load_mysql_list(); } else { str_add = "mysql 创建失败!"; } } //--end 选中了创建mysql数据库,执行数据库创建操作 // if (this.comboBox2.Text.Equals("JAVA")) { webindex = ""; int createTomcatConf = this.add_tomcat_web_xml(domain, path, tomcat_port.ToString()); if (createTomcatConf != 1) { str_add += "Tomcat配置文件写入失败!"; } else { Form1.form1.button13_Click(null, null); } } // Form1.form1.writeLog("网站添加成功 " + str_add); MessageBox.Show("网站添加成功\n" + str_add); this.setApacheConf(domain, domain2, webindex, port, path, https); Form1.form1.load_apache_web(); Form1.form1.button3_Click(null, null); this.Hide(); } } catch (Exception ep) { MessageBox.Show("新增网站失败:" + ep.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); Form1.form1.writeLog("新增网站失败"); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("ID", "Comment")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("ID", "S_WebSite")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("id", "compare_result")); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ModelWebSiteItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [S_WebSite] set "); if (model.ClassID != null) { strSql.Append("ClassID=" + model.ClassID + ","); } if (model.WebSiteName != null) { strSql.Append("WebSiteName='" + model.WebSiteName + "',"); } if (model.WebSiteUrl != null) { strSql.Append("WebSiteUrl='" + model.WebSiteUrl + "',"); } if (model.WebSiteLoginUrl != null) { strSql.Append("WebSiteLoginUrl='" + model.WebSiteLoginUrl + "',"); } if (model.PublishName != null) { strSql.Append("PublishName='" + model.PublishName + "',"); } if (model.LoginUserName != null) { strSql.Append("LoginUserName='******',"); } if (model.LoginUserPwd != null) { strSql.Append("LoginUserPwd='" + model.LoginUserPwd + "',"); } if (model.CookiesValue != null) { strSql.Append("CookiesValue='" + model.CookiesValue + "',"); } if (model.IsCookie != null) { strSql.Append("IsCookie=" + model.IsCookie + ","); } if (model.Status != null) { strSql.Append("Status=" + model.Status + ","); } if (model.IsLinkPic != null) { strSql.Append("IsLinkPic=" + model.IsLinkPic + ","); } if (model.IsLinkWord != null) { strSql.Append("IsLinkWord=" + model.IsLinkWord + ","); } if (model.IsLinkPdf != null) { strSql.Append("IsLinkPdf=" + model.IsLinkPdf + ","); } if (model.IsLinkVideo != null) { strSql.Append("IsLinkVideo=" + model.IsLinkVideo + ","); } if (model.IsTitleFalse != null) { strSql.Append("IsTitleFalse=" + model.IsTitleFalse + ","); } if (model.IsContentFalse != null) { strSql.Append("IsContentFalse=" + model.IsContentFalse + ","); } if (model.IsAddTask != null) { strSql.Append("IsAddTask=" + model.IsAddTask + ","); } #region if (model.DataSourceType != null) { strSql.Append("DataSourceType=" + model.DataSourceType + ","); } if (model.DataType != null) { strSql.Append("DataType='" + model.DataType + "',"); } if (model.DataLinkUrl != null) { strSql.Append("DataLinkUrl='" + model.DataLinkUrl + "',"); } if (model.DataQuerySQL != null) { strSql.Append("DataQuerySQL='" + model.DataQuerySQL + "',"); } if (model.FileSourcePath != null) { strSql.Append("FileSourcePath='" + model.FileSourcePath + "',"); } #endregion strSql.Append("AddDateTime='" + model.AddDateTime + "'"); strSql.Append(" where ID=" + model.ID + " "); DbHelperSQLite.ExecuteSql(strSql.ToString()); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("PlayMediaID", "PlayMediaInfo")); }
/// <summary> /// 得到一个对象实体 /// </summary> public ModelWebSiteItem GetModle(int ID) { ModelWebSiteItem model = new ModelWebSiteItem(); StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append("* "); strSql.Append(" from [S_WebSite] "); strSql.Append(" where ID=" + ID + " "); DataSet ds = DbHelperSQLite.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["ClassID"].ToString() != "") { model.ClassID = int.Parse(ds.Tables[0].Rows[0]["ClassID"].ToString()); } if (ds.Tables[0].Rows[0]["WebSiteName"] != null) { model.WebSiteName = ds.Tables[0].Rows[0]["WebSiteName"].ToString(); } if (ds.Tables[0].Rows[0]["WebSiteUrl"] != null) { model.WebSiteUrl = ds.Tables[0].Rows[0]["WebSiteUrl"].ToString(); } if (ds.Tables[0].Rows[0]["WebSiteLoginUrl"] != null) { model.WebSiteLoginUrl = ds.Tables[0].Rows[0]["WebSiteLoginUrl"].ToString(); } if (ds.Tables[0].Rows[0]["PublishName"] != null) { model.PublishName = ds.Tables[0].Rows[0]["PublishName"].ToString(); } if (ds.Tables[0].Rows[0]["LoginUserName"] != null) { model.LoginUserName = ds.Tables[0].Rows[0]["LoginUserName"].ToString(); } if (ds.Tables[0].Rows[0]["LoginUserPwd"] != null) { model.LoginUserPwd = ds.Tables[0].Rows[0]["LoginUserPwd"].ToString(); } if (ds.Tables[0].Rows[0]["CookiesValue"] != null) { model.CookiesValue = ds.Tables[0].Rows[0]["CookiesValue"].ToString(); } if (ds.Tables[0].Rows[0]["IsCookie"].ToString() != "") { model.IsCookie = int.Parse(ds.Tables[0].Rows[0]["IsCookie"].ToString()); } if (ds.Tables[0].Rows[0]["Status"].ToString() != "") { model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString()); } if (ds.Tables[0].Rows[0]["IsLinkPic"].ToString() != "") { model.IsLinkPic = int.Parse(ds.Tables[0].Rows[0]["IsLinkPic"].ToString()); } if (ds.Tables[0].Rows[0]["IsLinkWord"].ToString() != "") { model.IsLinkWord = int.Parse(ds.Tables[0].Rows[0]["IsLinkWord"].ToString()); } if (ds.Tables[0].Rows[0]["IsLinkPdf"].ToString() != "") { model.IsLinkPdf = int.Parse(ds.Tables[0].Rows[0]["IsLinkPdf"].ToString()); } if (ds.Tables[0].Rows[0]["IsLinkVideo"].ToString() != "") { model.IsLinkVideo = int.Parse(ds.Tables[0].Rows[0]["IsLinkVideo"].ToString()); } if (ds.Tables[0].Rows[0]["IsTitleFalse"].ToString() != "") { model.IsTitleFalse = int.Parse(ds.Tables[0].Rows[0]["IsTitleFalse"].ToString()); } if (ds.Tables[0].Rows[0]["IsContentFalse"].ToString() != "") { model.IsContentFalse = int.Parse(ds.Tables[0].Rows[0]["IsContentFalse"].ToString()); } if (ds.Tables[0].Rows[0]["IsAddTask"].ToString() != "") { model.IsAddTask = int.Parse(ds.Tables[0].Rows[0]["IsAddTask"].ToString()); } if (ds.Tables[0].Rows[0]["AddDateTime"] != null) { model.AddDateTime = ds.Tables[0].Rows[0]["AddDateTime"].ToString(); } #region 2012 2 22 if (ds.Tables[0].Rows[0]["DataSourceType"] != null) { model.DataSourceType = int.Parse("0" + ds.Tables[0].Rows[0]["DataSourceType"].ToString()); } if (ds.Tables[0].Rows[0]["DataType"] != null) { model.DataType = ds.Tables[0].Rows[0]["DataType"].ToString(); } if (ds.Tables[0].Rows[0]["DataLinkUrl"] != null) { model.DataLinkUrl = ds.Tables[0].Rows[0]["DataLinkUrl"].ToString(); } if (ds.Tables[0].Rows[0]["DataQuerySQL"] != null) { model.DataQuerySQL = ds.Tables[0].Rows[0]["DataQuerySQL"].ToString(); } if (ds.Tables[0].Rows[0]["FileSourcePath"] != null) { model.FileSourcePath = ds.Tables[0].Rows[0]["FileSourcePath"].ToString(); } #endregion return(model); } return(null); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("id", "security_feedback")); }
/// <summary> /// 窗体初始化,包括配置数据文件 /// </summary> private void formInit() { try { string gssipStr = ""; string gssportStr = ""; //配置SQLITE文件 PubConstant.SqliteConnStr = Application.StartupPath; string sqlstr = "SELECT * FROM GSSCONFIG WHERE ID=1"; DataSet ds = DbHelperSQLite.Query(sqlstr); if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows != null) { gssipStr = ds.Tables[0].Rows[0]["GSSIP"].ToString().Trim(); gssportStr = ds.Tables[0].Rows[0]["GSSPORT"].ToString().Trim(); } string.Format("ip:[{0}],port:[{1}]", gssipStr, gssportStr).Logger(); if (gssipStr.Length > 0 && gssportStr.Length > 0) { tGSSip.Text = gssipStr; tGSSport.Text = gssportStr; ShareData.LocalIp = gssipStr; ShareData.LocalPort = Convert.ToInt16(gssportStr); //-------服务端通讯相关--------- IPAddress svripaddr = IPAddress.Parse(gssipStr); ushort uPort = ushort.Parse(gssportStr); svr = new TcpSvr(svripaddr, uPort, 1024, new Coder(Coder.EncodingMothord.Default)); svr.Resovlver = new DatagramResolver("]$}"); //处理客户端连接数已满事件 svr.ServerFull += new NetEvent(this.ServerFull); //处理新客户端连接事件 svr.ClientConn += new NetEvent(this.ClientConn); //处理客户端关闭事件 svr.ClientClose += new NetEvent(this.ClientClose); //处理接收到数据事件 svr.RecvData += new NetEvent(this.RecvData); string Sstate = string.Format("{0}/{1}", svr.SessionCount, svr.Capacity); lblServState.Text = Sstate; //服务对客户端请求的处理实例 svrhandle = new ServerHandle(svr); //日志记录 ShareData.Log.Info("GSS系统网络初始化" + gssipStr + ":" + gssportStr); //开机自启动 string runstr = ""; try { RegistryKey ms_run = Registry.LocalMachine.OpenSubKey("SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Run", true); if (ms_run.GetValue("ShenLongYouSoft") != null) { runstr = ms_run.GetValue("ShenLongYouSoft").ToString(); } timer1.Enabled = true; } catch (System.Exception ex) { ex.ToString().ErrorLogger(); ShareData.Log.Error("注册表查询失败", ex); } if (runstr.Trim().Length > 0) { checkBox1.Checked = true; ServStart(); } } else { FormServConfig form2 = new FormServConfig(); form2.ShowDialog(); Application.Restart(); } } catch (System.Exception ex) { ex.ToString().ErrorLogger(); MessageBox.Show("GSS初始化失败!\r\n" + ex.Message, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error); //日志记录 ShareData.Log.Error("GSS初始化失败", ex); timer1.Enabled = false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Hd model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Inv_Rcv_Bill_Hd set "); strSql.Append("Id=@Id,"); strSql.Append("RcvType=@RcvType,"); strSql.Append("RcvUserId=@RcvUserId,"); strSql.Append("RcvUserName=@RcvUserName,"); strSql.Append("RcvPhone=@RcvPhone,"); strSql.Append("RcvDateTime=@RcvDateTime,"); strSql.Append("RcvReason=@RcvReason,"); strSql.Append("RcvAddress=@RcvAddress,"); strSql.Append("RentSubject=@RentSubject,"); strSql.Append("RentUserId=@RentUserId,"); strSql.Append("RentUserName=@RentUserName,"); strSql.Append("RentPhone=@RentPhone,"); strSql.Append("RrcBillId=@RrcBillId,"); strSql.Append("PlanRtnDateTime=@PlanRtnDateTime,"); strSql.Append("ActualRtnDateTime=@ActualRtnDateTime,"); strSql.Append("BillStatus=@BillStatus,"); strSql.Append("DateTimeCreated=@DateTimeCreated,"); strSql.Append("UserCreator=@UserCreator,"); strSql.Append("DateTimeModified=@DateTimeModified,"); strSql.Append("UserModified=@UserModified,"); strSql.Append("State=@State,"); strSql.Append("OrgId=@OrgId"); strSql.Append(" where "); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 4), new SQLiteParameter("@RcvType", DbType.String, 0), new SQLiteParameter("@RcvUserId", DbType.Int32, 4), new SQLiteParameter("@RcvUserName", DbType.String, 0), new SQLiteParameter("@RcvPhone", DbType.String, 0), new SQLiteParameter("@RcvDateTime", DbType.Date), new SQLiteParameter("@RcvReason", DbType.String, 0), new SQLiteParameter("@RcvAddress", DbType.String, 0), new SQLiteParameter("@RentSubject", DbType.String, 0), new SQLiteParameter("@RentUserId", DbType.String, 0), new SQLiteParameter("@RentUserName", DbType.String, 0), new SQLiteParameter("@RentPhone", DbType.String, 0), new SQLiteParameter("@RrcBillId", DbType.Int32, 4), new SQLiteParameter("@PlanRtnDateTime", DbType.Date), new SQLiteParameter("@ActualRtnDateTime", DbType.Date), new SQLiteParameter("@BillStatus", DbType.String, 0), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1), new SQLiteParameter("@OrgId", DbType.String, 0) }; parameters[0].Value = model.Id; parameters[1].Value = model.RcvType; parameters[2].Value = model.RcvUserId; parameters[3].Value = model.RcvUserName; parameters[4].Value = model.RcvPhone; parameters[5].Value = model.RcvDateTime; parameters[6].Value = model.RcvReason; parameters[7].Value = model.RcvAddress; parameters[8].Value = model.RentSubject; parameters[9].Value = model.RentUserId; parameters[10].Value = model.RentUserName; parameters[11].Value = model.RentPhone; parameters[12].Value = model.RrcBillId; parameters[13].Value = model.PlanRtnDateTime; parameters[14].Value = model.ActualRtnDateTime; parameters[15].Value = model.BillStatus; parameters[16].Value = model.DateTimeCreated; parameters[17].Value = model.UserCreator; parameters[18].Value = model.DateTimeModified; parameters[19].Value = model.UserModified; parameters[20].Value = model.State; parameters[21].Value = model.OrgId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("EventID", "EventInfo")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQLite.GetMaxID("id", "business_compare")); }
public DataTable GetFileList(string treetype) { string sql = string.Format("select * from sys_Treeview where tree_type='{0}'", treetype); return(DbHelperSQLite.Query(sql).Tables[0]); }