/// <summary> /// Insert语句生成 /// </summary> /// <typeparam name="T">Model泛型</typeparam> /// <typeparam name="P">sql参数类型,SqlParameter/OracleParameter</typeparam> /// <param name="model">实例</param> /// <param name="parameterList">参数数组</param> /// <returns>Insert语句</returns> public string InsertSqlGenerate <T>(T model, ref List <DbParameter> parameterList) { string cacheSQL = SQLDataCache.GetHashTableData(model, CRUDEnum.INSERT); string result = string.Empty; if (!string.IsNullOrEmpty(cacheSQL)) { result = cacheSQL; } else { result = "insert into {0}({2}) values({1})"; result = string.Format(result, TableGenerator.Table <T>(), ParameterGenerator.ParameterString <T>(), TableGenerator.AllColumn <T>()); } List <DbParameter> paramList = SQLDataCache.GetParameterCacheData <DbParameter>(model);; if (paramList == null) { parameterList = ParameterGenerator.ParametersArray <T>(model); SQLDataCache.ModelParameterPush <DbParameter>(model, parameterList); } else { parameterList.AddRange(paramList.ToArray()); ParameterGenerator.ModelValueToParamListPush(parameterList, model); } return(result); }
/// <summary> /// 生成删除语句 /// </summary> /// <typeparam name="T">泛型T Model</typeparam> /// <param name="model">实例</param> /// <param name="parameter">参数数组</param> /// <returns></returns> public string DeleteSqlGenerate <T>(T model, ref DbParameter parameter) { string cacheSQL = SQLDataCache.GetHashTableData(model, CRUDEnum.DELETE); string result = string.Empty; if (!string.IsNullOrEmpty(cacheSQL)) { result = cacheSQL; } else { result = "delete from {0} where {1} = {2}"; result = string.Format(result, TableGenerator.Table <T>(), ParameterGenerator.ParameterString <T>(), TableGenerator.AllColumn <T>()); } List <DbParameter> paramList = SQLDataCache.GetParameterCacheData <DbParameter>(model); parameter = paramList != null?paramList.ToArray()[0] : ParameterGenerator.KeyParameterArray <T>(model); // 从缓存中取出后需对键列重新赋值 parameter.Value = model.GetType().GetProperty(parameter.ParameterName).GetValue(model, null); return(result); }