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