public string GetCVS <T>(List <T> objList)
{
if (objList == null)
{
return("");
}
var sl = ObjectListHelper.GetValidTypePropertyList(typeof(T), typeof(ReportOutputIgnore));
var s = "";
sl.ForEach(v => s += (v + ","));
s += "\r\n";
objList.ForEach(v =>
{
foreach (var p in sl)
{
var value = v.GetType().GetProperty(p).GetValue(v);
if (value != null)
{
s += value.ToString() + ",";
}
else
{
s += ",";
}
}
s += "\r\n";
});
return(s);
}
public string CreateInertSql(string tbName, object data, Type dataType = null)
{
if (data == null)
{
return(null);
}
if (dataType == null)
{
dataType = data.GetType();
}
StringBuilder sql = new StringBuilder();
sql.Append(string.Format("INSERT INTO {0}(", tbName));
var sl = ObjectListHelper.GetValidTypePropertyList(dataType, typeof(ReportOutputIgnore));
var hs = "";
sl.ForEach(v => hs += (v + ","));
hs = FixKeyWordColumn(hs);
sql.Append(hs);
sql.Append(")");
sql.Append(" VALUES ");
var vs = "";
vs += "(";
for (int i = 0; i < sl.Count; i++)
{
var valueString = "";
var value = dataType.GetProperty(sl[i]).GetValue(data);
if (value == null)
{
valueString = GetDefaultValue(data.GetType().GetProperty(sl[i]));
}
else
{
valueString = value.ToString();
}
if (IsNeedQuotation(data.GetType().GetProperty(sl[i])))
{
valueString = "'" + valueString + "'";
}
if (i != sl.Count - 1)
{
valueString += ",";
}
vs += valueString;
}
vs += ")";
sql.Append(vs);
return(sql.ToString());
}
public string CreateInertSql(string tbName, List <object> ObjectList)
{
if (ObjectList == null || ObjectList.Count == 0)
{
return(null);
}
var o = ObjectList.FirstOrDefault();
var objType = o.GetType();
StringBuilder sql = new StringBuilder();
sql.Append(string.Format("INSERT INTO {0}(", tbName));
var sl = ObjectListHelper.GetValidTypePropertyList(objType, typeof(ReportOutputIgnore));
var hs = "";
sl.ForEach(v => hs += (v + ","));
hs = FixKeyWordColumn(hs);
sql.Append(hs);
sql.Append(")");
sql.Append(" VALUES ");
var vs = "";
ObjectList.ForEach(v =>
{
try
{
vs += "(";
for (int i = 0; i < sl.Count; i++)
{
var valueString = "";
var value = v.GetType().GetProperty(sl[i]).GetValue(v);
if (value == null)
{
valueString = GetDefaultValue(v.GetType().GetProperty(sl[i]));
}
else
{
valueString = value.ToString();
}
if (IsNeedQuotation(v.GetType().GetProperty(sl[i])))
{
valueString = "'" + valueString + "'";
}
if (i != sl.Count - 1)
{
valueString += ",";
}
vs += valueString;
}
vs += "),";
}
catch (Exception ex)
{
LogSupport.Error(ex);
}
});
sql.Append(vs.Substring(0, vs.Length - 1));
return(sql.ToString());
}
public string CreateUpdateSql(string tbName, object data, string conditions, Type dataType = null)
{
if (data == null)
{
return(null);
}
if (dataType == null)
{
dataType = data.GetType();
}
if (string.IsNullOrEmpty(conditions))
{
return(null);
}
StringBuilder sql = new StringBuilder();
sql.Append(string.Format("Update {0} ", tbName));
var sl = ObjectListHelper.GetValidTypePropertyList(dataType, typeof(ReportOutputIgnore));
var vs = "";
vs += "(";
for (int i = 0; i < sl.Count; i++)
{
var cs = sl[i];
if (IsColumnNameNeedBracket(cs))
{
cs = "[" + cs + "]";
}
var s = cs + "=";
var valueString = "";
var value = dataType.GetProperty(sl[i]).GetValue(data);
if (value == null)
{
valueString = valueString + GetDefaultValue(data.GetType().GetProperty(sl[i]));
}
else
{
valueString = value.ToString();
}
if (IsNeedQuotation(data.GetType().GetProperty(sl[i])))
{
valueString = "'" + valueString + "'";
}
s = s + valueString;
if (i != sl.Count - 1)
{
s += ",";
}
vs += s;
}
vs += ")";
sql.Append(vs);
conditions = conditions.Trim();
if (!conditions.StartsWith("where", StringComparison.CurrentCultureIgnoreCase))
{
conditions = " where " + conditions;
}
else
{
conditions = " " + conditions;
}
sql.Append(conditions);
return(sql.ToString());
}