public DataTable ExecDataSet(string pSql, ParamStruct[] pParameterArray) { SqlConnection vCon = new SqlConnection(_glCadenaConexion); SqlCommand vCmd = new SqlCommand(pSql, vCon); vCmd.CommandType = CommandType.StoredProcedure; if (pParameterArray != null) { for (int i = 0; i < pParameterArray.Length; i++) { ParamStruct vParam = pParameterArray[i]; IDbDataParameter vPm = GetParameter(vParam.ParamName, vParam.direction, vParam.value, vParam.DataType, vParam.sourceColumn, vParam.size); vCmd.Parameters.Add(vPm); } } vCon.Open(); DataSet vDs = new DataSet(); SqlDataAdapter vDa = new SqlDataAdapter(); vDa.SelectCommand = vCmd; vDa.Fill(vDs); vCon.Close(); if (vDs != null & vDs.Tables.Count > 0) return vDs.Tables[0]; else return null; }
public void sp_Save_RMOrder(int pID, string pOrderNumber, string pCustomerName, string pDeliveryAddress, DateTime pOrderDate) { ParamStruct[] vParam = new ParamStruct[5]; vParam[0].ParamName = "@Id"; vParam[0].DataType = DbType.Int32; vParam[0].value = pID; vParam[1].ParamName = "@OrderNumber"; vParam[1].DataType = DbType.String; vParam[1].value = pOrderNumber; vParam[2].ParamName = "@CustomerName"; vParam[2].DataType = DbType.String; vParam[2].value = pCustomerName; vParam[3].ParamName = "@DeliveryAddress"; vParam[3].DataType = DbType.String; vParam[3].value = pDeliveryAddress; vParam[4].ParamName = "@OrderDate"; vParam[4].DataType = DbType.DateTime; vParam[4].value = pOrderDate; _ConfigurationManager.ExecSql("sp_Save_RMOrder", vParam); }
public DataTable sp_Get_RMOrder_ID(int pId) { ParamStruct[] vParam = new ParamStruct[1]; vParam[0].ParamName = "@Id"; vParam[0].DataType = DbType.Int32; vParam[0].value = pId; return _ConfigurationManager.ExecDataSet("sp_Get_RMOrder_ID", vParam); }
public void sp_Delete_Order(int pID) { ParamStruct[] vParam = new ParamStruct[1]; vParam[0].ParamName = "@OrderId"; vParam[0].DataType = DbType.Int32; vParam[0].value = pID; _ConfigurationManager.ExecDataSet("sp_Delete_Order", vParam); }
public DataTable sp_Get_RMUser_Email(string pEmail) { ParamStruct[] vParam = new ParamStruct[1]; vParam[0].ParamName = "@Email"; vParam[0].DataType = DbType.String; vParam[0].value = pEmail; return _ConfigurationManager.ExecDataSet("sp_Get_RMUser_Email", vParam); }
public void sp_Save_RMUser(string pEmail, string pPassword) { ParamStruct[] vParam = new ParamStruct[2]; vParam[0].ParamName = "@Email"; vParam[0].DataType = DbType.String; vParam[0].value = pEmail; vParam[1].ParamName = "@Password"; vParam[1].DataType = DbType.String; vParam[1].value = pPassword; _ConfigurationManager.ExecSql("sp_Save_RMUser", vParam); }
public void ExecSql(string pSql, ParamStruct[] pParameterArray) { SqlConnection pCon = new SqlConnection(_glCadenaConexion); SqlCommand pCmd = new SqlCommand(pSql, pCon); pCmd.CommandType = CommandType.StoredProcedure; if (pParameterArray != null) { for (int i = 0; i < pParameterArray.Length; i++) { ParamStruct vPs = pParameterArray[i]; IDbDataParameter vPm = GetParameter(vPs.ParamName, vPs.direction, vPs.value, vPs.DataType, vPs.sourceColumn, vPs.size); pCmd.Parameters.Add(vPm); } } pCon.Open(); pCmd.ExecuteNonQuery(); pCon.Close(); }