public static int UpdateUCache(string tableName)
{
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Clear();
sql.Add("update UCACHE set");
bool flag = database.Driver == DbProviderType.MSSQL;
if (flag)
{
sql.Add("UCACHE_UPDTIME = getdate()");
}
else
{
bool flag2 = database.Driver == DbProviderType.ORACLE;
if (flag2)
{
sql.Add("UCACHE_UPDTIME = sysdate");
}
}
sql.Add("where UCACHE_TABLENAME = :UCACHE_TABLENAME");
sql.ParamByName("UCACHE_TABLENAME").Value = tableName;
return(database.ExecSQL(sql));
}
public static void SendTodo(int smsOutId, string smsFormatUsers, string content)
{
bool flag = string.IsNullOrWhiteSpace(smsFormatUsers) || string.IsNullOrWhiteSpace(content);
if (!flag)
{
Database database = LogicContext.GetDatabase();
Dictionary <string, User> dictionary = smsFormatUsers.ToSmsUsers();
try
{
HSQL sql = new HSQL(database);
sql.Clear();
database.BeginTrans();
sql.Add("INSERT INTO SMSTODO(SMSTODO_SMSOUTINID,SMSTODO_MOBILE,SMSTODO_USERID,SMSTODO_USERNAME,SMSTODO_CONTENT,SMSTODO_RETRIES,SMSTODO_INPROC)");
sql.Add("VALUES(:SMSTODO_SMSOUTINID,:SMSTODO_MOBILE,:SMSTODO_USERID,:SMSTODO_USERNAME,:SMSTODO_CONTENT,:SMSTODO_RETRIES,:SMSTODO_INPROC)");
foreach (KeyValuePair <string, User> keyValuePair in dictionary)
{
sql.ParamByName("SMSTODO_SMSOUTINID").Value = smsOutId;
sql.ParamByName("SMSTODO_MOBILE").Value = keyValuePair.Key;
sql.ParamByName("SMSTODO_USERID").Value = keyValuePair.Value.UserId;
sql.ParamByName("SMSTODO_USERNAME").Value = keyValuePair.Value.UserName;
sql.ParamByName("SMSTODO_CONTENT").Value = content;
sql.ParamByName("SMSTODO_RETRIES").Value = 0;
sql.ParamByName("SMSTODO_INPROC").Value = "N";
database.ExecSQL(sql);
}
database.CommitTrans();
}
catch (Exception ex)
{
database.RollbackTrans();
throw ex;
}
}
}
public static int GetBBWeeks(DateTime dRQ)
{
int iWeeks = dRQ.DayOfYear / 7 + 1;
Database db = LogicContext.GetDatabase();
try
{
HSQL hsql = new HSQL(db);
hsql.Clear();
hsql.Add(" select BBZDY_FIRRQ from BBZDY ");
hsql.Add(" where BBZDY_FIRRQ<=:pRQ ");
hsql.Add(" and BBZDY_LASRQ>=:pRQ ");
hsql.ParamByName("pRQ").Value = dRQ;
DataSet ds = db.OpenDataSet(hsql);
bool flag = ds.Tables[0].Rows.Count > 0;
if (flag)
{
iWeeks = (dRQ.DayOfYear - Convert.ToDateTime(ds.Tables[0].Rows[0]["BBZDY_FIRRQ"].ToString()).DayOfYear) / 7 + 1;
}
}
catch
{
}
return(iWeeks);
}
public static void Init()
{
Database database = LogicContext.GetDatabase();
HSQL hsql = new HSQL(database);
hsql.Add("SELECT USERS_USERID FROM USERS WHERE USERS_USERID = :USERS_USERID");
hsql.ParamByName("USERS_USERID").Value = "ADMIN";
bool flag = DbHelper.ExistingRecord(hsql);
if (!flag)
{
hsql.Clear();
hsql.Add("INSERT INTO USERS(USERS_USERID,USERS_USERNAME,USERS_PASSWORD,USERS_ABBR,USERS_TYPE,USERS_DISABLED");
hsql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
hsql.Add("VALUES");
hsql.Add("(:USERS_USERID,:USERS_USERNAME,:USERS_PASSWORD,:USERS_ABBR,:USERS_TYPE,:USERS_DISABLED");
hsql.Add(",:CREATERID,:CREATER,getdate(),:MODIFIERID,:MODIFIER,getdate())");
hsql.ParamByName("USERS_USERID").Value = "ADMIN";
hsql.ParamByName("USERS_USERNAME").Value = "管理员";
hsql.ParamByName("USERS_PASSWORD").Value = "2396188767";
hsql.ParamByName("USERS_ABBR").Value = "ADMIN";
hsql.ParamByName("USERS_TYPE").Value = "S";
hsql.ParamByName("USERS_DISABLED").Value = "N";
hsql.ParamByName("CREATERID").Value = "ADMIN";
hsql.ParamByName("CREATER").Value = "管理员";
hsql.ParamByName("MODIFIERID").Value = "ADMIN";
hsql.ParamByName("MODIFIER").Value = "管理员";
database.ExecSQL(hsql);
}
}
public static bool HasBBJG(string sBBBH, int iBBND, int iBBQH)
{
bool result = false;
Database db = LogicContext.GetDatabase();
try
{
HSQL hsql = new HSQL(db);
hsql.Clear();
hsql.Add(" select 1 from BBSC ");
hsql.Add(" where BBSC_BBBH=:BBSC_BBBH ");
hsql.Add(" and BBSC_BBND=:BBSC_BBND ");
hsql.Add(" and BBSC_BBQH=:BBSC_BBQH ");
hsql.ParamByName("BBSC_BBBH").Value = sBBBH;
hsql.ParamByName("BBSC_BBND").Value = iBBND;
hsql.ParamByName("BBSC_BBQH").Value = iBBQH;
DataSet ds = db.OpenDataSet(hsql);
bool flag = ds.Tables[0].Rows.Count > 0;
if (flag)
{
result = true;
}
}
catch
{
}
return(result);
}
public static int GetFirstDayIntWeek(int iBBND)
{
int iWeek = 1;
Database db = LogicContext.GetDatabase();
try
{
HSQL hsql = new HSQL(db);
hsql.Clear();
hsql.Add(" select BBZDY_ZKS from BBZDY ");
hsql.Add(" where BBZDY_ND=:BBZDY_ND ");
hsql.ParamByName("BBZDY_ND").Value = iBBND;
DataSet ds = db.OpenDataSet(hsql);
bool flag = ds.Tables[0].Rows.Count > 0;
if (flag)
{
iWeek = Convert.ToInt32(ds.Tables[0].Rows[0]["BBZDY_ZKS"].ToString());
}
else
{
iWeek = 1;
}
}
catch
{
}
return(iWeek);
}
public static bool InsertBBJG(string sBBBH, int iBBND, int iBBQH, DateTime dKSRQ, DateTime dJSRQ)
{
bool result = false;
Database db = LogicContext.GetDatabase();
try
{
HSQL hsql = new HSQL(db);
hsql.Clear();
hsql.Add("INSERT INTO BBSC(");
hsql.Add(" BBSC_BBBH, BBSC_BBND, BBSC_BBQH, BBSC_KSRQ,BBSC_JSRQ, BBSC_BZ ");
hsql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
hsql.Add("VALUES(");
hsql.Add(" :BBSC_BBBH, :BBSC_BBND, :BBSC_BBQH, :BBSC_KSRQ,:BBSC_JSRQ, :BBSC_BZ ");
hsql.Add(",:CREATERID,:CREATER,:CREATEDTIME,:MODIFIERID,:MODIFIER,:MODIFIEDTIME)");
hsql.ParamByName("BBSC_BBBH").Value = sBBBH;
hsql.ParamByName("BBSC_BBND").Value = iBBND;
hsql.ParamByName("BBSC_BBQH").Value = iBBQH;
hsql.ParamByName("BBSC_KSRQ").Value = dKSRQ;
hsql.ParamByName("BBSC_JSRQ").Value = dJSRQ;
hsql.ParamByName("BBSC_BZ").Value = "报表服务生成";
hsql.ParamByName("CREATERID").Value = "";
hsql.ParamByName("CREATER").Value = "";
hsql.ParamByName("CREATEDTIME").Value = DateTime.Now;
hsql.ParamByName("MODIFIERID").Value = "";
hsql.ParamByName("MODIFIER").Value = "";
hsql.ParamByName("MODIFIEDTIME").Value = DateTime.Now;
db.ExecSQL(hsql);
result = true;
}
catch
{
}
return(result);
}
public static int GetBBMAXQH(string sBBBH, int iBBND)
{
Database db = LogicContext.GetDatabase();
int result;
try
{
HSQL hsql = new HSQL(db);
hsql.Clear();
hsql.Add(" select isnull(max(BBSC_BBQH),0) as MAXBBQH from BBSC ");
hsql.Add("WHERE BBSC_BBBH = :BBSC_BBBH");
hsql.Add(" and BBSC_BBND = :BBSC_BBND");
hsql.ParamByName("BBSC_BBBH").Value = sBBBH;
hsql.ParamByName("BBSC_BBND").Value = iBBND;
DataSet ds = db.OpenDataSet(hsql);
bool flag = ds.Tables[0].Rows.Count > 0;
if (flag)
{
result = Convert.ToInt32(ds.Tables[0].Rows[0]["MAXBBQH"].ToString());
}
else
{
result = 0;
}
}
catch
{
result = 0;
}
return(result);
}
public static bool SaveBBSCYS(string sBBBH, int sBBND, int sBBQH, string sReport)
{
Database db = LogicContext.GetDatabase();
bool result;
try
{
HSQL hsql = new HSQL(db);
byte[] bybuf = new byte[0];
bybuf = Encoding.Default.GetBytes(sReport);
hsql.Clear();
hsql.Add(" update BBSC ");
hsql.Add(" set BBSC_BBNR=:BBSC_BBNR ");
hsql.Add("WHERE BBSC_BBBH = :BBSC_BBBH");
hsql.Add(" and BBSC_BBND = :BBSC_BBND");
hsql.Add(" and BBSC_BBQH = :BBSC_BBQH");
hsql.ParamByName("BBSC_BBNR").Value = bybuf;
hsql.ParamByName("BBSC_BBBH").Value = sBBBH;
hsql.ParamByName("BBSC_BBND").Value = sBBND;
hsql.ParamByName("BBSC_BBQH").Value = sBBQH;
db.ExecSQL(hsql);
result = true;
}
catch
{
result = false;
}
return(result);
}
public static string GetBBDYYS(string sYSBH)
{
Database db = LogicContext.GetDatabase();
string result;
try
{
HSQL hsql = new HSQL(db);
hsql.Clear();
hsql.Add(" select BBSZ_BBYS from BBSZ ");
hsql.Add("WHERE BBSZ_BH = :BBSZ_BH");
hsql.ParamByName("BBSZ_BH").Value = sYSBH;
DataSet ds = db.OpenDataSet(hsql);
bool flag = ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0]["BBSZ_BBYS"].ToString() != "";
if (flag)
{
byte[] bybuf = new byte[0];
bybuf = (byte[])ds.Tables[0].Rows[0]["BBSZ_BBYS"];
string sBBYS = Encoding.Default.GetString(bybuf, 0, bybuf.Length);
result = sBBYS;
}
else
{
result = "";
}
}
catch
{
result = "";
}
return(result);
}
private int UpdateBusinessFiles()
{
int files = 0;
Database db = LogicContext.GetDatabase();
HSQL hsql = new HSQL(db);
hsql.Add("SELECT COUNT(DFSGROUP_FILEID) FROM DFSGROUP WHERE DFSGROUP_GROUPID = :DFSGROUP_GROUPID");
hsql.AddParam("DFSGROUP_GROUPID", TimDbType.Float, 0, this.hidFileGroup.Value.ToDouble());
object objFiles = db.ExecScalar(hsql);
bool flag = objFiles != null;
if (flag)
{
files = objFiles.ToString().ToInt();
hsql.Clear();
hsql.Add(string.Format("UPDATE {0} SET {1} = {2} WHERE {3}", new object[]
{
this.filelist.BusinessTable,
this.filelist.FilesField,
files.ToString(),
this.filelist.ExecOn
}));
db.ExecSQL(hsql);
}
return(files);
}
public static bool UpdatePsw(string userId, string psw, string newPsw, string confirmNewPsw)
{
bool flag = string.IsNullOrEmpty(userId);
if (flag)
{
throw new Exception("用户名或密码错误！");
}
bool flag2 = newPsw != confirmNewPsw;
if (flag2)
{
throw new Exception("两次输入的密码不匹配！");
}
User user = UserUtils.GetUser(userId);
bool flag3 = user == null;
if (flag3)
{
throw new Exception("用户名或密码错误！");
}
bool disabled = user.Disabled;
if (disabled)
{
throw new Exception("当前用户名已被停用！");
}
SystemInfo systemInfo = SystemInfoUtils.GetSystemInfo();
bool flag4 = systemInfo != null && systemInfo.PswLength > 0 && systemInfo.PswLength > newPsw.Length;
if (flag4)
{
throw new Exception(string.Format("密码长度小于系统指定最短长度({0})！", systemInfo.PswLength));
}
bool flag5 = user.Password != PasswordSec.Encode(userId, psw);
if (flag5)
{
throw new Exception("用户名或密码错误！");
}
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Clear();
sql.Add("UPDATE USERS SET");
sql.Add("USERS_PASSWORD = :USERS_PASSWORD");
sql.Add("WHERE USERS_USERID = :USERS_USERID");
sql.ParamByName("USERS_PASSWORD").Value = PasswordSec.Encode(userId, newPsw);
sql.ParamByName("USERS_USERID").Value = userId;
bool flag6 = database.ExecSQL(sql) != 1;
if (flag6)
{
throw new Exception(string.Format("用户({0})密码修改失败！", userId));
}
CacheEvent.TableIsUpdated("USERS");
return(true);
}
public override HSQL BuildDeleteSql()
{
HSQL hsql = base.BuildDeleteSql();
hsql.Clear();
hsql.Add("DELETE FROM REPORTSTYLE");
hsql.Add("WHERE REPORTSTYLE_STYLEID = :REPORTSTYLE_STYLEID");
hsql.Add("AND REPORTSTYLE_ORDER = :REPORTSTYLE_ORDER");
return(hsql);
}
internal bool RewriteAuthSession()
{
DateTime dateTime = AppRuntime.ServerDateTime;
bool flag = dateTime <= this.UpdateTime;
if (flag)
{
dateTime = this.UpdateTime.AddSeconds(1.0);
}
bool flag2 = !(this.RewriteAuthTime < dateTime);
bool result;
if (flag2)
{
result = false;
}
else
{
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Raw = true;
sql.Clear();
sql.Add("update AUTH set ");
sql.Add(" AUTH_USERID = :AUTH_USERID,");
sql.Add(" AUTH_LOGINTIME = :AUTH_LOGINTIME,");
sql.Add(" AUTH_LOGINTYPE = :AUTH_LOGINTYPE,");
sql.Add(" AUTH_CLIENTIP = :AUTH_CLIENTIP,");
sql.Add(" AUTH_CLIENTNAME = :AUTH_CLIENTNAME,");
sql.Add(" AUTH_DBID = :AUTH_DBID,");
sql.Add(" AUTH_LASTREFRESH = :AUTH_LASTREFRESH,");
sql.Add(" AUTH_LASTREQUEST = :AUTH_LASTREQUEST,");
sql.Add(" AUTH_UPDATETIME = :AUTH_UPDATETIME,");
sql.Add(" AUTH_EXINFO = :AUTH_EXINFO");
sql.Add("where AUTH_SESSIONID = :AUTH_SESSIONID");
sql.ParamByName("AUTH_USERID").Value = this.UserId;
sql.ParamByName("AUTH_LOGINTIME").Value = this.LoginTime;
sql.ParamByName("AUTH_LOGINTYPE").Value = this.LoginType.ToString();
sql.ParamByName("AUTH_CLIENTIP").Value = this.ClientIp;
sql.ParamByName("AUTH_CLIENTNAME").Value = this.ClientName;
sql.ParamByName("AUTH_DBID").Value = this.DbId;
sql.ParamByName("AUTH_LASTREFRESH").Value = this.LastRefreshTime;
sql.ParamByName("AUTH_LASTREQUEST").Value = this.LastRequestTime;
sql.ParamByName("AUTH_UPDATETIME").Value = this.UpdateTime;
sql.ParamByName("AUTH_EXINFO").Value = this.ExInfo;
sql.ParamByName("AUTH_SESSIONID").Value = this.SessionId;
database.ExecSQL(sql);
this.UpdateTime = dateTime;
this.RewriteAuthTime = AppRuntime.ServerDateTime.AddMinutes(5.0);
result = true;
}
return(result);
}
public override HSQL BuildRecordSetSql()
{
HSQL hsql = base.BuildRecordSetSql();
hsql.Clear();
hsql.Add("SELECT DFSGROUP_GROUPID,DFSGROUP_FILEID");
hsql.Add(",DFSFILE_FSID,DFSFILE_FILEID,DFSFILE_FILENAME,DFSFILE_EXTNAME,DFSFILE_FILESIZE");
hsql.Add("FROM DFSGROUP LEFT JOIN DFSFILE ON DFSFILE_FILEID = DFSGROUP_FILEID");
hsql.Add("WHERE DFSGROUP_GROUPID = :DFSGROUP_GROUPID");
hsql.Add("ORDER BY DFSGROUP_FILEID");
hsql.AddParam("DFSGROUP_GROUPID", TimDbType.Float, 0, this.QueryFileGroupId.ToInt());
return(hsql);
}
public static void ClearTmpTbl(string sTable, int iTmpID)
{
Database database = LogicContext.GetDatabase();
HSQL hsql = new HSQL(database);
hsql.Clear();
hsql.Add("delete from " + sTable);
hsql.Add(" where " + sTable.Trim() + "_ID=:pID ");
hsql.Add(" or " + sTable.Trim() + "_VMTIME<=:pVMTIME ");
hsql.ParamByName("pID").Value = iTmpID;
hsql.ParamByName("pVMTIME").Value = DateTime.Now.AddDays(-3.0);
database.ExecSQL(hsql);
}
internal static bool UpdateAuthLastRequest(string sessionId, DateTime lastRequest)
{
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Raw = true;
sql.Clear();
sql.Add("update AUTH set");
sql.Add(" AUTH_LASTREQUEST = :AUTH_LASTREQUEST");
sql.Add(" where AUTH_SESSIONID=:AUTH_SESSIONID");
sql.ParamByName("AUTH_SESSIONID").Value = sessionId;
sql.ParamByName("AUTH_LASTREQUEST").Value = lastRequest;
return(database.ExecSQL(sql) == 1);
}
internal static bool UpdateAuthLastRefresh(string sessionId)
{
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Raw = true;
sql.Clear();
sql.Add("update AUTH set");
sql.Add(" AUTH_LASTREFRESH = :AUTH_LASTREFRESH");
sql.Add(" where AUTH_SESSIONID=:AUTH_SESSIONID");
sql.ParamByName("AUTH_SESSIONID").Value = sessionId;
sql.ParamByName("AUTH_LASTREFRESH").Value = AppRuntime.ServerDateTime;
return(database.ExecSQL(sql) == 1);
}
public static void FillDropDownList(TimDropDownList ctrl, string sql, bool insertEmpty, bool firstSelected)
{
Database db = LogicContext.GetDatabase();
HSQL hsql = new HSQL(db);
hsql.Clear();
hsql.Add(sql);
try
{
DataSet ds = db.OpenDataSet(hsql);
bool flag = ds.Tables[0].Columns.Count < 2;
if (flag)
{
throw new Exception("");
}
ctrl.Items.Clear();
if (insertEmpty)
{
ctrl.Items.Add(new ListItem(" ", " "));
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string text = ds.Tables[0].Rows[i][0].ToString().Trim();
string value = ds.Tables[0].Rows[i][1].ToString().Trim();
ctrl.Items.Add(new ListItem(text, value));
}
if (insertEmpty)
{
bool flag2 = firstSelected && ctrl.Items.Count > 1;
if (flag2)
{
ctrl.Items[1].Selected = true;
}
}
else
{
bool flag3 = firstSelected && ctrl.Items.Count > 0;
if (flag3)
{
ctrl.Items[0].Selected = true;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public override HSQL BuildInsertSql()
{
HSQL hsql = base.BuildInsertSql();
hsql.Clear();
hsql.Add("INSERT INTO REPORTSTYLE(REPORTSTYLE_STYLEID,REPORTSTYLE_STYLENAME");
hsql.Add(",REPORTSTYLE_ORDER,REPORTSTYLE_DEFAULT,REPORTSTYLE_PUBLIC");
hsql.Add(",REPORTSTYLE_EXECON,REPORTSTYLE_VERSION");
hsql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
hsql.Add("VALUES");
hsql.Add("(:REPORTSTYLE_STYLEID,:REPORTSTYLE_STYLENAME");
hsql.Add(",:REPORTSTYLE_ORDER,:REPORTSTYLE_DEFAULT,:REPORTSTYLE_PUBLIC");
hsql.Add(",:REPORTSTYLE_EXECON,:REPORTSTYLE_VERSION");
hsql.Add(",:CREATERID,:CREATER,:CREATEDTIME,:MODIFIERID,:MODIFIER,:MODIFIEDTIME)");
return(hsql);
}
public override HSQL BuildUpdateSql()
{
HSQL hsql = base.BuildUpdateSql();
hsql.Clear();
hsql.Add("UPDATE REPORTSTYLE SET");
hsql.Add(" REPORTSTYLE_STYLENAME = :REPORTSTYLE_STYLENAME");
hsql.Add(",REPORTSTYLE_DEFAULT = :REPORTSTYLE_DEFAULT");
hsql.Add(",REPORTSTYLE_PUBLIC = :REPORTSTYLE_PUBLIC");
hsql.Add(",REPORTSTYLE_EXECON = :REPORTSTYLE_EXECON");
hsql.Add(",REPORTSTYLE_VERSION = :REPORTSTYLE_VERSION");
hsql.Add(",MODIFIERID = :MODIFIERID");
hsql.Add(",MODIFIER = :MODIFIER");
hsql.Add(",MODIFIEDTIME = :MODIFIEDTIME");
hsql.Add("WHERE REPORTSTYLE_STYLEID = :REPORTSTYLE_STYLEID");
hsql.Add("AND REPORTSTYLE_ORDER = :REPORTSTYLE_ORDER");
return(hsql);
}
private static bool GetUltIdLastRefreshTimeAndDbTime(out DateTime lastRefreshTime, out DateTime dbTime)
{
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Clear();
sql.Raw = true;
bool flag2 = database.Driver == DbProviderType.MSSQL;
if (flag2)
{
sql.Add("select AUTH_LASTREFRESH,getdate() as DBTIME");
}
else
{
bool flag3 = database.Driver == DbProviderType.ORACLE;
if (flag3)
{
sql.Add("select AUTH_LASTREFRESH,sysdate as DBTIME");
}
}
sql.Add("from AUTH");
sql.Add("where AUTH_SESSIONID = :AUTH_SESSIONID");
sql.ParamByName("AUTH_SESSIONID").Value = "876978727978717673657871";
DataTable dataTable = database.OpenDataSet(sql).Tables[0];
bool flag4 = dataTable.Rows.Count == 1;
bool flag;
if (flag4)
{
DataRow dataRow = dataTable.Rows[0];
flag = true;
lastRefreshTime = dataRow["AUTH_LASTREFRESH"].ToString().ToDateTime();
dbTime = dataRow["DBTIME"].ToString().ToDateTime();
}
else
{
flag = false;
lastRefreshTime = AppRuntime.UltDateTime;
dbTime = AppRuntime.UltDateTime;
}
return(flag);
}
public void Execute()
{
Dictionary <string, DateTime> dictionary = new Dictionary <string, DateTime>(StringComparer.InvariantCultureIgnoreCase);
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Clear();
sql.Raw = true;
bool flag = database.Driver == DbProviderType.MSSQL;
if (flag)
{
sql.Add("select UCACHE_TABLENAME,UCACHE_UPDTIME,getdate() as DBTIME from UCACHE");
}
else
{
bool flag2 = database.Driver == DbProviderType.ORACLE;
if (flag2)
{
sql.Add("select UCACHE_TABLENAME,UCACHE_UPDTIME,sysdate as DBTIME from UCACHE");
}
}
DataSet dataSet = database.OpenDataSet(sql);
for (int index = 0; index < dataSet.Tables[0].Rows.Count; index++)
{
DataRow dataRow = dataSet.Tables[0].Rows[index];
bool flag3 = index == 0 && dataRow["DBTIME"] != DBNull.Value;
if (flag3)
{
AppRuntime.ServerDateTime = (DateTime)dataRow["DBTIME"];
}
bool flag4 = dataRow["UCACHE_UPDTIME"] != DBNull.Value;
if (flag4)
{
string key = dataRow["UCACHE_TABLENAME"].ToString().Trim();
DateTime dateTime = (DateTime)dataRow["UCACHE_UPDTIME"];
dictionary.Add(key, dateTime);
}
}
UCacheTimeManager.TableUpdateTime = dictionary;
}
public static bool ResetPsw(string userId, string resetPsw)
{
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Clear();
sql.Add("UPDATE USERS SET");
sql.Add("USERS_PASSWORD = :USERS_PASSWORD");
sql.Add("WHERE USERS_USERID = :USERS_USERID");
sql.ParamByName("USERS_PASSWORD").Value = PasswordSec.Encode(userId, resetPsw);
sql.ParamByName("USERS_USERID").Value = userId;
bool flag = database.ExecSQL(sql) != 1;
if (flag)
{
throw new Exception(string.Format("用户({0})密码修改失败！", userId));
}
CacheEvent.TableIsUpdated("USERS");
return(true);
}
protected void btnPublic_Click(object sender, EventArgs e)
{
Database db = LogicContext.GetDatabase();
HSQL hsql = new HSQL(db);
hsql.Clear();
bool flag = this.gvMaster.DataKeys[this.gvMaster.SelectedIndex]["REPORTSTYLE_PUBLIC"].ToString().Trim() == "Y";
if (flag)
{
hsql.Add("UPDATE REPORTSTYLE SET REPORTSTYLE_PUBLIC = 'N' WHERE REPORTSTYLE_STYLEID = :REPORTSTYLE_STYLEID AND REPORTSTYLE_ORDER = :REPORTSTYLE_ORDER");
}
else
{
hsql.Add("UPDATE REPORTSTYLE SET REPORTSTYLE_PUBLIC = 'Y' WHERE REPORTSTYLE_STYLEID = :REPORTSTYLE_STYLEID AND REPORTSTYLE_ORDER = :REPORTSTYLE_ORDER");
}
hsql.ParamByName("REPORTSTYLE_STYLEID").Value = this.gvMaster.DataKeys[this.gvMaster.SelectedIndex]["REPORTSTYLE_STYLEID"].ToString().Trim();
hsql.ParamByName("REPORTSTYLE_ORDER").Value = this.gvMaster.DataKeys[this.gvMaster.SelectedIndex]["REPORTSTYLE_ORDER"].ToString().Trim();
db.ExecSQL(hsql);
base.CurMaster_OnQuery(null, null);
}
public static string GetBBLX(string sBBBH)
{
string R_BBLX = "";
Database db = LogicContext.GetDatabase();
try
{
HSQL hsql = new HSQL(db);
hsql.Clear();
hsql.Add(" select BBSZ_BBLX from BBSZ ");
hsql.Add(" where BBSZ_BH=:BBSZ_BH ");
hsql.ParamByName("BBSZ_BH").Value = sBBBH;
DataSet ds = db.OpenDataSet(hsql);
bool flag = ds.Tables[0].Rows.Count > 0;
if (flag)
{
R_BBLX = ds.Tables[0].Rows[0]["BBSZ_BBLX"].ToString().Trim();
}
}
catch
{
}
return(R_BBLX);
}
public static int InsertUCache(string tableName)
{
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Clear();
sql.Add("insert into UCACHE(UCACHE_TABLENAME, UCACHE_UPDTIME)");
bool flag = database.Driver == DbProviderType.MSSQL;
if (flag)
{
sql.Add("values(:UCACHE_TABLENAME,getdate())");
}
else
{
bool flag2 = database.Driver == DbProviderType.ORACLE;
if (flag2)
{
sql.Add("values(:UCACHE_TABLENAME,sysdate)");
}
}
sql.ParamByName("UCACHE_TABLENAME").Value = tableName;
return(database.ExecSQL(sql));
}
internal static DateTime GetDbServerDateTime()
{
DateTime dateTime = DateTime.Now;
try
{
Database database = LogicContext.GetDatabase(new DbConfig("DBCFG", AppConfig.DefaultDbDesc, AppConfig.DbMS, AppConfig.DbServer));
HSQL sql = new HSQL(database);
sql.Clear();
sql.Raw = true;
bool flag = database.Driver == DbProviderType.MSSQL;
if (flag)
{
sql.Add("select getdate()");
}
else
{
bool flag2 = database.Driver == DbProviderType.ORACLE;
if (flag2)
{
sql.Add("select sysdate from dual");
}
}
object obj = database.ExecScalar(sql);
bool flag3 = obj != null;
if (flag3)
{
dateTime = (DateTime)obj;
}
}
catch
{
dateTime = DateTime.Now;
}
return(dateTime);
}
public static void Init()
{
Database database = LogicContext.GetDatabase();
HSQL hsql = new HSQL(database);
hsql.Clear();
hsql.Add("SELECT PERMISSIONOP_ID FROM PERMISSIONOP WHERE PERMISSIONOP_ID = :PERMISSIONOP_ID");
hsql.ParamByName("PERMISSIONOP_ID").Value = "INSERT";
bool flag = !DbHelper.ExistingRecord(hsql);
if (flag)
{
hsql.Clear();
hsql.Add("INSERT INTO PERMISSIONOP(PERMISSIONOP_XH,PERMISSIONOP_ID,PERMISSIONOP_NAME");
hsql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
hsql.Add("VALUES");
hsql.Add("(:PERMISSIONOP_XH,:PERMISSIONOP_ID,:PERMISSIONOP_NAME");
hsql.Add(",:CREATERID,:CREATER,getdate(),:MODIFIERID,:MODIFIER,getdate())");
hsql.ParamByName("PERMISSIONOP_XH").Value = "1";
hsql.ParamByName("PERMISSIONOP_ID").Value = "INSERT";
hsql.ParamByName("PERMISSIONOP_NAME").Value = "新建";
hsql.ParamByName("CREATERID").Value = "ADMIN";
hsql.ParamByName("CREATER").Value = "管理员";
hsql.ParamByName("MODIFIERID").Value = "AMDIN";
hsql.ParamByName("MODIFIER").Value = "管理员";
database.ExecSQL(hsql);
}
hsql.Clear();
hsql.Add("SELECT PERMISSIONOP_ID FROM PERMISSIONOP WHERE PERMISSIONOP_ID = :PERMISSIONOP_ID");
hsql.ParamByName("PERMISSIONOP_ID").Value = "EDIT";
bool flag2 = !DbHelper.ExistingRecord(hsql);
if (flag2)
{
hsql.Clear();
hsql.Add("INSERT INTO PERMISSIONOP(PERMISSIONOP_XH,PERMISSIONOP_ID,PERMISSIONOP_NAME");
hsql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
hsql.Add("VALUES");
hsql.Add("(:PERMISSIONOP_XH,:PERMISSIONOP_ID,:PERMISSIONOP_NAME");
hsql.Add(",:CREATERID,:CREATER,getdate(),:MODIFIERID,:MODIFIER,getdate())");
hsql.ParamByName("PERMISSIONOP_XH").Value = "2";
hsql.ParamByName("PERMISSIONOP_ID").Value = "EDIT";
hsql.ParamByName("PERMISSIONOP_NAME").Value = "编辑";
hsql.ParamByName("CREATERID").Value = "ADMIN";
hsql.ParamByName("CREATER").Value = "管理员";
hsql.ParamByName("MODIFIERID").Value = "ADMIN";
hsql.ParamByName("MODIFIER").Value = "管理员";
database.ExecSQL(hsql);
}
hsql.Clear();
hsql.Add("SELECT PERMISSIONOP_ID FROM PERMISSIONOP WHERE PERMISSIONOP_ID = :PERMISSIONOP_ID");
hsql.ParamByName("PERMISSIONOP_ID").Value = "DELETE";
bool flag3 = !DbHelper.ExistingRecord(hsql);
if (flag3)
{
hsql.Clear();
hsql.Add("INSERT INTO PERMISSIONOP(PERMISSIONOP_XH,PERMISSIONOP_ID,PERMISSIONOP_NAME");
hsql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
hsql.Add("VALUES");
hsql.Add("(:PERMISSIONOP_XH,:PERMISSIONOP_ID,:PERMISSIONOP_NAME");
hsql.Add(",:CREATERID,:CREATER,getdate(),:MODIFIERID,:MODIFIER,getdate())");
hsql.ParamByName("PERMISSIONOP_XH").Value = "3";
hsql.ParamByName("PERMISSIONOP_ID").Value = "DELETE";
hsql.ParamByName("PERMISSIONOP_NAME").Value = "删除";
hsql.ParamByName("CREATERID").Value = "ADMIN";
hsql.ParamByName("CREATER").Value = "管理员";
hsql.ParamByName("MODIFIERID").Value = "ADMIN";
hsql.ParamByName("MODIFIER").Value = "管理员";
database.ExecSQL(hsql);
}
hsql.Clear();
hsql.Add("SELECT PERMISSIONOP_ID FROM PERMISSIONOP WHERE PERMISSIONOP_ID = :PERMISSIONOP_ID");
hsql.ParamByName("PERMISSIONOP_ID").Value = "VIEW";
bool flag4 = !DbHelper.ExistingRecord(hsql);
if (flag4)
{
hsql.Clear();
hsql.Add("INSERT INTO PERMISSIONOP(PERMISSIONOP_XH,PERMISSIONOP_ID,PERMISSIONOP_NAME");
hsql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
hsql.Add("VALUES");
hsql.Add("(:PERMISSIONOP_XH,:PERMISSIONOP_ID,:PERMISSIONOP_NAME");
hsql.Add(",:CREATERID,:CREATER,getdate(),:MODIFIERID,:MODIFIER,getdate())");
hsql.ParamByName("PERMISSIONOP_XH").Value = "4";
hsql.ParamByName("PERMISSIONOP_ID").Value = "VIEW";
hsql.ParamByName("PERMISSIONOP_NAME").Value = "浏览";
hsql.ParamByName("CREATERID").Value = "ADMIN";
hsql.ParamByName("CREATER").Value = "管理员";
hsql.ParamByName("MODIFIERID").Value = "ADMIN";
hsql.ParamByName("MODIFIER").Value = "管理员";
database.ExecSQL(hsql);
}
hsql.Clear();
hsql.Add("SELECT PERMISSIONOP_ID FROM PERMISSIONOP WHERE PERMISSIONOP_ID = :PERMISSIONOP_ID");
hsql.ParamByName("PERMISSIONOP_ID").Value = "PRINT";
bool flag5 = !DbHelper.ExistingRecord(hsql);
if (flag5)
{
hsql.Clear();
hsql.Add("INSERT INTO PERMISSIONOP(PERMISSIONOP_XH,PERMISSIONOP_ID,PERMISSIONOP_NAME");
hsql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
hsql.Add("VALUES");
hsql.Add("(:PERMISSIONOP_XH,:PERMISSIONOP_ID,:PERMISSIONOP_NAME");
hsql.Add(",:CREATERID,:CREATER,getdate(),:MODIFIERID,:MODIFIER,getdate())");
hsql.ParamByName("PERMISSIONOP_XH").Value = "5";
hsql.ParamByName("PERMISSIONOP_ID").Value = "PRINT";
hsql.ParamByName("PERMISSIONOP_NAME").Value = "打印";
hsql.ParamByName("CREATERID").Value = "ADMIN";
hsql.ParamByName("CREATER").Value = "管理员";
hsql.ParamByName("MODIFIERID").Value = "ADMIN";
hsql.ParamByName("MODIFIER").Value = "管理员";
database.ExecSQL(hsql);
}
hsql.Clear();
hsql.Add("SELECT PERMISSIONOP_ID FROM PERMISSIONOP WHERE PERMISSIONOP_ID = :PERMISSIONOP_ID");
hsql.ParamByName("PERMISSIONOP_ID").Value = "DESIGN";
bool flag6 = !DbHelper.ExistingRecord(hsql);
if (flag6)
{
hsql.Clear();
hsql.Add("INSERT INTO PERMISSIONOP(PERMISSIONOP_XH,PERMISSIONOP_ID,PERMISSIONOP_NAME");
hsql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
hsql.Add("VALUES");
hsql.Add("(:PERMISSIONOP_XH,:PERMISSIONOP_ID,:PERMISSIONOP_NAME");
hsql.Add(",:CREATERID,:CREATER,getdate(),:MODIFIERID,:MODIFIER,getdate())");
hsql.ParamByName("PERMISSIONOP_XH").Value = "6";
hsql.ParamByName("PERMISSIONOP_ID").Value = "DESIGN";
hsql.ParamByName("PERMISSIONOP_NAME").Value = "报表设计";
hsql.ParamByName("CREATERID").Value = "ADMIN";
hsql.ParamByName("CREATER").Value = "管理员";
hsql.ParamByName("MODIFIERID").Value = "ADMIN";
hsql.ParamByName("MODIFIER").Value = "管理员";
database.ExecSQL(hsql);
}
}
public static void Init(TIM.T_KERNEL.DbTableCache.DllComponent dllComponent)
{
List <DllModule> modules = dllComponent.Modules;
Database database = LogicContext.GetDatabase();
HSQL hsql = new HSQL(database);
hsql.Clear();
hsql.Add("delete from MODULE WHERE MODULE_COMID = :MODULE_COMID");
hsql.ParamByName("MODULE_COMID").Value = dllComponent.ComId;
database.ExecSQL(hsql);
foreach (DllModule dllModule in modules)
{
bool flag = dllModule.Type == ModuleType.W || dllModule.Type == ModuleType.N;
if (flag)
{
hsql.Clear();
hsql.Add("SELECT MEPAGE_MDID FROM MEPAGE WHERE MEPAGE_MDID = :MEPAGE_MDID");
hsql.ParamByName("MEPAGE_MDID").Value = dllModule.MdId;
bool flag2 = DbHelper.ExistingRecord(hsql);
if (flag2)
{
hsql.Clear();
hsql.Add("UPDATE MEPAGE SET ");
hsql.Add(" MEPAGE_WFBID = :MEPAGE_WFBID,");
hsql.Add(" MEPAGE_COMID = :MEPAGE_COMID,");
hsql.Add(" MEPAGE_URL = :MEPAGE_URL,");
hsql.Add(" MEPAGE_TYPE = :MEPAGE_TYPE");
hsql.Add("WHERE MEPAGE_MDID = :MEPAGE_MDID");
hsql.ParamByName("MEPAGE_MDID").Value = dllModule.MdId;
hsql.ParamByName("MEPAGE_WFBID").Value = dllModule.WfbId;
hsql.ParamByName("MEPAGE_COMID").Value = dllComponent.ComId;
hsql.ParamByName("MEPAGE_URL").Value = dllModule.Url;
hsql.ParamByName("MEPAGE_TYPE").Value = dllModule.Type.ToString();
database.ExecSQL(hsql);
}
else
{
hsql.Clear();
hsql.Add("INSERT INTO MEPAGE(MEPAGE_MDID,MEPAGE_WFBID,MEPAGE_COMID,MEPAGE_URL,MEPAGE_TYPE)");
hsql.Add("VALUES");
hsql.Add("(:MEPAGE_MDID,:MEPAGE_WFBID,:MEPAGE_COMID,:MEPAGE_URL,:MEPAGE_TYPE)");
hsql.ParamByName("MEPAGE_MDID").Value = dllModule.MdId;
hsql.ParamByName("MEPAGE_WFBID").Value = dllModule.WfbId;
hsql.ParamByName("MEPAGE_COMID").Value = dllComponent.ComId;
hsql.ParamByName("MEPAGE_URL").Value = dllModule.Url;
hsql.ParamByName("MEPAGE_TYPE").Value = dllModule.Type.ToString();
database.ExecSQL(hsql);
}
}
else
{
hsql.Clear();
hsql.Add("SELECT MODULE_MDID FROM MODULE WHERE MODULE_MDID = :MODULE_MDID");
hsql.ParamByName("MODULE_MDID").Value = dllModule.MdId;
bool flag3 = DbHelper.ExistingRecord(hsql);
if (flag3)
{
hsql.Clear();
hsql.Add("UPDATE MODULE SET ");
hsql.Add(" MODULE_COMID = :MODULE_COMID,");
hsql.Add(" MODULE_MDNAME = :MODULE_MDNAME,");
hsql.Add(" MODULE_TYPE = :MODULE_TYPE,");
hsql.Add(" MODULE_URL = :MODULE_URL,");
hsql.Add(" MODULE_ATTRIBUTE = :MODULE_ATTRIBUTE");
hsql.Add("WHERE MODULE_MDID = :MODULE_MDID");
hsql.ParamByName("MODULE_MDID").Value = dllModule.MdId;
hsql.ParamByName("MODULE_COMID").Value = dllComponent.ComId;
hsql.ParamByName("MODULE_MDNAME").Value = dllModule.MdName;
hsql.ParamByName("MODULE_TYPE").Value = dllModule.Type.ToString();
hsql.ParamByName("MODULE_URL").Value = "";
hsql.ParamByName("MODULE_ATTRIBUTE").Value = dllModule.Attribute;
database.ExecSQL(hsql);
}
else
{
hsql.Clear();
hsql.Add("INSERT INTO MODULE(MODULE_MDID,MODULE_COMID,MODULE_MDNAME,MODULE_TYPE,MODULE_STDMDID,MODULE_URL,MODULE_ATTRIBUTE)");
hsql.Add("VALUES");
hsql.Add("(:MODULE_MDID,:MODULE_COMID,:MODULE_MDNAME,:MODULE_TYPE,:MODULE_STDMDID,:MODULE_URL,:MODULE_ATTRIBUTE)");
hsql.ParamByName("MODULE_MDID").Value = dllModule.MdId;
hsql.ParamByName("MODULE_COMID").Value = dllComponent.ComId;
hsql.ParamByName("MODULE_MDNAME").Value = dllModule.MdName;
hsql.ParamByName("MODULE_TYPE").Value = dllModule.Type.ToString();
hsql.ParamByName("MODULE_STDMDID").Value = 0;
hsql.ParamByName("MODULE_URL").Value = "";
hsql.ParamByName("MODULE_ATTRIBUTE").Value = dllModule.Attribute;
database.ExecSQL(hsql);
}
}
}
}
