protected bool WfUpdateAda08(string pAda01, string pAda08) { StringBuilder sbSql; List <SqlParameter> sqlParmsList; try { sbSql = new StringBuilder(); sbSql.AppendLine("UPDATE ada_tb"); sbSql.AppendLine("SET ada08=@ada08"); sbSql.AppendLine("WHERE ada01=@ada01"); sqlParmsList = new List <SqlParameter>(); sqlParmsList.Add(new SqlParameter("ada01", pAda01)); sqlParmsList.Add(new SqlParameter("ada08", pAda08)); BoSecurity.OfExecuteNonquery(sbSql.ToString(), sqlParmsList.ToArray()); return(true); } catch (Exception ex) { throw ex; } }
//todo:目前是以proc運作,需考量改用程式碼來執行 private void WfRefreshView() { StringBuilder sbSql, sbViewSql; string lsSql; string viewName; DataTable dtAta, dtView; string ata01; CommonBLL boRefresh; try { if (BoSecurity == null) { WfShowErrorMsg("未設定主要連線!"); return; } //先更新主要連線的view YR sbViewSql = new StringBuilder(); sbViewSql.AppendLine(string.Format("SELECT name ")); sbViewSql.AppendLine(string.Format("FROM sys.objects")); sbViewSql.AppendLine(string.Format("WHERE type = 'V'")); dtView = BoSecurity.OfGetDataTable(sbViewSql.ToString()); foreach (DataRow ldr in dtView.Rows) { viewName = ldr["name"] == DBNull.Value ? "" : ldr["name"].ToString(); lsSql = string.Format("EXEC sp_refreshview '{0}' ", viewName); BoSecurity.OfExecuteNonquery(lsSql.ToString()); lsSql = string.Format("EXEC sp_gen_aza '{0}' ", viewName); BoSecurity.OfExecuteNonquery(lsSql.ToString()); } sbSql = new StringBuilder(); sbSql.AppendLine("SELECT * FROM ata_tb"); dtAta = BoSecurity.OfGetDataTable(sbSql.ToString(), null); if (dtAta != null && dtAta.Rows.Count > 0) { foreach (DataRow drTemp in dtAta.Rows) { ata01 = drTemp["ata01"] == DBNull.Value ? "" : drTemp["ata01"].ToString(); boRefresh = new CommonBLL(ata01, "", "", ""); //boRefresh.TRAN = admBll.TRAN; dtView = boRefresh.OfGetDataTable(sbViewSql.ToString()); foreach (DataRow ldr in dtView.Rows) { viewName = ldr["name"] == DBNull.Value ? "" : ldr["name"].ToString(); lsSql = string.Format("EXEC sp_refreshview '{0}' ", viewName); boRefresh.OfExecuteNonquery(lsSql.ToString()); } } } //admBll.TRAN.Commit(); } catch (System.Exception ex) { BoSecurity.TRAN.Rollback(); throw ex; } }