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)));
}
