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