private DataSourceTable CheckDSTableDesign(DataTable dtTable) { string tablename = dtTable.TableName; DataSourceTable sTableDetail = new DataSourceTable(); sTableDetail.Name = tablename; int iCount = 0; int iIdCount = 0; int iUpdateCount = 0; foreach (DataColumn column in dtTable.Columns) { if (column.ToString() == "GINGER_KEY_NAME" || column.ToString() == "GINGER_KEY_VALUE") { iCount++; } else if (column.ToString() == "GINGER_ID") { iIdCount++; } else if (column.ToString() == "GINGER_LAST_UPDATE_DATETIME" || column.ToString() == "GINGER_LAST_UPDATED_BY") { iUpdateCount++; } } if (iCount == 2 && dtTable.Columns.Count == 2 + iIdCount + iUpdateCount) { sTableDetail.DSTableType = DataSourceTable.eDSTableType.GingerKeyValue; } else { sTableDetail.DSTableType = DataSourceTable.eDSTableType.Customized; } OleDbCommand myCommand = new OleDbCommand(); if (iIdCount == 0) { myAccessConn.Close(); Init(mFilePath, "Write"); myCommand.CommandText = "ALTER TABLE " + tablename + " ADD COLUMN [GINGER_ID] AUTOINCREMENT"; myCommand.Connection = myAccessConn; myCommand.ExecuteNonQuery(); myAccessConn.Close(); Init(mFilePath); } sTableDetail.DSC = this; return(sTableDetail); }
public override void AddRow(List <string> mColumnNames, DataSourceTable mDSTableDetails) { DataRow dr = mDSTableDetails.DataTable.NewRow(); mColumnNames = mDSTableDetails.DSC.GetColumnList(mDSTableDetails.Name); foreach (string sColName in mColumnNames) { if (sColName != "GINGER_ID" && sColName != "GINGER_LAST_UPDATED_BY" && sColName != "GINGER_LAST_UPDATE_DATETIME") { dr[sColName] = ""; } else if (sColName == "GINGER_ID") { dr[sColName] = System.DBNull.Value; } } mDSTableDetails.DataTable.Rows.Add(dr); }
public override void DuplicateRow(List <string> mColumnNames, List <object> SelectedItemsList, DataSourceTable mDSTableDetails) { mColumnNames = mDSTableDetails.DSC.GetColumnList(mDSTableDetails.Name); foreach (object o in SelectedItemsList) { DataRow row = (((DataRowView)o).Row); DataRow dr = mDSTableDetails.DataTable.NewRow(); foreach (string sColName in mColumnNames) { if (sColName != "GINGER_ID" && sColName != "GINGER_LAST_UPDATED_BY" && sColName != "GINGER_LAST_UPDATE_DATETIME") { dr[sColName] = row[sColName]; } else { dr[sColName] = System.DBNull.Value; } } mDSTableDetails.DataTable.Rows.Add(dr); } }
public abstract void DuplicateRow(List <string> mColumnNames, List <object> SelectedItemsList, DataSourceTable mDSTableDetails);
public abstract void AddRow(List <string> mColumnNames, DataSourceTable mDSTableDetails);