private void refreshRow(DataSet ds, ListDataRow row) { if (ds.Tables.Count < 1) { return; } DataTable tb = ds.Tables[0]; if (tb.Rows.Count < 1) { return; } foreach (DataColumn col in tb.Columns) { string field = col.ColumnName; string fName = XSqlBuilder.OLD_VERSION_PIX + field; if (row.ContainsKey(field)) { row[field] = tb.Rows[0][field].ToString(); } if (row.ContainsKey(fName)) { row[fName] = tb.Rows[0][field].ToString(); } } }
private void setCommandParamValue(DbCommand cmd, Dictionary <string, string> paramValues, ListDataRow row) { foreach (DbParameter dbp in cmd.Parameters) { string pName = dbp.ParameterName; string fName = pName.Remove(0, 1); object value = null; if (row != null && row.ContainsKey(fName)) { if (!string.IsNullOrEmpty(row[fName])) { value = row[fName]; } } if (paramValues != null && paramValues.ContainsKey(pName)) { if (!string.IsNullOrEmpty(paramValues[pName])) { value = paramValues[pName]; } } dbAdmin.Database.SetParameterValue(cmd, pName, value); } }
private bool isNewRow(ListDataRow row) { if (schema.PrimaryKeys == null || schema.PrimaryKeys.Count <= 0) { throw new XException(Lang.NoMainKey); } foreach (string pk in _schema.PrimaryKeys) { string kf = XSqlBuilder.OLD_VERSION_PIX + pk; if (!row.ContainsKey(kf) || string.IsNullOrEmpty(row[kf])) { return(true); } } return(false); }