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