protected SQLHelper ObjectToInsertSQlHelper(object obj)
{
ObjectResolverManage manage = ObjectResolverManage.GetInstance();
List <ClassFiledInfo> list = manage.GetTableColumnsInfo(obj);
string tableName = manage.GetTableName(obj);
SQLHelper helper = new SQLHelper("insert into " + tableName + "(");
int index = 0;
StringBuilder sb_valueFlag = new StringBuilder();
foreach (ClassFiledInfo info in list)
{
if (index < 1)
{
sb_valueFlag.Append("@" + info.ColunmName);
helper.Append(info.ColunmName, info.MpropertyInfo.GetValue(obj));
}
else
{
sb_valueFlag.Append(",@" + info.ColunmName);
helper.Append("," + info.ColunmName, info.MpropertyInfo.GetValue(obj));
}
index++;
}
helper.Append(")values(");
helper.Append(sb_valueFlag.ToString());
helper.Append(")");
return(helper);
}
protected SQLHelper ObjectToDeleteSQlHelper(object obj, string key, object whereValue)
{
ObjectResolverManage manage = ObjectResolverManage.GetInstance();
List <ClassFiledInfo> list = manage.GetTableColumnsInfo(obj);
SQLHelper helper = new SQLHelper("delete " + manage.GetTableName(obj) + " ");
helper.Append(" where " + key + "=@" + key);
helper.AddParameter(whereValue);
return(helper);
}
/// <summary>
/// 将实体对象转换为sql中的更新语句
/// </summary>
/// <param name="obj"></param>
/// <param name="key"></param>
/// <param name="whereValue"></param>
/// <returns></returns>
protected SQLHelper ObjectToUpdataSQlHelper(object obj, string key, object whereValue)
{
ObjectResolverManage manage = ObjectResolverManage.GetInstance();
List <ClassFiledInfo> list = manage.GetTableColumnsInfo(obj);
StringBuilder builder = new StringBuilder();
SQLHelper helper = new SQLHelper("updata " + manage.GetTableName(obj) + " set ");
int num = 0;
foreach (ClassFiledInfo info in list)
{
if (num < 1)
{
helper.Append(info.ColunmName + "=@" + info.ColunmName, info.ColunmValue);
}
else
{
helper.Append("," + info.ColunmName + "=@" + info.ColunmName, info.ColunmValue);
}
}
helper.Append(" where " + key + "=@" + key, whereValue);
return(helper);
}
protected unsafe SQLHelper ObjectToInsertSQlHelper(object obj)
{
ObjectResolverManage manage = ObjectResolverManage.GetInstance();
List <ClassFiledInfo> list = manage.GetTableColumnsInfo(obj);
string tableName = manage.GetTableName(obj);
SQLHelper helper = new SQLHelper("insert into " + tableName + "(");
int index = 0;
foreach (ClassFiledInfo info in list)
{
if (index < 1)
{
helper.Append(info.ColunmName, info.ColunmValue);
}
else
{
helper.Append("," + info.ColunmName, info.ColunmValue);
}
}
helper.Append(")values(");
helper.Append(")");
return(helper);
}
