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