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