public static DataSet Export(IQuotationFile QuotationFile) { SqlParameter[] _parameters = { new SqlParameter("@CustomerCode", QuotationFile.CustomerCode) , new SqlParameter("@ForecastDate", QuotationFile.ForecastDate) , new SqlParameter("@SysCreator", QuotationFile.SysCreator) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_Quotations_GetTemplate", _parameters)); }
public static Int32 Import(IQuotationFile QuotationFile) { SqlParameter[] _parameters = { new SqlParameter("@Name", QuotationFile.Name) , new SqlParameter("@ContentType", QuotationFile.ContentType) , new SqlParameter("@Data", QuotationFile.Data) , new SqlParameter("@Xml", QuotationFile.Xml) , new SqlParameter("@SysCreator", QuotationFile.SysCreator) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, "sp_QuotationFiles_Import", _parameters))); }
public static Int32 Insert(IQuotationFile QuotationFile) { SqlParameter[] _parameters = { new SqlParameter("@CustomerCode", QuotationFile.CustomerCode) , new SqlParameter("@ForecastDate", QuotationFile.ForecastDate) , new SqlParameter("@Name", QuotationFile.Name) , new SqlParameter("@ContentType", QuotationFile.ContentType) , new SqlParameter("@Data", QuotationFile.Data) , new SqlParameter("@SysCreator", QuotationFile.SysCreator) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, "sp_QuotationFiles_Insert", _parameters))); }