/// <summary> /// 加载参数 /// </summary> public static void BuildDBParameter(Database db, DbCommand dbCommand, params SqlParameter[] cmdParms) { foreach (SqlParameter sp in cmdParms) { db.AddInParameter(dbCommand, sp.ParameterName, sp.DbType,sp.Value); } }
public void AssignParameters(DbCommand command, object[] parameterValues) { InitializeParameters(command); db.SetParameterValue(command, "@CD_EMPRESA", parameterValues[0]); db.SetParameterValue(command, "@CD_SEQECF", parameterValues[1]); db.SetParameterValue(command, "@DT_EMI", parameterValues[2]); }
public virtual DbParameter AddParameter(DbCommand dm, string name, DbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value) { ////if (dbType == DbType.String) //// throw new Exception("请不要使用DbType.String进行数据库查询!"); if (CheckInjectAttackForSp(dm, value)) throw new Exception("输入的部分内容可能对系统稳定性造成影响,操作已停止![" + value + "]"); DbParameter param = this.ProviderFactory.CreateParameter(); if (param != null) { param.ParameterName = name; param.DbType = dbType; param.Size = size; param.Value = value ?? DBNull.Value; param.Direction = direction; param.IsNullable = nullable; param.SourceColumn = sourceColumn; param.SourceVersion = sourceVersion; dm.Parameters.Add(param); } return param; }
private void SetDynamicFilterParameterValues(DbCommand command, DbContext context) { if ((command == null) || (command.Parameters.Count == 0) || (context == null)) return; context.SetSqlParameters(command); }
internal DisposingDbDataReader(DbCommand command) { if (command == null) throw new ArgumentNullException("command"); this.command = command; reader = command.ExecuteReader(CommandBehavior.CloseConnection); }
public GlimpseDbDataReader(DbDataReader dataReader, DbCommand command, Guid connectionId, Guid commandId) { InnerDataReader = dataReader; InnerCommand = command; ConnectionId = connectionId; CommandId = commandId; }
private void InitializeParameters(DbCommand command) { if (!command.Parameters.Contains("@EmployeeId")) { _db.AddInParameter(command, "@EmployeeId", DbType.Int32); } }
// executes a command and returns the results as a DataTable object public static DataTable ExecuteSelectCommand(DbCommand command) { // The DataTable to be returned DataTable table; // Execute the command making sure the connection gets closed in the end try { // Open the data connection command.Connection.Open(); // Execute the command and save the results in a DataTable DbDataReader reader = command.ExecuteReader(); table = new DataTable(); table.Load(reader); // Close the reader reader.Close(); } catch (Exception ex) { Utilities.LogError(ex); throw; } finally { // Close the connection command.Connection.Close(); } return table; }
public static DataTable ReadTable(DbCommand cmd) { DataTable dt = new DataTable(); DbDataReader reader = null; try { reader = cmd.ExecuteReader(); int fieldc = reader.FieldCount; for (int i = 0; i < fieldc; i++) { DataColumn dc = new DataColumn(reader.GetName(i), reader.GetFieldType(i)); dt.Columns.Add(dc); } while (reader.Read()) { DataRow dr = dt.NewRow(); for (int i = 0; i < fieldc; i++) { dr[i] = reader[i]; } dt.Rows.Add(dr); } return dt; } finally { if (reader != null) reader.Close(); } }
public SqlDataSourceStatusEventArgs (DbCommand command, int rowsAffected, Exception exception) { this.command = command; this.rowsAffected = rowsAffected; this.exception = exception; this.exceptionHandled = false; }
/// <summary> /// Returns a DataSet (best used for multiple tables in the result set) /// </summary> /// <param name="command"></param> /// <returns></returns> /// <see cref=">http://msdn.microsoft.com/en-us/library/fks3666w%28VS.80%29.aspx" /> public static DataSet ExecuteMultipleTableSelectCommand(DbCommand command) { using (command) { var factory = DbProviderFactories.GetFactory(DataBaseConfigs.DbProviderName); using (var adapter = factory.CreateDataAdapter()) { if (adapter == null) return null; adapter.SelectCommand = command; using (var ds = new DataSet()) { try { adapter.Fill(ds); } catch (Exception ex) { Utilities.LogError(ex); return null; } command.Connection.Close(); return ds; } } } }
public static void AddWithValue(ref DbCommand command, string parameterName, object parameterValue) { var parameter = command.CreateParameter(); parameter.ParameterName = parameterName; parameter.Value = parameterValue; command.Parameters.Add(parameter); }
private void InitializeParameters(DbCommand command) { if (!command.Parameters.Contains("@CD_CLIFOR")) { db.AddInParameter(command, "@CD_CLIFOR", DbType.String); } }
// execute a select command and return a single result as a string public static string ExecuteScalar(DbCommand command) { // The value to be returned string value = ""; // Execute the command making sure the connection gets closed in the end try { // Open the connection of the command command.Connection.Open(); // Execute the command and get the number of affected rows value = command.ExecuteScalar().ToString(); } catch (Exception ex) { // Log eventual errors and rethrow them //Utilities.LogError(ex); throw ex; } finally { // Close the connection command.Connection.Close(); } // return the result return value; }
// execute an update, delete, or insert command // and return the number of affected rows public static int ExecuteNonQuery(DbCommand command) { // The number of affected rows int affectedRows = -1; // Execute the command making sure the connection gets closed in the end try { // Open the connection of the command command.Connection.Open(); // Execute the command and get the number of affected rows affectedRows = command.ExecuteNonQuery(); } catch (Exception ex) { // Log eventual errors and rethrow them //Utilities.LogError(ex); throw ex; } finally { // Close the connection command.Connection.Close(); } // return the number of affected rows return affectedRows; }
public static string GetSqlFromDbCommand(DbCommand dbCommand) { string strSql = dbCommand.CommandText; foreach (DbParameter dp in dbCommand.Parameters) { string strReplace = string.Empty; if (dp.Value == DBNull.Value) { strReplace = "NULL"; } else if (dp.DbType == DbType.Int32) { strReplace = string.Format("{0}", dp.Value); } else { strReplace = string.Format("'{0}'", dp.Value); } strSql = strSql.Replace(PARAMETER_NAME_PREFIX_AT + dp.ParameterName, strReplace); strSql = strSql.Replace(PARAMETER_NAME_PREFIX_COLON + dp.ParameterName, strReplace); } return strSql; }
internal TableManager(string tableName) { try { _da = TableManager._DbProviderFactory.CreateDataAdapter(); _cmd = TableManager._DbProviderFactory.CreateCommand(); DbCommandBuilder cb = TableManager._DbProviderFactory.CreateCommandBuilder(); cb.QuotePrefix = "["; cb.QuoteSuffix = "]"; _cmd.Connection = TableManager.Connection; cb.ConflictOption = ConflictOption.OverwriteChanges; cb.DataAdapter = _da; _dt = new DataTable(); _temp = new DataTable(); _dt.TableName = _temp.TableName = tableName; _cmd.CommandText = "Select * from " + Table.TableName; _da.SelectCommand = _cmd; _da.InsertCommand = cb.GetInsertCommand(); _da.DeleteCommand = cb.GetDeleteCommand(); _da.UpdateCommand = cb.GetUpdateCommand(); Recharge("1 = 2"); } catch { GlobalErrorCode = 13; } if (GlobalErrorCode == 13) MessageBox.Show("ОШИБКА"); }
public LoggingCommandWrapper(DbCommand dbCommand, ILogger logger) { Contract.Requires(dbCommand != null, nameof(dbCommand) + " is null."); Contract.Requires(logger != null, nameof(logger) + " is null."); _WrappedDbCommand = dbCommand; _Logger = logger; }
private DataTable GetReportData(DbCommand cmd, ArrayList parameterList) { db.AddInParameter(cmd, "p_patchDateS", DbType.String, parameterList[0]); db.AddInParameter(cmd, "p_patchDateE", DbType.String, parameterList[1]); db.AddInParameter(cmd, "p_signDate_S", DbType.String, parameterList[2]); db.AddInParameter(cmd, "p_signDate_E", DbType.String, parameterList[3]); db.AddInParameter(cmd, "p_acDate_S", DbType.String, parameterList[4]); db.AddInParameter(cmd, "p_acDate_E", DbType.String, parameterList[5]); db.AddInParameter(cmd, "p_groupS", DbType.String, parameterList[6]); db.AddInParameter(cmd, "p_groupE", DbType.String, parameterList[7]); db.AddInParameter(cmd, "p_payRfno", DbType.String, parameterList[8]); db.AddInParameter(cmd, "p_rfno", DbType.String, parameterList[9]); db.AddInParameter(cmd, "p_profit_S", DbType.String, parameterList[10]); db.AddInParameter(cmd, "p_profit_E", DbType.String, parameterList[11]); db.AddInParameter(cmd, "p_store_S", DbType.String, parameterList[12]); db.AddInParameter(cmd, "p_store_E", DbType.String, parameterList[13]); db.AddInParameter(cmd, "p_acUID", DbType.String, parameterList[14]); db.AddInParameter(cmd, "p_rootNo", DbType.String, parameterList[15]); db.AddInParameter(cmd, "p_item", DbType.String, parameterList[16]); db.AddInParameter(cmd, "p_periodS", DbType.String, parameterList[17]); db.AddInParameter(cmd, "p_periodE", DbType.String, parameterList[18]); db.AddInParameter(cmd, "p_checkReasonS", DbType.String, parameterList[19]); db.AddInParameter(cmd, "p_checkReasonE", DbType.String, parameterList[20]); db.AddInParameter(cmd, "p_descTypeS", DbType.String, parameterList[21]); db.AddInParameter(cmd, "p_descTypeE", DbType.String, parameterList[22]); db.AddInParameter(cmd, "p_diffTimes", DbType.String, parameterList[23]); db.AddInParameter(cmd, "p_diffAmount", DbType.String, parameterList[24]); db.AddInParameter(cmd, "p_diffSource", DbType.String, parameterList[25]); db.AddInParameter(cmd, "p_op1", DbType.String, ConvertOperator(parameterList[26].ToString())); db.AddInParameter(cmd, "p_op2", DbType.String, ConvertOperator(parameterList[27].ToString())); DataTable dt = db.ExecuteDataSet(cmd).Tables[0]; return dt; }
protected virtual void AddParametersFromCache(DbCommand command, Database database) { foreach (IDataParameter parameter in this.cache.GetCachedParameterSet(database.ConnectionString, command)) { command.Parameters.Add(parameter); } }
private void setupDbCommand( DbCommand dbCmd, DatabaseInfo databaseInfo ) { dbCmd.CommandText = sproc; dbCmd.CommandType = CommandType.StoredProcedure; foreach( var p in parameters ) dbCmd.Parameters.Add( p.GetAdoDotNetParameter( databaseInfo ) ); }
public void CreateAndCacheDbCommandParameters(string sqlCommandText, DbCommand command, string[] paramNames, DbType[] paramDbTypes, object[] paramValues) { lock (lockObject) { if (this.ParameterCache.IsCache(sqlCommandText)) { this.ParameterCache.AddParametersFromCache(sqlCommandText, command, paramDbTypes, paramValues); } else { if (this.ParameterCache.IsCache(sqlCommandText)) { this.ParameterCache.AddParametersFromCache(sqlCommandText, command, paramDbTypes, paramValues); } else { this.ParameterCache.CreateAndCacheParameters(sqlCommandText, command, paramNames, paramDbTypes, paramValues); } } } }
private static IDataParameter[] CreateParameterCopy(DbCommand command) { IDataParameterCollection parameters = command.Parameters; IDataParameter[] array = new IDataParameter[parameters.Count]; parameters.CopyTo(array, 0); return CachingMechanism.CloneParameters(array); }
public Manager(String fileName) { localization = new System.ComponentModel.ComponentResourceManager(typeof(WorkerTimeStrings)); this.fileName = fileName; if (File.Exists(fileName)) { this.sqlConnection = new SQLiteConnection("Data Source=" + fileName ); this.sqlCommand = this.sqlConnection.CreateCommand(); sqlConnection.Open(); } else { this.sqlConnection = new SQLiteConnection("Data Source=" + fileName); this.sqlCommand = this.sqlConnection.CreateCommand(); sqlConnection.Open(); ExecuteNonQuery("CREATE TABLE Tracks ([ID] INTEGER PRIMARY KEY AUTOINCREMENT, [ProjectID] INTEGER, [ActivityID] INTEGER, [Start] DATETIME, [End] DATETIME, [Duration] INTEGER)"); ExecuteNonQuery("CREATE TABLE Projects ([ID] INTEGER PRIMARY KEY AUTOINCREMENT, [Name] TEXT)"); ExecuteNonQuery("CREATE TABLE Activity ([ID] INTEGER PRIMARY KEY AUTOINCREMENT, [Name] TEXT, [ProjectID] INTEGER)"); if (MessageBox.Show(localization.GetString("String10"), localization.GetString("String3"), MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes ) { ExecuteNonQuery("INSERT INTO Projects (Name) VALUES ('" + localization.GetString("String12") + " 1')"); ExecuteNonQuery("INSERT INTO Projects (Name) VALUES ('" + localization.GetString("String12") + " 2')"); ExecuteNonQuery("INSERT INTO Projects (Name) VALUES ('" + localization.GetString("String12") + " 3')"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 1',1)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 2',1)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 3',1)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 1',2)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 2',2)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 3',2)"); } } Update1(); }
public override void NonQueryExecuting(DbCommand command, DbCommandInterceptionContext<int> interceptionContext) { if (command.Parameters.Count > 0 && command.Parameters[0].Value.ToString() == "Throw") { interceptionContext.Exception = new DataException("Exception Test"); } }
/// <summary> /// 为储存过程加载输出变量参数 /// </summary> /// <param name="db">database</param> /// <param name="dbCommand">db command</param> /// <param name="cmdParms">参数数组</param> public static void BuildDBParameterForReturnValue(Database db, DbCommand dbCommand, params IDataParameter[] cmdParms) { foreach (SqlParameter sp in cmdParms) { db.AddParameter(dbCommand, sp.ParameterName, sp.DbType, sp.Size, ParameterDirection.Output, false, 0, 0, sp.SourceColumn, DataRowVersion.Current, DBNull.Value); } }
/// <summary> /// Get a command for stored procedure /// </summary> /// <param name="pStoredProcedureName"></param> /// <returns></returns> public DbCommand CreateCommand(string pStoredProcedureName) { Command = CreateCommand(); Command.CommandType = CommandType.StoredProcedure; Command.CommandText = pStoredProcedureName; return Command; }
public void BindFixtureSymbols(Symbols symbols, DbCommand dc) { foreach (String paramName in ExtractParamNames(dc.CommandText)) { AddInput(dc, paramName, symbols.GetValueOrDefault(paramName, null)); } }
/// <summary> /// Tracks when 'command' is started. /// </summary> public void ExecuteStartImpl(DbCommand command, ExecuteType type) { var id = Tuple.Create((object)command, type); var sqlTiming = new SqlTiming(command, type, Profiler); _inProgress[id] = sqlTiming; }
protected void ProductDetailsViewSqlDataSource_Inserted(object sender, SqlDataSourceStatusEventArgs e) { System.Data.Common.DbCommand command = e.Command; ProductDetailsViewSqlDataSource.SelectParameters["ProductID"].DefaultValue = command.Parameters["@ProductID"].Value.ToString(); ProductGridView.DataBind(); ProductDetailsView.DataBind(); }
protected void DesignationDataSource_OnInserted(Object sender, SqlDataSourceStatusEventArgs e) { System.Data.Common.DbCommand command = e.Command; GridView GridView1Code = UpdatePanel2.FindControl("GridView1") as GridView; GridView1Code.DataBind(); ScriptManager.RegisterClientScriptBlock(GridView1Code, this.GetType(), "AlertMsg", "<script language='javascript'>$('html, body').animate({ scrollTop: $(document).height() }, 1000);</script>", false); SetDateRangesWhichCannotBeUsed(); UpdatePanel2.Update(); }
protected void SqlDataSourceFAQ_Inserted(object sender, SqlDataSourceStatusEventArgs e) { System.Data.Common.DbCommand command = e.Command; string IdFAQ = command.Parameters["@IdFAQ"].Value.ToString(); SqlDataSourceFAQReference.InsertParameters["IdQA"].DefaultValue = IdFAQ; GridView GridView1 = (GridView)DetailsView1.Rows[2].FindControl("GridView1"); for (int i = 0; i < GridView1.Rows.Count; i++) { GridViewRow Row = GridView1.Rows[i]; DropDownList DropDownList1 = ((DropDownList)Row.Cells[0].FindControl("DropDownList1")); if (DropDownList1.SelectedValue == "0") { continue; } Label Label1_ = ((Label)Row.Cells[0].FindControl("Label1_")); SqlDataSourceFAQReference.InsertParameters["IdReference"].DefaultValue = Label1_.Text; SqlDataSourceFAQReference.InsertParameters["IdReferenceData"].DefaultValue = DropDownList1.SelectedValue; SqlDataSourceFAQReference.Insert(); } ListView ListView1 = (ListView)DetailsView1.Rows[3].FindControl("ListView1"); SqlDataSourceFAQTags.InsertParameters["IdQA"].DefaultValue = IdFAQ; for (int i = 0; i < ListView1.Items.Count; i++) { ListViewItem Item = ListView1.Items[i]; CheckBox CheckBox1 = (CheckBox)Item.FindControl("CheckBox1"); Label IDLabel = ((Label)Item.FindControl("IDLabel")); if (!CheckBox1.Checked) { continue; } SqlDataSourceFAQTags.InsertParameters["IdTag"].DefaultValue = IDLabel.Text; SqlDataSourceFAQTags.Insert(); } }
protected void SqlDataSourceScenario_Inserted(object sender, SqlDataSourceStatusEventArgs e) { System.Data.Common.DbCommand command = e.Command; string IdScenario = command.Parameters["@IdScenario"].Value.ToString(); SqlDataSourceScenarioTypeClient.InsertParameters["IdScenario"].DefaultValue = IdScenario; ListView ListView1 = (ListView)DetailsView1.Rows[3].FindControl("ListView1"); for (int i = 0; i < ListView1.Items.Count; i++) { ListViewItem Item = ListView1.Items[i]; CheckBox CheckBox1 = (CheckBox)Item.FindControl("ActiveCheckBox"); HiddenField HiddenField1 = ((HiddenField)Item.FindControl("HiddenField1")); if (!CheckBox1.Checked) { continue; } SqlDataSourceScenarioTypeClient.InsertParameters["IdClientType"].DefaultValue = HiddenField1.Value; SqlDataSourceScenarioTypeClient.Insert(); } TextBox TextBox3 = (TextBox)DetailsView1.Rows[4].FindControl("TextBox3"); String[] Buttons = TextBox3.Text.ToString().Split(new Char [] { ',' }); for (int i = 0; i < Buttons.Length; i++) { string ButtonIVR = Buttons[i].Trim(); if (ButtonIVR != "") { SqlDataSourceIVR.InsertParameters["IdScenario"].DefaultValue = IdScenario; SqlDataSourceIVR.InsertParameters["Button"].DefaultValue = ButtonIVR; SqlDataSourceIVR.Insert(); } } }
public override DbCommandDefinition CreateCommandDefinition(DbCommand prototype) { return(new GlimpseDbCommandDefinition(InnerProviderServices.CreateCommandDefinition(prototype))); }
private int GetAllMenusCount() { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select count(*) from vshop_Menu"); return(1 + Convert.ToInt32(this.database.ExecuteScalar(sqlStringCommand))); }
private bool ExecuteTest() { this.errorMsgs = new System.Collections.Generic.List <string>(); System.Data.Common.DbTransaction dbTransaction = null; System.Data.Common.DbConnection dbConnection = null; string item; try { if (this.ValidateConnectionStrings(out item)) { System.Data.Common.DbConnection dbConnection2; dbConnection = (dbConnection2 = new System.Data.SqlClient.SqlConnection(this.GetConnectionString())); try { dbConnection.Open(); System.Data.Common.DbCommand dbCommand = dbConnection.CreateCommand(); dbTransaction = dbConnection.BeginTransaction(); dbCommand.Connection = dbConnection; dbCommand.Transaction = dbTransaction; dbCommand.CommandText = "CREATE TABLE installTest(Test bit NULL)"; dbCommand.ExecuteNonQuery(); dbCommand.CommandText = "DROP TABLE installTest"; dbCommand.ExecuteNonQuery(); dbTransaction.Commit(); dbConnection.Close(); goto IL_94; } finally { if (dbConnection2 != null) { ((System.IDisposable)dbConnection2).Dispose(); } } } this.errorMsgs.Add(item); IL_94 :; } catch (System.Exception ex) { this.errorMsgs.Add(ex.Message); if (dbTransaction != null) { try { dbTransaction.Rollback(); } catch (System.Exception ex2) { this.errorMsgs.Add(ex2.Message); } } if (dbConnection != null && dbConnection.State != System.Data.ConnectionState.Closed) { dbConnection.Close(); dbConnection.Dispose(); } } string folderPath = base.Request.MapPath(Globals.ApplicationPath + "/config/test.txt"); if (!Install.TestFolder(folderPath, out item)) { this.errorMsgs.Add(item); } try { Configuration configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(base.Request.ApplicationPath); if (configuration.ConnectionStrings.ConnectionStrings["HidistroSqlServer"].ConnectionString == "none") { configuration.ConnectionStrings.ConnectionStrings["HidistroSqlServer"].ConnectionString = "required"; } else { configuration.ConnectionStrings.ConnectionStrings["HidistroSqlServer"].ConnectionString = "none"; } configuration.Save(); } catch (System.Exception ex3) { this.errorMsgs.Add(ex3.Message); } folderPath = base.Request.MapPath(Globals.ApplicationPath + "/storage/test.txt"); if (!Install.TestFolder(folderPath, out item)) { this.errorMsgs.Add(item); } return(this.errorMsgs.Count == 0); }
protected override void DeriveParameters(System.Data.Common.DbCommand discoveryCommand) { throw new NotImplementedException(); }
public override System.Data.DataSet GetVotes() { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT *, (SELECT ISNULL(SUM(ItemCount),0) FROM distro_VoteItems WHERE VoteId = distro_Votes.VoteId) AS VoteCounts FROM distro_Votes WHERE DistributorUserId=@DistributorUserId"); this.database.AddInParameter(sqlStringCommand, "DistributorUserId", System.Data.DbType.Int32, HiContext.Current.User.UserId); return(this.database.ExecuteDataSet(sqlStringCommand)); }
public override int SetVoteIsBackup(long voteId) { System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("sub_Votes_IsBackup"); this.database.AddInParameter(storedProcCommand, "VoteId", System.Data.DbType.Int64, voteId); return(this.database.ExecuteNonQuery(storedProcCommand)); }
public override bool DeleteVoteItem(long voteId, System.Data.Common.DbTransaction dbTran) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM distro_VoteItems WHERE VoteId = @VoteId"); this.database.AddInParameter(sqlStringCommand, "VoteId", System.Data.DbType.Int64, voteId); return(this.database.ExecuteNonQuery(sqlStringCommand, dbTran) > 0); }
public override int GetVoteCounts(long voteId) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT ISNULL(SUM(ItemCount),0) FROM distro_VoteItems WHERE VoteId = @VoteId"); this.database.AddInParameter(sqlStringCommand, "VoteId", System.Data.DbType.Int64, voteId); return((int)this.database.ExecuteScalar(sqlStringCommand)); }
public override bool DistroHasDrawRequest() { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT COUNT(*) FROM Hishop_DistributorBalanceDrawRequest WHERE UserId=@UserId"); this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, HiContext.Current.User.UserId); return(Convert.ToInt32(this.database.ExecuteScalar(sqlStringCommand)) >= 1); }
public override void RemoveInpourRequest(string inpourId) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM Hishop_DistributorInpourRequest WHERE InpourId = @InpourId"); this.database.AddInParameter(sqlStringCommand, "InpourId", System.Data.DbType.String, inpourId); this.database.ExecuteNonQuery(sqlStringCommand); }
public override bool IsRecharge(string inpourId) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT COUNT(*) FROM Hishop_DistributorBalanceDetails WHERE InpourId = @InpourId"); this.database.AddInParameter(sqlStringCommand, "InpourId", System.Data.DbType.String, inpourId); return((int)this.database.ExecuteScalar(sqlStringCommand) > 0); }
public override void DeleteSiteRequest() { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM Hishop_SiteRequest WHERE UserId=@UserId"); this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, HiContext.Current.User.UserId); this.database.ExecuteNonQuery(sqlStringCommand); }
public override bool IsExitSiteUrl(string siteUrl) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT COUNT(*) FROM distro_Settings WHERE SiteUrl = @SiteUrl"); this.database.AddInParameter(sqlStringCommand, "SiteUrl", System.Data.DbType.String, siteUrl); return((int)this.database.ExecuteScalar(sqlStringCommand) > 0); }
public override void SetDefalutMemberGrade(int gradeId) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE aspnet_MemberGrades SET IsDefault = 0;UPDATE aspnet_MemberGrades SET IsDefault = 1 WHERE GradeId = @GradeId"); this.database.AddInParameter(sqlStringCommand, "GradeId", System.Data.DbType.Int32, gradeId); this.database.ExecuteNonQuery(sqlStringCommand); }
public bool DeleteMenu(int menuId) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE Weibo_Menu WHERE MenuId = @MenuId"); this.database.AddInParameter(sqlStringCommand, "MenuId", System.Data.DbType.Int32, menuId); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public int CreateCategory(CategoryInfo category) { System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_Category_Create"); this.database.AddOutParameter(storedProcCommand, "CategoryId", System.Data.DbType.Int32, 4); this.database.AddInParameter(storedProcCommand, "Name", System.Data.DbType.String, category.Name); this.database.AddInParameter(storedProcCommand, "SKUPrefix", System.Data.DbType.String, category.SKUPrefix); this.database.AddInParameter(storedProcCommand, "DisplaySequence", System.Data.DbType.Int32, category.DisplaySequence); if (!string.IsNullOrEmpty(category.IconUrl)) { this.database.AddInParameter(storedProcCommand, "IconUrl", System.Data.DbType.String, category.IconUrl); } if (!string.IsNullOrEmpty(category.MetaTitle)) { this.database.AddInParameter(storedProcCommand, "Meta_Title", System.Data.DbType.String, category.MetaTitle); } if (!string.IsNullOrEmpty(category.MetaDescription)) { this.database.AddInParameter(storedProcCommand, "Meta_Description", System.Data.DbType.String, category.MetaDescription); } if (!string.IsNullOrEmpty(category.MetaKeywords)) { this.database.AddInParameter(storedProcCommand, "Meta_Keywords", System.Data.DbType.String, category.MetaKeywords); } if (!string.IsNullOrEmpty(category.Notes1)) { this.database.AddInParameter(storedProcCommand, "Notes1", System.Data.DbType.String, category.Notes1); } if (!string.IsNullOrEmpty(category.Notes2)) { this.database.AddInParameter(storedProcCommand, "Notes2", System.Data.DbType.String, category.Notes2); } if (!string.IsNullOrEmpty(category.Notes3)) { this.database.AddInParameter(storedProcCommand, "Notes3", System.Data.DbType.String, category.Notes3); } if (!string.IsNullOrEmpty(category.Notes4)) { this.database.AddInParameter(storedProcCommand, "Notes4", System.Data.DbType.String, category.Notes4); } if (!string.IsNullOrEmpty(category.Notes5)) { this.database.AddInParameter(storedProcCommand, "Notes5", System.Data.DbType.String, category.Notes5); } if (category.ParentCategoryId.HasValue) { this.database.AddInParameter(storedProcCommand, "ParentCategoryId", System.Data.DbType.Int32, category.ParentCategoryId.Value); } else { this.database.AddInParameter(storedProcCommand, "ParentCategoryId", System.Data.DbType.Int32, 0); } if (category.AssociatedProductType.HasValue) { this.database.AddInParameter(storedProcCommand, "AssociatedProductType", System.Data.DbType.Int32, category.AssociatedProductType.Value); } if (!string.IsNullOrEmpty(category.RewriteName)) { this.database.AddInParameter(storedProcCommand, "RewriteName", System.Data.DbType.String, category.RewriteName); } this.database.AddInParameter(storedProcCommand, "FirstCommission", System.Data.DbType.String, category.FirstCommission); this.database.AddInParameter(storedProcCommand, "SecondCommission", System.Data.DbType.String, category.SecondCommission); this.database.AddInParameter(storedProcCommand, "ThirdCommission", System.Data.DbType.String, category.ThirdCommission); this.database.ExecuteNonQuery(storedProcCommand); return((int)this.database.GetParameterValue(storedProcCommand, "CategoryId")); }
internal GridReader(IDbCommand command, IDataReader reader, Identity identity, DynamicParameters dynamicParams, bool addToCache, CancellationToken cancel) : this(command, reader, identity, dynamicParams, addToCache) { this.cancel = cancel; }
public bool SetGradeDefault(int gradeid) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE aspnet_DistributorGrade set IsDefault=0 where GradeId<>@GradeId;UPDATE aspnet_DistributorGrade set IsDefault=1 where GradeId=@GradeId"); this.database.AddInParameter(sqlStringCommand, "GradeId", System.Data.DbType.Int32, gradeid); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public void ReaderExecuting(System.Data.Common.DbCommand command, DbCommandInterceptionContext <System.Data.Common.DbDataReader> interceptionContext) { LogSQLInfo(command, interceptionContext, "ReaderExecuting"); }
public void NonQueryExecuting(System.Data.Common.DbCommand command, DbCommandInterceptionContext <int> interceptionContext) { //LogSQLInfo(command, interceptionContext, "NonQueryExecuting"); }
public bool CreateShippingTemplate(FreightTemplate freightTemplate) { this.Error = ""; bool flag = false; System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select name from Hishop_FreightTemplate_Templates where name=@Name"); this.database.AddInParameter(sqlStringCommand, "Name", System.Data.DbType.String, freightTemplate.Name); System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand); bool result; if (!dataReader.Read()) { System.Data.Common.DbCommand sqlStringCommand2 = this.database.GetSqlStringCommand("INSERT INTO Hishop_FreightTemplate_Templates(Name,FreeShip,MUnit,HasFree)VALUES(@Name,@FreeShip,@MUnit,@HasFree)"); this.database.AddInParameter(sqlStringCommand2, "Name", System.Data.DbType.String, freightTemplate.Name); this.database.AddInParameter(sqlStringCommand2, "FreeShip", System.Data.DbType.Int16, freightTemplate.FreeShip); this.database.AddInParameter(sqlStringCommand2, "MUnit", System.Data.DbType.Int16, freightTemplate.MUnit); this.database.AddInParameter(sqlStringCommand2, "HasFree", System.Data.DbType.Int16, freightTemplate.HasFree); using (System.Data.Common.DbConnection dbConnection = this.database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { this.database.ExecuteNonQuery(sqlStringCommand2, dbTransaction); sqlStringCommand2 = this.database.GetSqlStringCommand("SELECT @@Identity"); object obj = this.database.ExecuteScalar(sqlStringCommand2, dbTransaction); int num = 0; if (obj != null && obj != DBNull.Value) { int.TryParse(obj.ToString(), out num); this.Error = num.ToString(); flag = (num > 0); } if (flag && !freightTemplate.FreeShip) { System.Data.Common.DbCommand sqlStringCommand3 = this.database.GetSqlStringCommand(" "); this.database.AddInParameter(sqlStringCommand3, "TemplateId", System.Data.DbType.Int32, num); if (freightTemplate.FreeShippings != null && freightTemplate.FreeShippings.Count > 0) { StringBuilder stringBuilder = new StringBuilder(); int num2 = 0; int num3 = 0; stringBuilder.Append("DECLARE @ERR INT; Set @ERR =0;"); stringBuilder.Append(" DECLARE @FreeId Int;"); foreach (FreeShipping current in freightTemplate.FreeShippings) { stringBuilder.Append(" INSERT INTO Hishop_FreightTemplate_FreeShipping(TemplateId,ModeId,ConditionNumber,ConditionType) VALUES( @TemplateId,").Append("@ModeId").Append(num2).Append(",@ConditionNumber").Append(num2).Append(",@ConditionType").Append(num2).Append("); SELECT @ERR=@ERR+@@ERROR;"); this.database.AddInParameter(sqlStringCommand3, "ModeId" + num2, System.Data.DbType.Int32, current.ModeId); this.database.AddInParameter(sqlStringCommand3, "ConditionNumber" + num2, System.Data.DbType.String, current.ConditionNumber); this.database.AddInParameter(sqlStringCommand3, "ConditionType" + num2, System.Data.DbType.Int32, current.ConditionType); stringBuilder.Append("Set @FreeId =@@identity;"); if (current.FreeShippingRegions != null) { foreach (FreeShippingRegion current2 in current.FreeShippingRegions) { stringBuilder.Append(" INSERT INTO Hishop_FreightTemplate_FreeShippingRegions(FreeId,TemplateId,RegionId) VALUES(@FreeId,@TemplateId,").Append("@RegionId").Append(num3).Append("); SELECT @ERR=@ERR+@@ERROR;"); this.database.AddInParameter(sqlStringCommand3, "RegionId" + num3, System.Data.DbType.Int32, current2.RegionId); num3++; } } num2++; } sqlStringCommand3.CommandText = stringBuilder.Append("SELECT @ERR;").ToString(); int num4 = (int)this.database.ExecuteScalar(sqlStringCommand3, dbTransaction); if (num4 != 0) { this.Error = "指定包邮信息部份有错误,请查检!"; dbTransaction.Rollback(); flag = false; } } if (flag && freightTemplate.SpecifyRegionGroups != null && freightTemplate.SpecifyRegionGroups.Count > 0) { sqlStringCommand3 = this.database.GetSqlStringCommand(" "); this.database.AddInParameter(sqlStringCommand3, "TemplateId", System.Data.DbType.Int32, num); StringBuilder stringBuilder = new StringBuilder(); int num2 = 0; int num3 = 0; stringBuilder.Append("DECLARE @ERR INT; Set @ERR =0;"); stringBuilder.Append(" DECLARE @GroupId Int;"); foreach (SpecifyRegionGroup current3 in freightTemplate.SpecifyRegionGroups) { stringBuilder.Append(" INSERT INTO Hishop_FreightTemplate_SpecifyRegionGroups(TemplateId,ModeId,FristNumber,FristPrice,AddNumber,AddPrice,IsDefault) VALUES(@TemplateId,").Append("@ModeId").Append(num2).Append(",@FristNumber").Append(num2).Append(",@FristPrice").Append(num2).Append(",@AddNumber").Append(num2).Append(",@AddPrice").Append(num2).Append(",@IsDefault").Append(num2).Append("); SELECT @ERR=@ERR+@@ERROR;"); this.database.AddInParameter(sqlStringCommand3, "ModeId" + num2, System.Data.DbType.Int16, current3.ModeId); this.database.AddInParameter(sqlStringCommand3, "FristNumber" + num2, System.Data.DbType.Decimal, current3.FristNumber); this.database.AddInParameter(sqlStringCommand3, "FristPrice" + num2, System.Data.DbType.Currency, current3.FristPrice); this.database.AddInParameter(sqlStringCommand3, "AddPrice" + num2, System.Data.DbType.Currency, current3.AddPrice); this.database.AddInParameter(sqlStringCommand3, "AddNumber" + num2, System.Data.DbType.Decimal, current3.AddNumber); this.database.AddInParameter(sqlStringCommand3, "IsDefault" + num2, System.Data.DbType.Int16, current3.IsDefault); stringBuilder.Append("Set @GroupId =@@identity;"); if (current3.SpecifyRegions != null) { foreach (SpecifyRegion current4 in current3.SpecifyRegions) { stringBuilder.Append(" INSERT INTO Hishop_FreightTemplate_SpecifyRegions(TemplateId,GroupId,RegionId) VALUES(@TemplateId,@GroupId").Append(",@RegionId").Append(num3).Append("); SELECT @ERR=@ERR+@@ERROR;"); this.database.AddInParameter(sqlStringCommand3, "RegionId" + num3, System.Data.DbType.Int32, current4.RegionId); num3++; } } num2++; } sqlStringCommand3.CommandText = stringBuilder.Append("SELECT @ERR;").ToString(); int num4 = (int)this.database.ExecuteScalar(sqlStringCommand3, dbTransaction); if (num4 != 0) { this.Error = "运送方式部份信息有错误,请查检!"; dbTransaction.Rollback(); flag = false; } } } dbTransaction.Commit(); } catch { if (dbTransaction.Connection != null) { dbTransaction.Rollback(); } flag = false; } finally { dbConnection.Close(); } } result = flag; } else { dataReader.Close(); result = false; } return(result); }
public void ScalarExecuting(System.Data.Common.DbCommand command, DbCommandInterceptionContext <object> interceptionContext) { LogSQLInfo(command, interceptionContext, "ScalarExecuting"); }
public bool UpdateShippingTemplate(FreightTemplate freightTemplate, string templateName) { bool result; if (freightTemplate.TemplateId == 0) { this.Error = "模板ID不存在!"; result = false; } else { bool flag = false; System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select name from Hishop_FreightTemplate_Templates where name=@Name and name<>@ReName"); this.database.AddInParameter(sqlStringCommand, "Name", System.Data.DbType.String, freightTemplate.Name); this.database.AddInParameter(sqlStringCommand, "ReName", System.Data.DbType.String, templateName); System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand); if (!dataReader.Read()) { StringBuilder stringBuilder = new StringBuilder("UPDATE Hishop_FreightTemplate_Templates SET Name=@Name,FreeShip=@FreeShip,MUnit=@MUnit,HasFree=@HasFree WHERE TemplateId=@TemplateId;"); System.Data.Common.DbCommand sqlStringCommand2 = this.database.GetSqlStringCommand(stringBuilder.ToString()); this.database.AddInParameter(sqlStringCommand2, "Name", System.Data.DbType.String, freightTemplate.Name); this.database.AddInParameter(sqlStringCommand2, "FreeShip", System.Data.DbType.Int16, freightTemplate.FreeShip); this.database.AddInParameter(sqlStringCommand2, "MUnit", System.Data.DbType.Int16, freightTemplate.MUnit); this.database.AddInParameter(sqlStringCommand2, "TemplateId", System.Data.DbType.Int32, freightTemplate.TemplateId); this.database.AddInParameter(sqlStringCommand2, "HasFree", System.Data.DbType.Int16, freightTemplate.HasFree); using (System.Data.Common.DbConnection dbConnection = this.database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { flag = (this.database.ExecuteNonQuery(sqlStringCommand2, dbTransaction) > 0); System.Data.Common.DbCommand sqlStringCommand3 = this.database.GetSqlStringCommand(" "); StringBuilder stringBuilder2 = new StringBuilder(); if (flag) { this.database.AddInParameter(sqlStringCommand3, "TemplateId", System.Data.DbType.Int32, freightTemplate.TemplateId); stringBuilder2.Append("delete from Hishop_FreightTemplate_SpecifyRegionGroups WHERE TemplateId=@TemplateId;"); stringBuilder2.Append("delete from Hishop_FreightTemplate_FreeShipping WHERE TemplateId=@TemplateId;"); stringBuilder2.Append("delete from Hishop_FreightTemplate_FreeShippingRegions WHERE TemplateId=@TemplateId;"); stringBuilder2.Append("delete from Hishop_FreightTemplate_SpecifyRegions WHERE TemplateId=@TemplateId;"); sqlStringCommand3.CommandText = stringBuilder2.ToString(); this.database.ExecuteNonQuery(sqlStringCommand3, dbTransaction); } if (flag && !freightTemplate.FreeShip) { if (freightTemplate.FreeShippings != null && freightTemplate.FreeShippings.Count > 0) { sqlStringCommand3 = this.database.GetSqlStringCommand(" "); this.database.AddInParameter(sqlStringCommand3, "TemplateId", System.Data.DbType.Int32, freightTemplate.TemplateId); stringBuilder2.Clear(); int num = 0; int num2 = 0; stringBuilder2.Append("DECLARE @ERR INT; Set @ERR =0;"); stringBuilder2.Append(" DECLARE @FreeId Int;"); foreach (FreeShipping current in freightTemplate.FreeShippings) { stringBuilder2.Append(" INSERT INTO Hishop_FreightTemplate_FreeShipping(TemplateId,ModeId,ConditionNumber,ConditionType) VALUES( @TemplateId,").Append("@ModeId").Append(num).Append(",@ConditionNumber").Append(num).Append(",@ConditionType").Append(num).Append("); SELECT @ERR=@ERR+@@ERROR;"); this.database.AddInParameter(sqlStringCommand3, "ModeId" + num, System.Data.DbType.Int32, current.ModeId); this.database.AddInParameter(sqlStringCommand3, "ConditionNumber" + num, System.Data.DbType.String, current.ConditionNumber); this.database.AddInParameter(sqlStringCommand3, "ConditionType" + num, System.Data.DbType.Int32, current.ConditionType); stringBuilder2.Append("Set @FreeId =@@identity;"); if (current.FreeShippingRegions != null) { foreach (FreeShippingRegion current2 in current.FreeShippingRegions) { stringBuilder2.Append(" INSERT INTO Hishop_FreightTemplate_FreeShippingRegions(FreeId,TemplateId,RegionId) VALUES(@FreeId,@TemplateId").Append(",@RegionId").Append(num2).Append("); SELECT @ERR=@ERR+@@ERROR;"); this.database.AddInParameter(sqlStringCommand3, "RegionId" + num2, System.Data.DbType.Int32, current2.RegionId); num2++; } } num++; } sqlStringCommand3.CommandText = stringBuilder2.Append("SELECT @ERR;").ToString(); int num3 = (int)this.database.ExecuteScalar(sqlStringCommand3, dbTransaction); if (num3 != 0) { dbTransaction.Rollback(); flag = false; } } if (flag && freightTemplate.SpecifyRegionGroups != null && freightTemplate.SpecifyRegionGroups.Count > 0) { sqlStringCommand3 = this.database.GetSqlStringCommand(" "); this.database.AddInParameter(sqlStringCommand3, "TemplateId", System.Data.DbType.Int32, freightTemplate.TemplateId); stringBuilder2.Clear(); int num = 0; int num2 = 0; stringBuilder2.Append("DECLARE @ERR INT; Set @ERR =0;"); stringBuilder2.Append(" DECLARE @GroupId Int;"); foreach (SpecifyRegionGroup current3 in freightTemplate.SpecifyRegionGroups) { stringBuilder2.Append(" INSERT INTO Hishop_FreightTemplate_SpecifyRegionGroups(TemplateId,ModeId,FristNumber,FristPrice,AddNumber,AddPrice,IsDefault) VALUES(@TemplateId,").Append("@ModeId").Append(num).Append(",@FristNumber").Append(num).Append(",@FristPrice").Append(num).Append(",@AddNumber").Append(num).Append(",@AddPrice").Append(num).Append(",@IsDefault").Append(num).Append("); SELECT @ERR=@ERR+@@ERROR;"); this.database.AddInParameter(sqlStringCommand3, "ModeId" + num, System.Data.DbType.Int16, current3.ModeId); this.database.AddInParameter(sqlStringCommand3, "FristNumber" + num, System.Data.DbType.Decimal, current3.FristNumber); this.database.AddInParameter(sqlStringCommand3, "FristPrice" + num, System.Data.DbType.Currency, current3.FristPrice); this.database.AddInParameter(sqlStringCommand3, "AddPrice" + num, System.Data.DbType.Currency, current3.AddPrice); this.database.AddInParameter(sqlStringCommand3, "AddNumber" + num, System.Data.DbType.Decimal, current3.AddNumber); this.database.AddInParameter(sqlStringCommand3, "IsDefault" + num, System.Data.DbType.Int16, current3.IsDefault); stringBuilder2.Append("Set @GroupId =@@identity;"); if (current3.SpecifyRegions != null) { foreach (SpecifyRegion current4 in current3.SpecifyRegions) { stringBuilder2.Append(" INSERT INTO Hishop_FreightTemplate_SpecifyRegions(TemplateId,GroupId,RegionId) VALUES(@TemplateId,@GroupId").Append(",@RegionId").Append(num2).Append("); SELECT @ERR=@ERR+@@ERROR;"); this.database.AddInParameter(sqlStringCommand3, "RegionId" + num2, System.Data.DbType.Int32, current4.RegionId); num2++; } } num++; } sqlStringCommand3.CommandText = stringBuilder2.Append("SELECT @ERR;").ToString(); int num3 = (int)this.database.ExecuteScalar(sqlStringCommand3, dbTransaction); if (num3 != 0) { dbTransaction.Rollback(); flag = false; } } } if (flag) { dbTransaction.Commit(); } else { dbTransaction.Rollback(); } } catch { if (dbTransaction.Connection != null) { dbTransaction.Rollback(); } flag = false; } finally { dbConnection.Close(); } } result = flag; } else { dataReader.Close(); result = false; } } return(result); }
public FreightTemplate GetFreightTemplate(int templateId, bool includeDetail) { FreightTemplate freightTemplate = new FreightTemplate(); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(" SELECT * FROM Hishop_FreightTemplate_Templates Where TemplateId =@TemplateId"); if (includeDetail) { System.Data.Common.DbCommand expr_24 = sqlStringCommand; expr_24.CommandText += " SELECT * FROM Hishop_FreightTemplate_FreeShipping g,vw_Hishop_FreightTemplate_FreeShippingRegions r Where g.FreeId=r.FreeId and TemplateId =@TemplateId"; System.Data.Common.DbCommand expr_3B = sqlStringCommand; expr_3B.CommandText += " SELECT g.*,r.RegionIds FROM Hishop_FreightTemplate_SpecifyRegionGroups g LEFT JOIN vw_Hishop_FreightTemplate_SpecifyRegions r on (g.GroupId=r.GroupId) where g.TemplateId =@TemplateId"; } this.database.AddInParameter(sqlStringCommand, "TemplateId", System.Data.DbType.Int32, templateId); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { if (dataReader.Read()) { if (dataReader["TemplateId"] != DBNull.Value) { freightTemplate.TemplateId = (int)dataReader["TemplateId"]; } freightTemplate.Name = (string)dataReader["Name"]; freightTemplate.FreeShip = (bool)dataReader["FreeShip"]; freightTemplate.HasFree = (bool)dataReader["HasFree"]; freightTemplate.MUnit = (int)((byte)dataReader["MUnit"]); } if (includeDetail) { dataReader.NextResult(); freightTemplate.FreeShippings = new List <FreeShipping>(); while (dataReader.Read()) { FreeShipping freeShipping = new FreeShipping(); freeShipping.TemplateId = (int)dataReader["TemplateId"]; freeShipping.ModeId = (int)((byte)dataReader["ModeId"]); freeShipping.FreeId = (int)((decimal)dataReader["FreeId"]); freeShipping.ConditionNumber = (string)dataReader["ConditionNumber"]; freeShipping.ConditionType = (int)((byte)dataReader["ConditionType"]); freeShipping.RegionIds = (string)dataReader["RegionIds"]; freightTemplate.FreeShippings.Add(freeShipping); } dataReader.NextResult(); freightTemplate.SpecifyRegionGroups = new List <SpecifyRegionGroup>(); while (dataReader.Read()) { SpecifyRegionGroup specifyRegionGroup = new SpecifyRegionGroup(); specifyRegionGroup.TemplateId = (int)dataReader["TemplateId"]; specifyRegionGroup.GroupId = (int)dataReader["GroupId"]; specifyRegionGroup.FristNumber = (decimal)dataReader["FristNumber"]; specifyRegionGroup.FristPrice = (decimal)dataReader["FristPrice"]; specifyRegionGroup.AddNumber = (decimal)dataReader["AddNumber"]; specifyRegionGroup.AddPrice = (decimal)dataReader["AddPrice"]; specifyRegionGroup.ModeId = (int)((byte)dataReader["ModeId"]); specifyRegionGroup.IsDefault = (bool)dataReader["IsDefault"]; string regionIds = ""; if (DBNull.Value != dataReader["RegionIds"]) { regionIds = (string)dataReader["RegionIds"]; } specifyRegionGroup.RegionIds = regionIds; freightTemplate.SpecifyRegionGroups.Add(specifyRegionGroup); } } } return(freightTemplate); }
public bool DeleteShippingTemplate(int templateId) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM Hishop_FreightTemplate_Templates Where TemplateId=@TemplateId"); this.database.AddInParameter(sqlStringCommand, "TemplateId", System.Data.DbType.Int32, templateId); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public override bool DeleteMemberGrade(int gradeId) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM aspnet_MemberGrades WHERE GradeId = @GradeId AND IsDefault = 0 AND NOT EXISTS(SELECT * FROM aspnet_Members WHERE GradeId = @GradeId)"); this.database.AddInParameter(sqlStringCommand, "GradeId", System.Data.DbType.Int32, gradeId); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
private static void PrepareCommand( DbCommand command, DbConnection connection, DbTransaction transaction, CommandType commandType, string commandText, DbParameter[] commandParameters) { if (command == null) throw new ArgumentNullException("command"); if (commandText == null || commandText.Length == 0) throw new ArgumentNullException("commandText"); command.Connection = connection; command.CommandText = commandText; command.CommandType = commandType; if (transaction != null) { if (transaction.Connection == null) throw new ArgumentException("The transaction was rollbacked or commited, please provide an open transaction.", "transaction"); command.Transaction = transaction; } if (commandParameters != null) { AttachParameters(command, commandParameters); } return; }