protected SqlDataBaseService.SQLHelper ObjectToDeleteSQlHelper(object obj, string key, object whereValue)
{
SqlDataBaseService.objectUlits.ObjectResolverManage manage;
string str;
List <SqlDataBaseService.objectUlits.ClassFiledInfo> list;
SqlDataBaseService.SQLHelper helper;
StringBuilder builder;
SqlDataBaseService.SQLHelper helper2;
manage = SqlDataBaseService.objectUlits.ObjectResolverManage.GetInstance();
str = manage.GetTableName(obj);
list = manage.GetTableColumnsInfo(obj);
helper = new SqlDataBaseService.SQLHelper("delete " + str + " ", Array.Empty <object>());
builder = new StringBuilder();
helper.Append(builder.ToString(), Array.Empty <object>());
helper.Append(" where " + key + "=@" + key, Array.Empty <object>());
helper.AddParameter(whereValue);
helper2 = helper;
Label_0076:
return(helper2);
}
protected SQLHelper ObjectToUpdataSQlHelper(object obj, string key, object whereValue)
{
ObjectResolverManage manage;
string str;
List <SqlDataBaseService.objectUlits.ClassFiledInfo> list;
SqlDataBaseService.SQLHelper helper;
StringBuilder builder;
int num;
List <SqlDataBaseService.objectUlits.ClassFiledInfo> .Enumerator enumerator;
SqlDataBaseService.objectUlits.ClassFiledInfo info;
object obj2;
bool flag;
SqlDataBaseService.SQLHelper helper2;
manage = SqlDataBaseService.objectUlits.ObjectResolverManage.GetInstance();
str = manage.GetTableName(obj);
list = manage.GetTableColumnsInfo(obj);
helper = new SqlDataBaseService.SQLHelper("updata " + str + " set ", Array.Empty <object>());
builder = new StringBuilder();
num = 0;
enumerator = list.GetEnumerator();
Label_0045:
try
{
goto Label_00C6;
Label_0047:
info = &enumerator.Current;
if ((num == 0) == null)
{
goto Label_0080;
}
builder.Append(info.ColunmName + "=@" + info.ColunmName);
goto Label_00A7;
Label_0080:
builder.Append("," + info.ColunmName + "=@" + info.ColunmName);
Label_00A7:
obj2 = info.MpropertyInfo.GetValue(obj);
helper.AddParameter(obj2);
num += 1;
Label_00C6:
if (&enumerator.MoveNext() != null)
{
goto Label_0047;
}
goto Label_00E3;
}
finally
{
Label_00D4:
&enumerator.Dispose();
}
Label_00E3:
helper.Append(builder.ToString(), Array.Empty <object>());
helper.Append(" where " + key + "=@" + key, Array.Empty <object>());
helper.AddParameter(whereValue);
helper2 = helper;
Label_0120:
return(helper2);
}
protected unsafe SqlDataBaseService.SQLHelper ObjectToInsertSQlHelper(object obj)
{
SqlDataBaseService.objectUlits.ObjectResolverManage manage;
string str;
List <SqlDataBaseService.objectUlits.ClassFiledInfo> list;
SqlDataBaseService.SQLHelper helper;
StringBuilder builder;
StringBuilder builder2;
int num;
List <SqlDataBaseService.objectUlits.ClassFiledInfo> .Enumerator enumerator;
SqlDataBaseService.objectUlits.ClassFiledInfo info;
object obj2;
bool flag;
SqlDataBaseService.SQLHelper helper2;
manage = SqlDataBaseService.objectUlits.ObjectResolverManage.GetInstance();
str = manage.GetTableName(obj);
list = manage.GetTableColumnsInfo(obj);
helper = new SqlDataBaseService.SQLHelper("insert into " + str, Array.Empty <object>());
builder = new StringBuilder();
builder2 = new StringBuilder();
num = 0;
enumerator = list.GetEnumerator();
Label_0047:
try
{
goto Label_00E0;
Label_004C:
info = &enumerator.Current;
if ((num == 0) == null)
{
goto Label_008D;
}
builder2.Append(info.ColunmName);
builder.Append("@" + info.ColunmName);
goto Label_00C1;
Label_008D:
builder2.Append("," + info.ColunmName);
builder.Append(",@" + info.ColunmName);
Label_00C1:
obj2 = info.MpropertyInfo.GetValue(obj);
helper.AddParameter(obj2);
num += 1;
Label_00E0:
if (&enumerator.MoveNext() != null)
{
goto Label_004C;
}
goto Label_00FD;
}
finally
{
Label_00EE:
&enumerator.Dispose();
}
Label_00FD:
builder2.Insert(0, "(");
builder2.Insert(builder2.Length, ")");
builder.Insert(0, "values(");
builder.Insert(builder.Length, ")");
helper.Append(builder2.ToString(), Array.Empty <object>());
helper.Append(builder.ToString(), Array.Empty <object>());
helper2 = helper;
Label_016C:
return(helper2);
}
