public bool Update(SupplierInformationInfo supplierInformationInfo)
{
const string SQL = "UPDATE Information SET [Number]=@Number,[Path]=@Path,[UploadDate]=@UploadDate,[OverdueDate]=@OverdueDate,[Type]=@Type,[ExtensionName]=@ExtensionName,[FilialeID]=@FilialeID WHERE ID=@ID ;";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new
{
ID = supplierInformationInfo.ID,
Number = supplierInformationInfo.Number,
Path = supplierInformationInfo.Path,
UploadDate = supplierInformationInfo.UploadDate,
OverdueDate = supplierInformationInfo.OverdueDate,
Type = supplierInformationInfo.Type,
ExtensionName = supplierInformationInfo.ExtensionName,
FilialeID = supplierInformationInfo.FilialeID,
}) > 0);
}
}
public bool Insert(SupplierInformationInfo supplierInformationInfo)
{
const string SQL = "INSERT INTO Information ([ID],[IdentifyID],[QualificationType],[Number],[Path],[UploadDate],[OverdueDate],[Type],[ExtensionName],[FilialeID]) VALUES (@ID,@IdentifyID,@QualificationType,@Number,@Path,@UploadDate,@OverdueDate,@Type,@ExtensionName,@FilialeID);";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new {
ID = supplierInformationInfo.ID,
IdentifyID = supplierInformationInfo.IdentifyId,
QualificationType = supplierInformationInfo.QualificationType,
Number = supplierInformationInfo.Number,
Path = supplierInformationInfo.Path,
UploadDate = supplierInformationInfo.UploadDate,
OverdueDate = supplierInformationInfo.OverdueDate,
Type = supplierInformationInfo.Type,
ExtensionName = supplierInformationInfo.ExtensionName,
FilialeID = supplierInformationInfo.FilialeID,
}) > 0);
}
}
