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