protected void setParaCollection4CmdInsertLog(System.Data.SqlClient.SqlCommand i_Cmd, decimal i_dc_id_nguoi_dung, string i_str_ten_tham_so) { System.Data.DataColumn v_Column = default(System.Data.DataColumn); System.Data.DataRow v_Row = default(System.Data.DataRow); System.Data.SqlClient.SqlParameter v_Para = default(System.Data.SqlClient.SqlParameter); v_Row = m_ds.Tables[m_TableName].Rows[0]; CProperty v_Property = new CProperty(); foreach (System.Data.DataColumn tempLoopVar_v_Column in m_ds.Tables[m_TableName].Columns) { v_Column = tempLoopVar_v_Column; v_Property.SetValues(v_Column.DataType, v_Column.ColumnName); //tao cac tham so truyen vao cho Stored Procedure v_Para = v_Property.CreateSQLValuePara(); //v_Para.Value = v_Row(v_Property.getName()) set_value_4_para(v_Para, v_Property, v_Row); i_Cmd.Parameters.Add(v_Para); } //' LinhDH 09/12/2012: Add parameter có insert Log v_Property.SetValues(Type.GetType("Decimal"), i_str_ten_tham_so); //tao cac tham so truyen vao cho Stored Procedure v_Para = v_Property.CreateSQLValuePara(); //v_Para.Value = v_Row(v_Property.getName()) set_value_4_paraInsertLog(v_Para, v_Property, i_dc_id_nguoi_dung); i_Cmd.Parameters.Add(v_Para); }
public System.Data.SqlClient.SqlCommand getDeleteCommand() { System.Data.SqlClient.SqlCommand v_Cmd = new System.Data.SqlClient.SqlCommand(); System.Data.DataColumn v_Column = default(System.Data.DataColumn); System.Data.DataRow v_Row = default(System.Data.DataRow); System.Data.SqlClient.SqlParameter v_Para = default(System.Data.SqlClient.SqlParameter); v_Row = m_ds.Tables[m_TableName].Rows[0]; CProperty v_Property = new CProperty(); foreach (System.Data.DataColumn tempLoopVar_v_Column in m_ds.Tables[m_TableName].PrimaryKey) { v_Column = tempLoopVar_v_Column; v_Property.SetValues(v_Column.DataType, v_Column.ColumnName); v_Para = v_Property.CreateSQLValuePara(); v_Para.Value = v_Row[v_Property.getName()]; v_Cmd.Parameters.Add(v_Para); } //Gan cac thuoc tinh cua command v_Cmd.Connection = m_cnn; v_Cmd.CommandType = CommandType.StoredProcedure; v_Cmd.CommandText = c_PRPrefix + m_TableName + "_Delete"; return v_Cmd; }
protected void setParaCollection4Cmd(System.Data.SqlClient.SqlCommand i_Cmd) { System.Data.DataColumn v_Column = default(System.Data.DataColumn); System.Data.DataRow v_Row = default(System.Data.DataRow); System.Data.SqlClient.SqlParameter v_Para = default(System.Data.SqlClient.SqlParameter); v_Row = m_ds.Tables[m_TableName].Rows[0]; CProperty v_Property = new CProperty(); foreach (System.Data.DataColumn tempLoopVar_v_Column in m_ds.Tables[m_TableName].Columns) { v_Column = tempLoopVar_v_Column; v_Property.SetValues(v_Column.DataType, v_Column.ColumnName); //tao cac tham so truyen vao cho Stored Procedure v_Para = v_Property.CreateSQLValuePara(); //v_Para.Value = v_Row(v_Property.getName()) set_value_4_para(v_Para, v_Property, v_Row); i_Cmd.Parameters.Add(v_Para); } //i_Cmd.Parameters.Add(getErrorParameter()) }