public void UpdateObject(BusinessObject obj) { if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colSelected)) { ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colSelected, false); } if (String.IsNullOrWhiteSpace(ABCBaseUserProvider.CurrentUserName) == false && DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colUpdateUser)) { ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colUpdateUser, ABCBaseUserProvider.CurrentUserName); } if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colUpdateTime)) { ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colUpdateTime, ABCApp.ABCDataGlobal.WorkingDate); } BusinessObjectHelper.GenerateNoColumn(obj, false); if (DatabaseHelper.IsSQLConnection()) { (DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.Update, TableName), obj); } else { DatabaseHelper.RunScript(QueryTemplateGenerator.GenUpdate(TableName), obj); } }
public void GetStoredProcedureList(bool isIncludeDefaultSP) { List <String> lstSPs = new List <string>(); foreach (String strTableName in DataStructureProvider.DataTablesList.Keys) { lstSPs.AddRange(StoredProcedureGenerator.GetSPNameList(strTableName)); } DataSet ds = DataQueryProvider.RunQuery("SELECT name FROM sys.procedures;"); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0].Clone(); foreach (DataRow dr in ds.Tables[0].Rows) { String strName = dr["name"].ToString(); if (isIncludeDefaultSP || lstSPs.Contains(strName) == false) { dt.ImportRow(dr); } } GridCtrl.DataSource = dt; } }
public DataSet GetDataSetAllObjects( ) { if (DatabaseHelper.IsSQLConnection()) { return((DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.SelectAll, TableName))); } else { return(DatabaseHelper.RunScript(QueryGenerator.GenSelectAll(TableName, false, true))); } }
public DataSet GetDataSetByForeignKey(String strForeignColumnName, Guid iObjectID) { if (DatabaseHelper.IsSQLConnection()) { return((DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.SelectByFK, TableName, strForeignColumnName), iObjectID)); } else { return(DatabaseHelper.RunScript(QueryGenerator.GenSelectByColumn(TableName, strForeignColumnName, iObjectID, false, true))); } }
public void RealDeleteObjectsByFK(String strForeignColumn, object objValue) { if (DatabaseHelper.IsSQLConnection()) { (DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.RealDeleteByFK, TableName, strForeignColumn), objValue); } else { DatabaseHelper.RunScript(QueryGenerator.GenRealDeleteByColumn(TableName, strForeignColumn, objValue)); } }
public void RealDeleteAllObjects( ) { if (DatabaseHelper.IsSQLConnection()) { (DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.RealDeleteAll, TableName)); } else { DatabaseHelper.RunScript(QueryGenerator.GenRealDeleteAll(TableName)); } }
public void RealDeleteObject(Guid iObjectID) { if (DatabaseHelper.IsSQLConnection()) { (DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.RealDelete, TableName), iObjectID); } else { DatabaseHelper.RunScript(QueryGenerator.GenRealDeleteByID(TableName, iObjectID)); } }
public BusinessObject GetObjectByName(String strObjectName) { DataSet ds = null; if (DatabaseHelper.IsSQLConnection()) { ds = (DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.SelectByName, TableName), strObjectName); } else { ds = (DatabaseHelper as SQLiteDatabaseHelper).RunScript(QueryGenerator.GenSelectByName(TableName, strObjectName, false, true)); } return(BusinessObjectHelper.GetBusinessObject(ds, TableName)); }
public void DeleteObjectsByFK(String strForeignColumn, Guid objValue) { if (String.IsNullOrWhiteSpace(strForeignColumn) || objValue == Guid.Empty) { return; } if (DatabaseHelper.IsSQLConnection()) { (DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.DeleteByFK, TableName, strForeignColumn), objValue); } else { DatabaseHelper.RunScript(QueryGenerator.GenDeleteByColumn(TableName, strForeignColumn, objValue)); } }
private void GenerateSPs( ) { using (ABCControls.TableChooserForm form = new ABCControls.TableChooserForm()) { List <String> lstResult = form.ShowChoose(); if (form.DialogResult == DialogResult.OK) { ResultRichText.Text = "Please waiting..."; foreach (String strTableName in lstResult) { ResultRichText.Text += (Environment.NewLine + String.Format("Generate Default Stored Procedures for Table : {0} ", strTableName) + Environment.NewLine + Environment.NewLine); //foreach ( String strItem in StoredProcedureGenerator.GetSPNameList( strTableName ) ) // ResultRichText.Text+=( String.Format( " + Stored Procedure : {0} " , strItem )+Environment.NewLine ); //ResultRichText.Select( ResultRichText.Text.Length-1 , 0 ); //ResultRichText.ScrollToCaret(); StoredProcedureGenerator.GenSP(strTableName); } } } }
public BusinessObject GetObjectByID(Guid iObjectID) { try { DataSet ds = null; if (DatabaseHelper.IsSQLConnection()) { ds = (DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.Select, TableName), iObjectID); } else { ds = (DatabaseHelper as SQLiteDatabaseHelper).RunScript(QueryGenerator.GenSelectByID(TableName, iObjectID)); } return(BusinessObjectHelper.GetBusinessObject(ds, TableName)); } catch (Exception ex) { return(null); } }
public virtual Guid CreateObject(BusinessObject obj) { #region Default Value if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colSelected)) { ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colSelected, false); } if (String.IsNullOrWhiteSpace(ABCBaseUserProvider.CurrentUserName) == false && DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colCreateUser)) { ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colCreateUser, ABCBaseUserProvider.CurrentUserName); } if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colCreateTime)) { ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colCreateTime, ABCApp.ABCDataGlobal.WorkingDate); } #endregion Guid iID = Guid.Empty; if (DatabaseHelper.IsSQLConnection()) { iID = ABCHelper.DataConverter.ConvertToGuid((DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.Insert, TableName), obj)); } else { String strQuery = QueryTemplateGenerator.GenInsert(TableName); iID = Guid.NewGuid(); strQuery = strQuery.Replace(String.Format("@{0}", DataStructureProvider.GetPrimaryKeyColumn(TableName)), "'" + iID.ToString() + "'"); DatabaseHelper.RunScript(strQuery, obj); } ABCDynamicInvoker.SetValue(obj, DataStructureProvider.GetPrimaryKeyColumn(obj.AATableName), iID); if (BusinessObjectHelper.GenerateNoColumn(obj, true)) { UpdateObject(obj); } return(iID); }