private SqlCommand GetInsertCommand(String PCommandText, List <JkFormParameter> PParams) { SqlCommand Command = new SqlCommand(); SqlDataAdapter Adapter = new SqlDataAdapter(PCommandText, VConnectionString); SqlCommandBuilder CommandBuilder = new SqlCommandBuilder(); if (PParams != null) { for (int i = 0; i <= PParams.Count - 1; i++) { if (String.IsNullOrWhiteSpace(PParams[i].Value)) { Adapter.SelectCommand.Parameters.AddWithValue("@" + PParams[i].Name, 0); } else { Adapter.SelectCommand.Parameters.AddWithValue("@" + PParams[i].Name, IAppHandler.ConvertMaskValue(PParams[i].Value)); } } } CommandBuilder.DataAdapter = Adapter; Command = CommandBuilder.GetInsertCommand(); return(Command); }
public DataTable LoadData(String PCommandText, List <JkFormParameter> PParamList, String CustomConnectionString = null) { DataTable PDataTable = new DataTable(); SqlDataAdapter DataAdapter = new SqlDataAdapter(PCommandText, CustomConnectionString ?? VConnectionString); String TableName = ExtractTableName(PCommandText); try { try { if (PParamList != null) { for (int i = 0; i <= PParamList.Count - 1; i++) { if (String.IsNullOrWhiteSpace(PParamList[i].Value)) { DataAdapter.SelectCommand.Parameters.AddWithValue("@" + PParamList[i].Name, 0); } else { DataAdapter.SelectCommand.Parameters.AddWithValue("@" + PParamList[i].Name, IAppHandler.ConvertMaskValue(PParamList[i].Value)); } } } DataAdapter.FillSchema(VDataset, SchemaType.Source, TableName); DataAdapter.Fill(VDataset, TableName); PDataTable = VDataset.Tables[TableName]; } catch (Exception err) { IMessageHandler.ShowError(ISystemMessages.LoadDataError + err.Message); } } finally { DataAdapter.SelectCommand.Connection.Close(); DataAdapter.Dispose(); } return(PDataTable); }