public string GetSql(object[] d, IGatherDB db)
{
decimal[] ids = db.GetSystemID(1);
string sql = string.Empty;
sql = sql + string.Format("insert into {0}", this.reportName) + GetColoums() + " values " + GetValues(ids[0], d) + ";";
return(sql);
}
public string GetSql(List <object[]> list, IGatherDB db)
{
string sql = string.Empty;
int len = list.Count;
decimal[] ids = db.GetSystemID(len);
for (int i = 0; i < len; i++)
{
sql = sql + string.Format("insert into {0}", this.reportName) + GetColoums() + " values " + GetValues(ids[i], list[i]) + ";";
}
return(sql);
}
public string GetSql(List<object[]> list,IGatherDB db)
{
string sql = string.Empty;
int len = list.Count;
decimal[] ids = db.GetSystemID(len);
for (int i = 0; i < len; i++)
{
sql = sql + string.Format("insert into {0}", this.reportName) + GetColoums() + " values " + GetValues(ids[i],list[i]) + ";";
}
return sql;
}
public string GetSql(object[] d,IGatherDB db)
{
decimal[] ids = db.GetSystemID(1);
string sql = string.Empty;
sql = sql + string.Format("insert into {0}", this.reportName) + GetColoums() + " values " + GetValues(ids[0],d) + ";";
return sql;
}