protected void SetUpdateSql(string tableName, SqlItemList setParameters, SqlItemList whereParameters) { if (setParameters.Count == 0) { throw new ApplicationException("set paramters is empty"); } if (whereParameters.Count == 0) { throw new ApplicationException("where paramters is empty"); } SetSqlFormat( @"update {0} set {1} ", tableName, GetCommaSetFieldParamList(setParameters.Select(x => x.FieldName).ToList())); SetParameters(setParameters.Select(x => x.FieldValue).ToArray()); foreach (var i in whereParameters) { AddSqlWhereField(i.FieldName, i.FieldValue); } }
protected void SetInsertIntoSql(string tableName, SqlItemList parameters) { SetSqlFormat("insert into {0} ({1}) values ({2})", tableName, GetCommaFieldList(parameters.Select(x => x.FieldName).ToList()), GetCommaListOfChar('?', parameters.Count)); SetParameters(parameters.Select(x => x.FieldValue).ToArray()); }