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); }