/* * ردیف اضافه می کنیم * */ protected void fillRadif(AbstractCommonData entity) { for (int i = 0; i < entity.Tables[entity.FilledTableName].Rows.Count; i++) { entity.Tables[entity.FilledTableName].Rows[i][AbstractCommonData.FIELD_RADIF] = i + 1; } }
public static string getData(AbstractCommonData dataSet, ArrayList selectedFields, ArrayList selectedFieldsTitle) { if (selectedFieldsTitle.Count < 2) { return(""); } string data = ""; string flds = ""; string t; for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { t = generalizeData(selectedFields[0].ToString(), dataSet.Tables[0].Rows[i][selectedFields[0].ToString()].ToString().Trim()); flds = "<Row>\n\t<Cell ss:Index=\"1\"><Data ss:Type=\"String\">" + t + "</Data></Cell>\n"; for (int j = 1; j < selectedFields.Count; j++) { if (selectedFields[j] == null || selectedFields[j].ToString().Length == 0) { t = ""; } else { t = generalizeData(selectedFields[j].ToString(), dataSet.Tables[0].Rows[i][selectedFields[j].ToString()].ToString().Trim()); } flds += "\t<Cell><Data ss:Type=\"String\">" + t + "</Data></Cell>\n"; } data += flds + "</Row>\n"; } return(data); }
public override void select(string query, AbstractCommonData dataSet, string tableName) { SqlCommand cmd = new SqlCommand(query, dbCon); sqlda.SelectCommand = cmd; sqlda.Fill(dataSet, tableName); }
public override void loadToDataSet(AbstractCommonData entity, string condition, string orderby, string filledTableName) { string query = ""; if (filledTableName != null && filledTableName.Length > 0) { entity.FilledTableName = filledTableName; } else { entity.FilledTableName = entity.VIEW_QUALIFIRE + entity.TableName; } if (condition != null && condition.Length > 0) { query = "SELECT * FROM " + entity.FilledTableName + " WHERE " + condition; } else { query = "SELECT * FROM " + entity.FilledTableName; } if (orderby != null && orderby.Length > 0) { query += " ORDER BY " + orderby; } SqlCommand cmd = new SqlCommand(query, dbCon); if (sqlda != null) { sqlda.SelectCommand = cmd; sqlda.SelectCommand.CommandTimeout = 20 * 60; sqlda.Fill(entity, entity.FilledTableName); fillRadif(entity); } }
public override int update(AbstractCommonData entity) { SqlCommand cmd = new SqlCommand(entity.updatecmdWithIndexedWhereCluse, dbCon); sqlda.InsertCommand = cmd; sqlda.SelectCommand.CommandTimeout = 20 * 60; try { entity.Tables[entity.FilledTableName].Columns.Remove("RADIF"); } catch (Exception ex) { } SqlParameterCollection sqlParams = cmd.Parameters; if (entity.FilledTableName == "") { entity.FilledTableName = entity.TableName; } for (int i = 0; i < entity.Tables[entity.FilledTableName].Columns.Count; i++) { string p = entity.Tables[entity.FilledTableName].Columns[i].Caption; System.Type type = entity.Tables[entity.FilledTableName].Columns[i].GetType(); object value = entity.Tables[entity.FilledTableName].Rows[0][p]; if (value != null) { sqlParams.Add(new SqlParameter("@" + p, type)); sqlParams["@" + p].Value = value; } } return(cmd.ExecuteNonQuery()); //cmd.Parameters.Add( //return sqlda.Update(dataSet); }
public int deleteWithIndexField(AbstractCommonData entity) { string sql = "delete from " + entity.TableName + " where " + entity.IndexFieldName + "=" + provider.getSQLString(entity.Tables[entity.FilledTableName].Rows[0][entity.IndexFieldName].ToString()); return(provider.executeNonQuery(sql)); }
public override int update(AbstractCommonData dataSet, string tableName) { SqlCommand cmd = new SqlCommand(dataSet.updatecmdWithIndexedWhereCluse, dbCon); sqlda.InsertCommand = cmd; dataSet.Tables[0].Columns.Remove("RADIF"); SqlParameterCollection sqlParams = cmd.Parameters; for (int i = 0; i < dataSet.Tables[tableName].Columns.Count; i++) { string p = dataSet.Tables[tableName].Columns[i].Caption; System.Type type = dataSet.Tables[tableName].Columns[i].GetType(); object value = dataSet.Tables[tableName].Rows[0][p]; if (value != null) { sqlParams.Add(new SqlParameter("@" + p, type)); sqlParams["@" + p].Value = value; } } return(cmd.ExecuteNonQuery()); //cmd.Parameters.Add( //return sqlda.Update(dataSet); }
/* * ردیف اضافه می کنیم * */ protected void fillRadif(AbstractCommonData ds) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ds.Tables[0].Rows[i][AbstractCommonData.RADIF_FIELD] = i + 1; } }
public void bindDataToGrid(DataGridView grid, AbstractCommonData entity, changingRow chageRow, Hashtable hash) { grid.Rows.Clear(); int columns = grid.ColumnCount; DataTable table = entity.Tables[entity.FilledTableName]; if (table == null) { throw new Exception("نا م جدول در دیتا ست یافت نشد"); } string field; string colName = ""; object value = ""; int currentRowIndex; for (int tableIndex = 0; tableIndex < table.Rows.Count; tableIndex++) { currentRowIndex = grid.Rows.Add(); for (int gridIndex = 0; gridIndex < grid.Columns.Count; gridIndex++) { field = grid.Columns[gridIndex].DataPropertyName; if (field != null && field.Length > 0) { colName = grid.Columns[gridIndex].Name; try { value = getAsString(table.Rows[tableIndex][field]); } catch (Exception ex) { value = ""; } //cell = new DataGridViewCell(); //cell.Value = value; if (colName.Equals("USERTYPE")) { if (grid.Rows[currentRowIndex].Cells[colName] is DataGridViewComboBoxCell) { ((DataGridViewComboBoxCell)grid.Rows[currentRowIndex].Cells[colName]).Value = value; } } else { grid.Rows[currentRowIndex].Cells[colName].Value = value; } } } if (chageRow != null) { chageRow(grid, currentRowIndex, hash); } } }
public override void executeSelect(string query, AbstractCommonData entity, string filledTableName) { SqlCommand cmd = new SqlCommand(query, dbCon); sqlda.SelectCommand = cmd; sqlda.SelectCommand.CommandTimeout = 20 * 60; sqlda.Fill(entity, filledTableName); entity.FilledTableName = filledTableName; fillRadif(entity); }
private int getNewId() { AbstractCommonData entity = new AbstractCommonData(); string sql = "SELECT NEWID = @@IDENTITY"; sqlda.SelectCommand = new SqlCommand(sql, dbCon); sqlda.SelectCommand.CommandTimeout = 20 * 60; sqlda.Fill(entity); int id = int.Parse(entity.Tables[0].Rows[0][0].ToString()); return(id); }
private void fillGrid(string condition) { int id = int.Parse(UsersBS.loginedUser.Tables[UsersData.users_TABLE].Rows[0][UsersData.id_FIELD].ToString()); System.Collections.Hashtable hash = new System.Collections.Hashtable(); hash.Add("colorField", InsuranceTypeData.INSURANCETYPECOLOR_FIELD); _dataSource = new ViewInsuranceInfoBS().loadUserLimitedList(id, condition); _gridTools.bindDataToGrid(dataGridView1, _dataSource, ViewInsuranceInfoData.VIEW_INSURANCEINFO_TABLE , new GridTools.changingRow(_gridTools.changeColor), hash); selectCurrentRow(); }
public override void select(AbstractCommonData entity, string cond) { entity.FilledTableName = entity.VIEW_QUALIFIRE + entity.TableName; string query = "SELECT * FROM " + entity.FilledTableName; if (cond != null && cond.Trim().Length > 0) { query += " WHERE " + cond; } SqlCommand cmd = new SqlCommand(query, dbCon); sqlda.SelectCommand = cmd; sqlda.SelectCommand.CommandTimeout = 20 * 60; sqlda.Fill(entity, entity.FilledTableName); }
public override void loadToDataSet(string tableName, AbstractCommonData dataSet, string condition) { string query = ""; if (condition != null && condition.Length > 0) { query = "SELECT * FROM " + tableName + " WHERE " + condition; } else { query = "SELECT * FROM " + tableName; } SqlCommand cmd = new SqlCommand(query, dbCon); sqlda.SelectCommand = cmd; sqlda.Fill(dataSet, tableName); }
public override int delete(AbstractCommonData entity) { SqlCommand cmd = new SqlCommand(entity.deleteCmdWithIndexedWhereCluse, dbCon); sqlda.DeleteCommand = cmd; sqlda.SelectCommand.CommandTimeout = 20 * 60; SqlParameterCollection sqlParams = cmd.Parameters; for (int i = 0; i < entity.Tables[entity.FilledTableName].Columns.Count; i++) { string p = entity.Tables[entity.FilledTableName].Columns[i].Caption; System.Type type = entity.Tables[entity.FilledTableName].Columns[i].GetType(); object value = entity.Tables[entity.FilledTableName].Rows[0][p]; if (value != null) { sqlParams.Add(new SqlParameter("@" + p, type)); sqlParams["@" + p].Value = value; } } cmd.ExecuteNonQuery(); sqlda.Update(entity); return(0); }
public override int add(AbstractCommonData entity) { // sqlda. SqlCommand cmd = new SqlCommand(entity.insertCommand, dbCon); sqlda.InsertCommand = cmd; sqlda.SelectCommand.CommandTimeout = 20 * 60; SqlParameterCollection sqlParams = cmd.Parameters; for (int i = 0; i < entity.Tables[entity.TableName].Columns.Count; i++) { string p = entity.Tables[entity.TableName].Columns[i].Caption; System.Type type = entity.Tables[entity.TableName].Columns[i].GetType(); object value = entity.Tables[entity.TableName].Rows[0][p]; if (value != null) { sqlParams.Add(new SqlParameter("@" + p, type)); sqlParams["@" + p].Value = value; } } cmd.ExecuteScalar(); return(getNewId()); }
/// <summary> /// 数据更新前的处理. /// </summary> /// <param name="data"></param> public static void BeforeUpdateOperation(HttpSessionStateBase session, AbstractCommonData data) { // 更新 最后修改时间. data.BeforeUpdateOperation(); }
/// <summary> /// 数据插入前的处理. /// </summary> /// <param name="data"></param> public static void BeforeInsertOperation(HttpSessionStateBase session, AbstractCommonData data) { // 更新插入时间. data.BeforeInsertOperation(); }
public void load(AbstractCommonData entity, string cond) { _abstractDA.load(entity, cond); }
public void load(AbstractCommonData entity) { _abstractDA.load(entity); }
public abstract int delete(AbstractCommonData entity);
public abstract int update(AbstractCommonData dataSet);
public abstract int add(AbstractCommonData dataSet);
public void load(AbstractCommonData entity) { provider.loadToDataSet(entity); }
public abstract void loadToDataSet(AbstractCommonData dataSet, string condition, string orderBy, string filledTableName);
public int update(AbstractCommonData entity) { return(provider.update(entity)); }
public abstract void executeSelect(string query, AbstractCommonData entity);
public abstract void select(AbstractCommonData entity, string cond);
public void load(AbstractCommonData entity, string cond) { provider.loadToDataSet(entity, cond); }
public abstract void executeSelect(string query, AbstractCommonData entity, string filledTableName);